CryptoGowdaDaily xMetric Transfers from Treasury
    Updated 2023-12-21
    with
    token_transfers as (
    select
    date_trunc('day', block_timestamp) as day,
    sum(raw_amount / pow(10, 18)) as daily_transfer
    from
    polygon.core.fact_token_transfers
    where
    from_address = '0x0000000000000000000000000000000000000000'
    and contract_address = lower('0x15848C9672e99be386807b9101f83A16EB017bb5')
    group by
    day
    )
    select
    *,
    sum(daily_transfer) over (
    order by
    day
    ) as cumulative_xMetric_transferred
    from
    token_transfers