adambalanear.,
Updated 2022-10-22Copy 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 INFO as
(select
TX_HASH ,
BLOCK_TIMESTAMP ,
TX_SIGNER AS MINTER ,
PROJECT_NAME ,
NETWORK_FEE AS FEE,
AVG(PRICE_USD) * NETWORK_FEE AS FEE_USD,
'NEAR'as title
FROM near.core.ez_nft_mints INNER JOIN near.core.fact_prices ON BLOCK_TIMESTAMP::DATE =TIMESTAMP ::DATE
where METHOD_NAME ='nft_mint' AND SYMBOL ='wNEAR'
GROUP BY 1,2,3,4,5
union
select
TX_HASH ,
BLOCK_TIMESTAMP ,
NFT_TO_ADDRESS AS MINTER,
PROJECT_NAME ,
TX_FEE AS FEE,
TX_FEE *AVG(PRICE) AS FEE_USD ,
'Ethereum'as title
FROM ethereum.core.ez_nft_mints INNER JOIN ethereum.core.fact_hourly_token_prices
ON HOUR::DATE =BLOCK_TIMESTAMP::DATE
where EVENT_TYPE='nft_mint' AND SYMBOL='WETH'
GROUP BY 1,2,3,4,5
)
select
title ,
Run a query to Download Data