cristinatintoKaiaswap User List
Updated 2024-07-27
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select distinct origin_from_address as "User",
min(trunc(block_timestamp,'day')) as "Debut",
count(distinct tx_hash) as "Total swaps",
count (distinct trunc(block_timestamp,'day')) as "Active Days"
from kaia.core.fact_event_logs
where
origin_function_signature='0xac9650d8' and origin_to_address='0x3ef68d3f7664b2805d4e88381b64868a56f88bc4'
group by 1
order by 3 desc, 4 desc
QueryRunArchived: QueryRun has been archived