nitsMATIC bridge then what
Updated 2022-01-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select contract_address, count(*) as most_interactions, avg(diff_in_minutes) as avg_time_in_minutes,avg_time_in_minutes/60 as avg_time_in_hr, avg_time_in_hr/24 as avg_time_in_days from (select *, timestampdiff(SQL_TSI_MINUTE, deposit_time, block_timestamp) as diff_in_minutes from
(select *, row_number() over (partition by origin_address order by block_timestamp) as rn
from (select block_timestamp as deposit_time, origin_address as address from polygon.udm_events
where (contract_address = '0xe6469ba6d2fd6130788e0ea9c0a0515900563b59' or contract_address = '0x9cd6746665d9557e1b9a775819625711d0693439')and
contains(origin_function_name, 'swap'))
inner join polygon.udm_events
on origin_address = address and deposit_time < block_timestamp )
where rn = '1' )
where contract_address is not NULL
group by contract_address
order by most_interactions desc
limit 10
Run a query to Download Data