Query editor
WITHUSDC_TRANSFERS AS (SELECTamount / 1000000.00 as amount_normalized,amount,block_time,tx_idFROMtokens_solana.transfersWHEREtoken_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' --USDCAND block_time >= date '2023-01-01'AND block_time < DATE_TRUNC('day', NOW()))selectDATE_TRUNC('month', block_time) as period,casewhen amount_normalized <= 1e1/2 then '<= $5'when amount_normalized > 1e1/2and amount_normalized <= 1e1 then '$5-10'when amount_normalized > 1e1and amount_normalized <= 1e2/2 then '$10-50'when amount_normalized > 1e2/2and amount_normalized <= 1e2 then '$50-100'when amount_normalized > 1e2and amount_normalized <= 1e3 then '$100-1000'when amount_normalized > 1e3 then '> $1000'end as transfer_bucket,count(*) as transfersfromUSDC_TRANSFERSgroup by1,2