mehrancrypto-dxoepqUntitled Query
    Updated 2022-08-30
    with tx1 as (
    SELECT ADDRESS
    from ethereum.core.dim_labels
    where LABEL_TYPE = 'nft'
    and LABEL ilike '%cryptopunk%'
    )
    SELECT CURRENCY_SYMBOL , sum(price_usd )
    from tx1 B , ethereum.core.ez_nft_sales A
    where NFT_ADDRESS = ADDRESS
    and BLOCK_TIMESTAMP::date = '2022-06-19'
    and BUYER_ADDRESS <> '0x0000000000000000000000000000000000000000'
    GROUP by 1

    Run a query to Download Data