jackguymotorheadz
Updated 2022-09-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tab1 as (
SELECT
DISTINCT tx_hash
FROM optimism.core.fact_event_logs
WHERE contract_address LIKE lower('0x5c9D55b78FEBCC2061715BA4f57EcF8EA2711F2c')
), tab2 as (
SELECT
tx_hash as txn,
max(AMOUNT) as amt1,
max(AMOUNT_USD) as amt_usd1
FROM optimism.core.ez_eth_transfers
where tx_hash IN (SELECT * FROM tab1)
GROUP BY 1
)
SELECT *
FROM tab2
LEFT outer JOIN optimism.core.ez_eth_transfers
ON txn = tx_hash
AND amt1 = amount
Run a query to Download Data