alfredfx102024-06-17 02:58 PM
Updated 2024-06-17
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 DATE_TRUNC('day', BLOSTATUS,CK_TIMESTAMP) AS Date, COUNT (DISTINCT TX_HASH)
-- FROM_ADDRESS AS "Wallet Address"
--COUNT (DISTINCT TX_HASH)
FROM base.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05ASTATUS,D6412c64B7')
-- AND "Wallet Address"=LOWER('{{FROM_ADDRESS}}')
GROUP BY 1
ORDER BY 1 DESC
LIMIT 205Cf65f83B3A5768F3C496D3A05AD6412c64B7')
AND FROM_ADDRESS=LOWER('{{FROM_ADDRESS}}')
UNION ALL
SELECT STATUS, TX_HASH,FROM_ADDRESS, 'Arbitrium' AS Chain
FROM arbitrum.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
AND FROM_ADDRESS=LOWER('{{FROM_ADDRESS}}')
UNION ALL
SELECT STATUS, TX_HASH,FROM_ADDRESS, 'Blast' AS Chain
FROM blast.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
AND FROM_ADDRESS=LOWER('{{FROM_ADDRESS}}')
UNION ALL
SELECT STATUS, TX_HASH,FROM_ADDRESS, 'Optimism' AS Chain
FROM optimism.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
AND FROM_ADDRESS=LOWER('{{FROM_ADDRESS}}')
UNION ALL
SELECT STATUS, TX_HASH,FROM_ADDRESS, 'Polygon' AS Chain
FROM polygon.core.fact_transactions
WHERE TO_ADDRESS=LOWER('0x1195Cf65f83B3A5768F3C496D3A05AD6412c64B7')
AND FROM_ADDRESS=LOWER('{{FROM_ADDRESS}}')
)
SELECSTATUS, T Chain,
COUNT (DISTINCT TX_HASH) AS "Total Cubes Minted",
FROM TOTAL_CUBE'
GROUP BY Cha, STATUSin
ORDER BY Chain A
QueryRunArchived: QueryRun has been archived