TRANSFER_TYPE,

CURRENCY,

SENDER,

RECEIVER,

BLOCK_TIMESTAMP

FROM osmosis.core.fact_transfers

WHERE RECEIVER = 'osmo1f5vfcph2dvfeqcqkhetwv75fda69z7e5c2dldm3kvgj23crkv6wqcn47a0'

AND BLOCK_TIMESTAMP BETWEEN '2024-07-01' AND CURRENT_DATE;

AND TX_SUCCEEDED = 'TRUE'