George_lcontracts_from_gitbook copy
Updated 2023-03-22
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
›
⌄
WITH contracts AS (
SELECT *
FROM (values
('inft personality pod: erc-721 contract address', '0xdd70af84ba86f29bf437756b655110d134b5651c', 'https://etherscan.io/address/0xDd70AF84BA86F29bf437756B655110D134b5651C'),
('the revenants', '0xc2d6b32e533e7a8da404abb13790a5a2f606ad75', 'https://etherscan.io/address/0xc2D6B32E533e7A8dA404aBb13790a5a2F606aD75'),
('intelligent nft (inft) protocol smart contract', '0xa189121ee045aeaa8da80b72f7a1132e3b216237', 'https://etherscan.io/address/0xa189121eE045AEAA8DA80b72F7a1132e3B216237'),
('inft protocol intelli-linker smart contract', '0x365b6813bc993748708edc62af72fddfa1b50d7b', 'https://etherscan.io/address/0x365B6813Bc993748708EDc62AF72FDDfA1B50D7b'),
('opensea inft personality pod minter smart contract', '0x86758d1c5ab95ff324f7e0b2cdec38c86eebe768', 'https://etherscan.io/address/0x86758d1c5aB95FF324F7E0b2cDEc38c86eebe768'),
('inft personality pod giveaway winners smart contract', '0x3bdd5ed3532d2bed52e299e21beccd506a8d6258', 'https://etherscan.io/address/0x3bDd5Ed3532d2BeD52e299e21BeCCD506a8d6258'),
('inft personality pod staking smart contract', '0xabeffb353dae4a177057e9a3e4a663386cf54758', 'https://etherscan.io/address/0xAbEffb353dae4A177057e9a3e4A663386cF54758'),
('fixed supply sale', '0xf56f453054a104dafcff4aa9c0cf16936a3a0cb6', 'https://etherscan.io/address/0xf56F453054a104Dafcff4aA9c0CF16936A3A0Cb6'),
('ali token staking smart contract', '0x6820c5a52dbcbd5a4834f553d8b4910dd3439594', 'https://etherscan.io/address/0x6820c5a52dbcbd5a4834f553d8b4910dd3439594'),
('ali token staking proxy smart contract', '0x47302c7e98987fd6c7d6bb6e1a2e6e8e504e6943', 'https://etherscan.io/address/0x47302c7e98987fd6c7d6bb6e1a2e6e8e504e6943'),
('arkiv: erc-721 contract address', '0xce69a87c02baa8c5f17ed7eb8b1c2657afc2e1af', 'https://etherscan.io/address/0xcE69a87C02bAA8C5F17Ed7eB8B1C2657aFC2E1aF'),
('opensea arkiv minter: erc-721 contract address', '0x437684f7357bdda8328e629eaa595c9f23060aac', 'https://etherscan.io/address/0x437684F7357BddA8328e629EAa595c9F23060AaC'),
('arkiv giveaway winners smart contract', '0xf5194433bde2bece5c3ac294eca78a1126c169cf', 'https://etherscan.io/address/0xF5194433bde2beCE5c3ac294EcA78a1126c169CF')
AS a (contract_name, contract_address, etherscan_link)
)
)
SELECT nft_address, project name, nft_to_address
FROM ethereum.core.ez_nft_transfers
WHERE nft_to_addre
Run a query to Download Data