PREVIEW / stock_30min / 2025-02-20
file: by_date/stock_30min/2025/2025-02-20.parquet size: 2.2 MB rows: 106,549 symbols: 518
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 |
|---|---|---|---|---|---|---|---|
| 2025-02-20 04:00:00 | AAPL | Stock | 243.98 | 244.28 | 243.79 | 243.84 | 12864.0 |
| 2025-02-20 04:30:00 | AAPL | Stock | 243.84 | 244.1 | 243.84 | 244.09 | 4621.0 |
| 2025-02-20 05:00:00 | AAPL | Stock | 244.11 | 244.13 | 244.04 | 244.05 | 861.0 |
| 2025-02-20 05:30:00 | AAPL | Stock | 244.07 | 244.23 | 244.0 | 244.1 | 4814.0 |
| 2025-02-20 06:00:00 | AAPL | Stock | 244.1 | 244.1 | 244.0 | 244.0 | 2479.0 |
| 2025-02-20 06:30:00 | AAPL | Stock | 243.89 | 244.0 | 243.86 | 243.91 | 2363.0 |
| 2025-02-20 07:00:00 | AAPL | Stock | 243.87 | 244.21 | 243.87 | 244.21 | 3997.0 |
| 2025-02-20 07:30:00 | AAPL | Stock | 244.22 | 244.57 | 244.22 | 244.5 | 5106.0 |
| 2025-02-20 08:00:00 | AAPL | Stock | 244.17 | 244.72 | 243.7 | 244.1 | 42746.0 |
| 2025-02-20 08:30:00 | AAPL | Stock | 244.18 | 244.87 | 243.5 | 243.78 | 75387.0 |
| 2025-02-20 09:00:00 | AAPL | Stock | 243.7967 | 244.99 | 243.77 | 244.98 | 60005.0 |
| 2025-02-20 09:30:00 | AAPL | Stock | 244.94 | 246.78 | 244.41 | 244.9 | 3591969.0 |
| 2025-02-20 10:00:00 | AAPL | Stock | 244.9 | 245.26 | 244.29 | 244.745 | 1763707.0 |
| 2025-02-20 10:30:00 | AAPL | Stock | 244.74 | 245.3539 | 244.59 | 245.07 | 1241313.0 |
| 2025-02-20 11:00:00 | AAPL | Stock | 245.11 | 246.7 | 245.08 | 246.1306 | 2104832.0 |
| 2025-02-20 11:30:00 | AAPL | Stock | 246.125 | 246.21 | 245.09 | 245.275 | 1967438.0 |
| 2025-02-20 12:00:00 | AAPL | Stock | 245.265 | 246.46 | 245.03 | 246.38 | 1302064.0 |
| 2025-02-20 12:30:00 | AAPL | Stock | 246.37 | 246.42 | 245.34 | 245.36 | 841968.0 |
| 2025-02-20 13:00:00 | AAPL | Stock | 245.369 | 245.8178 | 245.16 | 245.445 | 912129.0 |
| 2025-02-20 13:30:00 | AAPL | Stock | 245.44 | 245.59 | 245.02 | 245.3506 | 639057.0 |
| 2025-02-20 14:00:00 | AAPL | Stock | 245.33 | 245.58 | 245.17 | 245.255 | 633075.0 |
| 2025-02-20 14:30:00 | AAPL | Stock | 245.255 | 245.75 | 244.85 | 245.335 | 850085.0 |
| 2025-02-20 15:00:00 | AAPL | Stock | 245.33 | 245.7402 | 245.2724 | 245.61 | 902937.0 |
| 2025-02-20 15:30:00 | AAPL | Stock | 245.61 | 246.0 | 245.36 | 245.86 | 2334218.0 |
| 2025-02-20 16:00:00 | AAPL | Stock | 245.86 | 245.86 | 245.6 | 245.71 | 4435872.0 |
| 2025-02-20 16:30:00 | AAPL | Stock | 245.7 | 245.83 | 245.6619 | 245.67 | 24429.0 |
| 2025-02-20 17:00:00 | AAPL | Stock | 245.6703 | 245.7 | 245.5006 | 245.62 | 6145.0 |
| 2025-02-20 17:30:00 | AAPL | Stock | 245.63 | 245.6997 | 245.5566 | 245.6025 | 2075.0 |
| 2025-02-20 18:00:00 | AAPL | Stock | 245.65 | 245.7 | 245.56 | 245.58 | 6490.0 |
| 2025-02-20 18:30:00 | AAPL | Stock | 245.67 | 245.7 | 245.56 | 245.69 | 1833.0 |
| 2025-02-20 19:00:00 | AAPL | Stock | 245.69 | 245.7 | 245.6566 | 245.66 | 1685.0 |
| 2025-02-20 19:30:00 | AAPL | Stock | 245.65 | 245.67 | 245.5717 | 245.6 | 2552.0 |
| 2025-02-20 04:00:00 | MSFT | Stock | 415.91 | 419.0 | 415.5 | 418.35 | 21992.0 |
| 2025-02-20 04:30:00 | MSFT | Stock | 418.3 | 418.35 | 417.65 | 417.65 | 7280.0 |
| 2025-02-20 05:00:00 | MSFT | Stock | 417.7 | 418.85 | 417.7 | 417.98 | 9818.0 |
| 2025-02-20 05:30:00 | MSFT | Stock | 417.92 | 418.27 | 417.33 | 417.33 | 6372.0 |
| 2025-02-20 06:00:00 | MSFT | Stock | 417.3 | 417.3 | 416.9 | 417.0 | 9960.0 |
| 2025-02-20 06:30:00 | MSFT | Stock | 417.08 | 417.6 | 416.55 | 417.29 | 14179.0 |
| 2025-02-20 07:00:00 | MSFT | Stock | 417.03 | 417.03 | 414.9 | 415.4 | 34429.0 |
| 2025-02-20 07:30:00 | MSFT | Stock | 415.48 | 415.66 | 414.71 | 415.43 | 14022.0 |
| 2025-02-20 08:00:00 | MSFT | Stock | 415.4 | 417.8644 | 414.7 | 415.4994 | 62113.0 |
| 2025-02-20 08:30:00 | MSFT | Stock | 415.5 | 415.63 | 414.0296 | 414.47 | 48118.0 |
| 2025-02-20 09:00:00 | MSFT | Stock | 414.35 | 416.0 | 414.03 | 415.54 | 80006.0 |
| 2025-02-20 09:30:00 | MSFT | Stock | 415.69 | 417.3099 | 413.565 | 413.89 | 2639704.0 |
| 2025-02-20 10:00:00 | MSFT | Stock | 413.89 | 416.21 | 412.54 | 416.11 | 1260404.0 |
| 2025-02-20 10:30:00 | MSFT | Stock | 416.08 | 416.97 | 415.64 | 416.2 | 845207.0 |
| 2025-02-20 11:00:00 | MSFT | Stock | 416.21 | 419.31 | 416.05 | 417.9201 | 1947546.0 |
| 2025-02-20 11:30:00 | MSFT | Stock | 418.05 | 418.1 | 415.7 | 416.59 | 754662.0 |
| 2025-02-20 12:00:00 | MSFT | Stock | 416.605 | 418.38 | 416.29 | 417.67 | 588788.0 |
| 2025-02-20 12:30:00 | MSFT | Stock | 417.68 | 418.22 | 417.37 | 417.37 | 377053.0 |
> showing 50 of 106,549 rows — these rows as CSV