PREVIEW / stock_30min / 2015-09-29
file: by_date/stock_30min/2015/2015-09-29.parquet size: 1.6 MB rows: 81,742 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-29 04:00:00 | AAPL | Stock | 28.1075 | 28.2725 | 28.1075 | 28.2475 | 26756.0 |
| 2015-09-29 04:30:00 | AAPL | Stock | 28.3125 | 28.3425 | 28.2875 | 28.3125 | 19040.0 |
| 2015-09-29 05:00:00 | AAPL | Stock | 28.3125 | 28.3125 | 28.27 | 28.2725 | 7224.0 |
| 2015-09-29 05:30:00 | AAPL | Stock | 28.25 | 28.25 | 28.25 | 28.25 | 2264.0 |
| 2015-09-29 06:00:00 | AAPL | Stock | 28.2525 | 28.3075 | 28.2525 | 28.3075 | 14084.0 |
| 2015-09-29 06:30:00 | AAPL | Stock | 28.3075 | 28.3375 | 28.275 | 28.3375 | 17824.0 |
| 2015-09-29 07:00:00 | AAPL | Stock | 28.3 | 28.3375 | 28.2325 | 28.2875 | 141716.0 |
| 2015-09-29 07:30:00 | AAPL | Stock | 28.275 | 28.275 | 28.205 | 28.205 | 35204.0 |
| 2015-09-29 08:00:00 | AAPL | Stock | 28.235 | 28.3375 | 28.2075 | 28.3025 | 301096.0 |
| 2015-09-29 08:30:00 | AAPL | Stock | 28.3 | 28.32 | 28.2575 | 28.29 | 268312.0 |
| 2015-09-29 09:00:00 | AAPL | Stock | 28.2875 | 28.295 | 28.1825 | 28.205 | 247420.0 |
| 2015-09-29 09:30:00 | AAPL | Stock | 28.2075 | 28.329 | 28.15 | 28.275 | 22896336.0 |
| 2015-09-29 10:00:00 | AAPL | Stock | 28.282 | 28.3725 | 28.2125 | 28.3675 | 15048836.0 |
| 2015-09-29 10:30:00 | AAPL | Stock | 28.3698 | 28.3775 | 28.1375 | 28.2225 | 14489704.0 |
| 2015-09-29 11:00:00 | AAPL | Stock | 28.2222 | 28.25 | 28.0452 | 28.0975 | 13283548.0 |
| 2015-09-29 11:30:00 | AAPL | Stock | 28.0975 | 28.1125 | 27.7925 | 27.795 | 17768544.0 |
| 2015-09-29 12:00:00 | AAPL | Stock | 27.795 | 27.8682 | 27.5875 | 27.79 | 27696132.0 |
| 2015-09-29 12:30:00 | AAPL | Stock | 27.79 | 27.8162 | 27.568 | 27.5825 | 16136684.0 |
| 2015-09-29 13:00:00 | AAPL | Stock | 27.5825 | 27.7 | 27.5425 | 27.6722 | 16046708.0 |
| 2015-09-29 13:30:00 | AAPL | Stock | 27.6725 | 27.76 | 27.6525 | 27.719 | 10620832.0 |
| 2015-09-29 14:00:00 | AAPL | Stock | 27.72 | 27.735 | 27.45 | 27.5225 | 16608968.0 |
| 2015-09-29 14:30:00 | AAPL | Stock | 27.5225 | 27.525 | 27.355 | 27.3575 | 14432092.0 |
| 2015-09-29 15:00:00 | AAPL | Stock | 27.36 | 27.4432 | 26.9775 | 27.0 | 34175268.0 |
| 2015-09-29 15:30:00 | AAPL | Stock | 27.0005 | 27.37 | 26.965 | 27.265 | 42932176.0 |
| 2015-09-29 16:00:00 | AAPL | Stock | 27.265 | 28.1625 | 27.2575 | 27.265 | 8780740.0 |
| 2015-09-29 16:30:00 | AAPL | Stock | 27.2625 | 27.2675 | 27.22 | 27.2625 | 203496.0 |
| 2015-09-29 17:00:00 | AAPL | Stock | 27.265 | 27.275 | 27.23 | 27.275 | 106432.0 |
| 2015-09-29 17:30:00 | AAPL | Stock | 27.275 | 27.2875 | 27.26 | 27.275 | 24400.0 |
| 2015-09-29 18:00:00 | AAPL | Stock | 27.2875 | 27.2875 | 27.2375 | 27.2375 | 67384.0 |
| 2015-09-29 18:30:00 | AAPL | Stock | 27.23 | 27.2625 | 27.225 | 27.2375 | 59164.0 |
| 2015-09-29 19:00:00 | AAPL | Stock | 27.225 | 27.2725 | 27.225 | 27.2625 | 112204.0 |
| 2015-09-29 19:30:00 | AAPL | Stock | 27.2625 | 27.2625 | 27.2125 | 27.2475 | 69480.0 |
| 2015-09-29 07:30:00 | MSFT | Stock | 43.48 | 43.48 | 43.42 | 43.42 | 2200.0 |
| 2015-09-29 08:00:00 | MSFT | Stock | 43.42 | 43.6 | 43.42 | 43.6 | 2225.0 |
| 2015-09-29 08:30:00 | MSFT | Stock | 43.6 | 43.6 | 43.6 | 43.6 | 500.0 |
| 2015-09-29 09:00:00 | MSFT | Stock | 43.6 | 43.6 | 43.32 | 43.36 | 9300.0 |
| 2015-09-29 09:30:00 | MSFT | Stock | 43.39 | 43.51 | 43.19 | 43.36 | 2889241.0 |
| 2015-09-29 10:00:00 | MSFT | Stock | 43.36 | 43.52 | 43.195 | 43.52 | 2568758.0 |
| 2015-09-29 10:30:00 | MSFT | Stock | 43.52 | 43.54 | 43.41 | 43.52 | 1809816.0 |
| 2015-09-29 11:00:00 | MSFT | Stock | 43.53 | 43.54 | 43.37 | 43.49 | 1517189.0 |
| 2015-09-29 11:30:00 | MSFT | Stock | 43.494 | 43.57 | 43.36 | 43.5 | 1226919.0 |
| 2015-09-29 12:00:00 | MSFT | Stock | 43.49 | 43.51 | 43.28 | 43.46 | 1479336.0 |
| 2015-09-29 12:30:00 | MSFT | Stock | 43.47 | 43.49 | 43.28 | 43.285 | 800502.0 |
| 2015-09-29 13:00:00 | MSFT | Stock | 43.29 | 43.48 | 43.23 | 43.41 | 1178563.0 |
| 2015-09-29 13:30:00 | MSFT | Stock | 43.42 | 43.54 | 43.39 | 43.52 | 1150898.0 |
| 2015-09-29 14:00:00 | MSFT | Stock | 43.51 | 43.531 | 43.32 | 43.47 | 1410626.0 |
| 2015-09-29 14:30:00 | MSFT | Stock | 43.47 | 43.51 | 43.22 | 43.27 | 1820163.0 |
| 2015-09-29 15:00:00 | MSFT | Stock | 43.28 | 43.305 | 43.05 | 43.06 | 2276127.0 |
| 2015-09-29 15:30:00 | MSFT | Stock | 43.06 | 43.57 | 43.06 | 43.44 | 5585723.0 |
| 2015-09-29 16:00:00 | MSFT | Stock | 43.44 | 43.44 | 43.295 | 43.295 | 5916182.0 |
> showing 50 of 81,742 rows — these rows as CSV