PREVIEW / stock_30min / 2016-03-21
file: by_date/stock_30min/2016/2016-03-21.parquet size: 1.6 MB rows: 82,224 symbols: 3,348
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-21 04:30:00 | AAPL | Stock | 26.455 | 26.47 | 26.4425 | 26.47 | 2824.0 |
| 2016-03-21 05:00:00 | AAPL | Stock | 26.475 | 26.475 | 26.475 | 26.475 | 800.0 |
| 2016-03-21 05:30:00 | AAPL | Stock | 26.525 | 26.525 | 26.5225 | 26.5225 | 1200.0 |
| 2016-03-21 06:00:00 | AAPL | Stock | 26.5225 | 26.57 | 26.5225 | 26.55 | 13744.0 |
| 2016-03-21 06:30:00 | AAPL | Stock | 26.5425 | 26.55 | 26.525 | 26.525 | 6400.0 |
| 2016-03-21 07:00:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.4525 | 26.4525 | 27772.0 |
| 2016-03-21 07:30:00 | AAPL | Stock | 26.4875 | 26.5375 | 26.4875 | 26.525 | 13756.0 |
| 2016-03-21 08:00:00 | AAPL | Stock | 26.535 | 26.575 | 26.4775 | 26.4925 | 160944.0 |
| 2016-03-21 08:30:00 | AAPL | Stock | 26.4875 | 26.5 | 26.465 | 26.4925 | 71912.0 |
| 2016-03-21 09:00:00 | AAPL | Stock | 26.5 | 26.53 | 26.4575 | 26.46 | 110904.0 |
| 2016-03-21 09:30:00 | AAPL | Stock | 26.46 | 26.73 | 26.46 | 26.6975 | 15439992.0 |
| 2016-03-21 10:00:00 | AAPL | Stock | 26.6995 | 26.9125 | 26.6275 | 26.6775 | 11006760.0 |
| 2016-03-21 10:30:00 | AAPL | Stock | 26.675 | 26.71 | 26.6075 | 26.6575 | 7596732.0 |
| 2016-03-21 11:00:00 | AAPL | Stock | 26.66 | 26.725 | 26.6325 | 26.6688 | 6027684.0 |
| 2016-03-21 11:30:00 | AAPL | Stock | 26.6688 | 26.705 | 26.6575 | 26.6862 | 5210140.0 |
| 2016-03-21 12:00:00 | AAPL | Stock | 26.685 | 26.6975 | 26.6505 | 26.67 | 5462828.0 |
| 2016-03-21 12:30:00 | AAPL | Stock | 26.67 | 26.6975 | 26.5875 | 26.615 | 5520544.0 |
| 2016-03-21 13:00:00 | AAPL | Stock | 26.616 | 26.7125 | 26.53 | 26.6438 | 8525348.0 |
| 2016-03-21 13:30:00 | AAPL | Stock | 26.645 | 26.67 | 26.285 | 26.3998 | 21460728.0 |
| 2016-03-21 14:00:00 | AAPL | Stock | 26.399 | 26.5425 | 26.34 | 26.435 | 12669564.0 |
| 2016-03-21 14:30:00 | AAPL | Stock | 26.4325 | 26.4925 | 26.41 | 26.44 | 7397040.0 |
| 2016-03-21 15:00:00 | AAPL | Stock | 26.44 | 26.46 | 26.3925 | 26.436 | 6504372.0 |
| 2016-03-21 15:30:00 | AAPL | Stock | 26.4362 | 26.4825 | 26.385 | 26.4775 | 10011428.0 |
| 2016-03-21 16:00:00 | AAPL | Stock | 26.4775 | 26.6055 | 26.4625 | 26.485 | 6164556.0 |
| 2016-03-21 16:30:00 | AAPL | Stock | 26.4125 | 26.5 | 26.4125 | 26.5 | 195964.0 |
| 2016-03-21 17:00:00 | AAPL | Stock | 26.4975 | 26.4975 | 26.48 | 26.49 | 28800.0 |
| 2016-03-21 17:30:00 | AAPL | Stock | 26.49 | 26.4925 | 26.4775 | 26.4875 | 44596.0 |
| 2016-03-21 18:00:00 | AAPL | Stock | 26.4825 | 26.485 | 26.4775 | 26.4775 | 8396.0 |
| 2016-03-21 18:30:00 | AAPL | Stock | 26.49 | 26.49 | 26.48 | 26.4875 | 10836.0 |
| 2016-03-21 19:00:00 | AAPL | Stock | 26.4875 | 26.4925 | 26.48 | 26.4925 | 38252.0 |
| 2016-03-21 19:30:00 | AAPL | Stock | 26.48 | 26.4925 | 26.48 | 26.4875 | 40392.0 |
| 2016-03-21 07:00:00 | MSFT | Stock | 53.68 | 53.68 | 53.68 | 53.68 | 500.0 |
| 2016-03-21 08:00:00 | MSFT | Stock | 53.57 | 53.6 | 53.4 | 53.4 | 7083.0 |
| 2016-03-21 08:30:00 | MSFT | Stock | 53.38 | 53.43 | 53.27 | 53.34 | 3591.0 |
| 2016-03-21 09:00:00 | MSFT | Stock | 53.33 | 53.4 | 53.26 | 53.26 | 11819.0 |
| 2016-03-21 09:30:00 | MSFT | Stock | 53.22 | 53.64 | 52.93 | 53.525 | 3569321.0 |
| 2016-03-21 10:00:00 | MSFT | Stock | 53.53 | 53.6 | 53.2 | 53.311 | 1594306.0 |
| 2016-03-21 10:30:00 | MSFT | Stock | 53.311 | 53.46 | 53.15 | 53.43 | 1478270.0 |
| 2016-03-21 11:00:00 | MSFT | Stock | 53.43 | 53.76 | 53.42 | 53.68 | 1339350.0 |
| 2016-03-21 11:30:00 | MSFT | Stock | 53.68 | 53.76 | 53.627 | 53.627 | 1038166.0 |
| 2016-03-21 12:00:00 | MSFT | Stock | 53.62 | 53.67 | 53.42 | 53.46 | 955633.0 |
| 2016-03-21 12:30:00 | MSFT | Stock | 53.46 | 53.48 | 53.3 | 53.43 | 1153368.0 |
| 2016-03-21 13:00:00 | MSFT | Stock | 53.43 | 53.585 | 53.39 | 53.57 | 830882.0 |
| 2016-03-21 13:30:00 | MSFT | Stock | 53.57 | 53.75 | 53.52 | 53.735 | 1329231.0 |
| 2016-03-21 14:00:00 | MSFT | Stock | 53.74 | 53.84 | 53.6 | 53.765 | 1332133.0 |
| 2016-03-21 14:30:00 | MSFT | Stock | 53.76 | 53.93 | 53.74 | 53.86 | 1402422.0 |
| 2016-03-21 15:00:00 | MSFT | Stock | 53.86 | 53.925 | 53.76 | 53.83 | 1168596.0 |
| 2016-03-21 15:30:00 | MSFT | Stock | 53.83 | 53.87 | 53.72 | 53.86 | 2803340.0 |
| 2016-03-21 16:00:00 | MSFT | Stock | 53.85 | 53.89 | 53.588 | 53.588 | 2104901.0 |
| 2016-03-21 16:30:00 | MSFT | Stock | 53.86 | 53.89 | 53.82 | 53.89 | 45720.0 |
> showing 50 of 82,224 rows — these rows as CSV