CUBE3Revolut history - EVM - time based
Updated 2024-10-26
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
›
⌄
-- USD value transferres by receivers (native + ERC20)
SELECT
ADDRESS,
SUM(NATIVE_COUNTER) AS NATIVE_COUNTER,
SUM(TOKEN_COUNTER) AS TOKEN_COUNTER,
SUM(TOTAL_COUNTER) AS TOTAL_COUNTER,
SUM(NATIVE_USD) as NATIVE_USD,
SUM(TOKEN_USD) as TOKEN_USD,
SUM(TOTAL_USD) as TOTAL_USD
FROM(
SELECT
TO_ADDRESS AS ADDRESS,
COUNT(*) AS NATIVE_COUNTER,
0 AS TOKEN_COUNTER,
COUNT(*) AS TOTAL_COUNTER,
'native' AS TRANSFER_TYPE,
SUM(AMOUNT_USD) as NATIVE_USD,
0 as TOKEN_USD,
SUM(AMOUNT_USD) as TOTAL_USD,
FROM ethereum.core.ez_native_transfers
-- FROM bsc.core.ez_native_transfers
-- FROM polygon.core.ez_native_transfers
-- FROM optimism.core.ez_native_transfers
-- FROM base.core.ez_native_transfers
-- FROM arbitrum.core.ez_native_transfers
-- FROM avalanche.core.ez_native_transfers
WHERE FROM_ADDRESS = '0xb23360ccdd9ed1b15d45e5d3824bb409c8d7c460'
AND ORIGIN_FROM_ADDRESS = '0xb23360ccdd9ed1b15d45e5d3824bb409c8d7c460'
AND BLOCK_TIMESTAMP BETWEEN '2024-08-01' AND '2024-10-25'
GROUP BY TO_ADDRESS
UNION
SELECT
TO_ADDRESS AS ADDRESS,
0 AS NATIVE_COUNTER,
QueryRunArchived: QueryRun has been archived