PREVIEW / stock_30min / 2024-11-21
file: by_date/stock_30min/2024/2024-11-21.parquet size: 2.2 MB rows: 104,595 symbols: 704
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-21 04:00:00 | AAPL | Stock | 228.2 | 229.01 | 228.11 | 228.58 | 16579.0 |
| 2024-11-21 04:30:00 | AAPL | Stock | 228.55 | 228.72 | 228.55 | 228.6 | 1275.0 |
| 2024-11-21 05:00:00 | AAPL | Stock | 228.52 | 228.76 | 228.5 | 228.76 | 5463.0 |
| 2024-11-21 05:30:00 | AAPL | Stock | 228.69 | 229.0 | 228.57 | 228.88 | 5344.0 |
| 2024-11-21 06:00:00 | AAPL | Stock | 228.8 | 229.76 | 228.8 | 229.75 | 7466.0 |
| 2024-11-21 06:30:00 | AAPL | Stock | 229.76 | 229.96 | 229.48 | 229.66 | 18905.0 |
| 2024-11-21 07:00:00 | AAPL | Stock | 229.43 | 229.95 | 229.35 | 229.8 | 10009.0 |
| 2024-11-21 07:30:00 | AAPL | Stock | 229.73 | 229.97 | 229.09 | 229.35 | 17961.0 |
| 2024-11-21 08:00:00 | AAPL | Stock | 229.95 | 229.95 | 228.02 | 229.1001 | 72597.0 |
| 2024-11-21 08:30:00 | AAPL | Stock | 229.17 | 229.8 | 229.1 | 229.63 | 52359.0 |
| 2024-11-21 09:00:00 | AAPL | Stock | 229.6 | 229.7 | 228.5 | 228.85 | 116262.0 |
| 2024-11-21 09:30:00 | AAPL | Stock | 228.85 | 229.93 | 226.83 | 227.0 | 4199155.0 |
| 2024-11-21 10:00:00 | AAPL | Stock | 227.0 | 227.32 | 225.7103 | 225.95 | 2627063.0 |
| 2024-11-21 10:30:00 | AAPL | Stock | 225.94 | 228.35 | 225.83 | 228.34 | 2028276.0 |
| 2024-11-21 11:00:00 | AAPL | Stock | 228.34 | 228.92 | 228.07 | 228.77 | 1688333.0 |
| 2024-11-21 11:30:00 | AAPL | Stock | 228.75 | 229.12 | 228.48 | 228.8612 | 1227028.0 |
| 2024-11-21 12:00:00 | AAPL | Stock | 228.86 | 229.4699 | 228.6 | 229.295 | 1178441.0 |
| 2024-11-21 12:30:00 | AAPL | Stock | 229.31 | 230.155 | 229.27 | 229.7833 | 1613162.0 |
| 2024-11-21 13:00:00 | AAPL | Stock | 229.78 | 230.0499 | 229.63 | 229.84 | 813262.0 |
| 2024-11-21 13:30:00 | AAPL | Stock | 229.85 | 229.9337 | 229.215 | 229.47 | 1026591.0 |
| 2024-11-21 14:00:00 | AAPL | Stock | 229.47 | 229.67 | 229.23 | 229.36 | 1024070.0 |
| 2024-11-21 14:30:00 | AAPL | Stock | 229.38 | 229.425 | 228.99 | 229.38 | 889275.0 |
| 2024-11-21 15:00:00 | AAPL | Stock | 229.38 | 229.58 | 229.04 | 229.27 | 1049902.0 |
| 2024-11-21 15:30:00 | AAPL | Stock | 229.27 | 229.29 | 228.27 | 228.51 | 2877444.0 |
| 2024-11-21 16:00:00 | AAPL | Stock | 228.52 | 228.91 | 228.25 | 228.4001 | 6613639.0 |
| 2024-11-21 16:30:00 | AAPL | Stock | 228.49 | 228.7199 | 228.28 | 228.36 | 170550.0 |
| 2024-11-21 17:00:00 | AAPL | Stock | 228.37 | 228.52 | 228.37 | 228.52 | 2152.0 |
| 2024-11-21 17:30:00 | AAPL | Stock | 228.72 | 228.75 | 228.25 | 228.35 | 13070.0 |
| 2024-11-21 18:00:00 | AAPL | Stock | 228.32 | 228.52 | 228.16 | 228.43 | 18002.0 |
| 2024-11-21 18:30:00 | AAPL | Stock | 228.45 | 228.56 | 228.11 | 228.2301 | 6302.0 |
| 2024-11-21 19:00:00 | AAPL | Stock | 228.25 | 228.5 | 228.23 | 228.5 | 2043.0 |
| 2024-11-21 19:30:00 | AAPL | Stock | 228.4951 | 228.56 | 228.1 | 228.56 | 4831.0 |
| 2024-11-21 04:00:00 | MSFT | Stock | 414.5 | 414.54 | 412.7 | 412.7 | 3173.0 |
| 2024-11-21 04:30:00 | MSFT | Stock | 412.87 | 413.79 | 412.87 | 413.6 | 400.0 |
| 2024-11-21 05:00:00 | MSFT | Stock | 413.99 | 413.99 | 413.92 | 413.92 | 200.0 |
| 2024-11-21 05:30:00 | MSFT | Stock | 414.18 | 414.18 | 414.18 | 414.18 | 250.0 |
| 2024-11-21 06:00:00 | MSFT | Stock | 414.18 | 414.98 | 414.18 | 414.98 | 832.0 |
| 2024-11-21 06:30:00 | MSFT | Stock | 415.25 | 415.25 | 414.7 | 414.96 | 715.0 |
| 2024-11-21 07:00:00 | MSFT | Stock | 414.98 | 416.44 | 414.98 | 415.85 | 2309.0 |
| 2024-11-21 07:30:00 | MSFT | Stock | 416.05 | 416.37 | 415.45 | 415.63 | 3715.0 |
| 2024-11-21 08:00:00 | MSFT | Stock | 415.52 | 416.8 | 414.7 | 416.0866 | 25102.0 |
| 2024-11-21 08:30:00 | MSFT | Stock | 416.59 | 417.52 | 416.4454 | 417.01 | 20780.0 |
| 2024-11-21 09:00:00 | MSFT | Stock | 417.15 | 419.97 | 417.0 | 419.6 | 43159.0 |
| 2024-11-21 09:30:00 | MSFT | Stock | 419.5 | 419.78 | 413.64 | 414.045 | 1698363.0 |
| 2024-11-21 10:00:00 | MSFT | Stock | 413.97 | 414.3 | 411.01 | 411.29 | 997605.0 |
| 2024-11-21 10:30:00 | MSFT | Stock | 411.115 | 414.08 | 410.2887 | 413.78 | 963971.0 |
| 2024-11-21 11:00:00 | MSFT | Stock | 413.84 | 415.599 | 413.68 | 415.515 | 734888.0 |
| 2024-11-21 11:30:00 | MSFT | Stock | 415.53 | 415.6 | 412.67 | 412.925 | 467660.0 |
| 2024-11-21 12:00:00 | MSFT | Stock | 412.91 | 414.66 | 411.78 | 414.24 | 451684.0 |
| 2024-11-21 12:30:00 | MSFT | Stock | 414.25 | 415.94 | 414.19 | 415.04 | 383443.0 |
> showing 50 of 104,595 rows — these rows as CSV