PREVIEW / stock_30min / 2016-12-06
file: by_date/stock_30min/2016/2016-12-06.parquet size: 1.6 MB rows: 83,269 symbols: 3,155
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-12-06 04:00:00 | AAPL | Stock | 27.335 | 27.335 | 27.2875 | 27.2875 | 1856.0 |
| 2016-12-06 04:30:00 | AAPL | Stock | 27.275 | 27.275 | 27.275 | 27.275 | 1020.0 |
| 2016-12-06 05:30:00 | AAPL | Stock | 27.2775 | 27.2775 | 27.2775 | 27.2775 | 400.0 |
| 2016-12-06 06:00:00 | AAPL | Stock | 27.28 | 27.3875 | 27.28 | 27.3025 | 10304.0 |
| 2016-12-06 06:30:00 | AAPL | Stock | 27.305 | 27.3125 | 27.285 | 27.3125 | 4624.0 |
| 2016-12-06 07:00:00 | AAPL | Stock | 27.3125 | 27.375 | 27.3125 | 27.375 | 12840.0 |
| 2016-12-06 07:30:00 | AAPL | Stock | 27.35 | 27.6125 | 27.345 | 27.6 | 180252.0 |
| 2016-12-06 08:00:00 | AAPL | Stock | 27.5875 | 27.6 | 27.325 | 27.53 | 290852.0 |
| 2016-12-06 08:30:00 | AAPL | Stock | 27.5225 | 27.5625 | 27.5075 | 27.555 | 98124.0 |
| 2016-12-06 09:00:00 | AAPL | Stock | 27.5575 | 27.5575 | 27.3725 | 27.3725 | 290676.0 |
| 2016-12-06 09:30:00 | AAPL | Stock | 27.375 | 27.5832 | 27.3125 | 27.575 | 18596940.0 |
| 2016-12-06 10:00:00 | AAPL | Stock | 27.575 | 27.59 | 27.3625 | 27.3725 | 10069920.0 |
| 2016-12-06 10:30:00 | AAPL | Stock | 27.3705 | 27.465 | 27.3675 | 27.41 | 6079596.0 |
| 2016-12-06 11:00:00 | AAPL | Stock | 27.41 | 27.4225 | 27.3625 | 27.4 | 5742064.0 |
| 2016-12-06 11:30:00 | AAPL | Stock | 27.4 | 27.4038 | 27.2975 | 27.3725 | 5003748.0 |
| 2016-12-06 12:00:00 | AAPL | Stock | 27.3725 | 27.3975 | 27.3525 | 27.3775 | 3418112.0 |
| 2016-12-06 12:30:00 | AAPL | Stock | 27.377 | 27.4225 | 27.3525 | 27.365 | 4028224.0 |
| 2016-12-06 13:00:00 | AAPL | Stock | 27.3652 | 27.4 | 27.3375 | 27.3925 | 3127612.0 |
| 2016-12-06 13:30:00 | AAPL | Stock | 27.3912 | 27.44 | 27.38 | 27.4275 | 3747372.0 |
| 2016-12-06 14:00:00 | AAPL | Stock | 27.4275 | 27.4375 | 27.3875 | 27.4262 | 4561692.0 |
| 2016-12-06 14:30:00 | AAPL | Stock | 27.4275 | 27.4575 | 27.4275 | 27.4462 | 3982788.0 |
| 2016-12-06 15:00:00 | AAPL | Stock | 27.4475 | 27.455 | 27.3875 | 27.3875 | 5957216.0 |
| 2016-12-06 15:30:00 | AAPL | Stock | 27.3875 | 27.5075 | 27.385 | 27.485 | 12672896.0 |
| 2016-12-06 16:00:00 | AAPL | Stock | 27.4875 | 27.495 | 27.445 | 27.4875 | 8155664.0 |
| 2016-12-06 16:30:00 | AAPL | Stock | 27.48 | 27.4875 | 27.48 | 27.4875 | 17980.0 |
| 2016-12-06 17:00:00 | AAPL | Stock | 27.4725 | 27.475 | 27.4675 | 27.47 | 12100.0 |
| 2016-12-06 17:30:00 | AAPL | Stock | 27.4725 | 27.475 | 27.4675 | 27.4725 | 26016.0 |
| 2016-12-06 18:00:00 | AAPL | Stock | 27.4725 | 27.475 | 27.4725 | 27.475 | 5400.0 |
| 2016-12-06 18:30:00 | AAPL | Stock | 27.475 | 27.4875 | 27.475 | 27.4775 | 6800.0 |
| 2016-12-06 19:00:00 | AAPL | Stock | 27.485 | 27.4875 | 27.4775 | 27.4875 | 18048.0 |
| 2016-12-06 19:30:00 | AAPL | Stock | 27.4775 | 27.4825 | 27.4775 | 27.4825 | 9076.0 |
| 2016-12-06 06:00:00 | MSFT | Stock | 60.52 | 60.52 | 60.52 | 60.52 | 431.0 |
| 2016-12-06 07:30:00 | MSFT | Stock | 60.48 | 60.48 | 60.48 | 60.48 | 100.0 |
| 2016-12-06 08:00:00 | MSFT | Stock | 60.48 | 60.48 | 60.48 | 60.48 | 200.0 |
| 2016-12-06 08:30:00 | MSFT | Stock | 60.48 | 60.48 | 60.48 | 60.48 | 100.0 |
| 2016-12-06 09:00:00 | MSFT | Stock | 60.39 | 60.4 | 60.39 | 60.39 | 21953.0 |
| 2016-12-06 09:30:00 | MSFT | Stock | 60.43 | 60.46 | 59.8 | 60.2 | 2498166.0 |
| 2016-12-06 10:00:00 | MSFT | Stock | 60.195 | 60.345 | 59.95 | 59.98 | 1521487.0 |
| 2016-12-06 10:30:00 | MSFT | Stock | 59.985 | 60.15 | 59.985 | 60.11 | 1396368.0 |
| 2016-12-06 11:00:00 | MSFT | Stock | 60.105 | 60.12 | 59.96 | 60.09 | 1489757.0 |
| 2016-12-06 11:30:00 | MSFT | Stock | 60.095 | 60.12 | 59.95 | 60.095 | 864551.0 |
| 2016-12-06 12:00:00 | MSFT | Stock | 60.1 | 60.12 | 60.015 | 60.08 | 609141.0 |
| 2016-12-06 12:30:00 | MSFT | Stock | 60.08 | 60.169 | 59.96 | 59.985 | 727828.0 |
| 2016-12-06 13:00:00 | MSFT | Stock | 59.98 | 60.05 | 59.95 | 59.955 | 704460.0 |
| 2016-12-06 13:30:00 | MSFT | Stock | 59.96 | 60.07 | 59.9 | 60.026 | 808230.0 |
| 2016-12-06 14:00:00 | MSFT | Stock | 60.03 | 60.095 | 59.98 | 60.05 | 924900.0 |
| 2016-12-06 14:30:00 | MSFT | Stock | 60.06 | 60.13 | 60.015 | 60.11 | 878030.0 |
| 2016-12-06 15:00:00 | MSFT | Stock | 60.11 | 60.15 | 59.92 | 59.95 | 1174923.0 |
| 2016-12-06 15:30:00 | MSFT | Stock | 59.95 | 60.05 | 59.925 | 59.95 | 2314450.0 |
| 2016-12-06 16:00:00 | MSFT | Stock | 59.95 | 59.95 | 59.91 | 59.95 | 2093645.0 |
> showing 50 of 83,269 rows — these rows as CSV