adriaparcerisasaverage optimism portfolio 2
    Updated 2022-11-09
    SELECT
    trunc(block_timestamp,'month') as month,
    y.LABEL_TYPE as platform,
    y.LABEL_SUBTYPE as action,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as wallets,
    COUNT(DISTINCT tx_hash) as txs
    FROM optimism.core.fact_event_logs x
    JOIN optimism.core.dim_labels y ON address = origin_to_address
    WHERE TX_STATUS = 'SUCCESS' AND contract_address = '0x4200000000000000000000000000000000000042'
    GROUP BY 1,2,3
    ORDER BY 1,2,3
    Run a query to Download Data