MLDZMNsolana1
    Updated 2023-04-29
    with tb1 as (select
    RECORDED_HOUR::date as day,
    avg(close) as price_token
    from solana.core.fact_token_prices_hourly where SYMBOL='SOL'
    group by 1),

    deposit as (select
    count(distinct tx_id) as no_txn,
    count(distinct TX_FROM) as no_users,
    sum(amount) as deposit,
    sum(amount*price_token) as deposit_usd,
    avg(amount) as average_depsoit,
    no_users/count(distinct date_trunc(day, block_timestamp)) as average_user_day

    from solana.core.fact_transfers s
    left join tb1 a on s.BLOCK_TIMESTAMP::date=a.day
    where TX_TO='RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx'
    and mint='So11111111111111111111111111111111111111112'
    ),


    withdraw as (select
    count(distinct tx_id) as no_txn1,
    count(distinct TX_TO) as no_users1,
    sum(amount) as withdraw,
    sum(amount*price_token) as withdraw_usd,
    avg(amount) as average_withdraw

    from solana.core.fact_transfers s
    left join tb1 a on s.BLOCK_TIMESTAMP::date=a.day
    where TX_FROM='RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx'
    and mint='So11111111111111111111111111111111111111112'
    )



    Run a query to Download Data