PREVIEW / stock_1min / 2019-10-28
file: by_date/stock_1min/2019/2019-10-28.parquet size: 15.8 MB rows: 1,093,941 symbols: 2,137
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-10-28 04:00:00 | AAPL | Stock | 61.825 | 61.875 | 61.825 | 61.875 | 2508.0 |
| 2019-10-28 04:14:00 | AAPL | Stock | 61.9625 | 61.9625 | 61.9625 | 61.9625 | 400.0 |
| 2019-10-28 04:33:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 400.0 |
| 2019-10-28 04:43:00 | AAPL | Stock | 61.9825 | 61.9825 | 61.9825 | 61.9825 | 572.0 |
| 2019-10-28 04:46:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 400.0 |
| 2019-10-28 04:47:00 | AAPL | Stock | 61.9025 | 61.9025 | 61.9 | 61.9 | 2652.0 |
| 2019-10-28 04:50:00 | AAPL | Stock | 61.9025 | 61.9025 | 61.9025 | 61.9025 | 800.0 |
| 2019-10-28 04:51:00 | AAPL | Stock | 61.9425 | 61.9425 | 61.9425 | 61.9425 | 400.0 |
| 2019-10-28 04:54:00 | AAPL | Stock | 61.9425 | 61.95 | 61.9425 | 61.95 | 13200.0 |
| 2019-10-28 04:56:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 400.0 |
| 2019-10-28 04:57:00 | AAPL | Stock | 61.9575 | 61.9575 | 61.9575 | 61.9575 | 4000.0 |
| 2019-10-28 05:01:00 | AAPL | Stock | 61.915 | 61.915 | 61.905 | 61.905 | 1996.0 |
| 2019-10-28 05:18:00 | AAPL | Stock | 61.9175 | 61.9175 | 61.9175 | 61.9175 | 2224.0 |
| 2019-10-28 05:19:00 | AAPL | Stock | 61.9 | 61.9 | 61.9 | 61.9 | 544.0 |
| 2019-10-28 05:30:00 | AAPL | Stock | 61.875 | 61.875 | 61.875 | 61.875 | 952.0 |
| 2019-10-28 05:31:00 | AAPL | Stock | 61.875 | 61.875 | 61.875 | 61.875 | 960.0 |
| 2019-10-28 05:34:00 | AAPL | Stock | 61.875 | 61.875 | 61.875 | 61.875 | 1360.0 |
| 2019-10-28 05:36:00 | AAPL | Stock | 61.86 | 61.86 | 61.86 | 61.86 | 400.0 |
| 2019-10-28 05:39:00 | AAPL | Stock | 61.8975 | 61.9 | 61.8975 | 61.9 | 3124.0 |
| 2019-10-28 05:43:00 | AAPL | Stock | 61.8575 | 61.8575 | 61.855 | 61.855 | 840.0 |
| 2019-10-28 05:45:00 | AAPL | Stock | 61.9 | 61.9 | 61.9 | 61.9 | 400.0 |
| 2019-10-28 05:51:00 | AAPL | Stock | 61.9 | 61.9 | 61.9 | 61.9 | 800.0 |
| 2019-10-28 05:53:00 | AAPL | Stock | 61.8675 | 61.8675 | 61.8625 | 61.8625 | 800.0 |
| 2019-10-28 05:56:00 | AAPL | Stock | 61.855 | 61.8625 | 61.855 | 61.8575 | 1776.0 |
| 2019-10-28 06:02:00 | AAPL | Stock | 61.86 | 61.86 | 61.8375 | 61.8375 | 2960.0 |
| 2019-10-28 06:05:00 | AAPL | Stock | 61.855 | 61.855 | 61.855 | 61.855 | 1480.0 |
| 2019-10-28 06:06:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 400.0 |
| 2019-10-28 06:07:00 | AAPL | Stock | 61.8125 | 61.85 | 61.8125 | 61.8375 | 8000.0 |
| 2019-10-28 06:09:00 | AAPL | Stock | 61.8 | 61.8625 | 61.8 | 61.8625 | 7892.0 |
| 2019-10-28 06:10:00 | AAPL | Stock | 61.825 | 61.825 | 61.825 | 61.825 | 400.0 |
| 2019-10-28 06:14:00 | AAPL | Stock | 61.835 | 61.835 | 61.825 | 61.835 | 1708.0 |
| 2019-10-28 06:20:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 3276.0 |
| 2019-10-28 06:30:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 1188.0 |
| 2019-10-28 06:34:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 3256.0 |
| 2019-10-28 06:50:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 400.0 |
| 2019-10-28 06:55:00 | AAPL | Stock | 61.8375 | 61.8625 | 61.8375 | 61.8625 | 1196.0 |
| 2019-10-28 07:00:00 | AAPL | Stock | 61.8375 | 61.8875 | 61.8375 | 61.85 | 14064.0 |
| 2019-10-28 07:01:00 | AAPL | Stock | 61.85 | 61.8625 | 61.85 | 61.8625 | 4980.0 |
| 2019-10-28 07:02:00 | AAPL | Stock | 61.8875 | 61.9375 | 61.8875 | 61.9125 | 20344.0 |
| 2019-10-28 07:03:00 | AAPL | Stock | 61.9125 | 61.9125 | 61.8975 | 61.9 | 12448.0 |
| 2019-10-28 07:06:00 | AAPL | Stock | 61.9 | 61.9 | 61.9 | 61.9 | 960.0 |
| 2019-10-28 07:07:00 | AAPL | Stock | 61.9 | 61.9 | 61.875 | 61.875 | 1984.0 |
| 2019-10-28 07:08:00 | AAPL | Stock | 61.875 | 61.875 | 61.875 | 61.875 | 800.0 |
| 2019-10-28 07:09:00 | AAPL | Stock | 61.8625 | 61.875 | 61.8625 | 61.875 | 1400.0 |
| 2019-10-28 07:10:00 | AAPL | Stock | 61.8525 | 61.855 | 61.845 | 61.845 | 3600.0 |
| 2019-10-28 07:11:00 | AAPL | Stock | 61.8375 | 61.8375 | 61.8375 | 61.8375 | 1572.0 |
| 2019-10-28 07:12:00 | AAPL | Stock | 61.85 | 61.8625 | 61.85 | 61.8625 | 800.0 |
| 2019-10-28 07:14:00 | AAPL | Stock | 61.85 | 61.85 | 61.85 | 61.85 | 2400.0 |
| 2019-10-28 07:15:00 | AAPL | Stock | 61.85 | 61.875 | 61.85 | 61.875 | 16672.0 |
| 2019-10-28 07:16:00 | AAPL | Stock | 61.855 | 61.855 | 61.8525 | 61.8525 | 1584.0 |
> showing 50 of 1,093,941 rows — these rows as CSV