PREVIEW / stock_30min / 2025-04-07
file: by_date/stock_30min/2025/2025-04-07.parquet size: 2.3 MB rows: 115,152 symbols: 451
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-07 04:00:00 | AAPL | Stock | 177.87 | 181.94 | 177.09 | 181.11 | 230834.0 |
| 2025-04-07 04:30:00 | AAPL | Stock | 181.16 | 181.7 | 180.5 | 180.55 | 62725.0 |
| 2025-04-07 05:00:00 | AAPL | Stock | 180.55 | 180.9 | 179.5 | 180.58 | 53277.0 |
| 2025-04-07 05:30:00 | AAPL | Stock | 180.46 | 182.0 | 180.3 | 181.1 | 51692.0 |
| 2025-04-07 06:00:00 | AAPL | Stock | 181.07 | 185.49 | 180.73 | 183.57 | 116317.0 |
| 2025-04-07 06:30:00 | AAPL | Stock | 183.5 | 186.43 | 183.14 | 184.5 | 122014.0 |
| 2025-04-07 07:00:00 | AAPL | Stock | 184.82 | 184.9 | 181.19 | 182.32 | 297153.0 |
| 2025-04-07 07:30:00 | AAPL | Stock | 182.12 | 183.0 | 180.58 | 182.06 | 176980.0 |
| 2025-04-07 08:00:00 | AAPL | Stock | 183.7 | 185.98 | 174.43 | 183.0 | 879747.0 |
| 2025-04-07 08:30:00 | AAPL | Stock | 183.49 | 184.03 | 181.63 | 182.98 | 394399.0 |
| 2025-04-07 09:00:00 | AAPL | Stock | 182.97 | 183.65 | 175.7 | 177.21 | 1230876.0 |
| 2025-04-07 09:30:00 | AAPL | Stock | 177.21 | 181.14 | 174.62 | 180.49 | 25561967.0 |
| 2025-04-07 10:00:00 | AAPL | Stock | 180.49 | 194.15 | 179.0 | 181.77 | 16489479.0 |
| 2025-04-07 10:30:00 | AAPL | Stock | 181.68 | 185.9398 | 179.63 | 183.87 | 7366394.0 |
| 2025-04-07 11:00:00 | AAPL | Stock | 183.88 | 185.18 | 175.7 | 176.36 | 8367407.0 |
| 2025-04-07 11:30:00 | AAPL | Stock | 176.4 | 180.38 | 176.38 | 178.78 | 5161529.0 |
| 2025-04-07 12:00:00 | AAPL | Stock | 178.78 | 178.8413 | 175.75 | 178.14 | 4256520.0 |
| 2025-04-07 12:30:00 | AAPL | Stock | 178.1 | 179.8 | 177.23 | 177.6 | 3358435.0 |
| 2025-04-07 13:00:00 | AAPL | Stock | 177.6125 | 181.72 | 177.1 | 181.54 | 4686829.0 |
| 2025-04-07 13:30:00 | AAPL | Stock | 181.555 | 182.95 | 179.96 | 182.605 | 3632158.0 |
| 2025-04-07 14:00:00 | AAPL | Stock | 182.605 | 183.9 | 179.5 | 180.335 | 5686369.0 |
| 2025-04-07 14:30:00 | AAPL | Stock | 180.34 | 182.3 | 179.45 | 179.97 | 4068457.0 |
| 2025-04-07 15:00:00 | AAPL | Stock | 179.965 | 181.115 | 178.2801 | 178.4213 | 5141457.0 |
| 2025-04-07 15:30:00 | AAPL | Stock | 178.44 | 182.0 | 178.43 | 181.59 | 9208693.0 |
| 2025-04-07 16:00:00 | AAPL | Stock | 181.52 | 183.2 | 181.28 | 181.81 | 13437929.0 |
| 2025-04-07 16:30:00 | AAPL | Stock | 182.0 | 182.5 | 181.25 | 181.32 | 80020.0 |
| 2025-04-07 17:00:00 | AAPL | Stock | 181.49 | 182.0 | 181.27 | 181.77 | 103097.0 |
| 2025-04-07 17:30:00 | AAPL | Stock | 181.97 | 182.39 | 181.46 | 182.2 | 45508.0 |
| 2025-04-07 18:00:00 | AAPL | Stock | 182.3 | 182.77 | 182.0 | 182.55 | 26521.0 |
| 2025-04-07 18:30:00 | AAPL | Stock | 182.61 | 183.65 | 182.61 | 183.4 | 70920.0 |
| 2025-04-07 19:00:00 | AAPL | Stock | 183.45 | 183.77 | 183.1685 | 183.32 | 37953.0 |
| 2025-04-07 19:30:00 | AAPL | Stock | 183.4996 | 183.4996 | 181.99 | 182.68 | 48772.0 |
| 2025-04-07 04:00:00 | MSFT | Stock | 343.0 | 350.0 | 342.17 | 346.26 | 44563.0 |
| 2025-04-07 04:30:00 | MSFT | Stock | 346.14 | 348.16 | 345.25 | 345.5 | 11506.0 |
| 2025-04-07 05:00:00 | MSFT | Stock | 345.5 | 346.3 | 341.5 | 344.0 | 25876.0 |
| 2025-04-07 05:30:00 | MSFT | Stock | 344.26 | 347.25 | 344.09 | 345.65 | 12627.0 |
| 2025-04-07 06:00:00 | MSFT | Stock | 346.14 | 352.5 | 345.0 | 351.4 | 41501.0 |
| 2025-04-07 06:30:00 | MSFT | Stock | 350.61 | 356.8 | 349.76 | 352.62 | 37150.0 |
| 2025-04-07 07:00:00 | MSFT | Stock | 352.86 | 356.13 | 351.51 | 355.09 | 29763.0 |
| 2025-04-07 07:30:00 | MSFT | Stock | 354.44 | 354.56 | 351.14 | 352.84 | 15122.0 |
| 2025-04-07 08:00:00 | MSFT | Stock | 352.75 | 357.5 | 338.0 | 355.85 | 132408.0 |
| 2025-04-07 08:30:00 | MSFT | Stock | 357.44 | 358.0 | 353.0 | 356.0 | 62390.0 |
| 2025-04-07 09:00:00 | MSFT | Stock | 355.33 | 355.99 | 348.0 | 350.79 | 122751.0 |
| 2025-04-07 09:30:00 | MSFT | Stock | 350.88 | 354.44 | 344.79 | 353.35 | 5867133.0 |
| 2025-04-07 10:00:00 | MSFT | Stock | 353.35 | 370.9999 | 349.71 | 355.1525 | 4524740.0 |
| 2025-04-07 10:30:00 | MSFT | Stock | 355.22 | 362.0 | 351.93 | 360.46 | 2330903.0 |
| 2025-04-07 11:00:00 | MSFT | Stock | 360.405 | 362.09 | 350.0 | 352.92 | 2053836.0 |
| 2025-04-07 11:30:00 | MSFT | Stock | 352.905 | 358.73 | 352.81 | 355.92 | 1157643.0 |
| 2025-04-07 12:00:00 | MSFT | Stock | 355.87 | 356.74 | 352.9656 | 356.025 | 852755.0 |
| 2025-04-07 12:30:00 | MSFT | Stock | 355.93 | 357.56 | 352.11 | 352.52 | 759728.0 |
> showing 50 of 115,152 rows — these rows as CSV