PREVIEW / stock_30min / 2025-02-19
file: by_date/stock_30min/2025/2025-02-19.parquet size: 2.3 MB rows: 107,496 symbols: 524
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-02-19 04:00:00 | AAPL | Stock | 245.0 | 245.0 | 244.6 | 244.72 | 9125.0 |
| 2025-02-19 04:30:00 | AAPL | Stock | 244.79 | 244.8 | 244.53 | 244.56 | 3541.0 |
| 2025-02-19 05:00:00 | AAPL | Stock | 244.55 | 244.62 | 244.11 | 244.11 | 4209.0 |
| 2025-02-19 05:30:00 | AAPL | Stock | 244.18 | 244.26 | 244.0 | 244.0 | 4427.0 |
| 2025-02-19 06:00:00 | AAPL | Stock | 244.01 | 244.15 | 244.01 | 244.08 | 2759.0 |
| 2025-02-19 06:30:00 | AAPL | Stock | 244.07 | 244.12 | 243.84 | 243.88 | 5726.0 |
| 2025-02-19 07:00:00 | AAPL | Stock | 243.88 | 244.26 | 243.88 | 244.25 | 6951.0 |
| 2025-02-19 07:30:00 | AAPL | Stock | 244.2 | 244.34 | 244.2 | 244.29 | 4177.0 |
| 2025-02-19 08:00:00 | AAPL | Stock | 244.2 | 245.17 | 243.8 | 243.86 | 42784.0 |
| 2025-02-19 08:30:00 | AAPL | Stock | 243.9876 | 244.21 | 243.79 | 244.11 | 19435.0 |
| 2025-02-19 09:00:00 | AAPL | Stock | 244.12 | 244.72 | 243.73 | 244.72 | 62776.0 |
| 2025-02-19 09:30:00 | AAPL | Stock | 244.66 | 246.01 | 244.1181 | 245.07 | 3139173.0 |
| 2025-02-19 10:00:00 | AAPL | Stock | 245.07 | 245.58 | 243.79 | 243.93 | 1699355.0 |
| 2025-02-19 10:30:00 | AAPL | Stock | 243.93 | 244.49 | 243.26 | 243.42 | 1427852.0 |
| 2025-02-19 11:00:00 | AAPL | Stock | 243.41 | 244.44 | 243.1604 | 244.3957 | 1458385.0 |
| 2025-02-19 11:30:00 | AAPL | Stock | 244.39 | 244.9499 | 244.03 | 244.78 | 977816.0 |
| 2025-02-19 12:00:00 | AAPL | Stock | 244.79 | 245.66 | 244.745 | 245.15 | 1233771.0 |
| 2025-02-19 12:30:00 | AAPL | Stock | 245.14 | 245.28 | 244.6273 | 244.72 | 727022.0 |
| 2025-02-19 13:00:00 | AAPL | Stock | 244.73 | 244.8202 | 244.23 | 244.71 | 707872.0 |
| 2025-02-19 13:30:00 | AAPL | Stock | 244.715 | 245.1899 | 244.54 | 244.73 | 618880.0 |
| 2025-02-19 14:00:00 | AAPL | Stock | 244.74 | 245.08 | 244.22 | 244.9001 | 844943.0 |
| 2025-02-19 14:30:00 | AAPL | Stock | 244.9 | 244.9 | 244.4501 | 244.835 | 762471.0 |
| 2025-02-19 15:00:00 | AAPL | Stock | 244.84 | 245.18 | 244.635 | 244.88 | 1176950.0 |
| 2025-02-19 15:30:00 | AAPL | Stock | 244.88 | 245.0896 | 244.535 | 244.89 | 2157570.0 |
| 2025-02-19 16:00:00 | AAPL | Stock | 244.852 | 245.04 | 244.52 | 244.5805 | 4708728.0 |
| 2025-02-19 16:30:00 | AAPL | Stock | 244.66 | 244.87 | 244.48 | 244.51 | 9202.0 |
| 2025-02-19 17:00:00 | AAPL | Stock | 244.5025 | 244.55 | 244.2501 | 244.2511 | 9190.0 |
| 2025-02-19 17:30:00 | AAPL | Stock | 244.29 | 244.44 | 244.2613 | 244.34 | 4304.0 |
| 2025-02-19 18:00:00 | AAPL | Stock | 244.38 | 244.87 | 244.38 | 244.62 | 7983.0 |
| 2025-02-19 18:30:00 | AAPL | Stock | 244.695 | 244.73 | 244.5236 | 244.58 | 4987.0 |
| 2025-02-19 19:00:00 | AAPL | Stock | 244.65 | 244.71 | 244.51 | 244.51 | 1670.0 |
| 2025-02-19 19:30:00 | AAPL | Stock | 244.49 | 244.87 | 244.49 | 244.8 | 4581.0 |
| 2025-02-19 04:00:00 | MSFT | Stock | 409.91 | 409.91 | 409.63 | 409.7 | 2743.0 |
| 2025-02-19 04:30:00 | MSFT | Stock | 409.69 | 409.78 | 409.69 | 409.78 | 372.0 |
| 2025-02-19 05:00:00 | MSFT | Stock | 409.79 | 409.79 | 409.59 | 409.59 | 800.0 |
| 2025-02-19 05:30:00 | MSFT | Stock | 409.5 | 409.5 | 409.29 | 409.36 | 622.0 |
| 2025-02-19 06:00:00 | MSFT | Stock | 409.29 | 409.29 | 409.27 | 409.28 | 525.0 |
| 2025-02-19 06:30:00 | MSFT | Stock | 409.1 | 409.1 | 408.61 | 409.0 | 795.0 |
| 2025-02-19 07:00:00 | MSFT | Stock | 409.12 | 409.6 | 409.12 | 409.6 | 3742.0 |
| 2025-02-19 07:30:00 | MSFT | Stock | 409.51 | 409.7 | 409.31 | 409.5 | 1626.0 |
| 2025-02-19 08:00:00 | MSFT | Stock | 409.35 | 409.94 | 408.85 | 408.85 | 11042.0 |
| 2025-02-19 08:30:00 | MSFT | Stock | 408.88 | 409.0 | 408.7 | 408.8135 | 3612.0 |
| 2025-02-19 09:00:00 | MSFT | Stock | 408.85 | 409.03 | 408.25 | 408.91 | 12761.0 |
| 2025-02-19 09:30:00 | MSFT | Stock | 408.94 | 409.93 | 407.65 | 409.38 | 1340683.0 |
| 2025-02-19 10:00:00 | MSFT | Stock | 409.335 | 409.65 | 407.77 | 408.2 | 589441.0 |
| 2025-02-19 10:30:00 | MSFT | Stock | 408.27 | 409.285 | 408.05 | 408.33 | 668357.0 |
| 2025-02-19 11:00:00 | MSFT | Stock | 408.33 | 411.8487 | 407.96 | 410.4292 | 2515000.0 |
| 2025-02-19 11:30:00 | MSFT | Stock | 410.39 | 411.14 | 409.91 | 410.65 | 552640.0 |
| 2025-02-19 12:00:00 | MSFT | Stock | 410.6525 | 411.56 | 410.0 | 410.45 | 559336.0 |
| 2025-02-19 12:30:00 | MSFT | Stock | 410.45 | 411.11 | 410.2245 | 410.96 | 351913.0 |
> showing 50 of 107,496 rows — these rows as CSV