maybeyonassablier_streams_stop
    Updated 2022-04-21
    with
    stream_created as (
    select
    block_timestamp,
    event_inputs:sender::string as user,
    event_inputs:streamId::string as stream_id,
    event_inputs:startTime::string as start_time,
    event_inputs:stopTime::string as stop_time,
    event_inputs:deposit::string as amount
    from ethereum_core.fact_event_logs
    where contract_address = lower('0xCD18eAa163733Da39c232722cBC4E8940b1D8888')
    and event_name = 'CreateStream'
    ),
    stream_cancel as (
    select
    block_timestamp,
    event_inputs:sender::string as user,
    event_inputs:streamId::string as stream_id,
    event_inputs:senderBalance::string as balance_left
    from ethereum_core.fact_event_logs
    where contract_address = lower('0xCD18eAa163733Da39c232722cBC4E8940b1D8888')
    and event_name = 'CancelStream'
    )
    select
    'streams created' as type,
    count(stream_id) as streams
    from stream_created

    union all

    select
    'streams cancelled' as type,
    count(stream_id) as streams
    from stream_cancel

    Run a query to Download Data