PapasotUSDC-USDT liquidity Tinyman LP
    Updated 2023-01-02
    -- USDC - USDT Tinyman LP creator account = I37JDCOJCK2JSPRMV5HHFHQ54YU6J6VWCBCDNULIT5ZJWO357R2DJLGIBM

    select
    date_trunc('day',block_timestamp) as block_day,
    sum(amount) as LP_liquidity,
    count(*) as transaction_count
    from algorand.transfers
    where receiver = 'I37JDCOJCK2JSPRMV5HHFHQ54YU6J6VWCBCDNULIT5ZJWO357R2DJLGIBM'
    and block_day > '2022-02-01'
    and (asset_id = '31566704' or asset_id = '312769')
    group by block_day, asset_id
    order by block_day
    Run a query to Download Data