shadilSablier streams that cancelled before their stop time
    Updated 2022-04-21
    with first_query as
    (select count(tx_hash) as total_created
    from ethereum_core.fact_event_logs
    where event_name = 'CreateStream'
    and contract_address = '0xcd18eaa163733da39c232722cbc4e8940b1d8888')
    select count(ethereum_core.fact_event_logs.tx_hash) as total_cancelled
    from ethereum_core.fact_event_logs join ethereum_core.fact_event_logs secnd
    on (secnd.event_name = 'CancelStream'
    and secnd.block_timestamp < ethereum_core.fact_event_logs.event_inputs:startTime
    and secnd.event_inputs:streamId = ethereum_core.fact_event_logs.event_inputs:streamId
    and secnd.block_timestamp >= ethereum_core.fact_event_logs.block_timestamp
    and ethereum_core.fact_event_logs.event_inputs:stopTime > secnd.block_timestamp)
    where ethereum_core.fact_event_logs.event_name = 'CreateStream'
    and ethereum_core.fact_event_logs.contract_address = '0xcd18eaa163733da39c232722cbc4e8940b1d8888'

    Run a query to Download Data