banterlytics2023-07-28 07:28 PM
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 gen AS (
WITH all_tx AS (
SELECT
date_trunc('day', block_timestamp::date) AS dt,
tx_hash,
decoded_log:to::string AS event_to,
decoded_log:from::string AS event_from,
decoded_log:tokenId::string AS token_id
FROM ethereum.core.fact_decoded_event_logs
WHERE block_timestamp BETWEEN '2021-04-15 19:56:00.000' AND '2023-07-26 16:11:00.000'
AND contract_address = lower('0x57a204aa1042f6e66dd7730813f4024114d74f37')
AND event_name = 'Transfer'
AND token_id < 1001
),
transfers AS (
SELECT
event_to AS wallet,
dt,
'mint' AS action,
1 AS value
FROM all_tx
WHERE event_from = '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT
event_to AS wallet,
dt,
'gain' AS action,
1 AS value
FROM all_tx
WHERE event_from != '0x0000000000000000000000000000000000000000'
UNION ALL
SELECT
Run a query to Download Data