intellidegentJadu
Updated 2022-12-05
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
›
⌄
SELECT
DATE_TRUNC('week', block_timestamp) as "Week",
event_type as "Event Type",
CASE WHEN nft_address = lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71') THEN 'Jadu Ava'
WHEN nft_address = lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf') THEN 'Jadu Jetpack'
WHEN nft_address = lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8') THEN 'Jadu Hoverboard'
END AS "Project",
COUNT(TX_HASH) AS "Transactions",
SUM(MINT_PRICE_USD) AS "USD Mint Sales",
"USD Mint Sales"/"Transactions" as "Avg USD Price",
SUM(MINT_PRICE_ETH) AS "Eth Mint Sales",
SUM(TX_FEE) AS "Transaction Fees",
MIN(MINT_PRICE_USD) AS "Lowest USD",
MAX(MINT_PRICE_USD) AS "Highest USD"
FROM ethereum.core.ez_nft_mints
WHERE nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))
--AND "MINT_PRICE_USD" < 1
GROUP BY "Week", "Event Type", "Project"
ORDER BY "Week"
select distinct(project_name)
from ethereum.core.ez_nft_mints
WHERE nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))
order by project_name
select event_type, count(event_type)
from ethereum.core.ez_nft_transfers
WHERE nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))
group by event_type
select event_type, count(event_type)
from ethereum.core.ez_nft_sales
WHERE nft_address IN (lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71'), lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf'), lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8'))
group by event_type
Run a query to Download Data