*,

sum(net_dust) over (ORDER BY day) as cume_dust,

100 * (net_dust / 33000000) as net_dust_percent,

100 * ((sum(net_dust) over (ORDER BY day)) / 33000000) as cume_dust_percent

FROM (

SELECT

date_trunc('day', block_timestamp) AS day,

sum(CASE WHEN tx_to LIKE 'AxFuniPo7RaDgPH6Gizf4GZmLQFc4M5ipckeeZfkrPNn' THEN amount else -1 * amount end) as net_dust

FROM solana.core.fact_transfers

WHERE mint LIKE 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'

AND (tx_to LIKE 'AxFuniPo7RaDgPH6Gizf4GZmLQFc4M5ipckeeZfkrPNn' OR tx_from LIKE 'AxFuniPo7RaDgPH6Gizf4GZmLQFc4M5ipckeeZfkrPNn')

GROUP BY 1