PREVIEW / stock_5min / 2019-04-15
file: by_date/stock_5min/2019/2019-04-15.parquet size: 5.5 MB rows: 349,322 symbols: 2,631
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-04-15 04:05:00 | AAPL | Stock | 49.695 | 49.695 | 49.695 | 49.695 | 400.0 |
| 2019-04-15 04:15:00 | AAPL | Stock | 49.7 | 49.7 | 49.7 | 49.7 | 400.0 |
| 2019-04-15 04:30:00 | AAPL | Stock | 49.61 | 49.6225 | 49.61 | 49.6225 | 1264.0 |
| 2019-04-15 04:55:00 | AAPL | Stock | 49.68 | 49.68 | 49.68 | 49.68 | 444.0 |
| 2019-04-15 07:00:00 | AAPL | Stock | 49.68 | 49.7325 | 49.68 | 49.73 | 3576.0 |
| 2019-04-15 07:05:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.6725 | 49.6725 | 1500.0 |
| 2019-04-15 07:10:00 | AAPL | Stock | 49.68 | 49.6875 | 49.67 | 49.6875 | 6052.0 |
| 2019-04-15 07:15:00 | AAPL | Stock | 49.6875 | 49.6875 | 49.6875 | 49.6875 | 1600.0 |
| 2019-04-15 07:20:00 | AAPL | Stock | 49.6675 | 49.6725 | 49.6675 | 49.6725 | 800.0 |
| 2019-04-15 07:25:00 | AAPL | Stock | 49.6625 | 49.6875 | 49.6625 | 49.6875 | 6340.0 |
| 2019-04-15 07:40:00 | AAPL | Stock | 49.665 | 49.665 | 49.5775 | 49.6325 | 21172.0 |
| 2019-04-15 07:45:00 | AAPL | Stock | 49.625 | 49.625 | 49.5725 | 49.5725 | 7212.0 |
| 2019-04-15 07:50:00 | AAPL | Stock | 49.6125 | 49.6225 | 49.6125 | 49.62 | 3240.0 |
| 2019-04-15 07:55:00 | AAPL | Stock | 49.6225 | 49.625 | 49.575 | 49.575 | 3776.0 |
| 2019-04-15 08:00:00 | AAPL | Stock | 49.7295 | 49.8425 | 49.57 | 49.595 | 37532.0 |
| 2019-04-15 08:05:00 | AAPL | Stock | 49.57 | 49.5875 | 49.5375 | 49.5525 | 5616.0 |
| 2019-04-15 08:10:00 | AAPL | Stock | 49.5525 | 49.6 | 49.5525 | 49.6 | 9168.0 |
| 2019-04-15 08:15:00 | AAPL | Stock | 49.6 | 49.6725 | 49.6 | 49.6475 | 23648.0 |
| 2019-04-15 08:20:00 | AAPL | Stock | 49.665 | 49.6875 | 49.66 | 49.6825 | 7400.0 |
| 2019-04-15 08:25:00 | AAPL | Stock | 49.6825 | 49.6875 | 49.6575 | 49.6575 | 3400.0 |
| 2019-04-15 08:30:00 | AAPL | Stock | 49.685 | 49.685 | 49.6625 | 49.6625 | 7044.0 |
| 2019-04-15 08:35:00 | AAPL | Stock | 49.665 | 49.665 | 49.6475 | 49.6475 | 2000.0 |
| 2019-04-15 08:40:00 | AAPL | Stock | 49.65 | 49.6675 | 49.6475 | 49.6675 | 3292.0 |
| 2019-04-15 08:45:00 | AAPL | Stock | 49.6375 | 49.6375 | 49.6375 | 49.6375 | 400.0 |
| 2019-04-15 08:50:00 | AAPL | Stock | 49.6625 | 49.6625 | 49.6375 | 49.6375 | 6000.0 |
| 2019-04-15 08:55:00 | AAPL | Stock | 49.6375 | 49.655 | 49.635 | 49.655 | 7804.0 |
| 2019-04-15 09:00:00 | AAPL | Stock | 49.65 | 49.6725 | 49.6375 | 49.6675 | 7496.0 |
| 2019-04-15 09:05:00 | AAPL | Stock | 49.665 | 49.67 | 49.65 | 49.6525 | 7000.0 |
| 2019-04-15 09:10:00 | AAPL | Stock | 49.6525 | 49.6525 | 49.6375 | 49.65 | 3004.0 |
| 2019-04-15 09:15:00 | AAPL | Stock | 49.6375 | 49.6775 | 49.6375 | 49.655 | 6780.0 |
| 2019-04-15 09:20:00 | AAPL | Stock | 49.645 | 49.6775 | 49.645 | 49.6775 | 8276.0 |
| 2019-04-15 09:25:00 | AAPL | Stock | 49.6775 | 49.6775 | 49.6 | 49.6475 | 36720.0 |
| 2019-04-15 09:30:00 | AAPL | Stock | 49.645 | 49.9625 | 49.6275 | 49.925 | 4142472.0 |
| 2019-04-15 09:35:00 | AAPL | Stock | 49.9175 | 49.9525 | 49.765 | 49.8975 | 2145580.0 |
| 2019-04-15 09:40:00 | AAPL | Stock | 49.9 | 49.925 | 49.83 | 49.8325 | 1162960.0 |
| 2019-04-15 09:45:00 | AAPL | Stock | 49.8375 | 49.8575 | 49.7175 | 49.7225 | 1323996.0 |
| 2019-04-15 09:50:00 | AAPL | Stock | 49.725 | 49.7925 | 49.7175 | 49.7675 | 1090624.0 |
| 2019-04-15 09:55:00 | AAPL | Stock | 49.7675 | 49.8375 | 49.7375 | 49.76 | 1110192.0 |
| 2019-04-15 10:00:00 | AAPL | Stock | 49.76 | 49.765 | 49.69 | 49.755 | 1086676.0 |
| 2019-04-15 10:05:00 | AAPL | Stock | 49.755 | 49.7825 | 49.71 | 49.7425 | 871032.0 |
| 2019-04-15 10:10:00 | AAPL | Stock | 49.7388 | 49.7425 | 49.665 | 49.687 | 1043144.0 |
| 2019-04-15 10:15:00 | AAPL | Stock | 49.685 | 49.7625 | 49.675 | 49.74 | 776748.0 |
| 2019-04-15 10:20:00 | AAPL | Stock | 49.74 | 49.77 | 49.7175 | 49.7668 | 675652.0 |
| 2019-04-15 10:25:00 | AAPL | Stock | 49.765 | 49.7862 | 49.685 | 49.685 | 633184.0 |
| 2019-04-15 10:30:00 | AAPL | Stock | 49.685 | 49.694 | 49.6 | 49.6375 | 1209512.0 |
| 2019-04-15 10:35:00 | AAPL | Stock | 49.6375 | 49.64 | 49.525 | 49.535 | 1048244.0 |
| 2019-04-15 10:40:00 | AAPL | Stock | 49.535 | 49.5875 | 49.5025 | 49.5812 | 833748.0 |
| 2019-04-15 10:45:00 | AAPL | Stock | 49.5775 | 49.625 | 49.5525 | 49.605 | 617056.0 |
| 2019-04-15 10:50:00 | AAPL | Stock | 49.6025 | 49.6175 | 49.5662 | 49.61 | 573588.0 |
| 2019-04-15 10:55:00 | AAPL | Stock | 49.6123 | 49.6625 | 49.6 | 49.651 | 543976.0 |
> showing 50 of 349,322 rows — these rows as CSV