PREVIEW / stock_5min / 2024-01-24
file: by_date/stock_5min/2024/2024-01-24.parquet size: 6.6 MB rows: 399,961 symbols: 1,167
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-01-24 04:00:00 | AAPL | Stock | 194.9 | 195.05 | 194.9 | 195.05 | 2329.0 |
| 2024-01-24 04:05:00 | AAPL | Stock | 195.14 | 195.49 | 195.14 | 195.28 | 2070.0 |
| 2024-01-24 04:10:00 | AAPL | Stock | 195.1 | 195.1 | 194.9 | 194.94 | 7365.0 |
| 2024-01-24 04:15:00 | AAPL | Stock | 194.99 | 194.99 | 194.91 | 194.95 | 1414.0 |
| 2024-01-24 04:20:00 | AAPL | Stock | 194.95 | 195.05 | 194.95 | 195.05 | 4935.0 |
| 2024-01-24 04:25:00 | AAPL | Stock | 195.0 | 195.05 | 195.0 | 195.05 | 1290.0 |
| 2024-01-24 04:30:00 | AAPL | Stock | 194.99 | 194.99 | 194.93 | 194.93 | 1534.0 |
| 2024-01-24 04:35:00 | AAPL | Stock | 194.93 | 195.0 | 194.87 | 194.87 | 2666.0 |
| 2024-01-24 04:40:00 | AAPL | Stock | 194.82 | 194.9 | 194.82 | 194.87 | 2065.0 |
| 2024-01-24 04:45:00 | AAPL | Stock | 194.86 | 194.88 | 194.86 | 194.88 | 1217.0 |
| 2024-01-24 04:55:00 | AAPL | Stock | 194.83 | 194.83 | 194.83 | 194.83 | 100.0 |
| 2024-01-24 05:00:00 | AAPL | Stock | 194.85 | 194.85 | 194.85 | 194.85 | 135.0 |
| 2024-01-24 05:05:00 | AAPL | Stock | 194.88 | 194.9 | 194.88 | 194.9 | 604.0 |
| 2024-01-24 05:15:00 | AAPL | Stock | 194.86 | 194.86 | 194.85 | 194.85 | 237.0 |
| 2024-01-24 05:20:00 | AAPL | Stock | 194.83 | 194.83 | 194.77 | 194.77 | 440.0 |
| 2024-01-24 05:25:00 | AAPL | Stock | 194.8 | 194.8 | 194.75 | 194.75 | 681.0 |
| 2024-01-24 05:30:00 | AAPL | Stock | 194.73 | 194.73 | 194.73 | 194.73 | 210.0 |
| 2024-01-24 05:45:00 | AAPL | Stock | 194.79 | 194.79 | 194.75 | 194.75 | 307.0 |
| 2024-01-24 05:50:00 | AAPL | Stock | 194.8 | 194.8 | 194.8 | 194.8 | 706.0 |
| 2024-01-24 05:55:00 | AAPL | Stock | 194.82 | 194.82 | 194.8 | 194.8 | 1418.0 |
| 2024-01-24 06:00:00 | AAPL | Stock | 194.8 | 194.9 | 194.8 | 194.9 | 3617.0 |
| 2024-01-24 06:05:00 | AAPL | Stock | 194.8 | 194.8 | 194.8 | 194.8 | 100.0 |
| 2024-01-24 06:10:00 | AAPL | Stock | 194.93 | 195.08 | 194.93 | 195.08 | 3219.0 |
| 2024-01-24 06:15:00 | AAPL | Stock | 195.08 | 195.08 | 195.0 | 195.0 | 1878.0 |
| 2024-01-24 06:25:00 | AAPL | Stock | 194.95 | 194.95 | 194.95 | 194.95 | 100.0 |
| 2024-01-24 06:35:00 | AAPL | Stock | 194.98 | 194.98 | 194.98 | 194.98 | 144.0 |
| 2024-01-24 06:40:00 | AAPL | Stock | 194.99 | 195.08 | 194.99 | 195.08 | 3048.0 |
| 2024-01-24 06:45:00 | AAPL | Stock | 195.17 | 195.3 | 195.17 | 195.3 | 2105.0 |
| 2024-01-24 06:50:00 | AAPL | Stock | 195.21 | 195.29 | 195.21 | 195.29 | 1035.0 |
| 2024-01-24 07:00:00 | AAPL | Stock | 195.0 | 195.19 | 195.0 | 195.15 | 6846.0 |
| 2024-01-24 07:05:00 | AAPL | Stock | 195.19 | 195.19 | 195.1 | 195.1 | 1507.0 |
| 2024-01-24 07:10:00 | AAPL | Stock | 195.18 | 195.25 | 195.18 | 195.25 | 2602.0 |
| 2024-01-24 07:15:00 | AAPL | Stock | 195.25 | 195.25 | 195.2 | 195.24 | 1007.0 |
| 2024-01-24 07:20:00 | AAPL | Stock | 195.23 | 195.23 | 195.1 | 195.12 | 4846.0 |
| 2024-01-24 07:25:00 | AAPL | Stock | 195.04 | 195.1 | 195.04 | 195.1 | 1260.0 |
| 2024-01-24 07:30:00 | AAPL | Stock | 195.08 | 195.22 | 195.08 | 195.22 | 2904.0 |
| 2024-01-24 07:35:00 | AAPL | Stock | 195.18 | 195.55 | 195.18 | 195.55 | 18464.0 |
| 2024-01-24 07:40:00 | AAPL | Stock | 195.5 | 195.55 | 195.45 | 195.45 | 1251.0 |
| 2024-01-24 07:45:00 | AAPL | Stock | 195.42 | 195.47 | 195.4 | 195.46 | 3497.0 |
| 2024-01-24 07:50:00 | AAPL | Stock | 195.46 | 195.46 | 195.38 | 195.38 | 1303.0 |
| 2024-01-24 07:55:00 | AAPL | Stock | 195.35 | 195.41 | 195.35 | 195.41 | 3474.0 |
| 2024-01-24 08:00:00 | AAPL | Stock | 195.13 | 195.58 | 194.61 | 194.72 | 81690.0 |
| 2024-01-24 08:05:00 | AAPL | Stock | 195.47 | 195.48 | 194.8 | 195.355 | 3908.0 |
| 2024-01-24 08:10:00 | AAPL | Stock | 195.35 | 195.5428 | 195.35 | 195.4206 | 7949.0 |
| 2024-01-24 08:15:00 | AAPL | Stock | 195.4799 | 195.53 | 195.44 | 195.45 | 7413.0 |
| 2024-01-24 08:20:00 | AAPL | Stock | 195.5 | 195.55 | 195.4947 | 195.51 | 4423.0 |
| 2024-01-24 08:25:00 | AAPL | Stock | 195.53 | 195.53 | 195.36 | 195.45 | 5300.0 |
| 2024-01-24 08:30:00 | AAPL | Stock | 195.4 | 195.48 | 195.38 | 195.48 | 4385.0 |
| 2024-01-24 08:35:00 | AAPL | Stock | 195.47 | 195.47 | 195.3 | 195.3001 | 15782.0 |
| 2024-01-24 08:40:00 | AAPL | Stock | 195.3 | 195.31 | 195.25 | 195.2995 | 9073.0 |
> showing 50 of 399,961 rows — these rows as CSV