PREVIEW / stock_5min / 2016-03-21
file: by_date/stock_5min/2016/2016-03-21.parquet size: 5.4 MB rows: 358,467 symbols: 3,348
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 |
|---|---|---|---|---|---|---|---|
| 2016-03-21 04:30:00 | AAPL | Stock | 26.455 | 26.455 | 26.4425 | 26.4425 | 1376.0 |
| 2016-03-21 04:45:00 | AAPL | Stock | 26.455 | 26.455 | 26.45 | 26.45 | 896.0 |
| 2016-03-21 04:55:00 | AAPL | Stock | 26.47 | 26.47 | 26.47 | 26.47 | 552.0 |
| 2016-03-21 05:25:00 | AAPL | Stock | 26.475 | 26.475 | 26.475 | 26.475 | 800.0 |
| 2016-03-21 05:45:00 | AAPL | Stock | 26.525 | 26.525 | 26.5225 | 26.5225 | 1200.0 |
| 2016-03-21 06:00:00 | AAPL | Stock | 26.5225 | 26.53 | 26.5225 | 26.53 | 3620.0 |
| 2016-03-21 06:05:00 | AAPL | Stock | 26.5375 | 26.5375 | 26.5375 | 26.5375 | 400.0 |
| 2016-03-21 06:10:00 | AAPL | Stock | 26.55 | 26.5575 | 26.55 | 26.5525 | 2444.0 |
| 2016-03-21 06:15:00 | AAPL | Stock | 26.55 | 26.57 | 26.55 | 26.55 | 6880.0 |
| 2016-03-21 06:20:00 | AAPL | Stock | 26.55 | 26.55 | 26.55 | 26.55 | 400.0 |
| 2016-03-21 06:30:00 | AAPL | Stock | 26.5425 | 26.5425 | 26.5425 | 26.5425 | 800.0 |
| 2016-03-21 06:35:00 | AAPL | Stock | 26.5425 | 26.5425 | 26.5425 | 26.5425 | 2240.0 |
| 2016-03-21 06:40:00 | AAPL | Stock | 26.5425 | 26.5425 | 26.5425 | 26.5425 | 960.0 |
| 2016-03-21 06:50:00 | AAPL | Stock | 26.55 | 26.55 | 26.55 | 26.55 | 400.0 |
| 2016-03-21 06:55:00 | AAPL | Stock | 26.5425 | 26.5425 | 26.525 | 26.525 | 2000.0 |
| 2016-03-21 07:15:00 | AAPL | Stock | 26.5125 | 26.5125 | 26.475 | 26.475 | 25652.0 |
| 2016-03-21 07:20:00 | AAPL | Stock | 26.4525 | 26.4525 | 26.4525 | 26.4525 | 920.0 |
| 2016-03-21 07:25:00 | AAPL | Stock | 26.4525 | 26.4525 | 26.4525 | 26.4525 | 1200.0 |
| 2016-03-21 07:40:00 | AAPL | Stock | 26.4875 | 26.49 | 26.4875 | 26.49 | 1592.0 |
| 2016-03-21 07:45:00 | AAPL | Stock | 26.4875 | 26.5 | 26.4875 | 26.5 | 1164.0 |
| 2016-03-21 07:50:00 | AAPL | Stock | 26.5 | 26.5375 | 26.5 | 26.5375 | 7400.0 |
| 2016-03-21 07:55:00 | AAPL | Stock | 26.5375 | 26.5375 | 26.525 | 26.525 | 3600.0 |
| 2016-03-21 08:00:00 | AAPL | Stock | 26.535 | 26.575 | 26.49 | 26.5125 | 42168.0 |
| 2016-03-21 08:05:00 | AAPL | Stock | 26.515 | 26.5325 | 26.5125 | 26.525 | 37620.0 |
| 2016-03-21 08:10:00 | AAPL | Stock | 26.525 | 26.525 | 26.5175 | 26.52 | 7360.0 |
| 2016-03-21 08:15:00 | AAPL | Stock | 26.525 | 26.525 | 26.505 | 26.5075 | 19456.0 |
| 2016-03-21 08:20:00 | AAPL | Stock | 26.505 | 26.505 | 26.4775 | 26.4775 | 38340.0 |
| 2016-03-21 08:25:00 | AAPL | Stock | 26.495 | 26.495 | 26.4825 | 26.4925 | 16000.0 |
| 2016-03-21 08:30:00 | AAPL | Stock | 26.4875 | 26.5 | 26.465 | 26.4875 | 20852.0 |
| 2016-03-21 08:35:00 | AAPL | Stock | 26.48 | 26.48 | 26.4775 | 26.4775 | 5604.0 |
| 2016-03-21 08:40:00 | AAPL | Stock | 26.4775 | 26.48 | 26.475 | 26.4775 | 11500.0 |
| 2016-03-21 08:45:00 | AAPL | Stock | 26.4825 | 26.4925 | 26.4775 | 26.4875 | 16000.0 |
| 2016-03-21 08:50:00 | AAPL | Stock | 26.49 | 26.5 | 26.485 | 26.4925 | 16600.0 |
| 2016-03-21 08:55:00 | AAPL | Stock | 26.4925 | 26.4925 | 26.4925 | 26.4925 | 1356.0 |
| 2016-03-21 09:00:00 | AAPL | Stock | 26.5 | 26.505 | 26.5 | 26.505 | 5480.0 |
| 2016-03-21 09:05:00 | AAPL | Stock | 26.5025 | 26.5025 | 26.495 | 26.495 | 22008.0 |
| 2016-03-21 09:10:00 | AAPL | Stock | 26.4875 | 26.5 | 26.48 | 26.5 | 7820.0 |
| 2016-03-21 09:15:00 | AAPL | Stock | 26.5 | 26.5125 | 26.4875 | 26.5 | 6440.0 |
| 2016-03-21 09:20:00 | AAPL | Stock | 26.5 | 26.51 | 26.5 | 26.5 | 13000.0 |
| 2016-03-21 09:25:00 | AAPL | Stock | 26.505 | 26.53 | 26.4575 | 26.46 | 56156.0 |
| 2016-03-21 09:30:00 | AAPL | Stock | 26.46 | 26.685 | 26.46 | 26.64 | 5217256.0 |
| 2016-03-21 09:35:00 | AAPL | Stock | 26.6375 | 26.7075 | 26.625 | 26.675 | 2670264.0 |
| 2016-03-21 09:40:00 | AAPL | Stock | 26.6725 | 26.73 | 26.66 | 26.73 | 2435480.0 |
| 2016-03-21 09:45:00 | AAPL | Stock | 26.729 | 26.73 | 26.675 | 26.7 | 2474208.0 |
| 2016-03-21 09:50:00 | AAPL | Stock | 26.701 | 26.72 | 26.6725 | 26.7025 | 1726536.0 |
| 2016-03-21 09:55:00 | AAPL | Stock | 26.7025 | 26.7125 | 26.695 | 26.6975 | 916248.0 |
| 2016-03-21 10:00:00 | AAPL | Stock | 26.6995 | 26.9125 | 26.69 | 26.697 | 1887080.0 |
| 2016-03-21 10:05:00 | AAPL | Stock | 26.695 | 26.6952 | 26.6435 | 26.67 | 1515668.0 |
| 2016-03-21 10:10:00 | AAPL | Stock | 26.6712 | 26.6925 | 26.6275 | 26.6775 | 1603972.0 |
| 2016-03-21 10:15:00 | AAPL | Stock | 26.68 | 26.7075 | 26.6575 | 26.6985 | 1219144.0 |
> showing 50 of 358,467 rows — these rows as CSV