shadilSablier streams that cancelled before their stop time
Updated 2022-04-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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