PREVIEW / stock_30min / 2016-03-07
file: by_date/stock_30min/2016/2016-03-07.parquet size: 1.6 MB rows: 83,538 symbols: 3,366
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-07 04:00:00 | AAPL | Stock | 25.7525 | 25.7525 | 25.7525 | 25.7525 | 2000.0 |
| 2016-03-07 05:00:00 | AAPL | Stock | 25.6675 | 25.7075 | 25.63 | 25.685 | 24540.0 |
| 2016-03-07 05:30:00 | AAPL | Stock | 25.685 | 25.69 | 25.63 | 25.63 | 10720.0 |
| 2016-03-07 06:00:00 | AAPL | Stock | 25.6575 | 25.75 | 25.6425 | 25.75 | 74664.0 |
| 2016-03-07 06:30:00 | AAPL | Stock | 25.725 | 25.75 | 25.7225 | 25.7275 | 21068.0 |
| 2016-03-07 07:00:00 | AAPL | Stock | 25.7275 | 25.77 | 25.725 | 25.77 | 83332.0 |
| 2016-03-07 07:30:00 | AAPL | Stock | 25.7725 | 25.795 | 25.75 | 25.795 | 110672.0 |
| 2016-03-07 08:00:00 | AAPL | Stock | 25.7725 | 25.795 | 25.7525 | 25.76 | 256516.0 |
| 2016-03-07 08:30:00 | AAPL | Stock | 25.755 | 25.765 | 25.7075 | 25.725 | 199728.0 |
| 2016-03-07 09:00:00 | AAPL | Stock | 25.73 | 25.73 | 25.5925 | 25.5925 | 377148.0 |
| 2016-03-07 09:30:00 | AAPL | Stock | 25.595 | 25.7075 | 25.505 | 25.5125 | 21716656.0 |
| 2016-03-07 10:00:00 | AAPL | Stock | 25.51 | 25.545 | 25.425 | 25.44 | 14537644.0 |
| 2016-03-07 10:30:00 | AAPL | Stock | 25.4402 | 25.5875 | 25.4375 | 25.5288 | 9222776.0 |
| 2016-03-07 11:00:00 | AAPL | Stock | 25.5275 | 25.5375 | 25.4725 | 25.4875 | 8462608.0 |
| 2016-03-07 11:30:00 | AAPL | Stock | 25.4875 | 25.5875 | 25.48 | 25.5225 | 9352856.0 |
| 2016-03-07 12:00:00 | AAPL | Stock | 25.5245 | 25.5375 | 25.4925 | 25.5025 | 4171892.0 |
| 2016-03-07 12:30:00 | AAPL | Stock | 25.5025 | 25.52 | 25.4895 | 25.5025 | 3104984.0 |
| 2016-03-07 13:00:00 | AAPL | Stock | 25.5025 | 25.5275 | 25.4075 | 25.4388 | 6496460.0 |
| 2016-03-07 13:30:00 | AAPL | Stock | 25.44 | 25.44 | 25.35 | 25.4225 | 7394040.0 |
| 2016-03-07 14:00:00 | AAPL | Stock | 25.42 | 25.445 | 25.3375 | 25.3425 | 6951856.0 |
| 2016-03-07 14:30:00 | AAPL | Stock | 25.3412 | 25.3875 | 25.32 | 25.3275 | 8162000.0 |
| 2016-03-07 15:00:00 | AAPL | Stock | 25.3275 | 25.418 | 25.24 | 25.385 | 9530608.0 |
| 2016-03-07 15:30:00 | AAPL | Stock | 25.385 | 25.48 | 25.3625 | 25.4675 | 14369456.0 |
| 2016-03-07 16:00:00 | AAPL | Stock | 25.4675 | 25.47 | 25.425 | 25.46 | 5489456.0 |
| 2016-03-07 16:30:00 | AAPL | Stock | 25.45 | 25.46 | 25.4325 | 25.44 | 16604.0 |
| 2016-03-07 17:00:00 | AAPL | Stock | 25.45 | 25.4625 | 25.4375 | 25.45 | 22768.0 |
| 2016-03-07 17:30:00 | AAPL | Stock | 25.45 | 25.45 | 25.4225 | 25.4375 | 30724.0 |
| 2016-03-07 18:00:00 | AAPL | Stock | 25.425 | 25.445 | 25.425 | 25.4275 | 16000.0 |
| 2016-03-07 18:30:00 | AAPL | Stock | 25.425 | 25.4425 | 25.425 | 25.4275 | 14800.0 |
| 2016-03-07 19:00:00 | AAPL | Stock | 25.4425 | 25.4425 | 25.425 | 25.43 | 10680.0 |
| 2016-03-07 19:30:00 | AAPL | Stock | 25.4325 | 25.435 | 25.4225 | 25.4225 | 8836.0 |
| 2016-03-07 04:00:00 | MSFT | Stock | 51.85 | 51.85 | 51.85 | 51.85 | 130.0 |
| 2016-03-07 06:30:00 | MSFT | Stock | 51.72 | 51.72 | 51.65 | 51.72 | 1225.0 |
| 2016-03-07 07:00:00 | MSFT | Stock | 51.75 | 51.75 | 51.75 | 51.75 | 2200.0 |
| 2016-03-07 07:30:00 | MSFT | Stock | 51.7 | 51.79 | 51.7 | 51.79 | 2400.0 |
| 2016-03-07 08:00:00 | MSFT | Stock | 51.79 | 51.79 | 51.7 | 51.7 | 16000.0 |
| 2016-03-07 08:30:00 | MSFT | Stock | 51.75 | 51.75 | 51.68 | 51.7 | 11780.0 |
| 2016-03-07 09:00:00 | MSFT | Stock | 51.71 | 51.92 | 51.51 | 51.69 | 51188.0 |
| 2016-03-07 09:30:00 | MSFT | Stock | 51.69 | 51.8 | 51.3 | 51.35 | 3084874.0 |
| 2016-03-07 10:00:00 | MSFT | Stock | 51.35 | 51.496 | 51.12 | 51.13 | 2363550.0 |
| 2016-03-07 10:30:00 | MSFT | Stock | 51.12 | 51.32 | 51.01 | 51.06 | 2604521.0 |
| 2016-03-07 11:00:00 | MSFT | Stock | 51.06 | 51.11 | 50.8 | 50.945 | 3406445.0 |
| 2016-03-07 11:30:00 | MSFT | Stock | 50.95 | 51.26 | 50.945 | 51.15 | 2119562.0 |
| 2016-03-07 12:00:00 | MSFT | Stock | 51.16 | 51.255 | 51.08 | 51.24 | 1374007.0 |
| 2016-03-07 12:30:00 | MSFT | Stock | 51.24 | 51.43 | 51.23 | 51.27 | 1096145.0 |
| 2016-03-07 13:00:00 | MSFT | Stock | 51.27 | 51.41 | 51.14 | 51.14 | 1396206.0 |
| 2016-03-07 13:30:00 | MSFT | Stock | 51.14 | 51.15 | 50.92 | 50.99 | 2527757.0 |
| 2016-03-07 14:00:00 | MSFT | Stock | 50.99 | 51.11 | 50.87 | 50.875 | 2161536.0 |
| 2016-03-07 14:30:00 | MSFT | Stock | 50.87 | 50.92 | 50.6 | 50.704 | 3162652.0 |
| 2016-03-07 15:00:00 | MSFT | Stock | 50.7 | 50.9 | 50.58 | 50.85 | 2753989.0 |
> showing 50 of 83,538 rows — these rows as CSV