0xaimanNFT put for Sale RandomEarth for December 2021
Updated 2021-12-12
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
›
⌄
⌄
⌄
/*
Select BLOCK_TIMESTAMP, F.Value, tx_id
from terra.msg_events , Table(flatten(input=>EVENT_ATTRIBUTES))F
where -- tx_id='D574BD43C141777E7A5EF310D012472CFB0E0DB9A646842D0A7CBE9E0DCC3743' and
event_type='wasm' and
tx_status='SUCCEEDED' and
key='1_contract_address' and
value='terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
-- and event_attributes:contract_address='terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t' and
-- event_attributes:action
--where contract_address='terra1eek0ymmhyzja60830xhzm7k7jkrk99a60q2z2t'
limit 100
*/
------------------------------
select date_trunc('day',t ) as date,-- action,
--nft_project,
/* case when nft_project='terra103z9cnqm8psy0nyxqtugg6m7xnwvlkqdzm4s4k' then 'Galactic Punks'
when nft_project='terra1ca9peph7c20eqr9cns2vhn6sp6cp7vv4jnzjrc' then 'Derby Star Horse'
when nft_project='terra1lfr4aja5a2xpxvnrl4gyjpru0wwglu7k87jmeq' then 'Hero NFT'
when nft_project='terra1p70x7jkqhf37qa7qm4v23g4u4g8ka4ktxudxa7' then 'Levana Dragons:Meteor Dusts'
when nft_project='terra1934kn7p03ns94htl75zpzsg0n4yvw8yf2746ep' then 'Styllar'
when nft_project='terra1k0y373yxqne22pc9g7jvnr4qclpsxtafevtrpg' then 'Levana Dragons: Eggs'
when nft_project='terra1trn7mhgc9e2wfkm5mhr65p3eu7a2lc526uwny2' then 'Luna Bulls'
when nft_project='terra1chrdxaef0y2feynkpq63mve0sqeg09acjnp55v' then 'Levana Dragons: Meteors'
when nft_project='terra1fnv8f2202zgsnvpju7auehmygmdfj93xls8x0s' then 'Goochi Goochi'
when nft_project='terra1hj0dga445h3faxu85gm0293608qntsj3a727ck' then 'Terra Bots'
when nft_project='terra1f89xq3qhu98v4jch4y5xcrkhl9gytrne99x74t' then 'Terrapins'
when nft_project='terra1sux7jjk9vfd0q6z0l99wpg07yd0wme0ac9le40' then 'The Crunks'
when nft_project='terra16zx5gu9t9q3pwmz77ll7tv6y5p3k6thpufcxqy' then 'Terra Unicorns'
when nft_project='terra1h6msx3t0qj7fuhssyqc44g20qwwyz35zqel96l' then 'Poppin Puffins'
when nft_project='terra12vdepstt7f45lr8gz2flf7dnwzwlft3r22nref' then 'Luna Apes'
when nft_project='terra1gek0c83grmj6twdr8c9al00hagd4kw5lxlt0cu' then 'Styllar Items'
Run a query to Download Data