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

ethereum.core.fact_transactions

WHERE

TO_ADDRESS IN (

'0x3fa9f416955fb4a27f6f2bf617ecbe609baa9c4c',

'0xa0d31c1fb382a4b33f57b95ab09f1a7115d11138',

'0x035dc7dd0e90de650bc8b94196a5419e33b08207',

'0x767fe9edc9e0df98e07454847909b5e959d7ca0e',

'0x98c7c18e1b1379fd9135ec82593c902891ca0c76',

'0x9dca38d109c6c69790fb70bcfdeaf27c4394597c',

'0x57980520ea663a63184d9a16766396d5c5424406',

'0x487e58fe51af1e6fcb1c95aefdac68394a173032',

'0xf5df4f4bb2cc79949b37a0a7ea7ce09248b3233c',

'0x8b4d8443a0229349a9892d4f7cbe89ef5f843f72',

'0xa1b1c05b3d00e5803c1c502d9175f3e39fe5a8c6',

'0x6b72209b2514940606910dd9ad309ee1e5e201c6',

'0xb901614d588ef8db45045ffbb2145e1c36cbf8b9',

'0x5e49e4710686d43c409a3286d4459b148609966e',

'0x53aff3b5059a48e4ee37e63c03e3ad563756d6e1',

'0xe8d3c555d4f984a81bf9ab43cbd4e71acd73fb00',

'0xdb0a2a38f30a3f43fbfae98c85b132702df20cb3',

'0x7f5f854ffb6b7701540a00c69c4ab2de2b34291d',

'0xa904f27b1de7e82ba587677ee1f5af0ad0a8c79a',

'0x25121eddf746c884dde4619b573a7b10714e2a36',

'0x9e0d99B864E1Ac12565125c5a82B59adEa5a09Cd',

'0x384aa03d8b7cc6a818e7cb7a037ba0cd81af9fdf'

)

GROUP BY

Day

),