BLOCK_TIMESTAMP | BLOCK_NUMBER | TX_HASH | EVENT_TYPE | CONTRACT_ADDRESS | NAME | FROM_ADDRESS | TO_ADDRESS | TOKEN_ID | QUANTITY | TOKEN_STANDARD | MINT_PRICE_NATIVE | MINT_PRICE_USD | NFT_COUNT | AMOUNT | AMOUNT_USD | MINT_PRICE_TOKENS | MINT_PRICE_TOKENS_USD | MINT_TOKEN_SYMBOL | MINT_TOKEN_ADDRESS | TX_FEE | EZ_NFT_MINTS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | NFT_ADDRESS | PROJECT_NAME | NFT_FROM_ADDRESS | NFT_TO_ADDRESS | TOKENID | ERC1155_VALUE | MINT_PRICE_ETH | _LOG_ID | _INSERTED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-02-12 17:25:59.000 | 21831883 | 0x31225a0da6f5c68655d3eea6320282d6e3117319aed1332416f41baf9703d7ba | nft_mint | 0x4e502ab1bb313b3c1311eb0d11b31a6b62988b86 | MegaETH NFT | 0x0000000000000000000000000000000000000000 | 0x62090bba01e5f834f24d8f7a49cabe572a568c36 | 4999 | 1 | erc721 | 1 | 2610.39 | 1 | 0.0007902072395 | 58ca0bbac9ad3d93660136dd3c86efab | 2025-02-13 03:13:49.871 | 2025-02-13 03:13:49.871 | 0x4e502ab1bb313b3c1311eb0d11b31a6b62988b86 | MegaETH NFT | 0x0000000000000000000000000000000000000000 | 0x62090bba01e5f834f24d8f7a49cabe572a568c36 | 4999 | 1 | 0x31225a0da6f5c68655d3eea6320282d6e3117319aed1332416f41baf9703d7ba-513-0... | 2025-02-13 00:35:06.257 |
Pine AnalyticsMega_ETH_NFT
Updated 2025-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (
SELECT * FROM ethereum.price.ez_prices_hourly where token_address like lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')
)
SELECT
date_trunc('hour', block_timestamp) as hour,
count(*) as ntfs_minted,
count(*) * price as Mint_fees_usd,
sum(ntfs_minted) over (order by hour) as total_nfts_minted,
sum(Mint_fees_usd) over (order by hour) as total_nft_mint_fees
from ethereum.nft.ez_nft_mints
left outer join tab1
on hour = date_trunc('hour', block_timestamp)
WHERE contract_address like '0x4e502ab1bb313b3c1311eb0d11b31a6b62988b86'
GROUP BY 1
Last run: about 2 months ago
1
742B
2s