oscarqtoken_transfers_assesment_ETH
Updated 2025-03-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
›
⌄
WITH transfers_table AS (
SELECT
DATE_TRUNC('month',block_timestamp) AS transfer_date,
contract_address,
count(*) AS num_transfers,
sum(amount) AS total_amount,
sum(amount_usd) total_amount_usd,
'ethereum' AS blockchain
FROM
ethereum.core.ez_token_transfers tr
LEFT JOIN
ethereum.core.dim_contracts ct ON tr.contract_address = ct.address
WHERE
block_timestamp >= '{{initial}}'
AND block_timestamp < '{{end}}'
AND contract_address NOT IN (SELECT pool_address FROM ethereum.defi.dim_dex_liquidity_pools)
GROUP BY 1,2,6
)
SELECT
transfer_date,
contract_address,
ct.name AS name,
ct.symbol AS symbol,
ct.created_block_timestamp AS created_blocktime_stamp,
ct.creator_address AS creator_address,
num_transfers,
total_amount,
total_amount_usd,
blockchain
FROM
transfers_table tr
LEFT JOIN
ethereum.core.dim_contracts ct ON tr.contract_address = ct.address
WHERE
(
QueryRunArchived: QueryRun has been archived