PREVIEW / stock_5min / 2000-09-06
file: by_date/stock_5min/2000/2000-09-06.parquet size: 1.2 MB rows: 91,848 symbols: 1,216
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-06 08:00:00 | AAPL | Stock | 1.1161 | 1.1161 | 1.1138 | 1.1155 | 291200.0 |
| 2000-09-06 08:25:00 | AAPL | Stock | 1.1116 | 1.1116 | 1.1116 | 1.1116 | 39200.0 |
| 2000-09-06 08:40:00 | AAPL | Stock | 1.106 | 1.106 | 1.106 | 1.106 | 33600.0 |
| 2000-09-06 09:00:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.1049 | 1.1071 | 358400.0 |
| 2000-09-06 09:05:00 | AAPL | Stock | 1.1094 | 1.1105 | 1.1094 | 1.1105 | 67200.0 |
| 2000-09-06 09:10:00 | AAPL | Stock | 1.1094 | 1.1094 | 1.1094 | 1.1094 | 16800.0 |
| 2000-09-06 09:15:00 | AAPL | Stock | 1.1094 | 1.1094 | 1.1083 | 1.1083 | 67200.0 |
| 2000-09-06 09:20:00 | AAPL | Stock | 1.1071 | 1.1071 | 1.1071 | 1.1071 | 22400.0 |
| 2000-09-06 09:25:00 | AAPL | Stock | 1.1027 | 1.1049 | 1.096 | 1.1004 | 2492000.0 |
| 2000-09-06 09:30:00 | AAPL | Stock | 1.096 | 1.1027 | 1.0915 | 1.1016 | 7296800.0 |
| 2000-09-06 09:35:00 | AAPL | Stock | 1.096 | 1.1127 | 1.0938 | 1.1094 | 10656800.0 |
| 2000-09-06 09:40:00 | AAPL | Stock | 1.1127 | 1.1138 | 1.1071 | 1.1094 | 5437600.0 |
| 2000-09-06 09:45:00 | AAPL | Stock | 1.1105 | 1.1105 | 1.1027 | 1.1027 | 3141600.0 |
| 2000-09-06 09:50:00 | AAPL | Stock | 1.1027 | 1.1127 | 1.1016 | 1.1105 | 4698400.0 |
| 2000-09-06 09:55:00 | AAPL | Stock | 1.1111 | 1.1116 | 1.1038 | 1.1071 | 3556000.0 |
| 2000-09-06 10:00:00 | AAPL | Stock | 1.1071 | 1.1083 | 1.1049 | 1.1049 | 1327200.0 |
| 2000-09-06 10:05:00 | AAPL | Stock | 1.106 | 1.106 | 1.1049 | 1.1049 | 2452800.0 |
| 2000-09-06 10:10:00 | AAPL | Stock | 1.1049 | 1.106 | 1.0938 | 1.1016 | 6188000.0 |
| 2000-09-06 10:15:00 | AAPL | Stock | 1.1004 | 1.1038 | 1.096 | 1.0993 | 3612000.0 |
| 2000-09-06 10:20:00 | AAPL | Stock | 1.0993 | 1.0993 | 1.096 | 1.0982 | 1674400.0 |
| 2000-09-06 10:25:00 | AAPL | Stock | 1.0982 | 1.0993 | 1.096 | 1.0982 | 4278400.0 |
| 2000-09-06 10:30:00 | AAPL | Stock | 1.0982 | 1.0993 | 1.0971 | 1.0982 | 1713600.0 |
| 2000-09-06 10:35:00 | AAPL | Stock | 1.0971 | 1.0982 | 1.0949 | 1.096 | 2934400.0 |
| 2000-09-06 10:40:00 | AAPL | Stock | 1.0971 | 1.0971 | 1.0949 | 1.096 | 1120000.0 |
| 2000-09-06 10:45:00 | AAPL | Stock | 1.096 | 1.0971 | 1.0893 | 1.0893 | 3270400.0 |
| 2000-09-06 10:50:00 | AAPL | Stock | 1.0893 | 1.0938 | 1.0848 | 1.0848 | 5622400.0 |
| 2000-09-06 10:55:00 | AAPL | Stock | 1.0837 | 1.0882 | 1.0837 | 1.0859 | 2794400.0 |
| 2000-09-06 11:00:00 | AAPL | Stock | 1.0871 | 1.0871 | 1.0804 | 1.0815 | 3197600.0 |
| 2000-09-06 11:05:00 | AAPL | Stock | 1.0815 | 1.0837 | 1.0804 | 1.0804 | 3505600.0 |
| 2000-09-06 11:10:00 | AAPL | Stock | 1.0804 | 1.0837 | 1.0804 | 1.0826 | 3477600.0 |
| 2000-09-06 11:15:00 | AAPL | Stock | 1.0815 | 1.0848 | 1.0804 | 1.0837 | 8394400.0 |
| 2000-09-06 11:20:00 | AAPL | Stock | 1.0837 | 1.0859 | 1.0837 | 1.0837 | 15276800.0 |
| 2000-09-06 11:25:00 | AAPL | Stock | 1.0837 | 1.0848 | 1.0815 | 1.0815 | 7324800.0 |
| 2000-09-06 11:30:00 | AAPL | Stock | 1.0815 | 1.0837 | 1.0804 | 1.0826 | 1114400.0 |
| 2000-09-06 11:35:00 | AAPL | Stock | 1.0815 | 1.0848 | 1.0804 | 1.0848 | 2077600.0 |
| 2000-09-06 11:40:00 | AAPL | Stock | 1.0826 | 1.0848 | 1.0826 | 1.0848 | 2307200.0 |
| 2000-09-06 11:45:00 | AAPL | Stock | 1.0848 | 1.0848 | 1.0837 | 1.0837 | 4810400.0 |
| 2000-09-06 11:50:00 | AAPL | Stock | 1.0837 | 1.0848 | 1.0826 | 1.0826 | 3382400.0 |
| 2000-09-06 11:55:00 | AAPL | Stock | 1.0826 | 1.0837 | 1.0826 | 1.0837 | 761600.0 |
| 2000-09-06 12:00:00 | AAPL | Stock | 1.0837 | 1.0837 | 1.0826 | 1.0831 | 425600.0 |
| 2000-09-06 12:05:00 | AAPL | Stock | 1.0826 | 1.0837 | 1.0815 | 1.0815 | 851200.0 |
| 2000-09-06 12:10:00 | AAPL | Stock | 1.0815 | 1.0826 | 1.0781 | 1.0781 | 1601600.0 |
| 2000-09-06 12:15:00 | AAPL | Stock | 1.0792 | 1.0815 | 1.0748 | 1.0748 | 2609600.0 |
| 2000-09-06 12:20:00 | AAPL | Stock | 1.0748 | 1.0781 | 1.0737 | 1.0737 | 3556000.0 |
| 2000-09-06 12:25:00 | AAPL | Stock | 1.077 | 1.0781 | 1.0748 | 1.0759 | 2105600.0 |
| 2000-09-06 12:30:00 | AAPL | Stock | 1.0759 | 1.0781 | 1.0748 | 1.0748 | 565600.0 |
| 2000-09-06 12:35:00 | AAPL | Stock | 1.0748 | 1.0759 | 1.0748 | 1.0748 | 1086400.0 |
| 2000-09-06 12:40:00 | AAPL | Stock | 1.0753 | 1.0759 | 1.0737 | 1.0748 | 918400.0 |
| 2000-09-06 12:45:00 | AAPL | Stock | 1.0759 | 1.0781 | 1.0737 | 1.0781 | 2536800.0 |
| 2000-09-06 12:50:00 | AAPL | Stock | 1.077 | 1.0815 | 1.077 | 1.0804 | 1909600.0 |
> showing 50 of 91,848 rows — these rows as CSV