PREVIEW / stock_30min / 2016-02-29
file: by_date/stock_30min/2016/2016-02-29.parquet size: 1.6 MB rows: 82,054 symbols: 3,372
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-02-29 04:00:00 | AAPL | Stock | 24.2125 | 24.2125 | 24.0 | 24.0 | 13880.0 |
| 2016-02-29 04:30:00 | AAPL | Stock | 23.985 | 23.985 | 23.985 | 23.985 | 944.0 |
| 2016-02-29 05:00:00 | AAPL | Stock | 24.0 | 24.13 | 24.0 | 24.095 | 12076.0 |
| 2016-02-29 05:30:00 | AAPL | Stock | 24.095 | 24.095 | 24.085 | 24.085 | 10136.0 |
| 2016-02-29 06:00:00 | AAPL | Stock | 24.0575 | 24.0975 | 24.05 | 24.0975 | 1672.0 |
| 2016-02-29 06:30:00 | AAPL | Stock | 24.0625 | 24.165 | 24.0625 | 24.1625 | 5200.0 |
| 2016-02-29 07:00:00 | AAPL | Stock | 24.18 | 24.18 | 24.15 | 24.1625 | 14532.0 |
| 2016-02-29 07:30:00 | AAPL | Stock | 24.1675 | 24.18 | 24.1625 | 24.1625 | 18640.0 |
| 2016-02-29 08:00:00 | AAPL | Stock | 24.17 | 24.1875 | 24.1625 | 24.1825 | 24048.0 |
| 2016-02-29 08:30:00 | AAPL | Stock | 24.1875 | 24.265 | 24.1875 | 24.265 | 77380.0 |
| 2016-02-29 09:00:00 | AAPL | Stock | 24.2525 | 24.3225 | 24.2125 | 24.2125 | 315764.0 |
| 2016-02-29 09:30:00 | AAPL | Stock | 24.2125 | 24.4225 | 24.1875 | 24.39 | 15929940.0 |
| 2016-02-29 10:00:00 | AAPL | Stock | 24.3925 | 24.465 | 24.3275 | 24.4172 | 8003112.0 |
| 2016-02-29 10:30:00 | AAPL | Stock | 24.4175 | 24.4925 | 24.385 | 24.4675 | 5314924.0 |
| 2016-02-29 11:00:00 | AAPL | Stock | 24.465 | 24.5575 | 24.4375 | 24.4938 | 8099148.0 |
| 2016-02-29 11:30:00 | AAPL | Stock | 24.4925 | 24.5375 | 24.48 | 24.5025 | 6277384.0 |
| 2016-02-29 12:00:00 | AAPL | Stock | 24.4975 | 24.5175 | 24.4325 | 24.46 | 4588652.0 |
| 2016-02-29 12:30:00 | AAPL | Stock | 24.459 | 24.4775 | 24.4075 | 24.4738 | 6463096.0 |
| 2016-02-29 13:00:00 | AAPL | Stock | 24.475 | 24.495 | 24.4325 | 24.4328 | 5207476.0 |
| 2016-02-29 13:30:00 | AAPL | Stock | 24.4325 | 24.4325 | 24.385 | 24.4265 | 4534628.0 |
| 2016-02-29 14:00:00 | AAPL | Stock | 24.425 | 24.4312 | 24.3025 | 24.3675 | 6313900.0 |
| 2016-02-29 14:30:00 | AAPL | Stock | 24.3662 | 24.3975 | 24.3 | 24.3375 | 6308612.0 |
| 2016-02-29 15:00:00 | AAPL | Stock | 24.3375 | 24.3375 | 24.25 | 24.3125 | 7211204.0 |
| 2016-02-29 15:30:00 | AAPL | Stock | 24.3102 | 24.3375 | 24.1625 | 24.1625 | 16359052.0 |
| 2016-02-29 16:00:00 | AAPL | Stock | 24.1625 | 24.3895 | 24.1625 | 24.2025 | 22083408.0 |
| 2016-02-29 16:30:00 | AAPL | Stock | 24.205 | 24.225 | 24.195 | 24.225 | 107408.0 |
| 2016-02-29 17:00:00 | AAPL | Stock | 24.22 | 24.225 | 24.2 | 24.225 | 11200.0 |
| 2016-02-29 17:30:00 | AAPL | Stock | 24.225 | 24.225 | 24.195 | 24.2 | 16000.0 |
| 2016-02-29 18:00:00 | AAPL | Stock | 24.2125 | 24.225 | 24.21 | 24.225 | 14456.0 |
| 2016-02-29 18:30:00 | AAPL | Stock | 24.225 | 24.2375 | 24.2225 | 24.225 | 20468.0 |
| 2016-02-29 19:00:00 | AAPL | Stock | 24.2125 | 24.23 | 24.2125 | 24.215 | 6260.0 |
| 2016-02-29 19:30:00 | AAPL | Stock | 24.215 | 24.22 | 24.19 | 24.1975 | 56752.0 |
| 2016-02-29 07:30:00 | MSFT | Stock | 51.1 | 51.17 | 51.1 | 51.17 | 1250.0 |
| 2016-02-29 08:00:00 | MSFT | Stock | 51.0 | 51.2 | 51.0 | 51.14 | 5315.0 |
| 2016-02-29 08:30:00 | MSFT | Stock | 51.2 | 51.35 | 51.2 | 51.3 | 7940.0 |
| 2016-02-29 09:00:00 | MSFT | Stock | 51.28 | 51.3 | 51.25 | 51.25 | 3410.0 |
| 2016-02-29 09:30:00 | MSFT | Stock | 51.35 | 51.38 | 51.0 | 51.2 | 1951219.0 |
| 2016-02-29 10:00:00 | MSFT | Stock | 51.19 | 51.29 | 51.01 | 51.23 | 1366834.0 |
| 2016-02-29 10:30:00 | MSFT | Stock | 51.24 | 51.325 | 51.09 | 51.304 | 1303622.0 |
| 2016-02-29 11:00:00 | MSFT | Stock | 51.301 | 51.44 | 51.25 | 51.38 | 1122172.0 |
| 2016-02-29 11:30:00 | MSFT | Stock | 51.375 | 51.65 | 51.375 | 51.505 | 1112244.0 |
| 2016-02-29 12:00:00 | MSFT | Stock | 51.51 | 51.55 | 51.41 | 51.46 | 590772.0 |
| 2016-02-29 12:30:00 | MSFT | Stock | 51.47 | 51.47 | 51.31 | 51.37 | 913734.0 |
| 2016-02-29 13:00:00 | MSFT | Stock | 51.38 | 51.465 | 51.26 | 51.26 | 711490.0 |
| 2016-02-29 13:30:00 | MSFT | Stock | 51.26 | 51.32 | 51.21 | 51.32 | 843841.0 |
| 2016-02-29 14:00:00 | MSFT | Stock | 51.315 | 51.32 | 50.95 | 51.145 | 1349089.0 |
| 2016-02-29 14:30:00 | MSFT | Stock | 51.145 | 51.18 | 50.83 | 50.865 | 1751606.0 |
| 2016-02-29 15:00:00 | MSFT | Stock | 50.86 | 50.86 | 50.66 | 50.809 | 2446157.0 |
| 2016-02-29 15:30:00 | MSFT | Stock | 50.8 | 50.92 | 50.73 | 50.77 | 5411199.0 |
| 2016-02-29 16:00:00 | MSFT | Stock | 50.88 | 50.93 | 50.76 | 50.84 | 6662700.0 |
> showing 50 of 82,054 rows — these rows as CSV