flipside

adele23NFT Transfers

Updated 2025-03-10

-- general starting table for NFT mints

-- select

-- block_timestamp,

-- tx_hash,

-- nft_from_address,

-- nft_to_address,

-- nft_address,

-- tokenid,

-- project_name

-- from ethereum.nft.ez_nft_transfers

-- where nft_address = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') -- pudgy

-- order by block_timestamp asc

-- limit 10

-- nft mints

-- nft transfers

-- 0x0000000000000000000000000000000000000000 is the address that you first get the nft or token first.

-- use this address above to see all addresses who minted first.

-- how to see everyone who minted

-- with raw as

-- (select

-- block_timestamp,

-- tx_hash,

-- nft_from_address,

-- nft_to_address,

-- nft_address,

-- tokenid,

-- project_name

-- from ethereum.nft.ez_nft_transfers

-- where nft_address = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8') -- pudgy

-- and nft_from_address = '0x0000000000000000000000000000000000000000'

-- order by block_timestamp asc

-- )

Last run: 20 days ago

	NFT_TO_ADDRESS	HOLDINGS
1	0xab45160c38e9781347fad728b7331e2601812198	1
2	0x983cb6a03b921cb3fa09808d06b3ad59e8822d2e	3
3	0x40962b448aa899196906646340cb4eb61a8d49b4	3
4	0xbb10a4cfbad91566b48944ebbf7292a55b484ae6	1
5	0xd3b3c6465beda6f5722dfc5348f3593fa0165750	1
6	0x6779ef3c2a8e48797c3ee3f8a54e61d64a2e8fe8	1
7	0x933c6d65bac2dc3d49470dc8bdf7e2df689c58d2	1
8	0xe4d7811fc629c6630826fa3164fc838aa36bcc4a	7
9	0xc17aedb8070d726d2a68c2c8163612721ef2b0ec	1
10	0xe043a67f8d78a7afee93fa700e718cec0d99edf3	4
11	0x9978e58f72c02462b59908ba4d7ec67d7f2f0b6d	2
12	0xcdf63fc907241fb3d1fbae13f173127ec55731a3	3
13	0x201eec84a2992685b689849844b3bcfba3e56e85	10
14	0xa9a620a02425716b0173f287c69aa825da7395b8	2
15	0x5620afa09991ef3a87d29c5ff3c550e5c898f5c7	1
16	0xcab8736dbe52971e33e54d095e299bcced2012a2	4
17	0x9d44c49df2cb83f7009ad5854878f88a623f3634	5
18	0x33f6ad7d3fe4c01d41d25cb18e720d1277f50563	2
19	0xd9e912afcea495dc8789bd2d6c0004473e48521f	8
20	0x809c5c20331997000711026400653e82a5b545e2	1

...

4943

237KB

5s