PREVIEW / stock_5min / 2009-03-10
file: by_date/stock_5min/2009/2009-03-10.parquet size: 4.6 MB rows: 317,836 symbols: 3,361
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-03-10 04:15:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 16800.0 |
| 2009-03-10 04:25:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 2800.0 |
| 2009-03-10 04:40:00 | AAPL | Stock | 3.0046 | 3.0046 | 3.0046 | 3.0046 | 8400.0 |
| 2009-03-10 06:40:00 | AAPL | Stock | 3.0136 | 3.0136 | 3.0136 | 3.0136 | 2800.0 |
| 2009-03-10 07:10:00 | AAPL | Stock | 3.0146 | 3.0146 | 3.0146 | 3.0146 | 2800.0 |
| 2009-03-10 07:20:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0161 | 3.0161 | 2800.0 |
| 2009-03-10 07:30:00 | AAPL | Stock | 3.0161 | 3.0161 | 3.0161 | 3.0161 | 2800.0 |
| 2009-03-10 07:35:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0264 | 3.0264 | 2800.0 |
| 2009-03-10 07:40:00 | AAPL | Stock | 3.0214 | 3.025 | 3.0214 | 3.025 | 39200.0 |
| 2009-03-10 07:45:00 | AAPL | Stock | 3.0264 | 3.0264 | 3.0179 | 3.0179 | 11200.0 |
| 2009-03-10 07:50:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 2800.0 |
| 2009-03-10 07:55:00 | AAPL | Stock | 3.0179 | 3.0179 | 3.0179 | 3.0179 | 81200.0 |
| 2009-03-10 08:00:00 | AAPL | Stock | 3.0179 | 3.0264 | 3.0179 | 3.0257 | 139552.0 |
| 2009-03-10 08:05:00 | AAPL | Stock | 3.0271 | 3.0286 | 3.0254 | 3.0261 | 58212.0 |
| 2009-03-10 08:10:00 | AAPL | Stock | 3.025 | 3.0268 | 3.0221 | 3.0264 | 212828.0 |
| 2009-03-10 08:15:00 | AAPL | Stock | 3.0279 | 3.0357 | 3.0279 | 3.0357 | 110320.0 |
| 2009-03-10 08:20:00 | AAPL | Stock | 3.0354 | 3.0354 | 3.0304 | 3.0304 | 49168.0 |
| 2009-03-10 08:25:00 | AAPL | Stock | 3.0304 | 3.0339 | 3.0254 | 3.0264 | 225372.0 |
| 2009-03-10 08:30:00 | AAPL | Stock | 3.0268 | 3.03 | 3.0268 | 3.0293 | 39200.0 |
| 2009-03-10 08:35:00 | AAPL | Stock | 3.0293 | 3.0332 | 3.0293 | 3.0296 | 108444.0 |
| 2009-03-10 08:40:00 | AAPL | Stock | 3.03 | 3.0393 | 3.0296 | 3.0393 | 482524.0 |
| 2009-03-10 08:45:00 | AAPL | Stock | 3.0432 | 3.0489 | 3.0357 | 3.0471 | 340144.0 |
| 2009-03-10 08:50:00 | AAPL | Stock | 3.0471 | 3.0471 | 3.0357 | 3.0393 | 183316.0 |
| 2009-03-10 08:55:00 | AAPL | Stock | 3.0386 | 3.0429 | 3.0361 | 3.0411 | 105000.0 |
| 2009-03-10 09:00:00 | AAPL | Stock | 3.0386 | 3.04 | 3.0343 | 3.0357 | 89908.0 |
| 2009-03-10 09:05:00 | AAPL | Stock | 3.0368 | 3.04 | 3.0368 | 3.0368 | 44520.0 |
| 2009-03-10 09:10:00 | AAPL | Stock | 3.0375 | 3.04 | 3.0357 | 3.0389 | 195272.0 |
| 2009-03-10 09:15:00 | AAPL | Stock | 3.0393 | 3.04 | 3.0314 | 3.0314 | 227808.0 |
| 2009-03-10 09:20:00 | AAPL | Stock | 3.0318 | 3.0318 | 3.0232 | 3.0268 | 283052.0 |
| 2009-03-10 09:25:00 | AAPL | Stock | 3.03 | 3.0325 | 3.0254 | 3.0311 | 403424.0 |
| 2009-03-10 09:30:00 | AAPL | Stock | 3.0311 | 3.0339 | 3.0129 | 3.0257 | 19563516.0 |
| 2009-03-10 09:35:00 | AAPL | Stock | 3.0254 | 3.0525 | 3.0196 | 3.0471 | 20565944.0 |
| 2009-03-10 09:40:00 | AAPL | Stock | 3.0479 | 3.08 | 3.0436 | 3.0757 | 19571300.0 |
| 2009-03-10 09:45:00 | AAPL | Stock | 3.0757 | 3.0946 | 3.0746 | 3.0839 | 18650044.0 |
| 2009-03-10 09:50:00 | AAPL | Stock | 3.0832 | 3.0929 | 3.0696 | 3.0796 | 17408496.0 |
| 2009-03-10 09:55:00 | AAPL | Stock | 3.0796 | 3.0825 | 3.0496 | 3.0496 | 14625940.0 |
| 2009-03-10 10:00:00 | AAPL | Stock | 3.0497 | 3.0829 | 3.0482 | 3.0771 | 17083976.0 |
| 2009-03-10 10:05:00 | AAPL | Stock | 3.0771 | 3.0986 | 3.0739 | 3.0957 | 14670684.0 |
| 2009-03-10 10:10:00 | AAPL | Stock | 3.0968 | 3.1054 | 3.09 | 3.1029 | 9279760.0 |
| 2009-03-10 10:15:00 | AAPL | Stock | 3.1032 | 3.1143 | 3.0986 | 3.1079 | 17565268.0 |
| 2009-03-10 10:20:00 | AAPL | Stock | 3.1079 | 3.1196 | 3.1039 | 3.1139 | 11517576.0 |
| 2009-03-10 10:25:00 | AAPL | Stock | 3.1139 | 3.1139 | 3.1039 | 3.1071 | 9191364.0 |
| 2009-03-10 10:30:00 | AAPL | Stock | 3.1075 | 3.1168 | 3.1015 | 3.1021 | 10256876.0 |
| 2009-03-10 10:35:00 | AAPL | Stock | 3.1014 | 3.125 | 3.0982 | 3.1222 | 15063048.0 |
| 2009-03-10 10:40:00 | AAPL | Stock | 3.1225 | 3.1246 | 3.1096 | 3.1154 | 12099892.0 |
| 2009-03-10 10:45:00 | AAPL | Stock | 3.1157 | 3.1318 | 3.1154 | 3.1275 | 11213272.0 |
| 2009-03-10 10:50:00 | AAPL | Stock | 3.1275 | 3.1371 | 3.1229 | 3.1254 | 13397328.0 |
| 2009-03-10 10:55:00 | AAPL | Stock | 3.1254 | 3.1264 | 3.1171 | 3.1239 | 8009960.0 |
| 2009-03-10 11:00:00 | AAPL | Stock | 3.1239 | 3.1239 | 3.1004 | 3.1054 | 14876204.0 |
| 2009-03-10 11:05:00 | AAPL | Stock | 3.1058 | 3.1104 | 3.0989 | 3.1071 | 8472716.0 |
> showing 50 of 317,836 rows — these rows as CSV