PREVIEW / stock_5min / 2009-12-04
file: by_date/stock_5min/2009/2009-12-04.parquet size: 4.7 MB rows: 321,272 symbols: 3,435
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 |
|---|---|---|---|---|---|---|---|
| 2009-12-04 04:35:00 | AAPL | Stock | 7.0136 | 7.0136 | 7.0136 | 7.0136 | 2800.0 |
| 2009-12-04 07:00:00 | AAPL | Stock | 7.0104 | 7.0104 | 7.0104 | 7.0104 | 17304.0 |
| 2009-12-04 07:25:00 | AAPL | Stock | 7.0096 | 7.0107 | 7.0096 | 7.0107 | 11200.0 |
| 2009-12-04 07:30:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0039 | 7.0039 | 8400.0 |
| 2009-12-04 07:35:00 | AAPL | Stock | 7.0039 | 7.0039 | 7.0039 | 7.0039 | 2800.0 |
| 2009-12-04 07:40:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0032 | 7.0032 | 8400.0 |
| 2009-12-04 07:45:00 | AAPL | Stock | 7.0036 | 7.0036 | 7.0004 | 7.0004 | 114800.0 |
| 2009-12-04 07:55:00 | AAPL | Stock | 7.0071 | 7.0071 | 7.0004 | 7.0004 | 5600.0 |
| 2009-12-04 08:00:00 | AAPL | Stock | 7.0039 | 7.0071 | 6.9975 | 6.9975 | 115388.0 |
| 2009-12-04 08:05:00 | AAPL | Stock | 6.9982 | 6.9982 | 6.9911 | 6.9925 | 90048.0 |
| 2009-12-04 08:10:00 | AAPL | Stock | 6.9929 | 6.9982 | 6.9914 | 6.9982 | 151340.0 |
| 2009-12-04 08:15:00 | AAPL | Stock | 6.9979 | 7.0036 | 6.9966 | 6.9966 | 173320.0 |
| 2009-12-04 08:20:00 | AAPL | Stock | 7.0 | 7.0036 | 7.0 | 7.0 | 220780.0 |
| 2009-12-04 08:25:00 | AAPL | Stock | 6.9975 | 7.0246 | 6.9964 | 7.0246 | 382340.0 |
| 2009-12-04 08:30:00 | AAPL | Stock | 7.0182 | 7.1179 | 7.0161 | 7.1071 | 4227076.0 |
| 2009-12-04 08:35:00 | AAPL | Stock | 7.1075 | 7.1418 | 7.1071 | 7.1418 | 2177784.0 |
| 2009-12-04 08:40:00 | AAPL | Stock | 7.1418 | 7.1429 | 7.1161 | 7.1182 | 1209012.0 |
| 2009-12-04 08:45:00 | AAPL | Stock | 7.1168 | 7.1239 | 7.1118 | 7.1179 | 739004.0 |
| 2009-12-04 08:50:00 | AAPL | Stock | 7.1121 | 7.115 | 7.1086 | 7.1114 | 503636.0 |
| 2009-12-04 08:55:00 | AAPL | Stock | 7.1129 | 7.1214 | 7.1129 | 7.1179 | 310072.0 |
| 2009-12-04 09:00:00 | AAPL | Stock | 7.1193 | 7.1232 | 7.1179 | 7.1221 | 372764.0 |
| 2009-12-04 09:05:00 | AAPL | Stock | 7.1229 | 7.1357 | 7.1229 | 7.1275 | 640640.0 |
| 2009-12-04 09:10:00 | AAPL | Stock | 7.1261 | 7.1411 | 7.125 | 7.1404 | 409220.0 |
| 2009-12-04 09:15:00 | AAPL | Stock | 7.1393 | 7.1393 | 7.1304 | 7.1354 | 503748.0 |
| 2009-12-04 09:20:00 | AAPL | Stock | 7.1391 | 7.1393 | 7.1286 | 7.1304 | 456540.0 |
| 2009-12-04 09:25:00 | AAPL | Stock | 7.1293 | 7.1361 | 7.1214 | 7.1289 | 365148.0 |
| 2009-12-04 09:30:00 | AAPL | Stock | 7.1293 | 7.1386 | 7.0929 | 7.0964 | 17214120.0 |
| 2009-12-04 09:35:00 | AAPL | Stock | 7.0964 | 7.1332 | 7.0929 | 7.1186 | 17911824.0 |
| 2009-12-04 09:40:00 | AAPL | Stock | 7.12 | 7.1221 | 7.1004 | 7.1207 | 11348064.0 |
| 2009-12-04 09:45:00 | AAPL | Stock | 7.1207 | 7.1321 | 7.1193 | 7.1296 | 9746520.0 |
| 2009-12-04 09:50:00 | AAPL | Stock | 7.1299 | 7.1307 | 7.1107 | 7.1118 | 8093204.0 |
| 2009-12-04 09:55:00 | AAPL | Stock | 7.1132 | 7.1257 | 7.1121 | 7.1214 | 8165724.0 |
| 2009-12-04 10:00:00 | AAPL | Stock | 7.1225 | 7.1254 | 7.0971 | 7.0986 | 10833648.0 |
| 2009-12-04 10:05:00 | AAPL | Stock | 7.098 | 7.1016 | 7.0764 | 7.0907 | 17108560.0 |
| 2009-12-04 10:10:00 | AAPL | Stock | 7.0904 | 7.0957 | 7.0811 | 7.0943 | 6725068.0 |
| 2009-12-04 10:15:00 | AAPL | Stock | 7.0943 | 7.0993 | 7.0821 | 7.0821 | 6396628.0 |
| 2009-12-04 10:20:00 | AAPL | Stock | 7.0842 | 7.0893 | 7.0786 | 7.085 | 4964316.0 |
| 2009-12-04 10:25:00 | AAPL | Stock | 7.0839 | 7.0991 | 7.0831 | 7.0956 | 5944288.0 |
| 2009-12-04 10:30:00 | AAPL | Stock | 7.0957 | 7.0986 | 7.0889 | 7.0893 | 3408104.0 |
| 2009-12-04 10:35:00 | AAPL | Stock | 7.09 | 7.0936 | 7.0807 | 7.0827 | 5729276.0 |
| 2009-12-04 10:40:00 | AAPL | Stock | 7.0829 | 7.0839 | 7.0643 | 7.0714 | 11382112.0 |
| 2009-12-04 10:45:00 | AAPL | Stock | 7.0729 | 7.08 | 7.0661 | 7.0691 | 5212032.0 |
| 2009-12-04 10:50:00 | AAPL | Stock | 7.0693 | 7.0696 | 7.0493 | 7.0551 | 8335964.0 |
| 2009-12-04 10:55:00 | AAPL | Stock | 7.0554 | 7.0579 | 7.0382 | 7.0538 | 8188404.0 |
| 2009-12-04 11:00:00 | AAPL | Stock | 7.0532 | 7.0546 | 7.0318 | 7.0354 | 11248300.0 |
| 2009-12-04 11:05:00 | AAPL | Stock | 7.0357 | 7.0379 | 7.0171 | 7.0379 | 12735296.0 |
| 2009-12-04 11:10:00 | AAPL | Stock | 7.0375 | 7.0554 | 7.031 | 7.0543 | 7268716.0 |
| 2009-12-04 11:15:00 | AAPL | Stock | 7.0547 | 7.055 | 7.0314 | 7.0339 | 6120548.0 |
| 2009-12-04 11:20:00 | AAPL | Stock | 7.0338 | 7.0468 | 7.0293 | 7.0429 | 3839528.0 |
| 2009-12-04 11:25:00 | AAPL | Stock | 7.0424 | 7.0439 | 7.0136 | 7.0146 | 5698448.0 |
> showing 50 of 321,272 rows — these rows as CSV