mattkstewLAAF Wallets 3
Updated 2023-01-25Copy Reference Fork
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
›
⌄
with tab1 as (
select
tx_sender,
min(date_trunc('day', block_timestamp)) as date1
from terra.core.fact_transactions
group by 1
)
, tab2 as (
select
date1,
count(*) as amount
from tab1
group by 1 )
select
date1,
case when date1 >= '2023-01-14' then 'After Station Launch'
else 'Before Station Launch'
END as Station_launch,
sum(amount) over (order by date1) as value
from tab2
where date1 > '2023-01-07'
order by 1
Run a query to Download Data