PREVIEW / stock_5min / 2000-09-21
file: by_date/stock_5min/2000/2000-09-21.parquet size: 1.2 MB rows: 87,788 symbols: 1,214
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-21 08:05:00 | AAPL | Stock | 1.0848 | 1.0848 | 1.0848 | 1.0848 | 168000.0 |
| 2000-09-21 08:10:00 | AAPL | Stock | 1.0848 | 1.0848 | 1.0714 | 1.0714 | 336000.0 |
| 2000-09-21 08:15:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0714 | 1.0714 | 112000.0 |
| 2000-09-21 08:20:00 | AAPL | Stock | 1.0647 | 1.067 | 1.0647 | 1.0647 | 565600.0 |
| 2000-09-21 08:25:00 | AAPL | Stock | 1.0647 | 1.0647 | 1.0592 | 1.0592 | 184800.0 |
| 2000-09-21 08:30:00 | AAPL | Stock | 1.0592 | 1.0603 | 1.0469 | 1.0513 | 1624000.0 |
| 2000-09-21 08:35:00 | AAPL | Stock | 1.0597 | 1.0597 | 1.0536 | 1.0536 | 252000.0 |
| 2000-09-21 08:40:00 | AAPL | Stock | 1.0592 | 1.0592 | 1.058 | 1.058 | 112000.0 |
| 2000-09-21 08:45:00 | AAPL | Stock | 1.058 | 1.058 | 1.058 | 1.058 | 28000.0 |
| 2000-09-21 08:50:00 | AAPL | Stock | 1.067 | 1.067 | 1.0525 | 1.0536 | 935200.0 |
| 2000-09-21 08:55:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0536 | 1.0536 | 151200.0 |
| 2000-09-21 09:00:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0536 | 1.0536 | 89600.0 |
| 2000-09-21 09:05:00 | AAPL | Stock | 1.058 | 1.058 | 1.058 | 1.058 | 16800.0 |
| 2000-09-21 09:15:00 | AAPL | Stock | 1.0603 | 1.0625 | 1.0603 | 1.0625 | 50400.0 |
| 2000-09-21 09:20:00 | AAPL | Stock | 1.058 | 1.058 | 1.0558 | 1.058 | 106400.0 |
| 2000-09-21 09:25:00 | AAPL | Stock | 1.058 | 1.0681 | 1.0536 | 1.0536 | 3108000.0 |
| 2000-09-21 09:30:00 | AAPL | Stock | 1.0446 | 1.0536 | 1.0446 | 1.0469 | 8870400.0 |
| 2000-09-21 09:35:00 | AAPL | Stock | 1.0458 | 1.048 | 1.0402 | 1.0446 | 8825600.0 |
| 2000-09-21 09:40:00 | AAPL | Stock | 1.0435 | 1.0502 | 1.0402 | 1.048 | 8439200.0 |
| 2000-09-21 09:45:00 | AAPL | Stock | 1.0469 | 1.0558 | 1.0458 | 1.0558 | 16139200.0 |
| 2000-09-21 09:50:00 | AAPL | Stock | 1.0558 | 1.0647 | 1.053 | 1.0603 | 7112000.0 |
| 2000-09-21 09:55:00 | AAPL | Stock | 1.0603 | 1.0625 | 1.0491 | 1.0491 | 6092800.0 |
| 2000-09-21 10:00:00 | AAPL | Stock | 1.0491 | 1.0513 | 1.0424 | 1.0424 | 5824000.0 |
| 2000-09-21 10:05:00 | AAPL | Stock | 1.0435 | 1.0446 | 1.0301 | 1.0335 | 9396800.0 |
| 2000-09-21 10:10:00 | AAPL | Stock | 1.0313 | 1.0357 | 1.0246 | 1.0357 | 8321600.0 |
| 2000-09-21 10:15:00 | AAPL | Stock | 1.0357 | 1.0379 | 1.0279 | 1.0324 | 8618400.0 |
| 2000-09-21 10:20:00 | AAPL | Stock | 1.0324 | 1.0324 | 1.0268 | 1.0279 | 4978400.0 |
| 2000-09-21 10:25:00 | AAPL | Stock | 1.0268 | 1.0335 | 1.0268 | 1.029 | 6350400.0 |
| 2000-09-21 10:30:00 | AAPL | Stock | 1.029 | 1.0313 | 1.0257 | 1.0301 | 5628000.0 |
| 2000-09-21 10:35:00 | AAPL | Stock | 1.0301 | 1.0301 | 1.0279 | 1.0301 | 2116800.0 |
| 2000-09-21 10:40:00 | AAPL | Stock | 1.0301 | 1.0301 | 1.0268 | 1.0301 | 4704000.0 |
| 2000-09-21 10:45:00 | AAPL | Stock | 1.0313 | 1.0313 | 1.029 | 1.0301 | 1265600.0 |
| 2000-09-21 10:50:00 | AAPL | Stock | 1.0301 | 1.0301 | 1.0257 | 1.0268 | 2240000.0 |
| 2000-09-21 10:55:00 | AAPL | Stock | 1.0268 | 1.0268 | 1.0246 | 1.0246 | 2133600.0 |
| 2000-09-21 11:00:00 | AAPL | Stock | 1.0246 | 1.0246 | 1.0179 | 1.0212 | 6389600.0 |
| 2000-09-21 11:05:00 | AAPL | Stock | 1.0201 | 1.0212 | 1.0179 | 1.0201 | 3572800.0 |
| 2000-09-21 11:10:00 | AAPL | Stock | 1.0201 | 1.0201 | 1.0134 | 1.0162 | 8108800.0 |
| 2000-09-21 11:15:00 | AAPL | Stock | 1.0167 | 1.0167 | 1.0056 | 1.0089 | 8898400.0 |
| 2000-09-21 11:20:00 | AAPL | Stock | 1.01 | 1.0123 | 1.0089 | 1.0112 | 5415200.0 |
| 2000-09-21 11:25:00 | AAPL | Stock | 1.0112 | 1.0123 | 1.0089 | 1.0089 | 2940000.0 |
| 2000-09-21 11:30:00 | AAPL | Stock | 1.0095 | 1.01 | 1.0045 | 1.0045 | 3040800.0 |
| 2000-09-21 11:35:00 | AAPL | Stock | 1.0056 | 1.0089 | 1.0056 | 1.0089 | 5482400.0 |
| 2000-09-21 11:40:00 | AAPL | Stock | 1.01 | 1.0156 | 1.01 | 1.0134 | 4429600.0 |
| 2000-09-21 11:45:00 | AAPL | Stock | 1.0112 | 1.0134 | 1.0089 | 1.01 | 4211200.0 |
| 2000-09-21 11:50:00 | AAPL | Stock | 1.01 | 1.0123 | 1.0089 | 1.0112 | 5073600.0 |
| 2000-09-21 11:55:00 | AAPL | Stock | 1.01 | 1.0112 | 1.0089 | 1.01 | 2755200.0 |
| 2000-09-21 12:00:00 | AAPL | Stock | 1.01 | 1.01 | 1.0089 | 1.01 | 2928800.0 |
| 2000-09-21 12:05:00 | AAPL | Stock | 1.01 | 1.0112 | 1.0089 | 1.0112 | 8052800.0 |
| 2000-09-21 12:10:00 | AAPL | Stock | 1.01 | 1.0112 | 1.01 | 1.0112 | 2900800.0 |
| 2000-09-21 12:15:00 | AAPL | Stock | 1.0112 | 1.0156 | 1.01 | 1.0156 | 10477600.0 |
> showing 50 of 87,788 rows — these rows as CSV