flipside

    Buy The Deep!
    freemartianBuy The Deep!
    Updated 2022-05-18
    select sum(swap_from_amount) as algo_volume, count(distinct swapper) as wallet_count, count (swap_from_amount) as swap_count, swap_program, date_trunc('day', block_timestamp) as TIME
    from flipside_prod_db.algorand.swaps
    where block_timestamp >= '2022-05-01' and block_timestamp <= '2022-05-17'
    and swap_from_asset_id = 0
    group by swap_program, TIME
    Run a query to Download Data