FROM terra.daily_balances t1 LEFT JOIN terra.daily_balances t2

ON (t1.address = t2.address AND t1.date < t2.date)

WHERE t2.date IS NULL

and t1.currency='LUNA'

and t1.balance_type='liquid'

and t1.balance <>0

and t1.address_label is not null

and t1.date > CURRENT_DATE() - interval '3 month'