PREVIEW / stock_30min / 2025-03-05
file: by_date/stock_30min/2025/2025-03-05.parquet size: 2.2 MB rows: 104,553 symbols: 509
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-03-05 04:00:00 | AAPL | Stock | 237.76 | 237.76 | 236.95 | 237.39 | 11059.0 |
| 2025-03-05 04:30:00 | AAPL | Stock | 237.39 | 237.64 | 237.27 | 237.55 | 8315.0 |
| 2025-03-05 05:00:00 | AAPL | Stock | 237.58 | 237.58 | 236.93 | 237.0 | 9206.0 |
| 2025-03-05 05:30:00 | AAPL | Stock | 237.05 | 237.22 | 236.95 | 236.97 | 1478.0 |
| 2025-03-05 06:00:00 | AAPL | Stock | 236.96 | 236.98 | 236.77 | 236.8 | 1332.0 |
| 2025-03-05 06:30:00 | AAPL | Stock | 236.89 | 237.05 | 236.19 | 236.62 | 10174.0 |
| 2025-03-05 07:00:00 | AAPL | Stock | 236.72 | 236.93 | 236.32 | 236.7 | 5584.0 |
| 2025-03-05 07:30:00 | AAPL | Stock | 236.84 | 236.84 | 236.45 | 236.45 | 5743.0 |
| 2025-03-05 08:00:00 | AAPL | Stock | 236.75 | 237.72 | 235.93 | 236.35 | 69291.0 |
| 2025-03-05 08:30:00 | AAPL | Stock | 236.52 | 236.9 | 236.2801 | 236.2801 | 29913.0 |
| 2025-03-05 09:00:00 | AAPL | Stock | 236.29 | 236.6996 | 235.22 | 235.43 | 100347.0 |
| 2025-03-05 09:30:00 | AAPL | Stock | 235.42 | 235.95 | 231.04 | 231.77 | 5102382.0 |
| 2025-03-05 10:00:00 | AAPL | Stock | 231.83 | 233.25 | 230.52 | 230.92 | 3509936.0 |
| 2025-03-05 10:30:00 | AAPL | Stock | 230.94 | 233.2 | 230.8 | 232.57 | 1742740.0 |
| 2025-03-05 11:00:00 | AAPL | Stock | 232.565 | 232.63 | 230.14 | 230.649 | 1966835.0 |
| 2025-03-05 11:30:00 | AAPL | Stock | 230.62 | 232.45 | 229.23 | 232.2 | 2655801.0 |
| 2025-03-05 12:00:00 | AAPL | Stock | 232.2 | 234.66 | 232.14 | 234.5399 | 1876460.0 |
| 2025-03-05 12:30:00 | AAPL | Stock | 234.54 | 235.4 | 234.0 | 234.945 | 1661826.0 |
| 2025-03-05 13:00:00 | AAPL | Stock | 234.945 | 235.54 | 234.02 | 234.68 | 1374335.0 |
| 2025-03-05 13:30:00 | AAPL | Stock | 234.6653 | 235.85 | 234.1 | 235.82 | 1072020.0 |
| 2025-03-05 14:00:00 | AAPL | Stock | 235.835 | 236.55 | 235.4 | 235.7475 | 1105668.0 |
| 2025-03-05 14:30:00 | AAPL | Stock | 235.77 | 236.19 | 235.15 | 235.49 | 912352.0 |
| 2025-03-05 15:00:00 | AAPL | Stock | 235.47 | 236.48 | 235.21 | 236.04 | 1324013.0 |
| 2025-03-05 15:30:00 | AAPL | Stock | 236.01 | 236.39 | 235.06 | 235.82 | 2753636.0 |
| 2025-03-05 16:00:00 | AAPL | Stock | 235.78 | 235.99 | 235.22 | 235.83 | 5665603.0 |
| 2025-03-05 16:30:00 | AAPL | Stock | 235.91 | 236.19 | 235.74 | 236.03 | 30726.0 |
| 2025-03-05 17:00:00 | AAPL | Stock | 236.03 | 236.3 | 236.0 | 236.0034 | 14080.0 |
| 2025-03-05 17:30:00 | AAPL | Stock | 236.03 | 236.12 | 236.01 | 236.1 | 7994.0 |
| 2025-03-05 18:00:00 | AAPL | Stock | 236.1 | 236.41 | 236.05 | 236.09 | 12796.0 |
| 2025-03-05 18:30:00 | AAPL | Stock | 236.08 | 236.08 | 235.74 | 235.74 | 8202.0 |
| 2025-03-05 19:00:00 | AAPL | Stock | 235.74 | 236.29 | 235.74 | 236.23 | 3914.0 |
| 2025-03-05 19:30:00 | AAPL | Stock | 236.1 | 236.1 | 235.5 | 235.7823 | 3312.0 |
| 2025-03-05 04:00:00 | MSFT | Stock | 391.2 | 391.35 | 390.45 | 391.0 | 5857.0 |
| 2025-03-05 04:30:00 | MSFT | Stock | 391.61 | 391.74 | 391.2 | 391.2 | 4990.0 |
| 2025-03-05 05:00:00 | MSFT | Stock | 391.2 | 391.2 | 390.5 | 390.5 | 525.0 |
| 2025-03-05 05:30:00 | MSFT | Stock | 390.41 | 390.64 | 390.41 | 390.64 | 1004.0 |
| 2025-03-05 06:00:00 | MSFT | Stock | 390.29 | 390.78 | 390.29 | 390.78 | 1759.0 |
| 2025-03-05 06:30:00 | MSFT | Stock | 390.32 | 390.5 | 390.0 | 390.0 | 4244.0 |
| 2025-03-05 07:00:00 | MSFT | Stock | 389.88 | 390.37 | 389.46 | 389.79 | 3197.0 |
| 2025-03-05 07:30:00 | MSFT | Stock | 390.0 | 390.5 | 389.75 | 389.75 | 4650.0 |
| 2025-03-05 08:00:00 | MSFT | Stock | 389.72 | 391.2 | 388.8925 | 389.0 | 26342.0 |
| 2025-03-05 08:30:00 | MSFT | Stock | 389.01 | 389.8 | 388.94 | 389.0001 | 5866.0 |
| 2025-03-05 09:00:00 | MSFT | Stock | 388.88 | 389.72 | 388.5529 | 389.69 | 15062.0 |
| 2025-03-05 09:30:00 | MSFT | Stock | 389.39 | 392.31 | 388.81 | 389.15 | 1549486.0 |
| 2025-03-05 10:00:00 | MSFT | Stock | 389.88 | 393.18 | 389.31 | 391.54 | 923172.0 |
| 2025-03-05 10:30:00 | MSFT | Stock | 391.575 | 393.36 | 391.22 | 392.5 | 529965.0 |
| 2025-03-05 11:00:00 | MSFT | Stock | 392.49 | 392.52 | 390.12 | 392.0493 | 527425.0 |
| 2025-03-05 11:30:00 | MSFT | Stock | 392.09 | 392.75 | 390.32 | 392.12 | 536304.0 |
| 2025-03-05 12:00:00 | MSFT | Stock | 392.1 | 394.7715 | 392.04 | 394.7715 | 572060.0 |
| 2025-03-05 12:30:00 | MSFT | Stock | 394.74 | 396.95 | 394.3 | 396.91 | 738383.0 |
> showing 50 of 104,553 rows — these rows as CSV