0xtoshicluster8l
Updated 2024-06-06
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 Cluster as (
SELECT * FROM (VALUES
('0x5de510263fdc5236c034aa7b23c3a61e053691de'),
('0xfa40d296a89d4469f893adf187d685abee336d39'),
('0x3c0211973468c63dfee25eb05b0ffa45cc891ea9'),
('0x94b8034a4d30cf40d26839ee59cac00f9f0b7e5f'),
('0x6792fcd346f9fbc8c99a92980138981af6f53b09'),
('0x1aea871fe3ffe8852c7fd4b1d6eae9767d47a4bc'),
('0xee2bad7c82e80d75cd2582880342bd329e37e677'),
('0x76f463c09774dde3b874a35b003942cb8e27c70b'),
('0x044434ea6918fe13262a9ea58a8c882af51ab971'),
('0xf4713a2e7ed226bd8902681ea548f2c37f2833c8'),
('0xd92e09f09e3d8b9ad6b85dea7cbd190c334f7df1'),
('0xb53c36743390b780a72685064a62ce964b9a7eff'),
('0x48a2b66f5800be1805ed2e489ad6e5e7f8dc20a3'),
('0xd80e912e05c61711466f9bbe8ef656ff0d5ac83a'),
('0x019bad383053ca94f6b4c9d9d6e15925e6cbc74d'),
('0x850e9d09be7cb0dac96ad5afd28791226867f176'),
('0xd2c4bde6b4199b592ffec4548a98d56aaf6c76ae'),
('0xc26490cb286914dedf17058b2ef91c20f7188321'),
('0x1382a25998e929fd5daa757a96429180ee32dfa2'),
('0xa26289fb1f49a20efc5fbe0a35d47702e6c8d6e0'),
('0x5d1d4036048b6bc3e59001b3c48f067b2dc5e32b'),
('0x8e0c6ef8d94d247471399b2368c789cf65f9ce6b'),
('0xbcfd6545dbc9e7f9f0f811eaf7e9b8c17e619fe2'),
('0xfc9d1851edc15eb1f6482b39e16b6b5b6d265e9f'),
('0x0e83e575764818a7844efc86bec423379dc48d50'),
('0xa7b9b2e23b7560f610d9e6e88af7b342755be61b'),
('0xc43b8f7f6bc44effffd1257aed4df4986ecab361')
) t(address) )
SELECT SENDER_WALLET,
DATE_TRUNC('week', SOURCE_TIMESTAMP_UTC) as txdate,
ZEROIFNULL(COUNT(SOURCE_TRANSACTION_HASH)) as numOfTX
FROM external.layerzero.fact_transactions_snapshot
WHERE SENDER_WALLET IN (SELECT address FROM Cluster)
GROUP BY 1,2
QueryRunArchived: QueryRun has been archived