m0rt3zaMISO - BSC users over time
Updated 2022-09-19Copy 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
›
⌄
WITH markets AS (
SELECT
event_inputs:addr as market_address
FROM bsc.core.fact_event_logs
WHERE origin_to_address = '0x5629ce74ddcad7cc72b3ea30444da7172ad851d9'
AND event_name = 'MarketCreated'
), txs AS (
SELECT
b.block_timestamp,
b.from_address as user,
b.tx_hash,
a.*
FROM markets as a JOIN bsc.core.fact_transactions as b on a.market_address = b.to_address
)
SELECT
date_trunc('Week', block_timestamp) as week,
date_trunc('Month', block_timestamp) as month,
count(DISTINCT tx_hash) as "Transaction Count",
count(DISTINCT user) as "User Count"
FROM txs
WHERE block_timestamp > '2022-04-20'
GROUP BY week, month
Run a query to Download Data