PREVIEW / stock_5min / 2024-03-01
file: by_date/stock_5min/2024/2024-03-01.parquet size: 7.0 MB rows: 418,967 symbols: 1,121
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-03-01 04:00:00 | AAPL | Stock | 180.6 | 181.11 | 180.6 | 180.81 | 2547.0 |
| 2024-03-01 04:05:00 | AAPL | Stock | 180.84 | 180.9 | 180.81 | 180.9 | 400.0 |
| 2024-03-01 04:10:00 | AAPL | Stock | 180.9 | 181.21 | 180.9 | 181.21 | 2075.0 |
| 2024-03-01 04:15:00 | AAPL | Stock | 181.15 | 181.2 | 181.15 | 181.16 | 1022.0 |
| 2024-03-01 04:20:00 | AAPL | Stock | 181.15 | 181.15 | 181.13 | 181.13 | 747.0 |
| 2024-03-01 04:25:00 | AAPL | Stock | 180.84 | 180.84 | 180.64 | 180.64 | 1452.0 |
| 2024-03-01 04:30:00 | AAPL | Stock | 180.69 | 180.83 | 180.69 | 180.83 | 948.0 |
| 2024-03-01 04:35:00 | AAPL | Stock | 180.85 | 180.85 | 180.85 | 180.85 | 100.0 |
| 2024-03-01 04:45:00 | AAPL | Stock | 180.88 | 180.88 | 180.88 | 180.88 | 250.0 |
| 2024-03-01 04:55:00 | AAPL | Stock | 180.84 | 180.84 | 180.84 | 180.84 | 300.0 |
| 2024-03-01 05:00:00 | AAPL | Stock | 180.78 | 180.78 | 180.6 | 180.6 | 3850.0 |
| 2024-03-01 05:05:00 | AAPL | Stock | 180.53 | 180.53 | 180.28 | 180.53 | 10153.0 |
| 2024-03-01 05:10:00 | AAPL | Stock | 180.53 | 180.53 | 178.8 | 179.29 | 33260.0 |
| 2024-03-01 05:15:00 | AAPL | Stock | 179.3 | 179.76 | 179.01 | 179.4 | 29623.0 |
| 2024-03-01 05:20:00 | AAPL | Stock | 179.4 | 179.6 | 178.9 | 178.9 | 22834.0 |
| 2024-03-01 05:25:00 | AAPL | Stock | 178.9 | 179.25 | 178.66 | 179.03 | 17909.0 |
| 2024-03-01 05:30:00 | AAPL | Stock | 179.08 | 179.35 | 179.03 | 179.35 | 5012.0 |
| 2024-03-01 05:35:00 | AAPL | Stock | 179.38 | 179.38 | 179.24 | 179.35 | 1644.0 |
| 2024-03-01 05:40:00 | AAPL | Stock | 179.35 | 179.35 | 179.03 | 179.03 | 4214.0 |
| 2024-03-01 05:45:00 | AAPL | Stock | 179.08 | 179.15 | 179.01 | 179.15 | 1787.0 |
| 2024-03-01 05:50:00 | AAPL | Stock | 179.18 | 179.21 | 178.95 | 178.95 | 4951.0 |
| 2024-03-01 05:55:00 | AAPL | Stock | 178.91 | 178.96 | 178.86 | 178.86 | 3912.0 |
| 2024-03-01 06:00:00 | AAPL | Stock | 178.85 | 178.9 | 178.75 | 178.8 | 5995.0 |
| 2024-03-01 06:05:00 | AAPL | Stock | 178.83 | 178.83 | 178.78 | 178.78 | 2062.0 |
| 2024-03-01 06:10:00 | AAPL | Stock | 178.78 | 178.87 | 178.71 | 178.81 | 7597.0 |
| 2024-03-01 06:15:00 | AAPL | Stock | 178.87 | 178.88 | 178.85 | 178.85 | 13700.0 |
| 2024-03-01 06:20:00 | AAPL | Stock | 178.85 | 179.03 | 178.85 | 178.94 | 8842.0 |
| 2024-03-01 06:25:00 | AAPL | Stock | 178.89 | 179.05 | 178.85 | 178.93 | 3626.0 |
| 2024-03-01 06:30:00 | AAPL | Stock | 178.93 | 179.05 | 178.93 | 179.05 | 1801.0 |
| 2024-03-01 06:35:00 | AAPL | Stock | 179.09 | 179.1 | 178.95 | 178.95 | 2749.0 |
| 2024-03-01 06:40:00 | AAPL | Stock | 178.97 | 179.0 | 178.97 | 179.0 | 2416.0 |
| 2024-03-01 06:45:00 | AAPL | Stock | 179.04 | 179.13 | 179.04 | 179.13 | 4617.0 |
| 2024-03-01 06:50:00 | AAPL | Stock | 179.12 | 179.45 | 179.08 | 179.29 | 20938.0 |
| 2024-03-01 06:55:00 | AAPL | Stock | 179.39 | 179.39 | 179.11 | 179.12 | 2778.0 |
| 2024-03-01 07:00:00 | AAPL | Stock | 179.2 | 179.45 | 179.2 | 179.37 | 16121.0 |
| 2024-03-01 07:05:00 | AAPL | Stock | 179.37 | 179.46 | 179.35 | 179.45 | 20280.0 |
| 2024-03-01 07:10:00 | AAPL | Stock | 179.43 | 179.43 | 179.36 | 179.42 | 3747.0 |
| 2024-03-01 07:15:00 | AAPL | Stock | 179.42 | 179.87 | 179.33 | 179.84 | 46000.0 |
| 2024-03-01 07:20:00 | AAPL | Stock | 179.8 | 179.93 | 179.5 | 179.57 | 16924.0 |
| 2024-03-01 07:25:00 | AAPL | Stock | 179.57 | 179.87 | 179.57 | 179.84 | 5135.0 |
| 2024-03-01 07:30:00 | AAPL | Stock | 179.85 | 179.9 | 179.55 | 179.64 | 11222.0 |
| 2024-03-01 07:35:00 | AAPL | Stock | 179.71 | 179.72 | 179.62 | 179.65 | 2902.0 |
| 2024-03-01 07:40:00 | AAPL | Stock | 179.68 | 179.7 | 179.63 | 179.66 | 2339.0 |
| 2024-03-01 07:45:00 | AAPL | Stock | 179.73 | 179.86 | 179.73 | 179.81 | 6327.0 |
| 2024-03-01 07:50:00 | AAPL | Stock | 179.9 | 180.12 | 179.9 | 180.1 | 18378.0 |
| 2024-03-01 07:55:00 | AAPL | Stock | 180.12 | 180.12 | 179.9 | 180.06 | 9002.0 |
| 2024-03-01 08:00:00 | AAPL | Stock | 179.37 | 181.3 | 179.3 | 181.09 | 70192.0 |
| 2024-03-01 08:05:00 | AAPL | Stock | 181.12 | 181.25 | 180.03 | 180.12 | 10434.0 |
| 2024-03-01 08:10:00 | AAPL | Stock | 180.12 | 180.18 | 180.08 | 180.11 | 9543.0 |
| 2024-03-01 08:15:00 | AAPL | Stock | 180.03 | 180.1 | 179.99 | 180.03 | 16433.0 |
> showing 50 of 418,967 rows — these rows as CSV