PREVIEW / stock_5min / 2019-02-28
file: by_date/stock_5min/2019/2019-02-28.parquet size: 5.7 MB rows: 360,147 symbols: 2,666
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-02-28 04:00:00 | AAPL | Stock | 43.5625 | 43.5625 | 43.43 | 43.4575 | 5980.0 |
| 2019-02-28 04:30:00 | AAPL | Stock | 43.5225 | 43.5225 | 43.52 | 43.52 | 800.0 |
| 2019-02-28 04:45:00 | AAPL | Stock | 43.5025 | 43.5025 | 43.5025 | 43.5025 | 668.0 |
| 2019-02-28 05:25:00 | AAPL | Stock | 43.5075 | 43.5075 | 43.5 | 43.5 | 1900.0 |
| 2019-02-28 06:15:00 | AAPL | Stock | 43.5575 | 43.5575 | 43.5575 | 43.5575 | 852.0 |
| 2019-02-28 06:20:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 1604.0 |
| 2019-02-28 06:25:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 1600.0 |
| 2019-02-28 06:30:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 4000.0 |
| 2019-02-28 06:35:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 6732.0 |
| 2019-02-28 06:45:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5875 | 43.5875 | 400.0 |
| 2019-02-28 06:50:00 | AAPL | Stock | 43.565 | 43.565 | 43.565 | 43.565 | 1172.0 |
| 2019-02-28 06:55:00 | AAPL | Stock | 43.565 | 43.565 | 43.565 | 43.565 | 1592.0 |
| 2019-02-28 07:00:00 | AAPL | Stock | 43.62 | 43.62 | 43.5875 | 43.6 | 4932.0 |
| 2019-02-28 07:05:00 | AAPL | Stock | 43.5775 | 43.5775 | 43.575 | 43.575 | 3792.0 |
| 2019-02-28 07:10:00 | AAPL | Stock | 43.565 | 43.565 | 43.5625 | 43.5625 | 1308.0 |
| 2019-02-28 07:20:00 | AAPL | Stock | 43.5975 | 43.5975 | 43.5775 | 43.5775 | 3268.0 |
| 2019-02-28 07:25:00 | AAPL | Stock | 43.5825 | 43.5825 | 43.5825 | 43.5825 | 1836.0 |
| 2019-02-28 07:30:00 | AAPL | Stock | 43.5875 | 43.5875 | 43.5775 | 43.5775 | 5668.0 |
| 2019-02-28 07:35:00 | AAPL | Stock | 43.5825 | 43.6375 | 43.575 | 43.6375 | 9608.0 |
| 2019-02-28 07:40:00 | AAPL | Stock | 43.635 | 43.635 | 43.635 | 43.635 | 400.0 |
| 2019-02-28 07:45:00 | AAPL | Stock | 43.61 | 43.61 | 43.6075 | 43.6075 | 896.0 |
| 2019-02-28 07:50:00 | AAPL | Stock | 43.6325 | 43.6375 | 43.6325 | 43.6375 | 7928.0 |
| 2019-02-28 07:55:00 | AAPL | Stock | 43.65 | 43.6525 | 43.65 | 43.6525 | 1552.0 |
| 2019-02-28 08:00:00 | AAPL | Stock | 43.6125 | 43.6625 | 43.595 | 43.6625 | 25272.0 |
| 2019-02-28 08:05:00 | AAPL | Stock | 43.6625 | 43.6625 | 43.6625 | 43.6625 | 2000.0 |
| 2019-02-28 08:10:00 | AAPL | Stock | 43.625 | 43.63 | 43.6125 | 43.6125 | 12968.0 |
| 2019-02-28 08:15:00 | AAPL | Stock | 43.6125 | 43.6225 | 43.6125 | 43.6175 | 2704.0 |
| 2019-02-28 08:20:00 | AAPL | Stock | 43.615 | 43.615 | 43.5875 | 43.5875 | 8236.0 |
| 2019-02-28 08:25:00 | AAPL | Stock | 43.575 | 43.6 | 43.575 | 43.6 | 2400.0 |
| 2019-02-28 08:30:00 | AAPL | Stock | 43.6325 | 43.6825 | 43.6275 | 43.6475 | 17300.0 |
| 2019-02-28 08:35:00 | AAPL | Stock | 43.6475 | 43.6825 | 43.6375 | 43.6825 | 20300.0 |
| 2019-02-28 08:40:00 | AAPL | Stock | 43.6775 | 43.6875 | 43.66 | 43.66 | 14600.0 |
| 2019-02-28 08:45:00 | AAPL | Stock | 43.66 | 43.66 | 43.625 | 43.625 | 4400.0 |
| 2019-02-28 08:50:00 | AAPL | Stock | 43.625 | 43.645 | 43.605 | 43.645 | 2000.0 |
| 2019-02-28 08:55:00 | AAPL | Stock | 43.6325 | 43.645 | 43.6 | 43.6125 | 11188.0 |
| 2019-02-28 09:00:00 | AAPL | Stock | 43.62 | 43.6275 | 43.62 | 43.6275 | 1600.0 |
| 2019-02-28 09:05:00 | AAPL | Stock | 43.6 | 43.6375 | 43.6 | 43.6065 | 7252.0 |
| 2019-02-28 09:10:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.6 | 43.6375 | 12512.0 |
| 2019-02-28 09:15:00 | AAPL | Stock | 43.6325 | 43.6325 | 43.6325 | 43.6325 | 4400.0 |
| 2019-02-28 09:20:00 | AAPL | Stock | 43.6325 | 43.6325 | 43.6325 | 43.6325 | 400.0 |
| 2019-02-28 09:25:00 | AAPL | Stock | 43.6375 | 43.6375 | 43.575 | 43.585 | 12792.0 |
| 2019-02-28 09:30:00 | AAPL | Stock | 43.58 | 43.6875 | 43.4875 | 43.565 | 3081712.0 |
| 2019-02-28 09:35:00 | AAPL | Stock | 43.5575 | 43.6125 | 43.4972 | 43.5925 | 1813328.0 |
| 2019-02-28 09:40:00 | AAPL | Stock | 43.5975 | 43.6125 | 43.54 | 43.5825 | 1177448.0 |
| 2019-02-28 09:45:00 | AAPL | Stock | 43.5825 | 43.6675 | 43.575 | 43.66 | 1533168.0 |
| 2019-02-28 09:50:00 | AAPL | Stock | 43.66 | 43.7275 | 43.65 | 43.6675 | 1411720.0 |
| 2019-02-28 09:55:00 | AAPL | Stock | 43.6725 | 43.6838 | 43.57 | 43.5725 | 886616.0 |
| 2019-02-28 10:00:00 | AAPL | Stock | 43.5712 | 43.5712 | 43.505 | 43.5132 | 1402052.0 |
| 2019-02-28 10:05:00 | AAPL | Stock | 43.5132 | 43.536 | 43.44 | 43.446 | 1631436.0 |
| 2019-02-28 10:10:00 | AAPL | Stock | 43.4475 | 43.51 | 43.44 | 43.4862 | 1378164.0 |
> showing 50 of 360,147 rows — these rows as CSV