rackhaelDIMENSION X
Updated 2023-03-28
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
35
36
›
⌄
-- select *
-- from flow.core.dim_contract_labels
-- where contract_name IN ('%DimensionX %')
WITH monthly_metrics AS (
SELECT
COALESCE(PLATFORM_NAME, AGGREGATOR_NAME) AS platform,
DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,
COUNT(DISTINCT TX_HASH) AS transactions,
COUNT(DISTINCT payer) AS users
FROM
ethereum.core.ez_nft_sales
WHERE
COALESCE(PLATFORM_NAME, AGGREGATOR_NAME) IN ('blur', 'opensea')
AND BLOCK_TIMESTAMP >= DATEADD(day, -180, CURRENT_TIMESTAMP())
AND BLOCK_TIMESTAMP < DATEADD(day, -DAY(CURRENT_TIMESTAMP()), DATEADD(month, 1, DATE_TRUNC('month', CURRENT_TIMESTAMP())))
GROUP BY
1, 2
with monthly metriscs as (
SELECT *
FROM flow.core.fact_events
WHERE event_contract = ('A.e3ad6030cbaff1c2.DimensionX')
)
select distinct marketplace
from flow.core.ez_nft_sales
-- event contract contract name account address
Run a query to Download Data