nitsHow many sponsors
    Updated 2022-06-26
    with tx as
    (SELECT DISTINCT tx_hash from ethereum.core.fact_event_logs
    where contract_address = lower('0xcA69d7aE5F6a5A3FdBB66b2C6cAA1a2928c7CD2f')),
    ctr as
    (SELECT DISTINCT contract_address as contracts
    from ethereum.core.fact_event_logs
    where tx_hash in (SELECT * from tx))

    -- SELECT contract_address, count(DISTINCT tx_hash) as total_calls from
    -- ethereum.core.fact_event_logs
    -- where contract_address in (SELECT * from ctr )
    -- GROUP by 1
    -- ORDER by 2 desc

    -- select date(block_timestamp) as day, sum(amt) as total_amt,
    -- sum( total_amt) over (order by day) as cumulative_amt from
    SELECT date(fu) as day, COUNT(DISTINCT addr) as total_addresses,
    sum(total_addresses) over (order by day) as cumulative_sponsors from
    (SELECT addr, min(block_timestamp) as fu from
    (SELECT *, event_inputs:contributor as addr from ethereum.core.fact_event_logs
    WHERE contract_address in (SELECT * from ctr) and event_name = 'Contribution')
    GROUP by 1 )
    GROUP by 1
    -- order by 3
    -- where tx_hash = '0xebe96fe53b240254306c11e349701aeb31c43bc512ca709f3fb771195fc19809'
    -- limit 100
    Run a query to Download Data