PREVIEW / stock_30min / 2025-10-20
file: by_date/stock_30min/2025/2025-10-20.parquet size: 2.3 MB rows: 110,868 symbols: 226
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-10-20 04:00:00 | AAPL | Stock | 253.57 | 253.67 | 253.16 | 253.29 | 23704.0 |
| 2025-10-20 04:30:00 | AAPL | Stock | 253.15 | 253.42 | 253.11 | 253.31 | 4984.0 |
| 2025-10-20 05:00:00 | AAPL | Stock | 253.15 | 253.32 | 253.0 | 253.22 | 6803.0 |
| 2025-10-20 05:30:00 | AAPL | Stock | 253.2 | 253.52 | 253.12 | 253.52 | 2858.0 |
| 2025-10-20 06:00:00 | AAPL | Stock | 253.44 | 253.6 | 253.0 | 253.3 | 10735.0 |
| 2025-10-20 06:30:00 | AAPL | Stock | 253.39 | 256.06 | 253.27 | 254.7 | 74673.0 |
| 2025-10-20 07:00:00 | AAPL | Stock | 254.6 | 255.84 | 254.3 | 255.84 | 74573.0 |
| 2025-10-20 07:30:00 | AAPL | Stock | 255.76 | 256.25 | 255.58 | 256.1 | 73088.0 |
| 2025-10-20 08:00:00 | AAPL | Stock | 254.6 | 256.68 | 251.66 | 256.59 | 221726.0 |
| 2025-10-20 08:30:00 | AAPL | Stock | 256.5468 | 256.96 | 256.5468 | 256.79 | 148849.0 |
| 2025-10-20 09:00:00 | AAPL | Stock | 256.7989 | 257.64 | 255.42 | 255.82 | 423944.0 |
| 2025-10-20 09:30:00 | AAPL | Stock | 255.885 | 259.87 | 255.63 | 258.9775 | 9372007.0 |
| 2025-10-20 10:00:00 | AAPL | Stock | 259.0 | 259.77 | 258.0702 | 259.505 | 4269646.0 |
| 2025-10-20 10:30:00 | AAPL | Stock | 259.49 | 261.63 | 259.07 | 261.57 | 6619471.0 |
| 2025-10-20 11:00:00 | AAPL | Stock | 261.58 | 263.55 | 261.52 | 262.57 | 6421946.0 |
| 2025-10-20 11:30:00 | AAPL | Stock | 262.55 | 264.375 | 262.4175 | 263.31 | 5438431.0 |
| 2025-10-20 12:00:00 | AAPL | Stock | 263.32 | 264.23 | 262.8101 | 263.49 | 3973071.0 |
| 2025-10-20 12:30:00 | AAPL | Stock | 263.48 | 263.7 | 262.65 | 263.62 | 3271142.0 |
| 2025-10-20 13:00:00 | AAPL | Stock | 263.6101 | 264.22 | 262.8809 | 263.165 | 2888834.0 |
| 2025-10-20 13:30:00 | AAPL | Stock | 263.165 | 263.39 | 262.826 | 262.925 | 1518679.0 |
| 2025-10-20 14:00:00 | AAPL | Stock | 262.92 | 263.83 | 262.79 | 263.73 | 1823240.0 |
| 2025-10-20 14:30:00 | AAPL | Stock | 263.74 | 263.755 | 263.04 | 263.28 | 1604551.0 |
| 2025-10-20 15:00:00 | AAPL | Stock | 263.3 | 263.81 | 263.2006 | 263.42 | 2052806.0 |
| 2025-10-20 15:30:00 | AAPL | Stock | 263.44 | 263.86 | 261.93 | 262.23 | 6062612.0 |
| 2025-10-20 16:00:00 | AAPL | Stock | 262.24 | 262.85 | 262.11 | 262.75 | 7717771.0 |
| 2025-10-20 16:30:00 | AAPL | Stock | 262.6088 | 262.7512 | 262.24 | 262.45 | 62951.0 |
| 2025-10-20 17:00:00 | AAPL | Stock | 262.43 | 262.68 | 262.43 | 262.6 | 40393.0 |
| 2025-10-20 17:30:00 | AAPL | Stock | 262.5999 | 262.65 | 262.24 | 262.65 | 128392.0 |
| 2025-10-20 18:00:00 | AAPL | Stock | 262.64 | 262.93 | 262.24 | 262.85 | 26690.0 |
| 2025-10-20 18:30:00 | AAPL | Stock | 262.89 | 262.904 | 262.5 | 262.7581 | 26720.0 |
| 2025-10-20 19:00:00 | AAPL | Stock | 262.76 | 262.9229 | 262.56 | 262.68 | 17273.0 |
| 2025-10-20 19:30:00 | AAPL | Stock | 262.77 | 262.8 | 262.55 | 262.6 | 22900.0 |
| 2025-10-20 04:00:00 | MSFT | Stock | 514.0 | 515.5 | 514.0 | 515.5 | 1381.0 |
| 2025-10-20 04:30:00 | MSFT | Stock | 515.68 | 516.0 | 515.68 | 516.0 | 2757.0 |
| 2025-10-20 05:00:00 | MSFT | Stock | 515.49 | 515.5 | 515.04 | 515.5 | 639.0 |
| 2025-10-20 05:30:00 | MSFT | Stock | 515.35 | 515.35 | 515.1 | 515.1 | 539.0 |
| 2025-10-20 06:00:00 | MSFT | Stock | 514.67 | 514.67 | 514.67 | 514.67 | 100.0 |
| 2025-10-20 06:30:00 | MSFT | Stock | 514.8 | 514.8 | 513.43 | 513.44 | 6656.0 |
| 2025-10-20 07:00:00 | MSFT | Stock | 513.38 | 513.71 | 513.0 | 513.71 | 2376.0 |
| 2025-10-20 07:30:00 | MSFT | Stock | 513.6 | 514.2 | 513.4 | 514.2 | 1251.0 |
| 2025-10-20 08:00:00 | MSFT | Stock | 513.44 | 516.2 | 513.0 | 513.2 | 9893.0 |
| 2025-10-20 08:30:00 | MSFT | Stock | 513.4 | 514.5 | 513.25 | 514.5 | 10173.0 |
| 2025-10-20 09:00:00 | MSFT | Stock | 514.35 | 515.4 | 514.35 | 514.66 | 9257.0 |
| 2025-10-20 09:30:00 | MSFT | Stock | 514.61 | 516.04 | 513.43 | 514.476 | 905442.0 |
| 2025-10-20 10:00:00 | MSFT | Stock | 514.47 | 516.91 | 514.25 | 516.48 | 675967.0 |
| 2025-10-20 10:30:00 | MSFT | Stock | 516.47 | 518.7 | 515.98 | 518.085 | 610627.0 |
| 2025-10-20 11:00:00 | MSFT | Stock | 518.09 | 518.4355 | 516.76 | 517.2424 | 328404.0 |
| 2025-10-20 11:30:00 | MSFT | Stock | 517.26 | 517.8036 | 516.81 | 517.3599 | 342875.0 |
| 2025-10-20 12:00:00 | MSFT | Stock | 517.29 | 517.37 | 516.3 | 516.63 | 270635.0 |
| 2025-10-20 12:30:00 | MSFT | Stock | 516.655 | 516.73 | 516.04 | 516.49 | 192356.0 |
> showing 50 of 110,868 rows — these rows as CSV