DataBeingNumber Of Gnosis Safes Over Time
Updated 2022-08-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
⌄
SELECT day, sum(Number_Of_Gnosis_Safes) over (order by day) as Number_Of_Gnosis_Safes
FROM (
SELECT count(*) as Number_Of_Gnosis_Safes, date_trunc('day', block_timestamp) as DAY
FROM ethereum.core.fact_transactions
WHERE origin_function_signature = lower('0x61b69abd') or origin_function_signature = lower('0x1688f0b9') or origin_function_signature = lower('0xd18af54d') and to_address = lower('0x76e2cfc1f5fa8f6a5b3fc4c8f4788f0116861f9b') or
to_address = lower('0x12302fE9c02ff50939BaAaaf415fc226C078613C') or to_address = lower('0xa6B71E26C5e0845f74c812102Ca7114b6a896AB2') or to_address = lower('0x88CD603A5Dc47857D02865BbC7941B588C533263')
or to_address = lower('0x50e55Af101C777bA7A1d560a774A82eF002ced9F')
GROUP BY 2)
ORDER BY 2
/* SELECT block_timestamp, min(date_trunc('day', block_timestamp))fst_date FROM ethereum.core.fact_transactions
WHERE origin_function_signature = lower('0x61b69abd') or origin_function_signature = lower('0x1688f0b9') and to_address = lower('0x76e2cfc1f5fa8f6a5b3fc4c8f4788f0116861f9b') or
to_address = lower('0x12302fE9c02ff50939BaAaaf415fc226C078613C') or to_address = lower('0xa6B71E26C5e0845f74c812102Ca7114b6a896AB2') or to_address = lower('0x88CD603A5Dc47857D02865BbC7941B588C533263')
or to_address = lower('0x50e55Af101C777bA7A1d560a774A82eF002ced9F') GROUP BY 1*/
Run a query to Download Data