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

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)

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

group by 1,2, round