PREVIEW / stock_5min / 2021-11-18
file: by_date/stock_5min/2021/2021-11-18.parquet size: 7.8 MB rows: 476,848 symbols: 2,707
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 |
|---|---|---|---|---|---|---|---|
| 2021-11-18 04:00:00 | AAPL | Stock | 153.71 | 154.4 | 153.71 | 154.36 | 7602.0 |
| 2021-11-18 04:05:00 | AAPL | Stock | 154.31 | 154.31 | 154.18 | 154.19 | 6081.0 |
| 2021-11-18 04:10:00 | AAPL | Stock | 154.18 | 154.18 | 154.1 | 154.1 | 1336.0 |
| 2021-11-18 04:15:00 | AAPL | Stock | 154.03 | 154.04 | 154.03 | 154.04 | 900.0 |
| 2021-11-18 04:20:00 | AAPL | Stock | 154.04 | 154.1 | 154.04 | 154.1 | 1162.0 |
| 2021-11-18 04:25:00 | AAPL | Stock | 154.13 | 154.22 | 154.13 | 154.22 | 1889.0 |
| 2021-11-18 04:30:00 | AAPL | Stock | 154.2 | 154.2 | 154.18 | 154.18 | 712.0 |
| 2021-11-18 04:35:00 | AAPL | Stock | 154.22 | 154.22 | 154.2 | 154.2 | 464.0 |
| 2021-11-18 04:40:00 | AAPL | Stock | 154.13 | 154.14 | 154.13 | 154.14 | 231.0 |
| 2021-11-18 04:50:00 | AAPL | Stock | 154.18 | 154.18 | 154.1 | 154.1 | 2434.0 |
| 2021-11-18 04:55:00 | AAPL | Stock | 154.09 | 154.09 | 153.98 | 154.01 | 2057.0 |
| 2021-11-18 05:00:00 | AAPL | Stock | 154.01 | 154.07 | 153.97 | 154.07 | 3164.0 |
| 2021-11-18 05:05:00 | AAPL | Stock | 154.07 | 154.07 | 154.02 | 154.02 | 200.0 |
| 2021-11-18 05:10:00 | AAPL | Stock | 154.05 | 154.07 | 153.99 | 154.07 | 975.0 |
| 2021-11-18 05:15:00 | AAPL | Stock | 154.0 | 154.0 | 153.99 | 153.99 | 300.0 |
| 2021-11-18 05:20:00 | AAPL | Stock | 153.99 | 153.99 | 153.84 | 153.84 | 3310.0 |
| 2021-11-18 05:25:00 | AAPL | Stock | 153.84 | 153.84 | 153.81 | 153.81 | 1771.0 |
| 2021-11-18 05:40:00 | AAPL | Stock | 153.89 | 153.89 | 153.88 | 153.88 | 684.0 |
| 2021-11-18 05:45:00 | AAPL | Stock | 153.88 | 153.88 | 153.85 | 153.85 | 388.0 |
| 2021-11-18 05:50:00 | AAPL | Stock | 153.86 | 153.86 | 153.86 | 153.86 | 100.0 |
| 2021-11-18 05:55:00 | AAPL | Stock | 153.89 | 154.0 | 153.89 | 154.0 | 1332.0 |
| 2021-11-18 06:00:00 | AAPL | Stock | 153.97 | 153.97 | 153.8 | 153.8 | 2515.0 |
| 2021-11-18 06:05:00 | AAPL | Stock | 153.81 | 153.82 | 153.8 | 153.8 | 3450.0 |
| 2021-11-18 06:15:00 | AAPL | Stock | 153.85 | 153.85 | 153.85 | 153.85 | 100.0 |
| 2021-11-18 06:20:00 | AAPL | Stock | 153.85 | 153.9 | 153.85 | 153.85 | 2492.0 |
| 2021-11-18 06:25:00 | AAPL | Stock | 153.85 | 153.86 | 153.83 | 153.83 | 1574.0 |
| 2021-11-18 06:30:00 | AAPL | Stock | 153.85 | 153.91 | 153.85 | 153.9 | 931.0 |
| 2021-11-18 06:35:00 | AAPL | Stock | 153.9 | 153.9 | 153.86 | 153.86 | 350.0 |
| 2021-11-18 06:40:00 | AAPL | Stock | 153.86 | 153.86 | 153.85 | 153.85 | 306.0 |
| 2021-11-18 06:50:00 | AAPL | Stock | 153.85 | 153.91 | 153.83 | 153.84 | 1563.0 |
| 2021-11-18 06:55:00 | AAPL | Stock | 153.91 | 153.97 | 153.9 | 153.97 | 5744.0 |
| 2021-11-18 07:00:00 | AAPL | Stock | 153.94 | 153.98 | 153.89 | 153.9 | 11255.0 |
| 2021-11-18 07:05:00 | AAPL | Stock | 153.88 | 153.96 | 153.86 | 153.95 | 6283.0 |
| 2021-11-18 07:10:00 | AAPL | Stock | 153.95 | 153.95 | 153.88 | 153.9 | 4074.0 |
| 2021-11-18 07:15:00 | AAPL | Stock | 153.9 | 153.92 | 153.9 | 153.9 | 1831.0 |
| 2021-11-18 07:20:00 | AAPL | Stock | 153.9 | 153.9 | 153.84 | 153.84 | 11231.0 |
| 2021-11-18 07:25:00 | AAPL | Stock | 153.84 | 153.87 | 153.82 | 153.82 | 6707.0 |
| 2021-11-18 07:30:00 | AAPL | Stock | 153.84 | 153.94 | 153.84 | 153.86 | 10123.0 |
| 2021-11-18 07:35:00 | AAPL | Stock | 153.91 | 153.91 | 153.81 | 153.85 | 6026.0 |
| 2021-11-18 07:40:00 | AAPL | Stock | 153.87 | 153.9 | 153.84 | 153.9 | 6868.0 |
| 2021-11-18 07:45:00 | AAPL | Stock | 153.89 | 153.89 | 153.75 | 153.75 | 5179.0 |
| 2021-11-18 07:50:00 | AAPL | Stock | 153.74 | 153.79 | 153.71 | 153.77 | 4272.0 |
| 2021-11-18 07:55:00 | AAPL | Stock | 153.75 | 153.76 | 153.73 | 153.75 | 1225.0 |
| 2021-11-18 08:00:00 | AAPL | Stock | 153.9 | 153.99 | 153.107 | 153.6801 | 132232.0 |
| 2021-11-18 08:05:00 | AAPL | Stock | 153.68 | 153.75 | 153.68 | 153.73 | 19921.0 |
| 2021-11-18 08:10:00 | AAPL | Stock | 153.72 | 153.75 | 153.69 | 153.7499 | 7667.0 |
| 2021-11-18 08:15:00 | AAPL | Stock | 153.75 | 153.75 | 153.66 | 153.6703 | 16886.0 |
| 2021-11-18 08:20:00 | AAPL | Stock | 153.66 | 153.71 | 153.6301 | 153.71 | 7105.0 |
| 2021-11-18 08:25:00 | AAPL | Stock | 153.71 | 153.89 | 153.71 | 153.85 | 14583.0 |
| 2021-11-18 08:30:00 | AAPL | Stock | 153.85 | 153.95 | 153.82 | 153.82 | 15549.0 |
> showing 50 of 476,848 rows — these rows as CSV