PREVIEW / stock_5min / 2008-04-28
file: by_date/stock_5min/2008/2008-04-28.parquet size: 4.3 MB rows: 308,685 symbols: 3,283
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-04-28 05:55:00 | AAPL | Stock | 6.1018 | 6.1018 | 6.1018 | 6.1018 | 5600.0 |
| 2008-04-28 06:40:00 | AAPL | Stock | 6.11 | 6.11 | 6.11 | 6.11 | 2800.0 |
| 2008-04-28 07:00:00 | AAPL | Stock | 6.1089 | 6.1129 | 6.1089 | 6.1129 | 33600.0 |
| 2008-04-28 07:10:00 | AAPL | Stock | 6.11 | 6.1161 | 6.11 | 6.1161 | 18200.0 |
| 2008-04-28 07:15:00 | AAPL | Stock | 6.1161 | 6.1161 | 6.1161 | 6.1161 | 2800.0 |
| 2008-04-28 07:25:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 19880.0 |
| 2008-04-28 07:30:00 | AAPL | Stock | 6.1071 | 6.1071 | 6.1071 | 6.1071 | 28000.0 |
| 2008-04-28 07:35:00 | AAPL | Stock | 6.0957 | 6.105 | 6.0893 | 6.105 | 16800.0 |
| 2008-04-28 07:40:00 | AAPL | Stock | 6.1036 | 6.1036 | 6.1036 | 6.1036 | 30800.0 |
| 2008-04-28 07:50:00 | AAPL | Stock | 6.0993 | 6.0993 | 6.0982 | 6.0982 | 16800.0 |
| 2008-04-28 07:55:00 | AAPL | Stock | 6.1043 | 6.1071 | 6.1043 | 6.1071 | 41104.0 |
| 2008-04-28 08:00:00 | AAPL | Stock | 6.1086 | 6.1086 | 6.0625 | 6.0829 | 1331848.0 |
| 2008-04-28 08:05:00 | AAPL | Stock | 6.0839 | 6.09 | 6.0821 | 6.0825 | 193844.0 |
| 2008-04-28 08:10:00 | AAPL | Stock | 6.0861 | 6.0861 | 6.0714 | 6.0714 | 237580.0 |
| 2008-04-28 08:15:00 | AAPL | Stock | 6.0714 | 6.0857 | 6.0679 | 6.0761 | 213360.0 |
| 2008-04-28 08:20:00 | AAPL | Stock | 6.0782 | 6.0832 | 6.0736 | 6.0832 | 164164.0 |
| 2008-04-28 08:25:00 | AAPL | Stock | 6.0825 | 6.0832 | 6.0789 | 6.0789 | 141008.0 |
| 2008-04-28 08:30:00 | AAPL | Stock | 6.08 | 6.0982 | 6.0789 | 6.0982 | 227668.0 |
| 2008-04-28 08:35:00 | AAPL | Stock | 6.0961 | 6.1 | 6.0893 | 6.0946 | 271628.0 |
| 2008-04-28 08:40:00 | AAPL | Stock | 6.0929 | 6.0964 | 6.0886 | 6.0886 | 276304.0 |
| 2008-04-28 08:45:00 | AAPL | Stock | 6.0886 | 6.0896 | 6.085 | 6.0896 | 61600.0 |
| 2008-04-28 08:50:00 | AAPL | Stock | 6.0896 | 6.0907 | 6.0818 | 6.0907 | 231980.0 |
| 2008-04-28 08:55:00 | AAPL | Stock | 6.0896 | 6.0911 | 6.0857 | 6.0861 | 112224.0 |
| 2008-04-28 09:00:00 | AAPL | Stock | 6.0879 | 6.0896 | 6.0857 | 6.0882 | 287476.0 |
| 2008-04-28 09:05:00 | AAPL | Stock | 6.0893 | 6.0893 | 6.0821 | 6.0825 | 70784.0 |
| 2008-04-28 09:10:00 | AAPL | Stock | 6.0829 | 6.0839 | 6.0789 | 6.0839 | 182000.0 |
| 2008-04-28 09:15:00 | AAPL | Stock | 6.0854 | 6.0868 | 6.0825 | 6.0854 | 140000.0 |
| 2008-04-28 09:20:00 | AAPL | Stock | 6.0839 | 6.0839 | 6.0739 | 6.0771 | 105980.0 |
| 2008-04-28 09:25:00 | AAPL | Stock | 6.0786 | 6.0786 | 6.0604 | 6.0632 | 659568.0 |
| 2008-04-28 09:30:00 | AAPL | Stock | 6.0636 | 6.0854 | 6.0404 | 6.0625 | 22056440.0 |
| 2008-04-28 09:35:00 | AAPL | Stock | 6.0629 | 6.0893 | 6.0536 | 6.0743 | 17808056.0 |
| 2008-04-28 09:40:00 | AAPL | Stock | 6.0754 | 6.1021 | 6.0746 | 6.0936 | 19478060.0 |
| 2008-04-28 09:45:00 | AAPL | Stock | 6.0943 | 6.0945 | 6.0675 | 6.0911 | 18083940.0 |
| 2008-04-28 09:50:00 | AAPL | Stock | 6.0914 | 6.1143 | 6.0821 | 6.1071 | 20297760.0 |
| 2008-04-28 09:55:00 | AAPL | Stock | 6.1071 | 6.1207 | 6.0954 | 6.1036 | 16352140.0 |
| 2008-04-28 10:00:00 | AAPL | Stock | 6.1029 | 6.1107 | 6.0857 | 6.0979 | 13547212.0 |
| 2008-04-28 10:05:00 | AAPL | Stock | 6.0992 | 6.0992 | 6.0721 | 6.09 | 13481104.0 |
| 2008-04-28 10:10:00 | AAPL | Stock | 6.0896 | 6.1189 | 6.0886 | 6.1189 | 15159228.0 |
| 2008-04-28 10:15:00 | AAPL | Stock | 6.1182 | 6.1246 | 6.0982 | 6.0996 | 12245268.0 |
| 2008-04-28 10:20:00 | AAPL | Stock | 6.0996 | 6.1107 | 6.0936 | 6.1054 | 9836680.0 |
| 2008-04-28 10:25:00 | AAPL | Stock | 6.1043 | 6.1118 | 6.0964 | 6.0982 | 8132684.0 |
| 2008-04-28 10:30:00 | AAPL | Stock | 6.0982 | 6.1246 | 6.0964 | 6.1168 | 11222008.0 |
| 2008-04-28 10:35:00 | AAPL | Stock | 6.1161 | 6.125 | 6.1129 | 6.1229 | 11061820.0 |
| 2008-04-28 10:40:00 | AAPL | Stock | 6.1225 | 6.1296 | 6.12 | 6.1286 | 12440708.0 |
| 2008-04-28 10:45:00 | AAPL | Stock | 6.1286 | 6.1446 | 6.1282 | 6.1314 | 19878908.0 |
| 2008-04-28 10:50:00 | AAPL | Stock | 6.1314 | 6.1382 | 6.1268 | 6.1318 | 9059372.0 |
| 2008-04-28 10:55:00 | AAPL | Stock | 6.1318 | 6.1389 | 6.1271 | 6.1386 | 8043476.0 |
| 2008-04-28 11:00:00 | AAPL | Stock | 6.1389 | 6.1475 | 6.1293 | 6.1425 | 10528476.0 |
| 2008-04-28 11:05:00 | AAPL | Stock | 6.1414 | 6.1518 | 6.1346 | 6.1386 | 11847136.0 |
| 2008-04-28 11:10:00 | AAPL | Stock | 6.1371 | 6.1407 | 6.1254 | 6.1296 | 7994560.0 |
> showing 50 of 308,685 rows — these rows as CSV