PREVIEW / stock_30min / 2025-01-30
file: by_date/stock_30min/2025/2025-01-30.parquet size: 2.2 MB rows: 105,409 symbols: 568
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-01-30 04:00:00 | AAPL | Stock | 239.63 | 239.92 | 239.1 | 239.1 | 7577.0 |
| 2025-01-30 04:30:00 | AAPL | Stock | 239.05 | 239.1 | 238.92 | 238.97 | 3933.0 |
| 2025-01-30 05:00:00 | AAPL | Stock | 238.94 | 239.2 | 238.83 | 238.83 | 7812.0 |
| 2025-01-30 05:30:00 | AAPL | Stock | 239.11 | 239.19 | 238.8 | 238.88 | 6753.0 |
| 2025-01-30 06:00:00 | AAPL | Stock | 238.97 | 239.56 | 238.89 | 239.55 | 5135.0 |
| 2025-01-30 06:30:00 | AAPL | Stock | 239.45 | 239.62 | 239.34 | 239.35 | 8319.0 |
| 2025-01-30 07:00:00 | AAPL | Stock | 239.15 | 239.15 | 238.12 | 238.12 | 14412.0 |
| 2025-01-30 07:30:00 | AAPL | Stock | 238.1 | 238.7 | 238.09 | 238.7 | 11898.0 |
| 2025-01-30 08:00:00 | AAPL | Stock | 238.45 | 240.16 | 238.05 | 238.67 | 237435.0 |
| 2025-01-30 08:30:00 | AAPL | Stock | 238.5 | 239.03 | 238.4026 | 238.95 | 61649.0 |
| 2025-01-30 09:00:00 | AAPL | Stock | 239.0 | 239.1999 | 237.16 | 238.71 | 155314.0 |
| 2025-01-30 09:30:00 | AAPL | Stock | 238.665 | 240.79 | 238.41 | 239.46 | 4229446.0 |
| 2025-01-30 10:00:00 | AAPL | Stock | 239.46 | 239.46 | 238.09 | 238.4501 | 2037171.0 |
| 2025-01-30 10:30:00 | AAPL | Stock | 238.46 | 239.04 | 238.06 | 238.06 | 1423653.0 |
| 2025-01-30 11:00:00 | AAPL | Stock | 238.09 | 238.49 | 237.21 | 238.2 | 1844759.0 |
| 2025-01-30 11:30:00 | AAPL | Stock | 238.1844 | 238.84 | 238.01 | 238.78 | 1231375.0 |
| 2025-01-30 12:00:00 | AAPL | Stock | 238.8 | 238.88 | 237.81 | 238.0252 | 1321281.0 |
| 2025-01-30 12:30:00 | AAPL | Stock | 238.03 | 238.55 | 237.905 | 238.395 | 867890.0 |
| 2025-01-30 13:00:00 | AAPL | Stock | 238.39 | 238.7686 | 238.29 | 238.45 | 847558.0 |
| 2025-01-30 13:30:00 | AAPL | Stock | 238.44 | 239.67 | 238.44 | 239.645 | 1242003.0 |
| 2025-01-30 14:00:00 | AAPL | Stock | 239.649 | 239.649 | 238.931 | 239.25 | 1353722.0 |
| 2025-01-30 14:30:00 | AAPL | Stock | 239.25 | 239.87 | 239.21 | 239.861 | 1519058.0 |
| 2025-01-30 15:00:00 | AAPL | Stock | 239.865 | 240.06 | 239.455 | 239.58 | 2239458.0 |
| 2025-01-30 15:30:00 | AAPL | Stock | 239.58 | 239.855 | 237.24 | 237.56 | 5155309.0 |
| 2025-01-30 16:00:00 | AAPL | Stock | 237.52 | 238.55 | 237.13 | 238.55 | 4923986.0 |
| 2025-01-30 16:30:00 | AAPL | Stock | 238.45 | 245.44 | 233.51 | 233.99 | 3230638.0 |
| 2025-01-30 17:00:00 | AAPL | Stock | 234.0 | 247.8699 | 232.97 | 247.0101 | 2996605.0 |
| 2025-01-30 17:30:00 | AAPL | Stock | 247.74 | 248.35 | 237.59 | 245.03 | 1299338.0 |
| 2025-01-30 18:00:00 | AAPL | Stock | 245.0146 | 246.2 | 244.13 | 244.2 | 428300.0 |
| 2025-01-30 18:30:00 | AAPL | Stock | 244.24 | 245.0 | 243.5109 | 245.0 | 273295.0 |
| 2025-01-30 19:00:00 | AAPL | Stock | 244.95 | 245.0 | 244.1 | 244.25 | 106352.0 |
| 2025-01-30 19:30:00 | AAPL | Stock | 244.24 | 244.8 | 244.2 | 244.75 | 124195.0 |
| 2025-01-30 04:00:00 | MSFT | Stock | 425.85 | 427.59 | 424.88 | 425.5 | 70524.0 |
| 2025-01-30 04:30:00 | MSFT | Stock | 425.27 | 426.09 | 424.52 | 425.45 | 15411.0 |
| 2025-01-30 05:00:00 | MSFT | Stock | 425.46 | 425.92 | 423.85 | 425.12 | 16753.0 |
| 2025-01-30 05:30:00 | MSFT | Stock | 425.31 | 426.61 | 425.0 | 425.91 | 14185.0 |
| 2025-01-30 06:00:00 | MSFT | Stock | 425.72 | 425.88 | 424.48 | 425.1 | 20819.0 |
| 2025-01-30 06:30:00 | MSFT | Stock | 425.0 | 426.15 | 424.32 | 424.32 | 38106.0 |
| 2025-01-30 07:00:00 | MSFT | Stock | 424.3 | 425.0 | 422.01 | 423.34 | 75163.0 |
| 2025-01-30 07:30:00 | MSFT | Stock | 423.33 | 424.4 | 422.8 | 424.15 | 63978.0 |
| 2025-01-30 08:00:00 | MSFT | Stock | 423.9 | 427.1 | 422.5 | 423.9001 | 220732.0 |
| 2025-01-30 08:30:00 | MSFT | Stock | 424.6 | 425.0 | 421.5001 | 422.63 | 175258.0 |
| 2025-01-30 09:00:00 | MSFT | Stock | 422.76 | 423.16 | 417.0 | 418.2 | 425813.0 |
| 2025-01-30 09:30:00 | MSFT | Stock | 418.7 | 422.86 | 414.74 | 421.72 | 7716173.0 |
| 2025-01-30 10:00:00 | MSFT | Stock | 421.71 | 421.74 | 414.17 | 415.2299 | 4576778.0 |
| 2025-01-30 10:30:00 | MSFT | Stock | 415.22 | 416.93 | 413.94 | 415.25 | 1972289.0 |
| 2025-01-30 11:00:00 | MSFT | Stock | 415.18 | 415.51 | 413.16 | 415.25 | 2303750.0 |
| 2025-01-30 11:30:00 | MSFT | Stock | 415.275 | 416.55 | 414.383 | 416.33 | 1380224.0 |
| 2025-01-30 12:00:00 | MSFT | Stock | 416.34 | 417.09 | 414.33 | 414.5045 | 1587607.0 |
| 2025-01-30 12:30:00 | MSFT | Stock | 414.51 | 415.4857 | 414.34 | 414.5 | 1104079.0 |
> showing 50 of 105,409 rows — these rows as CSV