PREVIEW / stock_30min / 2024-11-20
file: by_date/stock_30min/2024/2024-11-20.parquet size: 2.1 MB rows: 102,996 symbols: 702
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-20 04:00:00 | AAPL | Stock | 227.83 | 228.25 | 227.8 | 228.13 | 6013.0 |
| 2024-11-20 04:30:00 | AAPL | Stock | 228.07 | 228.07 | 227.76 | 227.76 | 4350.0 |
| 2024-11-20 05:00:00 | AAPL | Stock | 227.79 | 228.01 | 227.7 | 227.7 | 2348.0 |
| 2024-11-20 05:30:00 | AAPL | Stock | 227.5 | 227.76 | 227.5 | 227.63 | 2313.0 |
| 2024-11-20 06:00:00 | AAPL | Stock | 227.78 | 227.85 | 227.72 | 227.75 | 2760.0 |
| 2024-11-20 06:30:00 | AAPL | Stock | 227.8 | 227.8 | 227.64 | 227.71 | 5237.0 |
| 2024-11-20 07:00:00 | AAPL | Stock | 227.76 | 228.35 | 227.76 | 228.16 | 12645.0 |
| 2024-11-20 07:30:00 | AAPL | Stock | 228.15 | 228.47 | 228.15 | 228.47 | 15093.0 |
| 2024-11-20 08:00:00 | AAPL | Stock | 227.88 | 228.71 | 227.66 | 228.44 | 49865.0 |
| 2024-11-20 08:30:00 | AAPL | Stock | 228.3653 | 228.51 | 228.0 | 228.18 | 22621.0 |
| 2024-11-20 09:00:00 | AAPL | Stock | 228.1 | 228.3267 | 227.37 | 228.25 | 103135.0 |
| 2024-11-20 09:30:00 | AAPL | Stock | 228.06 | 229.93 | 227.59 | 227.63 | 3298454.0 |
| 2024-11-20 10:00:00 | AAPL | Stock | 227.63 | 228.02 | 226.42 | 226.515 | 1727614.0 |
| 2024-11-20 10:30:00 | AAPL | Stock | 226.525 | 227.205 | 226.36 | 226.94 | 1127454.0 |
| 2024-11-20 11:00:00 | AAPL | Stock | 226.95 | 227.14 | 226.1 | 226.18 | 1039205.0 |
| 2024-11-20 11:30:00 | AAPL | Stock | 226.19 | 227.7 | 225.89 | 227.48 | 1398786.0 |
| 2024-11-20 12:00:00 | AAPL | Stock | 227.47 | 227.59 | 226.59 | 226.8501 | 670298.0 |
| 2024-11-20 12:30:00 | AAPL | Stock | 226.85 | 227.37 | 226.74 | 226.89 | 609376.0 |
| 2024-11-20 13:00:00 | AAPL | Stock | 226.88 | 227.14 | 226.38 | 226.8133 | 633817.0 |
| 2024-11-20 13:30:00 | AAPL | Stock | 226.79 | 227.01 | 226.39 | 226.9163 | 601583.0 |
| 2024-11-20 14:00:00 | AAPL | Stock | 226.91 | 226.94 | 226.61 | 226.81 | 536725.0 |
| 2024-11-20 14:30:00 | AAPL | Stock | 226.81 | 227.46 | 226.7 | 227.4 | 632945.0 |
| 2024-11-20 15:00:00 | AAPL | Stock | 227.4 | 228.0 | 227.22 | 227.97 | 854477.0 |
| 2024-11-20 15:30:00 | AAPL | Stock | 227.97 | 229.0 | 227.97 | 229.0 | 3054461.0 |
| 2024-11-20 16:00:00 | AAPL | Stock | 229.0 | 229.15 | 228.0 | 228.32 | 7722065.0 |
| 2024-11-20 16:30:00 | AAPL | Stock | 228.32 | 229.0 | 228.2 | 228.94 | 57911.0 |
| 2024-11-20 17:00:00 | AAPL | Stock | 228.85 | 228.86 | 228.5515 | 228.61 | 10140.0 |
| 2024-11-20 17:30:00 | AAPL | Stock | 228.6 | 228.6 | 228.32 | 228.55 | 12058.0 |
| 2024-11-20 18:00:00 | AAPL | Stock | 228.3297 | 228.5199 | 228.1348 | 228.4 | 15166.0 |
| 2024-11-20 18:30:00 | AAPL | Stock | 228.56 | 228.8299 | 228.56 | 228.71 | 10886.0 |
| 2024-11-20 19:00:00 | AAPL | Stock | 228.67 | 228.79 | 228.33 | 228.37 | 8335.0 |
| 2024-11-20 19:30:00 | AAPL | Stock | 228.3803 | 228.69 | 228.24 | 228.24 | 21954.0 |
| 2024-11-20 04:00:00 | MSFT | Stock | 418.06 | 418.77 | 417.99 | 418.62 | 3002.0 |
| 2024-11-20 04:30:00 | MSFT | Stock | 418.49 | 418.49 | 418.45 | 418.49 | 763.0 |
| 2024-11-20 05:00:00 | MSFT | Stock | 418.4 | 418.83 | 418.28 | 418.79 | 1958.0 |
| 2024-11-20 05:30:00 | MSFT | Stock | 418.46 | 419.0 | 418.46 | 418.85 | 1524.0 |
| 2024-11-20 06:00:00 | MSFT | Stock | 419.03 | 420.2 | 419.03 | 420.2 | 5311.0 |
| 2024-11-20 06:30:00 | MSFT | Stock | 420.17 | 420.8 | 419.8 | 420.8 | 2752.0 |
| 2024-11-20 07:00:00 | MSFT | Stock | 420.45 | 420.45 | 419.6 | 420.12 | 6156.0 |
| 2024-11-20 07:30:00 | MSFT | Stock | 420.18 | 420.3 | 419.89 | 420.0 | 4963.0 |
| 2024-11-20 08:00:00 | MSFT | Stock | 419.6 | 420.32 | 418.0 | 420.09 | 30437.0 |
| 2024-11-20 08:30:00 | MSFT | Stock | 419.888 | 419.888 | 418.91 | 419.3527 | 4845.0 |
| 2024-11-20 09:00:00 | MSFT | Stock | 419.55 | 419.55 | 416.62 | 417.24 | 35126.0 |
| 2024-11-20 09:30:00 | MSFT | Stock | 416.87 | 417.29 | 412.88 | 413.295 | 1223047.0 |
| 2024-11-20 10:00:00 | MSFT | Stock | 413.3104 | 413.8899 | 410.58 | 411.275 | 1022864.0 |
| 2024-11-20 10:30:00 | MSFT | Stock | 411.275 | 413.46 | 411.18 | 413.11 | 498030.0 |
| 2024-11-20 11:00:00 | MSFT | Stock | 413.125 | 413.58 | 412.35 | 413.21 | 340535.0 |
| 2024-11-20 11:30:00 | MSFT | Stock | 413.23 | 416.23 | 413.06 | 415.68 | 450172.0 |
| 2024-11-20 12:00:00 | MSFT | Stock | 415.68 | 415.96 | 413.29 | 414.0199 | 288237.0 |
| 2024-11-20 12:30:00 | MSFT | Stock | 413.95 | 414.65 | 413.58 | 413.92 | 191274.0 |
> showing 50 of 102,996 rows — these rows as CSV