PREVIEW / stock_5min / 2010-12-14
file: by_date/stock_5min/2010/2010-12-14.parquet size: 4.9 MB rows: 334,324 symbols: 3,529
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-14 04:00:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 13440.0 |
| 2010-12-14 04:20:00 | AAPL | Stock | 11.4768 | 11.4768 | 11.4768 | 11.4768 | 14000.0 |
| 2010-12-14 04:35:00 | AAPL | Stock | 11.4893 | 11.4893 | 11.4893 | 11.4893 | 5600.0 |
| 2010-12-14 04:50:00 | AAPL | Stock | 11.4721 | 11.4721 | 11.4718 | 11.4718 | 8400.0 |
| 2010-12-14 05:00:00 | AAPL | Stock | 11.4718 | 11.4718 | 11.4718 | 11.4718 | 2800.0 |
| 2010-12-14 05:05:00 | AAPL | Stock | 11.4846 | 11.4846 | 11.4846 | 11.4846 | 2800.0 |
| 2010-12-14 05:20:00 | AAPL | Stock | 11.4979 | 11.5043 | 11.4975 | 11.5043 | 8400.0 |
| 2010-12-14 05:25:00 | AAPL | Stock | 11.5164 | 11.5164 | 11.5071 | 11.5154 | 28000.0 |
| 2010-12-14 05:40:00 | AAPL | Stock | 11.5143 | 11.5143 | 11.5143 | 11.5143 | 2800.0 |
| 2010-12-14 05:45:00 | AAPL | Stock | 11.5293 | 11.5293 | 11.5293 | 11.5293 | 25200.0 |
| 2010-12-14 05:55:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 16800.0 |
| 2010-12-14 06:15:00 | AAPL | Stock | 11.5089 | 11.5089 | 11.5089 | 11.5089 | 28000.0 |
| 2010-12-14 06:20:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 5600.0 |
| 2010-12-14 06:25:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5179 | 11.5179 | 2800.0 |
| 2010-12-14 06:30:00 | AAPL | Stock | 11.525 | 11.5286 | 11.525 | 11.5286 | 11200.0 |
| 2010-12-14 06:40:00 | AAPL | Stock | 11.5357 | 11.5357 | 11.5357 | 11.5357 | 2800.0 |
| 2010-12-14 06:50:00 | AAPL | Stock | 11.5318 | 11.5318 | 11.5286 | 11.5286 | 8400.0 |
| 2010-12-14 06:55:00 | AAPL | Stock | 11.5179 | 11.5179 | 11.5157 | 11.5157 | 9520.0 |
| 2010-12-14 07:00:00 | AAPL | Stock | 11.5196 | 11.5214 | 11.5089 | 11.5089 | 73164.0 |
| 2010-12-14 07:05:00 | AAPL | Stock | 11.5075 | 11.5075 | 11.4821 | 11.4821 | 98000.0 |
| 2010-12-14 07:10:00 | AAPL | Stock | 11.485 | 11.5 | 11.485 | 11.5 | 82404.0 |
| 2010-12-14 07:15:00 | AAPL | Stock | 11.5 | 11.5 | 11.5 | 11.5 | 11200.0 |
| 2010-12-14 07:20:00 | AAPL | Stock | 11.5125 | 11.5125 | 11.4879 | 11.4971 | 96880.0 |
| 2010-12-14 07:25:00 | AAPL | Stock | 11.4893 | 11.4946 | 11.4893 | 11.49 | 19600.0 |
| 2010-12-14 07:30:00 | AAPL | Stock | 11.4893 | 11.4929 | 11.4893 | 11.4929 | 67200.0 |
| 2010-12-14 07:35:00 | AAPL | Stock | 11.4929 | 11.5143 | 11.4893 | 11.5129 | 207200.0 |
| 2010-12-14 07:40:00 | AAPL | Stock | 11.5161 | 11.5161 | 11.5161 | 11.5161 | 2800.0 |
| 2010-12-14 07:45:00 | AAPL | Stock | 11.5125 | 11.5125 | 11.4893 | 11.4893 | 51520.0 |
| 2010-12-14 07:50:00 | AAPL | Stock | 11.4886 | 11.4893 | 11.4679 | 11.4839 | 210700.0 |
| 2010-12-14 07:55:00 | AAPL | Stock | 11.48 | 11.4821 | 11.4775 | 11.4821 | 92400.0 |
| 2010-12-14 08:00:00 | AAPL | Stock | 11.4857 | 11.4875 | 11.4386 | 11.4468 | 1041404.0 |
| 2010-12-14 08:05:00 | AAPL | Stock | 11.4429 | 11.4625 | 11.4429 | 11.4536 | 220920.0 |
| 2010-12-14 08:10:00 | AAPL | Stock | 11.4575 | 11.4768 | 11.4571 | 11.4643 | 307580.0 |
| 2010-12-14 08:15:00 | AAPL | Stock | 11.4632 | 11.4679 | 11.4518 | 11.4536 | 336252.0 |
| 2010-12-14 08:20:00 | AAPL | Stock | 11.4543 | 11.4607 | 11.4521 | 11.4571 | 114100.0 |
| 2010-12-14 08:25:00 | AAPL | Stock | 11.455 | 11.4611 | 11.4536 | 11.4589 | 119840.0 |
| 2010-12-14 08:30:00 | AAPL | Stock | 11.4586 | 11.4718 | 11.4539 | 11.4554 | 360360.0 |
| 2010-12-14 08:35:00 | AAPL | Stock | 11.4568 | 11.4671 | 11.4546 | 11.4636 | 44380.0 |
| 2010-12-14 08:40:00 | AAPL | Stock | 11.4632 | 11.4707 | 11.4625 | 11.4679 | 147700.0 |
| 2010-12-14 08:45:00 | AAPL | Stock | 11.4675 | 11.4796 | 11.4675 | 11.4732 | 268044.0 |
| 2010-12-14 08:50:00 | AAPL | Stock | 11.4729 | 11.4764 | 11.4718 | 11.4718 | 28000.0 |
| 2010-12-14 08:55:00 | AAPL | Stock | 11.4764 | 11.4779 | 11.4718 | 11.4754 | 138180.0 |
| 2010-12-14 09:00:00 | AAPL | Stock | 11.4754 | 11.4754 | 11.4686 | 11.4686 | 275100.0 |
| 2010-12-14 09:05:00 | AAPL | Stock | 11.47 | 11.4711 | 11.4571 | 11.4571 | 856520.0 |
| 2010-12-14 09:10:00 | AAPL | Stock | 11.4611 | 11.47 | 11.4571 | 11.4643 | 77560.0 |
| 2010-12-14 09:15:00 | AAPL | Stock | 11.4646 | 11.4661 | 11.4571 | 11.4643 | 99680.0 |
| 2010-12-14 09:20:00 | AAPL | Stock | 11.4625 | 11.4714 | 11.4621 | 11.4686 | 57680.0 |
| 2010-12-14 09:25:00 | AAPL | Stock | 11.4696 | 11.4868 | 11.4679 | 11.4807 | 638428.0 |
| 2010-12-14 09:30:00 | AAPL | Stock | 11.4821 | 11.5036 | 11.4364 | 11.4643 | 14568540.0 |
| 2010-12-14 09:35:00 | AAPL | Stock | 11.4654 | 11.4825 | 11.4607 | 11.4629 | 9216592.0 |
> showing 50 of 334,324 rows — these rows as CSV