shahdadi-9ptm8Ysol price vs. transactions and transfers
    Updated 2022-06-30
    with a as (select
    date_trunc('day',hour) as date,
    avg(price) sol_price
    from ethereum.core.fact_hourly_token_prices
    where token_address = lower('0xD31a59c85aE9D8edEFeC411D448f90841571b89c') and date>= '2022-01-01'
    group by date
    ), b as(
    select
    date_trunc('day',block_timestamp) as date,
    count(tx_id) txn
    from solana.core.fact_transactions
    where date>= '2022-01-01'
    group by date
    ),c as(
    select
    date_trunc('day',block_timestamp) as date,
    count(tx_id) sol_transfer
    from solana.core.fact_transfers
    where date>= '2022-01-01' and mint = 'So11111111111111111111111111111111111111112'
    group by date
    )
    select sol_price,txn,sol_transfer,a.date
    from a join b on a.date=b.date
    join c on a.date=c.date
    Run a query to Download Data