flipside

    Swap from STBL to USDC
    mo115Swap from STBL to USDC
    Updated 2022-05-19
    select date_trunc('day',block_timestamp) as date ,SWAP_PROGRAM, sum(SWAP_FROM_AMOUNT) as STBL_amount,ASSET_NAME, sum(SWAP_TO_AMOUNT)
    from flipside_prod_db.algorand.swaps left join flipside_prod_db.algorand.asset on ASSET_ID=SWAP_TO_ASSET_ID
    WHERE (BLOCK_TIMESTAMP>='2022-05-08' and BLOCK_TIMESTAMP<='2022-05-14')
    and SWAP_FROM_ASSET_ID =
    '465865291'
    and asset_name = 'USDC'
    group by 1,2,4
    Run a query to Download Data