PREVIEW / stock_5min / 2018-02-13
file: by_date/stock_5min/2018/2018-02-13.parquet size: 5.5 MB rows: 357,821 symbols: 2,882
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-13 04:00:00 | AAPL | Stock | 40.6625 | 40.6625 | 40.525 | 40.575 | 5260.0 |
| 2018-02-13 04:05:00 | AAPL | Stock | 40.6225 | 40.6625 | 40.6225 | 40.625 | 8912.0 |
| 2018-02-13 04:30:00 | AAPL | Stock | 40.5775 | 40.5775 | 40.5775 | 40.5775 | 400.0 |
| 2018-02-13 04:40:00 | AAPL | Stock | 40.5225 | 40.5225 | 40.5225 | 40.5225 | 400.0 |
| 2018-02-13 04:45:00 | AAPL | Stock | 40.5025 | 40.5025 | 40.5 | 40.5 | 7668.0 |
| 2018-02-13 04:50:00 | AAPL | Stock | 40.495 | 40.495 | 40.495 | 40.495 | 440.0 |
| 2018-02-13 04:55:00 | AAPL | Stock | 40.51 | 40.51 | 40.51 | 40.51 | 800.0 |
| 2018-02-13 05:00:00 | AAPL | Stock | 40.5625 | 40.5625 | 40.5625 | 40.5625 | 800.0 |
| 2018-02-13 05:05:00 | AAPL | Stock | 40.5 | 40.5 | 40.5 | 40.5 | 400.0 |
| 2018-02-13 05:10:00 | AAPL | Stock | 40.475 | 40.475 | 40.475 | 40.475 | 688.0 |
| 2018-02-13 05:30:00 | AAPL | Stock | 40.5475 | 40.5475 | 40.48 | 40.48 | 8292.0 |
| 2018-02-13 05:35:00 | AAPL | Stock | 40.48 | 40.5375 | 40.48 | 40.5375 | 3200.0 |
| 2018-02-13 05:45:00 | AAPL | Stock | 40.535 | 40.5375 | 40.535 | 40.5375 | 800.0 |
| 2018-02-13 06:00:00 | AAPL | Stock | 40.5075 | 40.5075 | 40.49 | 40.5 | 2708.0 |
| 2018-02-13 06:05:00 | AAPL | Stock | 40.4875 | 40.4875 | 40.4675 | 40.4675 | 7108.0 |
| 2018-02-13 06:10:00 | AAPL | Stock | 40.465 | 40.465 | 40.45 | 40.45 | 6232.0 |
| 2018-02-13 06:15:00 | AAPL | Stock | 40.4375 | 40.4375 | 40.425 | 40.425 | 1200.0 |
| 2018-02-13 06:20:00 | AAPL | Stock | 40.425 | 40.425 | 40.425 | 40.425 | 7944.0 |
| 2018-02-13 06:30:00 | AAPL | Stock | 40.425 | 40.425 | 40.425 | 40.425 | 1600.0 |
| 2018-02-13 06:35:00 | AAPL | Stock | 40.445 | 40.445 | 40.445 | 40.445 | 400.0 |
| 2018-02-13 06:45:00 | AAPL | Stock | 40.45 | 40.4625 | 40.45 | 40.4625 | 1600.0 |
| 2018-02-13 06:55:00 | AAPL | Stock | 40.46 | 40.5 | 40.46 | 40.5 | 8624.0 |
| 2018-02-13 07:00:00 | AAPL | Stock | 40.525 | 40.525 | 40.425 | 40.425 | 55404.0 |
| 2018-02-13 07:05:00 | AAPL | Stock | 40.445 | 40.445 | 40.4125 | 40.425 | 10044.0 |
| 2018-02-13 07:10:00 | AAPL | Stock | 40.415 | 40.4275 | 40.4125 | 40.4175 | 6120.0 |
| 2018-02-13 07:15:00 | AAPL | Stock | 40.4525 | 40.4675 | 40.4275 | 40.465 | 9348.0 |
| 2018-02-13 07:20:00 | AAPL | Stock | 40.4625 | 40.5 | 40.4625 | 40.4625 | 6000.0 |
| 2018-02-13 07:25:00 | AAPL | Stock | 40.4975 | 40.5275 | 40.4925 | 40.5275 | 11184.0 |
| 2018-02-13 07:30:00 | AAPL | Stock | 40.5075 | 40.5075 | 40.475 | 40.4875 | 21656.0 |
| 2018-02-13 07:35:00 | AAPL | Stock | 40.465 | 40.465 | 40.4175 | 40.43 | 23896.0 |
| 2018-02-13 07:40:00 | AAPL | Stock | 40.435 | 40.55 | 40.435 | 40.55 | 37812.0 |
| 2018-02-13 07:45:00 | AAPL | Stock | 40.55 | 40.565 | 40.535 | 40.565 | 57008.0 |
| 2018-02-13 07:50:00 | AAPL | Stock | 40.5475 | 40.5625 | 40.5375 | 40.55 | 15220.0 |
| 2018-02-13 07:55:00 | AAPL | Stock | 40.5475 | 40.55 | 40.535 | 40.55 | 4400.0 |
| 2018-02-13 08:00:00 | AAPL | Stock | 40.45 | 40.575 | 40.4125 | 40.5175 | 110380.0 |
| 2018-02-13 08:05:00 | AAPL | Stock | 40.515 | 40.575 | 40.515 | 40.575 | 25420.0 |
| 2018-02-13 08:10:00 | AAPL | Stock | 40.5625 | 40.5625 | 40.5075 | 40.5075 | 6884.0 |
| 2018-02-13 08:15:00 | AAPL | Stock | 40.535 | 40.57 | 40.53 | 40.57 | 25440.0 |
| 2018-02-13 08:20:00 | AAPL | Stock | 40.55 | 40.5625 | 40.5275 | 40.5625 | 24576.0 |
| 2018-02-13 08:25:00 | AAPL | Stock | 40.56 | 40.56 | 40.525 | 40.525 | 8260.0 |
| 2018-02-13 08:30:00 | AAPL | Stock | 40.525 | 40.54 | 40.4775 | 40.51 | 57940.0 |
| 2018-02-13 08:35:00 | AAPL | Stock | 40.53 | 40.55 | 40.53 | 40.55 | 18616.0 |
| 2018-02-13 08:40:00 | AAPL | Stock | 40.55 | 40.58 | 40.5375 | 40.5375 | 16852.0 |
| 2018-02-13 08:45:00 | AAPL | Stock | 40.5375 | 40.5375 | 40.5175 | 40.52 | 4128.0 |
| 2018-02-13 08:50:00 | AAPL | Stock | 40.52 | 40.525 | 40.435 | 40.4475 | 49300.0 |
| 2018-02-13 08:55:00 | AAPL | Stock | 40.44 | 40.445 | 40.4125 | 40.4175 | 52688.0 |
| 2018-02-13 09:00:00 | AAPL | Stock | 40.4225 | 40.4575 | 40.3575 | 40.3875 | 155740.0 |
| 2018-02-13 09:05:00 | AAPL | Stock | 40.3875 | 40.4475 | 40.3875 | 40.4475 | 30844.0 |
| 2018-02-13 09:10:00 | AAPL | Stock | 40.4125 | 40.45 | 40.4 | 40.4375 | 62972.0 |
| 2018-02-13 09:15:00 | AAPL | Stock | 40.435 | 40.4425 | 40.425 | 40.425 | 45860.0 |
> showing 50 of 357,821 rows — these rows as CSV