flipside

    Getting Started
    peterakoGetting Started
    Updated 2024-01-22
    solana.core.fact_transactionsaxelar.core.fact_daily_balancesaptos.core.fact_transactions_block_metadataosmosis.gov.fact_staking_rewards-- Get started with Flipside by running your first query:
    -- the SQL statement below will get you a list of NFT
    -- platforms on Ethereum, ranked by how many sales
    -- they've had in the past month.

    -- Be sure to see our documentation for more guidance,
    -- including a full walkthrough of the app:
    -- https://docs.flipsidecrypto.com/our-app/getting-started

    with
    figment_validators as (
    select *
    from axelar.gov.fact_staking_rewards
    where validator_address = 'axelarvaloper1uvx854yjzn9re8vu74067u68r4ar70tywgpcwg'
    and to_date(block_timestamp) = current_date
    )

    select
    a.validator_address
    ,a.delegator_address
    ,a.amount
    ,b.balance
    ,a.block_timestamp
    ,b.date
    from figment_validators a
    join axelar.core.fact_daily_balances b
    on a.delegator_address = b.address
    and b.date = to_date(a.block_timestamp);

    Select DISTINCT(action) from sei.gov.fact_staking_rewards;

    select * from solana.core.fact_transfers limit 10;
    QueryRunArchived: QueryRun has been archived