saadiq2023-06-14 08:43 AM
    Updated 2023-06-14
    select
    block_timestamp,
    project_name,
    tokenid,
    event_type,
    price,
    price_usd,
    case
    when price > 100000 then price / 1000000000000000000
    else price
    end as normalized_price,
    tx_hash
    from
    (
    SELECT
    project_name,
    nft_address,
    block_timestamp,
    event_type,
    tokenid,
    mint_price_eth AS price,
    mint_price_usd AS price_usd,
    tx_hash,
    nft_from_address AS from_address,
    nft_to_address AS to_address
    FROM
    ethereum.core.ez_nft_mints
    WHERE
    nft_address IN (
    '0x23581767a106ae21c074b2276d25e5c3e136a68b',
    '0x8a90cab2b38dba80c64b7734e58ee1db38b8992e',
    '0xed5af388653567af2f388e6224dc7c4b3241c544',
    '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b'
    )
    UNION
    SELECT
    Run a query to Download Data