PREVIEW / stock_30min / 2017-06-30
file: by_date/stock_30min/2017/2017-06-30.parquet size: 1.6 MB rows: 81,108 symbols: 3,010
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 |
|---|---|---|---|---|---|---|---|
| 2017-06-30 05:00:00 | AAPL | Stock | 35.9875 | 35.9875 | 35.9875 | 35.9875 | 6968.0 |
| 2017-06-30 06:00:00 | AAPL | Stock | 36.0475 | 36.0725 | 36.0225 | 36.0725 | 6640.0 |
| 2017-06-30 06:30:00 | AAPL | Stock | 36.055 | 36.09 | 36.0525 | 36.09 | 2712.0 |
| 2017-06-30 07:00:00 | AAPL | Stock | 36.0675 | 36.145 | 36.0675 | 36.075 | 86036.0 |
| 2017-06-30 07:30:00 | AAPL | Stock | 36.0625 | 36.0875 | 36.0625 | 36.0675 | 18184.0 |
| 2017-06-30 08:00:00 | AAPL | Stock | 36.1125 | 36.145 | 35.985 | 36.0 | 160324.0 |
| 2017-06-30 08:30:00 | AAPL | Stock | 35.99 | 36.025 | 35.86 | 35.9 | 183320.0 |
| 2017-06-30 09:00:00 | AAPL | Stock | 35.9 | 36.4225 | 35.8775 | 36.19 | 1088768.0 |
| 2017-06-30 09:30:00 | AAPL | Stock | 36.1125 | 36.24 | 35.9975 | 36.1075 | 16499704.0 |
| 2017-06-30 10:00:00 | AAPL | Stock | 36.107 | 36.13 | 35.9648 | 36.0975 | 5572388.0 |
| 2017-06-30 10:30:00 | AAPL | Stock | 36.1025 | 36.1352 | 35.945 | 36.085 | 5720924.0 |
| 2017-06-30 11:00:00 | AAPL | Stock | 36.085 | 36.13 | 36.045 | 36.06 | 3539120.0 |
| 2017-06-30 11:30:00 | AAPL | Stock | 36.0588 | 36.1825 | 36.03 | 36.1675 | 3560760.0 |
| 2017-06-30 12:00:00 | AAPL | Stock | 36.1675 | 36.1775 | 36.1 | 36.1525 | 2512600.0 |
| 2017-06-30 12:30:00 | AAPL | Stock | 36.1512 | 36.1575 | 36.025 | 36.05 | 2696392.0 |
| 2017-06-30 13:00:00 | AAPL | Stock | 36.05 | 36.13 | 36.05 | 36.1188 | 2012912.0 |
| 2017-06-30 13:30:00 | AAPL | Stock | 36.12 | 36.1625 | 36.1 | 36.1312 | 2124508.0 |
| 2017-06-30 14:00:00 | AAPL | Stock | 36.13 | 36.155 | 36.08 | 36.1335 | 2578716.0 |
| 2017-06-30 14:30:00 | AAPL | Stock | 36.1325 | 36.185 | 36.125 | 36.1765 | 3111812.0 |
| 2017-06-30 15:00:00 | AAPL | Stock | 36.1775 | 36.2 | 36.1275 | 36.1675 | 3932176.0 |
| 2017-06-30 15:30:00 | AAPL | Stock | 36.17 | 36.2175 | 36.0 | 36.0075 | 12250552.0 |
| 2017-06-30 16:00:00 | AAPL | Stock | 36.0075 | 36.05 | 36.005 | 36.025 | 10869668.0 |
| 2017-06-30 16:30:00 | AAPL | Stock | 36.005 | 36.03 | 36.005 | 36.025 | 670176.0 |
| 2017-06-30 17:00:00 | AAPL | Stock | 36.02 | 36.02 | 35.9875 | 35.9875 | 69736.0 |
| 2017-06-30 17:30:00 | AAPL | Stock | 36.005 | 36.005 | 36.005 | 36.005 | 400.0 |
| 2017-06-30 18:00:00 | AAPL | Stock | 36.0025 | 36.0025 | 35.9775 | 35.9775 | 8696.0 |
| 2017-06-30 18:30:00 | AAPL | Stock | 36.01 | 36.015 | 36.01 | 36.015 | 1200.0 |
| 2017-06-30 19:00:00 | AAPL | Stock | 36.0 | 36.0 | 35.9875 | 35.9875 | 5000.0 |
| 2017-06-30 19:30:00 | AAPL | Stock | 36.0 | 36.005 | 35.9625 | 35.9625 | 6032.0 |
| 2017-06-30 04:00:00 | MSFT | Stock | 68.4 | 68.4 | 68.4 | 68.4 | 100.0 |
| 2017-06-30 04:30:00 | MSFT | Stock | 68.4 | 68.4 | 68.4 | 68.4 | 1300.0 |
| 2017-06-30 05:30:00 | MSFT | Stock | 68.65 | 68.65 | 68.65 | 68.65 | 100.0 |
| 2017-06-30 06:00:00 | MSFT | Stock | 68.69 | 68.69 | 68.69 | 68.69 | 2500.0 |
| 2017-06-30 06:30:00 | MSFT | Stock | 68.72 | 68.8 | 68.72 | 68.79 | 875.0 |
| 2017-06-30 07:00:00 | MSFT | Stock | 68.62 | 68.84 | 68.61 | 68.69 | 9010.0 |
| 2017-06-30 07:30:00 | MSFT | Stock | 68.65 | 68.66 | 68.65 | 68.65 | 3565.0 |
| 2017-06-30 08:00:00 | MSFT | Stock | 68.66 | 68.71 | 68.52 | 68.52 | 14805.0 |
| 2017-06-30 08:30:00 | MSFT | Stock | 68.53 | 68.53 | 68.42 | 68.46 | 6655.0 |
| 2017-06-30 09:00:00 | MSFT | Stock | 68.5 | 69.17 | 68.4 | 69.14 | 410878.0 |
| 2017-06-30 09:30:00 | MSFT | Stock | 68.78 | 69.38 | 68.75 | 69.07 | 4940610.0 |
| 2017-06-30 10:00:00 | MSFT | Stock | 69.075 | 69.16 | 68.77 | 69.05 | 1383892.0 |
| 2017-06-30 10:30:00 | MSFT | Stock | 69.04 | 69.1 | 68.74 | 69.01 | 1074971.0 |
| 2017-06-30 11:00:00 | MSFT | Stock | 69.01 | 69.02 | 68.84 | 68.87 | 997286.0 |
| 2017-06-30 11:30:00 | MSFT | Stock | 68.87 | 68.965 | 68.78 | 68.96 | 979690.0 |
| 2017-06-30 12:00:00 | MSFT | Stock | 68.95 | 69.08 | 68.91 | 68.99 | 607679.0 |
| 2017-06-30 12:30:00 | MSFT | Stock | 68.99 | 69.1 | 68.955 | 69.091 | 714075.0 |
| 2017-06-30 13:00:00 | MSFT | Stock | 69.095 | 69.18 | 69.095 | 69.18 | 426432.0 |
| 2017-06-30 13:30:00 | MSFT | Stock | 69.18 | 69.24 | 69.15 | 69.225 | 430382.0 |
| 2017-06-30 14:00:00 | MSFT | Stock | 69.23 | 69.35 | 69.21 | 69.28 | 1074072.0 |
| 2017-06-30 14:30:00 | MSFT | Stock | 69.28 | 69.34 | 69.25 | 69.27 | 985577.0 |
> showing 50 of 81,108 rows — these rows as CSV