PREVIEW / stock_5min / 2009-11-09
file: by_date/stock_5min/2009/2009-11-09.parquet size: 4.7 MB rows: 320,645 symbols: 3,416
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-11-09 04:15:00 | AAPL | Stock | 6.9582 | 6.9582 | 6.9582 | 6.9582 | 2800.0 |
| 2009-11-09 04:25:00 | AAPL | Stock | 6.9604 | 6.9604 | 6.9604 | 6.9604 | 2800.0 |
| 2009-11-09 04:30:00 | AAPL | Stock | 6.9675 | 6.9675 | 6.9614 | 6.9614 | 5600.0 |
| 2009-11-09 05:05:00 | AAPL | Stock | 7.0139 | 7.0139 | 7.0139 | 7.0139 | 2800.0 |
| 2009-11-09 07:00:00 | AAPL | Stock | 7.0071 | 7.0071 | 7.0071 | 7.0071 | 2800.0 |
| 2009-11-09 07:05:00 | AAPL | Stock | 7.0 | 7.0029 | 6.9989 | 6.9989 | 111776.0 |
| 2009-11-09 07:10:00 | AAPL | Stock | 7.0154 | 7.0154 | 7.0154 | 7.0154 | 28000.0 |
| 2009-11-09 07:15:00 | AAPL | Stock | 7.0104 | 7.0107 | 7.0104 | 7.0107 | 11200.0 |
| 2009-11-09 07:25:00 | AAPL | Stock | 7.0011 | 7.0011 | 7.0011 | 7.0011 | 2800.0 |
| 2009-11-09 07:30:00 | AAPL | Stock | 7.0118 | 7.0139 | 7.0114 | 7.0139 | 43316.0 |
| 2009-11-09 07:35:00 | AAPL | Stock | 7.0043 | 7.0171 | 7.0043 | 7.0161 | 33600.0 |
| 2009-11-09 07:40:00 | AAPL | Stock | 7.0179 | 7.0261 | 7.0179 | 7.0261 | 10640.0 |
| 2009-11-09 07:45:00 | AAPL | Stock | 7.0246 | 7.0361 | 7.0246 | 7.0357 | 74424.0 |
| 2009-11-09 08:00:00 | AAPL | Stock | 7.0268 | 7.0357 | 7.0179 | 7.0343 | 334124.0 |
| 2009-11-09 08:05:00 | AAPL | Stock | 7.0343 | 7.0343 | 7.0296 | 7.0332 | 462084.0 |
| 2009-11-09 08:10:00 | AAPL | Stock | 7.0336 | 7.0404 | 7.0336 | 7.0404 | 209860.0 |
| 2009-11-09 08:15:00 | AAPL | Stock | 7.0389 | 7.0479 | 7.0389 | 7.0407 | 223944.0 |
| 2009-11-09 08:20:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0357 | 7.0359 | 101052.0 |
| 2009-11-09 08:25:00 | AAPL | Stock | 7.0357 | 7.0375 | 7.0357 | 7.0357 | 91000.0 |
| 2009-11-09 08:30:00 | AAPL | Stock | 7.0357 | 7.0375 | 7.0289 | 7.0293 | 241556.0 |
| 2009-11-09 08:35:00 | AAPL | Stock | 7.0293 | 7.0375 | 7.0286 | 7.0357 | 127456.0 |
| 2009-11-09 08:40:00 | AAPL | Stock | 7.0321 | 7.0396 | 7.0321 | 7.0357 | 166460.0 |
| 2009-11-09 08:45:00 | AAPL | Stock | 7.0357 | 7.0411 | 7.0355 | 7.0357 | 106260.0 |
| 2009-11-09 08:50:00 | AAPL | Stock | 7.0354 | 7.0357 | 7.0346 | 7.0357 | 42924.0 |
| 2009-11-09 08:55:00 | AAPL | Stock | 7.0354 | 7.0386 | 7.0346 | 7.0386 | 104720.0 |
| 2009-11-09 09:00:00 | AAPL | Stock | 7.0386 | 7.0418 | 7.0343 | 7.0418 | 140140.0 |
| 2009-11-09 09:05:00 | AAPL | Stock | 7.0414 | 7.0425 | 7.0371 | 7.0379 | 131600.0 |
| 2009-11-09 09:10:00 | AAPL | Stock | 7.0379 | 7.0389 | 7.0375 | 7.0375 | 107800.0 |
| 2009-11-09 09:15:00 | AAPL | Stock | 7.0375 | 7.0375 | 7.0321 | 7.0354 | 424256.0 |
| 2009-11-09 09:20:00 | AAPL | Stock | 7.0346 | 7.0354 | 7.0318 | 7.0339 | 91000.0 |
| 2009-11-09 09:25:00 | AAPL | Stock | 7.0321 | 7.0346 | 7.0311 | 7.0311 | 183400.0 |
| 2009-11-09 09:30:00 | AAPL | Stock | 7.0336 | 7.0357 | 7.0093 | 7.0171 | 15462860.0 |
| 2009-11-09 09:35:00 | AAPL | Stock | 7.0171 | 7.0414 | 7.0161 | 7.038 | 14305004.0 |
| 2009-11-09 09:40:00 | AAPL | Stock | 7.0386 | 7.0836 | 7.0318 | 7.0807 | 21113036.0 |
| 2009-11-09 09:45:00 | AAPL | Stock | 7.0818 | 7.0893 | 7.0339 | 7.0625 | 13053180.0 |
| 2009-11-09 09:50:00 | AAPL | Stock | 7.0632 | 7.08 | 7.0568 | 7.0775 | 8844052.0 |
| 2009-11-09 09:55:00 | AAPL | Stock | 7.0773 | 7.0804 | 7.065 | 7.0675 | 6033608.0 |
| 2009-11-09 10:00:00 | AAPL | Stock | 7.0671 | 7.0846 | 7.0671 | 7.0761 | 8663900.0 |
| 2009-11-09 10:05:00 | AAPL | Stock | 7.075 | 7.0996 | 7.075 | 7.0932 | 13261948.0 |
| 2009-11-09 10:10:00 | AAPL | Stock | 7.0929 | 7.1239 | 7.0911 | 7.1161 | 14576044.0 |
| 2009-11-09 10:15:00 | AAPL | Stock | 7.1171 | 7.1214 | 7.1093 | 7.115 | 9071916.0 |
| 2009-11-09 10:20:00 | AAPL | Stock | 7.115 | 7.1232 | 7.1082 | 7.1162 | 7946960.0 |
| 2009-11-09 10:25:00 | AAPL | Stock | 7.1161 | 7.1164 | 7.1057 | 7.1071 | 5761392.0 |
| 2009-11-09 10:30:00 | AAPL | Stock | 7.1057 | 7.1104 | 7.1 | 7.1021 | 5480524.0 |
| 2009-11-09 10:35:00 | AAPL | Stock | 7.1031 | 7.1204 | 7.1025 | 7.1189 | 5145476.0 |
| 2009-11-09 10:40:00 | AAPL | Stock | 7.1188 | 7.1232 | 7.1104 | 7.1193 | 4587212.0 |
| 2009-11-09 10:45:00 | AAPL | Stock | 7.1193 | 7.1304 | 7.1161 | 7.1257 | 8498364.0 |
| 2009-11-09 10:50:00 | AAPL | Stock | 7.1271 | 7.1282 | 7.1179 | 7.1246 | 4743452.0 |
| 2009-11-09 10:55:00 | AAPL | Stock | 7.1222 | 7.1236 | 7.115 | 7.1179 | 3896060.0 |
| 2009-11-09 11:00:00 | AAPL | Stock | 7.1186 | 7.125 | 7.1154 | 7.1211 | 3210144.0 |
> showing 50 of 320,645 rows — these rows as CSV