SELECT

ORIGIN_FROM_ADDRESS,

TX_HASH,

AMOUNT,

DATE_TRUNC('{{granularity }}', BLOCK_TIMESTAMP) AS date

FROM base.core.ez_token_transfers

WHERE CONTRACT_ADDRESS IN (

LOWER('0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'),

LOWER('0xb79dd08ea68a908a97220c76d19a6aa9cbde4376'),

LOWER('0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca'),

LOWER('0x4621b7a9c75199271f773ebd9a499dbd165c3191'),

LOWER('0x50c5725949a6f0c72e6c4a641f24049a917db0cb'),

LOWER('0x417ac0e078398c154edfadd9ef675d30be60af93'),

LOWER('0xfde4c96c8593536e31f229ea8f37b2ada2699bb2'),

LOWER('0xca72827a3d211cfd8f6b00ac98824872b72cab49'),

LOWER('0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'),

LOWER('0xcfa3ef56d303ae4faaba0592388f19d7c3399fb4'),

LOWER('0x60a3e35cc302bfa44cb288bc5a4f316fdb1adb42')

)

AND LOWER(FROM_ADDRESS) <> '0x0000000000000000000000000000000000000000'

AND LOWER(TO_ADDRESS) <> '0x0000000000000000000000000000000000000000'

SELECT

date,

SUM(f.AMOUNT) AS transfer_volume,

COUNT(f.TX_HASH) AS transactions,

COUNT(DISTINCT f.ORIGIN_FROM_ADDRESS) AS active_addresses,

FROM tf f

GROUP BY date

ORDER BY date DESC;