c2ctraderNumber of Mints and Burns of Tinyman Pools (alternative code)
    Updated 2022-06-09
    select asset_id ,price_usd from algorand.prices_swap
    where
    asset_id in (
    select asset_id from
    (
    select asset_id,max(block_hour) from algorand.prices_swap group by asset_id
    )
    )




    -- --determine pool_name and pool_address from labels table
    -- WITH pool as (
    -- select address pool_address, address_name pool_name from flipside_prod_db.algorand.labels
    -- where label = 'tinyman'
    -- ),
    -- asset_info as (
    -- select creator_address, asset_id lp_id, asset_name
    -- from flipside_prod_db.algorand.asset where creator_address in (SELECT pool_address from pool)
    -- ),
    -- asset_price as (
    -- select asset_id ,price_usd from algorand.prices_swap s join asset_info i on s.asset_id=i.lp_id
    -- where block_hour >=CURRENT_DATE
    -- ),
    -- burn_info as (
    -- SELECT
    -- case
    -- when asset_sender in (SELECT pool_address from pool) then asset_sender
    -- when tx_sender in (SELECT pool_address from pool) then tx_sender
    -- END as pool_address,
    -- asset_id, amount
    -- FROM flipside_prod_db.algorand.transfers t
    -- WHERE asset_sender in (SELECT pool_address from pool)
    -- or
    -- tx_sender in (SELECT pool_address from pool)
    Run a query to Download Data