flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
Transaction Trends
datavortex
Transaction Trends
Updated 2024-09-04
Copy Reference
Fork
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
DATE_TRUNC
(
'week'
,
block_timestamp
)
AS
week_start
,
COUNT
(
DISTINCT
tx_hash
)
AS
unique_transactions
,
SUM
(
price_usd
)
AS
total_volume_usd
FROM
optimism
.
nft
.
ez_nft_sales
GROUP
BY
DATE_TRUNC
(
'week'
,
block_timestamp
)
ORDER
BY
week_start
;
Results
QueryRunArchived: QueryRun has been archived