PREVIEW / stock_30min / 2024-11-22
file: by_date/stock_30min/2024/2024-11-22.parquet size: 2.2 MB rows: 104,475 symbols: 703
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-22 04:00:00 | AAPL | Stock | 228.5 | 228.96 | 228.31 | 228.31 | 9604.0 |
| 2024-11-22 04:30:00 | AAPL | Stock | 228.33 | 228.82 | 228.14 | 228.76 | 5878.0 |
| 2024-11-22 05:00:00 | AAPL | Stock | 228.67 | 228.67 | 228.27 | 228.36 | 2060.0 |
| 2024-11-22 05:30:00 | AAPL | Stock | 228.4 | 228.49 | 228.35 | 228.45 | 2443.0 |
| 2024-11-22 06:00:00 | AAPL | Stock | 228.37 | 228.6 | 228.35 | 228.6 | 1515.0 |
| 2024-11-22 06:30:00 | AAPL | Stock | 228.51 | 228.85 | 228.35 | 228.85 | 2324.0 |
| 2024-11-22 07:00:00 | AAPL | Stock | 228.94 | 229.0 | 228.74 | 228.9 | 8078.0 |
| 2024-11-22 07:30:00 | AAPL | Stock | 228.89 | 229.03 | 228.7 | 228.92 | 5280.0 |
| 2024-11-22 08:00:00 | AAPL | Stock | 228.94 | 229.1 | 228.49 | 228.52 | 25142.0 |
| 2024-11-22 08:30:00 | AAPL | Stock | 228.956 | 228.956 | 228.6 | 228.72 | 16226.0 |
| 2024-11-22 09:00:00 | AAPL | Stock | 228.75 | 228.8774 | 228.02 | 228.29 | 115841.0 |
| 2024-11-22 09:30:00 | AAPL | Stock | 228.21 | 230.13 | 228.06 | 229.98 | 3335424.0 |
| 2024-11-22 10:00:00 | AAPL | Stock | 229.95 | 229.95 | 229.01 | 229.28 | 1598593.0 |
| 2024-11-22 10:30:00 | AAPL | Stock | 229.28 | 229.93 | 229.07 | 229.5 | 1359358.0 |
| 2024-11-22 11:00:00 | AAPL | Stock | 229.5 | 229.65 | 228.83 | 229.48 | 975003.0 |
| 2024-11-22 11:30:00 | AAPL | Stock | 229.4899 | 229.68 | 228.97 | 229.5799 | 1021948.0 |
| 2024-11-22 12:00:00 | AAPL | Stock | 229.58 | 230.12 | 229.52 | 229.985 | 1478667.0 |
| 2024-11-22 12:30:00 | AAPL | Stock | 229.985 | 230.53 | 229.675 | 230.3901 | 1402365.0 |
| 2024-11-22 13:00:00 | AAPL | Stock | 230.39 | 230.7199 | 230.11 | 230.18 | 1156068.0 |
| 2024-11-22 13:30:00 | AAPL | Stock | 230.165 | 230.39 | 229.82 | 229.875 | 1032279.0 |
| 2024-11-22 14:00:00 | AAPL | Stock | 229.87 | 229.9931 | 229.33 | 229.44 | 1175606.0 |
| 2024-11-22 14:30:00 | AAPL | Stock | 229.445 | 229.64 | 229.32 | 229.49 | 873945.0 |
| 2024-11-22 15:00:00 | AAPL | Stock | 229.48 | 229.492 | 228.93 | 229.375 | 1196909.0 |
| 2024-11-22 15:30:00 | AAPL | Stock | 229.37 | 230.2 | 229.31 | 229.74 | 3418410.0 |
| 2024-11-22 16:00:00 | AAPL | Stock | 229.71 | 230.1589 | 229.71 | 230.1589 | 6080246.0 |
| 2024-11-22 16:30:00 | AAPL | Stock | 230.0125 | 230.05 | 229.87 | 229.99 | 50780.0 |
| 2024-11-22 17:00:00 | AAPL | Stock | 229.99 | 230.0 | 229.97 | 229.97 | 6793.0 |
| 2024-11-22 17:30:00 | AAPL | Stock | 229.97 | 229.98 | 229.9187 | 229.9187 | 14491.0 |
| 2024-11-22 18:00:00 | AAPL | Stock | 229.94 | 229.98 | 229.9 | 229.98 | 6483.0 |
| 2024-11-22 18:30:00 | AAPL | Stock | 229.99 | 230.0 | 229.95 | 229.9899 | 3491.0 |
| 2024-11-22 19:00:00 | AAPL | Stock | 229.91 | 229.98 | 229.89 | 229.93 | 1528.0 |
| 2024-11-22 19:30:00 | AAPL | Stock | 229.93 | 229.95 | 229.93 | 229.95 | 1208.0 |
| 2024-11-22 04:00:00 | MSFT | Stock | 412.94 | 413.11 | 412.0 | 412.0 | 3051.0 |
| 2024-11-22 04:30:00 | MSFT | Stock | 411.96 | 412.0 | 411.52 | 411.66 | 2698.0 |
| 2024-11-22 05:00:00 | MSFT | Stock | 411.52 | 411.89 | 411.19 | 411.89 | 1137.0 |
| 2024-11-22 05:30:00 | MSFT | Stock | 412.15 | 412.15 | 412.01 | 412.01 | 435.0 |
| 2024-11-22 06:00:00 | MSFT | Stock | 412.0 | 412.39 | 411.79 | 411.79 | 831.0 |
| 2024-11-22 06:30:00 | MSFT | Stock | 411.88 | 412.0 | 411.59 | 412.0 | 520.0 |
| 2024-11-22 07:00:00 | MSFT | Stock | 412.48 | 412.55 | 412.26 | 412.5 | 2620.0 |
| 2024-11-22 07:30:00 | MSFT | Stock | 412.73 | 412.94 | 412.33 | 412.9 | 1451.0 |
| 2024-11-22 08:00:00 | MSFT | Stock | 412.479 | 413.65 | 412.2189 | 412.6101 | 21447.0 |
| 2024-11-22 08:30:00 | MSFT | Stock | 412.83 | 412.93 | 411.97 | 412.0213 | 13506.0 |
| 2024-11-22 09:00:00 | MSFT | Stock | 412.18 | 412.7 | 411.0 | 411.02 | 19639.0 |
| 2024-11-22 09:30:00 | MSFT | Stock | 411.365 | 415.62 | 411.06 | 414.8 | 1306225.0 |
| 2024-11-22 10:00:00 | MSFT | Stock | 414.5 | 414.66 | 411.66 | 411.91 | 630772.0 |
| 2024-11-22 10:30:00 | MSFT | Stock | 411.96 | 413.9 | 411.7593 | 413.24 | 488335.0 |
| 2024-11-22 11:00:00 | MSFT | Stock | 413.29 | 413.46 | 411.87 | 413.05 | 406010.0 |
| 2024-11-22 11:30:00 | MSFT | Stock | 412.95 | 413.97 | 412.27 | 413.595 | 533641.0 |
| 2024-11-22 12:00:00 | MSFT | Stock | 413.56 | 414.58 | 413.27 | 414.1074 | 372731.0 |
| 2024-11-22 12:30:00 | MSFT | Stock | 414.16 | 414.9389 | 413.33 | 414.51 | 403388.0 |
> showing 50 of 104,475 rows — these rows as CSV