PREVIEW / stock_30min / 2015-02-02
file: by_date/stock_30min/2015/2015-02-02.parquet size: 1.6 MB rows: 84,106 symbols: 3,528
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-02-02 04:00:00 | AAPL | Stock | 29.4375 | 29.45 | 29.3975 | 29.3975 | 8896.0 |
| 2015-02-02 04:30:00 | AAPL | Stock | 29.4475 | 29.4475 | 29.4475 | 29.4475 | 800.0 |
| 2015-02-02 05:00:00 | AAPL | Stock | 29.4 | 29.4125 | 29.4 | 29.4125 | 1200.0 |
| 2015-02-02 05:30:00 | AAPL | Stock | 29.4 | 29.4 | 29.3925 | 29.4 | 11832.0 |
| 2015-02-02 06:00:00 | AAPL | Stock | 29.4125 | 29.4125 | 29.375 | 29.375 | 16812.0 |
| 2015-02-02 06:30:00 | AAPL | Stock | 29.3825 | 29.4225 | 29.38 | 29.415 | 7600.0 |
| 2015-02-02 07:00:00 | AAPL | Stock | 29.395 | 29.42 | 29.3825 | 29.4 | 42128.0 |
| 2015-02-02 07:30:00 | AAPL | Stock | 29.4125 | 29.4175 | 29.375 | 29.4175 | 49400.0 |
| 2015-02-02 08:00:00 | AAPL | Stock | 29.3925 | 29.43 | 29.25 | 29.4225 | 1142920.0 |
| 2015-02-02 08:30:00 | AAPL | Stock | 29.425 | 29.4625 | 29.3775 | 29.425 | 1069988.0 |
| 2015-02-02 09:00:00 | AAPL | Stock | 29.4275 | 29.55 | 29.208 | 29.52 | 1244608.0 |
| 2015-02-02 09:30:00 | AAPL | Stock | 29.51 | 29.5962 | 29.16 | 29.1705 | 34233696.0 |
| 2015-02-02 10:00:00 | AAPL | Stock | 29.17 | 29.345 | 29.02 | 29.255 | 25086880.0 |
| 2015-02-02 10:30:00 | AAPL | Stock | 29.255 | 29.3675 | 29.2025 | 29.3225 | 14422188.0 |
| 2015-02-02 11:00:00 | AAPL | Stock | 29.325 | 29.535 | 29.3225 | 29.5225 | 17607820.0 |
| 2015-02-02 11:30:00 | AAPL | Stock | 29.525 | 29.5962 | 29.4575 | 29.4825 | 15930428.0 |
| 2015-02-02 12:00:00 | AAPL | Stock | 29.485 | 29.5 | 29.3725 | 29.42 | 9865936.0 |
| 2015-02-02 12:30:00 | AAPL | Stock | 29.4225 | 29.4675 | 29.24 | 29.2622 | 10360260.0 |
| 2015-02-02 13:00:00 | AAPL | Stock | 29.26 | 29.3975 | 29.2075 | 29.3425 | 11646968.0 |
| 2015-02-02 13:30:00 | AAPL | Stock | 29.3405 | 29.3795 | 29.1625 | 29.2388 | 13310044.0 |
| 2015-02-02 14:00:00 | AAPL | Stock | 29.236 | 29.4 | 29.235 | 29.3975 | 10178064.0 |
| 2015-02-02 14:30:00 | AAPL | Stock | 29.4 | 29.4275 | 29.265 | 29.275 | 10788504.0 |
| 2015-02-02 15:00:00 | AAPL | Stock | 29.2742 | 29.465 | 29.185 | 29.4575 | 15188972.0 |
| 2015-02-02 15:30:00 | AAPL | Stock | 29.465 | 29.7925 | 29.44 | 29.655 | 31834304.0 |
| 2015-02-02 16:00:00 | AAPL | Stock | 29.64 | 29.6625 | 29.2425 | 29.6575 | 8435016.0 |
| 2015-02-02 16:30:00 | AAPL | Stock | 29.645 | 29.6575 | 29.3695 | 29.6375 | 294604.0 |
| 2015-02-02 17:00:00 | AAPL | Stock | 29.6525 | 29.6575 | 29.625 | 29.6375 | 500532.0 |
| 2015-02-02 17:30:00 | AAPL | Stock | 29.6425 | 29.6575 | 29.6175 | 29.63 | 104796.0 |
| 2015-02-02 18:00:00 | AAPL | Stock | 29.625 | 29.6575 | 29.59 | 29.59 | 155784.0 |
| 2015-02-02 18:30:00 | AAPL | Stock | 29.59 | 29.62 | 29.5725 | 29.5725 | 126844.0 |
| 2015-02-02 19:00:00 | AAPL | Stock | 29.5825 | 29.605 | 29.5675 | 29.5975 | 28172.0 |
| 2015-02-02 19:30:00 | AAPL | Stock | 29.58 | 29.6225 | 29.52 | 29.5375 | 324444.0 |
| 2015-02-02 04:30:00 | MSFT | Stock | 40.65 | 40.65 | 40.59 | 40.59 | 400.0 |
| 2015-02-02 05:00:00 | MSFT | Stock | 40.59 | 40.59 | 40.59 | 40.59 | 904.0 |
| 2015-02-02 05:30:00 | MSFT | Stock | 40.59 | 40.61 | 40.59 | 40.61 | 1104.0 |
| 2015-02-02 07:00:00 | MSFT | Stock | 40.56 | 40.68 | 40.56 | 40.68 | 3000.0 |
| 2015-02-02 07:30:00 | MSFT | Stock | 40.63 | 40.63 | 40.55 | 40.55 | 9087.0 |
| 2015-02-02 08:00:00 | MSFT | Stock | 40.6 | 40.6 | 40.45 | 40.55 | 9285.0 |
| 2015-02-02 08:30:00 | MSFT | Stock | 40.55 | 40.55 | 40.45 | 40.46 | 16164.0 |
| 2015-02-02 09:00:00 | MSFT | Stock | 40.48 | 40.64 | 40.4 | 40.55 | 134246.0 |
| 2015-02-02 09:30:00 | MSFT | Stock | 40.59 | 40.765 | 40.48 | 40.54 | 6744791.0 |
| 2015-02-02 10:00:00 | MSFT | Stock | 40.53 | 40.54 | 40.23 | 40.31 | 5058459.0 |
| 2015-02-02 10:30:00 | MSFT | Stock | 40.3 | 40.64 | 40.3 | 40.5 | 3547367.0 |
| 2015-02-02 11:00:00 | MSFT | Stock | 40.5 | 40.75 | 40.48 | 40.71 | 2657415.0 |
| 2015-02-02 11:30:00 | MSFT | Stock | 40.72 | 40.89 | 40.67 | 40.858 | 4186281.0 |
| 2015-02-02 12:00:00 | MSFT | Stock | 40.86 | 40.96 | 40.8 | 40.92 | 2128740.0 |
| 2015-02-02 12:30:00 | MSFT | Stock | 40.918 | 40.97 | 40.69 | 40.71 | 2274093.0 |
| 2015-02-02 13:00:00 | MSFT | Stock | 40.7 | 40.89 | 40.635 | 40.886 | 2100247.0 |
| 2015-02-02 13:30:00 | MSFT | Stock | 40.885 | 40.95 | 40.645 | 40.67 | 2804718.0 |
| 2015-02-02 14:00:00 | MSFT | Stock | 40.67 | 40.91 | 40.65 | 40.91 | 1771098.0 |
> showing 50 of 84,106 rows — these rows as CSV