select *

from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')),

holders as (

select * from

(select user, contract, sum(amount) as balance

from

(

select from_address as user, -RAW_AMOUNT_PRECISE as amount, tx_hash, contract

from polygon.core.fact_token_transfers

join tokens_data b

on contract=CONTRACT_ADDRESS

where BLOCK_TIMESTAMP::date>=start_date

and BLOCK_TIMESTAMP<date_trunc(hour, '2025-03-17 18:00:00.000'::timestamp)

union all

select to_address, RAW_AMOUNT_PRECISE, tx_hash, contract

from polygon.core.fact_token_transfers

join tokens_data

on contract=CONTRACT_ADDRESS

where BLOCK_TIMESTAMP::date>=start_date

and BLOCK_TIMESTAMP<date_trunc(hour, '2025-03-17 18:00:00.000'::timestamp))

group by 1,2)

where balance>0

select b.symbol, a.contract, count(*) as users, sum(balance/pow(10, decimal)) as supply, round

from holders a

join tokens_data b

on a.contract=b.contract

where balance/pow(10, decimal)>=0.00000001

and user!='0x000000000000000000000000000000000000dead'

group by 1,2, round