PREVIEW / stock_5min / 2022-11-01
file: by_date/stock_5min/2022/2022-11-01.parquet size: 6.8 MB rows: 426,861 symbols: 2,127
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 |
|---|---|---|---|---|---|---|---|
| 2022-11-01 04:00:00 | AAPL | Stock | 153.59 | 154.43 | 153.04 | 154.43 | 4261.0 |
| 2022-11-01 04:05:00 | AAPL | Stock | 154.43 | 154.6 | 154.43 | 154.5 | 1997.0 |
| 2022-11-01 04:10:00 | AAPL | Stock | 154.48 | 154.58 | 154.44 | 154.56 | 6777.0 |
| 2022-11-01 04:15:00 | AAPL | Stock | 154.57 | 154.6 | 154.49 | 154.54 | 4935.0 |
| 2022-11-01 04:20:00 | AAPL | Stock | 154.5 | 154.6 | 154.5 | 154.54 | 6923.0 |
| 2022-11-01 04:25:00 | AAPL | Stock | 154.49 | 154.55 | 154.48 | 154.51 | 822.0 |
| 2022-11-01 04:30:00 | AAPL | Stock | 154.51 | 154.55 | 154.47 | 154.47 | 880.0 |
| 2022-11-01 04:35:00 | AAPL | Stock | 154.49 | 154.5 | 154.46 | 154.46 | 1646.0 |
| 2022-11-01 04:40:00 | AAPL | Stock | 154.48 | 154.48 | 154.48 | 154.48 | 136.0 |
| 2022-11-01 04:45:00 | AAPL | Stock | 154.41 | 154.41 | 154.4 | 154.4 | 495.0 |
| 2022-11-01 04:50:00 | AAPL | Stock | 154.45 | 154.47 | 154.45 | 154.47 | 432.0 |
| 2022-11-01 04:55:00 | AAPL | Stock | 154.41 | 154.55 | 154.41 | 154.55 | 7047.0 |
| 2022-11-01 05:00:00 | AAPL | Stock | 154.4 | 154.4 | 154.26 | 154.26 | 591.0 |
| 2022-11-01 05:05:00 | AAPL | Stock | 154.38 | 154.42 | 154.31 | 154.31 | 1620.0 |
| 2022-11-01 05:15:00 | AAPL | Stock | 154.36 | 154.36 | 154.36 | 154.36 | 236.0 |
| 2022-11-01 05:20:00 | AAPL | Stock | 154.53 | 154.53 | 154.53 | 154.53 | 221.0 |
| 2022-11-01 05:25:00 | AAPL | Stock | 154.55 | 154.55 | 154.55 | 154.55 | 1090.0 |
| 2022-11-01 05:30:00 | AAPL | Stock | 154.55 | 154.58 | 154.55 | 154.58 | 800.0 |
| 2022-11-01 05:35:00 | AAPL | Stock | 154.58 | 154.6 | 154.58 | 154.6 | 1251.0 |
| 2022-11-01 05:40:00 | AAPL | Stock | 154.6 | 154.76 | 154.6 | 154.74 | 5576.0 |
| 2022-11-01 05:45:00 | AAPL | Stock | 154.72 | 154.73 | 154.7 | 154.71 | 1677.0 |
| 2022-11-01 05:50:00 | AAPL | Stock | 154.73 | 154.75 | 154.73 | 154.75 | 800.0 |
| 2022-11-01 05:55:00 | AAPL | Stock | 154.79 | 154.82 | 154.79 | 154.8 | 3994.0 |
| 2022-11-01 06:00:00 | AAPL | Stock | 154.82 | 154.86 | 154.7 | 154.74 | 4365.0 |
| 2022-11-01 06:05:00 | AAPL | Stock | 154.64 | 154.74 | 154.64 | 154.74 | 1290.0 |
| 2022-11-01 06:10:00 | AAPL | Stock | 154.83 | 154.89 | 154.83 | 154.87 | 1746.0 |
| 2022-11-01 06:15:00 | AAPL | Stock | 154.93 | 154.93 | 154.92 | 154.92 | 1013.0 |
| 2022-11-01 06:20:00 | AAPL | Stock | 154.92 | 155.04 | 154.89 | 155.04 | 9087.0 |
| 2022-11-01 06:25:00 | AAPL | Stock | 155.0 | 155.0 | 155.0 | 155.0 | 976.0 |
| 2022-11-01 06:30:00 | AAPL | Stock | 154.99 | 155.1 | 154.99 | 155.1 | 4174.0 |
| 2022-11-01 06:35:00 | AAPL | Stock | 155.1 | 155.15 | 155.05 | 155.05 | 4063.0 |
| 2022-11-01 06:40:00 | AAPL | Stock | 155.1 | 155.1 | 155.02 | 155.02 | 2459.0 |
| 2022-11-01 06:45:00 | AAPL | Stock | 154.91 | 155.04 | 154.91 | 155.04 | 1659.0 |
| 2022-11-01 06:50:00 | AAPL | Stock | 155.05 | 155.05 | 155.04 | 155.04 | 1581.0 |
| 2022-11-01 06:55:00 | AAPL | Stock | 155.04 | 155.04 | 155.0 | 155.0 | 1340.0 |
| 2022-11-01 07:00:00 | AAPL | Stock | 154.9 | 154.98 | 154.69 | 154.8 | 10838.0 |
| 2022-11-01 07:05:00 | AAPL | Stock | 154.78 | 155.06 | 154.77 | 155.0 | 14861.0 |
| 2022-11-01 07:10:00 | AAPL | Stock | 154.92 | 154.92 | 154.75 | 154.79 | 4392.0 |
| 2022-11-01 07:15:00 | AAPL | Stock | 154.79 | 154.8 | 154.79 | 154.8 | 650.0 |
| 2022-11-01 07:20:00 | AAPL | Stock | 154.8 | 154.85 | 154.78 | 154.8 | 4026.0 |
| 2022-11-01 07:25:00 | AAPL | Stock | 154.84 | 154.87 | 154.84 | 154.84 | 1429.0 |
| 2022-11-01 07:30:00 | AAPL | Stock | 154.9 | 155.05 | 154.9 | 155.02 | 13321.0 |
| 2022-11-01 07:35:00 | AAPL | Stock | 155.02 | 155.02 | 154.9 | 154.9 | 5068.0 |
| 2022-11-01 07:40:00 | AAPL | Stock | 154.9 | 154.95 | 154.85 | 154.85 | 2471.0 |
| 2022-11-01 07:45:00 | AAPL | Stock | 154.92 | 154.99 | 154.91 | 154.94 | 2184.0 |
| 2022-11-01 07:50:00 | AAPL | Stock | 154.93 | 154.96 | 154.92 | 154.94 | 1617.0 |
| 2022-11-01 07:55:00 | AAPL | Stock | 154.96 | 155.0 | 154.94 | 154.94 | 6922.0 |
| 2022-11-01 08:00:00 | AAPL | Stock | 154.79 | 155.13 | 154.0 | 154.85 | 80706.0 |
| 2022-11-01 08:05:00 | AAPL | Stock | 154.86 | 154.95 | 154.86 | 154.93 | 8882.0 |
| 2022-11-01 08:10:00 | AAPL | Stock | 154.95 | 155.04 | 154.9 | 155.04 | 11427.0 |
> showing 50 of 426,861 rows — these rows as CSV