Open Site Navigation
Explore the structure of the whole Terra ecosystem and understand how Flipside’s data is organized to account for every smart contract.

Terra Data Cheat Codes

Terra Chain Operation

About

  • LUNA is the native staking token for Terra

  • Terra also includes native Stablecoins pegged against numerous global currencies

◼️

Basic Transfers & Transactions

  • For native tokens

terra.transfers

◼️

  • For other tokens and related transactions

terra.msgs
terra.msg_events

Delegated Proof of Stake Details

  • Terra is secured by Delegated Proof of Stake validation whereby Delegators stake LUNA to Validators, and earn rewards across all native Terra currencies

  • Ex: Daily Reward Summary

terra.staking and terra.rewards
Applications

Contracts, Messaging, & Events

  • Terra’s app/smart contract development system is called Wasm.

  • Message payloads emitted by those contracts

terra.msgs
terra.msg_events

Example Applications

terra.msgs
terra.msg_events

◼️

  • Mirror is a yield platform that allows users to mint/burn/purchase synthetic assets and stake liquidity tokens to earn income

  • Ex: Liquidity Events on MIR/UST Pool

terra.msgs
terra.msg_events

◼️

  • Anchor is a lending ecosystem where users can borrow UST and supply bLUNA tokens to earn ANC as interest

  • Ex: Latest Borrows on Anchor

terra.msgs
terra.msg_events
Governance

Proposal Submission & Voting

  • Users can submit proposals by depositing 512 LUNA to their address

  • Ex: Latest Proposal

terra.gov_submit_proposal

◼️

terra.gov_vote

Voting Power

terra.validator_voting_power
Swaps & Exchanges

Native Swapping

terra.swaps

Terra Swapping

terra.msgs
terra.msg_events
Core Functionality

Terra Transaction Fees

 terra.transactions

Historical Balances

terra.daily_balances

◼️

terra.msgs
terra.msg_events

Prices

terra.oracle_prices

Know which table to use for which function.

Copy/paste its name, i.e. “ “terra.daily_balances” right into your query.

Click the links to view example queries

Click on the three dots next to the graph or table to view the SQL code behind it. 

Pre-built queries to unlock supreme analysis

Create an account in Velocity to get started!