tkvresearcheligible nft holder
Updated 2024-03-12
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
/* BNB CodeConqueror address: 0x87a218ae43c136b3148a45ea1a282517794002c8 */
/* BNB PixelProwler address: 0x45eb7e752e446db7e7c757b21b26cbc897345843 */
/* BNB MelodyMaven address: 0x917b43b57d25952c1a8ce1af68aec95678d1246e */
/* BNB EcoGuardian address: 0x1d143f26540c4bf893d74bef4a5d9999987e492b */
/* Polygon CodeConqueror address: 0xe7c224ec925e877659ffbab6d44bdf0413135c51 */
/* Polygon PixelProwler address: 0x141a1fb33683c304da7c3fe6fc6a49b5c0c2dc42 */
/* Polygon MelodyMaven address: 0x20fb7ec336958ea887a288ce49999d7d7c08529c */
/* Polygon EcoGuardian address: 0x9d03ab31c0e71d909c68d3f6bb7483577ba8dcd7 */
with
L AS ( select * from (VALUES
( 'BNB','Pandra King BNB','0xf250bf5953b601e42e93226f7a9e4e8b9e7435af')
-- ( 'BNB','PixelProwler','0x45eb7e752e446db7e7c757b21b26cbc897345843'),
-- ( 'BNB','MelodyMaven','0x917b43b57d25952c1a8ce1af68aec95678d1246e'),
-- ( 'BNB','EcoGuardian','0x1d143f26540c4bf893d74bef4a5d9999987e492b'),
( 'Polygon','Pandra King Polygon','0x216c6bcffa9481af69f8c2f5a6d1095c1f075e92'),
-- ( 'Polygon','PixelProwler','0x141a1fb33683c304da7c3fe6fc6a49b5c0c2dc42'),
-- ( 'Polygon','MelodyMaven','0x20fb7ec336958ea887a288ce49999d7d7c08529c'),
-- ( 'Polygon','EcoGuardian','0x9d03ab31c0e71d909c68d3f6bb7483577ba8dcd7')
) as l1(chain, nft_name, address)),
final_table as
(select nft_to_address as nft_holder,
sum(nft_cnt) as number_nft_holding
from
(select nft_to_address,
sum(nft_count) as nft_cnt
from
(select
NFT_TO_ADDRESS,
count(distinct TOKENID) as nft_count
--max(BLOCK_TIMESTAMP) over (partition by TOKENID) as last_day_transfer
from bsc.nft.ez_nft_transfers
QueryRunArchived: QueryRun has been archived