Baselight

Bitcoin Blockchain Data

Bitcoin Historical Dataset 9-May-2021, contains all information for each blocks

@kaggle.jventrone_bitcoin_blockchain_data

Data Update 2021–05–08
@kaggle.jventrone_bitcoin_blockchain_data.data_update_2021_05_08

  • 126.34 MB
  • 682676 rows
  • 19 columns
unnamed_0

Unnamed: 0

hash

Hash

confirmations

Confirmations

timestamp

Timestamp

height

Height

number_of_transactions

Number Of Transactions

difficulty

Difficulty

merkle_root

Merkle Root

version

Version

bits

Bits

weight

Weight

size

Size

nonce

Nonce

transaction_volume

Transaction Volume

block_reward

Block Reward

fee_reward

Fee Reward

miner_name

Miner Name

url_miner

URL Miner

n_0

0

00000000000000000001da49981856df74f84c46da231984603bb513a6370b341Sun May 09 2021 03:01:00 GMT+0000 (Coordinated Universal Time)682676194520608845737768.16d393294a4577f92a0c6b027948bae63138d6acd657d1424dfb550af4c43b06990x3fff00003867710433,999,550 WU1,523,698 bytes29255543236956.53517309 BTC6.25000000 BTC0.65500240 BTCPoolin/btc/address/17HzvxMhoke5K3oavLzPGkLy4zd35KjWEb
00000000000000000001e888b808b8f337f36e1fa28e2c4ffb8f4259118e68cf1Sun May 09 2021 02:40:00 GMT+0000 (Coordinated Universal Time)682675201020608845737768.1691641c10f45dc08bb437f99f7c6dfd8117bf820b321ef3e6adad2ba598a35d9c0x37ffe0043867710433,993,252 WU1,281,744 bytes24914507617870.61409089 BTC6.25000000 BTC0.74946810 BTCAntPool/btc/address/12dRugNcdxK39288NjcDV4GX7rMsKCGn6B
10000000000000000000b056f6fc7d074eed8a3b11a21db75b50f1b85668234791Sun May 09 2021 02:19:00 GMT+0000 (Coordinated Universal Time)68267411220608845737768.16ff9266b8eda52b2326ba30848e470a732463aa856e86c063d0906f061d9cdd480x200040003867710433,993,026 WU1,042,718 bytes1747276293299.78126644 BTC6.25000000 BTC0.06751435 BTCUnknown/btc/address/35y82tEPDa2wm6tzkEacMG8GPPW7zbMj83
2000000000000000000092b15e61d2d8de335b77e1575c96d269914cc5d8d384d2Sun May 09 2021 02:19:00 GMT+0000 (Coordinated Universal Time)68267311220608845737768.1604a80cbaffc463e26ccb6a0696c67f0be60e4736e67dd7de337f61d3a44c299d0x200000003867710433,993,008 WU1,060,403 bytes4174040095457.30745450 BTC6.25000000 BTC0.06265385 BTCUnknown/btc/address/35y82tEPDa2wm6tzkEacMG8GPPW7zbMj83
3000000000000000000034261ef486c4fb78e4e967c98747d85e4d9cb93f1fb563Sun May 09 2021 02:18:00 GMT+0000 (Coordinated Universal Time)68267239820608845737768.160c3955cf4e2caee926f89799ee7adda005bb2f6b9ab161d73c6aaf970846fa9f0x20c000043867710433,998,374 WU1,115,599 bytes42629670911388.16878694 BTC6.25000000 BTC0.15195586 BTCF2Pool/btc/address/1KFHE7w8BhaENAswwryaoccDb6qcT6DbYY
400000000000000000005483afaf4687227df7a894bf9a6418f6f4ced01dcc8734Sun May 09 2021 02:15:00 GMT+0000 (Coordinated Universal Time)6826713620608845737768.16ba153585006679ca99c5bd5f95e5b18b295d35717962cf5e1a4cc979456c85560x200000043867710433,999,528 WU1,012,467 bytes1515620989163.90176908 BTC6.25000000 BTC0.04552627 BTCPoolin/btc/address/191sNkKTG8pzUsNgZYKo7DH2odg39XDAGo
50000000000000000000367631ec3e2191cc92b93b9116401caec9557b93b20b95Sun May 09 2021 02:15:00 GMT+0000 (Coordinated Universal Time)68267034120608845737768.16552b05ff567b80e527f075dc21832568108d34c4f324af159bf9d25fbad9d78a0x37ffe0043867710433,998,499 WU1,093,335 bytes22473891991637.51045939 BTC6.25000000 BTC0.11890336 BTCF2Pool/btc/address/1KFHE7w8BhaENAswwryaoccDb6qcT6DbYY
6000000000000000000062632cfc161fff8c51d3b53f5b23c50f524ea465f6a1c6Sun May 09 2021 02:13:00 GMT+0000 (Coordinated Universal Time)682669100720608845737768.1657cab70d2173cdfb73f377da22c6e519cdaa802141726cb603f96190c233a0af0x208000003867710433,993,189 WU1,183,998 bytes38442233103780.23729806 BTC6.25000000 BTC0.31958254 BTCUnknown/btc/address/1Bf9sZvBHPFGVPX71WX2njhd1NXKv5y7v5
70000000000000000000951abdf6f2d523d0b9c0663ebc865920bd55d4efd7f107Sun May 09 2021 02:05:00 GMT+0000 (Coordinated Universal Time)68266889420608845737768.165ff2eccc9b8e8f8412d4d2621ed0ee691fd495aabfa68ef560a48f51641db5c80x200000043867710433,993,566 WU1,409,276 bytes819423812343.75998371 BTC6.25000000 BTC0.19606282 BTCAntPool/btc/address/12dRugNcdxK39288NjcDV4GX7rMsKCGn6B
80000000000000000000aefb3e2d031c08753085bda73e976c46fac7c9d052f698Sun May 09 2021 02:05:00 GMT+0000 (Coordinated Universal Time)682667119620608845737768.16efd109619177dd0072186f344b5f8a7243be4d48fd4ee48da61f113dd6ab68bb0x2000e0003867710433,993,584 WU1,146,893 bytes16158938866189.95416049 BTC6.25000000 BTC0.93577221 BTCViaBTC/btc/address/18cBEMRxXHqzWWCxZNtU91F5sbUNKhL5PX

CREATE TABLE data_update_2021_05_08 (
  "unnamed_0" BIGINT,
  "hash" VARCHAR,
  "confirmations" BIGINT,
  "timestamp" TIMESTAMP,
  "height" BIGINT,
  "number_of_transactions" DOUBLE,
  "difficulty" DOUBLE,
  "merkle_root" VARCHAR,
  "version" VARCHAR,
  "bits" BIGINT,
  "weight" VARCHAR,
  "size" VARCHAR,
  "nonce" BIGINT,
  "transaction_volume" VARCHAR,
  "block_reward" VARCHAR,
  "fee_reward" VARCHAR,
  "miner_name" VARCHAR,
  "url_miner" VARCHAR,
  "n_0" VARCHAR
);

Share link

Anyone who has the link will be able to view this.