PREVIEW / stock_5min / 2023-08-07
file: by_date/stock_5min/2023/2023-08-07.parquet size: 6.7 MB rows: 406,377 symbols: 1,509
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-07 04:00:00 | AAPL | Stock | 183.04 | 183.49 | 182.54 | 183.35 | 14940.0 |
| 2023-08-07 04:05:00 | AAPL | Stock | 183.25 | 183.35 | 183.0 | 183.01 | 12017.0 |
| 2023-08-07 04:10:00 | AAPL | Stock | 182.89 | 183.0 | 182.75 | 182.93 | 11417.0 |
| 2023-08-07 04:15:00 | AAPL | Stock | 182.95 | 182.97 | 182.9 | 182.97 | 2161.0 |
| 2023-08-07 04:20:00 | AAPL | Stock | 183.0 | 183.0 | 182.98 | 183.0 | 3020.0 |
| 2023-08-07 04:25:00 | AAPL | Stock | 182.93 | 182.97 | 182.89 | 182.97 | 300.0 |
| 2023-08-07 04:30:00 | AAPL | Stock | 183.0 | 183.02 | 182.81 | 182.99 | 8618.0 |
| 2023-08-07 04:35:00 | AAPL | Stock | 182.87 | 182.9 | 182.84 | 182.9 | 3993.0 |
| 2023-08-07 04:40:00 | AAPL | Stock | 182.98 | 182.99 | 182.8 | 182.99 | 4930.0 |
| 2023-08-07 04:45:00 | AAPL | Stock | 182.88 | 182.88 | 182.75 | 182.75 | 4892.0 |
| 2023-08-07 04:50:00 | AAPL | Stock | 182.85 | 182.99 | 182.85 | 182.98 | 1882.0 |
| 2023-08-07 04:55:00 | AAPL | Stock | 182.98 | 183.04 | 182.91 | 182.91 | 3984.0 |
| 2023-08-07 05:00:00 | AAPL | Stock | 182.82 | 182.86 | 182.77 | 182.77 | 2084.0 |
| 2023-08-07 05:05:00 | AAPL | Stock | 182.9 | 182.9 | 182.9 | 182.9 | 947.0 |
| 2023-08-07 05:10:00 | AAPL | Stock | 182.85 | 182.85 | 182.82 | 182.82 | 2361.0 |
| 2023-08-07 05:15:00 | AAPL | Stock | 182.88 | 182.9 | 182.88 | 182.9 | 401.0 |
| 2023-08-07 05:20:00 | AAPL | Stock | 182.89 | 182.89 | 182.89 | 182.89 | 100.0 |
| 2023-08-07 05:25:00 | AAPL | Stock | 182.9 | 183.0 | 182.9 | 183.0 | 905.0 |
| 2023-08-07 05:30:00 | AAPL | Stock | 183.08 | 183.08 | 183.05 | 183.05 | 200.0 |
| 2023-08-07 05:35:00 | AAPL | Stock | 183.09 | 183.17 | 183.09 | 183.17 | 1129.0 |
| 2023-08-07 05:40:00 | AAPL | Stock | 183.19 | 183.2 | 183.1 | 183.12 | 4240.0 |
| 2023-08-07 05:45:00 | AAPL | Stock | 183.1 | 183.1 | 183.07 | 183.1 | 621.0 |
| 2023-08-07 05:50:00 | AAPL | Stock | 183.03 | 183.1 | 183.02 | 183.02 | 3445.0 |
| 2023-08-07 05:55:00 | AAPL | Stock | 183.0 | 183.04 | 182.85 | 182.86 | 2415.0 |
| 2023-08-07 06:00:00 | AAPL | Stock | 182.82 | 182.88 | 182.82 | 182.88 | 1685.0 |
| 2023-08-07 06:05:00 | AAPL | Stock | 182.86 | 182.86 | 182.75 | 182.84 | 4073.0 |
| 2023-08-07 06:10:00 | AAPL | Stock | 182.72 | 182.72 | 182.65 | 182.65 | 1594.0 |
| 2023-08-07 06:15:00 | AAPL | Stock | 182.74 | 182.74 | 182.72 | 182.74 | 4141.0 |
| 2023-08-07 06:20:00 | AAPL | Stock | 182.74 | 182.74 | 182.6 | 182.6 | 3433.0 |
| 2023-08-07 06:25:00 | AAPL | Stock | 182.59 | 182.6 | 182.43 | 182.52 | 7396.0 |
| 2023-08-07 06:30:00 | AAPL | Stock | 182.52 | 182.63 | 182.38 | 182.63 | 949.0 |
| 2023-08-07 06:35:00 | AAPL | Stock | 182.5 | 182.5 | 182.43 | 182.5 | 2271.0 |
| 2023-08-07 06:40:00 | AAPL | Stock | 182.59 | 182.7 | 182.59 | 182.69 | 3812.0 |
| 2023-08-07 06:45:00 | AAPL | Stock | 182.75 | 182.75 | 182.55 | 182.6 | 1467.0 |
| 2023-08-07 06:50:00 | AAPL | Stock | 182.6 | 182.6 | 182.59 | 182.6 | 800.0 |
| 2023-08-07 06:55:00 | AAPL | Stock | 182.6 | 182.66 | 182.6 | 182.66 | 956.0 |
| 2023-08-07 07:00:00 | AAPL | Stock | 182.69 | 182.97 | 182.43 | 182.45 | 21760.0 |
| 2023-08-07 07:05:00 | AAPL | Stock | 182.43 | 182.45 | 182.26 | 182.33 | 9044.0 |
| 2023-08-07 07:10:00 | AAPL | Stock | 182.35 | 182.5 | 182.35 | 182.5 | 6871.0 |
| 2023-08-07 07:15:00 | AAPL | Stock | 182.5 | 182.51 | 182.4 | 182.47 | 4548.0 |
| 2023-08-07 07:20:00 | AAPL | Stock | 182.44 | 182.44 | 182.35 | 182.38 | 2171.0 |
| 2023-08-07 07:25:00 | AAPL | Stock | 182.35 | 182.39 | 182.29 | 182.39 | 3647.0 |
| 2023-08-07 07:30:00 | AAPL | Stock | 182.37 | 182.41 | 182.37 | 182.38 | 4134.0 |
| 2023-08-07 07:35:00 | AAPL | Stock | 182.42 | 182.49 | 182.42 | 182.47 | 4067.0 |
| 2023-08-07 07:40:00 | AAPL | Stock | 182.49 | 182.49 | 182.4 | 182.4 | 11815.0 |
| 2023-08-07 07:45:00 | AAPL | Stock | 182.41 | 182.59 | 182.4 | 182.59 | 7359.0 |
| 2023-08-07 07:50:00 | AAPL | Stock | 182.57 | 182.59 | 182.55 | 182.58 | 2883.0 |
| 2023-08-07 07:55:00 | AAPL | Stock | 182.56 | 182.56 | 182.5 | 182.54 | 8277.0 |
| 2023-08-07 08:00:00 | AAPL | Stock | 182.62 | 183.88 | 182.26 | 182.64 | 96459.0 |
| 2023-08-07 08:05:00 | AAPL | Stock | 182.6 | 182.7 | 182.6 | 182.63 | 9977.0 |
> showing 50 of 406,377 rows — these rows as CSV