Primary key / clustered index

Design a MySQL schema for ultra-fast retrieval of historical FX time series at scale (~40k pairs): RDS vs S3 tradeoffs, indexing, table-per-pair strategy.