table sample | Dune

Query Editor

SQL Query

SELECT
    *
FROM {{table_schema}}.{{table_name}}
TABLESAMPLE BERNOULLI(100)
LIMIT 10

Query Results

block_time block_number value gas_limit gas_price gas_used max_fee_per_gas max_priority_fee_per_gas priority_fee_per_gas nonce index success from to block_hash data hash type access_list block_date blob_versioned_hashes max_fee_per_blob_gas authorization_list
2015-08-10 00:47:11 61151 5000000000000000000 90000 60088963456 21037 17 0 0xc8ebccc5f5689fa8659d83713341e5ad19349448 0xc7d3e431be6222543364408a94c12c0d089be305 0x667ea5086c17d749601b107cfe3b63fb53c19793180bf76c8c00e3a4ecc98cd6 0x 0x581c5bf5c13e3218e9b349039d7a06b301de69d4f9bf5d8053efe0f6d8d26004 Legacy 2015-08-10 00:00:00
2015-08-12 00:43:03 71693 9998796400000000000 21000 57314707872 21000 11 0 0x910a4aadabb3a7b3f7879118332e13da66b68d77 0x32be343b94f860124dc4fee278fdcbd38c102d88 0x3330e230ac9fc6fef008d9942bf377932c7bc1e57956204ae5645942c4ad4274 0x 0xe027b4c7189221a835e27af1371552188a0af37c38fc2956cd792953d51ef429 Legacy 2015-08-12 00:00:00
2015-08-17 06:18:46 99564 14998737680000000000 21000 60110574861 21000 15 0 0xdee4977f74e6aef6d627191c9a45d2627e331150 0x32be343b94f860124dc4fee278fdcbd38c102d88 0x73569d2a421971869864eaaf74ffcd22db330b76c7bca8f2f887ba63c72c177a 0x 0xccced835d3c2674090f3b36982e0e197637b5b9852e4bb63e0ea1d57586c5ff0 Legacy 2015-08-17 00:00:00
2015-08-12 02:27:57 72057 100000000000000000 90000 57935965411 21000 2 0 0x33fb577a4d214fe010d32cca7c3eeda63f87ceef 0xa64015e0870ff579f8827b39b538c1eda5ef25a0 0xf11c39014de6cdd6b81558be169de66689b4bb1ade53d7c830b1753e71aab820 0x 0xa717a1ad62e4b31f6f71a737adda7e99c07d75c7de354c35d49e19d6b17d8b46 Legacy 2015-08-12 00:00:00
2015-08-12 05:55:00 72841 6724720000000000000 21079 500000000000 21000 1 0 0x45e43898393e6b184c2aa9930d66fdec295b36b4 0xe2d2df4fa47ebdebde9f4fc0845ca35f8081fc59 0x85ebc0e86681b05586dee6c15ec337f932ece4ba0aebb1b04709feea8081dfec 0x 0xbd3dde249e843823908317bcaf7f5664ba75e476b15b393c92c284b67cdbc056 Legacy 2015-08-12 00:00:00
2015-08-17 06:36:31 99628 3600000000000000000 90000 55439040167 23967 1 0 0xb4f523106d96985a62306557ed1e19f129d42812 0xad8d3a5d2d92eb14bb56ca9f380be35b8efe0c04 0x5fb4d2117104e603c56eb260838f71af0eae52d10218c4dc63664a2d54290655 0xb214faa541414141414a4946440000000000000000000000000000000000000000000000 0x30990d98dc2c02198d10c3fbc93765561cf97ecc140efe7ac35c258811333d1b Legacy 2015-08-17 00:00:00
2015-08-17 07:04:26 99753 4998736160000000000 21000 60182620912 21000 72 0 0xb1abce2918e21ddb93aa452731a12672a3d9f75a 0x32be343b94f860124dc4fee278fdcbd38c102d88 0x8796e75f630391e976871ffce653fcca5633395daebeb3f290ec016707a4948e 0x 0x18c17c0b8bf8f452d021b79a7834b63c1858c65fefc88973494416274ba41d13 Legacy 2015-08-17 00:00:00
2015-08-19 04:28:58 109557 0 1000000 55776128476 177080 2 0 0x13f26856cbacaaba9c4488a31c72e605fae029fc 0x6d12128e1340207da39717518b6c990bed7b6deeb88b25c6d4f419293a6fcf42 0x 0x3aebfd751912b8fdb932a7a5b2e11f0fe5afd41d5c7b5ccb3341b047716d6ed0 Legacy 2015-08-19 00:00:00
2015-08-12 09:25:34 73589 990000000000000000 21000 56720481427 21000 293 0 0x32be343b94f860124dc4fee278fdcbd38c102d88 0x932b45e862c96e06ccbd1dd61b3045d41cc5eb53 0x957966abdb6ad9f46c421f47f2a5c102d0ea87814527df4e195ec5308d734af1 0x 0x9e7769f855a1db6cf56f922a60c56a860f6c1076c4000545c5be3f84564e1310 Legacy 2015-08-12 00:00:00
2015-08-12 11:09:06 73938 7993828730000000000 21000 56320772209 21000 1 0 0x19ae27e1b61445eb9f27821a5eb4b3e957319e7e 0x32be343b94f860124dc4fee278fdcbd38c102d88 0xf8b08ae6a7efcb1876850142d0e7ab2801092dc94667428f30ad214769b950df 0x 0xa4db4bc2cbd0bec76161bc50a77e7049ef9c43cf4dc4a8766059465fb5b0346a Legacy 2015-08-12 00:00:00