PREVIEW / stock_30min / 2024-11-19
file: by_date/stock_30min/2024/2024-11-19.parquet size: 2.2 MB rows: 104,271 symbols: 707
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-19 04:00:00 | AAPL | Stock | 228.08 | 228.19 | 227.17 | 227.17 | 13259.0 |
| 2024-11-19 04:30:00 | AAPL | Stock | 227.02 | 227.18 | 226.73 | 227.05 | 11763.0 |
| 2024-11-19 05:00:00 | AAPL | Stock | 227.01 | 227.7 | 226.95 | 227.5 | 4955.0 |
| 2024-11-19 05:30:00 | AAPL | Stock | 227.54 | 227.7 | 227.5 | 227.69 | 3545.0 |
| 2024-11-19 06:00:00 | AAPL | Stock | 227.62 | 227.76 | 227.6 | 227.6 | 2276.0 |
| 2024-11-19 06:30:00 | AAPL | Stock | 227.57 | 227.73 | 227.5 | 227.73 | 1414.0 |
| 2024-11-19 07:00:00 | AAPL | Stock | 227.79 | 228.22 | 227.0 | 227.88 | 15115.0 |
| 2024-11-19 07:30:00 | AAPL | Stock | 227.9 | 228.0 | 227.5 | 227.84 | 19381.0 |
| 2024-11-19 08:00:00 | AAPL | Stock | 227.99 | 228.87 | 227.36 | 227.36 | 30750.0 |
| 2024-11-19 08:30:00 | AAPL | Stock | 227.36 | 227.36 | 225.87 | 225.87 | 41209.0 |
| 2024-11-19 09:00:00 | AAPL | Stock | 225.89 | 226.8 | 225.38 | 226.66 | 96228.0 |
| 2024-11-19 09:30:00 | AAPL | Stock | 226.65 | 228.55 | 226.65 | 228.435 | 3120872.0 |
| 2024-11-19 10:00:00 | AAPL | Stock | 228.43 | 228.865 | 228.03 | 228.85 | 1211625.0 |
| 2024-11-19 10:30:00 | AAPL | Stock | 228.84 | 229.45 | 228.68 | 229.05 | 1102352.0 |
| 2024-11-19 11:00:00 | AAPL | Stock | 229.06 | 229.61 | 229.05 | 229.31 | 916843.0 |
| 2024-11-19 11:30:00 | AAPL | Stock | 229.335 | 229.6799 | 229.19 | 229.34 | 858470.0 |
| 2024-11-19 12:00:00 | AAPL | Stock | 229.34 | 229.86 | 229.19 | 229.855 | 818282.0 |
| 2024-11-19 12:30:00 | AAPL | Stock | 229.855 | 230.16 | 229.315 | 229.4 | 1730809.0 |
| 2024-11-19 13:00:00 | AAPL | Stock | 229.39 | 229.82 | 229.24 | 229.555 | 678447.0 |
| 2024-11-19 13:30:00 | AAPL | Stock | 229.55 | 229.965 | 229.45 | 229.935 | 783793.0 |
| 2024-11-19 14:00:00 | AAPL | Stock | 229.94 | 229.99 | 229.355 | 229.39 | 811738.0 |
| 2024-11-19 14:30:00 | AAPL | Stock | 229.39 | 229.5 | 228.6527 | 228.79 | 1125395.0 |
| 2024-11-19 15:00:00 | AAPL | Stock | 228.78 | 228.88 | 228.35 | 228.44 | 959877.0 |
| 2024-11-19 15:30:00 | AAPL | Stock | 228.44 | 228.72 | 227.72 | 228.3 | 3129520.0 |
| 2024-11-19 16:00:00 | AAPL | Stock | 228.28 | 228.36 | 228.06 | 228.2 | 7435770.0 |
| 2024-11-19 16:30:00 | AAPL | Stock | 228.16 | 228.4 | 227.99 | 228.2 | 35083.0 |
| 2024-11-19 17:00:00 | AAPL | Stock | 228.18 | 228.27 | 228.0 | 228.01 | 10522.0 |
| 2024-11-19 17:30:00 | AAPL | Stock | 228.0201 | 228.05 | 228.01 | 228.05 | 3210.0 |
| 2024-11-19 18:00:00 | AAPL | Stock | 228.05 | 228.23 | 228.05 | 228.1 | 7362.0 |
| 2024-11-19 18:30:00 | AAPL | Stock | 228.14 | 228.28 | 228.0 | 228.0 | 2692.0 |
| 2024-11-19 19:00:00 | AAPL | Stock | 228.1 | 228.5 | 228.08 | 228.35 | 9492.0 |
| 2024-11-19 19:30:00 | AAPL | Stock | 228.42 | 228.74 | 228.23 | 228.5 | 5804.0 |
| 2024-11-19 04:00:00 | MSFT | Stock | 414.95 | 415.95 | 414.0 | 414.0 | 4099.0 |
| 2024-11-19 04:30:00 | MSFT | Stock | 413.5 | 414.96 | 413.0 | 414.96 | 4446.0 |
| 2024-11-19 05:00:00 | MSFT | Stock | 414.3 | 414.83 | 414.3 | 414.75 | 1070.0 |
| 2024-11-19 05:30:00 | MSFT | Stock | 414.12 | 414.81 | 414.12 | 414.81 | 1022.0 |
| 2024-11-19 06:00:00 | MSFT | Stock | 414.69 | 414.69 | 414.45 | 414.45 | 425.0 |
| 2024-11-19 06:30:00 | MSFT | Stock | 414.56 | 414.87 | 414.56 | 414.87 | 486.0 |
| 2024-11-19 07:00:00 | MSFT | Stock | 414.85 | 415.12 | 414.5 | 414.7 | 1658.0 |
| 2024-11-19 07:30:00 | MSFT | Stock | 414.65 | 415.0 | 414.5 | 414.98 | 4682.0 |
| 2024-11-19 08:00:00 | MSFT | Stock | 414.55 | 416.43 | 414.1616 | 414.51 | 21726.0 |
| 2024-11-19 08:30:00 | MSFT | Stock | 414.4 | 414.6987 | 412.11 | 412.3 | 18021.0 |
| 2024-11-19 09:00:00 | MSFT | Stock | 412.18 | 414.26 | 411.37 | 413.55 | 31281.0 |
| 2024-11-19 09:30:00 | MSFT | Stock | 413.11 | 414.0 | 411.55 | 412.79 | 1419468.0 |
| 2024-11-19 10:00:00 | MSFT | Stock | 412.84 | 413.12 | 411.64 | 413.12 | 641276.0 |
| 2024-11-19 10:30:00 | MSFT | Stock | 413.09 | 413.92 | 412.79 | 413.2285 | 511065.0 |
| 2024-11-19 11:00:00 | MSFT | Stock | 413.215 | 413.96 | 412.68 | 413.92 | 513366.0 |
| 2024-11-19 11:30:00 | MSFT | Stock | 413.94 | 415.39 | 413.81 | 414.775 | 563337.0 |
| 2024-11-19 12:00:00 | MSFT | Stock | 414.755 | 415.36 | 414.14 | 415.1 | 285774.0 |
| 2024-11-19 12:30:00 | MSFT | Stock | 415.15 | 415.84 | 415.06 | 415.68 | 277347.0 |
> showing 50 of 104,271 rows — these rows as CSV