Constant brontes_database::clickhouse::RAW_CEX_TRADES
source ยท pub const RAW_CEX_TRADES: &str = r#"SELECT
c.exchange AS exchange,
'Taker' AS trade_type,
upper(replaceAll(replaceAll(replaceAll(c.symbol, '/', ''), '-', ''), '_', '')) AS symbol,
c.timestamp AS timestamp,
c.side AS side,
c.price AS price,
c.amount AS amount
FROM cex.normalized_trades AS c
WHERE c.timestamp >= ? AND c.timestamp < ?
ORDER BY timestamp "#;