PREVIEW / stock_5min / 2011-11-15
file: by_date/stock_5min/2011/2011-11-15.parquet size: 4.8 MB rows: 324,848 symbols: 3,523
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 |
|---|---|---|---|---|---|---|---|
| 2011-11-15 04:05:00 | AAPL | Stock | 13.525 | 13.525 | 13.525 | 13.525 | 2800.0 |
| 2011-11-15 05:35:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 5600.0 |
| 2011-11-15 05:45:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 33600.0 |
| 2011-11-15 05:50:00 | AAPL | Stock | 13.4911 | 13.4911 | 13.4911 | 13.4911 | 19600.0 |
| 2011-11-15 05:55:00 | AAPL | Stock | 13.5 | 13.5 | 13.5 | 13.5 | 19600.0 |
| 2011-11-15 06:00:00 | AAPL | Stock | 13.4918 | 13.4918 | 13.4918 | 13.4918 | 2800.0 |
| 2011-11-15 06:15:00 | AAPL | Stock | 13.4643 | 13.4643 | 13.4286 | 13.4286 | 5600.0 |
| 2011-11-15 06:30:00 | AAPL | Stock | 13.4839 | 13.4839 | 13.4839 | 13.4839 | 2800.0 |
| 2011-11-15 06:40:00 | AAPL | Stock | 13.4536 | 13.4536 | 13.4536 | 13.4536 | 5600.0 |
| 2011-11-15 06:45:00 | AAPL | Stock | 13.4536 | 13.4643 | 13.4536 | 13.4643 | 12600.0 |
| 2011-11-15 06:55:00 | AAPL | Stock | 13.4643 | 13.4643 | 13.4643 | 13.4643 | 2800.0 |
| 2011-11-15 07:00:00 | AAPL | Stock | 13.4693 | 13.4761 | 13.4554 | 13.4761 | 39200.0 |
| 2011-11-15 07:05:00 | AAPL | Stock | 13.4661 | 13.4661 | 13.4661 | 13.4661 | 5600.0 |
| 2011-11-15 07:10:00 | AAPL | Stock | 13.4743 | 13.4893 | 13.4725 | 13.4893 | 50400.0 |
| 2011-11-15 07:15:00 | AAPL | Stock | 13.4893 | 13.4893 | 13.4736 | 13.4893 | 39480.0 |
| 2011-11-15 07:20:00 | AAPL | Stock | 13.4893 | 13.5 | 13.4789 | 13.5 | 36120.0 |
| 2011-11-15 07:25:00 | AAPL | Stock | 13.5071 | 13.5239 | 13.5071 | 13.5239 | 19600.0 |
| 2011-11-15 07:30:00 | AAPL | Stock | 13.51 | 13.51 | 13.5086 | 13.5086 | 8400.0 |
| 2011-11-15 07:35:00 | AAPL | Stock | 13.5096 | 13.5179 | 13.5089 | 13.5093 | 51044.0 |
| 2011-11-15 07:40:00 | AAPL | Stock | 13.5286 | 13.5357 | 13.5104 | 13.5229 | 109200.0 |
| 2011-11-15 07:45:00 | AAPL | Stock | 13.5286 | 13.5393 | 13.5286 | 13.5393 | 19600.0 |
| 2011-11-15 07:50:00 | AAPL | Stock | 13.5357 | 13.5457 | 13.5129 | 13.5129 | 33600.0 |
| 2011-11-15 07:55:00 | AAPL | Stock | 13.5218 | 13.5268 | 13.5179 | 13.5268 | 187040.0 |
| 2011-11-15 08:00:00 | AAPL | Stock | 13.5271 | 13.5429 | 13.5179 | 13.5357 | 189476.0 |
| 2011-11-15 08:05:00 | AAPL | Stock | 13.5393 | 13.5536 | 13.5339 | 13.5536 | 237720.0 |
| 2011-11-15 08:10:00 | AAPL | Stock | 13.5461 | 13.55 | 13.5357 | 13.5357 | 105224.0 |
| 2011-11-15 08:15:00 | AAPL | Stock | 13.5357 | 13.5446 | 13.5286 | 13.5393 | 130480.0 |
| 2011-11-15 08:20:00 | AAPL | Stock | 13.5461 | 13.5793 | 13.5446 | 13.5793 | 255220.0 |
| 2011-11-15 08:25:00 | AAPL | Stock | 13.5714 | 13.5804 | 13.5625 | 13.5779 | 217560.0 |
| 2011-11-15 08:30:00 | AAPL | Stock | 13.5789 | 13.6143 | 13.5786 | 13.6071 | 488152.0 |
| 2011-11-15 08:35:00 | AAPL | Stock | 13.6071 | 13.6161 | 13.6036 | 13.6161 | 254660.0 |
| 2011-11-15 08:40:00 | AAPL | Stock | 13.6157 | 13.6364 | 13.6143 | 13.6164 | 292740.0 |
| 2011-11-15 08:45:00 | AAPL | Stock | 13.6129 | 13.6243 | 13.5939 | 13.595 | 260092.0 |
| 2011-11-15 08:50:00 | AAPL | Stock | 13.6021 | 13.6071 | 13.6021 | 13.6021 | 81536.0 |
| 2011-11-15 08:55:00 | AAPL | Stock | 13.5929 | 13.5929 | 13.5768 | 13.5843 | 141148.0 |
| 2011-11-15 09:00:00 | AAPL | Stock | 13.5964 | 13.6018 | 13.5957 | 13.6018 | 30912.0 |
| 2011-11-15 09:05:00 | AAPL | Stock | 13.6043 | 13.615 | 13.6032 | 13.6071 | 221564.0 |
| 2011-11-15 09:10:00 | AAPL | Stock | 13.6071 | 13.6118 | 13.5996 | 13.6054 | 61320.0 |
| 2011-11-15 09:15:00 | AAPL | Stock | 13.6054 | 13.6129 | 13.6036 | 13.6071 | 66192.0 |
| 2011-11-15 09:20:00 | AAPL | Stock | 13.6111 | 13.625 | 13.6075 | 13.6236 | 295036.0 |
| 2011-11-15 09:25:00 | AAPL | Stock | 13.6196 | 13.6196 | 13.545 | 13.6011 | 588084.0 |
| 2011-11-15 09:30:00 | AAPL | Stock | 13.6018 | 13.6286 | 13.5518 | 13.5971 | 24362296.0 |
| 2011-11-15 09:35:00 | AAPL | Stock | 13.5968 | 13.6482 | 13.5725 | 13.6404 | 13805008.0 |
| 2011-11-15 09:40:00 | AAPL | Stock | 13.6416 | 13.6786 | 13.64 | 13.67 | 12231828.0 |
| 2011-11-15 09:45:00 | AAPL | Stock | 13.6729 | 13.7046 | 13.6646 | 13.6839 | 13285916.0 |
| 2011-11-15 09:50:00 | AAPL | Stock | 13.684 | 13.7179 | 13.6836 | 13.7104 | 11862676.0 |
| 2011-11-15 09:55:00 | AAPL | Stock | 13.7136 | 13.7296 | 13.6983 | 13.7118 | 10245060.0 |
| 2011-11-15 10:00:00 | AAPL | Stock | 13.7117 | 13.7178 | 13.6782 | 13.6964 | 8878912.0 |
| 2011-11-15 10:05:00 | AAPL | Stock | 13.6954 | 13.7486 | 13.6757 | 13.7193 | 11492068.0 |
| 2011-11-15 10:10:00 | AAPL | Stock | 13.7189 | 13.7286 | 13.6979 | 13.7057 | 6660136.0 |
> showing 50 of 324,848 rows — these rows as CSV