PREVIEW / stock_5min / 2000-09-15
file: by_date/stock_5min/2000/2000-09-15.parquet size: 1.2 MB rows: 91,151 symbols: 1,231
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-09-15 08:00:00 | AAPL | Stock | 1.0151 | 1.0151 | 1.0151 | 1.0151 | 156800.0 |
| 2000-09-15 08:50:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0201 | 1.0201 | 128800.0 |
| 2000-09-15 08:55:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0179 | 1.0179 | 229600.0 |
| 2000-09-15 09:00:00 | AAPL | Stock | 1.0156 | 1.0156 | 1.0156 | 1.0156 | 16800.0 |
| 2000-09-15 09:05:00 | AAPL | Stock | 1.0167 | 1.0167 | 1.0167 | 1.0167 | 112000.0 |
| 2000-09-15 09:10:00 | AAPL | Stock | 1.0156 | 1.0156 | 1.0156 | 1.0156 | 16800.0 |
| 2000-09-15 09:15:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0156 | 1.0156 | 1192800.0 |
| 2000-09-15 09:20:00 | AAPL | Stock | 1.0156 | 1.0223 | 1.0156 | 1.0167 | 1058400.0 |
| 2000-09-15 09:25:00 | AAPL | Stock | 1.0201 | 1.0313 | 1.0156 | 1.0313 | 9732800.0 |
| 2000-09-15 09:30:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.0201 | 1.0313 | 15215200.0 |
| 2000-09-15 09:35:00 | AAPL | Stock | 1.019 | 1.0313 | 1.0156 | 1.0246 | 5527200.0 |
| 2000-09-15 09:40:00 | AAPL | Stock | 1.0268 | 1.0313 | 1.0223 | 1.0234 | 6904800.0 |
| 2000-09-15 09:45:00 | AAPL | Stock | 1.0234 | 1.0313 | 1.0234 | 1.0301 | 4009600.0 |
| 2000-09-15 09:50:00 | AAPL | Stock | 1.029 | 1.0357 | 1.029 | 1.0335 | 4205600.0 |
| 2000-09-15 09:55:00 | AAPL | Stock | 1.0335 | 1.0346 | 1.029 | 1.0346 | 2973600.0 |
| 2000-09-15 10:00:00 | AAPL | Stock | 1.0335 | 1.0391 | 1.0313 | 1.0313 | 5012000.0 |
| 2000-09-15 10:05:00 | AAPL | Stock | 1.0313 | 1.0346 | 1.0268 | 1.0268 | 2928800.0 |
| 2000-09-15 10:10:00 | AAPL | Stock | 1.0268 | 1.029 | 1.0201 | 1.0234 | 3483200.0 |
| 2000-09-15 10:15:00 | AAPL | Stock | 1.0179 | 1.0279 | 1.0179 | 1.0246 | 3936800.0 |
| 2000-09-15 10:20:00 | AAPL | Stock | 1.0223 | 1.0279 | 1.0223 | 1.0268 | 3584000.0 |
| 2000-09-15 10:25:00 | AAPL | Stock | 1.0268 | 1.0279 | 1.0201 | 1.0201 | 7845600.0 |
| 2000-09-15 10:30:00 | AAPL | Stock | 1.0201 | 1.0246 | 1.019 | 1.0234 | 3600800.0 |
| 2000-09-15 10:35:00 | AAPL | Stock | 1.0234 | 1.0234 | 1.0156 | 1.019 | 6983200.0 |
| 2000-09-15 10:40:00 | AAPL | Stock | 1.0179 | 1.0223 | 1.0179 | 1.0212 | 4530400.0 |
| 2000-09-15 10:45:00 | AAPL | Stock | 1.0212 | 1.0223 | 1.019 | 1.0201 | 2156000.0 |
| 2000-09-15 10:50:00 | AAPL | Stock | 1.0201 | 1.0212 | 1.0179 | 1.0201 | 2951200.0 |
| 2000-09-15 10:55:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0156 | 1.0179 | 1024800.0 |
| 2000-09-15 11:00:00 | AAPL | Stock | 1.0179 | 1.019 | 1.0167 | 1.0179 | 2615200.0 |
| 2000-09-15 11:05:00 | AAPL | Stock | 1.0179 | 1.019 | 1.0179 | 1.0179 | 694400.0 |
| 2000-09-15 11:10:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0156 | 1.0167 | 1999200.0 |
| 2000-09-15 11:15:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0145 | 1.0167 | 2772000.0 |
| 2000-09-15 11:20:00 | AAPL | Stock | 1.0156 | 1.0173 | 1.0145 | 1.0167 | 750400.0 |
| 2000-09-15 11:25:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0156 | 1.0167 | 1540000.0 |
| 2000-09-15 11:30:00 | AAPL | Stock | 1.0179 | 1.0257 | 1.0179 | 1.0257 | 3220000.0 |
| 2000-09-15 11:35:00 | AAPL | Stock | 1.0268 | 1.0279 | 1.0246 | 1.0246 | 2228800.0 |
| 2000-09-15 11:40:00 | AAPL | Stock | 1.0246 | 1.0257 | 1.0223 | 1.0234 | 509600.0 |
| 2000-09-15 11:45:00 | AAPL | Stock | 1.0246 | 1.0268 | 1.0234 | 1.0257 | 616000.0 |
| 2000-09-15 11:50:00 | AAPL | Stock | 1.0268 | 1.029 | 1.0246 | 1.029 | 1388800.0 |
| 2000-09-15 11:55:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0268 | 1.029 | 1400000.0 |
| 2000-09-15 12:00:00 | AAPL | Stock | 1.0279 | 1.029 | 1.0246 | 1.029 | 980000.0 |
| 2000-09-15 12:05:00 | AAPL | Stock | 1.0279 | 1.0279 | 1.0223 | 1.0223 | 1248800.0 |
| 2000-09-15 12:10:00 | AAPL | Stock | 1.0223 | 1.0223 | 1.0145 | 1.0156 | 968800.0 |
| 2000-09-15 12:15:00 | AAPL | Stock | 1.0156 | 1.0179 | 1.0145 | 1.0173 | 666400.0 |
| 2000-09-15 12:20:00 | AAPL | Stock | 1.0167 | 1.0179 | 1.0145 | 1.0145 | 800800.0 |
| 2000-09-15 12:25:00 | AAPL | Stock | 1.0145 | 1.0167 | 1.0145 | 1.0156 | 2340800.0 |
| 2000-09-15 12:30:00 | AAPL | Stock | 1.0156 | 1.0167 | 1.0134 | 1.0145 | 968800.0 |
| 2000-09-15 12:35:00 | AAPL | Stock | 1.0134 | 1.0145 | 1.0134 | 1.0145 | 341600.0 |
| 2000-09-15 12:40:00 | AAPL | Stock | 1.0145 | 1.0156 | 1.0134 | 1.0145 | 1136800.0 |
| 2000-09-15 12:45:00 | AAPL | Stock | 1.0156 | 1.0156 | 1.0134 | 1.0156 | 1820000.0 |
| 2000-09-15 12:50:00 | AAPL | Stock | 1.0156 | 1.0156 | 1.0145 | 1.0145 | 358400.0 |
> showing 50 of 91,151 rows — these rows as CSV