PREVIEW / stock_1min / 2018-11-15
file: by_date/stock_1min/2018/2018-11-15.parquet size: 16.4 MB rows: 1,142,745 symbols: 2,304
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-15 04:00:00 | AAPL | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 400.0 |
| 2018-11-15 04:02:00 | AAPL | Stock | 46.9 | 46.9 | 46.9 | 46.9 | 3800.0 |
| 2018-11-15 04:04:00 | AAPL | Stock | 46.975 | 46.975 | 46.9725 | 46.9725 | 2620.0 |
| 2018-11-15 04:06:00 | AAPL | Stock | 46.975 | 47.0 | 46.975 | 47.0 | 4800.0 |
| 2018-11-15 04:07:00 | AAPL | Stock | 47.15 | 47.15 | 47.15 | 47.15 | 800.0 |
| 2018-11-15 04:08:00 | AAPL | Stock | 47.0925 | 47.0925 | 47.0925 | 47.0925 | 400.0 |
| 2018-11-15 04:09:00 | AAPL | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 400.0 |
| 2018-11-15 04:14:00 | AAPL | Stock | 47.0625 | 47.0625 | 47.0625 | 47.0625 | 2800.0 |
| 2018-11-15 04:15:00 | AAPL | Stock | 47.025 | 47.0275 | 47.0025 | 47.015 | 2400.0 |
| 2018-11-15 04:16:00 | AAPL | Stock | 46.965 | 46.965 | 46.965 | 46.965 | 800.0 |
| 2018-11-15 04:21:00 | AAPL | Stock | 46.935 | 46.935 | 46.93 | 46.93 | 3540.0 |
| 2018-11-15 04:24:00 | AAPL | Stock | 47.0425 | 47.0475 | 47.0425 | 47.0425 | 2280.0 |
| 2018-11-15 04:30:00 | AAPL | Stock | 46.9375 | 46.9375 | 46.9375 | 46.9375 | 400.0 |
| 2018-11-15 04:47:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.8375 | 46.8375 | 400.0 |
| 2018-11-15 04:50:00 | AAPL | Stock | 46.835 | 46.835 | 46.835 | 46.835 | 400.0 |
| 2018-11-15 05:03:00 | AAPL | Stock | 46.7525 | 46.7525 | 46.75 | 46.75 | 800.0 |
| 2018-11-15 05:16:00 | AAPL | Stock | 46.79 | 46.825 | 46.79 | 46.825 | 1600.0 |
| 2018-11-15 05:18:00 | AAPL | Stock | 46.8575 | 46.8575 | 46.8575 | 46.8575 | 696.0 |
| 2018-11-15 05:19:00 | AAPL | Stock | 46.825 | 46.925 | 46.825 | 46.925 | 7464.0 |
| 2018-11-15 05:22:00 | AAPL | Stock | 46.9225 | 46.9225 | 46.9225 | 46.9225 | 2000.0 |
| 2018-11-15 05:24:00 | AAPL | Stock | 46.925 | 46.925 | 46.925 | 46.925 | 2000.0 |
| 2018-11-15 05:27:00 | AAPL | Stock | 46.925 | 46.925 | 46.925 | 46.925 | 2000.0 |
| 2018-11-15 05:28:00 | AAPL | Stock | 46.93 | 46.93 | 46.925 | 46.925 | 1600.0 |
| 2018-11-15 05:36:00 | AAPL | Stock | 46.9225 | 46.94 | 46.9225 | 46.94 | 4280.0 |
| 2018-11-15 05:40:00 | AAPL | Stock | 46.95 | 46.95 | 46.95 | 46.95 | 1428.0 |
| 2018-11-15 05:41:00 | AAPL | Stock | 46.9125 | 46.95 | 46.875 | 46.95 | 6724.0 |
| 2018-11-15 05:44:00 | AAPL | Stock | 46.925 | 46.925 | 46.925 | 46.925 | 760.0 |
| 2018-11-15 05:58:00 | AAPL | Stock | 46.995 | 46.995 | 46.995 | 46.995 | 4000.0 |
| 2018-11-15 06:00:00 | AAPL | Stock | 47.0225 | 47.0225 | 47.0225 | 47.0225 | 800.0 |
| 2018-11-15 06:05:00 | AAPL | Stock | 47.0375 | 47.0375 | 47.0375 | 47.0375 | 1816.0 |
| 2018-11-15 06:06:00 | AAPL | Stock | 47.0375 | 47.0375 | 47.0375 | 47.0375 | 2184.0 |
| 2018-11-15 06:11:00 | AAPL | Stock | 47.05 | 47.05 | 47.05 | 47.05 | 2000.0 |
| 2018-11-15 06:14:00 | AAPL | Stock | 47.05 | 47.05 | 47.05 | 47.05 | 1596.0 |
| 2018-11-15 06:15:00 | AAPL | Stock | 47.09 | 47.09 | 47.09 | 47.09 | 1200.0 |
| 2018-11-15 06:18:00 | AAPL | Stock | 47.085 | 47.085 | 47.085 | 47.085 | 800.0 |
| 2018-11-15 06:24:00 | AAPL | Stock | 47.095 | 47.095 | 47.095 | 47.095 | 1200.0 |
| 2018-11-15 06:30:00 | AAPL | Stock | 47.015 | 47.015 | 47.0 | 47.0 | 4596.0 |
| 2018-11-15 06:37:00 | AAPL | Stock | 47.0025 | 47.0025 | 47.0025 | 47.0025 | 800.0 |
| 2018-11-15 06:38:00 | AAPL | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 400.0 |
| 2018-11-15 06:40:00 | AAPL | Stock | 46.98 | 46.98 | 46.98 | 46.98 | 728.0 |
| 2018-11-15 06:44:00 | AAPL | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 1192.0 |
| 2018-11-15 06:45:00 | AAPL | Stock | 47.0025 | 47.0025 | 47.0025 | 47.0025 | 2000.0 |
| 2018-11-15 06:47:00 | AAPL | Stock | 47.0 | 47.0 | 47.0 | 47.0 | 880.0 |
| 2018-11-15 06:48:00 | AAPL | Stock | 47.025 | 47.025 | 47.025 | 47.025 | 968.0 |
| 2018-11-15 06:49:00 | AAPL | Stock | 46.965 | 46.965 | 46.965 | 46.965 | 400.0 |
| 2018-11-15 06:50:00 | AAPL | Stock | 46.9975 | 46.9975 | 46.9975 | 46.9975 | 800.0 |
| 2018-11-15 06:57:00 | AAPL | Stock | 47.0475 | 47.0475 | 47.0475 | 47.0475 | 2000.0 |
| 2018-11-15 07:00:00 | AAPL | Stock | 47.08 | 47.0825 | 46.98 | 47.05 | 10976.0 |
| 2018-11-15 07:01:00 | AAPL | Stock | 47.0125 | 47.0125 | 47.0125 | 47.0125 | 13196.0 |
| 2018-11-15 07:02:00 | AAPL | Stock | 47.015 | 47.05 | 47.015 | 47.035 | 2800.0 |
> showing 50 of 1,142,745 rows — these rows as CSV