MONTH | CHAIN | Transactions | Cumulative transactions | |
|---|---|---|---|---|
1 | 2022-06-01 00:00:00.000 | Polygon | 1593 | 1593 |
2 | 2022-07-01 00:00:00.000 | Polygon | 7784 | 9377 |
3 | 2022-08-01 00:00:00.000 | Polygon | 6966 | 16343 |
4 | 2022-09-01 00:00:00.000 | Polygon | 7235 | 23578 |
5 | 2022-10-01 00:00:00.000 | Polygon | 6125 | 29703 |
6 | 2022-11-01 00:00:00.000 | Polygon | 722 | 30425 |
7 | 2022-12-01 00:00:00.000 | Polygon | 788 | 31213 |
8 | 2023-01-01 00:00:00.000 | Polygon | 901 | 32114 |
9 | 2023-02-01 00:00:00.000 | Polygon | 675 | 32789 |
10 | 2023-03-01 00:00:00.000 | Polygon | 860 | 33649 |
11 | 2023-04-01 00:00:00.000 | Polygon | 867 | 34516 |
12 | 2023-05-01 00:00:00.000 | Polygon | 748 | 35264 |
13 | 2023-06-01 00:00:00.000 | Polygon | 141 | 35405 |
14 | 2023-07-01 00:00:00.000 | Polygon | 1158 | 36563 |
15 | 2023-08-01 00:00:00.000 | Polygon | 1346 | 37909 |
16 | 2023-09-01 00:00:00.000 | Polygon | 711 | 38620 |
17 | 2023-10-01 00:00:00.000 | Polygon | 702 | 39322 |
18 | 2023-11-01 00:00:00.000 | Polygon | 368 | 39690 |
19 | 2023-12-01 00:00:00.000 | Polygon | 234 | 39924 |
20 | 2024-01-01 00:00:00.000 | Polygon | 14 | 39938 |
Flipside TeamTotal activity
Updated 9 days ago
999
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
›
⌄
With ethereum as (SELECT
date_trunc('month', BLOCK_TIMESTAMP) as month,
'Ethereum' as chain,
count(*) as no_txn
from ethereum.core.fact_transactions
where TO_ADDRESS in (
SELECT
DECODED_LOG:multisig as multisig
from ethereum.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0x48b6af7b12c71f09e2fc8af4855de4ff54e775ca'
and CONTRACT_NAME = 'Service Registry'
and EVENT_NAME = 'CreateMultisigWithAgents'
)
group by 1
),
polygon as (SELECT
date_trunc('month', BLOCK_TIMESTAMP) as month,
'Polygon' as chain,
count(*) as no_txn
from Polygon.core.fact_transactions
where TO_ADDRESS in (
SELECT
DECODED_LOG:multisig as multisig
from Polygon.core.ez_decoded_event_logs
where CONTRACT_ADDRESS = '0xe3607b00e75f6405248323a9417ff6b39b244b50'
and CONTRACT_NAME = 'Service Registry L2'
and EVENT_NAME = 'CreateMultisigWithAgents'
)
group by 1),
gnosis as (SELECT
date_trunc('month', BLOCK_TIMESTAMP) as month,
'Gnosis' as chain,
Last run: 9 days ago
100
5KB
153s