PREVIEW / stock_30min / 2024-12-30
file: by_date/stock_30min/2024/2024-12-30.parquet size: 2.3 MB rows: 112,312 symbols: 613
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-12-30 04:00:00 | AAPL | Stock | 255.02 | 255.02 | 254.38 | 254.5 | 10252.0 |
| 2024-12-30 04:30:00 | AAPL | Stock | 254.35 | 254.4 | 254.31 | 254.4 | 2632.0 |
| 2024-12-30 05:00:00 | AAPL | Stock | 254.5 | 254.75 | 254.45 | 254.54 | 2655.0 |
| 2024-12-30 05:30:00 | AAPL | Stock | 254.51 | 254.51 | 254.47 | 254.49 | 2118.0 |
| 2024-12-30 06:00:00 | AAPL | Stock | 254.43 | 254.6 | 254.38 | 254.5 | 2376.0 |
| 2024-12-30 06:30:00 | AAPL | Stock | 254.51 | 254.64 | 254.5 | 254.53 | 1064.0 |
| 2024-12-30 07:00:00 | AAPL | Stock | 254.61 | 254.61 | 254.21 | 254.26 | 5655.0 |
| 2024-12-30 07:30:00 | AAPL | Stock | 254.2 | 254.23 | 252.88 | 252.9 | 29204.0 |
| 2024-12-30 08:00:00 | AAPL | Stock | 252.87 | 255.24 | 252.75 | 252.91 | 81649.0 |
| 2024-12-30 08:30:00 | AAPL | Stock | 252.95 | 253.08 | 252.01 | 252.29 | 56694.0 |
| 2024-12-30 09:00:00 | AAPL | Stock | 252.23 | 252.75 | 251.07 | 251.98 | 140348.0 |
| 2024-12-30 09:30:00 | AAPL | Stock | 252.22 | 253.0 | 250.89 | 251.27 | 3751201.0 |
| 2024-12-30 10:00:00 | AAPL | Stock | 251.2613 | 252.07 | 250.75 | 250.92 | 2224913.0 |
| 2024-12-30 10:30:00 | AAPL | Stock | 250.93 | 252.17 | 250.89 | 251.69 | 1445181.0 |
| 2024-12-30 11:00:00 | AAPL | Stock | 251.685 | 252.285 | 251.06 | 251.9 | 1295695.0 |
| 2024-12-30 11:30:00 | AAPL | Stock | 251.89 | 252.6488 | 251.81 | 252.54 | 1007333.0 |
| 2024-12-30 12:00:00 | AAPL | Stock | 252.5 | 253.1 | 252.35 | 253.05 | 996118.0 |
| 2024-12-30 12:30:00 | AAPL | Stock | 253.06 | 253.47 | 252.7 | 253.41 | 765636.0 |
| 2024-12-30 13:00:00 | AAPL | Stock | 253.4 | 253.41 | 252.5 | 252.82 | 727994.0 |
| 2024-12-30 13:30:00 | AAPL | Stock | 252.8 | 253.29 | 252.77 | 253.14 | 741166.0 |
| 2024-12-30 14:00:00 | AAPL | Stock | 253.1201 | 253.202 | 252.59 | 252.9364 | 814649.0 |
| 2024-12-30 14:30:00 | AAPL | Stock | 252.93 | 253.5 | 252.89 | 253.34 | 792749.0 |
| 2024-12-30 15:00:00 | AAPL | Stock | 253.348 | 253.48 | 252.685 | 252.72 | 962341.0 |
| 2024-12-30 15:30:00 | AAPL | Stock | 252.72 | 253.04 | 252.04 | 252.06 | 2820197.0 |
| 2024-12-30 16:00:00 | AAPL | Stock | 252.2 | 252.32 | 251.615 | 252.13 | 6112900.0 |
| 2024-12-30 16:30:00 | AAPL | Stock | 252.05 | 252.2 | 251.7 | 251.83 | 47310.0 |
| 2024-12-30 17:00:00 | AAPL | Stock | 251.83 | 252.3 | 251.83 | 252.3 | 25760.0 |
| 2024-12-30 17:30:00 | AAPL | Stock | 252.23 | 252.36 | 252.22 | 252.22 | 4577.0 |
| 2024-12-30 18:00:00 | AAPL | Stock | 252.24 | 252.24 | 251.68 | 251.73 | 61270.0 |
| 2024-12-30 18:30:00 | AAPL | Stock | 251.75 | 251.87 | 251.75 | 251.8679 | 18560.0 |
| 2024-12-30 19:00:00 | AAPL | Stock | 251.865 | 251.87 | 251.8105 | 251.87 | 13980.0 |
| 2024-12-30 19:30:00 | AAPL | Stock | 251.83 | 251.87 | 251.8 | 251.87 | 4621.0 |
| 2024-12-30 04:00:00 | MSFT | Stock | 430.7 | 430.7 | 429.8 | 430.29 | 2871.0 |
| 2024-12-30 04:30:00 | MSFT | Stock | 430.44 | 430.44 | 429.57 | 429.8 | 1624.0 |
| 2024-12-30 05:00:00 | MSFT | Stock | 429.71 | 430.29 | 429.71 | 429.85 | 3273.0 |
| 2024-12-30 05:30:00 | MSFT | Stock | 430.05 | 430.09 | 430.05 | 430.09 | 300.0 |
| 2024-12-30 06:00:00 | MSFT | Stock | 430.13 | 430.29 | 430.11 | 430.15 | 500.0 |
| 2024-12-30 06:30:00 | MSFT | Stock | 430.11 | 430.11 | 429.65 | 429.65 | 908.0 |
| 2024-12-30 07:00:00 | MSFT | Stock | 429.66 | 429.68 | 429.02 | 429.25 | 1938.0 |
| 2024-12-30 07:30:00 | MSFT | Stock | 429.18 | 429.25 | 426.74 | 426.91 | 8700.0 |
| 2024-12-30 08:00:00 | MSFT | Stock | 429.94 | 430.0 | 426.5 | 426.91 | 15882.0 |
| 2024-12-30 08:30:00 | MSFT | Stock | 426.85 | 426.9967 | 425.5795 | 425.75 | 19213.0 |
| 2024-12-30 09:00:00 | MSFT | Stock | 426.0 | 427.3216 | 425.65 | 426.22 | 16497.0 |
| 2024-12-30 09:30:00 | MSFT | Stock | 426.35 | 426.35 | 422.2 | 422.665 | 1229149.0 |
| 2024-12-30 10:00:00 | MSFT | Stock | 422.66 | 424.14 | 421.9 | 423.27 | 562806.0 |
| 2024-12-30 10:30:00 | MSFT | Stock | 423.3303 | 425.295 | 423.24 | 424.44 | 444753.0 |
| 2024-12-30 11:00:00 | MSFT | Stock | 424.36 | 425.79 | 423.99 | 425.19 | 301100.0 |
| 2024-12-30 11:30:00 | MSFT | Stock | 425.18 | 426.0499 | 424.97 | 425.44 | 361536.0 |
| 2024-12-30 12:00:00 | MSFT | Stock | 425.42 | 426.59 | 425.0801 | 426.545 | 240142.0 |
| 2024-12-30 12:30:00 | MSFT | Stock | 426.5795 | 427.55 | 425.8 | 427.03 | 298067.0 |
> showing 50 of 112,312 rows — these rows as CSV