DailyTransactions AS (

SELECT

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS Day,

COUNT(DISTINCT FROM_ADDRESS) AS Unique_Addresses,

COUNT(DISTINCT TX_HASH) AS Unique_Txs

FROM

bsc.core.fact_transactions

WHERE

TO_ADDRESS IN (

'0x5cc9af3deaac89764eb98b0513e8d938d90b073d',

'0x3203c9e46ca618c8c1ce5dc67e7e9d75f5da2377',

'0x85c128ee1feeb39a59490c720a9c563554b51d33',

'0xae5f14a9aed2b56121fb964a84a9dff114296563',

'0xdad49e63f97c967955975490a432de3796c699e6',

'0x4eededfe89dad70ab8cbf70e4dd140ff8e6e8ce5',

'0xb3e968ba01a78ea489292130bcf8bbe6a64be648',

'0x3bd6a582698eccf6822db08141818a1a8512c68d',

'0xcb0cffc2b12739d4be791b8af7fbf49bc1d6a8c2',

'0x1da9b6e37f006dd349089dea21cb8261391593d5',

'0x886224d26b235e827958645657f3881ac5cbdf9f',

'0x970093b4167261985621e6f2dc738d2e78ce6ac2',

'0x5bb4d72db22dc38958696bd5db9273f142bbb217',

'0x868f91588e4890f5e03f27b7ede7183be2e942e0',

'0x1846c0ab8d09007154066cbb114315e11d94d4e8',

'0xa66ed7aeb38ca1cb063ad3fdcca351de2d3e17e0',

'0x5fb3035d07e5d0e1d8efbc5ae5b7546c15173035',

'0xf91d6e71f6d9e6dbffe92597ce0fdd76058c49a7',

'0x819e97c7da2c784403b790121304db9e6a038de9',

'0xb4986e78ebbc09badf2d1c200c6300aace6c2d4f',

'0x63e760960333931fc75eabb0860a00991f21d91f',

'0x4cad08ca7a8bab80ceda046de39c042a9cc59c3f',

'0xc9c71db791fae54f19002341e988dd56d4b5cf42',

'0xd03fd9197c55ecd06cb6fbd8b5e554c36674126e',

'0xf03eafef2dd2061ec2d1f541b4700c66793431c5',

'0x9377d04f61af8ab51bbc4a03495e3dcaacc59249',