kellenFlipside Thorchain Swap Quest: New AVAX Swappers
    Updated 2024-06-20

    with t0 as (
    select pool_name
    , lower(s.from_address) as address
    , min(block_timestamp::date) as first_date
    from thorchain.defi.fact_swaps s
    where block_timestamp >= '2021-01-01'
    and pool_name = 'AVAX.AVAX'
    group by 1, 2
    ), t1 as (
    select *
    , case when address in
    (
    '0x042d21b306d6274c6a12f27b6a94c899d0d0b167'
    , '0x04be6616bb87f0a7bda77c19bb761a7da8d195da'
    , '0x0770457567feaae5dd8ad4d6e441ccd9dc34b44c'
    , '0x085720fd7fcacb6a59340070373ae1660d992769'
    , '0x09715f3a4f72032546fb5a9c0500cb701699763f'
    , '0x09bee2e57d1c0edca7a45b7d8db4a1c5e806a27e'
    , '0x0c3fc56b2b9eb5dc3623a73c1b3787d0f521128c'
    , '0x106c62f52907a8348ce93fe7b265cd36c6c64c47'
    , '0x110c7971aad9188be4bdf7ac28a96b56f7c52df4'
    , '0x11866fe915ad2ed16a1cd45e0c6c648799093f08'
    , '0x19c5899132680d07f87ca9186040d7496a4a8e1d'
    , '0x1aad6f9793bb2ed50f7dc362faf2a71afdc50876'
    , '0x20dc31fe377de1dc5ee837360f3073eee4d3a31e'
    , '0x22c6284526fa0f6b3ec00807517c1f5e67417d48'
    , '0x23d3397345fd4f74d07c748f8a19a68668cf47d5'
    , '0x288d7c57e6a18549d2290f5a1a0eb988ac813418'
    , '0x2f2a2f8e1da4b340c47b4373fdb34799f765804d'
    , '0x2f6eb9d4e5844135543610d6d3fa67ad799ba30b'
    , '0x2f94c5ebd682b14a60d9b8717b073d5434313765'
    , '0x30de50679bc2d653d3af62db835416d250deb578'
    , '0x35abe1ff5a549659bbef0c9c20cbebbf6bc99a33'
    , '0x3c9a9b541db5189b4872a64f1f98d644d1c9604a'
    , '0x3ecbe1eefb004cb694a9c0278a9a1e5613ab3357'
    QueryRunArchived: QueryRun has been archived