datavortexusers24hrs
Updated 2024-12-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
COUNT(DISTINCT subaccount) AS past_24hr_traders
FROM
(
SELECT
topics [2] AS subaccount
FROM
arbitrum.core.fact_event_logs
WHERE
topics [0] = '0x224253ad5cda2459ff587f559a41374ab9243acbd2daff8c13f05473db79d14c'
AND block_timestamp >= DATEADD(DAY, -1, CURRENT_TIMESTAMP)
UNION
ALL
SELECT
topics [3] AS subaccount
FROM
arbitrum.core.fact_event_logs
WHERE
topics [0] = '0x7c57459d6f4f0fb2fc5b1e298c8c0eb238422944964aa1e249eaa78747f0cca9'
AND block_timestamp >= DATEADD(DAY, -1, CURRENT_TIMESTAMP)
) AS subaccounts;
QueryRunArchived: QueryRun has been archived