kaibladeSmart contract deployments
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
-- SELECT DATE_TRUNC('day', block_timestamp) AS "Days", AVG(tx_fee)
-- FROM ethereum.core.fact_transactions
-- WHERE block_timestamp::date >= CURRENT_DATE() - INTERVAL '24 month'
-- GROUP BY "Days"
WITH raw_data AS
(SELECT *
FROM ethereum.core.fact_event_logs
WHERE event_name ='OwnershipTransferred'
AND event_inputs:previousOwner = '0x0000000000000000000000000000000000000000'
AND block_timestamp::date >= CURRENT_DATE() - INTERVAL '24 month')
SELECT DATE_TRUNC('day', block_timestamp) AS "Days",
COUNT(DISTINCT tx_hash) AS "Deployments"
FROM raw_data
GROUP BY "Days"
Run a query to Download Data