0xHaM-dDaily Number of Transactions in Q3 2024
Updated 2024-10-01
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
30
31
32
33
34
›
⌄
-- forked from Quarterly Number of Transactions Since 2023 @ https://flipsidecrypto.xyz/studio/queries/d2215b33-f6f1-4dca-9958-26a7c070762f
select
date_trunc('d', block_timestamp) as "Date",
case
when year(block_timestamp) = '2023' then concat('Q', quarter("Date"),'-','Months ','[',month("Date") ,' To ',month("Date") + 1,']','-', 23 )
when year(block_timestamp) = '2024' then concat('Q', quarter("Date"),'-','Months ','[',month("Date") ,' To ',month("Date") + 1,']','-', 24 )
end as "Quarter",
CASE when year(block_timestamp) = '2023' then 'y.2023' else 'y.2024' end as year,
count(distinct tx_hash) as "Transaction Count",
round("Transaction Count" / count(distinct block_timestamp::date)) as "Average Daily TXs",
count(distinct origin_from_address) as "User Count",
round("User Count" / count(distinct block_timestamp::date)) as "Average Daily Users",
round((("Transaction Count" / lag("Transaction Count") over (order by "Date")) - 1) * 100) AS "Change in TXs in Percent",
round((("User Count" / lag("User Count") over (order by "Date")) - 1) * 100) AS "Change in Users in Percent",
count(distinct service_id) as "# Services",
round((("# Services"/ lag("# Services") over (order by "Date")) - 1) * 100) AS "Change in # Services in Percent",
sum("Transaction Count") over (order by "Date") AS "Total Transaction",
from
crosschain.olas.fact_service_events
where
block_timestamp::date >= '2024-07-01'
AND
block_timestamp::date < '2024-10-01'
GROUP BY 1,2,3
QueryRunArchived: QueryRun has been archived