PREVIEW / stock_30min / 2024-01-26
file: by_date/stock_30min/2024/2024-01-26.parquet size: 2.0 MB rows: 96,630 symbols: 1,165
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-26 04:00:00 | AAPL | Stock | 193.31 | 193.69 | 193.07 | 193.67 | 10231.0 |
| 2024-01-26 04:30:00 | AAPL | Stock | 193.54 | 193.91 | 193.51 | 193.9 | 8644.0 |
| 2024-01-26 05:00:00 | AAPL | Stock | 193.9 | 194.17 | 193.9 | 194.1 | 11797.0 |
| 2024-01-26 05:30:00 | AAPL | Stock | 194.1 | 194.16 | 194.0 | 194.0 | 2867.0 |
| 2024-01-26 06:00:00 | AAPL | Stock | 194.02 | 194.15 | 193.79 | 194.15 | 4436.0 |
| 2024-01-26 06:30:00 | AAPL | Stock | 194.16 | 194.35 | 194.13 | 194.35 | 11852.0 |
| 2024-01-26 07:00:00 | AAPL | Stock | 194.35 | 194.5 | 194.2 | 194.43 | 18684.0 |
| 2024-01-26 07:30:00 | AAPL | Stock | 194.42 | 194.7 | 194.38 | 194.5 | 17025.0 |
| 2024-01-26 08:00:00 | AAPL | Stock | 194.37 | 194.7 | 193.0 | 194.6 | 61682.0 |
| 2024-01-26 08:30:00 | AAPL | Stock | 194.62 | 194.8599 | 194.25 | 194.38 | 123922.0 |
| 2024-01-26 09:00:00 | AAPL | Stock | 194.28 | 194.35 | 193.8 | 194.23 | 121438.0 |
| 2024-01-26 09:30:00 | AAPL | Stock | 194.26 | 194.65 | 193.75 | 194.615 | 3949999.0 |
| 2024-01-26 10:00:00 | AAPL | Stock | 194.64 | 194.76 | 194.19 | 194.685 | 2288770.0 |
| 2024-01-26 10:30:00 | AAPL | Stock | 194.69 | 194.745 | 194.36 | 194.525 | 1774192.0 |
| 2024-01-26 11:00:00 | AAPL | Stock | 194.52 | 194.57 | 194.37 | 194.39 | 1375629.0 |
| 2024-01-26 11:30:00 | AAPL | Stock | 194.4 | 194.475 | 193.91 | 194.0401 | 1677216.0 |
| 2024-01-26 12:00:00 | AAPL | Stock | 194.04 | 194.08 | 193.6 | 193.72 | 1451321.0 |
| 2024-01-26 12:30:00 | AAPL | Stock | 193.7001 | 193.71 | 192.46 | 192.4678 | 2933064.0 |
| 2024-01-26 13:00:00 | AAPL | Stock | 192.46 | 192.76 | 192.27 | 192.66 | 1794717.0 |
| 2024-01-26 13:30:00 | AAPL | Stock | 192.66 | 192.73 | 192.27 | 192.451 | 1531012.0 |
| 2024-01-26 14:00:00 | AAPL | Stock | 192.455 | 192.65 | 192.34 | 192.4751 | 1244839.0 |
| 2024-01-26 14:30:00 | AAPL | Stock | 192.48 | 192.97 | 192.37 | 192.91 | 1348120.0 |
| 2024-01-26 15:00:00 | AAPL | Stock | 192.92 | 192.975 | 192.34 | 192.425 | 1535228.0 |
| 2024-01-26 15:30:00 | AAPL | Stock | 192.425 | 192.59 | 191.94 | 192.42 | 5875180.0 |
| 2024-01-26 16:00:00 | AAPL | Stock | 192.42 | 192.45 | 192.02 | 192.3 | 6863830.0 |
| 2024-01-26 16:30:00 | AAPL | Stock | 192.3 | 192.42 | 192.19 | 192.29 | 141379.0 |
| 2024-01-26 17:00:00 | AAPL | Stock | 192.28 | 192.3 | 192.18 | 192.3 | 23086.0 |
| 2024-01-26 17:30:00 | AAPL | Stock | 192.3 | 192.3 | 192.2 | 192.24 | 13092.0 |
| 2024-01-26 18:00:00 | AAPL | Stock | 192.21 | 192.24 | 192.21 | 192.22 | 14755.0 |
| 2024-01-26 18:30:00 | AAPL | Stock | 192.22 | 192.2731 | 192.1 | 192.1001 | 6743.0 |
| 2024-01-26 19:00:00 | AAPL | Stock | 192.19 | 192.3 | 192.15 | 192.3 | 8325.0 |
| 2024-01-26 19:30:00 | AAPL | Stock | 192.3 | 192.31 | 192.2 | 192.28 | 10695.0 |
| 2024-01-26 04:00:00 | MSFT | Stock | 401.12 | 402.52 | 401.12 | 402.5 | 1356.0 |
| 2024-01-26 04:30:00 | MSFT | Stock | 402.63 | 403.28 | 402.57 | 403.14 | 2343.0 |
| 2024-01-26 05:00:00 | MSFT | Stock | 403.39 | 403.5 | 403.18 | 403.5 | 630.0 |
| 2024-01-26 05:30:00 | MSFT | Stock | 403.4 | 403.4 | 403.02 | 403.05 | 1771.0 |
| 2024-01-26 06:00:00 | MSFT | Stock | 403.0 | 403.0 | 403.0 | 403.0 | 1098.0 |
| 2024-01-26 06:30:00 | MSFT | Stock | 403.12 | 404.43 | 403.12 | 404.43 | 5014.0 |
| 2024-01-26 07:00:00 | MSFT | Stock | 404.03 | 404.61 | 403.99 | 404.48 | 2479.0 |
| 2024-01-26 07:30:00 | MSFT | Stock | 404.66 | 404.66 | 403.92 | 403.98 | 6052.0 |
| 2024-01-26 08:00:00 | MSFT | Stock | 404.3 | 404.7 | 401.65 | 403.31 | 15158.0 |
| 2024-01-26 08:30:00 | MSFT | Stock | 404.39 | 404.39 | 402.77 | 403.95 | 24145.0 |
| 2024-01-26 09:00:00 | MSFT | Stock | 403.85 | 404.37 | 403.0 | 404.2 | 19928.0 |
| 2024-01-26 09:30:00 | MSFT | Stock | 404.36 | 404.6 | 402.95 | 403.88 | 1569777.0 |
| 2024-01-26 10:00:00 | MSFT | Stock | 403.84 | 404.702 | 403.03 | 404.6406 | 945753.0 |
| 2024-01-26 10:30:00 | MSFT | Stock | 404.6 | 405.75 | 404.595 | 405.13 | 787288.0 |
| 2024-01-26 11:00:00 | MSFT | Stock | 405.116 | 405.64 | 405.08 | 405.345 | 528174.0 |
| 2024-01-26 11:30:00 | MSFT | Stock | 405.3 | 406.01 | 404.4479 | 405.67 | 652818.0 |
| 2024-01-26 12:00:00 | MSFT | Stock | 405.68 | 406.17 | 405.0 | 405.12 | 485568.0 |
| 2024-01-26 12:30:00 | MSFT | Stock | 405.1 | 405.1 | 402.69 | 403.3167 | 662850.0 |
> showing 50 of 96,630 rows — these rows as CSV