PREVIEW / stock_5min / 2023-01-18
file: by_date/stock_5min/2023/2023-01-18.parquet size: 7.0 MB rows: 428,847 symbols: 1,938
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 |
|---|---|---|---|---|---|---|---|
| 2023-01-18 04:00:00 | AAPL | Stock | 136.28 | 136.28 | 136.1 | 136.1 | 868.0 |
| 2023-01-18 04:05:00 | AAPL | Stock | 136.14 | 136.14 | 136.1 | 136.1 | 1266.0 |
| 2023-01-18 04:10:00 | AAPL | Stock | 136.16 | 136.16 | 136.07 | 136.12 | 2573.0 |
| 2023-01-18 04:15:00 | AAPL | Stock | 136.12 | 136.28 | 136.12 | 136.28 | 1291.0 |
| 2023-01-18 04:20:00 | AAPL | Stock | 136.28 | 136.3 | 136.25 | 136.3 | 3367.0 |
| 2023-01-18 04:25:00 | AAPL | Stock | 136.3 | 136.3 | 136.3 | 136.3 | 106.0 |
| 2023-01-18 04:30:00 | AAPL | Stock | 136.15 | 136.17 | 136.13 | 136.15 | 2280.0 |
| 2023-01-18 04:35:00 | AAPL | Stock | 136.13 | 136.13 | 136.11 | 136.11 | 500.0 |
| 2023-01-18 04:40:00 | AAPL | Stock | 136.13 | 136.13 | 136.13 | 136.13 | 100.0 |
| 2023-01-18 04:45:00 | AAPL | Stock | 136.12 | 136.16 | 136.07 | 136.16 | 1611.0 |
| 2023-01-18 04:50:00 | AAPL | Stock | 136.23 | 136.23 | 136.23 | 136.23 | 403.0 |
| 2023-01-18 04:55:00 | AAPL | Stock | 136.18 | 136.18 | 136.17 | 136.17 | 698.0 |
| 2023-01-18 05:00:00 | AAPL | Stock | 136.18 | 136.2 | 136.18 | 136.18 | 1420.0 |
| 2023-01-18 05:05:00 | AAPL | Stock | 136.21 | 136.21 | 136.2 | 136.2 | 479.0 |
| 2023-01-18 05:10:00 | AAPL | Stock | 136.16 | 136.17 | 136.14 | 136.17 | 358.0 |
| 2023-01-18 05:15:00 | AAPL | Stock | 136.17 | 136.22 | 136.17 | 136.18 | 5248.0 |
| 2023-01-18 05:25:00 | AAPL | Stock | 136.17 | 136.17 | 136.07 | 136.11 | 474.0 |
| 2023-01-18 05:30:00 | AAPL | Stock | 136.12 | 136.12 | 136.02 | 136.02 | 690.0 |
| 2023-01-18 05:35:00 | AAPL | Stock | 136.02 | 136.12 | 136.02 | 136.12 | 421.0 |
| 2023-01-18 05:40:00 | AAPL | Stock | 136.16 | 136.2 | 136.16 | 136.2 | 360.0 |
| 2023-01-18 05:45:00 | AAPL | Stock | 136.24 | 136.3 | 136.24 | 136.3 | 855.0 |
| 2023-01-18 05:50:00 | AAPL | Stock | 136.31 | 136.34 | 136.31 | 136.34 | 1222.0 |
| 2023-01-18 05:55:00 | AAPL | Stock | 136.34 | 136.45 | 136.34 | 136.41 | 2774.0 |
| 2023-01-18 06:10:00 | AAPL | Stock | 136.44 | 136.44 | 136.42 | 136.42 | 468.0 |
| 2023-01-18 06:20:00 | AAPL | Stock | 136.43 | 136.43 | 136.42 | 136.42 | 1732.0 |
| 2023-01-18 06:25:00 | AAPL | Stock | 136.44 | 136.44 | 136.44 | 136.44 | 150.0 |
| 2023-01-18 06:30:00 | AAPL | Stock | 136.4 | 136.4 | 136.32 | 136.36 | 973.0 |
| 2023-01-18 06:35:00 | AAPL | Stock | 136.4 | 136.49 | 136.36 | 136.49 | 1070.0 |
| 2023-01-18 06:40:00 | AAPL | Stock | 136.48 | 136.48 | 136.48 | 136.48 | 357.0 |
| 2023-01-18 06:45:00 | AAPL | Stock | 136.48 | 136.48 | 136.43 | 136.43 | 2031.0 |
| 2023-01-18 06:50:00 | AAPL | Stock | 136.43 | 136.57 | 136.43 | 136.57 | 1347.0 |
| 2023-01-18 06:55:00 | AAPL | Stock | 136.57 | 136.57 | 136.57 | 136.57 | 400.0 |
| 2023-01-18 07:00:00 | AAPL | Stock | 136.52 | 136.59 | 136.43 | 136.55 | 7516.0 |
| 2023-01-18 07:05:00 | AAPL | Stock | 136.58 | 136.63 | 136.5 | 136.5 | 3896.0 |
| 2023-01-18 07:10:00 | AAPL | Stock | 136.52 | 136.59 | 136.5 | 136.57 | 3982.0 |
| 2023-01-18 07:15:00 | AAPL | Stock | 136.57 | 136.6 | 136.57 | 136.58 | 3058.0 |
| 2023-01-18 07:20:00 | AAPL | Stock | 136.58 | 136.6 | 136.58 | 136.59 | 8403.0 |
| 2023-01-18 07:25:00 | AAPL | Stock | 136.55 | 136.66 | 136.5 | 136.66 | 4637.0 |
| 2023-01-18 07:30:00 | AAPL | Stock | 136.63 | 136.8 | 136.63 | 136.8 | 9793.0 |
| 2023-01-18 07:35:00 | AAPL | Stock | 136.85 | 136.85 | 136.66 | 136.76 | 6096.0 |
| 2023-01-18 07:40:00 | AAPL | Stock | 136.75 | 136.86 | 136.69 | 136.86 | 9450.0 |
| 2023-01-18 07:45:00 | AAPL | Stock | 136.84 | 136.87 | 136.82 | 136.82 | 2446.0 |
| 2023-01-18 07:50:00 | AAPL | Stock | 136.84 | 136.85 | 136.8 | 136.8 | 2802.0 |
| 2023-01-18 07:55:00 | AAPL | Stock | 136.8 | 136.88 | 136.8 | 136.88 | 2305.0 |
| 2023-01-18 08:00:00 | AAPL | Stock | 136.5995 | 136.89 | 135.601 | 136.75 | 105463.0 |
| 2023-01-18 08:05:00 | AAPL | Stock | 136.74 | 136.75 | 136.67 | 136.68 | 19311.0 |
| 2023-01-18 08:10:00 | AAPL | Stock | 136.7 | 136.77 | 136.7 | 136.74 | 965.0 |
| 2023-01-18 08:15:00 | AAPL | Stock | 136.75 | 136.78 | 136.74 | 136.76 | 6573.0 |
| 2023-01-18 08:20:00 | AAPL | Stock | 136.75 | 136.75 | 136.68 | 136.68 | 8341.0 |
| 2023-01-18 08:25:00 | AAPL | Stock | 136.69 | 136.7961 | 136.46 | 136.7 | 25203.0 |
> showing 50 of 428,847 rows — these rows as CSV