PREVIEW / stock_1min / 2018-05-29
file: by_date/stock_1min/2018/2018-05-29.parquet size: 15.5 MB rows: 1,108,628 symbols: 2,359
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-05-29 04:00:00 | AAPL | Stock | 47.0775 | 47.0775 | 46.985 | 46.985 | 15924.0 |
| 2018-05-29 04:08:00 | AAPL | Stock | 46.95 | 46.95 | 46.95 | 46.95 | 400.0 |
| 2018-05-29 04:32:00 | AAPL | Stock | 46.8125 | 46.8125 | 46.75 | 46.75 | 9160.0 |
| 2018-05-29 04:36:00 | AAPL | Stock | 46.7125 | 46.7125 | 46.6875 | 46.6875 | 2300.0 |
| 2018-05-29 04:41:00 | AAPL | Stock | 46.725 | 46.725 | 46.725 | 46.725 | 2000.0 |
| 2018-05-29 04:50:00 | AAPL | Stock | 46.725 | 46.725 | 46.725 | 46.725 | 2000.0 |
| 2018-05-29 05:02:00 | AAPL | Stock | 46.695 | 46.695 | 46.695 | 46.695 | 400.0 |
| 2018-05-29 05:07:00 | AAPL | Stock | 46.7375 | 46.7375 | 46.7375 | 46.7375 | 1632.0 |
| 2018-05-29 05:09:00 | AAPL | Stock | 46.675 | 46.675 | 46.675 | 46.675 | 7468.0 |
| 2018-05-29 05:19:00 | AAPL | Stock | 46.7275 | 46.7275 | 46.7275 | 46.7275 | 744.0 |
| 2018-05-29 05:59:00 | AAPL | Stock | 46.7625 | 46.7625 | 46.7625 | 46.7625 | 524.0 |
| 2018-05-29 06:34:00 | AAPL | Stock | 46.7875 | 46.7875 | 46.7875 | 46.7875 | 400.0 |
| 2018-05-29 06:35:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 400.0 |
| 2018-05-29 07:00:00 | AAPL | Stock | 46.8375 | 46.865 | 46.78 | 46.8625 | 5176.0 |
| 2018-05-29 07:01:00 | AAPL | Stock | 46.8525 | 46.8525 | 46.85 | 46.85 | 20612.0 |
| 2018-05-29 07:02:00 | AAPL | Stock | 46.8475 | 46.85 | 46.825 | 46.825 | 20100.0 |
| 2018-05-29 07:03:00 | AAPL | Stock | 46.825 | 46.8275 | 46.77 | 46.77 | 27956.0 |
| 2018-05-29 07:04:00 | AAPL | Stock | 46.765 | 46.765 | 46.75 | 46.75 | 40400.0 |
| 2018-05-29 07:05:00 | AAPL | Stock | 46.755 | 46.755 | 46.75 | 46.75 | 1956.0 |
| 2018-05-29 07:06:00 | AAPL | Stock | 46.755 | 46.755 | 46.75 | 46.75 | 7156.0 |
| 2018-05-29 07:07:00 | AAPL | Stock | 46.75 | 46.76 | 46.75 | 46.76 | 800.0 |
| 2018-05-29 07:08:00 | AAPL | Stock | 46.765 | 46.765 | 46.765 | 46.765 | 400.0 |
| 2018-05-29 07:09:00 | AAPL | Stock | 46.7675 | 46.775 | 46.755 | 46.755 | 6800.0 |
| 2018-05-29 07:10:00 | AAPL | Stock | 46.7875 | 46.7875 | 46.7875 | 46.7875 | 1056.0 |
| 2018-05-29 07:21:00 | AAPL | Stock | 46.805 | 46.805 | 46.8 | 46.8 | 3800.0 |
| 2018-05-29 07:23:00 | AAPL | Stock | 46.825 | 46.9125 | 46.825 | 46.875 | 11424.0 |
| 2018-05-29 07:24:00 | AAPL | Stock | 46.8625 | 46.8625 | 46.8625 | 46.8625 | 828.0 |
| 2018-05-29 07:25:00 | AAPL | Stock | 46.84 | 46.84 | 46.8275 | 46.8275 | 2948.0 |
| 2018-05-29 07:27:00 | AAPL | Stock | 46.825 | 46.825 | 46.825 | 46.825 | 400.0 |
| 2018-05-29 07:29:00 | AAPL | Stock | 46.8275 | 46.8275 | 46.825 | 46.825 | 2048.0 |
| 2018-05-29 07:30:00 | AAPL | Stock | 46.825 | 46.825 | 46.825 | 46.825 | 400.0 |
| 2018-05-29 07:31:00 | AAPL | Stock | 46.8475 | 46.8475 | 46.8275 | 46.8475 | 1200.0 |
| 2018-05-29 07:32:00 | AAPL | Stock | 46.855 | 46.875 | 46.855 | 46.875 | 3200.0 |
| 2018-05-29 07:34:00 | AAPL | Stock | 46.88 | 46.88 | 46.88 | 46.88 | 400.0 |
| 2018-05-29 07:35:00 | AAPL | Stock | 46.8975 | 46.9 | 46.875 | 46.875 | 4420.0 |
| 2018-05-29 07:36:00 | AAPL | Stock | 46.895 | 46.8975 | 46.895 | 46.8975 | 800.0 |
| 2018-05-29 07:37:00 | AAPL | Stock | 46.8775 | 46.8775 | 46.8775 | 46.8775 | 1200.0 |
| 2018-05-29 07:38:00 | AAPL | Stock | 46.8875 | 46.8875 | 46.8875 | 46.8875 | 400.0 |
| 2018-05-29 07:42:00 | AAPL | Stock | 46.8775 | 46.8775 | 46.8625 | 46.8625 | 3176.0 |
| 2018-05-29 07:43:00 | AAPL | Stock | 46.8675 | 46.8675 | 46.8675 | 46.8675 | 400.0 |
| 2018-05-29 07:44:00 | AAPL | Stock | 46.8625 | 46.875 | 46.8625 | 46.875 | 3500.0 |
| 2018-05-29 07:48:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 1600.0 |
| 2018-05-29 07:49:00 | AAPL | Stock | 46.875 | 46.875 | 46.875 | 46.875 | 800.0 |
| 2018-05-29 07:50:00 | AAPL | Stock | 46.88 | 46.88 | 46.88 | 46.88 | 2000.0 |
| 2018-05-29 07:51:00 | AAPL | Stock | 46.885 | 46.9 | 46.885 | 46.9 | 2800.0 |
| 2018-05-29 07:52:00 | AAPL | Stock | 46.8975 | 46.9125 | 46.8975 | 46.9125 | 7600.0 |
| 2018-05-29 07:54:00 | AAPL | Stock | 46.9025 | 46.9025 | 46.9 | 46.9 | 800.0 |
| 2018-05-29 07:55:00 | AAPL | Stock | 46.9 | 46.9 | 46.9 | 46.9 | 1600.0 |
| 2018-05-29 08:00:00 | AAPL | Stock | 46.755 | 46.895 | 46.755 | 46.895 | 69220.0 |
| 2018-05-29 08:01:00 | AAPL | Stock | 46.9125 | 46.925 | 46.9125 | 46.925 | 42000.0 |
> showing 50 of 1,108,628 rows — these rows as CSV