LUNA
Transactions CSV for the Terra blockchain (99%+ coverage by volume)

CSV transactions with full details

General
  • airdrop
  • swap
  • staking reward occurrence for LUNA stakers
    • withdraw reward
    • delegate with reward
    • redelegate with reward
  • transfer
  • vote
Anchor Protocol
  • Anchor Earn interest
    • appears alongside any Anchor Earn deposit/withdraw
    • appears with comment anchor_earn_interest
  • Anchor Earn deposit/withdraw
  • Anchor Borrow deposit/withdraw/borrow/repay
  • Anchor Bond bond-luna/unbond-luna/claim-reward
  • ANC stake/unstake
Mirror Protocol
  • Mirror LP deposit/withdraw/stake/unstake/claim-reward
  • Mirror long-farm/short-farm/borrow/repay
  • MIR stake/unstake
RandomEarth NFTs
  • add whitelist
  • mint
  • buy
  • offer to sell
  • withdraw proceeds
  • "sell" is NOT included: user must manually import (deduce from _NFT_WITHDRAW_PROCEEDS and _NFT_OFFER_SELL transactions)

CSV transactions with missing details (TX_TYPE=_UNKNOWN)

  • bond/unbond non-LUNA tokens
  • all other transactions not listed

Limits

  • 5000 most recent transactions

Notes

CSV includes details on 99%+ of Terra blockchain transactions by volume.

Incoming transfers of non-native tokens like MIR are not included in the CSV.
  • I have been unable to find a solution to this specific problem.

Change Log

10/25/21
  • Added handling of NFT whitelist and NFT mint
10/22/21
  • Fixed multi-airdrops-within-one-contract bug (would only detect 1st airdrop)
10/4/21
  • Changed borrow/repay to be exported transactions into non-default CSVs (i.e. included into koinly CSV, cointracking CSV, etc).
10/2/21
  • Fix for col5 encoding differences (execute_msg; airdrops MIR/ANC/MINE)
  • Fix for col5 encoding differences (currency address lookup; stake ANC)
  • Fix for col5 new LP stake case (MINE-UST LP)
10/1/21
  • Migrated to new data source (lcd to fcd) due to deprecation of lcd data source.
  • New unresolvable issues:
    • older anchor earn deposits/withdrawals are treated as _UNKNOWN due to inability to retrieve aUST amounts. Users advised to look at https://finder.terra.money/ for these transactions.
9/10/21
  • Migrated underlying API to different private node provider
  • Changed tx limit from 10000 to 5000, on a trial basis (will try to increase later)
8/30/21
  • Added comment to _GOV_UNSTAKE transactions: must calculate governance staking rewards manually (deposit/withdrawal amounts shown to guide).
8/29/21
  • Fixed no fees for receive transfers
8/25/21
  • Changed treatment of anchor earn deposits/withdrawals
    • old method: anchor earn interest transaction
    • new method: treat as trade between UST/aUST
8/21/21
  • Increased tx limit from 5000 to 10000
8/18/21
  • Bug fix: fixed bug introduced by 8/17 migration: handling of failed transactions (fixed to ignore instead of labeling as _UNKNOWN)
8/17/21
  • Migrated dependency from deprecated Terra API to new Terra API
  • Bug fix: Fixed _WITHDRAW_COLLATERAL transaction that was mislabeled as staking income for aUST.
Last modified 18h ago