Nige7777bLuna Burn
Updated 2021-07-06
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
-- msg_value:coins[0]:amount as Amount ,
-- msg_value
-- FROM terra.msgs
-- WHERE msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' -- anchor market
-- AND msg_value:execute_msg:deposit_stable IS NOT NULL
-- and block_timestamp >= CURRENT_DATE -1
-- limit 100
select --msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as InstantBurn
msg_value:execute_msg:send:amount / POW(10,6) as Amount
,
--sum( msg_value:coins[0]:amount / POW(10,6)) as Amount,
-- count(*) as BurnCount,
--msg_value:sender::string,
*,
date_trunc('day', block_timestamp) Day
from terra.msgs
WHERE 1=1
--and msg_value:contract = 'terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p' -- instant burn
and block_timestamp >= CURRENT_DATE -5
and msg_value:contract::string = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' -- bLuna contract
and msg_value:execute_msg:send:contract::string = 'terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p' -- bluna-luna pool
and msg_value:execute_msg:send:msg:swap is not null
-- :execute_msg:swap:offer_asset:info:native_token:denom::string = 'uluna'
-- group by
-- InstantBurn,
-- Day
limit 10000
-- with c_1 as
Run a query to Download Data