scottincryptoAave BGD Payments Stream
Updated 2022-10-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
select
block_timestamp
, 'Stream Creation'
, contract_address
, event_inputs:deposit / 1e18 as amt
, *
from ethereum.core.fact_event_logs
where contract_address in (lower('0x25f2226b597e8f9514b3f68f00f494cf4f286491'), lower('0x467b92af281d14cb6809913ad016a607b5ba8a36'))
and event_name = 'CreateStream'
and block_timestamp > '2022-05-01'
-- Can't find stream events for Collector 0x467b92af281d14cb6809913ad016a607b5ba8a36
-- select
-- distinct
-- contract_address
-- , event_name
-- , origin_function_signature
-- , topics[0]
-- from ethereum.core.fact_event_logs
-- where contract_address in ('0x3d569673dAa0575c936c7c67c4E6AedA69CC630C')
-- -- and event_name = 'CreateStream'
-- and block_timestamp > '2022-05-01'
-- CreateStream(uint256,address,address,uint256,address,uint256,uint256) '0x7b01d409597969366dc268d7f957a990d1ca3d3449baf8fb45db67351aecfe78'
Run a query to Download Data