ArioThe Typical Minter - GodMode Status
Updated 2022-06-09
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
list_of_users as (
select
BLOCK_TIMESTAMP,
NFT_TO_ADDRESS as Users
from flipside_prod_db.ethereum_core.ez_nft_mints
where NFT_ADDRESS = '0x903e2f5d42ee23156d548dd46bb84b7873789e44'
and EVENT_TYPE = 'nft_mint'
and MINT_PRICE_ETH != 0
and NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
and block_timestamp between '2022-06-07 16:00:00.000' and '2022-06-07 17:00:00.000'
),
Minters as (
select distinct nft_to_address as minter
from ethereum.core.ez_nft_mints m join list_of_users l on m.nft_to_address = l.Users
where m.BLOCK_TIMESTAMP > current_date - 180
and m.BLOCK_TIMESTAMP < '2022-06-07'
),
nft_buyers as (
select distinct origin_from_address as nft_buyer
from ethereum.core.ez_nft_sales es join list_of_users l on es.origin_from_address = l.Users
where es.BLOCK_TIMESTAMP > CURRENT_DATE - 180
),
Swappers as (
select distinct origin_from_address as swapper
from ethereum.core.ez_dex_swaps s join list_of_users l on s.origin_from_address = l.Users
where s.BLOCK_TIMESTAMP > CURRENT_DATE - 180
),
final_table as (
select
Users,
minter,
nft_buyer,
swapper
from list_of_users