PREVIEW / stock_30min / 2016-05-10
file: by_date/stock_30min/2016/2016-05-10.parquet size: 1.6 MB rows: 82,134 symbols: 3,279
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-05-10 04:30:00 | AAPL | Stock | 23.2625 | 23.2625 | 23.2625 | 23.2625 | 400.0 |
| 2016-05-10 05:00:00 | AAPL | Stock | 23.3725 | 23.375 | 23.3725 | 23.3725 | 7896.0 |
| 2016-05-10 05:30:00 | AAPL | Stock | 23.365 | 23.375 | 23.3575 | 23.375 | 8800.0 |
| 2016-05-10 06:00:00 | AAPL | Stock | 23.325 | 23.35 | 23.3 | 23.3 | 6436.0 |
| 2016-05-10 06:30:00 | AAPL | Stock | 23.3175 | 23.3375 | 23.3125 | 23.3125 | 8784.0 |
| 2016-05-10 07:00:00 | AAPL | Stock | 23.3 | 23.3 | 23.225 | 23.225 | 111600.0 |
| 2016-05-10 07:30:00 | AAPL | Stock | 23.25 | 23.29 | 23.24 | 23.2825 | 21664.0 |
| 2016-05-10 08:00:00 | AAPL | Stock | 23.2525 | 23.285 | 23.24 | 23.28 | 106144.0 |
| 2016-05-10 08:30:00 | AAPL | Stock | 23.2775 | 23.3 | 23.2625 | 23.2925 | 71248.0 |
| 2016-05-10 09:00:00 | AAPL | Stock | 23.295 | 23.3325 | 23.28 | 23.33 | 327124.0 |
| 2016-05-10 09:30:00 | AAPL | Stock | 23.335 | 23.3475 | 23.0625 | 23.1025 | 21685828.0 |
| 2016-05-10 10:00:00 | AAPL | Stock | 23.105 | 23.125 | 23.0275 | 23.1095 | 15509400.0 |
| 2016-05-10 10:30:00 | AAPL | Stock | 23.11 | 23.2725 | 23.085 | 23.2362 | 12788036.0 |
| 2016-05-10 11:00:00 | AAPL | Stock | 23.235 | 23.3575 | 23.2075 | 23.3458 | 10230688.0 |
| 2016-05-10 11:30:00 | AAPL | Stock | 23.345 | 23.3725 | 23.3025 | 23.36 | 8603216.0 |
| 2016-05-10 12:00:00 | AAPL | Stock | 23.36 | 23.3925 | 23.3325 | 23.345 | 5969892.0 |
| 2016-05-10 12:30:00 | AAPL | Stock | 23.345 | 23.3575 | 23.325 | 23.3275 | 4294380.0 |
| 2016-05-10 13:00:00 | AAPL | Stock | 23.3275 | 23.3325 | 23.2725 | 23.305 | 4397452.0 |
| 2016-05-10 13:30:00 | AAPL | Stock | 23.305 | 23.3375 | 23.2925 | 23.3112 | 4422256.0 |
| 2016-05-10 14:00:00 | AAPL | Stock | 23.31 | 23.315 | 23.24 | 23.2425 | 5547316.0 |
| 2016-05-10 14:30:00 | AAPL | Stock | 23.244 | 23.305 | 23.2175 | 23.2922 | 8175812.0 |
| 2016-05-10 15:00:00 | AAPL | Stock | 23.2925 | 23.3275 | 23.2838 | 23.3175 | 6445228.0 |
| 2016-05-10 15:30:00 | AAPL | Stock | 23.3182 | 23.3675 | 23.3025 | 23.35 | 11566088.0 |
| 2016-05-10 16:00:00 | AAPL | Stock | 23.355 | 23.355 | 23.3025 | 23.3325 | 4237372.0 |
| 2016-05-10 16:30:00 | AAPL | Stock | 23.3325 | 23.3375 | 23.315 | 23.3375 | 54336.0 |
| 2016-05-10 17:00:00 | AAPL | Stock | 23.3375 | 23.3375 | 23.325 | 23.335 | 58908.0 |
| 2016-05-10 17:30:00 | AAPL | Stock | 23.3325 | 23.3325 | 23.315 | 23.3225 | 19392.0 |
| 2016-05-10 18:00:00 | AAPL | Stock | 23.3225 | 23.335 | 23.3225 | 23.335 | 10000.0 |
| 2016-05-10 18:30:00 | AAPL | Stock | 23.32 | 23.3325 | 23.32 | 23.32 | 4820.0 |
| 2016-05-10 19:00:00 | AAPL | Stock | 23.33 | 23.33 | 23.32 | 23.325 | 9436.0 |
| 2016-05-10 19:30:00 | AAPL | Stock | 23.32 | 23.325 | 23.32 | 23.325 | 15200.0 |
| 2016-05-10 07:00:00 | MSFT | Stock | 50.29 | 50.29 | 50.07 | 50.07 | 900.0 |
| 2016-05-10 07:30:00 | MSFT | Stock | 50.24 | 50.24 | 50.19 | 50.19 | 200.0 |
| 2016-05-10 08:00:00 | MSFT | Stock | 50.1 | 50.19 | 50.1 | 50.19 | 640.0 |
| 2016-05-10 08:30:00 | MSFT | Stock | 50.17 | 50.2 | 50.11 | 50.11 | 1812.0 |
| 2016-05-10 09:00:00 | MSFT | Stock | 50.2 | 50.36 | 50.07 | 50.36 | 15290.0 |
| 2016-05-10 09:30:00 | MSFT | Stock | 50.41 | 50.57 | 50.19 | 50.38 | 2404288.0 |
| 2016-05-10 10:00:00 | MSFT | Stock | 50.38 | 50.47 | 50.34 | 50.4 | 1335106.0 |
| 2016-05-10 10:30:00 | MSFT | Stock | 50.4 | 50.65 | 50.35 | 50.583 | 1234609.0 |
| 2016-05-10 11:00:00 | MSFT | Stock | 50.58 | 50.62 | 50.47 | 50.545 | 924836.0 |
| 2016-05-10 11:30:00 | MSFT | Stock | 50.54 | 50.68 | 50.54 | 50.67 | 1126937.0 |
| 2016-05-10 12:00:00 | MSFT | Stock | 50.665 | 50.77 | 50.665 | 50.76 | 1183588.0 |
| 2016-05-10 12:30:00 | MSFT | Stock | 50.76 | 50.85 | 50.74 | 50.84 | 921833.0 |
| 2016-05-10 13:00:00 | MSFT | Stock | 50.84 | 50.895 | 50.8 | 50.84 | 994640.0 |
| 2016-05-10 13:30:00 | MSFT | Stock | 50.84 | 50.91 | 50.79 | 50.89 | 914333.0 |
| 2016-05-10 14:00:00 | MSFT | Stock | 50.89 | 50.99 | 50.86 | 50.97 | 1437768.0 |
| 2016-05-10 14:30:00 | MSFT | Stock | 50.97 | 50.975 | 50.835 | 50.84 | 1330705.0 |
| 2016-05-10 15:00:00 | MSFT | Stock | 50.845 | 50.97 | 50.825 | 50.945 | 1632996.0 |
| 2016-05-10 15:30:00 | MSFT | Stock | 50.945 | 51.1 | 50.905 | 51.02 | 3784779.0 |
| 2016-05-10 16:00:00 | MSFT | Stock | 51.02 | 51.05 | 50.82 | 50.82 | 1694262.0 |
> showing 50 of 82,134 rows — these rows as CSV