samUntitled Query
Updated 2022-08-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
⌄
/*with functions as (
select
array_agg(distinct origin_function_signature) within group (order by origin_function_signature asc) as list
from avalanche.core.fact_event_logs
where block_timestamp::date >= '2022-08-01'
and contract_address = lower('0x9e295B5B976a184B14aD8cd72413aD846C299660')
and event_inputs:from = '0x0000000000000000000000000000000000000000'
)
select*
from avalanche.core.fact_event_logs
where origin_function_signature in (select list[1] from functions)
and contract_address = lower('0x9e295B5B976a184B14aD8cd72413aD846C299660')
and event_inputs:from = '0x0000000000000000000000000000000000000000'
limit 10
*/
select* from avalanche.core.fact_event_logs
where block_timestamp::date = '2022-08-01'
and tx_hash = lower ('0x9793b954c13422489dbca919b0e18c3065d81546b8112764e85918fe96d402d9')
Run a query to Download Data