Sandeshtop loser eth
Updated 2022-10-24
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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