MetricsDAO Course

cryptocatMetricsDAO Course

Updated 2022-12-07

-- SELECT block_timestamp::date, COUNT(block_timestamp::date)

-- FROM ethereum.core.fact_transactions

-- WHERE block_timestamp::date BETWEEN '2020-12-31' AND '2022-10-31'/

-- GROUP BY block_timestamp::date

-- SELECT COUNT(*) FROM (

-- SELECT DISTINCT(from_address,to_address)

-- FROM ethereum.core.fact_transactions

-- WHERE block_timestamp BETWEEN '2022-10-01' AND '2022-10-31')

-- SELECT COUNT(*)

-- FROM ethereum.core.ez_nft_sales

-- WHERE (block_timestamp BETWEEN '2022-10-01' AND '2022-10-31') AND event_type = 'sale'

-- SELECT count(*)

-- FROM ethereum.core.ez_dex_swaps

-- WHERE platform = 'uniswap-v2' AND event_name = 'Swap' AND (block_timestamp::date BETWEEN '2022-10-01' AND '2022-10-31')

-- SELECT platform_name, count(*)

-- FROM ethereum.core.ez_nft_sales

-- WHERE (block_timestamp::date BETWEEN '2022-10-01' AND '2022-10-31') AND event_type='sale'

-- GROUP BY platform_name

-- SELECT COUNT(*)

-- FROM ethereum.core.ez_nft_mints

-- WHERE (block_timestamp::date BETWEEN '2022-10-01' AND '2022-10-31') AND project_name = lower('ens')

-- SELECT pool_name, COUNT(*)

-- FROM ethereum.core.ez_dex_swaps

-- WHERE (block_timestamp::date BETWEEN '2022-10-01' AND '2022-10-31') AND platform = lower('sushiswap')

-- GROUP BY pool_name

Run a query to Download Data

flipside