adambala123.
Updated 2022-11-02
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
›
⌄
⌄
/*Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.
Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.*/
with mint_tokenid as (
select
tokenid
from ethereum.core.ez_nft_mints
where nft_address = lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')
),
transfers_date as (
select
distinct block_timestamp::date as day
from ethereum.core.ez_nft_transfers
where nft_address = lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')
),
mint_x_transfers_date as (
select* from mint_tokenid cross join transfers_date
),
mint_tx as (
select
tx_hash from ethereum.core.ez_nft_mints
where nft_address = lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')
),
minters as (
select
tokenid,
nft_to_address as minters_address
from ethereum.core.ez_nft_mints
where nft_address = lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')
),
raw_transfers as (
select
Run a query to Download Data