block_timestamp::date AS day,

count(tx_id) AS transactions,

count(DISTINCT sender) AS senders,

count (DISTINCT receiver) AS receivers,

SUM(amount / pow(10,6)) AS "LVN amount"

FROM osmosis.core.fact_transfers

WHERE currency = 'factory/osmo1mlng7pz4pnyxtpq0akfwall37czyk9lukaucsrn30ameplhhshtqdvfm5c/ulvn'

and tx_succeeded

AND block_timestamp::date >= '2023-12-16'

GROUP BY 1