PREVIEW / stock_5min / 2019-05-03
file: by_date/stock_5min/2019/2019-05-03.parquet size: 5.7 MB rows: 356,893 symbols: 2,609
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-03 04:00:00 | AAPL | Stock | 52.495 | 52.575 | 52.495 | 52.575 | 2400.0 |
| 2019-05-03 04:10:00 | AAPL | Stock | 52.5675 | 52.5675 | 52.5675 | 52.5675 | 400.0 |
| 2019-05-03 04:20:00 | AAPL | Stock | 52.575 | 52.575 | 52.575 | 52.575 | 420.0 |
| 2019-05-03 04:25:00 | AAPL | Stock | 52.595 | 52.595 | 52.5875 | 52.5875 | 2088.0 |
| 2019-05-03 04:30:00 | AAPL | Stock | 52.5525 | 52.5525 | 52.5525 | 52.5525 | 400.0 |
| 2019-05-03 04:40:00 | AAPL | Stock | 52.5475 | 52.5475 | 52.5475 | 52.5475 | 400.0 |
| 2019-05-03 05:00:00 | AAPL | Stock | 52.5375 | 52.575 | 52.5 | 52.5 | 22688.0 |
| 2019-05-03 05:45:00 | AAPL | Stock | 52.4875 | 52.4875 | 52.4875 | 52.4875 | 1172.0 |
| 2019-05-03 05:50:00 | AAPL | Stock | 52.4975 | 52.4975 | 52.4975 | 52.4975 | 400.0 |
| 2019-05-03 05:55:00 | AAPL | Stock | 52.4925 | 52.4925 | 52.4875 | 52.4875 | 1876.0 |
| 2019-05-03 06:05:00 | AAPL | Stock | 52.485 | 52.4875 | 52.485 | 52.4875 | 5892.0 |
| 2019-05-03 06:10:00 | AAPL | Stock | 52.4875 | 52.4875 | 52.4475 | 52.4475 | 2604.0 |
| 2019-05-03 06:20:00 | AAPL | Stock | 52.5 | 52.51 | 52.5 | 52.51 | 2128.0 |
| 2019-05-03 06:25:00 | AAPL | Stock | 52.51 | 52.51 | 52.51 | 52.51 | 2800.0 |
| 2019-05-03 06:30:00 | AAPL | Stock | 52.525 | 52.565 | 52.525 | 52.565 | 4880.0 |
| 2019-05-03 06:40:00 | AAPL | Stock | 52.555 | 52.555 | 52.555 | 52.555 | 1200.0 |
| 2019-05-03 06:45:00 | AAPL | Stock | 52.5725 | 52.6 | 52.5725 | 52.59 | 16380.0 |
| 2019-05-03 06:50:00 | AAPL | Stock | 52.59 | 52.59 | 52.59 | 52.59 | 3460.0 |
| 2019-05-03 06:55:00 | AAPL | Stock | 52.59 | 52.59 | 52.56 | 52.56 | 4588.0 |
| 2019-05-03 07:00:00 | AAPL | Stock | 52.525 | 52.6125 | 52.515 | 52.53 | 25664.0 |
| 2019-05-03 07:05:00 | AAPL | Stock | 52.53 | 52.53 | 52.5125 | 52.515 | 2400.0 |
| 2019-05-03 07:10:00 | AAPL | Stock | 52.5225 | 52.5225 | 52.5225 | 52.5225 | 800.0 |
| 2019-05-03 07:15:00 | AAPL | Stock | 52.53 | 52.5375 | 52.53 | 52.5375 | 2000.0 |
| 2019-05-03 07:20:00 | AAPL | Stock | 52.5375 | 52.5725 | 52.5375 | 52.5725 | 3700.0 |
| 2019-05-03 07:25:00 | AAPL | Stock | 52.555 | 52.555 | 52.53 | 52.53 | 32004.0 |
| 2019-05-03 07:30:00 | AAPL | Stock | 52.55 | 52.6125 | 52.55 | 52.605 | 24504.0 |
| 2019-05-03 07:35:00 | AAPL | Stock | 52.605 | 52.6125 | 52.5875 | 52.6 | 11496.0 |
| 2019-05-03 07:40:00 | AAPL | Stock | 52.6 | 52.6125 | 52.6 | 52.6125 | 7060.0 |
| 2019-05-03 07:45:00 | AAPL | Stock | 52.61 | 52.615 | 52.5875 | 52.5875 | 25604.0 |
| 2019-05-03 07:50:00 | AAPL | Stock | 52.58 | 52.5875 | 52.575 | 52.5875 | 5260.0 |
| 2019-05-03 07:55:00 | AAPL | Stock | 52.5875 | 52.6125 | 52.5875 | 52.6125 | 7500.0 |
| 2019-05-03 08:00:00 | AAPL | Stock | 52.61 | 52.635 | 52.5125 | 52.635 | 129260.0 |
| 2019-05-03 08:05:00 | AAPL | Stock | 52.625 | 52.625 | 52.5875 | 52.59 | 16240.0 |
| 2019-05-03 08:10:00 | AAPL | Stock | 52.5975 | 52.6225 | 52.57 | 52.5975 | 25740.0 |
| 2019-05-03 08:15:00 | AAPL | Stock | 52.6 | 52.625 | 52.585 | 52.61 | 38956.0 |
| 2019-05-03 08:20:00 | AAPL | Stock | 52.5875 | 52.6 | 52.57 | 52.575 | 8572.0 |
| 2019-05-03 08:25:00 | AAPL | Stock | 52.575 | 52.6125 | 52.575 | 52.5875 | 13420.0 |
| 2019-05-03 08:30:00 | AAPL | Stock | 52.5875 | 52.6525 | 52.4675 | 52.575 | 114412.0 |
| 2019-05-03 08:35:00 | AAPL | Stock | 52.5725 | 52.7475 | 52.5725 | 52.6375 | 95272.0 |
| 2019-05-03 08:40:00 | AAPL | Stock | 52.64 | 52.6875 | 52.625 | 52.66 | 70752.0 |
| 2019-05-03 08:45:00 | AAPL | Stock | 52.655 | 52.6875 | 52.6302 | 52.66 | 63468.0 |
| 2019-05-03 08:50:00 | AAPL | Stock | 52.6525 | 52.6875 | 52.63 | 52.6875 | 142076.0 |
| 2019-05-03 08:55:00 | AAPL | Stock | 52.6875 | 52.6975 | 52.67 | 52.695 | 76452.0 |
| 2019-05-03 09:00:00 | AAPL | Stock | 52.695 | 52.7 | 52.63 | 52.63 | 70932.0 |
| 2019-05-03 09:05:00 | AAPL | Stock | 52.6375 | 52.6425 | 52.6 | 52.6075 | 25088.0 |
| 2019-05-03 09:10:00 | AAPL | Stock | 52.635 | 52.6458 | 52.6 | 52.6125 | 43772.0 |
| 2019-05-03 09:15:00 | AAPL | Stock | 52.625 | 52.6425 | 52.6125 | 52.625 | 44448.0 |
| 2019-05-03 09:20:00 | AAPL | Stock | 52.6225 | 52.6375 | 52.5725 | 52.6375 | 50292.0 |
| 2019-05-03 09:25:00 | AAPL | Stock | 52.645 | 52.7275 | 52.6375 | 52.71 | 63668.0 |
| 2019-05-03 09:30:00 | AAPL | Stock | 52.69 | 52.865 | 52.58 | 52.615 | 5134856.0 |
> showing 50 of 356,893 rows — these rows as CSV