emirprince95LP mean, median, mode on LOOP
Updated 2022-01-26
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 mints as (
select date_trunc('day', block_timestamp) as ts,
sum(event_attributes:share/pow(10,6)) as LP_amount,
event_attributes:"0_contract_address" as LP_address,
event_attributes:receiver as wallet_address
from terra.msg_events
where event_attributes:"0_contract_address" in ('terra123neekasfmvcs4wa70cgw3j3uvwzqacdz2we03', 'terra106a00unep7pvwvcck4wylt4fffjhgkf9a0u6eu',
'terra1tus5ec9qsdht8dapq9ldfnsf8eehnfmwvsut83', 'terra1dw5j23l6nwge69z0enemutfmyc93c36aqnzjj5', 'terra1jfp5ew4tsru98wthajsqegtzaxt49ty4z2qws0',
'terra1jkr0ef9fpghdru38ht70ds6jfldprgttw6xlek','terra1cpzkckgzz90pq8fkumdjc58ee5llrxt2yka9fp', 'terra1lgazu0ltsxm3ayellqa2mhnhlvgx3hevkqeqy2',
'terra13eggta6zqfg03mxgqg9p5paqka7tgaaxnkhuuu','terra1f6d3pggq7h2y7jrgwxp3xh08yhvj8znalql87h', 'terra15568nqrqcawm263yqcuuuvj5mh763tp8jyscq3',
'terra1whns5nyc8sw328uw3qqnyafxd5yfqsytkdkgqz','terra1x4msd26x8ncqcng3dapx8306rmgwuwtlg30a2j','terra178yhudw6cwtnrn4fq593z87y385m0xe9n6x423' )--aust-ust, LOOP-UST, LUNA-UST, LOOP-LOOPR, LUNA-LOOP, LOOPR-UST,TWD-UST, SPEC-UST, MIR-UST, STT-UST, MINE-UST, ANC-UST, LOTA-UST, ALTE-UST, LOOP-weWETH, DPH-UST
and event_type = 'wasm'
and event_attributes:"2_action" = 'mint'
and tx_status = 'SUCCEEDED'
group by date_trunc('day', block_timestamp), LP_address, wallet_address
UNION
select date_trunc('day', block_timestamp) as ts, sum(event_attributes:share/pow(10,6)) as LP_amount,
event_attributes:"0_contract_address" as LP_address,
event_attributes:receiver as wallet_address from terra.msg_events
where event_attributes:"0_contract_address" ='terra154jt8ppucvvakvqa5fyfjdflsu6v83j4ckjfq3'
and event_type = 'wasm'
and msg_index = 2
and event_attributes:"3_action" = 'mint'
and tx_status = 'SUCCEEDED'
group by date_trunc('day', block_timestamp), LP_address, wallet_address
UNION
select date_trunc('day', block_timestamp) as ts, sum(event_attributes:share/pow(10,6)) as LP_amount,
event_attributes:"0_contract_address" as LP_address, event_attributes:receiver as wallet_address from terra.msg_events
where event_attributes:"0_contract_address" = 'terra1sgu6yca6yjk0a34l86u6ju4apjcd6refwuhgzv'
and event_type = 'wasm'
and event_attributes:"1_action" = 'mint'
and tx_status = 'SUCCEEDED'
Run a query to Download Data