blocks
14 columnsOne row per block: size, weight, difficulty, chainwork and transaction count.
dogecoin/blocks<start_block>_<end_block>.parquetone file per block rangeThe full Dogecoin ledger since December 2013: blocks, transactions, inputs and outputs with DOGE, koinu and USD values at block time.
Every Dogecoin block, transaction, input and output from the genesis block in December 2013 to yesterday, with values in DOGE, koinu and USD at block time. Addresses and script types are decoded on every input and output, and each output carries a change heuristic.
Inputs carry the hash and index of the output they spend, so UTXO traversal and coin-age calculations are a single join rather than a replay. Blocks arrive about once a minute, so a day is around 1,400 blocks. Files are cut by block range and named by their first and last block, so any window can be assembled exactly.
One row per block: size, weight, difficulty, chainwork and transaction count.
dogecoin/blocks<start_block>_<end_block>.parquetone file per block rangeOne row per transaction with input, output, fee and mined values in DOGE, koinu and USD.
dogecoin/transactions<start_block>_<end_block>.parquetone file per block rangeOne row per transaction input, referencing the output it spends, with address, script type and value.
dogecoin/inputs<start_block>_<end_block>.parquetone file per block rangeOne row per transaction output with address, script type, change heuristic and value.
dogecoin/outputs<start_block>_<end_block>.parquetone file per block rangeblocks14 columnsOne row per block: size, weight, difficulty, chainwork and transaction count.transactions25 columnsOne row per transaction with input, output, fee and mined values in DOGE, koinu and USD.inputs17 columnsOne row per transaction input, referencing the output it spends, with address, script type and value.outputs18 columnsOne row per transaction output with address, script type, change heuristic and value.Send this dataset’s full schema to an assistant and ask it anything. It reads the plain-text brief first, so the answer comes from the real column list rather than a guess.
Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.
Parquet files, delivered as signed download links by email after payment, in this layout:
# blocks: one file per block range dogecoin/blocks<start_block>_<end_block>.parquet # transactions: one file per block range dogecoin/transactions<start_block>_<end_block>.parquet # inputs: one file per block range dogecoin/inputs<start_block>_<end_block>.parquet # outputs: one file per block range dogecoin/outputs<start_block>_<end_block>.parquet
Four Parquet tables: blocks, transactions, inputs and outputs, covering full history from the genesis block to yesterday. Every input and output carries its address, script type and value in DOGE, koinu and USD.
Dogecoin has been merge-mined with Litecoin since 2014. The blocks table records each block once with its own hash, and block size is the size Dogecoin nodes report, including the auxiliary proof-of-work header.
As flat Parquet files under a stable S3 layout, one prefix per table, files named by block range. Signed HTTPS links are emailed once the files are prepared.
Join inputs.output_tx_hash to outputs.tx_hash and inputs.output_index to outputs.output_index. Each input names the output it spends, so a spend chain is a repeated self-join rather than a node replay.
One DuckDB line reads a whole table: SELECT * FROM read_parquet('outputs/*.parquet'). Values come in DOGE, the smallest unit and USD at block time, so no decimal adjustment is needed.
A purchase covers full history from the genesis block to the day before the files are cut. Files are cut by block range, so any window can be assembled exactly.
Yes. Every table links to a public sample Parquet file with real records from one day, and the sample repository shows the first rows of each in the browser.
Every bonding-curve trade, token creation, migration and pool on Pump.fun, plus per-token OHLCV, decoded and USD-priced.
Every TRX, TRC-10 and TRC-20 transfer on TRON since June 2018, one row per transfer, valued in USD where a price exists.
Every native ETH and token transfer on Ethereum since August 2015, one row per transfer, valued in USD where a price exists.
Tell us the chain, tables and date range.