strawbettyvolume of buyer and sellers of goETH
    Updated 2022-05-21
    with goETH_buys as (
    select
    date_trunc('day', block_timestamp) as date,
    swap_program,
    sum(swap_to_amount) as total_goeth_buy_volume,
    count(DISTINCT(swapper)) as n_goeth_buyers
    from flipside_prod_db.algorand.swaps
    where swap_to_asset_id = '386195940' -- swapped to goETH
    and date >= '2022-04-01'
    group by date, swap_program
    ), goETH_sells as (
    select
    date_trunc('day', block_timestamp) as date,
    swap_program,
    sum(swap_from_amount) as total_goeth_sell_volume,
    count(DISTINCT(swapper)) as n_goeth_sellers
    from flipside_prod_db.algorand.swaps
    where swap_from_asset_id = '386195940'
    and date >= '2022-04-01'
    group by date, swap_program
    )

    select b.date, total_goeth_buy_volume, total_goeth_sell_volume,n_goeth_buyers,n_goeth_sellers,
    n_goeth_buyers+n_goeth_sellers as wallets
    from goETH_buys as b left join goETH_sells as s on b.date=s.date
    Run a query to Download Data