brian-terraAll Remints
Updated 2023-01-23
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 tokens_minted as (
select block_timestamp,
tx_hash,
event_inputs:from::string as sender,
event_inputs:to::string as receiver,
event_inputs:tokenId::float as tokenid
from polygon.core.fact_event_logs
where /*tx_hash = '0xe0facde0c86d299fe063b4725ace6de96a8c373038673f7bf4e6e82e2b5e4264'
and */event_name = 'Transfer'
and tx_status = 'SUCCESS'
and sender = '0x0000000000000000000000000000000000000000'
and contract_address = '0x09421f533497331e1075fdca2a16e9ce3f52312b' --hellcats contract
and block_timestamp > '2023-01-20 20:00:00.000'
),
prices_paid as (
select block_timestamp,
tx_hash,
event_inputs:from::string as sender,
event_inputs:to::string as receiver,
event_inputs:value::float / 1e6 as usdc_spent
from polygon.core.fact_event_logs
where /*tx_hash = '0xe0facde0c86d299fe063b4725ace6de96a8c373038673f7bf4e6e82e2b5e4264'
and */event_name = 'Transfer'
and tx_status = 'SUCCESS'
and receiver = '0x676b9f1ca03d5c92516e87d5b4e3a862a9c0abef' -- hellcats mint fee collector
and contract_address = '0x2791bca1f2de4661ed88a30c99a7a9449aa84174' --hellcats contract
and block_timestamp > '2023-01-20 20:00:00.000'
),
all_data as (
select a.*,
nvl(b.usdc_spent,0) as total_usdc
from tokens_minted a, prices_paid b
where a.tx_hash = b.tx_hash (+)
Run a query to Download Data