NavidCopy of Copy of Copy of Untitled Query
Updated 2022-11-07Copy Reference Fork
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
›
⌄
with collection_mints as (
select
case
when NFT_ADDRESS='0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers'
when NFT_ADDRESS='0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' then 'CryptoPunks'
when NFT_ADDRESS='0xe4d20bc4a845aa35b008f5f9f85e50b581df7263' then 'HUGO x Imaginary Ones'
when NFT_ADDRESS='0xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7' then 'Zora'
when NFT_ADDRESS='0x60e4d786628fea6478f785a6d7e704777c86a7c6' then 'Mutant Ape Yacht Club'
when NFT_ADDRESS='0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7' then 'Meebits'
when NFT_ADDRESS='0xdcb8d9a2a65a006fafeec5695e288b711762d3e4' then 'HEXGO'
when NFT_ADDRESS='0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' then 'Bored Ape Yacht Club'
when NFT_ADDRESS='0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b' then 'CLONE X - X TAKASHI MURAKAMI'
when NFT_ADDRESS='0xb9e5717e6d547ebaad8b8b34fcd990bd007168a7' then 'Jack Atomy'
end as collection,
MINT_PRICE_ETH,
MINT_PRICE_USD,
tx_hash
from
ethereum.core.ez_nft_mints
where
NFT_ADDRESS in (
'0x60bb1e2aa1c9acafb4d34f71585d7e959f387769',
'0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb',
'0xe4d20bc4a845aa35b008f5f9f85e50b581df7263',
'0xabefbc9fd2f806065b4f3c237d4b59d9a97bcac7',
'0x60e4d786628fea6478f785a6d7e704777c86a7c6',
'0x7bd29408f11d2bfc23c34f18275bbf23bb716bc7',
'0xdcb8d9a2a65a006fafeec5695e288b711762d3e4',
'0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d',
'0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b',
'0xb9e5717e6d547ebaad8b8b34fcd990bd007168a7'
) and
block_timestamp > CURRENT_DATE-7
)
select
collection,
Run a query to Download Data