superflyUntitled Query
    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