cristinatintoKaiaswap User List
    Updated 2024-07-27

    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