PREVIEW / stock_30min / 2015-08-11
file: by_date/stock_30min/2015/2015-08-11.parquet size: 1.6 MB rows: 82,301 symbols: 3,476
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-08-11 04:00:00 | AAPL | Stock | 29.83 | 29.86 | 29.7875 | 29.8175 | 27856.0 |
| 2015-08-11 04:30:00 | AAPL | Stock | 29.82 | 29.82 | 29.75 | 29.75 | 54104.0 |
| 2015-08-11 05:00:00 | AAPL | Stock | 29.72 | 29.7875 | 29.6275 | 29.7875 | 26172.0 |
| 2015-08-11 05:30:00 | AAPL | Stock | 29.785 | 29.79 | 29.6875 | 29.6875 | 23228.0 |
| 2015-08-11 06:00:00 | AAPL | Stock | 29.6875 | 29.7425 | 29.6875 | 29.6875 | 48600.0 |
| 2015-08-11 06:30:00 | AAPL | Stock | 29.6875 | 29.7275 | 29.675 | 29.6875 | 70604.0 |
| 2015-08-11 07:00:00 | AAPL | Stock | 29.6875 | 29.7425 | 29.6475 | 29.655 | 152508.0 |
| 2015-08-11 07:30:00 | AAPL | Stock | 29.65 | 29.65 | 29.475 | 29.5125 | 525360.0 |
| 2015-08-11 08:00:00 | AAPL | Stock | 29.505 | 29.7425 | 29.43 | 29.475 | 1308336.0 |
| 2015-08-11 08:30:00 | AAPL | Stock | 29.475 | 29.55 | 29.4575 | 29.47 | 741956.0 |
| 2015-08-11 09:00:00 | AAPL | Stock | 29.4575 | 29.5 | 29.39 | 29.4525 | 1306268.0 |
| 2015-08-11 09:30:00 | AAPL | Stock | 29.4925 | 29.545 | 29.225 | 29.3225 | 39650288.0 |
| 2015-08-11 10:00:00 | AAPL | Stock | 29.3178 | 29.32 | 29.0925 | 29.15 | 29344292.0 |
| 2015-08-11 10:30:00 | AAPL | Stock | 29.155 | 29.22 | 29.0612 | 29.0875 | 19714488.0 |
| 2015-08-11 11:00:00 | AAPL | Stock | 29.0888 | 29.125 | 28.9625 | 28.97 | 21208132.0 |
| 2015-08-11 11:30:00 | AAPL | Stock | 28.97 | 29.05 | 28.85 | 28.875 | 17952864.0 |
| 2015-08-11 12:00:00 | AAPL | Stock | 28.8725 | 28.89 | 28.785 | 28.8325 | 19352356.0 |
| 2015-08-11 12:30:00 | AAPL | Stock | 28.8325 | 28.875 | 28.7025 | 28.715 | 19621308.0 |
| 2015-08-11 13:00:00 | AAPL | Stock | 28.7125 | 28.7225 | 28.455 | 28.5725 | 33748464.0 |
| 2015-08-11 13:30:00 | AAPL | Stock | 28.5725 | 28.6125 | 28.4275 | 28.47 | 27002676.0 |
| 2015-08-11 14:00:00 | AAPL | Stock | 28.475 | 28.5125 | 28.3332 | 28.4125 | 29302220.0 |
| 2015-08-11 14:30:00 | AAPL | Stock | 28.415 | 28.53 | 28.3325 | 28.51 | 26264932.0 |
| 2015-08-11 15:00:00 | AAPL | Stock | 28.515 | 28.5925 | 28.4625 | 28.4875 | 26922428.0 |
| 2015-08-11 15:30:00 | AAPL | Stock | 28.4892 | 28.505 | 28.3725 | 28.3875 | 40523528.0 |
| 2015-08-11 16:00:00 | AAPL | Stock | 28.3725 | 29.4045 | 28.3525 | 28.3875 | 8385324.0 |
| 2015-08-11 16:30:00 | AAPL | Stock | 28.385 | 28.4242 | 28.375 | 28.4125 | 390480.0 |
| 2015-08-11 17:00:00 | AAPL | Stock | 28.4118 | 28.46 | 28.41 | 28.4375 | 119628.0 |
| 2015-08-11 17:30:00 | AAPL | Stock | 28.4375 | 28.445 | 28.4175 | 28.43 | 74468.0 |
| 2015-08-11 18:00:00 | AAPL | Stock | 28.43 | 28.45 | 28.4125 | 28.4468 | 215272.0 |
| 2015-08-11 18:30:00 | AAPL | Stock | 28.4468 | 28.46 | 28.445 | 28.455 | 82980.0 |
| 2015-08-11 19:00:00 | AAPL | Stock | 28.4575 | 28.47 | 28.4475 | 28.4675 | 95916.0 |
| 2015-08-11 19:30:00 | AAPL | Stock | 28.455 | 28.475 | 28.4375 | 28.465 | 134764.0 |
| 2015-08-11 05:00:00 | MSFT | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 2450.0 |
| 2015-08-11 07:30:00 | MSFT | Stock | 46.95 | 47.0 | 46.95 | 46.95 | 2200.0 |
| 2015-08-11 08:00:00 | MSFT | Stock | 47.0 | 47.0 | 46.82 | 46.86 | 5517.0 |
| 2015-08-11 08:30:00 | MSFT | Stock | 46.86 | 46.9 | 46.8 | 46.8 | 9380.0 |
| 2015-08-11 09:00:00 | MSFT | Stock | 46.77 | 46.88 | 46.75 | 46.8 | 15238.0 |
| 2015-08-11 09:30:00 | MSFT | Stock | 46.82 | 46.94 | 46.51 | 46.76 | 3096095.0 |
| 2015-08-11 10:00:00 | MSFT | Stock | 46.76 | 46.79 | 46.59 | 46.6 | 1625992.0 |
| 2015-08-11 10:30:00 | MSFT | Stock | 46.59 | 46.626 | 46.48 | 46.49 | 1446727.0 |
| 2015-08-11 11:00:00 | MSFT | Stock | 46.499 | 46.53 | 46.27 | 46.32 | 1776764.0 |
| 2015-08-11 11:30:00 | MSFT | Stock | 46.33 | 46.36 | 46.171 | 46.23 | 1199028.0 |
| 2015-08-11 12:00:00 | MSFT | Stock | 46.23 | 46.35 | 46.183 | 46.34 | 1067224.0 |
| 2015-08-11 12:30:00 | MSFT | Stock | 46.33 | 46.33 | 46.18 | 46.2 | 1112575.0 |
| 2015-08-11 13:00:00 | MSFT | Stock | 46.19 | 46.21 | 46.0 | 46.05 | 1292894.0 |
| 2015-08-11 13:30:00 | MSFT | Stock | 46.05 | 46.1 | 45.97 | 46.0 | 1364703.0 |
| 2015-08-11 14:00:00 | MSFT | Stock | 46.01 | 46.23 | 45.9 | 46.21 | 1469965.0 |
| 2015-08-11 14:30:00 | MSFT | Stock | 46.21 | 46.275 | 46.144 | 46.2 | 1225226.0 |
| 2015-08-11 15:00:00 | MSFT | Stock | 46.195 | 46.28 | 46.12 | 46.23 | 1420609.0 |
| 2015-08-11 15:30:00 | MSFT | Stock | 46.22 | 46.49 | 46.17 | 46.42 | 5584403.0 |
> showing 50 of 82,301 rows — these rows as CSV