PREVIEW / stock_5min / 2000-09-08
file: by_date/stock_5min/2000/2000-09-08.parquet size: 1.2 MB rows: 88,254 symbols: 1,215
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-08 09:05:00 | AAPL | Stock | 1.1094 | 1.1384 | 1.1094 | 1.1094 | 280000.0 |
| 2000-09-08 09:10:00 | AAPL | Stock | 1.1083 | 1.1094 | 1.1083 | 1.1094 | 50400.0 |
| 2000-09-08 09:15:00 | AAPL | Stock | 1.1083 | 1.1094 | 1.106 | 1.106 | 89600.0 |
| 2000-09-08 09:20:00 | AAPL | Stock | 1.1094 | 1.1094 | 1.1094 | 1.1094 | 56000.0 |
| 2000-09-08 09:25:00 | AAPL | Stock | 1.1049 | 1.1049 | 1.1016 | 1.1016 | 123200.0 |
| 2000-09-08 09:30:00 | AAPL | Stock | 1.1004 | 1.1004 | 1.0859 | 1.0882 | 6518400.0 |
| 2000-09-08 09:35:00 | AAPL | Stock | 1.0893 | 1.0938 | 1.0871 | 1.0893 | 4709600.0 |
| 2000-09-08 09:40:00 | AAPL | Stock | 1.0871 | 1.0893 | 1.0804 | 1.0859 | 2996000.0 |
| 2000-09-08 09:45:00 | AAPL | Stock | 1.0859 | 1.0949 | 1.0848 | 1.0949 | 4782400.0 |
| 2000-09-08 09:50:00 | AAPL | Stock | 1.0926 | 1.1004 | 1.0893 | 1.1004 | 3332000.0 |
| 2000-09-08 09:55:00 | AAPL | Stock | 1.096 | 1.0993 | 1.0859 | 1.0859 | 5936000.0 |
| 2000-09-08 10:00:00 | AAPL | Stock | 1.0859 | 1.0882 | 1.0826 | 1.0826 | 2072000.0 |
| 2000-09-08 10:05:00 | AAPL | Stock | 1.0826 | 1.0837 | 1.0759 | 1.0815 | 4995200.0 |
| 2000-09-08 10:10:00 | AAPL | Stock | 1.0815 | 1.0826 | 1.0737 | 1.077 | 3668000.0 |
| 2000-09-08 10:15:00 | AAPL | Stock | 1.0759 | 1.0804 | 1.0725 | 1.0748 | 3040800.0 |
| 2000-09-08 10:20:00 | AAPL | Stock | 1.0748 | 1.0748 | 1.067 | 1.0714 | 6227200.0 |
| 2000-09-08 10:25:00 | AAPL | Stock | 1.0703 | 1.0703 | 1.0636 | 1.0636 | 4748800.0 |
| 2000-09-08 10:30:00 | AAPL | Stock | 1.0636 | 1.0681 | 1.0636 | 1.0658 | 6232800.0 |
| 2000-09-08 10:35:00 | AAPL | Stock | 1.0658 | 1.0692 | 1.0658 | 1.0658 | 1316000.0 |
| 2000-09-08 10:40:00 | AAPL | Stock | 1.0658 | 1.0692 | 1.0647 | 1.067 | 1825600.0 |
| 2000-09-08 10:45:00 | AAPL | Stock | 1.067 | 1.0703 | 1.0647 | 1.0681 | 2380000.0 |
| 2000-09-08 10:50:00 | AAPL | Stock | 1.0681 | 1.0692 | 1.0647 | 1.0647 | 1551200.0 |
| 2000-09-08 10:55:00 | AAPL | Stock | 1.0658 | 1.067 | 1.058 | 1.0592 | 3976000.0 |
| 2000-09-08 11:00:00 | AAPL | Stock | 1.0569 | 1.0625 | 1.0558 | 1.058 | 2508800.0 |
| 2000-09-08 11:05:00 | AAPL | Stock | 1.0569 | 1.058 | 1.0536 | 1.0536 | 2212000.0 |
| 2000-09-08 11:10:00 | AAPL | Stock | 1.0569 | 1.0636 | 1.0536 | 1.0636 | 2128000.0 |
| 2000-09-08 11:15:00 | AAPL | Stock | 1.0625 | 1.0703 | 1.0614 | 1.067 | 3124800.0 |
| 2000-09-08 11:20:00 | AAPL | Stock | 1.067 | 1.0703 | 1.0625 | 1.0681 | 1360800.0 |
| 2000-09-08 11:25:00 | AAPL | Stock | 1.0692 | 1.0759 | 1.067 | 1.0759 | 5247200.0 |
| 2000-09-08 11:30:00 | AAPL | Stock | 1.0759 | 1.0759 | 1.0692 | 1.0714 | 1506400.0 |
| 2000-09-08 11:35:00 | AAPL | Stock | 1.0703 | 1.0725 | 1.0692 | 1.0725 | 543200.0 |
| 2000-09-08 11:40:00 | AAPL | Stock | 1.0692 | 1.0714 | 1.067 | 1.067 | 1674400.0 |
| 2000-09-08 11:45:00 | AAPL | Stock | 1.0692 | 1.0692 | 1.0625 | 1.0625 | 1870400.0 |
| 2000-09-08 11:50:00 | AAPL | Stock | 1.0625 | 1.0636 | 1.0592 | 1.0597 | 1131200.0 |
| 2000-09-08 11:55:00 | AAPL | Stock | 1.0597 | 1.0636 | 1.0592 | 1.0636 | 1080800.0 |
| 2000-09-08 12:00:00 | AAPL | Stock | 1.0625 | 1.0658 | 1.0625 | 1.0658 | 1097600.0 |
| 2000-09-08 12:05:00 | AAPL | Stock | 1.0658 | 1.0658 | 1.0625 | 1.0625 | 464800.0 |
| 2000-09-08 12:10:00 | AAPL | Stock | 1.0625 | 1.0647 | 1.0614 | 1.0647 | 1237600.0 |
| 2000-09-08 12:15:00 | AAPL | Stock | 1.0647 | 1.0658 | 1.0625 | 1.0625 | 347200.0 |
| 2000-09-08 12:20:00 | AAPL | Stock | 1.0636 | 1.067 | 1.0625 | 1.067 | 1618400.0 |
| 2000-09-08 12:25:00 | AAPL | Stock | 1.0664 | 1.0781 | 1.0664 | 1.0781 | 1988000.0 |
| 2000-09-08 12:30:00 | AAPL | Stock | 1.0781 | 1.0781 | 1.0737 | 1.0759 | 2945600.0 |
| 2000-09-08 12:35:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0748 | 1.0748 | 649600.0 |
| 2000-09-08 12:40:00 | AAPL | Stock | 1.0737 | 1.0759 | 1.0737 | 1.0748 | 896000.0 |
| 2000-09-08 12:45:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0714 | 1.0725 | 935200.0 |
| 2000-09-08 12:50:00 | AAPL | Stock | 1.0737 | 1.0737 | 1.0703 | 1.0703 | 380800.0 |
| 2000-09-08 12:55:00 | AAPL | Stock | 1.0714 | 1.0714 | 1.0681 | 1.0692 | 756000.0 |
| 2000-09-08 13:00:00 | AAPL | Stock | 1.0681 | 1.0714 | 1.067 | 1.0681 | 2419200.0 |
| 2000-09-08 13:05:00 | AAPL | Stock | 1.067 | 1.0681 | 1.067 | 1.067 | 470400.0 |
| 2000-09-08 13:10:00 | AAPL | Stock | 1.067 | 1.067 | 1.0625 | 1.0636 | 1904000.0 |
> showing 50 of 88,254 rows — these rows as CSV