,sum(AMOUNT) / 1e6 AS "Sent Amount"

FROM lava.core.fact_transfers

WHERE 1 = 1

AND TX_SUCCEEDED = 'TRUE'

--AND TRANSFER_TYPE = 'IBC_TRANSFER_IN'

AND TRANSFER_TYPE = 'IBC_TRANSFER_OUT'

--AND TRANSFER_TYPE = 'LAVA'

AND CURRENCY = 'ulava'

GROUP BY 1

ORDER BY 2 DESC