alex-gPG
Updated 2024-05-03
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 *
-- FROM blast.core.fact_token_transfers
-- WHERE
-- CONTRACT_ADDRESS = '0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
-- AND
-- ORIGIN_FROM_ADDRESS = '0x5c2c1fe77809507a37a684fa980f8903a85365c4'
-- LIMIT 1
--0x5C2c1fE77809507a37a684FA980F8903A85365C4 me
-- 0xd6b64e44aae0938118ad0dae251b859d85351c22 thruster
-- how many days, how many transactions for single
SELECT
DATEDIFF(day, min(BLOCK_TIMESTAMP), CURRENT_DATE()) AS age,
sum(GAS_USED) AS gas,
COUNT(DISTINCT TO_ADDRESS) AS interactions,
COUNT(DISTINCT TO_DATE(BLOCK_TIMESTAMP)) AS days
FROM blast.core.fact_transactions
WHERE
FROM_ADDRESS = LOWER('0x5C2c1fE77809507a37a684FA980F8903A85365C4')
AND STATUS = 'SUCCESS'
SELECT COUNT(DISTINCT TO_ADDRESS) AS interactions
FROM blast.core.fact_transactions
WHERE STATUS = 'SUCCESS'
GROUP BY FROM_ADDRESS
ORDER BY 1 DESC
SELECT *
FROM blast.core.fact_transactions
LIMIT 1
WHERE TX_HASH = '0xb52c4b6be847e99f3d0fd88f18b8b82992dff77d4d6f064634ef86102cb99944'
QueryRunArchived: QueryRun has been archived