PREVIEW / stock_5min / 2000-02-09
file: by_date/stock_5min/2000/2000-02-09.parquet size: 1.2 MB rows: 90,179 symbols: 1,137
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-02-09 09:30:00 | AAPL | Stock | 1.019 | 1.0212 | 1.0162 | 1.0162 | 7515200.0 |
| 2000-02-09 09:35:00 | AAPL | Stock | 1.0179 | 1.0201 | 1.0061 | 1.0126 | 5913600.0 |
| 2000-02-09 09:40:00 | AAPL | Stock | 1.0117 | 1.0153 | 1.0056 | 1.0084 | 11155200.0 |
| 2000-02-09 09:45:00 | AAPL | Stock | 1.0084 | 1.0201 | 1.0045 | 1.0162 | 7212800.0 |
| 2000-02-09 09:50:00 | AAPL | Stock | 1.0156 | 1.0206 | 1.01 | 1.014 | 2620800.0 |
| 2000-02-09 09:55:00 | AAPL | Stock | 1.0112 | 1.0145 | 1.0067 | 1.0078 | 3505600.0 |
| 2000-02-09 10:00:00 | AAPL | Stock | 1.0078 | 1.0167 | 1.0067 | 1.0156 | 2721600.0 |
| 2000-02-09 10:05:00 | AAPL | Stock | 1.0145 | 1.0246 | 1.0145 | 1.0215 | 6608000.0 |
| 2000-02-09 10:10:00 | AAPL | Stock | 1.0201 | 1.029 | 1.0184 | 1.029 | 6003200.0 |
| 2000-02-09 10:15:00 | AAPL | Stock | 1.0301 | 1.0346 | 1.0268 | 1.0335 | 7022400.0 |
| 2000-02-09 10:20:00 | AAPL | Stock | 1.0346 | 1.0357 | 1.0257 | 1.0335 | 5510400.0 |
| 2000-02-09 10:25:00 | AAPL | Stock | 1.0332 | 1.0352 | 1.0324 | 1.0324 | 4312000.0 |
| 2000-02-09 10:30:00 | AAPL | Stock | 1.0324 | 1.0363 | 1.0313 | 1.0313 | 8344000.0 |
| 2000-02-09 10:35:00 | AAPL | Stock | 1.0318 | 1.0352 | 1.0301 | 1.0313 | 3987200.0 |
| 2000-02-09 10:40:00 | AAPL | Stock | 1.0313 | 1.0368 | 1.0301 | 1.0346 | 5275200.0 |
| 2000-02-09 10:45:00 | AAPL | Stock | 1.0346 | 1.0413 | 1.0346 | 1.0407 | 7627200.0 |
| 2000-02-09 10:50:00 | AAPL | Stock | 1.0402 | 1.0407 | 1.0352 | 1.0402 | 5096000.0 |
| 2000-02-09 10:55:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0329 | 1.0346 | 2721600.0 |
| 2000-02-09 11:00:00 | AAPL | Stock | 1.0346 | 1.0374 | 1.0335 | 1.0357 | 1825600.0 |
| 2000-02-09 11:05:00 | AAPL | Stock | 1.0357 | 1.0413 | 1.0346 | 1.0402 | 5006400.0 |
| 2000-02-09 11:10:00 | AAPL | Stock | 1.0402 | 1.0458 | 1.0396 | 1.0441 | 7459200.0 |
| 2000-02-09 11:15:00 | AAPL | Stock | 1.0435 | 1.0435 | 1.0324 | 1.0363 | 4916800.0 |
| 2000-02-09 11:20:00 | AAPL | Stock | 1.0357 | 1.0391 | 1.0346 | 1.0357 | 3516800.0 |
| 2000-02-09 11:25:00 | AAPL | Stock | 1.0354 | 1.0402 | 1.0324 | 1.0402 | 2150400.0 |
| 2000-02-09 11:30:00 | AAPL | Stock | 1.0402 | 1.0402 | 1.0296 | 1.0307 | 3684800.0 |
| 2000-02-09 11:35:00 | AAPL | Stock | 1.0304 | 1.0329 | 1.0234 | 1.0246 | 2822400.0 |
| 2000-02-09 11:40:00 | AAPL | Stock | 1.0234 | 1.0251 | 1.0201 | 1.0229 | 7448000.0 |
| 2000-02-09 11:45:00 | AAPL | Stock | 1.0237 | 1.0257 | 1.0201 | 1.0212 | 5577600.0 |
| 2000-02-09 11:50:00 | AAPL | Stock | 1.0212 | 1.024 | 1.019 | 1.0234 | 3360000.0 |
| 2000-02-09 11:55:00 | AAPL | Stock | 1.0229 | 1.024 | 1.0173 | 1.0173 | 3584000.0 |
| 2000-02-09 12:00:00 | AAPL | Stock | 1.0176 | 1.019 | 1.0134 | 1.0134 | 5084800.0 |
| 2000-02-09 12:05:00 | AAPL | Stock | 1.014 | 1.019 | 1.0134 | 1.0179 | 4267200.0 |
| 2000-02-09 12:10:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0128 | 1.0145 | 1601600.0 |
| 2000-02-09 12:15:00 | AAPL | Stock | 1.0142 | 1.0179 | 1.0128 | 1.0176 | 2284800.0 |
| 2000-02-09 12:20:00 | AAPL | Stock | 1.0179 | 1.0179 | 1.0089 | 1.0112 | 3740800.0 |
| 2000-02-09 12:25:00 | AAPL | Stock | 1.0112 | 1.0179 | 1.0089 | 1.0156 | 2576000.0 |
| 2000-02-09 12:30:00 | AAPL | Stock | 1.0151 | 1.0173 | 1.0106 | 1.0145 | 2195200.0 |
| 2000-02-09 12:35:00 | AAPL | Stock | 1.014 | 1.014 | 1.01 | 1.01 | 884800.0 |
| 2000-02-09 12:40:00 | AAPL | Stock | 1.01 | 1.0123 | 1.0089 | 1.0095 | 1971200.0 |
| 2000-02-09 12:45:00 | AAPL | Stock | 1.0095 | 1.0128 | 1.0089 | 1.0095 | 2363200.0 |
| 2000-02-09 12:50:00 | AAPL | Stock | 1.0095 | 1.0112 | 1.0067 | 1.0112 | 2867200.0 |
| 2000-02-09 12:55:00 | AAPL | Stock | 1.0112 | 1.0128 | 1.0089 | 1.0089 | 828800.0 |
| 2000-02-09 13:00:00 | AAPL | Stock | 1.0112 | 1.0112 | 1.0078 | 1.0106 | 1657600.0 |
| 2000-02-09 13:05:00 | AAPL | Stock | 1.0106 | 1.0145 | 1.0106 | 1.0123 | 1344000.0 |
| 2000-02-09 13:10:00 | AAPL | Stock | 1.0123 | 1.0123 | 1.0117 | 1.0117 | 1086400.0 |
| 2000-02-09 13:15:00 | AAPL | Stock | 1.012 | 1.0128 | 1.0117 | 1.0128 | 2755200.0 |
| 2000-02-09 13:20:00 | AAPL | Stock | 1.0123 | 1.0179 | 1.0123 | 1.0145 | 2296000.0 |
| 2000-02-09 13:25:00 | AAPL | Stock | 1.0167 | 1.0167 | 1.01 | 1.01 | 2945600.0 |
| 2000-02-09 13:30:00 | AAPL | Stock | 1.01 | 1.0145 | 1.01 | 1.014 | 2822400.0 |
| 2000-02-09 13:35:00 | AAPL | Stock | 1.014 | 1.014 | 1.0095 | 1.0112 | 2027200.0 |
> showing 50 of 90,179 rows — these rows as CSV