keshanTerra NFT: top 10 projects
Updated 2022-02-11
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
›
⌄
select msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:taker_asset:info:nft:contract_addr as address,
(case address when 'terra180tvldnt7h3lts6sp0n3kq7x496sf8cuvqf4xd' then 'Luna Monkey Business'
when 'terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'
when 'terra1zvmesqul8ss2ty84eml8aqkq0kq5ydwjuyf6a3' then 'BabyBulls'
when 'terra1hj0dga445h3faxu85gm0293608qntsj3a727ck' then 'TerraBots'
when 'terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'LunaBulls'
when 'terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'
when 'terra1fnv8f2202zgsnvpju7auehmygmdfj93xls8x0s' then 'Goochi Goochi'
when 'terra1f89xq3qhu98v4jch4y5xcrkhl9gytrne99x74t' then 'Terrapins on Terra'
when 'terra1598rvtgufwr7pnpqhrlajjrmvte4l8a6xkty6y' then 'Galactic Baby Ape Club'
when 'terra1fsfnnv08cgwcyfyh3p89rf44tfy4tlgnsapyda' then 'Terra Name Service'
when 'terra1vhuyuwwr4rkdpez5f5lmuqavut28h5dt29rpn6' then 'Levana Dragons-LVNDRG'
when 'terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg' then 'Levana Eggs'
when 'terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v' then 'Levana Dragons-LVN'
when 'terra1jp5fjj7rlc0erw4z3qr5zuvmg2w49pfzyhvsnk' then 'wagmimonkeez'
when 'terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7' then 'Levana Meteor Dust'
when 'terra14gfnxnwl0yz6njzet4n33erq5n70wt79nm24el' then 'Levana Loot'
else 'other' end) as project,
sum(case when msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:info:native_token:denom = 'uluna'
then msg_value:execute_msg:ledger_proxy:msg:post_order:order:order:maker_asset:amount else 0 end)/1e6 as luna_amount
FROM terra.msgs
WHERE msg_value:contract = 'terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
AND msg_type = 'wasm/MsgExecuteContract'
AND tx_status = 'SUCCEEDED'
AND msg_value:execute_msg:ledger_proxy:msg:post_order is not null
AND block_timestamp::date >= date_trunc('day', CURRENT_DATE) - 30
GROUP BY address, project
ORDER BY luna_amount desc
limit 10