PREVIEW / stock_30min / 2016-03-03
file: by_date/stock_30min/2016/2016-03-03.parquet size: 1.6 MB rows: 82,524 symbols: 3,352
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-03 05:00:00 | AAPL | Stock | 25.2175 | 25.2175 | 25.2175 | 25.2175 | 1000.0 |
| 2016-03-03 06:30:00 | AAPL | Stock | 25.2125 | 25.2125 | 25.2125 | 25.2125 | 1200.0 |
| 2016-03-03 07:00:00 | AAPL | Stock | 25.19 | 25.2125 | 25.19 | 25.2 | 13920.0 |
| 2016-03-03 07:30:00 | AAPL | Stock | 25.2 | 25.2 | 25.15 | 25.175 | 15400.0 |
| 2016-03-03 08:00:00 | AAPL | Stock | 25.19 | 25.2175 | 25.1275 | 25.1525 | 128348.0 |
| 2016-03-03 08:30:00 | AAPL | Stock | 25.1575 | 25.1675 | 25.1325 | 25.1525 | 101220.0 |
| 2016-03-03 09:00:00 | AAPL | Stock | 25.145 | 25.17 | 25.125 | 25.145 | 129484.0 |
| 2016-03-03 09:30:00 | AAPL | Stock | 25.1425 | 25.3825 | 25.1125 | 25.3175 | 16801296.0 |
| 2016-03-03 10:00:00 | AAPL | Stock | 25.3175 | 25.4275 | 25.265 | 25.3725 | 15580444.0 |
| 2016-03-03 10:30:00 | AAPL | Stock | 25.3725 | 25.42 | 25.2975 | 25.3125 | 11915168.0 |
| 2016-03-03 11:00:00 | AAPL | Stock | 25.314 | 25.3375 | 25.1975 | 25.2175 | 9937160.0 |
| 2016-03-03 11:30:00 | AAPL | Stock | 25.215 | 25.2375 | 25.155 | 25.205 | 10943848.0 |
| 2016-03-03 12:00:00 | AAPL | Stock | 25.205 | 25.2375 | 25.16 | 25.1875 | 7150972.0 |
| 2016-03-03 12:30:00 | AAPL | Stock | 25.1875 | 25.2475 | 25.1825 | 25.225 | 5194136.0 |
| 2016-03-03 13:00:00 | AAPL | Stock | 25.2225 | 25.2475 | 25.205 | 25.2275 | 4600104.0 |
| 2016-03-03 13:30:00 | AAPL | Stock | 25.2275 | 25.325 | 25.2275 | 25.325 | 7235976.0 |
| 2016-03-03 14:00:00 | AAPL | Stock | 25.3225 | 25.35 | 25.2675 | 25.32 | 5764656.0 |
| 2016-03-03 14:30:00 | AAPL | Stock | 25.3225 | 25.3625 | 25.2738 | 25.3575 | 5091996.0 |
| 2016-03-03 15:00:00 | AAPL | Stock | 25.36 | 25.38 | 25.32 | 25.3675 | 7117544.0 |
| 2016-03-03 15:30:00 | AAPL | Stock | 25.37 | 25.4175 | 25.3225 | 25.375 | 14967756.0 |
| 2016-03-03 16:00:00 | AAPL | Stock | 25.375 | 25.38 | 25.1875 | 25.355 | 8076312.0 |
| 2016-03-03 16:30:00 | AAPL | Stock | 25.3525 | 25.425 | 25.3525 | 25.3875 | 131452.0 |
| 2016-03-03 17:00:00 | AAPL | Stock | 25.4225 | 25.4725 | 25.4 | 25.405 | 61804.0 |
| 2016-03-03 17:30:00 | AAPL | Stock | 25.41 | 25.4225 | 25.41 | 25.41 | 21156.0 |
| 2016-03-03 18:00:00 | AAPL | Stock | 25.4175 | 25.4225 | 25.4025 | 25.4225 | 38240.0 |
| 2016-03-03 18:30:00 | AAPL | Stock | 25.4125 | 25.425 | 25.4125 | 25.4225 | 29472.0 |
| 2016-03-03 19:00:00 | AAPL | Stock | 25.425 | 25.425 | 25.405 | 25.4225 | 40420.0 |
| 2016-03-03 19:30:00 | AAPL | Stock | 25.4225 | 25.4625 | 25.42 | 25.4625 | 36924.0 |
| 2016-03-03 05:00:00 | MSFT | Stock | 52.5 | 52.5 | 52.4 | 52.4 | 300.0 |
| 2016-03-03 08:00:00 | MSFT | Stock | 52.85 | 52.94 | 52.85 | 52.9 | 1650.0 |
| 2016-03-03 08:30:00 | MSFT | Stock | 52.87 | 52.87 | 52.87 | 52.87 | 800.0 |
| 2016-03-03 09:00:00 | MSFT | Stock | 52.9 | 52.95 | 52.83 | 52.95 | 15100.0 |
| 2016-03-03 09:30:00 | MSFT | Stock | 52.97 | 52.97 | 52.45 | 52.485 | 1678933.0 |
| 2016-03-03 10:00:00 | MSFT | Stock | 52.49 | 52.51 | 52.0 | 52.14 | 2438452.0 |
| 2016-03-03 10:30:00 | MSFT | Stock | 52.14 | 52.22 | 51.905 | 51.94 | 2390122.0 |
| 2016-03-03 11:00:00 | MSFT | Stock | 51.94 | 51.98 | 51.79 | 51.84 | 1774036.0 |
| 2016-03-03 11:30:00 | MSFT | Stock | 51.84 | 52.0 | 51.78 | 51.98 | 1207992.0 |
| 2016-03-03 12:00:00 | MSFT | Stock | 51.99 | 52.08 | 51.884 | 51.884 | 1062157.0 |
| 2016-03-03 12:30:00 | MSFT | Stock | 51.88 | 51.98 | 51.8 | 51.92 | 1095297.0 |
| 2016-03-03 13:00:00 | MSFT | Stock | 51.915 | 52.08 | 51.915 | 52.01 | 1231303.0 |
| 2016-03-03 13:30:00 | MSFT | Stock | 52.01 | 52.26 | 52.0 | 52.155 | 1441262.0 |
| 2016-03-03 14:00:00 | MSFT | Stock | 52.16 | 52.25 | 52.065 | 52.195 | 1159773.0 |
| 2016-03-03 14:30:00 | MSFT | Stock | 52.2 | 52.38 | 52.11 | 52.347 | 1362656.0 |
| 2016-03-03 15:00:00 | MSFT | Stock | 52.35 | 52.43 | 52.19 | 52.195 | 1251307.0 |
| 2016-03-03 15:30:00 | MSFT | Stock | 52.195 | 52.37 | 52.17 | 52.35 | 2670464.0 |
| 2016-03-03 16:00:00 | MSFT | Stock | 52.35 | 52.37 | 52.28 | 52.35 | 1624601.0 |
| 2016-03-03 16:30:00 | MSFT | Stock | 52.28 | 52.32 | 52.28 | 52.28 | 4090.0 |
| 2016-03-03 17:00:00 | MSFT | Stock | 52.29 | 52.3 | 52.29 | 52.3 | 900.0 |
| 2016-03-03 17:30:00 | MSFT | Stock | 52.35 | 52.35 | 52.35 | 52.35 | 200.0 |
| 2016-03-03 18:00:00 | MSFT | Stock | 52.3 | 52.35 | 52.3 | 52.35 | 2630.0 |
> showing 50 of 82,524 rows — these rows as CSV