primo_datapolygon_nft_txns_price
Updated 2022-07-15
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
›
⌄
select price.dt, price.price, nft.ct
FROM
(
SELECT date(hour) as dt, avg(price) as price
from flipside_prod_db.ethereum_core.fact_hourly_token_prices
where symbol='MATIC'
and dt >= date('2021-06-01')
GROUP BY 1
) price
left join
(
-- Daily NFT Transaction on Polygon
select date(block_timestamp) dt, count(distinct tx_id) ct
from flipside_prod_db.polygon.transactions
where block_timestamp >= date('2021-06-01')
and to_label_type = 'nft'
group by 1
) nft
on price.dt = nft.dt
Run a query to Download Data