adriaparcerisasterradash1 1
Updated 2022-12-08
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
26
27
28
29
›
⌄
--Average Transaction Fee per txn per week
--Total Transaction Fees per week
--Total number of transactions per week
--Average transactions per second (TPS) per week
--Average block time per week
--Wallets
--Total number of new wallets per week
--Total number of active wallets per week
--Cumulative number of new wallets per week
SELECT
trunc(block_timestamp,'week') as date,
count(distinct tx_id) as txs,
sum(txs) over (order by date) as cum_txs,
avg(txs) over (order by date, date rows between 6 preceding and current row) as ma7_txs,
avg(txs) over (order by date, date rows between 14 preceding and current row) as ma15_txs,
avg(txs) over (order by date, date rows between 29 preceding and current row) as ma30_txs,
sum(fee) as total_fees,
sum(total_fees) over (order by date) as cum_fees,
avg(fee) as avg_tx_fee,
avg(avg_tx_fee) over (order by date, date rows between 6 preceding and current row) as ma7_fee,
avg(avg_tx_fee) over (order by date, date rows between 14 preceding and current row) as ma15_fees,
avg(avg_tx_fee) over (order by date, date rows between 29 preceding and current row) as ma30_fees
FROM terra.core.fact_transactions
WHERE tx:body:messages[0]:amount[0]:denom = 'uluna' -- LUNA 2.0 ACTIONS
AND block_timestamp > '2022-05-28' -- LUNA 2.0 LAUNCH
AND tx_succeeded = true
group by 1
order by 1
Run a query to Download Data