akshaymahajanpolygon AXL holders
    Updated 2023-08-10
    WITH RECURSIVE
    DateSequence AS (
    SELECT
    0 AS seq,
    DATEADD(DAY, 0, '2022-08-29') AS date
    UNION ALL
    SELECT
    seq + 1,
    DATEADD(DAY, seq + 1, '2022-08-29')
    FROM
    DateSequence
    WHERE
    seq < (
    SELECT
    DATEDIFF(DAY, '2022-08-29', CURRENT_TIMESTAMP)::int
    )
    ),
    distinct_wallets as (
    select distinct
    to_address
    from
    polygon.core.ez_token_transfers
    where
    contract_address = lower('0x6e4E624106Cb12E168E6533F8ec7c82263358940')
    ),
    wallets_dates as (
    SELECT
    date,
    to_address as address,
    0 as balance
    FROM
    DateSequence as t1
    cross join distinct_wallets as t2
    ),
    daily_change as (
    select