PREVIEW / stock_30min / 2015-12-31
file: by_date/stock_30min/2015/2015-12-31.parquet size: 1.6 MB rows: 82,931 symbols: 3,441
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-12-31 06:00:00 | AAPL | Stock | 26.88 | 26.88 | 26.88 | 26.88 | 400.0 |
| 2015-12-31 06:30:00 | AAPL | Stock | 26.8875 | 26.8875 | 26.8775 | 26.88 | 3300.0 |
| 2015-12-31 07:00:00 | AAPL | Stock | 26.88 | 26.88 | 26.875 | 26.8775 | 12600.0 |
| 2015-12-31 07:30:00 | AAPL | Stock | 26.8375 | 26.84 | 26.81 | 26.8125 | 11996.0 |
| 2015-12-31 08:00:00 | AAPL | Stock | 26.82 | 26.8775 | 26.785 | 26.7925 | 58384.0 |
| 2015-12-31 08:30:00 | AAPL | Stock | 26.795 | 26.8025 | 26.75 | 26.755 | 60184.0 |
| 2015-12-31 09:00:00 | AAPL | Stock | 26.7725 | 26.7775 | 26.7275 | 26.76 | 106092.0 |
| 2015-12-31 09:30:00 | AAPL | Stock | 26.7525 | 26.7575 | 26.4725 | 26.5452 | 18850588.0 |
| 2015-12-31 10:00:00 | AAPL | Stock | 26.545 | 26.585 | 26.47 | 26.4825 | 11154068.0 |
| 2015-12-31 10:30:00 | AAPL | Stock | 26.48 | 26.51 | 26.415 | 26.4675 | 10356596.0 |
| 2015-12-31 11:00:00 | AAPL | Stock | 26.465 | 26.5075 | 26.44 | 26.46 | 6951008.0 |
| 2015-12-31 11:30:00 | AAPL | Stock | 26.4575 | 26.475 | 26.407 | 26.445 | 7579444.0 |
| 2015-12-31 12:00:00 | AAPL | Stock | 26.445 | 26.5225 | 26.44 | 26.457 | 7990412.0 |
| 2015-12-31 12:30:00 | AAPL | Stock | 26.4562 | 26.48 | 26.4125 | 26.416 | 6786108.0 |
| 2015-12-31 13:00:00 | AAPL | Stock | 26.4162 | 26.42 | 26.335 | 26.365 | 10660616.0 |
| 2015-12-31 13:30:00 | AAPL | Stock | 26.3678 | 26.395 | 26.3425 | 26.375 | 5445084.0 |
| 2015-12-31 14:00:00 | AAPL | Stock | 26.375 | 26.375 | 26.2225 | 26.251 | 14840032.0 |
| 2015-12-31 14:30:00 | AAPL | Stock | 26.2525 | 26.3475 | 26.205 | 26.305 | 9516000.0 |
| 2015-12-31 15:00:00 | AAPL | Stock | 26.305 | 26.345 | 26.25 | 26.3025 | 9594600.0 |
| 2015-12-31 15:30:00 | AAPL | Stock | 26.3025 | 26.385 | 26.2975 | 26.3075 | 17906372.0 |
| 2015-12-31 16:00:00 | AAPL | Stock | 26.3075 | 26.3725 | 26.2695 | 26.36 | 11430252.0 |
| 2015-12-31 16:30:00 | AAPL | Stock | 26.365 | 26.3675 | 26.34 | 26.35 | 85952.0 |
| 2015-12-31 17:00:00 | AAPL | Stock | 26.35 | 26.35 | 26.315 | 26.3375 | 233968.0 |
| 2015-12-31 17:30:00 | AAPL | Stock | 26.35 | 26.3675 | 26.3375 | 26.3675 | 22608.0 |
| 2015-12-31 18:00:00 | AAPL | Stock | 26.365 | 26.37 | 26.35 | 26.3675 | 21780.0 |
| 2015-12-31 18:30:00 | AAPL | Stock | 26.3525 | 26.3675 | 26.3525 | 26.355 | 4188.0 |
| 2015-12-31 19:00:00 | AAPL | Stock | 26.3575 | 26.3575 | 26.35 | 26.35 | 12424.0 |
| 2015-12-31 19:30:00 | AAPL | Stock | 26.3525 | 26.3775 | 26.34 | 26.365 | 31028.0 |
| 2015-12-31 08:00:00 | MSFT | Stock | 55.69 | 56.48 | 55.69 | 56.3 | 3650.0 |
| 2015-12-31 09:00:00 | MSFT | Stock | 56.2 | 56.2 | 56.04 | 56.05 | 11849.0 |
| 2015-12-31 09:30:00 | MSFT | Stock | 56.05 | 56.16 | 55.68 | 55.79 | 2572038.0 |
| 2015-12-31 10:00:00 | MSFT | Stock | 55.78 | 55.834 | 55.57 | 55.585 | 1731717.0 |
| 2015-12-31 10:30:00 | MSFT | Stock | 55.57 | 55.64 | 55.42 | 55.56 | 1584467.0 |
| 2015-12-31 11:00:00 | MSFT | Stock | 55.56 | 55.73 | 55.52 | 55.565 | 1687254.0 |
| 2015-12-31 11:30:00 | MSFT | Stock | 55.56 | 55.86 | 55.53 | 55.814 | 1898789.0 |
| 2015-12-31 12:00:00 | MSFT | Stock | 55.82 | 56.11 | 55.81 | 56.09 | 1434273.0 |
| 2015-12-31 12:30:00 | MSFT | Stock | 56.09 | 56.19 | 56.003 | 56.05 | 876098.0 |
| 2015-12-31 13:00:00 | MSFT | Stock | 56.04 | 56.08 | 55.85 | 55.864 | 833985.0 |
| 2015-12-31 13:30:00 | MSFT | Stock | 55.86 | 56.05 | 55.85 | 55.98 | 999510.0 |
| 2015-12-31 14:00:00 | MSFT | Stock | 55.98 | 56.0 | 55.68 | 55.714 | 1278888.0 |
| 2015-12-31 14:30:00 | MSFT | Stock | 55.72 | 55.76 | 55.575 | 55.67 | 1540041.0 |
| 2015-12-31 15:00:00 | MSFT | Stock | 55.67 | 55.72 | 55.52 | 55.64 | 1544162.0 |
| 2015-12-31 15:30:00 | MSFT | Stock | 55.64 | 55.84 | 55.45 | 55.45 | 3080980.0 |
| 2015-12-31 16:00:00 | MSFT | Stock | 55.48 | 55.64 | 55.4 | 55.52 | 3575631.0 |
| 2015-12-31 16:30:00 | MSFT | Stock | 55.55 | 55.65 | 55.52 | 55.53 | 28866.0 |
| 2015-12-31 17:00:00 | MSFT | Stock | 55.53 | 55.6 | 55.48 | 55.57 | 34392.0 |
| 2015-12-31 17:30:00 | MSFT | Stock | 55.59 | 55.59 | 55.53 | 55.53 | 1550.0 |
| 2015-12-31 18:00:00 | MSFT | Stock | 55.58 | 55.58 | 55.53 | 55.53 | 650.0 |
| 2015-12-31 18:30:00 | MSFT | Stock | 55.58 | 55.58 | 55.53 | 55.53 | 1200.0 |
| 2015-12-31 19:00:00 | MSFT | Stock | 55.58 | 55.58 | 55.5 | 55.5 | 300.0 |
> showing 50 of 82,931 rows — these rows as CSV