headitmanagerTotal transactions by project ASTROPORT
Updated 2022-03-07
99
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 tbl1 as
(
select distinct tx_from[0] as all_address from terra.transactions where
date(block_timestamp) <= DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
)
,tbl2 as
(
select distinct tx_from[0] as new_address from terra.transactions where
date(block_timestamp) > DATEADD(DAY, -90, CURRENT_DATE) and tx_from[0] is not null
)
,tbl3 as
(select new_address from tbl2 left join tbl1 on tbl2.new_address=tbl1.all_address where all_address is null
)
select count(*) as transactions ,
(
case
WHEN msg_value:contract='terra1zgrx9jjqrfye8swykfgmd6hpde60j0nszzupp9' then 'Generator'
WHEN msg_value:contract='terra1v5ct2tuhfqd0tf8z0wwengh4fg77kaczgf6gtx' then 'PSI-UST PAIR'
WHEN msg_value:contract='terra18hjdxnnkv8ewqlaqj3zpn0vsfpzdt3d0y2ufdz' then 'PSI-nETH Pair'
WHEN msg_value:contract='terra10lv5wz84kpwxys7jeqkfxx299drs3vnw0lj8mz' then 'NLUNA-PSI Pair'
WHEN msg_value:contract='terra1hhpgcp2stvzx952zfxtxg4dhgf60yfzchesj3e' then 'HaloSwap Pair'
WHEN msg_value:contract='terra1627ldjvxatt54ydd3ns6xaxtd68a2vtyu7kakj' then 'Lockdrop'
WHEN msg_value:contract='terra1tvld5k6pus2yh7pcu7xuwyjedn7mjxfkkkjjap' then 'Bootstrap Auction'
WHEN msg_value:contract='terra1dpe2aqykm2vnakcz4vgpha0agxnlkjvgfahhk7' then 'Airdrop'
WHEN msg_value:contract='terra1hk7fturdl9fnvrn566dxer6ds7v4jklp2wqmp7' then 'Airdrop #2'
WHEN msg_value:contract='terra1nq4aszdm82wujstxwpjxtvckg7ghu63mqkey33' then 'Staking'
WHEN msg_value:contract='terra1fnywlw4edny3vw44x04xd67uzkdqluymgreu7g' then 'Factory'
WHEN msg_value:contract='terra16t7dpwwgx9n3lq6l6te3753lsjqwhxwpday9zx' then 'Router'
WHEN msg_value:contract='terra1hncazf652xa0gpcwupxfj6k4kl4k4qg64yzjyf' then 'Vesting'
WHEN msg_value:contract='terra1l7xu2rl3c7qmtx3r5sd2tz25glf6jh8ul7aag7' then 'ASTRO-UST Pair'
WHEN msg_value:contract='terra1m6ywlgn6wrjuagcmmezzz2a029gtldhey5k552' then 'LUNA-UST Pair'
WHEN msg_value:contract='terra1zpnhtf9h5s7ze2ewlqyer83sr4043qcq64zfc4' then 'APOLLO-UST Pair'
WHEN msg_value:contract='terra134m8n2epp0n40qr08qsvvrzycn2zq4zcpmue48' then 'MINE-UST Pair'
WHEN msg_value:contract='terra143xxfw5xf62d5m32k3t4eu9s82ccw80lcprzl9' then 'MIR-UST Pair'
WHEN msg_value:contract='terra1qr2k6yjjd5p2kaewqvg93ag74k6gyjr7re37fs' then 'ANC-UST Pair'
Run a query to Download Data