PREVIEW / stock_30min / 2015-10-29
file: by_date/stock_30min/2015/2015-10-29.parquet size: 1.6 MB rows: 81,034 symbols: 3,408
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-10-29 04:00:00 | AAPL | Stock | 29.8 | 29.8 | 29.5425 | 29.5675 | 17412.0 |
| 2015-10-29 04:30:00 | AAPL | Stock | 29.59 | 29.6125 | 29.565 | 29.6075 | 4804.0 |
| 2015-10-29 05:00:00 | AAPL | Stock | 29.5625 | 29.575 | 29.545 | 29.575 | 27024.0 |
| 2015-10-29 05:30:00 | AAPL | Stock | 29.5975 | 29.6 | 29.5625 | 29.6 | 9320.0 |
| 2015-10-29 06:00:00 | AAPL | Stock | 29.5975 | 29.6 | 29.5625 | 29.6 | 22188.0 |
| 2015-10-29 06:30:00 | AAPL | Stock | 29.6 | 29.6125 | 29.555 | 29.5875 | 8800.0 |
| 2015-10-29 07:00:00 | AAPL | Stock | 29.6 | 29.625 | 29.5875 | 29.6 | 56880.0 |
| 2015-10-29 07:30:00 | AAPL | Stock | 29.6 | 29.6075 | 29.55 | 29.55 | 161056.0 |
| 2015-10-29 08:00:00 | AAPL | Stock | 29.565 | 29.625 | 29.5525 | 29.6175 | 421872.0 |
| 2015-10-29 08:30:00 | AAPL | Stock | 29.6225 | 29.65 | 29.6 | 29.65 | 391608.0 |
| 2015-10-29 09:00:00 | AAPL | Stock | 29.65 | 29.6875 | 29.65 | 29.675 | 425024.0 |
| 2015-10-29 09:30:00 | AAPL | Stock | 29.675 | 29.8 | 29.575 | 29.6175 | 27054152.0 |
| 2015-10-29 10:00:00 | AAPL | Stock | 29.6225 | 29.7975 | 29.5675 | 29.67 | 17819124.0 |
| 2015-10-29 10:30:00 | AAPL | Stock | 29.6698 | 29.77 | 29.655 | 29.66 | 10632040.0 |
| 2015-10-29 11:00:00 | AAPL | Stock | 29.6625 | 29.7 | 29.6175 | 29.6508 | 8524288.0 |
| 2015-10-29 11:30:00 | AAPL | Stock | 29.652 | 29.7325 | 29.6425 | 29.72 | 7182576.0 |
| 2015-10-29 12:00:00 | AAPL | Stock | 29.7175 | 29.8175 | 29.68 | 29.8125 | 7094716.0 |
| 2015-10-29 12:30:00 | AAPL | Stock | 29.815 | 29.955 | 29.8015 | 29.945 | 13192096.0 |
| 2015-10-29 13:00:00 | AAPL | Stock | 29.945 | 29.965 | 29.8875 | 29.91 | 8604840.0 |
| 2015-10-29 13:30:00 | AAPL | Stock | 29.9078 | 29.9675 | 29.8275 | 29.945 | 16871252.0 |
| 2015-10-29 14:00:00 | AAPL | Stock | 29.945 | 30.095 | 29.925 | 30.0725 | 15993796.0 |
| 2015-10-29 14:30:00 | AAPL | Stock | 30.0728 | 30.1375 | 30.04 | 30.12 | 12729428.0 |
| 2015-10-29 15:00:00 | AAPL | Stock | 30.12 | 30.15 | 30.0325 | 30.1045 | 16077504.0 |
| 2015-10-29 15:30:00 | AAPL | Stock | 30.1028 | 30.1725 | 30.1025 | 30.1325 | 22720284.0 |
| 2015-10-29 16:00:00 | AAPL | Stock | 30.1325 | 30.1625 | 29.9542 | 30.1625 | 4471460.0 |
| 2015-10-29 16:30:00 | AAPL | Stock | 30.1675 | 30.1875 | 30.1325 | 30.17 | 318628.0 |
| 2015-10-29 17:00:00 | AAPL | Stock | 30.1675 | 30.1925 | 30.1675 | 30.1725 | 74832.0 |
| 2015-10-29 17:30:00 | AAPL | Stock | 30.1725 | 30.1825 | 30.125 | 30.1475 | 76816.0 |
| 2015-10-29 18:00:00 | AAPL | Stock | 30.145 | 30.1875 | 30.1425 | 30.165 | 90852.0 |
| 2015-10-29 18:30:00 | AAPL | Stock | 30.1725 | 30.175 | 30.1525 | 30.1625 | 37440.0 |
| 2015-10-29 19:00:00 | AAPL | Stock | 30.1625 | 30.1625 | 30.1325 | 30.1525 | 56972.0 |
| 2015-10-29 19:30:00 | AAPL | Stock | 30.1625 | 30.17 | 30.1525 | 30.16 | 70072.0 |
| 2015-10-29 04:30:00 | MSFT | Stock | 53.74 | 53.74 | 53.74 | 53.74 | 500.0 |
| 2015-10-29 05:00:00 | MSFT | Stock | 53.74 | 53.74 | 53.6 | 53.6 | 817.0 |
| 2015-10-29 05:30:00 | MSFT | Stock | 53.6 | 53.6 | 53.59 | 53.59 | 1017.0 |
| 2015-10-29 06:00:00 | MSFT | Stock | 53.6 | 53.6 | 53.6 | 53.6 | 400.0 |
| 2015-10-29 06:30:00 | MSFT | Stock | 53.62 | 53.62 | 53.62 | 53.62 | 300.0 |
| 2015-10-29 07:00:00 | MSFT | Stock | 53.62 | 53.67 | 53.6 | 53.63 | 5510.0 |
| 2015-10-29 07:30:00 | MSFT | Stock | 53.65 | 53.65 | 53.64 | 53.64 | 1000.0 |
| 2015-10-29 08:00:00 | MSFT | Stock | 53.69 | 53.71 | 53.63 | 53.65 | 9700.0 |
| 2015-10-29 08:30:00 | MSFT | Stock | 53.69 | 53.74 | 53.65 | 53.7 | 3655.0 |
| 2015-10-29 09:00:00 | MSFT | Stock | 53.7 | 53.7 | 53.55 | 53.56 | 21402.0 |
| 2015-10-29 09:30:00 | MSFT | Stock | 53.55 | 53.77 | 53.22 | 53.69 | 2849661.0 |
| 2015-10-29 10:00:00 | MSFT | Stock | 53.69 | 53.83 | 53.43 | 53.49 | 2111756.0 |
| 2015-10-29 10:30:00 | MSFT | Stock | 53.49 | 53.56 | 53.255 | 53.28 | 1847055.0 |
| 2015-10-29 11:00:00 | MSFT | Stock | 53.29 | 53.4 | 53.225 | 53.395 | 1731387.0 |
| 2015-10-29 11:30:00 | MSFT | Stock | 53.395 | 53.505 | 53.37 | 53.475 | 1915252.0 |
| 2015-10-29 12:00:00 | MSFT | Stock | 53.48 | 53.6 | 53.36 | 53.545 | 1433852.0 |
| 2015-10-29 12:30:00 | MSFT | Stock | 53.54 | 53.65 | 53.49 | 53.49 | 1525782.0 |
| 2015-10-29 13:00:00 | MSFT | Stock | 53.49 | 53.55 | 53.43 | 53.44 | 1779425.0 |
> showing 50 of 81,034 rows — these rows as CSV