0xHaM-dOverall View
Updated 2022-12-05Copy Reference Fork
999
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 dim_table AS (
SELECT *
FROM (
SELECT dateadd('hour', seq4(), '2022-07-01 00:00:00') AS date
FROM TABLE(GENERATOR(rowcount => 100000))
WHERE date <= date_trunc('hour', CURRENT_TIMESTAMP)
) AS h,
(SELECT 'Mint' AS transaction_type
UNION ALL
SELECT 'Burn' AS transaction_type)
)
, mint_and_burn_transactions AS (
SELECT
tx_hash
, event_index
, block_timestamp
, origin_from_address
, event_inputs['from']::string AS sender
, event_inputs['to']::string AS receiver
, contract_address AS token_address
, event_inputs['value']::bigint / pow(10,6) AS amount
, (CASE WHEN sender = '0x0000000000000000000000000000000000000000' THEN 'Mint'
WHEN receiver = '0x0000000000000000000000000000000000000000' THEN 'Burn'
ELSE 'Others' END) AS tx_type
, (CASE WHEN sender = '0x0000000000000000000000000000000000000000' THEN receiver
WHEN receiver = '0x0000000000000000000000000000000000000000' THEN sender END) AS wallet_address
FROM avalanche.core.fact_event_logs AS transfer
WHERE tx_status = 'SUCCESS'
AND event_name = 'Transfer'
AND block_timestamp >= '2022-07-01 00:00:00.000'
AND try_to_numeric(event_inputs['value']::string) IS NOT NULL
AND contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'
AND (sender = '0x0000000000000000000000000000000000000000' -- mint
Run a query to Download Data