PREVIEW / stock_5min / 2024-04-19
file: by_date/stock_5min/2024/2024-04-19.parquet size: 6.5 MB rows: 395,848 symbols: 992
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-04-19 04:00:00 | AAPL | Stock | 165.18 | 166.7 | 164.72 | 166.08 | 10918.0 |
| 2024-04-19 04:05:00 | AAPL | Stock | 166.29 | 166.38 | 166.04 | 166.2 | 2811.0 |
| 2024-04-19 04:10:00 | AAPL | Stock | 166.17 | 166.3 | 166.0 | 166.08 | 3535.0 |
| 2024-04-19 04:15:00 | AAPL | Stock | 166.14 | 166.38 | 166.04 | 166.38 | 5167.0 |
| 2024-04-19 04:20:00 | AAPL | Stock | 166.24 | 166.3 | 166.2 | 166.3 | 615.0 |
| 2024-04-19 04:25:00 | AAPL | Stock | 166.38 | 166.38 | 166.38 | 166.38 | 110.0 |
| 2024-04-19 04:30:00 | AAPL | Stock | 166.16 | 166.16 | 166.02 | 166.02 | 1961.0 |
| 2024-04-19 04:35:00 | AAPL | Stock | 166.0 | 166.2 | 166.0 | 166.2 | 5545.0 |
| 2024-04-19 04:40:00 | AAPL | Stock | 166.15 | 166.15 | 166.15 | 166.15 | 457.0 |
| 2024-04-19 04:45:00 | AAPL | Stock | 166.17 | 166.17 | 166.15 | 166.16 | 1883.0 |
| 2024-04-19 04:50:00 | AAPL | Stock | 166.19 | 166.3 | 166.19 | 166.3 | 286.0 |
| 2024-04-19 04:55:00 | AAPL | Stock | 166.35 | 166.35 | 166.24 | 166.24 | 456.0 |
| 2024-04-19 05:00:00 | AAPL | Stock | 166.29 | 166.29 | 166.29 | 166.29 | 999.0 |
| 2024-04-19 05:05:00 | AAPL | Stock | 166.41 | 166.45 | 166.41 | 166.45 | 329.0 |
| 2024-04-19 05:20:00 | AAPL | Stock | 166.46 | 166.46 | 166.46 | 166.46 | 278.0 |
| 2024-04-19 05:25:00 | AAPL | Stock | 166.5 | 166.57 | 166.5 | 166.57 | 2368.0 |
| 2024-04-19 05:30:00 | AAPL | Stock | 166.58 | 166.71 | 166.58 | 166.61 | 511.0 |
| 2024-04-19 05:35:00 | AAPL | Stock | 166.66 | 166.66 | 166.66 | 166.66 | 200.0 |
| 2024-04-19 05:40:00 | AAPL | Stock | 166.62 | 166.62 | 166.6 | 166.62 | 800.0 |
| 2024-04-19 05:45:00 | AAPL | Stock | 166.5 | 166.5 | 166.5 | 166.5 | 1658.0 |
| 2024-04-19 06:00:00 | AAPL | Stock | 166.42 | 167.18 | 166.42 | 167.1 | 15959.0 |
| 2024-04-19 06:05:00 | AAPL | Stock | 167.2 | 167.88 | 167.2 | 167.51 | 7992.0 |
| 2024-04-19 06:10:00 | AAPL | Stock | 167.51 | 167.84 | 167.46 | 167.46 | 4370.0 |
| 2024-04-19 06:15:00 | AAPL | Stock | 167.45 | 167.45 | 167.2 | 167.26 | 2161.0 |
| 2024-04-19 06:20:00 | AAPL | Stock | 167.25 | 167.25 | 167.2 | 167.22 | 2387.0 |
| 2024-04-19 06:25:00 | AAPL | Stock | 167.25 | 167.6 | 167.25 | 167.6 | 1042.0 |
| 2024-04-19 06:30:00 | AAPL | Stock | 167.49 | 167.49 | 167.33 | 167.33 | 400.0 |
| 2024-04-19 06:35:00 | AAPL | Stock | 167.26 | 167.26 | 167.02 | 167.02 | 450.0 |
| 2024-04-19 06:40:00 | AAPL | Stock | 167.15 | 167.2 | 167.15 | 167.2 | 250.0 |
| 2024-04-19 06:45:00 | AAPL | Stock | 167.09 | 167.09 | 167.05 | 167.05 | 447.0 |
| 2024-04-19 06:55:00 | AAPL | Stock | 167.0 | 167.19 | 167.0 | 167.19 | 1056.0 |
| 2024-04-19 07:00:00 | AAPL | Stock | 167.02 | 167.11 | 166.9 | 166.95 | 4005.0 |
| 2024-04-19 07:05:00 | AAPL | Stock | 166.95 | 166.95 | 166.9 | 166.91 | 819.0 |
| 2024-04-19 07:10:00 | AAPL | Stock | 166.95 | 167.05 | 166.92 | 166.95 | 4951.0 |
| 2024-04-19 07:15:00 | AAPL | Stock | 166.95 | 167.24 | 166.95 | 167.1 | 4519.0 |
| 2024-04-19 07:20:00 | AAPL | Stock | 167.04 | 167.04 | 167.01 | 167.01 | 588.0 |
| 2024-04-19 07:25:00 | AAPL | Stock | 167.09 | 167.17 | 167.09 | 167.15 | 5224.0 |
| 2024-04-19 07:30:00 | AAPL | Stock | 167.1 | 167.18 | 167.1 | 167.15 | 2472.0 |
| 2024-04-19 07:35:00 | AAPL | Stock | 167.15 | 167.18 | 167.12 | 167.15 | 2983.0 |
| 2024-04-19 07:40:00 | AAPL | Stock | 167.18 | 167.29 | 167.18 | 167.18 | 4062.0 |
| 2024-04-19 07:45:00 | AAPL | Stock | 167.18 | 167.18 | 167.0 | 167.15 | 1204.0 |
| 2024-04-19 07:50:00 | AAPL | Stock | 167.08 | 167.08 | 166.92 | 166.92 | 4273.0 |
| 2024-04-19 07:55:00 | AAPL | Stock | 167.0 | 167.04 | 167.0 | 167.04 | 1024.0 |
| 2024-04-19 08:00:00 | AAPL | Stock | 166.9 | 167.23 | 165.24 | 167.0 | 40039.0 |
| 2024-04-19 08:05:00 | AAPL | Stock | 167.0 | 167.05 | 166.91 | 167.05 | 7305.0 |
| 2024-04-19 08:10:00 | AAPL | Stock | 167.0001 | 167.1 | 167.0001 | 167.1 | 10308.0 |
| 2024-04-19 08:15:00 | AAPL | Stock | 167.1 | 167.17 | 167.07 | 167.1669 | 2741.0 |
| 2024-04-19 08:20:00 | AAPL | Stock | 167.17 | 167.17 | 167.05 | 167.17 | 2761.0 |
| 2024-04-19 08:25:00 | AAPL | Stock | 167.12 | 167.21 | 167.1 | 167.16 | 2888.0 |
| 2024-04-19 08:30:00 | AAPL | Stock | 167.16 | 167.41 | 167.16 | 167.35 | 19805.0 |
> showing 50 of 395,848 rows — these rows as CSV