sinahosseinzadehUntitled Query
Updated 2022-08-03
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
›
⌄
WITH QUIXO_VENTAS AS(
SELECT *
FROM optimism.core.ez_nft_sales as T1 WHERE PLATFORM_NAME ILIKE '%quixotic%'),
TRANS AS (SELECT DISTINCT TX_HASH, CURRENCY_SYMBOL
FROM optimism.core.ez_nft_sales as T2 WHERE PLATFORM_NAME ILIKE '%quixotic%'),
ETHEREUM AS (
SELECT SUM(AMOUNT) AS AMT, 'ETH' AS ASSET
FROM TRANS
JOIN optimism.core.ez_eth_transfers T4 ON TRANS.TX_HASH = T4.TX_HASH AND TRANS.CURRENCY_SYMBOL ILIKE '%ETH%'
WHERE T4.ORIGIN_FUNCTION_SIGNATURE = '0x912d97fc' AND T4.ETH_TO_ADDRESS = '0xec1557a67d4980c948cd473075293204f4d280fd'
),
opt AS (
SELECT sum(RAW_AMOUNT / pow(10, 18)) AS AMT, 'OP' AS ASSET
FROM optimism.core.fact_token_transfers as T5
WHERE CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042' AND TO_ADDRESS = '0xec1557a67d4980c948cd473075293204f4d280fd' AND
ORIGIN_FUNCTION_SIGNATURE = '0x912d97fc')
SELECT *
FROM ETHEREUM as T8
UNION ALL
SELECT *
FROM OPT as T10
Run a query to Download Data