akshaymahajanhashflow avatar mints
Updated 2023-09-20
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
›
⌄
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