shahdadi-9ptm8Yalgo price vs. transaction and transfers
    Updated 2022-06-30
    WITH A AS(select
    date_trunc('day',block_hour) as date,
    avg(price_usd) algo_price
    from flipside_prod_db.algorand.prices_swap
    where asset_id = 0 and date>= '2022-01-01'
    group by date
    ),b as(
    select
    date_trunc('day',block_timestamp) as date,
    count(TX_ID) as txn
    from flipside_prod_db.algorand.transactions
    where date>= '2022-01-01'
    group by date
    ),c as(
    select
    date_trunc('day',block_timestamp) as date,
    count(TX_ID) as transfer
    from flipside_prod_db.algorand.transfers
    where date>= '2022-01-01' and asset_id = 0
    group by date
    )
    select algo_price,txn,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