PREVIEW / stock_5min / 2023-03-13
file: by_date/stock_5min/2023/2023-03-13.parquet size: 7.3 MB rows: 449,936 symbols: 1,763
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-03-13 04:00:00 | AAPL | Stock | 150.55 | 150.63 | 150.55 | 150.62 | 10778.0 |
| 2023-03-13 04:05:00 | AAPL | Stock | 150.56 | 150.7 | 150.56 | 150.62 | 7005.0 |
| 2023-03-13 04:10:00 | AAPL | Stock | 150.6 | 150.73 | 150.48 | 150.6 | 10414.0 |
| 2023-03-13 04:15:00 | AAPL | Stock | 150.57 | 150.6 | 150.51 | 150.51 | 1584.0 |
| 2023-03-13 04:20:00 | AAPL | Stock | 150.5 | 150.64 | 150.5 | 150.55 | 2061.0 |
| 2023-03-13 04:25:00 | AAPL | Stock | 150.52 | 150.58 | 150.21 | 150.21 | 10030.0 |
| 2023-03-13 04:30:00 | AAPL | Stock | 150.13 | 150.2 | 150.06 | 150.13 | 4464.0 |
| 2023-03-13 04:35:00 | AAPL | Stock | 150.07 | 150.13 | 150.03 | 150.1 | 1796.0 |
| 2023-03-13 04:40:00 | AAPL | Stock | 150.07 | 150.11 | 150.06 | 150.06 | 4353.0 |
| 2023-03-13 04:45:00 | AAPL | Stock | 150.03 | 150.03 | 149.65 | 149.84 | 2773.0 |
| 2023-03-13 04:50:00 | AAPL | Stock | 149.55 | 149.55 | 149.5 | 149.5 | 3549.0 |
| 2023-03-13 04:55:00 | AAPL | Stock | 149.54 | 149.7 | 149.16 | 149.16 | 3220.0 |
| 2023-03-13 05:00:00 | AAPL | Stock | 149.11 | 149.11 | 148.86 | 148.99 | 3483.0 |
| 2023-03-13 05:05:00 | AAPL | Stock | 148.92 | 149.2 | 148.92 | 149.05 | 8328.0 |
| 2023-03-13 05:10:00 | AAPL | Stock | 149.05 | 149.4 | 149.0 | 149.4 | 3116.0 |
| 2023-03-13 05:15:00 | AAPL | Stock | 149.31 | 149.44 | 149.18 | 149.26 | 3911.0 |
| 2023-03-13 05:20:00 | AAPL | Stock | 149.27 | 149.27 | 148.35 | 148.89 | 7466.0 |
| 2023-03-13 05:25:00 | AAPL | Stock | 148.7 | 149.19 | 148.53 | 148.85 | 2152.0 |
| 2023-03-13 05:30:00 | AAPL | Stock | 148.85 | 148.94 | 148.65 | 148.94 | 6644.0 |
| 2023-03-13 05:35:00 | AAPL | Stock | 148.77 | 149.04 | 148.61 | 149.04 | 4171.0 |
| 2023-03-13 05:40:00 | AAPL | Stock | 149.05 | 149.48 | 149.05 | 149.4 | 5759.0 |
| 2023-03-13 05:45:00 | AAPL | Stock | 149.49 | 149.9 | 149.48 | 149.67 | 5344.0 |
| 2023-03-13 05:50:00 | AAPL | Stock | 149.5 | 149.52 | 149.22 | 149.36 | 801.0 |
| 2023-03-13 05:55:00 | AAPL | Stock | 149.22 | 149.22 | 149.03 | 149.03 | 1358.0 |
| 2023-03-13 06:00:00 | AAPL | Stock | 149.0 | 149.49 | 148.98 | 149.49 | 1866.0 |
| 2023-03-13 06:05:00 | AAPL | Stock | 149.25 | 149.25 | 149.25 | 149.25 | 100.0 |
| 2023-03-13 06:10:00 | AAPL | Stock | 149.11 | 149.11 | 148.81 | 148.81 | 1878.0 |
| 2023-03-13 06:15:00 | AAPL | Stock | 149.1 | 149.1 | 148.81 | 149.0 | 2480.0 |
| 2023-03-13 06:20:00 | AAPL | Stock | 149.03 | 149.3 | 149.03 | 149.05 | 3704.0 |
| 2023-03-13 06:25:00 | AAPL | Stock | 149.13 | 149.25 | 149.13 | 149.18 | 2020.0 |
| 2023-03-13 06:30:00 | AAPL | Stock | 149.25 | 149.6 | 149.09 | 149.38 | 2598.0 |
| 2023-03-13 06:35:00 | AAPL | Stock | 149.42 | 149.45 | 149.38 | 149.39 | 2598.0 |
| 2023-03-13 06:40:00 | AAPL | Stock | 149.39 | 149.4 | 148.96 | 148.96 | 1925.0 |
| 2023-03-13 06:45:00 | AAPL | Stock | 148.96 | 149.4 | 148.96 | 149.4 | 4500.0 |
| 2023-03-13 06:50:00 | AAPL | Stock | 149.42 | 149.67 | 149.2 | 149.67 | 2030.0 |
| 2023-03-13 06:55:00 | AAPL | Stock | 149.66 | 150.0 | 149.66 | 149.79 | 9129.0 |
| 2023-03-13 07:00:00 | AAPL | Stock | 149.52 | 150.1 | 149.5 | 150.06 | 21273.0 |
| 2023-03-13 07:05:00 | AAPL | Stock | 150.0 | 150.0 | 149.8 | 149.9 | 6885.0 |
| 2023-03-13 07:10:00 | AAPL | Stock | 149.72 | 149.72 | 149.45 | 149.54 | 5470.0 |
| 2023-03-13 07:15:00 | AAPL | Stock | 149.55 | 149.61 | 149.44 | 149.61 | 3063.0 |
| 2023-03-13 07:20:00 | AAPL | Stock | 149.5 | 149.54 | 149.5 | 149.53 | 1711.0 |
| 2023-03-13 07:25:00 | AAPL | Stock | 149.53 | 149.53 | 149.33 | 149.47 | 3504.0 |
| 2023-03-13 07:30:00 | AAPL | Stock | 149.53 | 149.64 | 149.53 | 149.6 | 2579.0 |
| 2023-03-13 07:35:00 | AAPL | Stock | 149.55 | 149.74 | 149.55 | 149.61 | 4531.0 |
| 2023-03-13 07:40:00 | AAPL | Stock | 149.51 | 149.51 | 148.99 | 149.0 | 16784.0 |
| 2023-03-13 07:45:00 | AAPL | Stock | 148.94 | 149.34 | 148.94 | 149.34 | 9061.0 |
| 2023-03-13 07:50:00 | AAPL | Stock | 149.39 | 149.39 | 149.25 | 149.25 | 11845.0 |
| 2023-03-13 07:55:00 | AAPL | Stock | 149.14 | 149.52 | 149.05 | 149.3 | 4391.0 |
| 2023-03-13 08:00:00 | AAPL | Stock | 149.8 | 150.95 | 148.129 | 148.68 | 89864.0 |
| 2023-03-13 08:05:00 | AAPL | Stock | 148.7 | 149.05 | 148.52 | 148.89 | 40807.0 |
> showing 50 of 449,936 rows — these rows as CSV