binhachonSablier Cash Streams - Total cancelled
    Updated 2022-04-20
    with cancel_transactions as (
    select
    distinct
    block_timestamp,
    tx_hash,
    event_inputs:streamId::float as streamId
    from ethereum_core.fact_event_logs
    where 1=1 --tx_hash = '0x5aece6272ec939c4647bccbe9020542e00037cf1d18aea999f5ef265b8013f91'
    and event_name = 'CancelStream'
    and contract_name = 'Sablier'
    )
    select count(*) from cancel_transactions
    Run a query to Download Data