maybeyonasalgo_octo_sale_vol_daily
    Updated 2022-05-26
    with
    sale_txs as (
    select
    tx_group_id,
    case when receiver = 'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' then 'Gen 2' else 'Gen 1' end as type
    from algorand.payment_transaction
    where receiver in (
    'X5YPUJ2HTFBY66WKWZOAA75WST5V7HWAGS2346SQFK622VNIRQ5ASXHTGA', -- Gen 1
    'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' -- Gen 2
    )
    and tx_group_id is not null
    ),
    sale_data as (
    select
    block_timestamp,
    s.tx_group_id,
    type,
    sum(amount) as algo_paid
    from algorand.payment_transaction p join sale_txs s on p.tx_group_id=s.tx_group_id
    group by 1,2,3
    )

    select
    date(block_timestamp) as date,
    type,
    count(tx_group_id) as sales,
    sum(algo_paid) as algo_vol
    from sale_data
    group by 1,2
    limit 100
    Run a query to Download Data