PREVIEW / stock_30min / 2015-11-30
file: by_date/stock_30min/2015/2015-11-30.parquet size: 1.6 MB rows: 84,455 symbols: 3,447
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 |
|---|---|---|---|---|---|---|---|
| 2015-11-30 04:00:00 | AAPL | Stock | 29.4525 | 29.465 | 29.4475 | 29.465 | 4000.0 |
| 2015-11-30 04:30:00 | AAPL | Stock | 29.47 | 29.47 | 29.4625 | 29.4625 | 2932.0 |
| 2015-11-30 05:00:00 | AAPL | Stock | 29.46 | 29.46 | 29.45 | 29.45 | 2396.0 |
| 2015-11-30 05:30:00 | AAPL | Stock | 29.45 | 29.45 | 29.45 | 29.45 | 2400.0 |
| 2015-11-30 06:00:00 | AAPL | Stock | 29.45 | 29.5575 | 29.45 | 29.55 | 56952.0 |
| 2015-11-30 06:30:00 | AAPL | Stock | 29.5 | 29.5 | 29.5 | 29.5 | 4196.0 |
| 2015-11-30 07:00:00 | AAPL | Stock | 29.4875 | 29.5075 | 29.485 | 29.5 | 51460.0 |
| 2015-11-30 07:30:00 | AAPL | Stock | 29.5225 | 29.53 | 29.4975 | 29.52 | 38168.0 |
| 2015-11-30 08:00:00 | AAPL | Stock | 29.51 | 29.5325 | 29.4725 | 29.52 | 142972.0 |
| 2015-11-30 08:30:00 | AAPL | Stock | 29.525 | 29.5275 | 29.49 | 29.505 | 143048.0 |
| 2015-11-30 09:00:00 | AAPL | Stock | 29.505 | 29.515 | 29.44 | 29.49 | 270660.0 |
| 2015-11-30 09:30:00 | AAPL | Stock | 29.4975 | 29.8125 | 29.4375 | 29.7025 | 21246224.0 |
| 2015-11-30 10:00:00 | AAPL | Stock | 29.7075 | 29.8548 | 29.6615 | 29.8195 | 15021104.0 |
| 2015-11-30 10:30:00 | AAPL | Stock | 29.82 | 29.845 | 29.7338 | 29.7378 | 9260064.0 |
| 2015-11-30 11:00:00 | AAPL | Stock | 29.745 | 29.7575 | 29.5825 | 29.605 | 8216968.0 |
| 2015-11-30 11:30:00 | AAPL | Stock | 29.6075 | 29.625 | 29.5125 | 29.5525 | 8110340.0 |
| 2015-11-30 12:00:00 | AAPL | Stock | 29.555 | 29.6675 | 29.5375 | 29.6325 | 5173456.0 |
| 2015-11-30 12:30:00 | AAPL | Stock | 29.6325 | 29.67 | 29.6105 | 29.655 | 3120844.0 |
| 2015-11-30 13:00:00 | AAPL | Stock | 29.6538 | 29.7125 | 29.5828 | 29.705 | 4163524.0 |
| 2015-11-30 13:30:00 | AAPL | Stock | 29.705 | 29.7375 | 29.665 | 29.7312 | 4492056.0 |
| 2015-11-30 14:00:00 | AAPL | Stock | 29.7325 | 29.785 | 29.73 | 29.735 | 5349256.0 |
| 2015-11-30 14:30:00 | AAPL | Stock | 29.7315 | 29.745 | 29.6642 | 29.6725 | 6516612.0 |
| 2015-11-30 15:00:00 | AAPL | Stock | 29.671 | 29.6975 | 29.6055 | 29.62 | 4851448.0 |
| 2015-11-30 15:30:00 | AAPL | Stock | 29.6175 | 29.655 | 29.5725 | 29.5925 | 19053520.0 |
| 2015-11-30 16:00:00 | AAPL | Stock | 29.575 | 29.64 | 29.572 | 29.6025 | 25117148.0 |
| 2015-11-30 16:30:00 | AAPL | Stock | 29.6 | 29.6075 | 29.575 | 29.6 | 180912.0 |
| 2015-11-30 17:00:00 | AAPL | Stock | 29.575 | 29.61 | 29.575 | 29.61 | 610244.0 |
| 2015-11-30 17:30:00 | AAPL | Stock | 29.61 | 29.6175 | 29.605 | 29.605 | 20160.0 |
| 2015-11-30 18:00:00 | AAPL | Stock | 29.61 | 29.625 | 29.605 | 29.625 | 28104.0 |
| 2015-11-30 18:30:00 | AAPL | Stock | 29.6325 | 29.635 | 29.575 | 29.625 | 86744.0 |
| 2015-11-30 19:00:00 | AAPL | Stock | 29.625 | 29.625 | 29.615 | 29.615 | 16800.0 |
| 2015-11-30 19:30:00 | AAPL | Stock | 29.6125 | 29.635 | 29.61 | 29.6325 | 75512.0 |
| 2015-11-30 04:30:00 | MSFT | Stock | 54.0 | 54.0 | 54.0 | 54.0 | 300.0 |
| 2015-11-30 05:00:00 | MSFT | Stock | 54.0 | 54.0 | 54.0 | 54.0 | 4000.0 |
| 2015-11-30 06:00:00 | MSFT | Stock | 54.07 | 54.07 | 54.07 | 54.07 | 100.0 |
| 2015-11-30 07:00:00 | MSFT | Stock | 54.17 | 54.18 | 54.11 | 54.15 | 9715.0 |
| 2015-11-30 07:30:00 | MSFT | Stock | 54.16 | 54.67 | 54.15 | 54.51 | 74666.0 |
| 2015-11-30 08:00:00 | MSFT | Stock | 54.52 | 54.7 | 54.02 | 54.68 | 64579.0 |
| 2015-11-30 08:30:00 | MSFT | Stock | 54.63 | 54.65 | 54.52 | 54.56 | 27582.0 |
| 2015-11-30 09:00:00 | MSFT | Stock | 54.54 | 54.65 | 54.46 | 54.54 | 76381.0 |
| 2015-11-30 09:30:00 | MSFT | Stock | 54.56 | 54.82 | 54.37 | 54.405 | 6617321.0 |
| 2015-11-30 10:00:00 | MSFT | Stock | 54.4 | 54.42 | 54.09 | 54.29 | 3107332.0 |
| 2015-11-30 10:30:00 | MSFT | Stock | 54.29 | 54.54 | 54.29 | 54.399 | 2940004.0 |
| 2015-11-30 11:00:00 | MSFT | Stock | 54.4 | 54.61 | 54.37 | 54.44 | 2317577.0 |
| 2015-11-30 11:30:00 | MSFT | Stock | 54.44 | 54.45 | 54.02 | 54.1 | 1997682.0 |
| 2015-11-30 12:00:00 | MSFT | Stock | 54.1 | 54.17 | 54.0 | 54.135 | 2262141.0 |
| 2015-11-30 12:30:00 | MSFT | Stock | 54.13 | 54.36 | 54.13 | 54.35 | 1432887.0 |
| 2015-11-30 13:00:00 | MSFT | Stock | 54.342 | 54.46 | 54.23 | 54.46 | 1537338.0 |
| 2015-11-30 13:30:00 | MSFT | Stock | 54.45 | 54.96 | 54.41 | 54.871 | 3847530.0 |
| 2015-11-30 14:00:00 | MSFT | Stock | 54.87 | 54.95 | 54.76 | 54.777 | 3393637.0 |
> showing 50 of 84,455 rows — these rows as CSV