saadiq2023-06-12 02:08 PM
Updated 2023-06-12
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
›
⌄
WITH numbers AS (
SELECT
SEQ4() AS num
FROM
TABLE (GENERATOR(ROWCOUNT => 1000)) -- Assuming less than 1000 days
),
dates AS (
SELECT
DATEADD(DAY, num, '2023-03-01') AS date
FROM
numbers
WHERE
DATEADD(DAY, num, '2023-03-01') BETWEEN '2023-03-26' AND CURRENT_DATE
),
DELTAS AS (
SELECT
*
FROM
ethereum.core.ez_balance_deltas
WHERE
user_address IN (
SELECT
DISTINCT user_address
FROM
ethereum.core.ez_balance_deltas
WHERE
contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b')
)
AND (
contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b')
/* proof contracts: MB */
)
)
SELECT
d.date,
count(distinct subquery.user_address) as user_count
Run a query to Download Data