PREVIEW / stock_30min / 2015-06-04
file: by_date/stock_30min/2015/2015-06-04.parquet size: 1.6 MB rows: 82,073 symbols: 3,493
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-06-04 04:00:00 | AAPL | Stock | 32.515 | 32.515 | 32.2925 | 32.3375 | 34480.0 |
| 2015-06-04 04:30:00 | AAPL | Stock | 32.3375 | 32.3375 | 32.27 | 32.325 | 38840.0 |
| 2015-06-04 05:00:00 | AAPL | Stock | 32.325 | 32.35 | 32.325 | 32.325 | 24992.0 |
| 2015-06-04 05:30:00 | AAPL | Stock | 32.325 | 32.355 | 32.3 | 32.355 | 14000.0 |
| 2015-06-04 06:00:00 | AAPL | Stock | 32.3375 | 32.365 | 32.2875 | 32.36 | 17416.0 |
| 2015-06-04 06:30:00 | AAPL | Stock | 32.335 | 32.36 | 32.2875 | 32.3125 | 10112.0 |
| 2015-06-04 07:00:00 | AAPL | Stock | 32.355 | 32.41 | 32.345 | 32.41 | 53904.0 |
| 2015-06-04 07:30:00 | AAPL | Stock | 32.415 | 32.415 | 32.385 | 32.3925 | 45584.0 |
| 2015-06-04 08:00:00 | AAPL | Stock | 32.395 | 32.4 | 32.3325 | 32.375 | 461740.0 |
| 2015-06-04 08:30:00 | AAPL | Stock | 32.375 | 32.4725 | 32.3675 | 32.4175 | 398632.0 |
| 2015-06-04 09:00:00 | AAPL | Stock | 32.4102 | 32.4325 | 32.3375 | 32.41 | 413668.0 |
| 2015-06-04 09:30:00 | AAPL | Stock | 32.41 | 32.6125 | 32.3375 | 32.565 | 21943108.0 |
| 2015-06-04 10:00:00 | AAPL | Stock | 32.5625 | 32.645 | 32.52 | 32.5525 | 12074648.0 |
| 2015-06-04 10:30:00 | AAPL | Stock | 32.55 | 32.5625 | 32.4522 | 32.46 | 9577488.0 |
| 2015-06-04 11:00:00 | AAPL | Stock | 32.46 | 32.5025 | 32.41 | 32.4575 | 9073416.0 |
| 2015-06-04 11:30:00 | AAPL | Stock | 32.46 | 32.4675 | 32.385 | 32.405 | 8037176.0 |
| 2015-06-04 12:00:00 | AAPL | Stock | 32.4062 | 32.4375 | 32.3825 | 32.42 | 5298504.0 |
| 2015-06-04 12:30:00 | AAPL | Stock | 32.42 | 32.4725 | 32.4025 | 32.4182 | 4702168.0 |
| 2015-06-04 13:00:00 | AAPL | Stock | 32.4175 | 32.42 | 32.3025 | 32.3352 | 12386424.0 |
| 2015-06-04 13:30:00 | AAPL | Stock | 32.3325 | 32.35 | 32.2925 | 32.31 | 7869592.0 |
| 2015-06-04 14:00:00 | AAPL | Stock | 32.3075 | 32.3525 | 32.2275 | 32.289 | 11870480.0 |
| 2015-06-04 14:30:00 | AAPL | Stock | 32.2875 | 32.3075 | 32.2525 | 32.3 | 7442464.0 |
| 2015-06-04 15:00:00 | AAPL | Stock | 32.2975 | 32.3725 | 32.2725 | 32.29 | 9894844.0 |
| 2015-06-04 15:30:00 | AAPL | Stock | 32.2925 | 32.37 | 32.2675 | 32.365 | 16626360.0 |
| 2015-06-04 16:00:00 | AAPL | Stock | 32.34 | 32.4405 | 32.3375 | 32.3725 | 7179712.0 |
| 2015-06-04 16:30:00 | AAPL | Stock | 32.36 | 32.365 | 32.355 | 32.355 | 31328.0 |
| 2015-06-04 17:00:00 | AAPL | Stock | 32.3625 | 32.37 | 32.34 | 32.355 | 115384.0 |
| 2015-06-04 17:30:00 | AAPL | Stock | 32.3525 | 32.3525 | 32.3375 | 32.3425 | 42684.0 |
| 2015-06-04 18:00:00 | AAPL | Stock | 32.3425 | 32.355 | 32.34 | 32.34 | 74796.0 |
| 2015-06-04 18:30:00 | AAPL | Stock | 32.3425 | 32.35 | 32.3375 | 32.35 | 21896.0 |
| 2015-06-04 19:00:00 | AAPL | Stock | 32.3525 | 32.3525 | 32.3375 | 32.3525 | 38096.0 |
| 2015-06-04 19:30:00 | AAPL | Stock | 32.35 | 32.355 | 32.335 | 32.335 | 73356.0 |
| 2015-06-04 04:00:00 | MSFT | Stock | 46.71 | 46.71 | 46.6 | 46.6 | 329.0 |
| 2015-06-04 05:30:00 | MSFT | Stock | 46.54 | 46.54 | 46.54 | 46.54 | 300.0 |
| 2015-06-04 06:30:00 | MSFT | Stock | 46.52 | 46.52 | 46.5 | 46.5 | 2985.0 |
| 2015-06-04 07:00:00 | MSFT | Stock | 46.53 | 46.54 | 46.5 | 46.54 | 9485.0 |
| 2015-06-04 07:30:00 | MSFT | Stock | 46.6 | 46.61 | 46.55 | 46.55 | 3440.0 |
| 2015-06-04 08:00:00 | MSFT | Stock | 46.66 | 46.66 | 46.54 | 46.59 | 11766.0 |
| 2015-06-04 08:30:00 | MSFT | Stock | 46.59 | 46.69 | 46.59 | 46.64 | 18751.0 |
| 2015-06-04 09:00:00 | MSFT | Stock | 46.6 | 46.85 | 46.5 | 46.85 | 54929.0 |
| 2015-06-04 09:30:00 | MSFT | Stock | 46.79 | 47.08 | 46.56 | 47.015 | 3243514.0 |
| 2015-06-04 10:00:00 | MSFT | Stock | 47.015 | 47.16 | 46.793 | 46.84 | 1570033.0 |
| 2015-06-04 10:30:00 | MSFT | Stock | 46.84 | 46.92 | 46.71 | 46.736 | 1347580.0 |
| 2015-06-04 11:00:00 | MSFT | Stock | 46.74 | 46.82 | 46.62 | 46.71 | 1861747.0 |
| 2015-06-04 11:30:00 | MSFT | Stock | 46.72 | 46.72 | 46.44 | 46.54 | 1740694.0 |
| 2015-06-04 12:00:00 | MSFT | Stock | 46.53 | 46.61 | 46.485 | 46.56 | 1160178.0 |
| 2015-06-04 12:30:00 | MSFT | Stock | 46.56 | 46.61 | 46.48 | 46.5 | 1001935.0 |
| 2015-06-04 13:00:00 | MSFT | Stock | 46.5 | 46.5 | 46.28 | 46.33 | 1724644.0 |
| 2015-06-04 13:30:00 | MSFT | Stock | 46.32 | 46.43 | 46.28 | 46.33 | 1384565.0 |
| 2015-06-04 14:00:00 | MSFT | Stock | 46.335 | 46.54 | 46.29 | 46.375 | 1223259.0 |
> showing 50 of 82,073 rows — these rows as CSV