dan-smithUSDT burn
Updated 2023-02-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
CASE WHEN contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' THEN 'usdc'
WHEN contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' THEN 'usdt'
END AS token
,EVENT_NAME
,l.TX_HASH
,GAS_USED * BLOCK_HEADER_JSON:base_fee_per_gas / 1e18 AS eth_burn
FROM ethereum.core.fact_decoded_event_logs l
LEFT JOIN ethereum.core.fact_blocks b ON l.TX_HASH = t.TX_HASH
WHERE (contract_address = '0xdac17f958d2ee523a2206206994597c13d831ec7'
OR contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')
AND t.block_timestamp >= '2023-02-01'
AND l.block_timestamp >= '2023-02-01'
--GROUP BY 1, 2
ORDER BY 1, 2
LIMIT 100
SELECT *
FROM ethereum.core.fact_transactions
LIMIT 1
Run a query to Download Data