zpokoETH Retention
Updated 2023-06-30
999
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
(
SELECT
COUNT(DISTINCT arb_bridge_addy) AS arb_bridge_addy_count
FROM (
SELECT
DATE_TRUNC('day', ft.block_timestamp) AS dt,
CASE
WHEN dl.label_type = 'nft' THEN ft.from_address
END AS arb_bridge_addy
FROM
ethereum.core.fact_transactions ft
JOIN ethereum.core.dim_labels dl ON ft.to_address = dl.address
WHERE
dl.label_type IN ('nft')
AND ft.block_timestamp >= DATEADD(DAY, -7, CURRENT_TIMESTAMP())
) AS all_7d
) AS count_7_days,
(
(
SELECT
COUNT(*) AS count_7_days
FROM
(
SELECT
CASE
WHEN dl.label_type = 'nft' THEN ft.from_address
END AS arb_bridge_addy
FROM
ethereum.core.fact_transactions ft
JOIN ethereum.core.dim_labels dl ON ft.to_address = dl.address
WHERE
dl.label_type IN ('nft')
AND ft.block_timestamp >= DATEADD(DAY, -7, CURRENT_TIMESTAMP())
GROUP BY
arb_bridge_addy
Run a query to Download Data