MLDZMNzetacapital
    Updated 2023-04-01
    with t1 as (select
    *
    from solana.core.fact_events
    where SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP >='2023-01-01'
    and PROGRAM_ID in ('ZETAxsqBRek56DhiGXrn75yj2NHU3aYUnxvHXpkf3aD')
    ),

    t2 as (select
    *
    from solana.core.fact_events
    where SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP >= '2023-01-01'
    and PROGRAM_ID in ('dammHkt7jmytvbS3nHTxQNEcP59aE57nxwV21YdqEDNm','dRiftyHA39MWEi3m9aunc5MzRF1JYuBsbn6VPcn33UH')
    ),

    t3 as (select
    RECORDED_HOUR::date as day,
    SYMBOL,
    avg(close) as price_token
    from solana.core.ez_token_prices_hourly
    group by 1,2

    )

    select
    block_timestamp::date as date,
    l.SYMBOL,
    count(distinct t.TX_FROM) as sender,
    count(distinct tx_id) as no_txn,
    sum(AMOUNT*price_token) as volume_usd,
    avg(AMOUNT*price_token) as avg_usd,
    median(AMOUNT*price_token) as median_usd
    from solana.core.fact_transfers t join solana.core.dim_tokens l on t.mint = l.TOKEN_ADDRESS
    left join t3 a on l.SYMBOL=a.SYMBOL and t.block_timestamp::date=a.day
    where t.block_timestamp>= '2023-01-01'
    Run a query to Download Data