superflyUntitled Query
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
safes as (
SELECT
contract_address as safe_address,
evt_block_time as date_created,
evt_block_number as block_number,
evt_tx_hash as tx_hash,
explode(owners) as signatories
FROM
ethereum.core.fact_traces WHERE evt_block_time >= '2022-02-09' -- gip 29 posted on forum
AND evt_block_time <= '2022-08-18' -- new cut off date
),
creator as (
SELECT
et.`from` as creator,
s.safe_address,
date_trunc('day', s.date_created) as day,
s.tx_hash,
s.signatories
FROM
safes s
INNER JOIN
ethereum.core.fact_traces et
ON s.block_number = et.block_number
AND s.date_created = et.block_time
AND s.tx_hash = et.hash
AND et.block_time >= '2022-02-09'
AND et.block_time <= '2022-08-18'
AND et.`to` = LOWER('0xa6b71e26c5e0845f74c812102ca7114b6a896ab2')
WHERE et.block_time >= '2022-02-09'
AND et.block_time <= '2022-08-18'
),
multiple_safes as (
Run a query to Download Data