m0rt3zaMISO - BSC users over time
    Updated 2022-09-19
    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