PREVIEW / stock_30min / 2025-05-21
file: by_date/stock_30min/2025/2025-05-21.parquet size: 2.2 MB rows: 103,724 symbols: 408
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-05-21 04:00:00 | AAPL | Stock | 206.45 | 206.45 | 206.0 | 206.12 | 3211.0 |
| 2025-05-21 04:30:00 | AAPL | Stock | 206.11 | 206.13 | 205.86 | 205.96 | 4923.0 |
| 2025-05-21 05:00:00 | AAPL | Stock | 206.02 | 206.13 | 205.91 | 205.91 | 4761.0 |
| 2025-05-21 05:30:00 | AAPL | Stock | 205.85 | 205.98 | 205.6 | 205.6 | 5059.0 |
| 2025-05-21 06:00:00 | AAPL | Stock | 205.57 | 205.64 | 205.39 | 205.51 | 4560.0 |
| 2025-05-21 06:30:00 | AAPL | Stock | 205.64 | 205.78 | 205.63 | 205.73 | 3241.0 |
| 2025-05-21 07:00:00 | AAPL | Stock | 205.75 | 206.25 | 205.73 | 206.13 | 11621.0 |
| 2025-05-21 07:30:00 | AAPL | Stock | 206.1 | 206.4 | 206.01 | 206.32 | 6239.0 |
| 2025-05-21 08:00:00 | AAPL | Stock | 205.99 | 206.55 | 205.45 | 206.12 | 50665.0 |
| 2025-05-21 08:30:00 | AAPL | Stock | 206.17 | 206.17 | 205.71 | 205.98 | 15729.0 |
| 2025-05-21 09:00:00 | AAPL | Stock | 205.9 | 206.0 | 204.9 | 205.18 | 83764.0 |
| 2025-05-21 09:30:00 | AAPL | Stock | 205.17 | 205.77 | 204.06 | 205.44 | 3774296.0 |
| 2025-05-21 10:00:00 | AAPL | Stock | 205.43 | 206.7799 | 205.03 | 205.81 | 2365574.0 |
| 2025-05-21 10:30:00 | AAPL | Stock | 205.82 | 206.48 | 205.4762 | 206.185 | 1597139.0 |
| 2025-05-21 11:00:00 | AAPL | Stock | 206.18 | 207.04 | 206.15 | 206.58 | 1486787.0 |
| 2025-05-21 11:30:00 | AAPL | Stock | 206.57 | 206.87 | 205.99 | 206.0 | 1416951.0 |
| 2025-05-21 12:00:00 | AAPL | Stock | 205.995 | 206.27 | 205.5201 | 205.64 | 1270734.0 |
| 2025-05-21 12:30:00 | AAPL | Stock | 205.65 | 206.1 | 205.0 | 205.16 | 1509955.0 |
| 2025-05-21 13:00:00 | AAPL | Stock | 205.18 | 205.2713 | 202.02 | 202.1 | 8358724.0 |
| 2025-05-21 13:30:00 | AAPL | Stock | 202.1 | 203.35 | 201.81 | 203.0931 | 2988436.0 |
| 2025-05-21 14:00:00 | AAPL | Stock | 203.1 | 203.27 | 201.76 | 202.3415 | 2828401.0 |
| 2025-05-21 14:30:00 | AAPL | Stock | 202.33 | 202.61 | 200.9 | 201.3895 | 2538634.0 |
| 2025-05-21 15:00:00 | AAPL | Stock | 201.3868 | 201.81 | 200.71 | 201.0301 | 2816160.0 |
| 2025-05-21 15:30:00 | AAPL | Stock | 201.04 | 202.5 | 201.04 | 202.06 | 4638036.0 |
| 2025-05-21 16:00:00 | AAPL | Stock | 202.045 | 202.2 | 201.69 | 201.95 | 7146997.0 |
| 2025-05-21 16:30:00 | AAPL | Stock | 201.93 | 202.09 | 201.77 | 201.95 | 51966.0 |
| 2025-05-21 17:00:00 | AAPL | Stock | 202.0 | 202.0 | 201.84 | 201.9684 | 22907.0 |
| 2025-05-21 17:30:00 | AAPL | Stock | 201.91 | 202.0 | 201.7512 | 201.86 | 12709.0 |
| 2025-05-21 18:00:00 | AAPL | Stock | 201.86 | 202.19 | 201.5469 | 201.88 | 19550.0 |
| 2025-05-21 18:30:00 | AAPL | Stock | 201.8799 | 201.89 | 201.66 | 201.74 | 7288.0 |
| 2025-05-21 19:00:00 | AAPL | Stock | 201.75 | 201.98 | 201.6699 | 201.9 | 14034.0 |
| 2025-05-21 19:30:00 | AAPL | Stock | 201.98 | 201.98 | 201.77 | 201.85 | 14120.0 |
| 2025-05-21 04:00:00 | MSFT | Stock | 456.78 | 456.78 | 455.1 | 455.69 | 2355.0 |
| 2025-05-21 04:30:00 | MSFT | Stock | 454.8 | 454.98 | 454.8 | 454.98 | 200.0 |
| 2025-05-21 05:00:00 | MSFT | Stock | 455.3 | 455.46 | 454.98 | 455.01 | 1380.0 |
| 2025-05-21 05:30:00 | MSFT | Stock | 454.99 | 454.99 | 453.11 | 453.62 | 6762.0 |
| 2025-05-21 06:00:00 | MSFT | Stock | 453.72 | 453.95 | 453.04 | 453.86 | 9972.0 |
| 2025-05-21 06:30:00 | MSFT | Stock | 454.3 | 454.67 | 454.3 | 454.65 | 1525.0 |
| 2025-05-21 07:00:00 | MSFT | Stock | 454.73 | 456.17 | 454.68 | 456.17 | 7657.0 |
| 2025-05-21 07:30:00 | MSFT | Stock | 456.07 | 456.07 | 455.7 | 456.0 | 3482.0 |
| 2025-05-21 08:00:00 | MSFT | Stock | 455.35 | 456.31 | 454.45 | 455.9 | 11830.0 |
| 2025-05-21 08:30:00 | MSFT | Stock | 455.38 | 455.38 | 454.75 | 454.8795 | 1731.0 |
| 2025-05-21 09:00:00 | MSFT | Stock | 454.95 | 454.9789 | 453.55 | 454.56 | 37000.0 |
| 2025-05-21 09:30:00 | MSFT | Stock | 454.76 | 456.39 | 454.25 | 456.06 | 1275824.0 |
| 2025-05-21 10:00:00 | MSFT | Stock | 456.11 | 457.5 | 455.3 | 455.945 | 668218.0 |
| 2025-05-21 10:30:00 | MSFT | Stock | 455.945 | 456.37 | 455.235 | 456.27 | 495945.0 |
| 2025-05-21 11:00:00 | MSFT | Stock | 456.27 | 457.27 | 455.94 | 456.915 | 488532.0 |
| 2025-05-21 11:30:00 | MSFT | Stock | 456.915 | 457.61 | 456.46 | 457.385 | 504689.0 |
| 2025-05-21 12:00:00 | MSFT | Stock | 457.385 | 457.78 | 456.8 | 456.92 | 429766.0 |
| 2025-05-21 12:30:00 | MSFT | Stock | 456.96 | 457.18 | 456.12 | 456.22 | 278771.0 |
> showing 50 of 103,724 rows — these rows as CSV