PREVIEW / stock_30min / 2015-03-30
file: by_date/stock_30min/2015/2015-03-30.parquet size: 1.6 MB rows: 83,744 symbols: 3,524
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-03-30 04:00:00 | AAPL | Stock | 30.7725 | 31.15 | 30.7725 | 31.1 | 63580.0 |
| 2015-03-30 04:30:00 | AAPL | Stock | 31.0875 | 31.1575 | 31.0875 | 31.1325 | 8400.0 |
| 2015-03-30 05:00:00 | AAPL | Stock | 31.15 | 31.1525 | 31.125 | 31.1325 | 10044.0 |
| 2015-03-30 05:30:00 | AAPL | Stock | 31.135 | 31.15 | 31.08 | 31.1 | 23048.0 |
| 2015-03-30 06:00:00 | AAPL | Stock | 31.1 | 31.1225 | 31.08 | 31.08 | 64204.0 |
| 2015-03-30 06:30:00 | AAPL | Stock | 31.0775 | 31.1 | 31.05 | 31.065 | 36664.0 |
| 2015-03-30 07:00:00 | AAPL | Stock | 31.0575 | 31.0825 | 31.0375 | 31.0825 | 222588.0 |
| 2015-03-30 07:30:00 | AAPL | Stock | 31.075 | 31.085 | 31.05 | 31.075 | 52604.0 |
| 2015-03-30 08:00:00 | AAPL | Stock | 31.0625 | 31.11 | 30.8125 | 31.0248 | 461308.0 |
| 2015-03-30 08:30:00 | AAPL | Stock | 31.025 | 31.1075 | 31.0125 | 31.0125 | 205560.0 |
| 2015-03-30 09:00:00 | AAPL | Stock | 31.005 | 31.06 | 31.0 | 31.0125 | 334916.0 |
| 2015-03-30 09:30:00 | AAPL | Stock | 31.0125 | 31.37 | 31.0 | 31.3425 | 31410916.0 |
| 2015-03-30 10:00:00 | AAPL | Stock | 31.34 | 31.405 | 31.28 | 31.3075 | 18534312.0 |
| 2015-03-30 10:30:00 | AAPL | Stock | 31.3072 | 31.3875 | 31.2675 | 31.355 | 12580308.0 |
| 2015-03-30 11:00:00 | AAPL | Stock | 31.355 | 31.395 | 31.27 | 31.2825 | 8195836.0 |
| 2015-03-30 11:30:00 | AAPL | Stock | 31.2825 | 31.3225 | 31.2275 | 31.265 | 8082948.0 |
| 2015-03-30 12:00:00 | AAPL | Stock | 31.265 | 31.3425 | 31.255 | 31.34 | 5328276.0 |
| 2015-03-30 12:30:00 | AAPL | Stock | 31.34 | 31.38 | 31.315 | 31.3625 | 6227404.0 |
| 2015-03-30 13:00:00 | AAPL | Stock | 31.365 | 31.4375 | 31.3532 | 31.4178 | 7953988.0 |
| 2015-03-30 13:30:00 | AAPL | Stock | 31.4175 | 31.4725 | 31.4075 | 31.4475 | 6769556.0 |
| 2015-03-30 14:00:00 | AAPL | Stock | 31.4475 | 31.4825 | 31.4262 | 31.43 | 6477156.0 |
| 2015-03-30 14:30:00 | AAPL | Stock | 31.43 | 31.47 | 31.41 | 31.425 | 6298784.0 |
| 2015-03-30 15:00:00 | AAPL | Stock | 31.4275 | 31.5275 | 31.4275 | 31.5175 | 10643832.0 |
| 2015-03-30 15:30:00 | AAPL | Stock | 31.5175 | 31.6 | 31.4812 | 31.5825 | 20603668.0 |
| 2015-03-30 16:00:00 | AAPL | Stock | 31.5875 | 31.5962 | 31.3798 | 31.5775 | 7698768.0 |
| 2015-03-30 16:30:00 | AAPL | Stock | 31.58 | 31.5925 | 31.3235 | 31.5775 | 188740.0 |
| 2015-03-30 17:00:00 | AAPL | Stock | 31.575 | 31.5925 | 31.575 | 31.5925 | 87892.0 |
| 2015-03-30 17:30:00 | AAPL | Stock | 31.59 | 31.595 | 31.58 | 31.595 | 118524.0 |
| 2015-03-30 18:00:00 | AAPL | Stock | 31.595 | 31.61 | 31.5828 | 31.61 | 63252.0 |
| 2015-03-30 18:30:00 | AAPL | Stock | 31.605 | 31.6075 | 31.5925 | 31.6075 | 150032.0 |
| 2015-03-30 19:00:00 | AAPL | Stock | 31.6075 | 31.61 | 31.6 | 31.61 | 34620.0 |
| 2015-03-30 19:30:00 | AAPL | Stock | 31.61 | 31.62 | 31.6 | 31.6125 | 110012.0 |
| 2015-03-30 06:00:00 | MSFT | Stock | 41.28 | 41.28 | 41.28 | 41.28 | 1500.0 |
| 2015-03-30 06:30:00 | MSFT | Stock | 41.28 | 41.3 | 41.28 | 41.28 | 6800.0 |
| 2015-03-30 07:30:00 | MSFT | Stock | 41.25 | 41.25 | 41.25 | 41.25 | 200.0 |
| 2015-03-30 08:00:00 | MSFT | Stock | 41.23 | 41.26 | 41.23 | 41.25 | 10600.0 |
| 2015-03-30 08:30:00 | MSFT | Stock | 41.28 | 41.28 | 41.23 | 41.24 | 1710.0 |
| 2015-03-30 09:00:00 | MSFT | Stock | 41.28 | 41.43 | 41.18 | 41.22 | 24390.0 |
| 2015-03-30 09:30:00 | MSFT | Stock | 41.21 | 41.54 | 41.08 | 41.44 | 4131496.0 |
| 2015-03-30 10:00:00 | MSFT | Stock | 41.45 | 41.47 | 41.21 | 41.23 | 2384719.0 |
| 2015-03-30 10:30:00 | MSFT | Stock | 41.24 | 41.34 | 41.21 | 41.325 | 1773408.0 |
| 2015-03-30 11:00:00 | MSFT | Stock | 41.33 | 41.335 | 41.195 | 41.28 | 1463911.0 |
| 2015-03-30 11:30:00 | MSFT | Stock | 41.275 | 41.33 | 41.22 | 41.29 | 1850622.0 |
| 2015-03-30 12:00:00 | MSFT | Stock | 41.3 | 41.36 | 41.26 | 41.36 | 1450374.0 |
| 2015-03-30 12:30:00 | MSFT | Stock | 41.35 | 41.39 | 41.32 | 41.344 | 1116780.0 |
| 2015-03-30 13:00:00 | MSFT | Stock | 41.35 | 41.36 | 41.25 | 41.25 | 1741151.0 |
| 2015-03-30 13:30:00 | MSFT | Stock | 41.25 | 41.26 | 41.1 | 41.13 | 1774771.0 |
| 2015-03-30 14:00:00 | MSFT | Stock | 41.13 | 41.19 | 41.08 | 41.13 | 1877377.0 |
| 2015-03-30 14:30:00 | MSFT | Stock | 41.115 | 41.16 | 41.03 | 41.06 | 1924403.0 |
| 2015-03-30 15:00:00 | MSFT | Stock | 41.06 | 41.15 | 41.04 | 41.04 | 2193550.0 |
> showing 50 of 83,744 rows — these rows as CSV