PREVIEW / stock_5min / 2008-10-14
file: by_date/stock_5min/2008/2008-10-14.parquet size: 4.8 MB rows: 340,190 symbols: 3,373
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-14 04:25:00 | AAPL | Stock | 4.1071 | 4.1071 | 4.1068 | 4.1071 | 61600.0 |
| 2008-10-14 04:40:00 | AAPL | Stock | 4.1071 | 4.1071 | 4.1 | 4.1 | 14000.0 |
| 2008-10-14 04:45:00 | AAPL | Stock | 4.1 | 4.1071 | 4.0893 | 4.0893 | 16800.0 |
| 2008-10-14 04:50:00 | AAPL | Stock | 4.1071 | 4.1071 | 4.0893 | 4.0893 | 26600.0 |
| 2008-10-14 04:55:00 | AAPL | Stock | 4.0893 | 4.0946 | 4.0804 | 4.0943 | 11200.0 |
| 2008-10-14 05:00:00 | AAPL | Stock | 4.0946 | 4.0946 | 4.0946 | 4.0946 | 2800.0 |
| 2008-10-14 05:05:00 | AAPL | Stock | 4.0946 | 4.1046 | 4.0714 | 4.0714 | 92400.0 |
| 2008-10-14 05:10:00 | AAPL | Stock | 4.075 | 4.075 | 4.0714 | 4.0714 | 14000.0 |
| 2008-10-14 05:50:00 | AAPL | Stock | 4.1043 | 4.1046 | 4.1043 | 4.1046 | 5600.0 |
| 2008-10-14 05:55:00 | AAPL | Stock | 4.1046 | 4.1046 | 4.1046 | 4.1046 | 7700.0 |
| 2008-10-14 06:00:00 | AAPL | Stock | 4.1046 | 4.1046 | 4.1046 | 4.1046 | 2800.0 |
| 2008-10-14 06:10:00 | AAPL | Stock | 4.1164 | 4.1164 | 4.1161 | 4.1161 | 16800.0 |
| 2008-10-14 06:15:00 | AAPL | Stock | 4.1161 | 4.1161 | 4.1161 | 4.1161 | 7476.0 |
| 2008-10-14 06:25:00 | AAPL | Stock | 4.1075 | 4.125 | 4.1071 | 4.125 | 39032.0 |
| 2008-10-14 06:30:00 | AAPL | Stock | 4.1246 | 4.125 | 4.1246 | 4.125 | 62776.0 |
| 2008-10-14 06:35:00 | AAPL | Stock | 4.125 | 4.125 | 4.125 | 4.125 | 16800.0 |
| 2008-10-14 06:40:00 | AAPL | Stock | 4.125 | 4.125 | 4.125 | 4.125 | 36400.0 |
| 2008-10-14 06:45:00 | AAPL | Stock | 4.125 | 4.125 | 4.125 | 4.125 | 9016.0 |
| 2008-10-14 06:50:00 | AAPL | Stock | 4.125 | 4.125 | 4.1171 | 4.1171 | 30800.0 |
| 2008-10-14 06:55:00 | AAPL | Stock | 4.125 | 4.125 | 4.125 | 4.125 | 74592.0 |
| 2008-10-14 07:00:00 | AAPL | Stock | 4.1168 | 4.1357 | 4.0979 | 4.0982 | 197288.0 |
| 2008-10-14 07:05:00 | AAPL | Stock | 4.0893 | 4.1071 | 4.0893 | 4.1 | 35140.0 |
| 2008-10-14 07:10:00 | AAPL | Stock | 4.1 | 4.1054 | 4.0893 | 4.0893 | 86520.0 |
| 2008-10-14 07:15:00 | AAPL | Stock | 4.0964 | 4.1 | 4.0964 | 4.1 | 28000.0 |
| 2008-10-14 07:20:00 | AAPL | Stock | 4.1 | 4.1 | 4.0893 | 4.0893 | 434028.0 |
| 2008-10-14 07:25:00 | AAPL | Stock | 4.0893 | 4.0893 | 4.0804 | 4.0821 | 53956.0 |
| 2008-10-14 07:30:00 | AAPL | Stock | 4.0893 | 4.1 | 4.0821 | 4.1 | 53200.0 |
| 2008-10-14 07:35:00 | AAPL | Stock | 4.0921 | 4.1 | 4.0857 | 4.1 | 187180.0 |
| 2008-10-14 07:40:00 | AAPL | Stock | 4.0875 | 4.1 | 4.0 | 4.0 | 384300.0 |
| 2008-10-14 07:45:00 | AAPL | Stock | 4.0625 | 4.0786 | 4.0625 | 4.0714 | 182000.0 |
| 2008-10-14 07:50:00 | AAPL | Stock | 4.0679 | 4.0893 | 4.0679 | 4.0714 | 175000.0 |
| 2008-10-14 07:55:00 | AAPL | Stock | 4.0718 | 4.0832 | 4.0714 | 4.0768 | 457520.0 |
| 2008-10-14 08:00:00 | AAPL | Stock | 4.0821 | 4.0921 | 4.0714 | 4.0843 | 1237096.0 |
| 2008-10-14 08:05:00 | AAPL | Stock | 4.0821 | 4.0914 | 4.075 | 4.0779 | 647920.0 |
| 2008-10-14 08:10:00 | AAPL | Stock | 4.0789 | 4.0893 | 4.0786 | 4.0839 | 795088.0 |
| 2008-10-14 08:15:00 | AAPL | Stock | 4.0807 | 4.0882 | 4.0804 | 4.0821 | 653324.0 |
| 2008-10-14 08:20:00 | AAPL | Stock | 4.0854 | 4.1036 | 4.0821 | 4.0996 | 868196.0 |
| 2008-10-14 08:25:00 | AAPL | Stock | 4.0982 | 4.1036 | 4.0982 | 4.1018 | 408632.0 |
| 2008-10-14 08:30:00 | AAPL | Stock | 4.1018 | 4.1064 | 4.0893 | 4.1054 | 592872.0 |
| 2008-10-14 08:35:00 | AAPL | Stock | 4.1054 | 4.1321 | 4.1054 | 4.1314 | 904652.0 |
| 2008-10-14 08:40:00 | AAPL | Stock | 4.1318 | 4.1486 | 4.125 | 4.1289 | 1296372.0 |
| 2008-10-14 08:45:00 | AAPL | Stock | 4.1289 | 4.1393 | 4.1189 | 4.1318 | 971796.0 |
| 2008-10-14 08:50:00 | AAPL | Stock | 4.1336 | 4.1393 | 4.1071 | 4.1111 | 1189860.0 |
| 2008-10-14 08:55:00 | AAPL | Stock | 4.1111 | 4.1311 | 4.1107 | 4.1207 | 1121400.0 |
| 2008-10-14 09:00:00 | AAPL | Stock | 4.1207 | 4.1207 | 4.0957 | 4.0964 | 1011360.0 |
| 2008-10-14 09:05:00 | AAPL | Stock | 4.0964 | 4.1064 | 4.0889 | 4.0979 | 1208480.0 |
| 2008-10-14 09:10:00 | AAPL | Stock | 4.0964 | 4.1068 | 4.0829 | 4.0993 | 1198232.0 |
| 2008-10-14 09:15:00 | AAPL | Stock | 4.1011 | 4.1125 | 4.1011 | 4.1071 | 953960.0 |
| 2008-10-14 09:20:00 | AAPL | Stock | 4.1071 | 4.1139 | 4.1043 | 4.1043 | 796936.0 |
| 2008-10-14 09:25:00 | AAPL | Stock | 4.105 | 4.1607 | 4.0736 | 4.1511 | 11289824.0 |
> showing 50 of 340,190 rows — these rows as CSV