PREVIEW / stock_5min / 2024-09-03
file: by_date/stock_5min/2024/2024-09-03.parquet size: 6.6 MB rows: 402,068 symbols: 843
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-03 04:00:00 | AAPL | Stock | 229.27 | 229.4 | 229.14 | 229.4 | 3298.0 |
| 2024-09-03 04:05:00 | AAPL | Stock | 229.3 | 229.47 | 229.3 | 229.47 | 1269.0 |
| 2024-09-03 04:10:00 | AAPL | Stock | 229.5 | 229.63 | 229.4 | 229.6 | 2763.0 |
| 2024-09-03 04:15:00 | AAPL | Stock | 229.51 | 229.73 | 229.4 | 229.71 | 4197.0 |
| 2024-09-03 04:20:00 | AAPL | Stock | 229.72 | 229.84 | 229.72 | 229.74 | 3601.0 |
| 2024-09-03 04:25:00 | AAPL | Stock | 229.44 | 229.44 | 229.31 | 229.31 | 2311.0 |
| 2024-09-03 04:30:00 | AAPL | Stock | 229.36 | 229.36 | 229.14 | 229.14 | 1143.0 |
| 2024-09-03 04:35:00 | AAPL | Stock | 229.22 | 229.22 | 229.22 | 229.22 | 300.0 |
| 2024-09-03 04:40:00 | AAPL | Stock | 229.21 | 229.21 | 229.2 | 229.2 | 646.0 |
| 2024-09-03 04:45:00 | AAPL | Stock | 229.21 | 229.24 | 229.21 | 229.24 | 300.0 |
| 2024-09-03 04:50:00 | AAPL | Stock | 229.18 | 229.18 | 229.0 | 229.0 | 1144.0 |
| 2024-09-03 04:55:00 | AAPL | Stock | 228.91 | 228.91 | 228.59 | 228.59 | 835.0 |
| 2024-09-03 05:00:00 | AAPL | Stock | 228.57 | 228.59 | 228.5 | 228.59 | 1135.0 |
| 2024-09-03 05:05:00 | AAPL | Stock | 228.65 | 228.66 | 228.65 | 228.66 | 336.0 |
| 2024-09-03 05:10:00 | AAPL | Stock | 228.68 | 228.68 | 228.04 | 228.21 | 3723.0 |
| 2024-09-03 05:15:00 | AAPL | Stock | 228.13 | 228.2 | 227.96 | 228.07 | 2853.0 |
| 2024-09-03 05:20:00 | AAPL | Stock | 228.04 | 228.16 | 227.8 | 228.15 | 3919.0 |
| 2024-09-03 05:25:00 | AAPL | Stock | 228.15 | 228.16 | 228.15 | 228.16 | 695.0 |
| 2024-09-03 05:30:00 | AAPL | Stock | 228.0 | 228.0 | 227.82 | 227.82 | 1284.0 |
| 2024-09-03 05:35:00 | AAPL | Stock | 228.1 | 228.1 | 228.06 | 228.06 | 800.0 |
| 2024-09-03 05:40:00 | AAPL | Stock | 228.09 | 228.09 | 228.04 | 228.04 | 300.0 |
| 2024-09-03 05:45:00 | AAPL | Stock | 228.09 | 228.13 | 228.09 | 228.13 | 300.0 |
| 2024-09-03 05:50:00 | AAPL | Stock | 228.14 | 228.41 | 228.14 | 228.33 | 538.0 |
| 2024-09-03 05:55:00 | AAPL | Stock | 228.38 | 228.47 | 228.38 | 228.47 | 400.0 |
| 2024-09-03 06:00:00 | AAPL | Stock | 228.29 | 228.29 | 228.02 | 228.1 | 940.0 |
| 2024-09-03 06:05:00 | AAPL | Stock | 228.1 | 228.14 | 228.09 | 228.09 | 670.0 |
| 2024-09-03 06:15:00 | AAPL | Stock | 228.19 | 228.34 | 228.19 | 228.21 | 762.0 |
| 2024-09-03 06:20:00 | AAPL | Stock | 228.23 | 228.23 | 228.16 | 228.17 | 912.0 |
| 2024-09-03 06:25:00 | AAPL | Stock | 228.36 | 228.36 | 228.36 | 228.36 | 100.0 |
| 2024-09-03 06:30:00 | AAPL | Stock | 228.32 | 228.32 | 228.32 | 228.32 | 100.0 |
| 2024-09-03 06:35:00 | AAPL | Stock | 228.2 | 228.2 | 228.2 | 228.2 | 200.0 |
| 2024-09-03 06:40:00 | AAPL | Stock | 228.19 | 228.19 | 228.19 | 228.19 | 100.0 |
| 2024-09-03 06:50:00 | AAPL | Stock | 228.2 | 228.31 | 228.2 | 228.3 | 450.0 |
| 2024-09-03 06:55:00 | AAPL | Stock | 228.3 | 228.3 | 228.21 | 228.21 | 498.0 |
| 2024-09-03 07:00:00 | AAPL | Stock | 228.14 | 228.48 | 228.1 | 228.1 | 4903.0 |
| 2024-09-03 07:05:00 | AAPL | Stock | 228.02 | 228.02 | 228.0 | 228.0 | 1705.0 |
| 2024-09-03 07:10:00 | AAPL | Stock | 227.98 | 227.98 | 227.57 | 227.57 | 5764.0 |
| 2024-09-03 07:15:00 | AAPL | Stock | 227.6 | 228.02 | 227.6 | 228.02 | 5703.0 |
| 2024-09-03 07:20:00 | AAPL | Stock | 227.94 | 227.94 | 227.94 | 227.94 | 100.0 |
| 2024-09-03 07:25:00 | AAPL | Stock | 227.89 | 228.0 | 227.88 | 227.98 | 2868.0 |
| 2024-09-03 07:30:00 | AAPL | Stock | 228.02 | 228.14 | 228.02 | 228.14 | 1380.0 |
| 2024-09-03 07:35:00 | AAPL | Stock | 228.09 | 228.09 | 227.97 | 227.97 | 1717.0 |
| 2024-09-03 07:40:00 | AAPL | Stock | 228.0 | 228.0 | 227.9 | 227.9 | 300.0 |
| 2024-09-03 07:45:00 | AAPL | Stock | 227.8 | 227.8 | 227.63 | 227.66 | 3382.0 |
| 2024-09-03 07:50:00 | AAPL | Stock | 227.64 | 227.64 | 227.61 | 227.61 | 462.0 |
| 2024-09-03 07:55:00 | AAPL | Stock | 227.68 | 227.84 | 227.63 | 227.84 | 8701.0 |
| 2024-09-03 08:00:00 | AAPL | Stock | 227.85 | 229.7 | 227.5501 | 227.61 | 54341.0 |
| 2024-09-03 08:05:00 | AAPL | Stock | 227.59 | 227.72 | 227.4297 | 227.7 | 5256.0 |
| 2024-09-03 08:10:00 | AAPL | Stock | 227.65 | 227.8 | 227.61 | 227.72 | 3046.0 |
| 2024-09-03 08:15:00 | AAPL | Stock | 227.8 | 227.93 | 227.73 | 227.86 | 4860.0 |
> showing 50 of 402,068 rows — these rows as CSV