PREVIEW / stock_5min / 2018-11-01
file: by_date/stock_5min/2018/2018-11-01.parquet size: 5.8 MB rows: 369,159 symbols: 2,769
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-11-01 04:00:00 | AAPL | Stock | 54.745 | 54.745 | 54.725 | 54.725 | 5600.0 |
| 2018-11-01 04:05:00 | AAPL | Stock | 54.715 | 54.715 | 54.625 | 54.715 | 2896.0 |
| 2018-11-01 04:10:00 | AAPL | Stock | 54.715 | 54.715 | 54.69 | 54.69 | 3720.0 |
| 2018-11-01 04:15:00 | AAPL | Stock | 54.665 | 54.665 | 54.665 | 54.665 | 988.0 |
| 2018-11-01 04:25:00 | AAPL | Stock | 54.7975 | 54.825 | 54.7975 | 54.825 | 6764.0 |
| 2018-11-01 04:30:00 | AAPL | Stock | 54.875 | 54.875 | 54.875 | 54.875 | 1600.0 |
| 2018-11-01 04:35:00 | AAPL | Stock | 54.905 | 54.905 | 54.905 | 54.905 | 2176.0 |
| 2018-11-01 04:40:00 | AAPL | Stock | 54.905 | 54.9075 | 54.905 | 54.905 | 4984.0 |
| 2018-11-01 04:50:00 | AAPL | Stock | 54.955 | 54.955 | 54.955 | 54.955 | 800.0 |
| 2018-11-01 05:00:00 | AAPL | Stock | 54.9 | 54.915 | 54.9 | 54.915 | 5464.0 |
| 2018-11-01 05:05:00 | AAPL | Stock | 54.91 | 54.91 | 54.91 | 54.91 | 400.0 |
| 2018-11-01 05:10:00 | AAPL | Stock | 54.9 | 54.9475 | 54.8925 | 54.9475 | 6692.0 |
| 2018-11-01 05:20:00 | AAPL | Stock | 54.875 | 54.875 | 54.875 | 54.875 | 1080.0 |
| 2018-11-01 05:25:00 | AAPL | Stock | 54.85 | 54.8725 | 54.85 | 54.8725 | 4116.0 |
| 2018-11-01 05:30:00 | AAPL | Stock | 54.9075 | 54.925 | 54.9075 | 54.925 | 4968.0 |
| 2018-11-01 05:40:00 | AAPL | Stock | 54.875 | 54.875 | 54.855 | 54.855 | 2448.0 |
| 2018-11-01 05:50:00 | AAPL | Stock | 54.8875 | 54.8875 | 54.8875 | 54.8875 | 3600.0 |
| 2018-11-01 05:55:00 | AAPL | Stock | 54.9125 | 54.9375 | 54.9125 | 54.9375 | 23260.0 |
| 2018-11-01 06:00:00 | AAPL | Stock | 54.9875 | 55.02 | 54.9775 | 55.0175 | 10412.0 |
| 2018-11-01 06:05:00 | AAPL | Stock | 55.0175 | 55.0175 | 55.0075 | 55.0075 | 1652.0 |
| 2018-11-01 06:10:00 | AAPL | Stock | 55.0075 | 55.0075 | 55.0 | 55.005 | 4000.0 |
| 2018-11-01 06:15:00 | AAPL | Stock | 55.045 | 55.045 | 54.9875 | 54.9875 | 2760.0 |
| 2018-11-01 06:20:00 | AAPL | Stock | 55.0 | 55.0 | 54.995 | 54.995 | 800.0 |
| 2018-11-01 06:25:00 | AAPL | Stock | 54.995 | 54.995 | 54.995 | 54.995 | 1200.0 |
| 2018-11-01 06:30:00 | AAPL | Stock | 55.0 | 55.0225 | 54.9975 | 55.0225 | 26908.0 |
| 2018-11-01 06:35:00 | AAPL | Stock | 55.015 | 55.0225 | 55.015 | 55.02 | 11040.0 |
| 2018-11-01 06:40:00 | AAPL | Stock | 54.995 | 55.0375 | 54.995 | 55.0375 | 27840.0 |
| 2018-11-01 06:45:00 | AAPL | Stock | 55.05 | 55.07 | 55.05 | 55.07 | 11256.0 |
| 2018-11-01 06:50:00 | AAPL | Stock | 55.0675 | 55.0975 | 55.06 | 55.0975 | 7328.0 |
| 2018-11-01 06:55:00 | AAPL | Stock | 55.05 | 55.05 | 55.0025 | 55.0025 | 15652.0 |
| 2018-11-01 07:00:00 | AAPL | Stock | 55.0 | 55.05 | 54.95 | 54.9975 | 119464.0 |
| 2018-11-01 07:05:00 | AAPL | Stock | 54.975 | 55.025 | 54.955 | 55.025 | 50132.0 |
| 2018-11-01 07:10:00 | AAPL | Stock | 55.0025 | 55.03 | 55.0 | 55.0225 | 56004.0 |
| 2018-11-01 07:15:00 | AAPL | Stock | 55.0025 | 55.095 | 54.9975 | 55.095 | 19208.0 |
| 2018-11-01 07:20:00 | AAPL | Stock | 55.095 | 55.125 | 55.0825 | 55.1 | 58360.0 |
| 2018-11-01 07:25:00 | AAPL | Stock | 55.1 | 55.125 | 55.05 | 55.08 | 48188.0 |
| 2018-11-01 07:30:00 | AAPL | Stock | 55.0875 | 55.105 | 55.0075 | 55.05 | 98372.0 |
| 2018-11-01 07:35:00 | AAPL | Stock | 55.06 | 55.1 | 55.0325 | 55.0575 | 27212.0 |
| 2018-11-01 07:40:00 | AAPL | Stock | 55.0625 | 55.11 | 54.925 | 54.95 | 88624.0 |
| 2018-11-01 07:45:00 | AAPL | Stock | 54.9675 | 55.0 | 54.95 | 54.9975 | 80512.0 |
| 2018-11-01 07:50:00 | AAPL | Stock | 54.9925 | 55.0 | 54.9625 | 55.0 | 52812.0 |
| 2018-11-01 07:55:00 | AAPL | Stock | 55.0 | 55.0 | 54.96 | 54.9825 | 24096.0 |
| 2018-11-01 08:00:00 | AAPL | Stock | 55.0 | 55.125 | 54.95 | 55.0125 | 217700.0 |
| 2018-11-01 08:05:00 | AAPL | Stock | 55.0125 | 55.05 | 54.975 | 55.04 | 40568.0 |
| 2018-11-01 08:10:00 | AAPL | Stock | 55.015 | 55.025 | 54.925 | 54.95 | 87356.0 |
| 2018-11-01 08:15:00 | AAPL | Stock | 54.9525 | 54.9875 | 54.95 | 54.9775 | 35720.0 |
| 2018-11-01 08:20:00 | AAPL | Stock | 54.9775 | 55.0 | 54.9375 | 54.9625 | 43904.0 |
| 2018-11-01 08:25:00 | AAPL | Stock | 54.975 | 54.99 | 54.9375 | 54.99 | 33980.0 |
| 2018-11-01 08:30:00 | AAPL | Stock | 54.9825 | 55.0025 | 54.9525 | 54.9975 | 44808.0 |
| 2018-11-01 08:35:00 | AAPL | Stock | 54.9975 | 55.0 | 54.935 | 54.975 | 70496.0 |
> showing 50 of 369,159 rows — these rows as CSV