LTirrell2022-03-04_terra_feet-wet_most-protocols
Updated 2022-03-10
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 flattened_transactions as (
select
t.block_timestamp,
t.tx_id,
w.value as wallet
from
terra.transactions t,
lateral flatten(input => t.tx_from) w
where
tx_status = 'SUCCEEDED'
),
new_wallets as (
select
wallet,
min(block_timestamp) :: date as join_date
from
flattened_transactions
group by
wallet
having
join_date >= current_date - 90
),
transactions as (
select
ft.block_timestamp,
ft.tx_id,
ft.wallet,
nw.join_date
from
new_wallets nw
inner join flattened_transactions ft on nw.wallet = ft.wallet
),
contracts as (
select
distinct m.msg_value :contract :: string as contract,
m.tx_id as tx_id
Run a query to Download Data