BitqueryBitqueryData Store
DogecoinBlocksTransactionsTransfersUTXO

Dogecoin

The full Dogecoin ledger since December 2013: blocks, transactions, inputs and outputs with DOGE, koinu and USD values at block time.

Coverage
Full historyto Sep 24, 2026 · yesterday
Tables
4Parquet, one prefix each
Columns
74across 4 tables
Coverage ends yesterday, UTC

Overview

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.

Use cases

  • UTXO graph analysis and address clustering
  • Coin-age and dormancy studies from spend links
  • Fee market and block-space research on a one-minute chain
  • Fund-flow tracing across transactions

4 tables

74 columns · free sample for each table

blocks

14 columns

One row per block: size, weight, difficulty, chainwork and transaction count.

dogecoin/blocks<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

transactions

25 columns

One 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 range
Browse columns Sample fileSample updated Sep 25, 2026

inputs

17 columns

One 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 range
Browse columns Sample fileSample updated Sep 25, 2026

outputs

18 columns

One row per transaction output with address, script type, change heuristic and value.

dogecoin/outputs<start_block>_<end_block>.parquetone file per block range
Browse columns Sample fileSample updated Sep 25, 2026

Schema reference

copies a column name
74 columns
blocks14 columnsOne row per block: size, weight, difficulty, chainwork and transaction count.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
median_timeUInt64Median time past of the block (epoch seconds)
nonceUInt64Block nonce
difficultyFloat64Mining difficulty
hashStringBlock hash
strippedsizeUInt64Block size without witness data, bytes
sizeUInt64Size in bytes
weightUInt64Block or transaction weight units
versionUInt64Version field
txcountUInt64Transactions in the block
chainworkStringCumulative chain work, hex
Sample file
transactions25 columnsOne row per transaction with input, output, fee and mined values in DOGE, koinu and USD.
ColumnTypeDescription
tx4
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
tx_hashStringTransaction hash
tx_indexInt64Position of the transaction in the block
blockchain1
blockchain_idInt64Internal chain id
Other6
blockUInt64Block height
locktimeUInt64Transaction locktime
versionInt64Version field
sizeUInt64Size in bytes
vsizeUInt64Virtual size in vbytes
weightUInt64Block or transaction weight units
is1
is_coinbaseInt641 for the coinbase transaction
input4
input_countInt64Number of inputs
input_value_decimalFloat64Total input value in DOGE
input_valueInt64Total input value in koinu
input_value_in_usdFloat64Total input value in USD at block time
output4
output_countInt64Number of outputs
output_value_decimalFloat64Total output value in DOGE
output_valueInt64Total output value in koinu
output_value_in_usdFloat64Total output value in USD at block time
fee3
fee_value_decimalFloat64Fee in DOGE
fee_valueInt64Fee in koinu
fee_value_in_usdFloat64Fee in USD at block time
mined2
mined_value_decimalFloat64Newly mined DOGE (coinbase only)
mined_valueInt64Newly mined koinu (coinbase only)
Sample file
inputs17 columnsOne row per transaction input, referencing the output it spends, with address, script type and value.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
tx_hashStringTransaction hash
transaction_indexInt64Position of the transaction in the block
input_indexInt64Index of the input in the transaction
output_tx_hashStringHash of the transaction that created the spent output; empty for coinbase
output_indexInt64Index of the output in the transaction
input_addressStringAddress spending the input; empty for coinbase
input_address_annotationNullable(String)Entity label for the address, when known
input_scriptStringInput script: hex witness or scriptSig
input_script_typeStringInput script type, e.g. txinwitness, scriptSig, coinbase
script_templateInt64Script template id
value_decimalFloat64Value in DOGE; a coinbase input carries the newly mined amount
value_in_usdFloat64Value in USD at block time
valueInt64Value in koinu; a coinbase input carries the newly mined amount
Sample file
outputs18 columnsOne row per transaction output with address, script type, change heuristic and value.
ColumnTypeDescription
tx_dateUInt64Block date, UTC midnight (epoch ms)
tx_timeUInt64Block timestamp (epoch seconds)
blockchain_idInt64Internal chain id
blockUInt64Block height
dateStringBlock date, YYYY-MM-DD
tx_hashStringTransaction hash
transaction_indexInt64Position of the transaction in the block
output_indexInt64Index of the output in the transaction
output_addressStringAddress receiving the output
output_address_annotationNullable(String)Entity label for the address, when known
directionStringChange heuristic: change, not_change, likely_change, likely_not_change, mining, fee, unknown
output_scriptStringOutput script as opcodes and hex
script_typeStringOutput script type, e.g. pubkeyhash, scripthash, witness_v0_keyhash, nulldata
script_templateInt64Script template id
req_sigsInt64Signatures required to spend
value_decimalFloat64Value in DOGE; a coinbase input carries the newly mined amount
value_in_usdFloat64Value in USD at block time
valueInt64Value in koinu; a coinbase input carries the newly mined amount
Sample file

Ask an AI about this data

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.

Start with

Opens a new chat with the question filled in. Nothing about you is sent to Bitquery, and the assistant sees only the public brief.

Delivery

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
  1. Download a free sampleNo email needed.
  2. Pay nowName, work email and licence check.
  3. Pay the invoiceBy card or bank transfer.
  4. Get signed linksThe team prepares the export and emails the links.

Price

Full history
Genesis → Sep 24, 2026
$8,000one-time, USD
  • All 4 tables, 74 columns
  • Parquet files in the layout under Delivery
  • Signed download links by email
  • Licensed under the Data License
Pay now

FAQ

7 questions
What is included in Dogecoin?

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.

How are merge-mined blocks handled?

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.

How is the data delivered?

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.

How do I trace where coins went?

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.

How do I load it?

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.

How current is the data?

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.

Can I try before I buy?

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.