PREVIEW / stock_5min / 2018-05-16
file: by_date/stock_5min/2018/2018-05-16.parquet size: 5.6 MB rows: 362,448 symbols: 2,851
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-05-16 04:00:00 | AAPL | Stock | 46.54 | 46.54 | 46.54 | 46.54 | 3704.0 |
| 2018-05-16 04:40:00 | AAPL | Stock | 46.605 | 46.605 | 46.605 | 46.605 | 400.0 |
| 2018-05-16 06:30:00 | AAPL | Stock | 46.4875 | 46.4875 | 46.4875 | 46.4875 | 800.0 |
| 2018-05-16 07:00:00 | AAPL | Stock | 46.56 | 46.6075 | 46.56 | 46.6075 | 11920.0 |
| 2018-05-16 07:05:00 | AAPL | Stock | 46.5925 | 46.6075 | 46.585 | 46.6 | 7328.0 |
| 2018-05-16 07:10:00 | AAPL | Stock | 46.6 | 46.6 | 46.6 | 46.6 | 5848.0 |
| 2018-05-16 07:15:00 | AAPL | Stock | 46.61 | 46.61 | 46.6075 | 46.61 | 19840.0 |
| 2018-05-16 07:20:00 | AAPL | Stock | 46.625 | 46.625 | 46.625 | 46.625 | 5040.0 |
| 2018-05-16 07:30:00 | AAPL | Stock | 46.6 | 46.6 | 46.5925 | 46.5925 | 800.0 |
| 2018-05-16 07:35:00 | AAPL | Stock | 46.5775 | 46.5775 | 46.5375 | 46.575 | 11380.0 |
| 2018-05-16 07:40:00 | AAPL | Stock | 46.5275 | 46.5275 | 46.5275 | 46.5275 | 1272.0 |
| 2018-05-16 07:45:00 | AAPL | Stock | 46.57 | 46.57 | 46.57 | 46.57 | 2400.0 |
| 2018-05-16 08:00:00 | AAPL | Stock | 46.639 | 46.64 | 46.5252 | 46.5675 | 24312.0 |
| 2018-05-16 08:05:00 | AAPL | Stock | 46.5675 | 46.5675 | 46.55 | 46.55 | 1600.0 |
| 2018-05-16 08:10:00 | AAPL | Stock | 46.56 | 46.56 | 46.525 | 46.525 | 13692.0 |
| 2018-05-16 08:15:00 | AAPL | Stock | 46.525 | 46.5475 | 46.525 | 46.545 | 13504.0 |
| 2018-05-16 08:20:00 | AAPL | Stock | 46.56 | 46.5675 | 46.5525 | 46.5575 | 7200.0 |
| 2018-05-16 08:25:00 | AAPL | Stock | 46.575 | 46.5875 | 46.5675 | 46.575 | 26304.0 |
| 2018-05-16 08:30:00 | AAPL | Stock | 46.575 | 46.575 | 46.5625 | 46.575 | 3360.0 |
| 2018-05-16 08:35:00 | AAPL | Stock | 46.5625 | 46.5725 | 46.475 | 46.4775 | 79928.0 |
| 2018-05-16 08:40:00 | AAPL | Stock | 46.475 | 46.4875 | 46.4675 | 46.4825 | 7244.0 |
| 2018-05-16 08:45:00 | AAPL | Stock | 46.4875 | 46.4875 | 46.4375 | 46.4375 | 76840.0 |
| 2018-05-16 08:50:00 | AAPL | Stock | 46.455 | 46.46 | 46.4 | 46.4 | 25036.0 |
| 2018-05-16 08:55:00 | AAPL | Stock | 46.4275 | 46.435 | 46.375 | 46.435 | 41016.0 |
| 2018-05-16 09:00:00 | AAPL | Stock | 46.4225 | 46.4325 | 46.4025 | 46.43 | 16168.0 |
| 2018-05-16 09:05:00 | AAPL | Stock | 46.4325 | 46.475 | 46.4125 | 46.475 | 51216.0 |
| 2018-05-16 09:10:00 | AAPL | Stock | 46.4875 | 46.53 | 46.434 | 46.4375 | 58304.0 |
| 2018-05-16 09:15:00 | AAPL | Stock | 46.49 | 46.49 | 46.49 | 46.49 | 1200.0 |
| 2018-05-16 09:20:00 | AAPL | Stock | 46.4625 | 46.5625 | 46.46 | 46.5625 | 15904.0 |
| 2018-05-16 09:25:00 | AAPL | Stock | 46.5375 | 46.5425 | 46.495 | 46.525 | 11996.0 |
| 2018-05-16 09:30:00 | AAPL | Stock | 46.525 | 46.6125 | 46.5 | 46.5325 | 2193364.0 |
| 2018-05-16 09:35:00 | AAPL | Stock | 46.535 | 46.68 | 46.535 | 46.6763 | 1711256.0 |
| 2018-05-16 09:40:00 | AAPL | Stock | 46.68 | 46.6825 | 46.5025 | 46.5075 | 1824508.0 |
| 2018-05-16 09:45:00 | AAPL | Stock | 46.51 | 46.6425 | 46.5075 | 46.6225 | 1116624.0 |
| 2018-05-16 09:50:00 | AAPL | Stock | 46.63 | 46.6975 | 46.6075 | 46.67 | 1335448.0 |
| 2018-05-16 09:55:00 | AAPL | Stock | 46.675 | 46.7675 | 46.675 | 46.7522 | 1341576.0 |
| 2018-05-16 10:00:00 | AAPL | Stock | 46.75 | 46.805 | 46.7412 | 46.7615 | 1478656.0 |
| 2018-05-16 10:05:00 | AAPL | Stock | 46.7608 | 46.8425 | 46.755 | 46.79 | 1546452.0 |
| 2018-05-16 10:10:00 | AAPL | Stock | 46.79 | 46.83 | 46.714 | 46.825 | 1405200.0 |
| 2018-05-16 10:15:00 | AAPL | Stock | 46.825 | 46.8875 | 46.8 | 46.8825 | 1199572.0 |
| 2018-05-16 10:20:00 | AAPL | Stock | 46.8838 | 46.92 | 46.8228 | 46.8975 | 1181764.0 |
| 2018-05-16 10:25:00 | AAPL | Stock | 46.8925 | 46.9325 | 46.8775 | 46.91 | 931160.0 |
| 2018-05-16 10:30:00 | AAPL | Stock | 46.915 | 46.9775 | 46.915 | 46.9548 | 1306560.0 |
| 2018-05-16 10:35:00 | AAPL | Stock | 46.9582 | 46.9975 | 46.955 | 46.9848 | 1216940.0 |
| 2018-05-16 10:40:00 | AAPL | Stock | 46.985 | 47.0275 | 46.975 | 47.0175 | 1347156.0 |
| 2018-05-16 10:45:00 | AAPL | Stock | 47.015 | 47.0575 | 47.0 | 47.05 | 1101488.0 |
| 2018-05-16 10:50:00 | AAPL | Stock | 47.0525 | 47.0938 | 46.9925 | 47.0225 | 1469312.0 |
| 2018-05-16 10:55:00 | AAPL | Stock | 47.02 | 47.0275 | 46.945 | 46.965 | 1363240.0 |
| 2018-05-16 11:00:00 | AAPL | Stock | 46.965 | 46.965 | 46.9125 | 46.95 | 971932.0 |
| 2018-05-16 11:05:00 | AAPL | Stock | 46.95 | 46.9725 | 46.9125 | 46.9288 | 848532.0 |
> showing 50 of 362,448 rows — these rows as CSV