PREVIEW / stock_30min / 2015-10-02
file: by_date/stock_30min/2015/2015-10-02.parquet size: 1.6 MB rows: 81,433 symbols: 3,431
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-02 04:00:00 | AAPL | Stock | 27.4875 | 27.565 | 27.4875 | 27.565 | 18240.0 |
| 2015-10-02 04:30:00 | AAPL | Stock | 27.51 | 27.55 | 27.51 | 27.51 | 5572.0 |
| 2015-10-02 05:00:00 | AAPL | Stock | 27.51 | 27.51 | 27.5 | 27.51 | 3200.0 |
| 2015-10-02 05:30:00 | AAPL | Stock | 27.5 | 27.55 | 27.5 | 27.545 | 14992.0 |
| 2015-10-02 06:00:00 | AAPL | Stock | 27.555 | 27.6125 | 27.53 | 27.57 | 41632.0 |
| 2015-10-02 06:30:00 | AAPL | Stock | 27.59 | 27.6125 | 27.565 | 27.5925 | 39860.0 |
| 2015-10-02 07:00:00 | AAPL | Stock | 27.5825 | 27.5825 | 27.5125 | 27.565 | 105252.0 |
| 2015-10-02 07:30:00 | AAPL | Stock | 27.5625 | 27.565 | 27.525 | 27.5275 | 47044.0 |
| 2015-10-02 08:00:00 | AAPL | Stock | 27.54 | 27.595 | 27.515 | 27.575 | 397200.0 |
| 2015-10-02 08:30:00 | AAPL | Stock | 27.575 | 27.5825 | 27.0 | 27.0675 | 1604224.0 |
| 2015-10-02 09:00:00 | AAPL | Stock | 27.07 | 27.105 | 26.9175 | 27.0125 | 1037804.0 |
| 2015-10-02 09:30:00 | AAPL | Stock | 27.0125 | 27.125 | 26.92 | 27.0488 | 28687472.0 |
| 2015-10-02 10:00:00 | AAPL | Stock | 27.04 | 27.06 | 26.8875 | 26.9825 | 17141020.0 |
| 2015-10-02 10:30:00 | AAPL | Stock | 26.9848 | 27.2225 | 26.9525 | 27.2175 | 14825312.0 |
| 2015-10-02 11:00:00 | AAPL | Stock | 27.215 | 27.285 | 27.1225 | 27.1925 | 13788800.0 |
| 2015-10-02 11:30:00 | AAPL | Stock | 27.19 | 27.3225 | 27.1675 | 27.26 | 14511000.0 |
| 2015-10-02 12:00:00 | AAPL | Stock | 27.2575 | 27.405 | 27.255 | 27.35 | 10359644.0 |
| 2015-10-02 12:30:00 | AAPL | Stock | 27.345 | 27.4925 | 27.34 | 27.45 | 13017116.0 |
| 2015-10-02 13:00:00 | AAPL | Stock | 27.4475 | 27.5425 | 27.41 | 27.4275 | 11979364.0 |
| 2015-10-02 13:30:00 | AAPL | Stock | 27.43 | 27.47 | 27.365 | 27.39 | 7817428.0 |
| 2015-10-02 14:00:00 | AAPL | Stock | 27.39 | 27.605 | 27.385 | 27.5838 | 11068008.0 |
| 2015-10-02 14:30:00 | AAPL | Stock | 27.5825 | 27.625 | 27.4788 | 27.485 | 11144828.0 |
| 2015-10-02 15:00:00 | AAPL | Stock | 27.485 | 27.7375 | 27.4825 | 27.7325 | 16612232.0 |
| 2015-10-02 15:30:00 | AAPL | Stock | 27.7325 | 27.7535 | 27.56 | 27.57 | 32990856.0 |
| 2015-10-02 16:00:00 | AAPL | Stock | 27.595 | 27.595 | 27.5525 | 27.5775 | 8113132.0 |
| 2015-10-02 16:30:00 | AAPL | Stock | 27.575 | 27.5825 | 27.5725 | 27.575 | 62224.0 |
| 2015-10-02 17:00:00 | AAPL | Stock | 27.5775 | 27.595 | 27.5625 | 27.575 | 498348.0 |
| 2015-10-02 17:30:00 | AAPL | Stock | 27.575 | 27.59 | 27.5625 | 27.5825 | 121628.0 |
| 2015-10-02 18:00:00 | AAPL | Stock | 27.585 | 27.5975 | 27.58 | 27.595 | 26732.0 |
| 2015-10-02 18:30:00 | AAPL | Stock | 27.5825 | 27.5925 | 27.58 | 27.59 | 44796.0 |
| 2015-10-02 19:00:00 | AAPL | Stock | 27.5875 | 27.5875 | 27.5825 | 27.5875 | 18892.0 |
| 2015-10-02 19:30:00 | AAPL | Stock | 27.5875 | 27.6 | 27.585 | 27.6 | 40340.0 |
| 2015-10-02 04:00:00 | MSFT | Stock | 44.83 | 44.83 | 44.83 | 44.83 | 500.0 |
| 2015-10-02 05:00:00 | MSFT | Stock | 44.89 | 44.9 | 44.89 | 44.9 | 700.0 |
| 2015-10-02 05:30:00 | MSFT | Stock | 44.85 | 45.04 | 44.85 | 45.0 | 3742.0 |
| 2015-10-02 06:00:00 | MSFT | Stock | 45.06 | 45.06 | 45.06 | 45.06 | 100.0 |
| 2015-10-02 06:30:00 | MSFT | Stock | 45.0 | 45.0 | 45.0 | 45.0 | 1300.0 |
| 2015-10-02 07:30:00 | MSFT | Stock | 44.95 | 44.98 | 44.85 | 44.95 | 15480.0 |
| 2015-10-02 08:00:00 | MSFT | Stock | 44.96 | 44.98 | 44.9 | 44.9 | 7543.0 |
| 2015-10-02 08:30:00 | MSFT | Stock | 44.85 | 44.98 | 44.2 | 44.3 | 92638.0 |
| 2015-10-02 09:00:00 | MSFT | Stock | 44.3 | 44.33 | 44.12 | 44.17 | 83847.0 |
| 2015-10-02 09:30:00 | MSFT | Stock | 44.22 | 44.35 | 43.92 | 44.28 | 4233313.0 |
| 2015-10-02 10:00:00 | MSFT | Stock | 44.29 | 44.4 | 44.05 | 44.185 | 2351518.0 |
| 2015-10-02 10:30:00 | MSFT | Stock | 44.185 | 44.42 | 44.14 | 44.39 | 2194264.0 |
| 2015-10-02 11:00:00 | MSFT | Stock | 44.39 | 44.47 | 44.3 | 44.425 | 1498429.0 |
| 2015-10-02 11:30:00 | MSFT | Stock | 44.43 | 44.53 | 44.3 | 44.47 | 1597124.0 |
| 2015-10-02 12:00:00 | MSFT | Stock | 44.48 | 44.79 | 44.42 | 44.74 | 2118342.0 |
| 2015-10-02 12:30:00 | MSFT | Stock | 44.74 | 45.09 | 44.74 | 44.98 | 3112094.0 |
| 2015-10-02 13:00:00 | MSFT | Stock | 44.985 | 45.22 | 44.96 | 45.105 | 2352577.0 |
| 2015-10-02 13:30:00 | MSFT | Stock | 45.105 | 45.12 | 44.92 | 45.03 | 1905738.0 |
> showing 50 of 81,433 rows — these rows as CSV