intellidegentJadu Air Drops
Updated 2022-12-12
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 TOTALS AS (
SELECT
CASE WHEN nft_address = lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71') THEN 'Jadu Ava Free Mint'
WHEN nft_address = lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf') THEN 'Jadu Jetpack Free Mint'
WHEN nft_address = lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8') THEN 'Jadu Hoverboard Free Mint'
END AS "Project",
COUNT(TX_HASH) AS "Transactions",
to_number(SUM(MINT_PRICE_USD),10,0) AS "USD Mint Sales",
to_number("USD Mint Sales"/"Transactions",10,0) as "Avg USD Price",
to_number(SUM(MINT_PRICE_ETH),10,0) AS "Eth Mint Sales",
to_number(SUM(TX_FEE),10,0) 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 "Project"
UNION
SELECT
CASE WHEN nft_address = lower('0x86fc6f6c6702ceF7d3BaE87eF41256715416DB71') THEN 'Jadu Ava Sale'
WHEN nft_address = lower('0xd0f0c40fcd1598721567f140ebf8af436e7b97cf') THEN 'Jadu Jetpack Sale'
WHEN nft_address = lower('0xeDa3b617646B5fc8C9c696e0356390128cE900F8') THEN 'Jadu Hoverboard Sale'
END AS "Project",
COUNT(TX_HASH) AS "Transactions",
to_number(SUM(MINT_PRICE_USD),10,0) AS "USD Mint Sales",
to_number("USD Mint Sales"/"Transactions",10,0) as "Avg USD Price",
to_number(SUM(MINT_PRICE_ETH),10,0) AS "Eth Mint Sales",
to_number(SUM(TX_FEE),10,0) 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 "Project"
Run a query to Download Data