PREVIEW / stock_30min / 2014-12-24
file: by_date/stock_30min/2014/2014-12-24.parquet size: 1004 KB rows: 46,872 symbols: 3,454
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-24 06:00:00 | AAPL | Stock | 28.135 | 28.135 | 28.135 | 28.135 | 400.0 |
| 2014-12-24 07:00:00 | AAPL | Stock | 28.125 | 28.125 | 28.125 | 28.125 | 800.0 |
| 2014-12-24 07:30:00 | AAPL | Stock | 28.15 | 28.2175 | 28.15 | 28.19 | 31732.0 |
| 2014-12-24 08:00:00 | AAPL | Stock | 28.1875 | 28.21 | 28.125 | 28.1875 | 160256.0 |
| 2014-12-24 08:30:00 | AAPL | Stock | 28.195 | 28.1975 | 28.165 | 28.1875 | 96888.0 |
| 2014-12-24 09:00:00 | AAPL | Stock | 28.1775 | 28.1775 | 28.135 | 28.15 | 93956.0 |
| 2014-12-24 09:30:00 | AAPL | Stock | 28.145 | 28.1775 | 28.03 | 28.075 | 10103192.0 |
| 2014-12-24 10:00:00 | AAPL | Stock | 28.075 | 28.0875 | 28.0025 | 28.0512 | 6332320.0 |
| 2014-12-24 10:30:00 | AAPL | Stock | 28.05 | 28.075 | 28.0288 | 28.0625 | 4710616.0 |
| 2014-12-24 11:00:00 | AAPL | Stock | 28.06 | 28.075 | 28.04 | 28.045 | 2908592.0 |
| 2014-12-24 11:30:00 | AAPL | Stock | 28.0425 | 28.0638 | 28.0325 | 28.0425 | 3371684.0 |
| 2014-12-24 12:00:00 | AAPL | Stock | 28.0438 | 28.055 | 28.0075 | 28.0125 | 4139556.0 |
| 2014-12-24 12:30:00 | AAPL | Stock | 28.0138 | 28.0525 | 28.0025 | 28.0025 | 6240020.0 |
| 2014-12-24 13:00:00 | AAPL | Stock | 28.0025 | 28.0602 | 27.9975 | 27.9975 | 16179244.0 |
| 2014-12-24 13:30:00 | AAPL | Stock | 28.0 | 28.01 | 28.0 | 28.0025 | 34124.0 |
| 2014-12-24 14:00:00 | AAPL | Stock | 28.0025 | 28.0125 | 28.0025 | 28.0125 | 35004.0 |
| 2014-12-24 14:30:00 | AAPL | Stock | 28.0125 | 28.0398 | 28.0025 | 28.0025 | 32256.0 |
| 2014-12-24 15:00:00 | AAPL | Stock | 28.005 | 28.01 | 28.005 | 28.01 | 11184.0 |
| 2014-12-24 15:30:00 | AAPL | Stock | 28.01 | 28.0125 | 28.005 | 28.005 | 11332.0 |
| 2014-12-24 16:00:00 | AAPL | Stock | 28.0075 | 28.0075 | 28.005 | 28.005 | 2000.0 |
| 2014-12-24 16:30:00 | AAPL | Stock | 28.0075 | 28.0075 | 28.005 | 28.005 | 4980.0 |
| 2014-12-24 08:00:00 | MSFT | Stock | 48.72 | 48.72 | 48.7 | 48.7 | 460.0 |
| 2014-12-24 08:30:00 | MSFT | Stock | 48.65 | 48.65 | 48.61 | 48.61 | 1542.0 |
| 2014-12-24 09:00:00 | MSFT | Stock | 48.61 | 48.61 | 48.42 | 48.5 | 15340.0 |
| 2014-12-24 09:30:00 | MSFT | Stock | 48.64 | 48.64 | 48.08 | 48.24 | 2005351.0 |
| 2014-12-24 10:00:00 | MSFT | Stock | 48.24 | 48.31 | 48.1 | 48.27 | 948629.0 |
| 2014-12-24 10:30:00 | MSFT | Stock | 48.27 | 48.31 | 48.21 | 48.28 | 757034.0 |
| 2014-12-24 11:00:00 | MSFT | Stock | 48.285 | 48.305 | 48.15 | 48.15 | 557224.0 |
| 2014-12-24 11:30:00 | MSFT | Stock | 48.16 | 48.31 | 48.15 | 48.294 | 870937.0 |
| 2014-12-24 12:00:00 | MSFT | Stock | 48.3 | 48.35 | 48.27 | 48.29 | 827761.0 |
| 2014-12-24 12:30:00 | MSFT | Stock | 48.3 | 48.32 | 48.13 | 48.15 | 1602068.0 |
| 2014-12-24 13:00:00 | MSFT | Stock | 48.14 | 48.24 | 48.14 | 48.14 | 2980100.0 |
| 2014-12-24 13:30:00 | MSFT | Stock | 48.16 | 48.16 | 48.16 | 48.16 | 300.0 |
| 2014-12-24 14:00:00 | MSFT | Stock | 48.11 | 48.24 | 48.1 | 48.1 | 9489.0 |
| 2014-12-24 14:30:00 | MSFT | Stock | 48.244 | 48.244 | 48.244 | 48.244 | 7500.0 |
| 2014-12-24 15:30:00 | MSFT | Stock | 48.15 | 48.2 | 48.15 | 48.2 | 2895.0 |
| 2014-12-24 16:30:00 | MSFT | Stock | 48.3 | 48.3 | 48.3 | 48.3 | 1000.0 |
| 2014-12-24 09:30:00 | NVDA | Stock | 0.5175 | 0.5181 | 0.515 | 0.5168 | 5601800.0 |
| 2014-12-24 10:00:00 | NVDA | Stock | 0.5168 | 0.5175 | 0.516 | 0.5168 | 4114240.0 |
| 2014-12-24 10:30:00 | NVDA | Stock | 0.5168 | 0.517 | 0.5145 | 0.5145 | 7509160.0 |
| 2014-12-24 11:00:00 | NVDA | Stock | 0.5145 | 0.5158 | 0.5142 | 0.5158 | 4432400.0 |
| 2014-12-24 11:30:00 | NVDA | Stock | 0.5158 | 0.5162 | 0.5152 | 0.5162 | 4244120.0 |
| 2014-12-24 12:00:00 | NVDA | Stock | 0.5162 | 0.5162 | 0.5146 | 0.515 | 4773040.0 |
| 2014-12-24 12:30:00 | NVDA | Stock | 0.515 | 0.5158 | 0.5138 | 0.5142 | 8708520.0 |
| 2014-12-24 13:00:00 | NVDA | Stock | 0.5142 | 0.5162 | 0.5142 | 0.5142 | 4219960.0 |
| 2014-12-24 14:00:00 | NVDA | Stock | 0.5159 | 0.5159 | 0.5159 | 0.5159 | 599920.0 |
| 2014-12-24 08:00:00 | AMZN | Stock | 15.3445 | 15.3445 | 15.3265 | 15.3265 | 4000.0 |
| 2014-12-24 08:30:00 | AMZN | Stock | 15.3245 | 15.3245 | 15.322 | 15.322 | 4000.0 |
| 2014-12-24 09:00:00 | AMZN | Stock | 15.3245 | 15.3245 | 15.32 | 15.32 | 8700.0 |
| 2014-12-24 09:30:00 | AMZN | Stock | 15.319 | 15.35 | 15.2285 | 15.283 | 3721560.0 |
> showing 50 of 46,872 rows — these rows as CSV