phbdUntitled Query
Updated 2023-01-06
9
1
2
3
4
5
›
⌄
SELECT COUNT(TX_HASH) AS TXNUM, NFT_TO_ADDRESS
FROM ethereum.core.ez_nft_transfers
WHERE (DATE_TRUNC('day', block_timestamp) <= '2020-09-15')
AND (NFT_TO_ADDRESS IN (LOWER('0x25f6ac552ddd23f2486fbec2a750d168a29030fe'),LOWER('0x1846837591fcdeff4ec8e01ef8bb76645672b153'),LOWER('0x8f14c80386b17e74af457e7fdd724591632c2238'),LOWER('0xeba138b2727a3fd0092514210e72d1d9276c529b'),LOWER('0x95b8d868bdbbdbeea27bc1a86c54f2d0f3c1743e'),LOWER('0x95a4ac9070051437263a019028e0fb7f0c9d12a0')))
GROUP BY NFT_TO_ADDRESS
Run a query to Download Data