PREVIEW / stock_1min / 2018-10-15
file: by_date/stock_1min/2018/2018-10-15.parquet size: 15.6 MB rows: 1,099,877 symbols: 2,308
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-10-15 04:00:00 | AAPL | Stock | 55.195 | 55.195 | 55.12 | 55.12 | 2688.0 |
| 2018-10-15 04:10:00 | AAPL | Stock | 55.1525 | 55.1525 | 55.1525 | 55.1525 | 400.0 |
| 2018-10-15 04:11:00 | AAPL | Stock | 55.1075 | 55.1075 | 55.1075 | 55.1075 | 496.0 |
| 2018-10-15 04:15:00 | AAPL | Stock | 55.075 | 55.075 | 55.075 | 55.075 | 800.0 |
| 2018-10-15 04:16:00 | AAPL | Stock | 55.075 | 55.075 | 55.075 | 55.075 | 452.0 |
| 2018-10-15 04:17:00 | AAPL | Stock | 55.075 | 55.075 | 55.075 | 55.075 | 2800.0 |
| 2018-10-15 04:18:00 | AAPL | Stock | 55.0275 | 55.0275 | 55.0275 | 55.0275 | 1200.0 |
| 2018-10-15 04:24:00 | AAPL | Stock | 54.9575 | 54.9575 | 54.925 | 54.925 | 2840.0 |
| 2018-10-15 04:34:00 | AAPL | Stock | 54.9025 | 54.9025 | 54.8725 | 54.8725 | 800.0 |
| 2018-10-15 04:37:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 680.0 |
| 2018-10-15 04:41:00 | AAPL | Stock | 54.9625 | 54.9625 | 54.9625 | 54.9625 | 600.0 |
| 2018-10-15 04:53:00 | AAPL | Stock | 54.825 | 54.875 | 54.825 | 54.875 | 2660.0 |
| 2018-10-15 04:54:00 | AAPL | Stock | 54.85 | 54.85 | 54.825 | 54.825 | 2400.0 |
| 2018-10-15 04:58:00 | AAPL | Stock | 54.825 | 54.825 | 54.825 | 54.825 | 600.0 |
| 2018-10-15 05:24:00 | AAPL | Stock | 55.0 | 55.0375 | 55.0 | 55.0375 | 4520.0 |
| 2018-10-15 05:46:00 | AAPL | Stock | 55.05 | 55.05 | 55.05 | 55.05 | 864.0 |
| 2018-10-15 05:50:00 | AAPL | Stock | 55.05 | 55.05 | 55.05 | 55.05 | 600.0 |
| 2018-10-15 05:51:00 | AAPL | Stock | 55.005 | 55.005 | 55.0 | 55.0 | 6564.0 |
| 2018-10-15 06:02:00 | AAPL | Stock | 55.0625 | 55.0625 | 55.0625 | 55.0625 | 1800.0 |
| 2018-10-15 06:09:00 | AAPL | Stock | 55.1 | 55.1 | 55.075 | 55.075 | 3600.0 |
| 2018-10-15 06:10:00 | AAPL | Stock | 55.055 | 55.055 | 55.055 | 55.055 | 2000.0 |
| 2018-10-15 06:16:00 | AAPL | Stock | 55.075 | 55.075 | 55.075 | 55.075 | 400.0 |
| 2018-10-15 06:18:00 | AAPL | Stock | 55.05 | 55.05 | 55.015 | 55.015 | 5200.0 |
| 2018-10-15 06:19:00 | AAPL | Stock | 55.015 | 55.02 | 55.0025 | 55.0025 | 5560.0 |
| 2018-10-15 06:30:00 | AAPL | Stock | 54.98 | 54.9825 | 54.975 | 54.975 | 1600.0 |
| 2018-10-15 06:32:00 | AAPL | Stock | 54.9725 | 54.9825 | 54.9725 | 54.9825 | 1200.0 |
| 2018-10-15 06:34:00 | AAPL | Stock | 54.9575 | 54.9575 | 54.9575 | 54.9575 | 2000.0 |
| 2018-10-15 06:39:00 | AAPL | Stock | 54.955 | 54.955 | 54.9475 | 54.9475 | 2000.0 |
| 2018-10-15 06:40:00 | AAPL | Stock | 54.9475 | 54.9475 | 54.935 | 54.9475 | 2000.0 |
| 2018-10-15 06:43:00 | AAPL | Stock | 54.92 | 54.9225 | 54.92 | 54.9225 | 4320.0 |
| 2018-10-15 06:44:00 | AAPL | Stock | 54.92 | 54.92 | 54.92 | 54.92 | 8072.0 |
| 2018-10-15 06:45:00 | AAPL | Stock | 54.9225 | 54.9225 | 54.9225 | 54.9225 | 1420.0 |
| 2018-10-15 06:46:00 | AAPL | Stock | 54.97 | 54.97 | 54.97 | 54.97 | 800.0 |
| 2018-10-15 06:49:00 | AAPL | Stock | 54.9375 | 54.9675 | 54.9375 | 54.9675 | 2400.0 |
| 2018-10-15 06:51:00 | AAPL | Stock | 54.96 | 54.96 | 54.96 | 54.96 | 800.0 |
| 2018-10-15 06:52:00 | AAPL | Stock | 54.96 | 54.96 | 54.9375 | 54.9375 | 2500.0 |
| 2018-10-15 06:55:00 | AAPL | Stock | 54.9475 | 54.9475 | 54.9475 | 54.9475 | 400.0 |
| 2018-10-15 06:58:00 | AAPL | Stock | 54.9425 | 54.9575 | 54.9425 | 54.9575 | 1200.0 |
| 2018-10-15 07:00:00 | AAPL | Stock | 54.9575 | 54.9625 | 54.9325 | 54.9625 | 13100.0 |
| 2018-10-15 07:01:00 | AAPL | Stock | 54.955 | 54.97 | 54.9425 | 54.9425 | 3528.0 |
| 2018-10-15 07:03:00 | AAPL | Stock | 54.945 | 54.9475 | 54.93 | 54.94 | 5800.0 |
| 2018-10-15 07:04:00 | AAPL | Stock | 54.96 | 54.9625 | 54.96 | 54.9625 | 1016.0 |
| 2018-10-15 07:05:00 | AAPL | Stock | 54.96 | 55.0625 | 54.9475 | 55.0625 | 10040.0 |
| 2018-10-15 07:07:00 | AAPL | Stock | 55.0575 | 55.0925 | 55.0575 | 55.075 | 23424.0 |
| 2018-10-15 07:08:00 | AAPL | Stock | 55.075 | 55.1 | 55.075 | 55.1 | 4400.0 |
| 2018-10-15 07:09:00 | AAPL | Stock | 55.125 | 55.125 | 55.085 | 55.125 | 4456.0 |
| 2018-10-15 07:10:00 | AAPL | Stock | 55.1475 | 55.165 | 55.1475 | 55.165 | 2400.0 |
| 2018-10-15 07:11:00 | AAPL | Stock | 55.165 | 55.2 | 55.15 | 55.1975 | 16940.0 |
| 2018-10-15 07:12:00 | AAPL | Stock | 55.195 | 55.195 | 55.1425 | 55.1425 | 4400.0 |
| 2018-10-15 07:13:00 | AAPL | Stock | 55.15 | 55.15 | 55.15 | 55.15 | 800.0 |
> showing 50 of 1,099,877 rows — these rows as CSV