alirsOptimistic Bears-part-03
    Updated 2022-08-10
    with dex as
    (SELECT * from optimism.core.dim_labels
    where label_type = 'dex')

    SELECT date(block_timestamp) as Date, project_name, count(DISTINCT tx_hash) as total_txs,
    sum(total_txs) over (partition by project_name order by Date) as cumulative_txs
    from optimism.core.fact_event_logs

    inner join dex on contract_address = address
    where Date>='2022-07-01' and Date <='2022-07-30'
    GROUP by Date, project_name
    Run a query to Download Data