--block_timestamp::date as day,

distinct l.label,

t.TX_FROM as times

--sum(amount) as volume

from solana.fact_transfers t join solana.dim_labels l on t.TX_FROM = l.address

where t.block_timestamp>=CURRENT_DATE-5

and t.mint='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

-- and t.tx_to='9BVcYqEQxyccuwznvxXqDkSJFavvTyheiTYk231T1A8S'

--and l.label_subtype != 'token_contract'

and l.LABEL_TYPE='cex'

-- and l.label != 'solana'

--and t.succeeded = TRUE

group by 1,2