PREVIEW / stock_5min / 2021-11-29
file: by_date/stock_5min/2021/2021-11-29.parquet size: 7.8 MB rows: 480,842 symbols: 2,679
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-29 04:00:00 | AAPL | Stock | 158.11 | 158.62 | 157.4 | 158.4 | 10130.0 |
| 2021-11-29 04:05:00 | AAPL | Stock | 158.43 | 158.6 | 158.42 | 158.6 | 12030.0 |
| 2021-11-29 04:10:00 | AAPL | Stock | 158.59 | 158.9 | 158.55 | 158.8 | 7180.0 |
| 2021-11-29 04:15:00 | AAPL | Stock | 158.95 | 158.95 | 158.64 | 158.85 | 3845.0 |
| 2021-11-29 04:20:00 | AAPL | Stock | 158.81 | 158.81 | 158.78 | 158.78 | 967.0 |
| 2021-11-29 04:25:00 | AAPL | Stock | 158.83 | 158.84 | 158.72 | 158.76 | 4240.0 |
| 2021-11-29 04:30:00 | AAPL | Stock | 158.8 | 158.82 | 158.64 | 158.69 | 4980.0 |
| 2021-11-29 04:35:00 | AAPL | Stock | 158.67 | 158.77 | 158.53 | 158.53 | 2757.0 |
| 2021-11-29 04:40:00 | AAPL | Stock | 158.5 | 158.6 | 158.46 | 158.56 | 3837.0 |
| 2021-11-29 04:45:00 | AAPL | Stock | 158.59 | 158.59 | 158.59 | 158.59 | 100.0 |
| 2021-11-29 04:50:00 | AAPL | Stock | 158.59 | 158.64 | 158.5 | 158.5 | 3434.0 |
| 2021-11-29 04:55:00 | AAPL | Stock | 158.52 | 158.52 | 158.35 | 158.35 | 569.0 |
| 2021-11-29 05:00:00 | AAPL | Stock | 158.4 | 158.5 | 158.4 | 158.5 | 7911.0 |
| 2021-11-29 05:05:00 | AAPL | Stock | 158.63 | 158.67 | 158.63 | 158.67 | 1820.0 |
| 2021-11-29 05:10:00 | AAPL | Stock | 158.65 | 158.71 | 158.65 | 158.71 | 1232.0 |
| 2021-11-29 05:15:00 | AAPL | Stock | 158.65 | 158.65 | 158.65 | 158.65 | 203.0 |
| 2021-11-29 05:20:00 | AAPL | Stock | 158.74 | 158.9 | 158.74 | 158.9 | 1114.0 |
| 2021-11-29 05:25:00 | AAPL | Stock | 158.89 | 159.0 | 158.89 | 158.92 | 4109.0 |
| 2021-11-29 05:30:00 | AAPL | Stock | 158.99 | 158.99 | 158.93 | 158.93 | 459.0 |
| 2021-11-29 05:35:00 | AAPL | Stock | 158.92 | 158.95 | 158.81 | 158.94 | 3203.0 |
| 2021-11-29 05:40:00 | AAPL | Stock | 158.96 | 159.06 | 158.94 | 158.94 | 3051.0 |
| 2021-11-29 05:45:00 | AAPL | Stock | 158.98 | 159.0 | 158.98 | 159.0 | 1630.0 |
| 2021-11-29 05:50:00 | AAPL | Stock | 159.04 | 159.2 | 159.04 | 159.19 | 3335.0 |
| 2021-11-29 05:55:00 | AAPL | Stock | 159.15 | 159.19 | 159.11 | 159.18 | 9311.0 |
| 2021-11-29 06:00:00 | AAPL | Stock | 159.15 | 159.2 | 159.15 | 159.2 | 3627.0 |
| 2021-11-29 06:05:00 | AAPL | Stock | 159.18 | 159.19 | 159.1 | 159.15 | 5556.0 |
| 2021-11-29 06:10:00 | AAPL | Stock | 159.16 | 159.22 | 159.12 | 159.12 | 9250.0 |
| 2021-11-29 06:15:00 | AAPL | Stock | 159.12 | 159.15 | 159.06 | 159.06 | 7202.0 |
| 2021-11-29 06:20:00 | AAPL | Stock | 158.98 | 159.08 | 158.92 | 159.08 | 3941.0 |
| 2021-11-29 06:25:00 | AAPL | Stock | 159.08 | 159.1 | 159.08 | 159.08 | 2071.0 |
| 2021-11-29 06:30:00 | AAPL | Stock | 159.05 | 159.06 | 159.05 | 159.06 | 862.0 |
| 2021-11-29 06:35:00 | AAPL | Stock | 159.0 | 159.08 | 159.0 | 159.08 | 1067.0 |
| 2021-11-29 06:40:00 | AAPL | Stock | 159.0 | 159.08 | 159.0 | 159.08 | 991.0 |
| 2021-11-29 06:45:00 | AAPL | Stock | 159.08 | 159.1 | 159.04 | 159.1 | 1437.0 |
| 2021-11-29 06:50:00 | AAPL | Stock | 159.02 | 159.03 | 158.8 | 159.03 | 4127.0 |
| 2021-11-29 06:55:00 | AAPL | Stock | 159.0 | 159.0 | 158.9 | 158.98 | 16237.0 |
| 2021-11-29 07:00:00 | AAPL | Stock | 159.0 | 159.03 | 158.7 | 158.72 | 21733.0 |
| 2021-11-29 07:05:00 | AAPL | Stock | 158.7 | 158.74 | 158.52 | 158.7 | 30302.0 |
| 2021-11-29 07:10:00 | AAPL | Stock | 158.68 | 158.7 | 158.62 | 158.64 | 17375.0 |
| 2021-11-29 07:15:00 | AAPL | Stock | 158.62 | 158.7 | 158.6 | 158.63 | 15949.0 |
| 2021-11-29 07:20:00 | AAPL | Stock | 158.62 | 158.8 | 158.62 | 158.71 | 15959.0 |
| 2021-11-29 07:25:00 | AAPL | Stock | 158.7 | 158.9 | 158.68 | 158.74 | 16510.0 |
| 2021-11-29 07:30:00 | AAPL | Stock | 158.72 | 158.9 | 158.72 | 158.79 | 6922.0 |
| 2021-11-29 07:35:00 | AAPL | Stock | 158.85 | 158.99 | 158.84 | 158.99 | 5050.0 |
| 2021-11-29 07:40:00 | AAPL | Stock | 158.99 | 159.15 | 158.98 | 159.05 | 23730.0 |
| 2021-11-29 07:45:00 | AAPL | Stock | 159.07 | 159.15 | 159.02 | 159.1 | 12752.0 |
| 2021-11-29 07:50:00 | AAPL | Stock | 159.08 | 159.12 | 158.97 | 159.01 | 15031.0 |
| 2021-11-29 07:55:00 | AAPL | Stock | 159.05 | 159.16 | 159.029 | 159.13 | 14835.0 |
| 2021-11-29 08:00:00 | AAPL | Stock | 158.75 | 159.16 | 158.52 | 159.0 | 307481.0 |
| 2021-11-29 08:05:00 | AAPL | Stock | 158.97 | 159.05 | 158.9 | 158.9999 | 54618.0 |
> showing 50 of 480,842 rows — these rows as CSV