check_skedWhere are the Coins Going? (Protocol) copy
Updated 2023-12-19
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 DecimalsValue AS (
SELECT
address,
decimals
FROM
ethereum.core.dim_contracts
WHERE
address IN (LOWER('0x6B175474E89094C44Da98b954EedeAC495271d0F'), LOWER('0xdAC17F958D2ee523a2206206994597C13D831ec7'), LOWER('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'), LOWER('0x853d955aCEf822Db058eb8505911ED77F175b99e'))
),
Received AS (
SELECT
r.to_address,
SUM(r.raw_amount) / POWER(10, d.decimals) AS usdt_received
FROM
ethereum.core.fact_token_transfers r
JOIN
DecimalsValue d ON r.contract_address = d.address
WHERE
r.contract_address IN (LOWER('0x6B175474E89094C44Da98b954EedeAC495271d0F'), LOWER('0xdAC17F958D2ee523a2206206994597C13D831ec7'), LOWER('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'), LOWER('0x853d955aCEf822Db058eb8505911ED77F175b99e'))
AND date_trunc('day', r.block_timestamp) BETWEEN CAST('2021-12-01' AS TIMESTAMP) AND CAST('2022-07-01' AS TIMESTAMP)
GROUP BY r.to_address, d.decimals
),
LabeledReceivedAmounts AS (
SELECT
l.label,
l.label_type,
SUM(r.usdt_received) AS total_received
FROM
Received r
JOIN
(SELECT
label_type,
label,
address
FROM
ethereum.core.dim_labels
QueryRunArchived: QueryRun has been archived