0xaimanlabel and poool
Updated 2022-08-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with raw as (with pool_address as
(select address from ethereum.core.dim_labels
where label_type= 'dex' and label ='sushiswap' and label_subtype='pool'
)
Select bLOCK_TIMESTAMP as t, TX_HASH, ORIGIN_FROM_ADDRESS as sender,
ORIGIN_TO_ADDRESS,
CONTRACT_ADDRESS as pool_address, EVENT_NAME, EVENT_INPUTS, EVENT_INPUTS:amount0 as a0, TX_STATUS
from ethereum.core.fact_event_logs el inner join pool_address
on el.contract_address=pool_address.address
where event_name = 'Mint' and tx_status ='SUCCESS'
)
select sender, l.label, pool_address , tx_hash
from raw left join ethereum.core.dim_labels l on
raw.sender=l.address
limit 1000
Run a query to Download Data