akshaymahajanhashflow avatar mints
    Updated 2023-09-20
    SELECT
    TX_HASH,
    BLOCK_TIMESTAMP,
    BLOCK_NUMBER,
    nft_to_address as ADDRESS,
    'nft_mint' AS ACTION,
    to_char(_log_id) AS TX_SIGNATURE,
    nft_address AS CONTRACT_ADDRESS,
    TO_JSON(OBJECT_CONSTRUCT(
    'nft_to_address', nft_to_address,
    'nft_contract_address', nft_address,
    'quantity', case when erc1155_value > 0 then erc1155_value else 1 end,
    'token_id', tokenid,
    'mint_price_eth', mint_price_eth,
    'mint_price_usd', mint_price_usd,
    'project_name', mints.,
    'metadata', mints.token_metadata
    )) AS EXTRA_DATA
    FROM ethereum.nft.ez_nft_mints mints
    where lower(mints.nft_address) = lower('0x3e3cfF05Ce7d7f1Be0e6d80Fbc0d9c64Bc0B3262')
    -- AND BLOCK_NUMBER >= {{BLOCK_NUMBER}}
    -- AND BLOCK_TIMESTAMP <= SYSDATE() - INTERVAL '6 hour'
    -- ORDER BY BLOCK_NUMBER ASC
    -- LIMIT {{LIMIT}}
    Run a query to Download Data