PREVIEW / stock_5min / 2000-05-04
file: by_date/stock_5min/2000/2000-05-04.parquet size: 1.1 MB rows: 80,418 symbols: 1,151
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2000-05-04 09:30:00 | AAPL | Stock | 1.0279 | 1.0279 | 1.0134 | 1.0137 | 7515200.0 |
| 2000-05-04 09:35:00 | AAPL | Stock | 1.0134 | 1.0223 | 1.0112 | 1.0145 | 6451200.0 |
| 2000-05-04 09:40:00 | AAPL | Stock | 1.0142 | 1.0145 | 1.0045 | 1.0067 | 14145600.0 |
| 2000-05-04 09:45:00 | AAPL | Stock | 1.0067 | 1.0089 | 1.0028 | 1.0056 | 20619200.0 |
| 2000-05-04 09:50:00 | AAPL | Stock | 1.0067 | 1.019 | 1.0061 | 1.0162 | 13652800.0 |
| 2000-05-04 09:55:00 | AAPL | Stock | 1.0162 | 1.0167 | 1.0106 | 1.014 | 4928000.0 |
| 2000-05-04 10:00:00 | AAPL | Stock | 1.014 | 1.0246 | 1.0134 | 1.0206 | 15590400.0 |
| 2000-05-04 10:05:00 | AAPL | Stock | 1.0206 | 1.0257 | 1.0179 | 1.019 | 7593600.0 |
| 2000-05-04 10:10:00 | AAPL | Stock | 1.0184 | 1.019 | 1.0134 | 1.0184 | 10068800.0 |
| 2000-05-04 10:15:00 | AAPL | Stock | 1.0181 | 1.0184 | 1.0134 | 1.014 | 3024000.0 |
| 2000-05-04 10:20:00 | AAPL | Stock | 1.014 | 1.0145 | 1.0112 | 1.014 | 6675200.0 |
| 2000-05-04 10:25:00 | AAPL | Stock | 1.014 | 1.0201 | 1.0134 | 1.019 | 8198400.0 |
| 2000-05-04 10:30:00 | AAPL | Stock | 1.0179 | 1.0251 | 1.0179 | 1.0251 | 3920000.0 |
| 2000-05-04 10:35:00 | AAPL | Stock | 1.0254 | 1.0257 | 1.0195 | 1.0195 | 2105600.0 |
| 2000-05-04 10:40:00 | AAPL | Stock | 1.0212 | 1.0223 | 1.019 | 1.019 | 9150400.0 |
| 2000-05-04 10:45:00 | AAPL | Stock | 1.0201 | 1.0218 | 1.0195 | 1.0212 | 6350400.0 |
| 2000-05-04 10:50:00 | AAPL | Stock | 1.0212 | 1.0212 | 1.0167 | 1.0167 | 6563200.0 |
| 2000-05-04 10:55:00 | AAPL | Stock | 1.017 | 1.0173 | 1.01 | 1.0112 | 2923200.0 |
| 2000-05-04 11:00:00 | AAPL | Stock | 1.0131 | 1.0179 | 1.0117 | 1.0179 | 4995200.0 |
| 2000-05-04 11:05:00 | AAPL | Stock | 1.0179 | 1.019 | 1.0173 | 1.019 | 2374400.0 |
| 2000-05-04 11:10:00 | AAPL | Stock | 1.019 | 1.019 | 1.0162 | 1.0179 | 2038400.0 |
| 2000-05-04 11:15:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0179 | 1.0184 | 1288000.0 |
| 2000-05-04 11:20:00 | AAPL | Stock | 1.0184 | 1.0184 | 1.0156 | 1.0179 | 2217600.0 |
| 2000-05-04 11:25:00 | AAPL | Stock | 1.0162 | 1.0173 | 1.0156 | 1.0162 | 828800.0 |
| 2000-05-04 11:30:00 | AAPL | Stock | 1.0156 | 1.0173 | 1.0156 | 1.0167 | 705600.0 |
| 2000-05-04 11:35:00 | AAPL | Stock | 1.0173 | 1.0179 | 1.0156 | 1.0156 | 2172800.0 |
| 2000-05-04 11:40:00 | AAPL | Stock | 1.0162 | 1.0162 | 1.0106 | 1.0128 | 3393600.0 |
| 2000-05-04 11:45:00 | AAPL | Stock | 1.0112 | 1.0179 | 1.0106 | 1.0128 | 1411200.0 |
| 2000-05-04 11:50:00 | AAPL | Stock | 1.0128 | 1.0134 | 1.01 | 1.0106 | 436800.0 |
| 2000-05-04 11:55:00 | AAPL | Stock | 1.0112 | 1.0123 | 1.0095 | 1.0106 | 851200.0 |
| 2000-05-04 12:00:00 | AAPL | Stock | 1.0106 | 1.012 | 1.0089 | 1.0095 | 1836800.0 |
| 2000-05-04 12:05:00 | AAPL | Stock | 1.0089 | 1.01 | 1.0073 | 1.0073 | 2352000.0 |
| 2000-05-04 12:10:00 | AAPL | Stock | 1.0073 | 1.0073 | 1.0017 | 1.002 | 6182400.0 |
| 2000-05-04 12:15:00 | AAPL | Stock | 1.0022 | 1.0056 | 1.0011 | 1.0056 | 6865600.0 |
| 2000-05-04 12:20:00 | AAPL | Stock | 1.005 | 1.0056 | 1.0033 | 1.0045 | 5902400.0 |
| 2000-05-04 12:25:00 | AAPL | Stock | 1.005 | 1.005 | 1.0039 | 1.005 | 1971200.0 |
| 2000-05-04 12:30:00 | AAPL | Stock | 1.0039 | 1.0056 | 1.0017 | 1.0017 | 1276800.0 |
| 2000-05-04 12:35:00 | AAPL | Stock | 1.0017 | 1.0045 | 1.0017 | 1.0045 | 952000.0 |
| 2000-05-04 12:40:00 | AAPL | Stock | 1.0039 | 1.0045 | 1.0 | 1.0045 | 4088000.0 |
| 2000-05-04 12:45:00 | AAPL | Stock | 1.0045 | 1.005 | 1.0039 | 1.005 | 1523200.0 |
| 2000-05-04 12:50:00 | AAPL | Stock | 1.005 | 1.0089 | 1.0045 | 1.0061 | 7212800.0 |
| 2000-05-04 12:55:00 | AAPL | Stock | 1.0061 | 1.0067 | 1.0039 | 1.0039 | 2284800.0 |
| 2000-05-04 13:00:00 | AAPL | Stock | 1.0039 | 1.0056 | 1.0028 | 1.0039 | 1344000.0 |
| 2000-05-04 13:05:00 | AAPL | Stock | 1.0056 | 1.0056 | 1.0033 | 1.0033 | 1332800.0 |
| 2000-05-04 13:10:00 | AAPL | Stock | 1.0039 | 1.0039 | 1.0011 | 1.0011 | 716800.0 |
| 2000-05-04 13:15:00 | AAPL | Stock | 1.0017 | 1.0045 | 1.0011 | 1.0039 | 3998400.0 |
| 2000-05-04 13:20:00 | AAPL | Stock | 1.0011 | 1.0039 | 1.0011 | 1.0039 | 436800.0 |
| 2000-05-04 13:25:00 | AAPL | Stock | 1.0033 | 1.0033 | 0.9961 | 0.9967 | 7302400.0 |
| 2000-05-04 13:30:00 | AAPL | Stock | 0.9967 | 1.0017 | 0.9961 | 1.0 | 3864000.0 |
| 2000-05-04 13:35:00 | AAPL | Stock | 1.0 | 1.0022 | 0.9989 | 0.9994 | 1915200.0 |
> showing 50 of 80,418 rows — these rows as CSV