PREVIEW / stock_30min / 2025-02-21
file: by_date/stock_30min/2025/2025-02-21.parquet size: 2.2 MB rows: 106,677 symbols: 513
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-21 04:00:00 | AAPL | Stock | 245.55 | 245.55 | 245.15 | 245.49 | 4182.0 |
| 2025-02-21 04:30:00 | AAPL | Stock | 245.4 | 245.43 | 245.34 | 245.36 | 1141.0 |
| 2025-02-21 05:00:00 | AAPL | Stock | 245.36 | 245.36 | 245.25 | 245.31 | 2986.0 |
| 2025-02-21 05:30:00 | AAPL | Stock | 245.35 | 245.4 | 245.3 | 245.3 | 2372.0 |
| 2025-02-21 06:00:00 | AAPL | Stock | 245.36 | 245.39 | 245.36 | 245.39 | 400.0 |
| 2025-02-21 06:30:00 | AAPL | Stock | 245.39 | 245.42 | 245.38 | 245.38 | 1050.0 |
| 2025-02-21 07:00:00 | AAPL | Stock | 245.42 | 245.7 | 245.42 | 245.67 | 5220.0 |
| 2025-02-21 07:30:00 | AAPL | Stock | 245.71 | 245.81 | 245.68 | 245.75 | 3544.0 |
| 2025-02-21 08:00:00 | AAPL | Stock | 245.55 | 246.2 | 245.297 | 245.83 | 24867.0 |
| 2025-02-21 08:30:00 | AAPL | Stock | 245.8607 | 246.19 | 245.83 | 245.89 | 12962.0 |
| 2025-02-21 09:00:00 | AAPL | Stock | 245.94 | 246.9 | 245.27 | 246.07 | 99631.0 |
| 2025-02-21 09:30:00 | AAPL | Stock | 246.01 | 246.94 | 245.45 | 245.69 | 4392948.0 |
| 2025-02-21 10:00:00 | AAPL | Stock | 245.64 | 246.01 | 245.22 | 245.78 | 1420314.0 |
| 2025-02-21 10:30:00 | AAPL | Stock | 245.775 | 245.95 | 245.22 | 245.83 | 1025644.0 |
| 2025-02-21 11:00:00 | AAPL | Stock | 245.815 | 247.45 | 245.815 | 247.13 | 2979744.0 |
| 2025-02-21 11:30:00 | AAPL | Stock | 247.145 | 247.5 | 246.65 | 247.015 | 1573313.0 |
| 2025-02-21 12:00:00 | AAPL | Stock | 247.02 | 247.65 | 246.9 | 247.37 | 1257927.0 |
| 2025-02-21 12:30:00 | AAPL | Stock | 247.38 | 248.69 | 247.2 | 248.43 | 2637496.0 |
| 2025-02-21 13:00:00 | AAPL | Stock | 248.45 | 248.49 | 247.1 | 247.43 | 2246765.0 |
| 2025-02-21 13:30:00 | AAPL | Stock | 247.4451 | 248.0767 | 247.04 | 247.74 | 1338724.0 |
| 2025-02-21 14:00:00 | AAPL | Stock | 247.75 | 247.87 | 246.43 | 246.5 | 1516797.0 |
| 2025-02-21 14:30:00 | AAPL | Stock | 246.5 | 246.83 | 245.632 | 245.92 | 2452082.0 |
| 2025-02-21 15:00:00 | AAPL | Stock | 245.91 | 246.009 | 245.3901 | 245.8 | 2011809.0 |
| 2025-02-21 15:30:00 | AAPL | Stock | 245.81 | 246.09 | 245.33 | 245.59 | 3954037.0 |
| 2025-02-21 16:00:00 | AAPL | Stock | 245.59 | 246.1 | 245.43 | 245.53 | 7640040.0 |
| 2025-02-21 16:30:00 | AAPL | Stock | 245.54 | 245.55 | 245.3 | 245.301 | 42123.0 |
| 2025-02-21 17:00:00 | AAPL | Stock | 245.3 | 245.3 | 245.11 | 245.13 | 12184.0 |
| 2025-02-21 17:30:00 | AAPL | Stock | 245.1202 | 245.55 | 245.0 | 245.3 | 32139.0 |
| 2025-02-21 18:00:00 | AAPL | Stock | 245.3 | 245.34 | 245.09 | 245.2169 | 4225.0 |
| 2025-02-21 18:30:00 | AAPL | Stock | 245.38 | 245.5 | 245.21 | 245.21 | 6165.0 |
| 2025-02-21 19:00:00 | AAPL | Stock | 245.18 | 245.2353 | 245.0912 | 245.1483 | 6060.0 |
| 2025-02-21 19:30:00 | AAPL | Stock | 245.1 | 245.1975 | 245.0 | 245.0 | 12268.0 |
| 2025-02-21 04:00:00 | MSFT | Stock | 416.13 | 417.4 | 416.13 | 417.3 | 3102.0 |
| 2025-02-21 04:30:00 | MSFT | Stock | 417.34 | 417.53 | 417.31 | 417.4 | 2215.0 |
| 2025-02-21 05:00:00 | MSFT | Stock | 417.4 | 417.49 | 417.23 | 417.48 | 3253.0 |
| 2025-02-21 05:30:00 | MSFT | Stock | 417.5 | 417.58 | 417.07 | 417.07 | 1601.0 |
| 2025-02-21 06:00:00 | MSFT | Stock | 417.18 | 417.43 | 417.18 | 417.23 | 838.0 |
| 2025-02-21 06:30:00 | MSFT | Stock | 417.32 | 417.32 | 417.23 | 417.26 | 1917.0 |
| 2025-02-21 07:00:00 | MSFT | Stock | 417.33 | 417.73 | 417.28 | 417.61 | 7917.0 |
| 2025-02-21 07:30:00 | MSFT | Stock | 417.63 | 417.8 | 417.52 | 417.61 | 1747.0 |
| 2025-02-21 08:00:00 | MSFT | Stock | 417.55 | 417.8 | 416.0 | 417.68 | 26268.0 |
| 2025-02-21 08:30:00 | MSFT | Stock | 417.7379 | 417.74 | 417.48 | 417.67 | 10710.0 |
| 2025-02-21 09:00:00 | MSFT | Stock | 417.67 | 418.25 | 416.78 | 417.26 | 31064.0 |
| 2025-02-21 09:30:00 | MSFT | Stock | 417.26 | 418.048 | 414.82 | 414.82 | 2296457.0 |
| 2025-02-21 10:00:00 | MSFT | Stock | 414.83 | 415.425 | 412.89 | 413.29 | 805459.0 |
| 2025-02-21 10:30:00 | MSFT | Stock | 413.29 | 413.88 | 412.27 | 413.88 | 789931.0 |
| 2025-02-21 11:00:00 | MSFT | Stock | 413.86 | 414.549 | 413.25 | 413.54 | 503653.0 |
| 2025-02-21 11:30:00 | MSFT | Stock | 413.585 | 414.09 | 413.11 | 413.54 | 462209.0 |
| 2025-02-21 12:00:00 | MSFT | Stock | 413.5391 | 414.29 | 412.71 | 413.29 | 446861.0 |
| 2025-02-21 12:30:00 | MSFT | Stock | 413.29 | 413.45 | 412.478 | 412.55 | 712715.0 |
> showing 50 of 106,677 rows — these rows as CSV