commanderjoseph-761gwXDaily tx
Updated 2024-11-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
DATE_TRUNC('day',block_timestamp) as Transaction_date,
COUNT(DISTINCT tx_hash) as no_of_daily_tx,
COUNT(DISTINCT from_address) as Daily_user,
sum(no_of_daily_tx) over (order by DATE_TRUNC('day',block_timestamp)) as Cumulative_txs,
sum(Daily_user) over (order by DATE_TRUNC('day',block_timestamp)) as Total_Users
FROM
berachain.testnet.fact_transactions
WHERE
block_timestamp > CAST('2024-06-10' AS TIMESTAMP)
GROUP
BY
Transaction_date
ORDER
BY
Transaction_date
DESC
QueryRunArchived: QueryRun has been archived