PREVIEW / stock_5min / 2012-08-22
file: by_date/stock_5min/2012/2012-08-22.parquet size: 4.6 MB rows: 308,025 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2012-08-22 04:00:00 | AAPL | Stock | 23.4286 | 23.4286 | 23.4286 | 23.4286 | 2800.0 |
| 2012-08-22 04:05:00 | AAPL | Stock | 23.4357 | 23.4393 | 23.4357 | 23.4393 | 14000.0 |
| 2012-08-22 04:10:00 | AAPL | Stock | 23.4393 | 23.4393 | 23.4393 | 23.4393 | 8400.0 |
| 2012-08-22 04:30:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 2800.0 |
| 2012-08-22 04:50:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 2800.0 |
| 2012-08-22 04:55:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 2800.0 |
| 2012-08-22 05:00:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 5600.0 |
| 2012-08-22 05:10:00 | AAPL | Stock | 23.5 | 23.5 | 23.5 | 23.5 | 2800.0 |
| 2012-08-22 05:15:00 | AAPL | Stock | 23.475 | 23.5 | 23.475 | 23.4911 | 28084.0 |
| 2012-08-22 05:20:00 | AAPL | Stock | 23.4875 | 23.4875 | 23.4875 | 23.4875 | 11200.0 |
| 2012-08-22 06:00:00 | AAPL | Stock | 23.4696 | 23.4696 | 23.4686 | 23.4686 | 5600.0 |
| 2012-08-22 06:10:00 | AAPL | Stock | 23.475 | 23.475 | 23.475 | 23.475 | 2800.0 |
| 2012-08-22 06:15:00 | AAPL | Stock | 23.4839 | 23.4839 | 23.4839 | 23.4839 | 2800.0 |
| 2012-08-22 06:25:00 | AAPL | Stock | 23.4754 | 23.4754 | 23.4679 | 23.4679 | 16800.0 |
| 2012-08-22 06:45:00 | AAPL | Stock | 23.4554 | 23.4554 | 23.4554 | 23.4554 | 8400.0 |
| 2012-08-22 06:50:00 | AAPL | Stock | 23.4554 | 23.4554 | 23.4286 | 23.4286 | 15400.0 |
| 2012-08-22 07:00:00 | AAPL | Stock | 23.4143 | 23.4143 | 23.3932 | 23.3964 | 25480.0 |
| 2012-08-22 07:05:00 | AAPL | Stock | 23.3929 | 23.4264 | 23.3929 | 23.4264 | 31500.0 |
| 2012-08-22 07:10:00 | AAPL | Stock | 23.4214 | 23.4282 | 23.4107 | 23.4107 | 42000.0 |
| 2012-08-22 07:15:00 | AAPL | Stock | 23.3961 | 23.3982 | 23.395 | 23.3982 | 25200.0 |
| 2012-08-22 07:20:00 | AAPL | Stock | 23.41 | 23.41 | 23.3614 | 23.3614 | 80948.0 |
| 2012-08-22 07:25:00 | AAPL | Stock | 23.3679 | 23.3857 | 23.3611 | 23.3807 | 23968.0 |
| 2012-08-22 07:30:00 | AAPL | Stock | 23.3643 | 23.3886 | 23.3643 | 23.3886 | 127176.0 |
| 2012-08-22 07:35:00 | AAPL | Stock | 23.3757 | 23.3929 | 23.3725 | 23.3929 | 57120.0 |
| 2012-08-22 07:45:00 | AAPL | Stock | 23.4107 | 23.4464 | 23.4107 | 23.4389 | 106120.0 |
| 2012-08-22 07:50:00 | AAPL | Stock | 23.4286 | 23.4357 | 23.4268 | 23.4268 | 72492.0 |
| 2012-08-22 07:55:00 | AAPL | Stock | 23.4154 | 23.4154 | 23.4107 | 23.4136 | 35952.0 |
| 2012-08-22 08:00:00 | AAPL | Stock | 23.4057 | 23.4357 | 23.3918 | 23.4114 | 321804.0 |
| 2012-08-22 08:05:00 | AAPL | Stock | 23.4275 | 23.4375 | 23.4243 | 23.4286 | 48440.0 |
| 2012-08-22 08:10:00 | AAPL | Stock | 23.4357 | 23.4814 | 23.4357 | 23.4643 | 323596.0 |
| 2012-08-22 08:15:00 | AAPL | Stock | 23.4643 | 23.5257 | 23.4643 | 23.5214 | 265580.0 |
| 2012-08-22 08:20:00 | AAPL | Stock | 23.5179 | 23.5436 | 23.5111 | 23.5311 | 413896.0 |
| 2012-08-22 08:25:00 | AAPL | Stock | 23.5286 | 23.5357 | 23.5179 | 23.5357 | 360360.0 |
| 2012-08-22 08:30:00 | AAPL | Stock | 23.5357 | 23.5479 | 23.5268 | 23.5304 | 159796.0 |
| 2012-08-22 08:35:00 | AAPL | Stock | 23.5271 | 23.5357 | 23.5268 | 23.5343 | 72016.0 |
| 2012-08-22 08:40:00 | AAPL | Stock | 23.5279 | 23.5279 | 23.4821 | 23.4846 | 404600.0 |
| 2012-08-22 08:45:00 | AAPL | Stock | 23.4857 | 23.5107 | 23.4857 | 23.5057 | 146356.0 |
| 2012-08-22 08:50:00 | AAPL | Stock | 23.5064 | 23.5089 | 23.5 | 23.5 | 57792.0 |
| 2012-08-22 08:55:00 | AAPL | Stock | 23.5068 | 23.5236 | 23.5 | 23.5179 | 84840.0 |
| 2012-08-22 09:00:00 | AAPL | Stock | 23.5179 | 23.5179 | 23.485 | 23.4911 | 203392.0 |
| 2012-08-22 09:05:00 | AAPL | Stock | 23.4911 | 23.4929 | 23.4643 | 23.4693 | 392392.0 |
| 2012-08-22 09:10:00 | AAPL | Stock | 23.4643 | 23.4643 | 23.4286 | 23.4296 | 457156.0 |
| 2012-08-22 09:15:00 | AAPL | Stock | 23.4314 | 23.4357 | 23.3786 | 23.3889 | 763644.0 |
| 2012-08-22 09:20:00 | AAPL | Stock | 23.3839 | 23.3886 | 23.3668 | 23.3693 | 348012.0 |
| 2012-08-22 09:25:00 | AAPL | Stock | 23.3679 | 23.4089 | 23.3625 | 23.3754 | 484876.0 |
| 2012-08-22 09:30:00 | AAPL | Stock | 23.375 | 23.3929 | 23.2432 | 23.2696 | 21625492.0 |
| 2012-08-22 09:35:00 | AAPL | Stock | 23.2693 | 23.2982 | 23.2264 | 23.2361 | 16803192.0 |
| 2012-08-22 09:40:00 | AAPL | Stock | 23.2361 | 23.255 | 23.1468 | 23.1857 | 29322580.0 |
| 2012-08-22 09:45:00 | AAPL | Stock | 23.1857 | 23.3386 | 23.1847 | 23.3014 | 19238856.0 |
| 2012-08-22 09:50:00 | AAPL | Stock | 23.3071 | 23.3371 | 23.2689 | 23.2921 | 7879676.0 |
> showing 50 of 308,025 rows — these rows as CSV