PREVIEW / stock_5min / 2019-06-10
file: by_date/stock_5min/2019/2019-06-10.parquet size: 5.7 MB rows: 362,994 symbols: 2,601
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-06-10 04:00:00 | AAPL | Stock | 47.8025 | 47.8025 | 47.8025 | 47.8025 | 400.0 |
| 2019-06-10 04:05:00 | AAPL | Stock | 47.8025 | 47.8025 | 47.8025 | 47.8025 | 400.0 |
| 2019-06-10 04:15:00 | AAPL | Stock | 47.7975 | 47.7975 | 47.7975 | 47.7975 | 1000.0 |
| 2019-06-10 04:50:00 | AAPL | Stock | 47.8625 | 47.8625 | 47.8625 | 47.8625 | 1584.0 |
| 2019-06-10 05:00:00 | AAPL | Stock | 47.8475 | 47.8475 | 47.8475 | 47.8475 | 600.0 |
| 2019-06-10 05:05:00 | AAPL | Stock | 47.81 | 47.81 | 47.81 | 47.81 | 960.0 |
| 2019-06-10 05:10:00 | AAPL | Stock | 47.765 | 47.765 | 47.765 | 47.765 | 1200.0 |
| 2019-06-10 05:25:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.7625 | 47.7625 | 2000.0 |
| 2019-06-10 05:30:00 | AAPL | Stock | 47.7625 | 47.7625 | 47.7275 | 47.7275 | 6596.0 |
| 2019-06-10 05:35:00 | AAPL | Stock | 47.7275 | 47.7275 | 47.7275 | 47.7275 | 2548.0 |
| 2019-06-10 05:45:00 | AAPL | Stock | 47.69 | 47.69 | 47.65 | 47.6825 | 5480.0 |
| 2019-06-10 05:50:00 | AAPL | Stock | 47.6825 | 47.69 | 47.65 | 47.65 | 5016.0 |
| 2019-06-10 06:05:00 | AAPL | Stock | 47.635 | 47.635 | 47.635 | 47.635 | 600.0 |
| 2019-06-10 06:10:00 | AAPL | Stock | 47.635 | 47.655 | 47.6 | 47.625 | 10732.0 |
| 2019-06-10 06:25:00 | AAPL | Stock | 47.625 | 47.625 | 47.625 | 47.625 | 400.0 |
| 2019-06-10 06:35:00 | AAPL | Stock | 47.665 | 47.665 | 47.665 | 47.665 | 3200.0 |
| 2019-06-10 06:40:00 | AAPL | Stock | 47.7475 | 47.7625 | 47.725 | 47.7625 | 9140.0 |
| 2019-06-10 06:45:00 | AAPL | Stock | 47.75 | 47.75 | 47.75 | 47.75 | 5708.0 |
| 2019-06-10 06:55:00 | AAPL | Stock | 47.75 | 47.75 | 47.75 | 47.75 | 15408.0 |
| 2019-06-10 07:00:00 | AAPL | Stock | 47.75 | 47.875 | 47.75 | 47.855 | 24780.0 |
| 2019-06-10 07:05:00 | AAPL | Stock | 47.85 | 47.9625 | 47.805 | 47.9625 | 11632.0 |
| 2019-06-10 07:10:00 | AAPL | Stock | 47.9 | 47.9625 | 47.8775 | 47.91 | 19036.0 |
| 2019-06-10 07:15:00 | AAPL | Stock | 47.94 | 47.9725 | 47.925 | 47.95 | 38440.0 |
| 2019-06-10 07:20:00 | AAPL | Stock | 47.95 | 48.0375 | 47.95 | 48.035 | 40200.0 |
| 2019-06-10 07:25:00 | AAPL | Stock | 48.0175 | 48.1 | 48.0175 | 48.1 | 15232.0 |
| 2019-06-10 07:30:00 | AAPL | Stock | 48.125 | 48.125 | 48.0625 | 48.0625 | 11924.0 |
| 2019-06-10 07:35:00 | AAPL | Stock | 48.0625 | 48.0725 | 48.0375 | 48.0625 | 17480.0 |
| 2019-06-10 07:40:00 | AAPL | Stock | 48.0625 | 48.095 | 48.0625 | 48.095 | 22200.0 |
| 2019-06-10 07:45:00 | AAPL | Stock | 48.095 | 48.1875 | 48.0925 | 48.1775 | 22848.0 |
| 2019-06-10 07:50:00 | AAPL | Stock | 48.1775 | 48.4375 | 48.15 | 48.275 | 73104.0 |
| 2019-06-10 07:55:00 | AAPL | Stock | 48.275 | 48.3375 | 48.26 | 48.3125 | 22072.0 |
| 2019-06-10 08:00:00 | AAPL | Stock | 47.8 | 48.3375 | 47.8 | 48.22 | 109356.0 |
| 2019-06-10 08:05:00 | AAPL | Stock | 48.225 | 48.2875 | 48.225 | 48.2675 | 20424.0 |
| 2019-06-10 08:10:00 | AAPL | Stock | 48.265 | 48.265 | 48.205 | 48.23 | 48740.0 |
| 2019-06-10 08:15:00 | AAPL | Stock | 48.25 | 48.285 | 48.24 | 48.25 | 52508.0 |
| 2019-06-10 08:20:00 | AAPL | Stock | 48.23 | 48.25 | 48.1625 | 48.19 | 61568.0 |
| 2019-06-10 08:25:00 | AAPL | Stock | 48.22 | 48.22 | 48.1825 | 48.19 | 5168.0 |
| 2019-06-10 08:30:00 | AAPL | Stock | 48.21 | 48.21 | 48.195 | 48.195 | 6100.0 |
| 2019-06-10 08:35:00 | AAPL | Stock | 48.2032 | 48.275 | 48.2 | 48.275 | 70672.0 |
| 2019-06-10 08:40:00 | AAPL | Stock | 48.275 | 48.3075 | 48.2125 | 48.2125 | 162612.0 |
| 2019-06-10 08:45:00 | AAPL | Stock | 48.2125 | 48.2475 | 48.1775 | 48.2475 | 25468.0 |
| 2019-06-10 08:50:00 | AAPL | Stock | 48.225 | 48.2475 | 48.175 | 48.1875 | 41128.0 |
| 2019-06-10 08:55:00 | AAPL | Stock | 48.18 | 48.1875 | 48.13 | 48.1875 | 38436.0 |
| 2019-06-10 09:00:00 | AAPL | Stock | 48.1875 | 48.2225 | 48.1572 | 48.1875 | 16704.0 |
| 2019-06-10 09:05:00 | AAPL | Stock | 48.2 | 48.2 | 48.175 | 48.1825 | 40660.0 |
| 2019-06-10 09:10:00 | AAPL | Stock | 48.17 | 48.2 | 48.1675 | 48.185 | 19984.0 |
| 2019-06-10 09:15:00 | AAPL | Stock | 48.1875 | 48.225 | 48.1875 | 48.225 | 21064.0 |
| 2019-06-10 09:20:00 | AAPL | Stock | 48.2175 | 48.2345 | 48.1875 | 48.1875 | 12656.0 |
| 2019-06-10 09:25:00 | AAPL | Stock | 48.1875 | 48.22 | 47.9475 | 48.0625 | 139632.0 |
| 2019-06-10 09:30:00 | AAPL | Stock | 48.0825 | 48.25 | 47.9025 | 48.16 | 6199920.0 |
> showing 50 of 362,994 rows — these rows as CSV