PREVIEW / stock_30min / 2025-04-02
file: by_date/stock_30min/2025/2025-04-02.parquet size: 2.2 MB rows: 106,695 symbols: 454
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-04-02 04:00:00 | AAPL | Stock | 222.82 | 222.82 | 222.08 | 222.34 | 5731.0 |
| 2025-04-02 04:30:00 | AAPL | Stock | 222.48 | 222.63 | 222.26 | 222.26 | 4734.0 |
| 2025-04-02 05:00:00 | AAPL | Stock | 222.45 | 222.51 | 222.18 | 222.35 | 2457.0 |
| 2025-04-02 05:30:00 | AAPL | Stock | 222.3 | 222.39 | 222.25 | 222.25 | 743.0 |
| 2025-04-02 06:00:00 | AAPL | Stock | 222.2 | 222.22 | 221.49 | 222.1 | 13995.0 |
| 2025-04-02 06:30:00 | AAPL | Stock | 221.92 | 222.0 | 221.74 | 221.91 | 6504.0 |
| 2025-04-02 07:00:00 | AAPL | Stock | 221.96 | 222.55 | 221.89 | 222.43 | 10511.0 |
| 2025-04-02 07:30:00 | AAPL | Stock | 222.43 | 222.43 | 221.86 | 221.87 | 8886.0 |
| 2025-04-02 08:00:00 | AAPL | Stock | 222.3 | 222.85 | 221.14 | 221.14 | 47174.0 |
| 2025-04-02 08:30:00 | AAPL | Stock | 221.11 | 221.72 | 221.11 | 221.45 | 16219.0 |
| 2025-04-02 09:00:00 | AAPL | Stock | 221.61 | 221.61 | 220.6 | 221.19 | 63751.0 |
| 2025-04-02 09:30:00 | AAPL | Stock | 221.35 | 223.0 | 221.02 | 222.84 | 2484328.0 |
| 2025-04-02 10:00:00 | AAPL | Stock | 222.83 | 224.1085 | 222.49 | 224.04 | 1713176.0 |
| 2025-04-02 10:30:00 | AAPL | Stock | 224.03 | 224.46 | 223.655 | 224.35 | 1565562.0 |
| 2025-04-02 11:00:00 | AAPL | Stock | 224.35 | 224.7154 | 223.45 | 224.48 | 1331832.0 |
| 2025-04-02 11:30:00 | AAPL | Stock | 224.47 | 224.6 | 223.1 | 223.685 | 1124246.0 |
| 2025-04-02 12:00:00 | AAPL | Stock | 223.69 | 224.15 | 223.62 | 224.13 | 852138.0 |
| 2025-04-02 12:30:00 | AAPL | Stock | 224.13 | 224.9578 | 223.93 | 224.68 | 1195316.0 |
| 2025-04-02 13:00:00 | AAPL | Stock | 224.7 | 225.19 | 224.58 | 224.72 | 1562792.0 |
| 2025-04-02 13:30:00 | AAPL | Stock | 224.72 | 224.81 | 223.97 | 224.1903 | 914646.0 |
| 2025-04-02 14:00:00 | AAPL | Stock | 224.18 | 224.28 | 222.91 | 222.92 | 848105.0 |
| 2025-04-02 14:30:00 | AAPL | Stock | 222.93 | 223.941 | 222.86 | 222.92 | 1179218.0 |
| 2025-04-02 15:00:00 | AAPL | Stock | 222.9453 | 223.81 | 222.945 | 223.6601 | 819779.0 |
| 2025-04-02 15:30:00 | AAPL | Stock | 223.67 | 224.46 | 223.5 | 223.8 | 3059641.0 |
| 2025-04-02 16:00:00 | AAPL | Stock | 223.89 | 225.5 | 218.5 | 218.53 | 5480390.0 |
| 2025-04-02 16:30:00 | AAPL | Stock | 218.5 | 223.89 | 211.32 | 212.73 | 953386.0 |
| 2025-04-02 17:00:00 | AAPL | Stock | 212.7 | 213.25 | 208.92 | 210.0 | 595920.0 |
| 2025-04-02 17:30:00 | AAPL | Stock | 210.14 | 211.8 | 208.3587 | 208.6 | 402331.0 |
| 2025-04-02 18:00:00 | AAPL | Stock | 208.68 | 209.0 | 206.15 | 208.5 | 399981.0 |
| 2025-04-02 18:30:00 | AAPL | Stock | 208.52 | 209.2 | 207.9 | 208.63 | 157245.0 |
| 2025-04-02 19:00:00 | AAPL | Stock | 208.71 | 208.71 | 206.56 | 207.0 | 142626.0 |
| 2025-04-02 19:30:00 | AAPL | Stock | 206.8 | 208.24 | 206.8 | 207.91 | 131067.0 |
| 2025-04-02 04:00:00 | MSFT | Stock | 380.5 | 380.94 | 379.58 | 380.94 | 9753.0 |
| 2025-04-02 04:30:00 | MSFT | Stock | 380.84 | 380.99 | 380.0 | 380.26 | 2161.0 |
| 2025-04-02 05:00:00 | MSFT | Stock | 380.34 | 380.34 | 380.14 | 380.14 | 274.0 |
| 2025-04-02 05:30:00 | MSFT | Stock | 380.2 | 380.2 | 380.2 | 380.2 | 200.0 |
| 2025-04-02 06:00:00 | MSFT | Stock | 380.3 | 380.74 | 379.26 | 379.77 | 3768.0 |
| 2025-04-02 06:30:00 | MSFT | Stock | 380.2 | 380.25 | 379.97 | 379.97 | 1507.0 |
| 2025-04-02 07:00:00 | MSFT | Stock | 379.97 | 380.5 | 379.5 | 380.34 | 4493.0 |
| 2025-04-02 07:30:00 | MSFT | Stock | 380.07 | 380.07 | 379.65 | 379.65 | 1869.0 |
| 2025-04-02 08:00:00 | MSFT | Stock | 380.07 | 381.02 | 377.43 | 377.43 | 15132.0 |
| 2025-04-02 08:30:00 | MSFT | Stock | 377.4 | 378.5 | 377.4 | 378.5 | 17202.0 |
| 2025-04-02 09:00:00 | MSFT | Stock | 378.31 | 378.5 | 376.12 | 377.66 | 12087.0 |
| 2025-04-02 09:30:00 | MSFT | Stock | 377.95 | 383.0 | 376.62 | 381.38 | 1186782.0 |
| 2025-04-02 10:00:00 | MSFT | Stock | 381.1 | 382.47 | 379.165 | 381.495 | 592175.0 |
| 2025-04-02 10:30:00 | MSFT | Stock | 381.47 | 382.07 | 381.0 | 381.76 | 400255.0 |
| 2025-04-02 11:00:00 | MSFT | Stock | 381.785 | 382.67 | 380.88 | 382.46 | 503362.0 |
| 2025-04-02 11:30:00 | MSFT | Stock | 382.39 | 382.5599 | 380.24 | 381.295 | 422602.0 |
| 2025-04-02 12:00:00 | MSFT | Stock | 381.31 | 383.27 | 381.17 | 383.24 | 334121.0 |
| 2025-04-02 12:30:00 | MSFT | Stock | 383.255 | 384.38 | 382.46 | 384.08 | 347549.0 |
> showing 50 of 106,695 rows — these rows as CSV