Query editor
SELECTDATE(block_time) AS day,APPROX_DISTINCT("to") AS holdersFROM tokens_bnb.transfersWHERE contract_address = 0xBedD3af0DcE80EDE8468fDA671DC54c921f4AE00AND block_time >= NOW() - INTERVAL '30' DAYGROUP BY 1ORDER BY 1
Query editor
1SELECT2DATE(block_time) AS day,3APPROX_DISTINCT("to") AS holders45FROM tokens_bnb.transfers67WHERE contract_address = 0xBedD3af0DcE80EDE8468fDA671DC54c921f4AE008AND block_time >= NOW() - INTERVAL '30' DAY910GROUP BY 111ORDER BY 1