NavidCopy of Copy of Untitled Query
    Updated 2022-11-15
    with trades as (
    select
    'Near' as type,
    sum(deposit/1e24) as amt,
    count(distinct tx_hash) as trades_cnt,
    count(distinct tx_signer) as sellers_cnt,
    count(distinct tx_receiver) as buyers_cnt
    from
    near.core.fact_transfers
    where date(block_timestamp) = (select date(max(block_timestamp)) from near.core.fact_transfers)
    union all
    select
    'Solana' as type,
    sum(AMOUNT/1e24) as amt,
    count(distinct tx_id) as trades_cnt,
    count(distinct tx_from) as sellers_cnt,
    count(distinct tx_to) as buyers_cnt
    from
    solana.core.fact_transfers
    where date(block_timestamp) = (select date(max(block_timestamp)) from solana.core.fact_transfers)
    )
    select
    type,
    buyers_cnt/sellers_cnt as ratio
    from
    trades

    Run a query to Download Data