PREVIEW / stock_5min / 2024-03-12
file: by_date/stock_5min/2024/2024-03-12.parquet size: 6.8 MB rows: 408,913 symbols: 1,104
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-12 04:00:00 | AAPL | Stock | 173.5 | 173.86 | 173.5 | 173.86 | 1619.0 |
| 2024-03-12 04:05:00 | AAPL | Stock | 173.86 | 173.86 | 173.7 | 173.7 | 1468.0 |
| 2024-03-12 04:10:00 | AAPL | Stock | 173.65 | 173.65 | 173.5 | 173.54 | 1615.0 |
| 2024-03-12 04:20:00 | AAPL | Stock | 173.49 | 173.49 | 173.41 | 173.41 | 807.0 |
| 2024-03-12 04:25:00 | AAPL | Stock | 173.41 | 173.42 | 173.41 | 173.41 | 350.0 |
| 2024-03-12 04:30:00 | AAPL | Stock | 173.37 | 173.45 | 173.29 | 173.45 | 2909.0 |
| 2024-03-12 04:35:00 | AAPL | Stock | 173.45 | 173.45 | 173.43 | 173.43 | 242.0 |
| 2024-03-12 04:40:00 | AAPL | Stock | 173.46 | 173.46 | 173.46 | 173.46 | 769.0 |
| 2024-03-12 04:45:00 | AAPL | Stock | 173.45 | 173.45 | 173.45 | 173.45 | 417.0 |
| 2024-03-12 04:50:00 | AAPL | Stock | 173.46 | 173.46 | 173.45 | 173.45 | 919.0 |
| 2024-03-12 04:55:00 | AAPL | Stock | 173.3 | 173.3 | 173.3 | 173.3 | 154.0 |
| 2024-03-12 05:00:00 | AAPL | Stock | 173.3 | 173.33 | 173.3 | 173.33 | 2311.0 |
| 2024-03-12 05:05:00 | AAPL | Stock | 173.32 | 173.32 | 173.25 | 173.25 | 1100.0 |
| 2024-03-12 05:10:00 | AAPL | Stock | 173.25 | 173.25 | 173.24 | 173.24 | 774.0 |
| 2024-03-12 05:15:00 | AAPL | Stock | 173.2 | 173.2 | 173.0 | 173.0 | 1771.0 |
| 2024-03-12 05:20:00 | AAPL | Stock | 173.16 | 173.16 | 172.91 | 173.03 | 5228.0 |
| 2024-03-12 05:25:00 | AAPL | Stock | 173.03 | 173.07 | 173.0 | 173.07 | 3687.0 |
| 2024-03-12 05:35:00 | AAPL | Stock | 173.24 | 173.24 | 173.23 | 173.23 | 604.0 |
| 2024-03-12 05:40:00 | AAPL | Stock | 173.23 | 173.23 | 173.19 | 173.19 | 690.0 |
| 2024-03-12 05:45:00 | AAPL | Stock | 173.23 | 173.31 | 173.23 | 173.3 | 2311.0 |
| 2024-03-12 05:50:00 | AAPL | Stock | 173.33 | 173.49 | 173.33 | 173.42 | 818.0 |
| 2024-03-12 05:55:00 | AAPL | Stock | 173.42 | 173.42 | 173.36 | 173.36 | 363.0 |
| 2024-03-12 06:00:00 | AAPL | Stock | 173.3 | 173.35 | 173.3 | 173.35 | 1956.0 |
| 2024-03-12 06:05:00 | AAPL | Stock | 173.38 | 173.38 | 173.38 | 173.38 | 100.0 |
| 2024-03-12 06:10:00 | AAPL | Stock | 173.4 | 173.42 | 173.4 | 173.42 | 325.0 |
| 2024-03-12 06:15:00 | AAPL | Stock | 173.48 | 173.48 | 173.45 | 173.45 | 418.0 |
| 2024-03-12 06:20:00 | AAPL | Stock | 173.48 | 173.48 | 173.47 | 173.47 | 779.0 |
| 2024-03-12 06:30:00 | AAPL | Stock | 173.45 | 173.45 | 173.45 | 173.45 | 200.0 |
| 2024-03-12 06:35:00 | AAPL | Stock | 173.35 | 173.35 | 173.35 | 173.35 | 129.0 |
| 2024-03-12 06:40:00 | AAPL | Stock | 173.48 | 173.5 | 173.48 | 173.49 | 1449.0 |
| 2024-03-12 06:45:00 | AAPL | Stock | 173.5 | 173.5 | 173.48 | 173.49 | 4051.0 |
| 2024-03-12 06:50:00 | AAPL | Stock | 173.48 | 173.5 | 173.48 | 173.48 | 308.0 |
| 2024-03-12 06:55:00 | AAPL | Stock | 173.49 | 173.5 | 173.49 | 173.49 | 361.0 |
| 2024-03-12 07:00:00 | AAPL | Stock | 173.5 | 173.57 | 173.3 | 173.39 | 7516.0 |
| 2024-03-12 07:05:00 | AAPL | Stock | 173.37 | 173.39 | 173.3 | 173.31 | 4866.0 |
| 2024-03-12 07:10:00 | AAPL | Stock | 173.36 | 173.38 | 173.35 | 173.35 | 4065.0 |
| 2024-03-12 07:15:00 | AAPL | Stock | 173.39 | 173.4 | 173.39 | 173.39 | 1804.0 |
| 2024-03-12 07:20:00 | AAPL | Stock | 173.4 | 173.41 | 173.38 | 173.39 | 1754.0 |
| 2024-03-12 07:25:00 | AAPL | Stock | 173.4 | 173.5 | 173.39 | 173.47 | 3759.0 |
| 2024-03-12 07:30:00 | AAPL | Stock | 173.45 | 173.45 | 173.43 | 173.43 | 320.0 |
| 2024-03-12 07:35:00 | AAPL | Stock | 173.4 | 173.41 | 173.38 | 173.41 | 1314.0 |
| 2024-03-12 07:40:00 | AAPL | Stock | 173.38 | 173.38 | 173.37 | 173.37 | 436.0 |
| 2024-03-12 07:45:00 | AAPL | Stock | 173.36 | 173.36 | 173.36 | 173.36 | 229.0 |
| 2024-03-12 07:55:00 | AAPL | Stock | 173.39 | 173.41 | 173.37 | 173.37 | 942.0 |
| 2024-03-12 08:00:00 | AAPL | Stock | 173.43 | 173.95 | 173.17 | 173.7 | 30413.0 |
| 2024-03-12 08:05:00 | AAPL | Stock | 173.77 | 173.9 | 173.22 | 173.3 | 8086.0 |
| 2024-03-12 08:10:00 | AAPL | Stock | 173.3101 | 173.36 | 173.2822 | 173.2822 | 1400.0 |
| 2024-03-12 08:15:00 | AAPL | Stock | 173.3 | 173.39 | 173.29 | 173.39 | 13179.0 |
| 2024-03-12 08:20:00 | AAPL | Stock | 173.39 | 173.39 | 173.35 | 173.38 | 3231.0 |
| 2024-03-12 08:25:00 | AAPL | Stock | 173.38 | 173.59 | 173.35 | 173.47 | 22157.0 |
> showing 50 of 408,913 rows — these rows as CSV