WITH daily_transfers AS (

SELECT

DATE_TRUNC('day', block_timestamp) AS "Date",

SUM(amount_usd) AS "Daily Volume USD",

SUM(amount) AS "Daily LPT Volume",

COUNT(DISTINCT tx_hash) AS "Number of Transfers",

COUNT(DISTINCT from_address) AS "Unique Senders",

COUNT(DISTINCT to_address) AS "Unique Receivers"

FROM ethereum.core.ez_token_transfers

WHERE contract_address = LOWER('0x58b6a8a3302369daec383334672404ee733ab239')

AND block_timestamp >= CURRENT_DATE - INTERVAL '30 days'

AND amount IS NOT NULL

AND amount > 0

AND amount_usd IS NOT NULL

GROUP BY 1

SELECT

"Date",

"Daily Volume USD",

"Daily LPT Volume",

"Number of Transfers",

"Unique Senders",

"Unique Receivers",

"Daily Volume USD" / "Number of Transfers" AS "Average Transfer Size USD"

FROM daily_transfers

ORDER BY "Date" DESC;