PREVIEW / stock_5min / 2016-01-28
file: by_date/stock_5min/2016/2016-01-28.parquet size: 5.4 MB rows: 360,703 symbols: 3,361
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-01-28 04:00:00 | AAPL | Stock | 23.5 | 23.6975 | 23.5 | 23.65 | 31420.0 |
| 2016-01-28 04:05:00 | AAPL | Stock | 23.65 | 23.65 | 23.625 | 23.65 | 18400.0 |
| 2016-01-28 04:10:00 | AAPL | Stock | 23.65 | 23.65 | 23.645 | 23.645 | 5064.0 |
| 2016-01-28 04:15:00 | AAPL | Stock | 23.645 | 23.645 | 23.645 | 23.645 | 2232.0 |
| 2016-01-28 04:30:00 | AAPL | Stock | 23.6025 | 23.65 | 23.6025 | 23.65 | 1420.0 |
| 2016-01-28 04:35:00 | AAPL | Stock | 23.65 | 23.65 | 23.65 | 23.65 | 3776.0 |
| 2016-01-28 04:40:00 | AAPL | Stock | 23.6475 | 23.65 | 23.6475 | 23.65 | 968.0 |
| 2016-01-28 04:45:00 | AAPL | Stock | 23.6375 | 23.65 | 23.625 | 23.65 | 11088.0 |
| 2016-01-28 04:50:00 | AAPL | Stock | 23.725 | 23.75 | 23.725 | 23.75 | 2940.0 |
| 2016-01-28 05:00:00 | AAPL | Stock | 23.7125 | 23.7125 | 23.6725 | 23.6775 | 2872.0 |
| 2016-01-28 05:05:00 | AAPL | Stock | 23.6725 | 23.6725 | 23.6725 | 23.6725 | 712.0 |
| 2016-01-28 05:10:00 | AAPL | Stock | 23.655 | 23.655 | 23.655 | 23.655 | 400.0 |
| 2016-01-28 05:15:00 | AAPL | Stock | 23.655 | 23.6625 | 23.655 | 23.6625 | 2400.0 |
| 2016-01-28 05:40:00 | AAPL | Stock | 23.6575 | 23.6575 | 23.65 | 23.65 | 1400.0 |
| 2016-01-28 05:50:00 | AAPL | Stock | 23.6275 | 23.6275 | 23.625 | 23.625 | 2400.0 |
| 2016-01-28 06:05:00 | AAPL | Stock | 23.575 | 23.575 | 23.5725 | 23.5725 | 5200.0 |
| 2016-01-28 06:20:00 | AAPL | Stock | 23.575 | 23.575 | 23.575 | 23.575 | 400.0 |
| 2016-01-28 06:25:00 | AAPL | Stock | 23.5725 | 23.625 | 23.5725 | 23.6225 | 29788.0 |
| 2016-01-28 06:30:00 | AAPL | Stock | 23.6225 | 23.6375 | 23.615 | 23.635 | 10600.0 |
| 2016-01-28 06:35:00 | AAPL | Stock | 23.615 | 23.6225 | 23.6125 | 23.6225 | 7840.0 |
| 2016-01-28 06:40:00 | AAPL | Stock | 23.6125 | 23.6125 | 23.5725 | 23.5725 | 5856.0 |
| 2016-01-28 06:45:00 | AAPL | Stock | 23.57 | 23.57 | 23.5275 | 23.5275 | 11120.0 |
| 2016-01-28 06:50:00 | AAPL | Stock | 23.565 | 23.585 | 23.565 | 23.585 | 5712.0 |
| 2016-01-28 06:55:00 | AAPL | Stock | 23.62 | 23.62 | 23.5375 | 23.5375 | 7600.0 |
| 2016-01-28 07:00:00 | AAPL | Stock | 23.535 | 23.535 | 23.5 | 23.5025 | 28780.0 |
| 2016-01-28 07:05:00 | AAPL | Stock | 23.4775 | 23.505 | 23.4775 | 23.495 | 26800.0 |
| 2016-01-28 07:10:00 | AAPL | Stock | 23.4975 | 23.5 | 23.475 | 23.5 | 17508.0 |
| 2016-01-28 07:15:00 | AAPL | Stock | 23.505 | 23.5125 | 23.5 | 23.5 | 21068.0 |
| 2016-01-28 07:20:00 | AAPL | Stock | 23.51 | 23.5375 | 23.5 | 23.5375 | 3200.0 |
| 2016-01-28 07:25:00 | AAPL | Stock | 23.525 | 23.5375 | 23.5 | 23.5375 | 5400.0 |
| 2016-01-28 07:30:00 | AAPL | Stock | 23.5175 | 23.5175 | 23.4775 | 23.4925 | 42572.0 |
| 2016-01-28 07:35:00 | AAPL | Stock | 23.475 | 23.475 | 23.4375 | 23.4375 | 22232.0 |
| 2016-01-28 07:40:00 | AAPL | Stock | 23.4375 | 23.45 | 23.425 | 23.45 | 8600.0 |
| 2016-01-28 07:45:00 | AAPL | Stock | 23.4625 | 23.4625 | 23.43 | 23.43 | 1520.0 |
| 2016-01-28 07:50:00 | AAPL | Stock | 23.4375 | 23.45 | 23.4375 | 23.45 | 24000.0 |
| 2016-01-28 07:55:00 | AAPL | Stock | 23.46 | 23.475 | 23.46 | 23.475 | 4800.0 |
| 2016-01-28 08:00:00 | AAPL | Stock | 23.4925 | 23.5625 | 23.44 | 23.4875 | 148672.0 |
| 2016-01-28 08:05:00 | AAPL | Stock | 23.485 | 23.4875 | 23.435 | 23.435 | 56348.0 |
| 2016-01-28 08:10:00 | AAPL | Stock | 23.435 | 23.445 | 23.4075 | 23.425 | 76636.0 |
| 2016-01-28 08:15:00 | AAPL | Stock | 23.445 | 23.465 | 23.43 | 23.45 | 34292.0 |
| 2016-01-28 08:20:00 | AAPL | Stock | 23.44 | 23.485 | 23.44 | 23.485 | 35608.0 |
| 2016-01-28 08:25:00 | AAPL | Stock | 23.49 | 23.495 | 23.4725 | 23.475 | 41140.0 |
| 2016-01-28 08:30:00 | AAPL | Stock | 23.465 | 23.49 | 23.425 | 23.4325 | 117972.0 |
| 2016-01-28 08:35:00 | AAPL | Stock | 23.43 | 23.44 | 23.375 | 23.38 | 57780.0 |
| 2016-01-28 08:40:00 | AAPL | Stock | 23.385 | 23.3975 | 23.385 | 23.3875 | 44392.0 |
| 2016-01-28 08:45:00 | AAPL | Stock | 23.41 | 23.4525 | 23.4025 | 23.4525 | 46948.0 |
| 2016-01-28 08:50:00 | AAPL | Stock | 23.435 | 23.475 | 23.435 | 23.475 | 58184.0 |
| 2016-01-28 08:55:00 | AAPL | Stock | 23.475 | 23.485 | 23.44 | 23.47 | 110800.0 |
| 2016-01-28 09:00:00 | AAPL | Stock | 23.4725 | 23.4875 | 23.45 | 23.4525 | 93104.0 |
| 2016-01-28 09:05:00 | AAPL | Stock | 23.4525 | 23.5225 | 23.4525 | 23.5225 | 177444.0 |
> showing 50 of 360,703 rows — these rows as CSV