PREVIEW / stock_30min / 2011-11-30
file: by_date/stock_30min/2011/2011-11-30.parquet size: 1.5 MB rows: 82,196 symbols: 3,566
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-30 05:30:00 | AAPL | Stock | 13.2875 | 13.2875 | 13.2875 | 13.2875 | 5600.0 |
| 2011-11-30 06:00:00 | AAPL | Stock | 13.2993 | 13.3729 | 13.2993 | 13.3661 | 14000.0 |
| 2011-11-30 06:30:00 | AAPL | Stock | 13.4625 | 13.4625 | 13.4625 | 13.4625 | 2800.0 |
| 2011-11-30 07:00:00 | AAPL | Stock | 13.42 | 13.4379 | 13.3929 | 13.3929 | 151200.0 |
| 2011-11-30 07:30:00 | AAPL | Stock | 13.3971 | 13.4021 | 13.3821 | 13.3982 | 86800.0 |
| 2011-11-30 08:00:00 | AAPL | Stock | 13.3961 | 13.5964 | 13.3839 | 13.5643 | 4126472.0 |
| 2011-11-30 08:30:00 | AAPL | Stock | 13.5675 | 13.6375 | 13.5643 | 13.6075 | 5395600.0 |
| 2011-11-30 09:00:00 | AAPL | Stock | 13.615 | 13.635 | 13.5946 | 13.6175 | 3106992.0 |
| 2011-11-30 09:30:00 | AAPL | Stock | 13.6171 | 13.6293 | 13.5279 | 13.5607 | 65662100.0 |
| 2011-11-30 10:00:00 | AAPL | Stock | 13.5625 | 13.5893 | 13.5107 | 13.5843 | 40455604.0 |
| 2011-11-30 10:30:00 | AAPL | Stock | 13.5843 | 13.6161 | 13.5704 | 13.6007 | 31073700.0 |
| 2011-11-30 11:00:00 | AAPL | Stock | 13.6036 | 13.61 | 13.5829 | 13.5954 | 18181212.0 |
| 2011-11-30 11:30:00 | AAPL | Stock | 13.5957 | 13.6071 | 13.5443 | 13.5643 | 18744908.0 |
| 2011-11-30 12:00:00 | AAPL | Stock | 13.5643 | 13.5714 | 13.5304 | 13.5547 | 17709216.0 |
| 2011-11-30 12:30:00 | AAPL | Stock | 13.5564 | 13.5589 | 13.5304 | 13.5579 | 12682516.0 |
| 2011-11-30 13:00:00 | AAPL | Stock | 13.5571 | 13.5671 | 13.5379 | 13.5396 | 10144092.0 |
| 2011-11-30 13:30:00 | AAPL | Stock | 13.5386 | 13.5554 | 13.5183 | 13.5229 | 14267624.0 |
| 2011-11-30 14:00:00 | AAPL | Stock | 13.5236 | 13.5693 | 13.5236 | 13.5639 | 14185136.0 |
| 2011-11-30 14:30:00 | AAPL | Stock | 13.5614 | 13.5714 | 13.5261 | 13.5629 | 13241032.0 |
| 2011-11-30 15:00:00 | AAPL | Stock | 13.5625 | 13.5875 | 13.5461 | 13.5679 | 22132824.0 |
| 2011-11-30 15:30:00 | AAPL | Stock | 13.5668 | 13.6429 | 13.5518 | 13.6414 | 65609180.0 |
| 2011-11-30 16:00:00 | AAPL | Stock | 13.6414 | 13.6596 | 13.5732 | 13.6443 | 36501976.0 |
| 2011-11-30 16:30:00 | AAPL | Stock | 13.6418 | 13.65 | 13.564 | 13.6464 | 3367476.0 |
| 2011-11-30 17:00:00 | AAPL | Stock | 13.6461 | 13.65 | 13.6436 | 13.6493 | 420616.0 |
| 2011-11-30 17:30:00 | AAPL | Stock | 13.6446 | 13.65 | 13.6429 | 13.6457 | 701988.0 |
| 2011-11-30 18:00:00 | AAPL | Stock | 13.6457 | 13.6518 | 13.6436 | 13.6475 | 102872.0 |
| 2011-11-30 18:30:00 | AAPL | Stock | 13.6482 | 13.65 | 13.6432 | 13.6454 | 137928.0 |
| 2011-11-30 19:00:00 | AAPL | Stock | 13.6432 | 13.6432 | 13.6429 | 13.6429 | 28000.0 |
| 2011-11-30 19:30:00 | AAPL | Stock | 13.6432 | 13.6432 | 13.6357 | 13.6375 | 84168.0 |
| 2011-11-30 04:00:00 | MSFT | Stock | 24.88 | 24.88 | 24.88 | 24.88 | 400.0 |
| 2011-11-30 06:00:00 | MSFT | Stock | 25.05 | 25.05 | 25.05 | 25.05 | 100.0 |
| 2011-11-30 07:00:00 | MSFT | Stock | 25.08 | 25.08 | 25.0 | 25.0 | 3350.0 |
| 2011-11-30 07:30:00 | MSFT | Stock | 25.0 | 25.05 | 24.97 | 25.04 | 3449.0 |
| 2011-11-30 08:00:00 | MSFT | Stock | 25.0 | 25.54 | 25.0 | 25.42 | 114887.0 |
| 2011-11-30 08:30:00 | MSFT | Stock | 25.42 | 25.58 | 25.4 | 25.5 | 90521.0 |
| 2011-11-30 09:00:00 | MSFT | Stock | 25.5 | 25.55 | 25.29 | 25.4 | 147899.0 |
| 2011-11-30 09:30:00 | MSFT | Stock | 25.4 | 25.41 | 25.14 | 25.29 | 8933504.0 |
| 2011-11-30 10:00:00 | MSFT | Stock | 25.29 | 25.42 | 25.28 | 25.39 | 7041899.0 |
| 2011-11-30 10:30:00 | MSFT | Stock | 25.38 | 25.565 | 25.37 | 25.52 | 5215592.0 |
| 2011-11-30 11:00:00 | MSFT | Stock | 25.52 | 25.54 | 25.35 | 25.44 | 5344306.0 |
| 2011-11-30 11:30:00 | MSFT | Stock | 25.43 | 25.47 | 25.38 | 25.402 | 2613062.0 |
| 2011-11-30 12:00:00 | MSFT | Stock | 25.41 | 25.52 | 25.39 | 25.49 | 2471575.0 |
| 2011-11-30 12:30:00 | MSFT | Stock | 25.498 | 25.51 | 25.45 | 25.47 | 2276109.0 |
| 2011-11-30 13:00:00 | MSFT | Stock | 25.47 | 25.51 | 25.38 | 25.39 | 3042820.0 |
| 2011-11-30 13:30:00 | MSFT | Stock | 25.39 | 25.42 | 25.32 | 25.37 | 3079830.0 |
| 2011-11-30 14:00:00 | MSFT | Stock | 25.36 | 25.46 | 25.35 | 25.445 | 2591473.0 |
| 2011-11-30 14:30:00 | MSFT | Stock | 25.445 | 25.47 | 25.33 | 25.402 | 2420124.0 |
| 2011-11-30 15:00:00 | MSFT | Stock | 25.401 | 25.42 | 25.36 | 25.395 | 5446168.0 |
| 2011-11-30 15:30:00 | MSFT | Stock | 25.391 | 25.58 | 25.38 | 25.55 | 13269885.0 |
| 2011-11-30 16:00:00 | MSFT | Stock | 25.55 | 25.603 | 25.413 | 25.58 | 14679157.0 |
> showing 50 of 82,196 rows — these rows as CSV