sinahosseinzadehUntitled Query
    Updated 2022-08-03

    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