IBC_insiderUntitled Query
Updated 2022-07-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with t1 as (select ORIGIN_FUNCTION_SIGNATURE, count(ORIGIN_FUNCTION_SIGNATURE) as xxx from ethereum.core.fact_event_logs
WHERE
CONTRACT_ADDRESS=lower('0xf59257e961883636290411c11ec5ae622d19455e')
and
BLOCK_TIMESTAMP>CURRENT_DATE-90
group by ORIGIN_FUNCTION_SIGNATURE
order by xxx desc),
t2 as(
select TEXT_SIGNATURE as "transaction name",xxx as "number of transaction" from t1 a inner join ethereum.core.dim_function_signatures b on a.ORIGIN_FUNCTION_SIGNATURE=b.BYTES_SIGNATURE
order by "number of transaction" desc
)
select * from t2
WHERE
"transaction name"='%swap'
or
"transaction name"='%swap%'
OR
"transaction name"='swap%'
Run a query to Download Data