PREVIEW / stock_30min / 2025-03-31
file: by_date/stock_30min/2025/2025-03-31.parquet size: 2.2 MB rows: 107,485 symbols: 468
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-03-31 04:00:00 | AAPL | Stock | 215.74 | 216.85 | 215.58 | 215.68 | 18300.0 |
| 2025-03-31 04:30:00 | AAPL | Stock | 215.79 | 216.12 | 215.0 | 215.93 | 15967.0 |
| 2025-03-31 05:00:00 | AAPL | Stock | 215.78 | 216.22 | 215.38 | 216.22 | 7654.0 |
| 2025-03-31 05:30:00 | AAPL | Stock | 216.2 | 216.32 | 215.82 | 216.0 | 8050.0 |
| 2025-03-31 06:00:00 | AAPL | Stock | 216.07 | 216.6 | 216.05 | 216.6 | 9213.0 |
| 2025-03-31 06:30:00 | AAPL | Stock | 216.73 | 216.75 | 216.05 | 216.32 | 24263.0 |
| 2025-03-31 07:00:00 | AAPL | Stock | 216.27 | 216.66 | 215.9 | 216.01 | 30783.0 |
| 2025-03-31 07:30:00 | AAPL | Stock | 216.08 | 216.79 | 216.0 | 216.71 | 31255.0 |
| 2025-03-31 08:00:00 | AAPL | Stock | 216.25 | 217.9 | 215.33 | 216.44 | 124468.0 |
| 2025-03-31 08:30:00 | AAPL | Stock | 216.4999 | 217.26 | 216.1775 | 217.1091 | 60270.0 |
| 2025-03-31 09:00:00 | AAPL | Stock | 217.11 | 217.25 | 215.5 | 217.2 | 200697.0 |
| 2025-03-31 09:30:00 | AAPL | Stock | 217.2 | 218.5 | 216.23 | 217.11 | 7050056.0 |
| 2025-03-31 10:00:00 | AAPL | Stock | 217.14 | 219.31 | 217.01 | 218.57 | 2803647.0 |
| 2025-03-31 10:30:00 | AAPL | Stock | 218.6 | 219.69 | 218.3256 | 219.25 | 1810222.0 |
| 2025-03-31 11:00:00 | AAPL | Stock | 219.28 | 220.08 | 218.9393 | 219.13 | 2075656.0 |
| 2025-03-31 11:30:00 | AAPL | Stock | 219.1 | 220.58 | 218.8852 | 220.35 | 1423769.0 |
| 2025-03-31 12:00:00 | AAPL | Stock | 220.36 | 220.93 | 219.56 | 220.92 | 1361616.0 |
| 2025-03-31 12:30:00 | AAPL | Stock | 220.9 | 221.02 | 220.085 | 220.1 | 1076397.0 |
| 2025-03-31 13:00:00 | AAPL | Stock | 220.09 | 220.76 | 219.39 | 219.87 | 1045365.0 |
| 2025-03-31 13:30:00 | AAPL | Stock | 219.85 | 220.25 | 219.24 | 219.49 | 924150.0 |
| 2025-03-31 14:00:00 | AAPL | Stock | 219.49 | 220.89 | 219.455 | 220.795 | 1106751.0 |
| 2025-03-31 14:30:00 | AAPL | Stock | 220.8 | 221.21 | 220.39 | 220.58 | 1383903.0 |
| 2025-03-31 15:00:00 | AAPL | Stock | 220.57 | 221.735 | 220.55 | 221.225 | 1675822.0 |
| 2025-03-31 15:30:00 | AAPL | Stock | 221.21 | 225.62 | 220.9901 | 221.995 | 8902712.0 |
| 2025-03-31 16:00:00 | AAPL | Stock | 222.13 | 222.99 | 221.45 | 221.79 | 15748065.0 |
| 2025-03-31 16:30:00 | AAPL | Stock | 221.79 | 222.13 | 221.52 | 221.7404 | 86361.0 |
| 2025-03-31 17:00:00 | AAPL | Stock | 221.7996 | 221.8 | 221.48 | 221.5 | 14869.0 |
| 2025-03-31 17:30:00 | AAPL | Stock | 221.42 | 222.13 | 221.42 | 221.51 | 23893.0 |
| 2025-03-31 18:00:00 | AAPL | Stock | 221.51 | 221.55 | 220.81 | 221.19 | 9171.0 |
| 2025-03-31 18:30:00 | AAPL | Stock | 221.1991 | 221.49 | 221.16 | 221.2836 | 6476.0 |
| 2025-03-31 19:00:00 | AAPL | Stock | 221.33 | 221.7 | 221.25 | 221.25 | 6459.0 |
| 2025-03-31 19:30:00 | AAPL | Stock | 221.3 | 221.3 | 221.08 | 221.1999 | 9228.0 |
| 2025-03-31 04:00:00 | MSFT | Stock | 373.94 | 376.41 | 373.94 | 374.74 | 6426.0 |
| 2025-03-31 04:30:00 | MSFT | Stock | 374.53 | 374.53 | 373.27 | 373.42 | 4127.0 |
| 2025-03-31 05:00:00 | MSFT | Stock | 372.53 | 373.35 | 372.37 | 373.19 | 5038.0 |
| 2025-03-31 05:30:00 | MSFT | Stock | 373.0 | 373.27 | 372.48 | 372.52 | 2572.0 |
| 2025-03-31 06:00:00 | MSFT | Stock | 372.52 | 372.88 | 372.25 | 372.88 | 9129.0 |
| 2025-03-31 06:30:00 | MSFT | Stock | 372.81 | 373.4 | 372.78 | 373.22 | 3687.0 |
| 2025-03-31 07:00:00 | MSFT | Stock | 373.42 | 374.05 | 372.67 | 372.74 | 10420.0 |
| 2025-03-31 07:30:00 | MSFT | Stock | 372.75 | 372.75 | 372.36 | 372.6 | 15648.0 |
| 2025-03-31 08:00:00 | MSFT | Stock | 373.51 | 375.01 | 372.18 | 373.4571 | 45050.0 |
| 2025-03-31 08:30:00 | MSFT | Stock | 373.59 | 377.853 | 373.12 | 374.0 | 10855.0 |
| 2025-03-31 09:00:00 | MSFT | Stock | 374.0 | 374.0 | 371.55 | 372.67 | 35701.0 |
| 2025-03-31 09:30:00 | MSFT | Stock | 372.67 | 373.14 | 368.29 | 370.44 | 2876334.0 |
| 2025-03-31 10:00:00 | MSFT | Stock | 370.465 | 371.1 | 367.63 | 367.834 | 1130052.0 |
| 2025-03-31 10:30:00 | MSFT | Stock | 367.795 | 369.41 | 367.24 | 368.1 | 906786.0 |
| 2025-03-31 11:00:00 | MSFT | Stock | 368.11 | 369.97 | 367.7 | 369.34 | 802516.0 |
| 2025-03-31 11:30:00 | MSFT | Stock | 369.28 | 371.8 | 368.91 | 370.96 | 812450.0 |
| 2025-03-31 12:00:00 | MSFT | Stock | 370.9336 | 372.0 | 370.17 | 371.99 | 424565.0 |
| 2025-03-31 12:30:00 | MSFT | Stock | 371.9892 | 372.1799 | 369.78 | 369.84 | 538938.0 |
> showing 50 of 107,485 rows — these rows as CSV