HeminbLUNA and bETH daily unique bidders
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with tab1 as(
select date_trunc('day',block_timestamp)as day,
count (distinct msg_value:sender)as bLUNA_unique_bidders
from terra.msgs
where day>='2021-11-01'
and msg_value:contract in ('terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u','terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')
and msg_value:execute_msg:submit_bid:collateral_token = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'
group by 1),
tab2 as(
select date_trunc('day',block_timestamp)as day,
((count (distinct msg_value:sender)) * -1) as bETH_unque_bidders
from terra.msgs
where day>='2021-11-01'
and msg_value:contract in ('terra1e25zllgag7j9xsun3me4stnye2pcg66234je3u','terra1w9ky73v4g7v98zzdqpqgf3kjmusnx4d4mvnac6')
and msg_value:execute_msg:submit_bid:collateral_token = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'
group by 1)
select tab1.day,tab1.bLUNA_unique_bidders,tab2.bETH_unque_bidders
from tab1
left join tab2
on tab1.day=tab2.day
Run a query to Download Data