PREVIEW / stock_30min / 2015-12-15
file: by_date/stock_30min/2015/2015-12-15.parquet size: 1.6 MB rows: 85,145 symbols: 3,434
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-12-15 04:00:00 | AAPL | Stock | 28.1125 | 28.2125 | 28.0825 | 28.0975 | 45504.0 |
| 2015-12-15 04:30:00 | AAPL | Stock | 28.125 | 28.2125 | 28.125 | 28.175 | 53216.0 |
| 2015-12-15 05:00:00 | AAPL | Stock | 28.175 | 28.175 | 28.0975 | 28.1625 | 59764.0 |
| 2015-12-15 05:30:00 | AAPL | Stock | 28.13 | 28.13 | 27.94 | 27.97 | 65696.0 |
| 2015-12-15 06:00:00 | AAPL | Stock | 27.975 | 28.0 | 27.905 | 27.905 | 80832.0 |
| 2015-12-15 06:30:00 | AAPL | Stock | 27.905 | 27.905 | 27.5275 | 27.725 | 182364.0 |
| 2015-12-15 07:00:00 | AAPL | Stock | 27.7375 | 27.8675 | 27.7375 | 27.825 | 149640.0 |
| 2015-12-15 07:30:00 | AAPL | Stock | 27.825 | 27.83 | 27.6275 | 27.7875 | 301444.0 |
| 2015-12-15 08:00:00 | AAPL | Stock | 27.8 | 27.8825 | 27.63 | 27.85 | 906756.0 |
| 2015-12-15 08:30:00 | AAPL | Stock | 27.85 | 27.995 | 27.7775 | 27.98 | 625076.0 |
| 2015-12-15 09:00:00 | AAPL | Stock | 27.9825 | 28.03 | 27.9625 | 27.9925 | 1149756.0 |
| 2015-12-15 09:30:00 | AAPL | Stock | 27.985 | 28.0875 | 27.7825 | 27.8475 | 34826352.0 |
| 2015-12-15 10:00:00 | AAPL | Stock | 27.8475 | 27.9975 | 27.84 | 27.9925 | 15752416.0 |
| 2015-12-15 10:30:00 | AAPL | Stock | 27.995 | 28.2 | 27.9175 | 28.16 | 18084240.0 |
| 2015-12-15 11:00:00 | AAPL | Stock | 28.155 | 28.16 | 27.9625 | 28.005 | 14271696.0 |
| 2015-12-15 11:30:00 | AAPL | Stock | 28.005 | 28.03 | 27.8 | 27.875 | 13144136.0 |
| 2015-12-15 12:00:00 | AAPL | Stock | 27.875 | 27.935 | 27.835 | 27.8988 | 8738852.0 |
| 2015-12-15 12:30:00 | AAPL | Stock | 27.899 | 28.0225 | 27.895 | 28.0075 | 8801300.0 |
| 2015-12-15 13:00:00 | AAPL | Stock | 28.0075 | 28.02 | 27.885 | 27.8925 | 6952556.0 |
| 2015-12-15 13:30:00 | AAPL | Stock | 27.895 | 27.9675 | 27.875 | 27.9425 | 8614848.0 |
| 2015-12-15 14:00:00 | AAPL | Stock | 27.9425 | 27.985 | 27.8775 | 27.8985 | 6781264.0 |
| 2015-12-15 14:30:00 | AAPL | Stock | 27.8982 | 27.92 | 27.8325 | 27.844 | 8125744.0 |
| 2015-12-15 15:00:00 | AAPL | Stock | 27.845 | 27.8575 | 27.6525 | 27.6775 | 14831484.0 |
| 2015-12-15 15:30:00 | AAPL | Stock | 27.675 | 27.71 | 27.5875 | 27.6225 | 25614308.0 |
| 2015-12-15 16:00:00 | AAPL | Stock | 27.6225 | 28.0878 | 27.5825 | 27.6175 | 8468520.0 |
| 2015-12-15 16:30:00 | AAPL | Stock | 27.6125 | 27.6675 | 27.6125 | 27.6325 | 182988.0 |
| 2015-12-15 17:00:00 | AAPL | Stock | 27.6375 | 28.0502 | 27.61 | 27.6175 | 73196.0 |
| 2015-12-15 17:30:00 | AAPL | Stock | 27.6075 | 27.6125 | 27.5875 | 27.595 | 42756.0 |
| 2015-12-15 18:00:00 | AAPL | Stock | 27.6025 | 27.6075 | 27.59 | 27.6 | 22612.0 |
| 2015-12-15 18:30:00 | AAPL | Stock | 27.6 | 27.6125 | 27.5875 | 27.5875 | 41048.0 |
| 2015-12-15 19:00:00 | AAPL | Stock | 27.6 | 27.6 | 27.585 | 27.5975 | 33696.0 |
| 2015-12-15 19:30:00 | AAPL | Stock | 27.5875 | 27.6225 | 27.5875 | 27.6225 | 37752.0 |
| 2015-12-15 04:00:00 | MSFT | Stock | 55.49 | 55.54 | 55.49 | 55.54 | 8304.0 |
| 2015-12-15 05:00:00 | MSFT | Stock | 55.54 | 55.55 | 55.53 | 55.55 | 3950.0 |
| 2015-12-15 05:30:00 | MSFT | Stock | 55.51 | 55.52 | 55.51 | 55.52 | 1200.0 |
| 2015-12-15 06:00:00 | MSFT | Stock | 55.53 | 55.53 | 55.53 | 55.53 | 305.0 |
| 2015-12-15 07:00:00 | MSFT | Stock | 55.53 | 55.53 | 55.52 | 55.52 | 2300.0 |
| 2015-12-15 07:30:00 | MSFT | Stock | 55.59 | 55.59 | 55.49 | 55.49 | 5500.0 |
| 2015-12-15 08:00:00 | MSFT | Stock | 55.52 | 55.57 | 55.42 | 55.57 | 21101.0 |
| 2015-12-15 08:30:00 | MSFT | Stock | 55.6 | 55.69 | 55.6 | 55.69 | 11362.0 |
| 2015-12-15 09:00:00 | MSFT | Stock | 55.73 | 55.78 | 55.53 | 55.58 | 93010.0 |
| 2015-12-15 09:30:00 | MSFT | Stock | 55.63 | 55.9 | 55.446 | 55.775 | 6297827.0 |
| 2015-12-15 10:00:00 | MSFT | Stock | 55.78 | 55.79 | 55.52 | 55.641 | 4241947.0 |
| 2015-12-15 10:30:00 | MSFT | Stock | 55.64 | 55.67 | 55.47 | 55.475 | 3038368.0 |
| 2015-12-15 11:00:00 | MSFT | Stock | 55.48 | 55.525 | 55.12 | 55.24 | 2560673.0 |
| 2015-12-15 11:30:00 | MSFT | Stock | 55.24 | 55.32 | 55.09 | 55.26 | 2159885.0 |
| 2015-12-15 12:00:00 | MSFT | Stock | 55.25 | 55.53 | 55.23 | 55.3 | 2533706.0 |
| 2015-12-15 12:30:00 | MSFT | Stock | 55.295 | 55.58 | 55.29 | 55.58 | 2015884.0 |
| 2015-12-15 13:00:00 | MSFT | Stock | 55.58 | 55.595 | 55.34 | 55.38 | 1548402.0 |
| 2015-12-15 13:30:00 | MSFT | Stock | 55.38 | 55.56 | 55.34 | 55.5 | 1464036.0 |
> showing 50 of 85,145 rows — these rows as CSV