pine_samiMonthly MISO Users
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
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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