RamaharTransactions Volume
    Updated 2022-12-19
    With table_1 as (select
    'FLOW' as chains,
    proposer as users,
    count (distinct tx_id) as transactions
    from flow.core.fact_transactions
    where block_timestamp::date >= CURRENT_DATE - 30
    group by 1,2

    union ALL

    select
    'Ethereum' as chains,
    from_address as users,
    count (distinct tx_hash) as transactions
    from ethereum.core.fact_transactions
    where block_timestamp::date >= CURRENT_DATE - 30
    group by 1,2

    union ALL

    select
    'Solana' as chains,
    signers[0] as users,
    count (distinct tx_id) as transactions
    from solana.core.fact_transactions
    where block_timestamp::date >= CURRENT_DATE - 30
    group by 1,2

    union ALL

    select
    'Avalanche' as chains,
    from_address as users,
    count (distinct tx_hash) as transactions
    from avalanche.core.fact_transactions
    where block_timestamp::date >= CURRENT_DATE - 30
    Run a query to Download Data