pine_samiMonthly MISO Users
    Updated 2022-09-19
    select 'BSC' as chain,
    date_trunc('month', block_timestamp) as date,
    count(distinct ORIGIN_FROM_ADDRESS) as users
    from bsc.core.fact_event_logs
    where (ORIGIN_FUNCTION_SIGNATURE='0x29762960' or ORIGIN_FUNCTION_SIGNATURE='0xdc97e082')
    and EVENT_NAME='AddedCommitment'
    group by 2
    UNION
    select 'Ethereum',
    date_trunc('month', block_timestamp),
    count(distinct ORIGIN_FROM_ADDRESS)
    from ethereum.core.fact_event_logs
    where (ORIGIN_FUNCTION_SIGNATURE='0x29762960' or ORIGIN_FUNCTION_SIGNATURE='0xdc97e082')
    and EVENT_NAME='AddedCommitment'
    group by 2
    UNION
    select 'polygon',
    date_trunc('month', block_timestamp),
    count(distinct ORIGIN_FROM_ADDRESS)
    from polygon.core.fact_event_logs
    where (ORIGIN_FUNCTION_SIGNATURE='0x29762960' or ORIGIN_FUNCTION_SIGNATURE='0xdc97e082')
    and EVENT_NAME='AddedCommitment'
    group by 2
    UNION
    select 'Arbitrum',
    date_trunc('month', block_timestamp),
    count(distinct ORIGIN_FROM_ADDRESS)
    from arbitrum.core.fact_event_logs
    where (ORIGIN_FUNCTION_SIGNATURE='0x29762960' or ORIGIN_FUNCTION_SIGNATURE='0xdc97e082')
    and EVENT_NAME='AddedCommitment'
    group by 2
    UNION
    select 'Avalanche',
    date_trunc('month', block_timestamp),
    count(distinct ORIGIN_FROM_ADDRESS)
    from avalanche.core.fact_event_logs
    Run a query to Download Data