farid-c9j0VMTotal algo transfered
    Updated 2022-07-01
    with algo_transfer as (select date(block_timestamp) as dates,
    round(sum(amount),2) as totalALGO_transfered
    from flipside_prod_db.algorand.payment_transaction
    where date(block_timestamp) >= '2022-01-01'
    group by dates),

    b as (select
    block_hour::date as days,
    avg(price_usd) as algo_price
    from algorand.prices_swap
    where block_hour::date >= '2022-01-01'
    and hour(block_hour) = 0
    and asset_id = 0
    group by days)

    select *
    from algo_transfer
    left join b
    on algo_transfer.dates=b.days
    Run a query to Download Data