PREVIEW / stock_5min / 2000-09-11
file: by_date/stock_5min/2000/2000-09-11.parquet size: 1.2 MB rows: 90,945 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-11 08:10:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0491 | 1.0491 | 11200.0 |
| 2000-09-11 08:40:00 | AAPL | Stock | 1.0491 | 1.0491 | 1.0491 | 1.0491 | 5600.0 |
| 2000-09-11 08:50:00 | AAPL | Stock | 1.0469 | 1.0469 | 1.0424 | 1.0424 | 44800.0 |
| 2000-09-11 09:00:00 | AAPL | Stock | 1.0424 | 1.0424 | 1.0424 | 1.0424 | 28000.0 |
| 2000-09-11 09:15:00 | AAPL | Stock | 1.0446 | 1.0491 | 1.0446 | 1.0491 | 100800.0 |
| 2000-09-11 09:25:00 | AAPL | Stock | 1.0491 | 1.0513 | 1.0486 | 1.0486 | 319200.0 |
| 2000-09-11 09:30:00 | AAPL | Stock | 1.048 | 1.0536 | 1.048 | 1.0536 | 7588000.0 |
| 2000-09-11 09:35:00 | AAPL | Stock | 1.0536 | 1.0558 | 1.048 | 1.0491 | 3236800.0 |
| 2000-09-11 09:40:00 | AAPL | Stock | 1.0502 | 1.053 | 1.048 | 1.0491 | 4429600.0 |
| 2000-09-11 09:45:00 | AAPL | Stock | 1.0502 | 1.0614 | 1.0491 | 1.058 | 3343200.0 |
| 2000-09-11 09:50:00 | AAPL | Stock | 1.058 | 1.0636 | 1.0547 | 1.0558 | 3119200.0 |
| 2000-09-11 09:55:00 | AAPL | Stock | 1.0536 | 1.0569 | 1.0491 | 1.0491 | 4524800.0 |
| 2000-09-11 10:00:00 | AAPL | Stock | 1.0491 | 1.0536 | 1.0491 | 1.0491 | 3589600.0 |
| 2000-09-11 10:05:00 | AAPL | Stock | 1.0502 | 1.0502 | 1.0458 | 1.0502 | 3460800.0 |
| 2000-09-11 10:10:00 | AAPL | Stock | 1.0502 | 1.0536 | 1.0491 | 1.0525 | 1696800.0 |
| 2000-09-11 10:15:00 | AAPL | Stock | 1.0536 | 1.0703 | 1.0536 | 1.0692 | 6916000.0 |
| 2000-09-11 10:20:00 | AAPL | Stock | 1.0703 | 1.077 | 1.067 | 1.0714 | 4480000.0 |
| 2000-09-11 10:25:00 | AAPL | Stock | 1.0714 | 1.0781 | 1.0681 | 1.0681 | 2520000.0 |
| 2000-09-11 10:30:00 | AAPL | Stock | 1.0692 | 1.0714 | 1.0603 | 1.0603 | 2900800.0 |
| 2000-09-11 10:35:00 | AAPL | Stock | 1.0603 | 1.0658 | 1.0603 | 1.0625 | 2570400.0 |
| 2000-09-11 10:40:00 | AAPL | Stock | 1.0625 | 1.0703 | 1.0603 | 1.0692 | 3259200.0 |
| 2000-09-11 10:45:00 | AAPL | Stock | 1.0681 | 1.0703 | 1.067 | 1.0692 | 1338400.0 |
| 2000-09-11 10:50:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.067 | 1.067 | 1265600.0 |
| 2000-09-11 10:55:00 | AAPL | Stock | 1.0681 | 1.0714 | 1.067 | 1.0714 | 1640800.0 |
| 2000-09-11 11:00:00 | AAPL | Stock | 1.0714 | 1.0759 | 1.0703 | 1.0737 | 1500800.0 |
| 2000-09-11 11:05:00 | AAPL | Stock | 1.0725 | 1.0748 | 1.0692 | 1.0692 | 1545600.0 |
| 2000-09-11 11:10:00 | AAPL | Stock | 1.0692 | 1.0714 | 1.0681 | 1.0681 | 1702400.0 |
| 2000-09-11 11:15:00 | AAPL | Stock | 1.0681 | 1.0681 | 1.0647 | 1.0658 | 2447200.0 |
| 2000-09-11 11:20:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0647 | 1.067 | 2206400.0 |
| 2000-09-11 11:25:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0647 | 1.0658 | 2895200.0 |
| 2000-09-11 11:30:00 | AAPL | Stock | 1.0658 | 1.067 | 1.0592 | 1.0625 | 3315200.0 |
| 2000-09-11 11:35:00 | AAPL | Stock | 1.0625 | 1.0647 | 1.0603 | 1.0625 | 772800.0 |
| 2000-09-11 11:40:00 | AAPL | Stock | 1.0614 | 1.0614 | 1.0558 | 1.0603 | 1898400.0 |
| 2000-09-11 11:45:00 | AAPL | Stock | 1.0592 | 1.0625 | 1.058 | 1.0614 | 784000.0 |
| 2000-09-11 11:50:00 | AAPL | Stock | 1.0625 | 1.0625 | 1.058 | 1.058 | 1528800.0 |
| 2000-09-11 11:55:00 | AAPL | Stock | 1.0592 | 1.0614 | 1.058 | 1.0614 | 1204000.0 |
| 2000-09-11 12:00:00 | AAPL | Stock | 1.0603 | 1.0614 | 1.0558 | 1.0558 | 1859200.0 |
| 2000-09-11 12:05:00 | AAPL | Stock | 1.0569 | 1.0569 | 1.0536 | 1.0536 | 1327200.0 |
| 2000-09-11 12:10:00 | AAPL | Stock | 1.0536 | 1.0547 | 1.0513 | 1.0525 | 1618400.0 |
| 2000-09-11 12:15:00 | AAPL | Stock | 1.0536 | 1.0536 | 1.0446 | 1.0458 | 2368800.0 |
| 2000-09-11 12:20:00 | AAPL | Stock | 1.0446 | 1.0469 | 1.0446 | 1.0469 | 1696800.0 |
| 2000-09-11 12:25:00 | AAPL | Stock | 1.0463 | 1.0469 | 1.0458 | 1.0458 | 627200.0 |
| 2000-09-11 12:30:00 | AAPL | Stock | 1.0458 | 1.0491 | 1.0458 | 1.048 | 2609600.0 |
| 2000-09-11 12:35:00 | AAPL | Stock | 1.0469 | 1.0525 | 1.0469 | 1.0525 | 2144800.0 |
| 2000-09-11 12:40:00 | AAPL | Stock | 1.0513 | 1.0558 | 1.0513 | 1.0547 | 761600.0 |
| 2000-09-11 12:45:00 | AAPL | Stock | 1.0558 | 1.0558 | 1.0525 | 1.0558 | 464800.0 |
| 2000-09-11 12:50:00 | AAPL | Stock | 1.0558 | 1.0597 | 1.0547 | 1.058 | 470400.0 |
| 2000-09-11 12:55:00 | AAPL | Stock | 1.058 | 1.0614 | 1.0558 | 1.058 | 772800.0 |
| 2000-09-11 13:00:00 | AAPL | Stock | 1.058 | 1.067 | 1.058 | 1.0592 | 2576000.0 |
| 2000-09-11 13:05:00 | AAPL | Stock | 1.0592 | 1.0603 | 1.058 | 1.058 | 1870400.0 |
> showing 50 of 90,945 rows — these rows as CSV