AVG(COUNTER) | MAX(COUNTER) | |
|---|---|---|
1 | 3573955.076923 | 5437361 |
CUBE3tamask1
Updated 2024-01-24
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
polygon.core.fact_traces.tx_hash, count(*),
CASE
WHEN polygon.core.fact_traces.from_address = '0xeb4c67e5be040068fa477a539341d6aef081e4eb' THEN 'from'
WHEN polygon.core.fact_traces.to_address = '0xeb4c67e5be040068fa477a539341d6aef081e4eb' THEN 'to'
END as direction
FROM
polygon.core.fact_traces
WHERE
polygon.core.fact_traces.type = 'CALL'
AND
polygon.core.fact_traces.identifier <> 'CALL_ORIGIN'
AND
(
polygon.core.fact_traces.from_address = '0xeb4c67e5be040068fa477a539341d6aef081e4eb'
OR
polygon.core.fact_traces.to_address = '0xeb4c67e5be040068fa477a539341d6aef081e4eb'
)
GROUP BY polygon.core.fact_traces.tx_hash, direction
ORDER BY polygon.core.fact_traces.tx_hash, direction;
*/
/*
SELECT TOKEN_ADDRESS, DECIMALS, SYMBOL, PRICE, MODIFIED_TIMESTAMP, '56' as CHAIN_ID
FROM (
SELECT TOKEN_ADDRESS, DECIMALS, SYMBOL, PRICE, MODIFIED_TIMESTAMP, ROW_NUMBER() OVER (PARTITION BY TOKEN_ADDRESS ORDER BY MODIFIED_TIMESTAMP DESC) AS rn
FROM bsc.price.ez_hourly_token_prices
WHERE MODIFIED_TIMESTAMP > '2024-01-22 14:10:10.428000' )
AS sub
WHERE rn = 1
ORDER BY TOKEN_ADDRESS OFFSET 0 ROWS FETCH NEXT 10000 ROWS ONLY
SELECT BLOCK_NUMBER, COUNT(DISTINCT(CONTRACT_ADDRESS)), MAX(TO_CHAR(BLOCK_TIMESTAMP, 'yyyy-MM')) AS year_month
Last run: over 1 year ago
1
26B
5s