PREVIEW / stock_5min / 2024-11-19
file: by_date/stock_5min/2024/2024-11-19.parquet size: 7.1 MB rows: 420,547 symbols: 707
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-11-19 04:00:00 | AAPL | Stock | 228.08 | 228.19 | 228.08 | 228.1 | 571.0 |
| 2024-11-19 04:05:00 | AAPL | Stock | 228.16 | 228.16 | 228.01 | 228.01 | 361.0 |
| 2024-11-19 04:10:00 | AAPL | Stock | 228.07 | 228.07 | 228.03 | 228.03 | 350.0 |
| 2024-11-19 04:15:00 | AAPL | Stock | 228.02 | 228.02 | 227.64 | 227.75 | 1407.0 |
| 2024-11-19 04:20:00 | AAPL | Stock | 227.41 | 227.5 | 227.37 | 227.5 | 1403.0 |
| 2024-11-19 04:25:00 | AAPL | Stock | 227.37 | 227.41 | 227.17 | 227.17 | 9167.0 |
| 2024-11-19 04:30:00 | AAPL | Stock | 227.02 | 227.14 | 226.86 | 226.86 | 3697.0 |
| 2024-11-19 04:35:00 | AAPL | Stock | 227.08 | 227.08 | 227.02 | 227.05 | 1552.0 |
| 2024-11-19 04:40:00 | AAPL | Stock | 226.96 | 226.96 | 226.73 | 226.82 | 2836.0 |
| 2024-11-19 04:45:00 | AAPL | Stock | 226.82 | 226.82 | 226.82 | 226.82 | 600.0 |
| 2024-11-19 04:50:00 | AAPL | Stock | 226.9 | 227.18 | 226.9 | 227.09 | 1286.0 |
| 2024-11-19 04:55:00 | AAPL | Stock | 227.07 | 227.07 | 227.0 | 227.05 | 1792.0 |
| 2024-11-19 05:00:00 | AAPL | Stock | 227.01 | 227.01 | 227.0 | 227.0 | 400.0 |
| 2024-11-19 05:05:00 | AAPL | Stock | 226.95 | 226.99 | 226.95 | 226.99 | 723.0 |
| 2024-11-19 05:10:00 | AAPL | Stock | 227.0 | 227.0 | 226.95 | 226.95 | 497.0 |
| 2024-11-19 05:15:00 | AAPL | Stock | 227.19 | 227.7 | 227.19 | 227.7 | 2438.0 |
| 2024-11-19 05:25:00 | AAPL | Stock | 227.57 | 227.57 | 227.5 | 227.5 | 897.0 |
| 2024-11-19 05:30:00 | AAPL | Stock | 227.54 | 227.54 | 227.5 | 227.5 | 2430.0 |
| 2024-11-19 05:45:00 | AAPL | Stock | 227.6 | 227.7 | 227.6 | 227.7 | 784.0 |
| 2024-11-19 05:50:00 | AAPL | Stock | 227.69 | 227.69 | 227.69 | 227.69 | 231.0 |
| 2024-11-19 05:55:00 | AAPL | Stock | 227.69 | 227.69 | 227.69 | 227.69 | 100.0 |
| 2024-11-19 06:00:00 | AAPL | Stock | 227.62 | 227.62 | 227.61 | 227.61 | 663.0 |
| 2024-11-19 06:20:00 | AAPL | Stock | 227.6 | 227.6 | 227.6 | 227.6 | 625.0 |
| 2024-11-19 06:25:00 | AAPL | Stock | 227.68 | 227.76 | 227.6 | 227.6 | 988.0 |
| 2024-11-19 06:30:00 | AAPL | Stock | 227.57 | 227.57 | 227.5 | 227.5 | 515.0 |
| 2024-11-19 06:40:00 | AAPL | Stock | 227.62 | 227.68 | 227.62 | 227.68 | 349.0 |
| 2024-11-19 06:55:00 | AAPL | Stock | 227.67 | 227.73 | 227.67 | 227.73 | 550.0 |
| 2024-11-19 07:00:00 | AAPL | Stock | 227.79 | 227.95 | 227.0 | 227.95 | 6872.0 |
| 2024-11-19 07:05:00 | AAPL | Stock | 227.94 | 228.1 | 227.94 | 228.1 | 1840.0 |
| 2024-11-19 07:10:00 | AAPL | Stock | 228.18 | 228.22 | 228.18 | 228.22 | 3473.0 |
| 2024-11-19 07:15:00 | AAPL | Stock | 228.0 | 228.01 | 228.0 | 228.0 | 985.0 |
| 2024-11-19 07:20:00 | AAPL | Stock | 228.0 | 228.0 | 227.98 | 227.98 | 1000.0 |
| 2024-11-19 07:25:00 | AAPL | Stock | 227.89 | 227.95 | 227.83 | 227.88 | 945.0 |
| 2024-11-19 07:30:00 | AAPL | Stock | 227.9 | 227.9 | 227.83 | 227.83 | 586.0 |
| 2024-11-19 07:35:00 | AAPL | Stock | 227.83 | 227.99 | 227.64 | 227.81 | 3414.0 |
| 2024-11-19 07:40:00 | AAPL | Stock | 227.95 | 228.0 | 227.8 | 227.8 | 995.0 |
| 2024-11-19 07:45:00 | AAPL | Stock | 227.8 | 227.8 | 227.5 | 227.5 | 11796.0 |
| 2024-11-19 07:50:00 | AAPL | Stock | 227.63 | 227.65 | 227.63 | 227.65 | 300.0 |
| 2024-11-19 07:55:00 | AAPL | Stock | 227.76 | 227.84 | 227.76 | 227.84 | 2290.0 |
| 2024-11-19 08:00:00 | AAPL | Stock | 227.99 | 228.87 | 227.5131 | 227.9 | 14219.0 |
| 2024-11-19 08:05:00 | AAPL | Stock | 227.9 | 227.9 | 227.45 | 227.9 | 3851.0 |
| 2024-11-19 08:10:00 | AAPL | Stock | 227.9 | 227.9 | 227.88 | 227.9 | 5230.0 |
| 2024-11-19 08:15:00 | AAPL | Stock | 227.89 | 227.89 | 227.56 | 227.56 | 2787.0 |
| 2024-11-19 08:20:00 | AAPL | Stock | 227.571 | 227.571 | 227.49 | 227.49 | 3113.0 |
| 2024-11-19 08:25:00 | AAPL | Stock | 227.49 | 227.5 | 227.36 | 227.36 | 1550.0 |
| 2024-11-19 08:30:00 | AAPL | Stock | 227.36 | 227.36 | 227.0 | 227.01 | 6873.0 |
| 2024-11-19 08:35:00 | AAPL | Stock | 227.02 | 227.05 | 226.85 | 227.05 | 8513.0 |
| 2024-11-19 08:40:00 | AAPL | Stock | 227.07 | 227.1 | 226.77 | 226.78 | 2099.0 |
| 2024-11-19 08:45:00 | AAPL | Stock | 226.9 | 226.9 | 226.5 | 226.5 | 6781.0 |
| 2024-11-19 08:50:00 | AAPL | Stock | 226.38 | 226.48 | 226.0 | 226.0 | 6007.0 |
> showing 50 of 420,547 rows — these rows as CSV