PREVIEW / stock_30min / 2024-08-22
file: by_date/stock_30min/2024/2024-08-22.parquet size: 2.0 MB rows: 96,410 symbols: 846
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-08-22 04:00:00 | AAPL | Stock | 226.2 | 226.52 | 226.2 | 226.5 | 4544.0 |
| 2024-08-22 04:30:00 | AAPL | Stock | 226.6 | 226.61 | 226.45 | 226.45 | 1346.0 |
| 2024-08-22 05:00:00 | AAPL | Stock | 226.57 | 226.59 | 226.57 | 226.59 | 200.0 |
| 2024-08-22 05:30:00 | AAPL | Stock | 226.46 | 226.59 | 226.4 | 226.4 | 1537.0 |
| 2024-08-22 06:00:00 | AAPL | Stock | 226.46 | 226.6 | 226.45 | 226.59 | 870.0 |
| 2024-08-22 06:30:00 | AAPL | Stock | 226.59 | 227.57 | 226.58 | 227.57 | 7067.0 |
| 2024-08-22 07:00:00 | AAPL | Stock | 227.12 | 227.6 | 224.8 | 227.35 | 36161.0 |
| 2024-08-22 07:30:00 | AAPL | Stock | 227.43 | 227.75 | 227.3 | 227.74 | 25538.0 |
| 2024-08-22 08:00:00 | AAPL | Stock | 226.44 | 227.8 | 226.1 | 227.1797 | 58120.0 |
| 2024-08-22 08:30:00 | AAPL | Stock | 227.05 | 227.5202 | 226.72 | 227.5202 | 37483.0 |
| 2024-08-22 09:00:00 | AAPL | Stock | 227.57 | 227.8793 | 227.12 | 227.85 | 57796.0 |
| 2024-08-22 09:30:00 | AAPL | Stock | 227.77 | 228.34 | 226.69 | 227.93 | 4205934.0 |
| 2024-08-22 10:00:00 | AAPL | Stock | 227.96 | 228.29 | 226.55 | 226.78 | 2315843.0 |
| 2024-08-22 10:30:00 | AAPL | Stock | 226.76 | 227.05 | 226.37 | 226.785 | 1095005.0 |
| 2024-08-22 11:00:00 | AAPL | Stock | 226.785 | 227.21 | 226.13 | 226.18 | 1456849.0 |
| 2024-08-22 11:30:00 | AAPL | Stock | 226.16 | 226.28 | 224.92 | 225.51 | 1553661.0 |
| 2024-08-22 12:00:00 | AAPL | Stock | 225.51 | 226.44 | 225.49 | 226.43 | 917246.0 |
| 2024-08-22 12:30:00 | AAPL | Stock | 226.435 | 226.61 | 225.32 | 225.505 | 1060614.0 |
| 2024-08-22 13:00:00 | AAPL | Stock | 225.51 | 225.8 | 225.0848 | 225.645 | 1138346.0 |
| 2024-08-22 13:30:00 | AAPL | Stock | 225.63 | 225.82 | 224.01 | 224.39 | 1850862.0 |
| 2024-08-22 14:00:00 | AAPL | Stock | 224.4 | 224.87 | 223.9 | 224.8599 | 1150766.0 |
| 2024-08-22 14:30:00 | AAPL | Stock | 224.86 | 224.93 | 224.34 | 224.4 | 803536.0 |
| 2024-08-22 15:00:00 | AAPL | Stock | 224.4 | 224.95 | 224.15 | 224.32 | 1087827.0 |
| 2024-08-22 15:30:00 | AAPL | Stock | 224.34 | 224.92 | 224.03 | 224.53 | 3621345.0 |
| 2024-08-22 16:00:00 | AAPL | Stock | 224.54 | 224.98 | 224.53 | 224.88 | 5361895.0 |
| 2024-08-22 16:30:00 | AAPL | Stock | 224.88 | 224.92 | 224.53 | 224.83 | 69006.0 |
| 2024-08-22 17:00:00 | AAPL | Stock | 224.85 | 224.95 | 224.53 | 224.95 | 215275.0 |
| 2024-08-22 17:30:00 | AAPL | Stock | 224.93 | 225.08 | 224.93 | 225.08 | 6712.0 |
| 2024-08-22 18:00:00 | AAPL | Stock | 225.08 | 225.08 | 224.95 | 225.0101 | 2537.0 |
| 2024-08-22 18:30:00 | AAPL | Stock | 225.08 | 225.19 | 225.01 | 225.05 | 5252.0 |
| 2024-08-22 19:00:00 | AAPL | Stock | 225.04 | 225.06 | 224.94 | 224.96 | 4390.0 |
| 2024-08-22 19:30:00 | AAPL | Stock | 225.0 | 225.1099 | 224.94 | 225.0011 | 9306.0 |
| 2024-08-22 04:00:00 | MSFT | Stock | 423.82 | 424.25 | 423.8 | 424.25 | 830.0 |
| 2024-08-22 04:30:00 | MSFT | Stock | 424.07 | 424.07 | 424.07 | 424.07 | 116.0 |
| 2024-08-22 05:00:00 | MSFT | Stock | 424.07 | 424.07 | 423.99 | 423.99 | 1167.0 |
| 2024-08-22 05:30:00 | MSFT | Stock | 423.63 | 423.64 | 423.63 | 423.64 | 300.0 |
| 2024-08-22 06:00:00 | MSFT | Stock | 423.96 | 423.96 | 423.96 | 423.96 | 100.0 |
| 2024-08-22 06:30:00 | MSFT | Stock | 424.17 | 424.26 | 424.16 | 424.16 | 419.0 |
| 2024-08-22 07:00:00 | MSFT | Stock | 424.14 | 424.54 | 423.91 | 424.46 | 10323.0 |
| 2024-08-22 07:30:00 | MSFT | Stock | 424.5 | 424.5 | 424.09 | 424.2 | 5342.0 |
| 2024-08-22 08:00:00 | MSFT | Stock | 424.1 | 424.5936 | 423.2 | 423.94 | 13887.0 |
| 2024-08-22 08:30:00 | MSFT | Stock | 423.83 | 424.3799 | 423.64 | 424.2 | 9198.0 |
| 2024-08-22 09:00:00 | MSFT | Stock | 424.2 | 424.38 | 423.3 | 424.38 | 25200.0 |
| 2024-08-22 09:30:00 | MSFT | Stock | 424.36 | 426.7899 | 424.06 | 425.545 | 1241834.0 |
| 2024-08-22 10:00:00 | MSFT | Stock | 425.56 | 425.93 | 423.46 | 423.8001 | 527224.0 |
| 2024-08-22 10:30:00 | MSFT | Stock | 423.79 | 423.79 | 421.4 | 421.51 | 528625.0 |
| 2024-08-22 11:00:00 | MSFT | Stock | 421.52 | 422.195 | 419.19 | 419.28 | 592802.0 |
| 2024-08-22 11:30:00 | MSFT | Stock | 419.2277 | 419.54 | 417.6 | 418.0499 | 660125.0 |
| 2024-08-22 12:00:00 | MSFT | Stock | 418.01 | 420.09 | 418.01 | 419.9315 | 376930.0 |
| 2024-08-22 12:30:00 | MSFT | Stock | 419.93 | 420.21 | 416.95 | 417.07 | 383776.0 |
> showing 50 of 96,410 rows — these rows as CSV