nitsgoETH Buyer vs Seller
    Updated 2022-05-21
    with goETHseller as
    (SELECT date(block_timestamp) as day,count(DISTINCT swapper) as addr,sum(swap_from_amount) as total_amt,
    sum(total_amt) over (order by day) as cumulative_amt
    , sum(addr) over ( order by day) as cumulative_addr
    , 'goETH seller' as type from algorand.swaps
    where swap_from_asset_id = '386195940'
    GROUP by 1),
    goETHbuyer as
    (SELECT date(block_timestamp) as day, count(DISTINCT swapper) as addr,sum(swap_to_amount) as total_amt,
    sum(total_amt) over (order by day) as cumulative_amt
    , sum(addr) over ( order by day) as cumulative_addr
    ,'goETH buyer' as type from algorand.swaps
    where swap_to_asset_id = '386195940'
    GROUP by 1 )

    SELECT * from goETHbuyer
    UNION ALL
    SELECT * from goETHseller
    -- limit 100
    Run a query to Download Data