PREVIEW / stock_5min / 2017-12-12
file: by_date/stock_5min/2017/2017-12-12.parquet size: 5.7 MB rows: 367,101 symbols: 2,945
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 |
|---|---|---|---|---|---|---|---|
| 2017-12-12 04:35:00 | AAPL | Stock | 43.065 | 43.065 | 43.065 | 43.065 | 596.0 |
| 2017-12-12 04:55:00 | AAPL | Stock | 43.1125 | 43.1125 | 43.1125 | 43.1125 | 400.0 |
| 2017-12-12 05:05:00 | AAPL | Stock | 43.075 | 43.075 | 43.075 | 43.075 | 808.0 |
| 2017-12-12 05:10:00 | AAPL | Stock | 43.065 | 43.065 | 43.065 | 43.065 | 1088.0 |
| 2017-12-12 05:35:00 | AAPL | Stock | 43.0075 | 43.075 | 43.0075 | 43.075 | 1368.0 |
| 2017-12-12 05:55:00 | AAPL | Stock | 43.065 | 43.065 | 43.065 | 43.065 | 2000.0 |
| 2017-12-12 06:30:00 | AAPL | Stock | 43.08 | 43.08 | 43.08 | 43.08 | 424.0 |
| 2017-12-12 06:50:00 | AAPL | Stock | 43.0875 | 43.0875 | 43.08 | 43.08 | 4456.0 |
| 2017-12-12 07:00:00 | AAPL | Stock | 43.0975 | 43.0975 | 43.0975 | 43.0975 | 400.0 |
| 2017-12-12 07:05:00 | AAPL | Stock | 43.1125 | 43.1125 | 43.1125 | 43.1125 | 800.0 |
| 2017-12-12 07:10:00 | AAPL | Stock | 43.115 | 43.115 | 43.1 | 43.1 | 2012.0 |
| 2017-12-12 07:20:00 | AAPL | Stock | 43.1 | 43.1 | 43.1 | 43.1 | 948.0 |
| 2017-12-12 07:25:00 | AAPL | Stock | 43.12 | 43.1225 | 43.12 | 43.1225 | 4000.0 |
| 2017-12-12 07:30:00 | AAPL | Stock | 43.1225 | 43.125 | 43.1225 | 43.1225 | 7236.0 |
| 2017-12-12 07:40:00 | AAPL | Stock | 43.1275 | 43.15 | 43.125 | 43.15 | 14040.0 |
| 2017-12-12 07:45:00 | AAPL | Stock | 43.15 | 43.15 | 43.15 | 43.15 | 400.0 |
| 2017-12-12 07:50:00 | AAPL | Stock | 43.125 | 43.1375 | 43.125 | 43.1375 | 6840.0 |
| 2017-12-12 08:00:00 | AAPL | Stock | 43.1425 | 43.17 | 43.0975 | 43.1625 | 42216.0 |
| 2017-12-12 08:05:00 | AAPL | Stock | 43.17 | 43.17 | 43.17 | 43.17 | 7200.0 |
| 2017-12-12 08:10:00 | AAPL | Stock | 43.1625 | 43.17 | 43.1525 | 43.1675 | 4340.0 |
| 2017-12-12 08:15:00 | AAPL | Stock | 43.155 | 43.155 | 43.1325 | 43.1325 | 1200.0 |
| 2017-12-12 08:20:00 | AAPL | Stock | 43.155 | 43.155 | 43.1375 | 43.1375 | 2800.0 |
| 2017-12-12 08:25:00 | AAPL | Stock | 43.1375 | 43.1375 | 43.1225 | 43.125 | 15488.0 |
| 2017-12-12 08:30:00 | AAPL | Stock | 43.1 | 43.125 | 43.1 | 43.125 | 14452.0 |
| 2017-12-12 08:35:00 | AAPL | Stock | 43.1225 | 43.1225 | 43.1 | 43.1 | 14308.0 |
| 2017-12-12 08:40:00 | AAPL | Stock | 43.1 | 43.1 | 43.0925 | 43.0975 | 5144.0 |
| 2017-12-12 08:45:00 | AAPL | Stock | 43.0975 | 43.0975 | 43.0825 | 43.085 | 2400.0 |
| 2017-12-12 08:50:00 | AAPL | Stock | 43.085 | 43.1 | 43.075 | 43.075 | 28752.0 |
| 2017-12-12 08:55:00 | AAPL | Stock | 43.095 | 43.11 | 43.095 | 43.11 | 15128.0 |
| 2017-12-12 09:00:00 | AAPL | Stock | 43.0875 | 43.1 | 43.075 | 43.075 | 8584.0 |
| 2017-12-12 09:05:00 | AAPL | Stock | 43.065 | 43.0825 | 43.065 | 43.0775 | 22684.0 |
| 2017-12-12 09:10:00 | AAPL | Stock | 43.0775 | 43.0775 | 43.0275 | 43.05 | 48256.0 |
| 2017-12-12 09:15:00 | AAPL | Stock | 43.0475 | 43.065 | 43.0425 | 43.065 | 9484.0 |
| 2017-12-12 09:20:00 | AAPL | Stock | 43.05 | 43.0625 | 43.005 | 43.005 | 32312.0 |
| 2017-12-12 09:25:00 | AAPL | Stock | 43.025 | 43.04 | 43.015 | 43.025 | 24468.0 |
| 2017-12-12 09:30:00 | AAPL | Stock | 43.0375 | 43.085 | 42.9575 | 43.0062 | 4151116.0 |
| 2017-12-12 09:35:00 | AAPL | Stock | 43.01 | 43.0425 | 42.8653 | 42.975 | 2890152.0 |
| 2017-12-12 09:40:00 | AAPL | Stock | 42.9788 | 43.0975 | 42.9675 | 43.0475 | 2774672.0 |
| 2017-12-12 09:45:00 | AAPL | Stock | 43.05 | 43.0675 | 42.945 | 42.9725 | 1774112.0 |
| 2017-12-12 09:50:00 | AAPL | Stock | 42.9725 | 43.05 | 42.9725 | 43.025 | 1059120.0 |
| 2017-12-12 09:55:00 | AAPL | Stock | 43.0225 | 43.045 | 42.9675 | 42.9875 | 1233276.0 |
| 2017-12-12 10:00:00 | AAPL | Stock | 42.99 | 43.01 | 42.9625 | 42.9625 | 1108312.0 |
| 2017-12-12 10:05:00 | AAPL | Stock | 42.965 | 42.9862 | 42.9275 | 42.9775 | 1183540.0 |
| 2017-12-12 10:10:00 | AAPL | Stock | 42.9788 | 42.9875 | 42.9525 | 42.9562 | 932896.0 |
| 2017-12-12 10:15:00 | AAPL | Stock | 42.955 | 42.9875 | 42.9525 | 42.956 | 1128948.0 |
| 2017-12-12 10:20:00 | AAPL | Stock | 42.9575 | 42.99 | 42.9075 | 42.9665 | 876140.0 |
| 2017-12-12 10:25:00 | AAPL | Stock | 42.9625 | 42.9725 | 42.9275 | 42.9475 | 515256.0 |
| 2017-12-12 10:30:00 | AAPL | Stock | 42.95 | 42.96 | 42.9075 | 42.9348 | 597308.0 |
| 2017-12-12 10:35:00 | AAPL | Stock | 42.9325 | 42.9475 | 42.915 | 42.94 | 536780.0 |
| 2017-12-12 10:40:00 | AAPL | Stock | 42.9425 | 42.9462 | 42.9 | 42.905 | 565300.0 |
> showing 50 of 367,101 rows — these rows as CSV