PREVIEW / stock_5min / 2024-07-31
file: by_date/stock_5min/2024/2024-07-31.parquet size: 6.7 MB rows: 409,488 symbols: 898
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-07-31 04:00:00 | AAPL | Stock | 219.67 | 219.67 | 219.29 | 219.66 | 4938.0 |
| 2024-07-31 04:05:00 | AAPL | Stock | 219.65 | 219.77 | 219.54 | 219.7 | 2431.0 |
| 2024-07-31 04:10:00 | AAPL | Stock | 219.62 | 219.86 | 219.45 | 219.85 | 7740.0 |
| 2024-07-31 04:15:00 | AAPL | Stock | 219.85 | 219.9 | 219.72 | 219.77 | 947.0 |
| 2024-07-31 04:20:00 | AAPL | Stock | 219.77 | 219.96 | 219.77 | 219.95 | 2000.0 |
| 2024-07-31 04:25:00 | AAPL | Stock | 219.89 | 219.89 | 219.69 | 219.69 | 530.0 |
| 2024-07-31 04:30:00 | AAPL | Stock | 219.74 | 220.0 | 219.74 | 219.93 | 700.0 |
| 2024-07-31 04:35:00 | AAPL | Stock | 219.9 | 219.9 | 219.9 | 219.9 | 466.0 |
| 2024-07-31 04:40:00 | AAPL | Stock | 219.97 | 220.0 | 219.97 | 220.0 | 600.0 |
| 2024-07-31 04:45:00 | AAPL | Stock | 219.96 | 220.09 | 219.9 | 220.09 | 2091.0 |
| 2024-07-31 04:50:00 | AAPL | Stock | 220.1 | 220.11 | 220.1 | 220.1 | 816.0 |
| 2024-07-31 04:55:00 | AAPL | Stock | 220.13 | 220.24 | 220.1 | 220.24 | 1607.0 |
| 2024-07-31 05:00:00 | AAPL | Stock | 220.33 | 220.49 | 220.28 | 220.28 | 2742.0 |
| 2024-07-31 05:05:00 | AAPL | Stock | 220.18 | 220.3 | 220.15 | 220.17 | 1611.0 |
| 2024-07-31 05:10:00 | AAPL | Stock | 220.11 | 220.11 | 220.02 | 220.09 | 697.0 |
| 2024-07-31 05:15:00 | AAPL | Stock | 220.14 | 220.14 | 220.14 | 220.14 | 100.0 |
| 2024-07-31 05:20:00 | AAPL | Stock | 220.1 | 220.29 | 220.1 | 220.29 | 593.0 |
| 2024-07-31 05:25:00 | AAPL | Stock | 220.2 | 220.2 | 220.2 | 220.2 | 300.0 |
| 2024-07-31 05:30:00 | AAPL | Stock | 220.13 | 220.5 | 220.13 | 220.5 | 2794.0 |
| 2024-07-31 05:35:00 | AAPL | Stock | 220.45 | 220.68 | 220.45 | 220.68 | 733.0 |
| 2024-07-31 05:40:00 | AAPL | Stock | 220.63 | 220.63 | 220.51 | 220.51 | 300.0 |
| 2024-07-31 05:45:00 | AAPL | Stock | 220.29 | 220.31 | 220.27 | 220.31 | 441.0 |
| 2024-07-31 05:50:00 | AAPL | Stock | 220.49 | 220.49 | 220.49 | 220.49 | 100.0 |
| 2024-07-31 06:00:00 | AAPL | Stock | 220.26 | 220.26 | 220.26 | 220.26 | 100.0 |
| 2024-07-31 06:05:00 | AAPL | Stock | 220.25 | 220.25 | 220.17 | 220.17 | 532.0 |
| 2024-07-31 06:10:00 | AAPL | Stock | 220.17 | 220.17 | 220.16 | 220.16 | 1604.0 |
| 2024-07-31 06:25:00 | AAPL | Stock | 220.2 | 220.2 | 220.0 | 220.0 | 1276.0 |
| 2024-07-31 06:30:00 | AAPL | Stock | 219.95 | 220.06 | 219.95 | 220.06 | 300.0 |
| 2024-07-31 06:35:00 | AAPL | Stock | 220.09 | 220.09 | 220.07 | 220.07 | 447.0 |
| 2024-07-31 06:40:00 | AAPL | Stock | 220.04 | 220.1 | 220.04 | 220.1 | 520.0 |
| 2024-07-31 06:45:00 | AAPL | Stock | 220.1 | 220.2 | 220.02 | 220.2 | 613.0 |
| 2024-07-31 06:50:00 | AAPL | Stock | 220.19 | 220.27 | 220.19 | 220.27 | 2043.0 |
| 2024-07-31 06:55:00 | AAPL | Stock | 220.28 | 220.42 | 220.2 | 220.42 | 3405.0 |
| 2024-07-31 07:00:00 | AAPL | Stock | 220.32 | 220.32 | 220.01 | 220.2 | 6719.0 |
| 2024-07-31 07:05:00 | AAPL | Stock | 220.38 | 220.5 | 220.38 | 220.49 | 2032.0 |
| 2024-07-31 07:10:00 | AAPL | Stock | 220.44 | 220.59 | 220.41 | 220.59 | 2154.0 |
| 2024-07-31 07:15:00 | AAPL | Stock | 220.6 | 220.6 | 220.09 | 220.09 | 2956.0 |
| 2024-07-31 07:20:00 | AAPL | Stock | 220.14 | 220.22 | 220.02 | 220.19 | 5028.0 |
| 2024-07-31 07:25:00 | AAPL | Stock | 220.19 | 220.2 | 220.11 | 220.18 | 785.0 |
| 2024-07-31 07:30:00 | AAPL | Stock | 220.15 | 220.22 | 220.11 | 220.2 | 780.0 |
| 2024-07-31 07:35:00 | AAPL | Stock | 220.28 | 220.31 | 220.15 | 220.15 | 10391.0 |
| 2024-07-31 07:40:00 | AAPL | Stock | 220.25 | 220.27 | 220.11 | 220.16 | 7059.0 |
| 2024-07-31 07:45:00 | AAPL | Stock | 220.26 | 220.26 | 220.22 | 220.25 | 6269.0 |
| 2024-07-31 07:50:00 | AAPL | Stock | 220.28 | 220.33 | 220.21 | 220.26 | 7652.0 |
| 2024-07-31 07:55:00 | AAPL | Stock | 220.2 | 220.25 | 220.12 | 220.25 | 3995.0 |
| 2024-07-31 08:00:00 | AAPL | Stock | 220.0 | 220.58 | 218.7 | 220.17 | 60671.0 |
| 2024-07-31 08:05:00 | AAPL | Stock | 220.15 | 220.2 | 220.09 | 220.2 | 4943.0 |
| 2024-07-31 08:10:00 | AAPL | Stock | 220.2 | 220.2 | 220.0 | 220.0 | 18058.0 |
| 2024-07-31 08:15:00 | AAPL | Stock | 219.91 | 220.2 | 219.85 | 220.2 | 16748.0 |
| 2024-07-31 08:20:00 | AAPL | Stock | 220.15 | 220.15 | 219.97 | 220.0 | 6406.0 |
> showing 50 of 409,488 rows — these rows as CSV