(

select asset_id,creator_address,asset_name from flipside_prod_db.algorand.asset

where asset_units='TM1POOL'

)

, before_scam_mint as

-- select t.*,p.price_usd,p.price_usd*t.amount as amount_usd,p.asset_id as pit from flipside_prod_db.algorand.transfers t

select t.ASSET_SENDER,sum(p.price_usd*t.amount) as amount_usd from flipside_prod_db.algorand.transfers t

inner join flipside_prod_db.algorand.prices_swap p

on ( date_trunc('hour',t.block_timestamp)=p.block_hour and t.asset_id=p.asset_id)

where t.tx_group_id in

(

select tx_group_id from flipside_prod_db.algorand.transfers

where 1=1

-- and tx_id='TJUHG5APVPTUFJLVB3D4LEUE22KSGZE6K6GMR3XWETFSVYWFR4MA'

and asset_sender in (select creator_address from pool_table)

and asset_id in (select asset_id from pool_table)

)

and ((t.asset_id=0 and t.amount > 1) or (t.asset_id!=0))

and t.receiver in (select creator_address from pool_table)

and block_timestamp < '2022-01-01'

group by 1

order by 2 desc

-- and asset_sender in (select creator_address from pool_table)

-- and asset_id in (select creator_address from pool_table)

),

before_scam_burn as

-- select t.*,p.price_usd,p.price_usd*t.amount as amount_usd,p.asset_id as pit from flipside_prod_db.algorand.transfers t

select t.RECEIVER,sum(p.price_usd*t.amount) as amount_usd from flipside_prod_db.algorand.transfers t

inner join flipside_prod_db.algorand.prices_swap p