HosseinUntitled Query
Updated 2023-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
a.block_timestamp::date as day,
count(distinct tx_sender) as users_count,
count(distinct tx_id) as txn_count,
sum(users_count) over (order by day) as cumulative_users_count,
sum(txn_count) over (order by day) as cumulative_txn_count
from terra.core.fact_lp_actions a
join terra.core.fact_transactions b
using(tx_id)
where a.tx_succeeded = 1
and year(block_timestamp) >= 2023
group by 1
order by 1
Run a query to Download Data