sinahosseinzadehUntitled Query
Updated 2022-08-30
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT COUNT(*)
, SUM(nft.price) AS eth_vol
, SUM(nft.price*t.price) AS usd_vol
FROM ethereum.core.ez_nft_sales nft
JOIN ethereum.core.fact_hourly_token_prices t
ON hour = DATE_TRUNC('HOUR', block_timestamp)
WHERE token_address ilike '0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2'
AND nft_address = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
AND block_timestamp::DATE >= '2022-01-01'
Run a query to Download Data