strawbettyassets goETH swap for
    Updated 2022-05-21
    with goeth_to as (
    select case when swap_to_asset_id = 0
    then 'ALGO' else asset_name
    end as swap_for,
    sum(swap_from_amount) as sell_go_eth,
    count(distinct swapper) as number_of_wallets,
    count(distinct tx_group_id) as number_of_sale
    from flipside_prod_db.algorand.swaps s
    left join flipside_prod_db.algorand.asset a on s.swap_to_asset_id = a.asset_id
    where swap_from_asset_id = '386195940'
    and block_timestamp::date >= '2022-04-01'
    group by 1
    order by 2 desc
    )

    select * from goeth_to
    Run a query to Download Data