PREVIEW / stock_5min / 2011-11-18
file: by_date/stock_5min/2011/2011-11-18.parquet size: 4.6 MB rows: 316,010 symbols: 3,510
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-18 04:55:00 | AAPL | Stock | 13.545 | 13.545 | 13.545 | 13.545 | 2800.0 |
| 2011-11-18 05:05:00 | AAPL | Stock | 13.545 | 13.545 | 13.545 | 13.545 | 5600.0 |
| 2011-11-18 05:55:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 21000.0 |
| 2011-11-18 06:15:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 25200.0 |
| 2011-11-18 06:35:00 | AAPL | Stock | 13.5354 | 13.5354 | 13.5354 | 13.5354 | 2800.0 |
| 2011-11-18 06:40:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 2800.0 |
| 2011-11-18 06:45:00 | AAPL | Stock | 13.5357 | 13.5357 | 13.5357 | 13.5357 | 14000.0 |
| 2011-11-18 06:55:00 | AAPL | Stock | 13.5714 | 13.5982 | 13.5714 | 13.5982 | 33600.0 |
| 2011-11-18 07:00:00 | AAPL | Stock | 13.5893 | 13.5929 | 13.5875 | 13.5929 | 33600.0 |
| 2011-11-18 07:05:00 | AAPL | Stock | 13.5786 | 13.5796 | 13.5786 | 13.5796 | 28140.0 |
| 2011-11-18 07:10:00 | AAPL | Stock | 13.595 | 13.595 | 13.5771 | 13.5771 | 14000.0 |
| 2011-11-18 07:15:00 | AAPL | Stock | 13.5771 | 13.5882 | 13.5771 | 13.5882 | 16800.0 |
| 2011-11-18 07:20:00 | AAPL | Stock | 13.5839 | 13.5839 | 13.5839 | 13.5839 | 4088.0 |
| 2011-11-18 07:25:00 | AAPL | Stock | 13.5943 | 13.6071 | 13.5943 | 13.6071 | 52080.0 |
| 2011-11-18 07:30:00 | AAPL | Stock | 13.6179 | 13.6357 | 13.6179 | 13.6318 | 112000.0 |
| 2011-11-18 07:35:00 | AAPL | Stock | 13.6218 | 13.6607 | 13.6218 | 13.6607 | 121380.0 |
| 2011-11-18 07:40:00 | AAPL | Stock | 13.6607 | 13.6607 | 13.6232 | 13.6339 | 71400.0 |
| 2011-11-18 07:45:00 | AAPL | Stock | 13.6318 | 13.6318 | 13.6161 | 13.6161 | 22400.0 |
| 2011-11-18 07:50:00 | AAPL | Stock | 13.6214 | 13.6296 | 13.6161 | 13.6225 | 34860.0 |
| 2011-11-18 07:55:00 | AAPL | Stock | 13.6221 | 13.6221 | 13.6161 | 13.6161 | 28000.0 |
| 2011-11-18 08:00:00 | AAPL | Stock | 13.6286 | 13.63 | 13.5893 | 13.6154 | 126308.0 |
| 2011-11-18 08:05:00 | AAPL | Stock | 13.6161 | 13.6161 | 13.605 | 13.605 | 83216.0 |
| 2011-11-18 08:10:00 | AAPL | Stock | 13.6064 | 13.6071 | 13.6 | 13.6036 | 32200.0 |
| 2011-11-18 08:15:00 | AAPL | Stock | 13.5918 | 13.6 | 13.5918 | 13.5961 | 54320.0 |
| 2011-11-18 08:20:00 | AAPL | Stock | 13.5961 | 13.5964 | 13.5829 | 13.5896 | 79352.0 |
| 2011-11-18 08:25:00 | AAPL | Stock | 13.5929 | 13.5929 | 13.5929 | 13.5929 | 28000.0 |
| 2011-11-18 08:30:00 | AAPL | Stock | 13.5989 | 13.5993 | 13.59 | 13.59 | 83300.0 |
| 2011-11-18 08:35:00 | AAPL | Stock | 13.5896 | 13.5975 | 13.5893 | 13.5896 | 154840.0 |
| 2011-11-18 08:40:00 | AAPL | Stock | 13.5896 | 13.6 | 13.5896 | 13.6 | 174300.0 |
| 2011-11-18 08:45:00 | AAPL | Stock | 13.6029 | 13.6064 | 13.5982 | 13.6018 | 59864.0 |
| 2011-11-18 08:50:00 | AAPL | Stock | 13.5989 | 13.6068 | 13.5989 | 13.6 | 84952.0 |
| 2011-11-18 08:55:00 | AAPL | Stock | 13.6 | 13.6054 | 13.6 | 13.6 | 59304.0 |
| 2011-11-18 09:00:00 | AAPL | Stock | 13.6 | 13.6 | 13.5929 | 13.6 | 110908.0 |
| 2011-11-18 09:05:00 | AAPL | Stock | 13.5932 | 13.5932 | 13.5864 | 13.5893 | 126728.0 |
| 2011-11-18 09:10:00 | AAPL | Stock | 13.5864 | 13.5868 | 13.5818 | 13.5868 | 84980.0 |
| 2011-11-18 09:15:00 | AAPL | Stock | 13.5818 | 13.5818 | 13.5679 | 13.5714 | 77084.0 |
| 2011-11-18 09:20:00 | AAPL | Stock | 13.5729 | 13.5732 | 13.5725 | 13.5732 | 16800.0 |
| 2011-11-18 09:25:00 | AAPL | Stock | 13.5721 | 13.5721 | 13.5289 | 13.5325 | 818468.0 |
| 2011-11-18 09:30:00 | AAPL | Stock | 13.5325 | 13.5436 | 13.4475 | 13.4893 | 11501812.0 |
| 2011-11-18 09:35:00 | AAPL | Stock | 13.4896 | 13.4896 | 13.4375 | 13.4593 | 9916788.0 |
| 2011-11-18 09:40:00 | AAPL | Stock | 13.4579 | 13.5 | 13.4557 | 13.4943 | 8624812.0 |
| 2011-11-18 09:45:00 | AAPL | Stock | 13.4957 | 13.5346 | 13.47 | 13.5218 | 11199748.0 |
| 2011-11-18 09:50:00 | AAPL | Stock | 13.5218 | 13.5529 | 13.5188 | 13.5357 | 9809072.0 |
| 2011-11-18 09:55:00 | AAPL | Stock | 13.5361 | 13.5443 | 13.4961 | 13.5029 | 8587824.0 |
| 2011-11-18 10:00:00 | AAPL | Stock | 13.5 | 13.5232 | 13.4682 | 13.5149 | 6798848.0 |
| 2011-11-18 10:05:00 | AAPL | Stock | 13.5143 | 13.5318 | 13.5043 | 13.5082 | 4189640.0 |
| 2011-11-18 10:10:00 | AAPL | Stock | 13.5082 | 13.5254 | 13.4771 | 13.5043 | 4793068.0 |
| 2011-11-18 10:15:00 | AAPL | Stock | 13.5082 | 13.5104 | 13.4643 | 13.4907 | 4813256.0 |
| 2011-11-18 10:20:00 | AAPL | Stock | 13.4918 | 13.4946 | 13.4675 | 13.4711 | 3779552.0 |
| 2011-11-18 10:25:00 | AAPL | Stock | 13.47 | 13.4804 | 13.4529 | 13.4757 | 6600076.0 |
> showing 50 of 316,010 rows — these rows as CSV