Sandeshtop loser eth
    Updated 2022-10-24
    with 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='AR6TJOX2SW37FVX2JVXQDM3TNUNMTOXZH2ROG5ZOHAD3FKP6GGHW2SVKMA'
    and asset_id='386358144'
    )
    and ((t.asset_id=0 and t.amount > 1) or (t.asset_id!=0))
    and t.receiver='AR6TJOX2SW37FVX2JVXQDM3TNUNMTOXZH2ROG5ZOHAD3FKP6GGHW2SVKMA'
    and block_timestamp < '2022-01-01'
    group by 1
    order by 2 desc


    -- and asset_sender='AR6TJOX2SW37FVX2JVXQDM3TNUNMTOXZH2ROG5ZOHAD3FKP6GGHW2SVKMA'
    -- and asset_id='AR6TJOX2SW37FVX2JVXQDM3TNUNMTOXZH2ROG5ZOHAD3FKP6GGHW2SVKMA'
    ),
    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
    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 receiver='AR6TJOX2SW37FVX2JVXQDM3TNUNMTOXZH2ROG5ZOHAD3FKP6GGHW2SVKMA'
    Run a query to Download Data