PREVIEW / stock_30min / 2024-09-11
file: by_date/stock_30min/2024/2024-09-11.parquet size: 2.0 MB rows: 97,694 symbols: 874
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-09-11 04:00:00 | AAPL | Stock | 217.8 | 219.53 | 217.12 | 219.5 | 8488.0 |
| 2024-09-11 04:30:00 | AAPL | Stock | 219.5 | 219.5 | 219.0 | 219.22 | 4208.0 |
| 2024-09-11 05:00:00 | AAPL | Stock | 219.47 | 219.47 | 219.47 | 219.47 | 405.0 |
| 2024-09-11 05:30:00 | AAPL | Stock | 219.43 | 219.54 | 219.39 | 219.39 | 1113.0 |
| 2024-09-11 06:00:00 | AAPL | Stock | 219.56 | 219.6 | 219.44 | 219.6 | 2763.0 |
| 2024-09-11 06:30:00 | AAPL | Stock | 219.42 | 219.63 | 219.42 | 219.63 | 9083.0 |
| 2024-09-11 07:00:00 | AAPL | Stock | 219.6 | 219.72 | 219.58 | 219.67 | 3041.0 |
| 2024-09-11 07:30:00 | AAPL | Stock | 219.67 | 220.0 | 219.64 | 219.88 | 9456.0 |
| 2024-09-11 08:00:00 | AAPL | Stock | 219.62 | 220.32 | 219.4 | 220.3 | 60571.0 |
| 2024-09-11 08:30:00 | AAPL | Stock | 220.35 | 220.65 | 219.0 | 220.46 | 100097.0 |
| 2024-09-11 09:00:00 | AAPL | Stock | 220.6 | 221.85 | 220.6 | 221.47 | 105922.0 |
| 2024-09-11 09:30:00 | AAPL | Stock | 221.49 | 223.09 | 220.15 | 220.505 | 4234237.0 |
| 2024-09-11 10:00:00 | AAPL | Stock | 220.55 | 221.01 | 219.15 | 219.25 | 2404386.0 |
| 2024-09-11 10:30:00 | AAPL | Stock | 219.24 | 219.34 | 217.89 | 218.59 | 2076475.0 |
| 2024-09-11 11:00:00 | AAPL | Stock | 218.55 | 219.21 | 218.04 | 218.9 | 1443574.0 |
| 2024-09-11 11:30:00 | AAPL | Stock | 218.9 | 220.35 | 218.67 | 219.68 | 1448239.0 |
| 2024-09-11 12:00:00 | AAPL | Stock | 219.6999 | 220.95 | 219.65 | 220.8352 | 1506317.0 |
| 2024-09-11 12:30:00 | AAPL | Stock | 220.86 | 221.33 | 220.51 | 221.0728 | 967421.0 |
| 2024-09-11 13:00:00 | AAPL | Stock | 221.07 | 221.85 | 220.99 | 221.2097 | 1277362.0 |
| 2024-09-11 13:30:00 | AAPL | Stock | 221.22 | 221.59 | 220.84 | 221.08 | 1340479.0 |
| 2024-09-11 14:00:00 | AAPL | Stock | 221.08 | 221.71 | 220.86 | 221.62 | 1319281.0 |
| 2024-09-11 14:30:00 | AAPL | Stock | 221.65 | 221.79 | 221.15 | 221.45 | 1398571.0 |
| 2024-09-11 15:00:00 | AAPL | Stock | 221.44 | 221.97 | 221.105 | 221.97 | 1858289.0 |
| 2024-09-11 15:30:00 | AAPL | Stock | 221.965 | 223.0 | 221.68 | 222.86 | 4440884.0 |
| 2024-09-11 16:00:00 | AAPL | Stock | 222.55 | 222.6697 | 221.9 | 222.1592 | 6893940.0 |
| 2024-09-11 16:30:00 | AAPL | Stock | 222.19 | 222.66 | 222.05 | 222.2 | 150652.0 |
| 2024-09-11 17:00:00 | AAPL | Stock | 222.22 | 222.22 | 222.0 | 222.0 | 12624.0 |
| 2024-09-11 17:30:00 | AAPL | Stock | 222.01 | 222.08 | 221.87 | 222.0 | 14431.0 |
| 2024-09-11 18:00:00 | AAPL | Stock | 222.09 | 222.1 | 221.93 | 222.07 | 8147.0 |
| 2024-09-11 18:30:00 | AAPL | Stock | 222.05 | 222.32 | 221.9624 | 222.32 | 28093.0 |
| 2024-09-11 19:00:00 | AAPL | Stock | 222.3 | 222.36 | 222.12 | 222.12 | 11477.0 |
| 2024-09-11 19:30:00 | AAPL | Stock | 222.18 | 222.18 | 221.95 | 222.1445 | 9548.0 |
| 2024-09-11 04:00:00 | MSFT | Stock | 414.59 | 414.6 | 414.12 | 414.47 | 1119.0 |
| 2024-09-11 04:30:00 | MSFT | Stock | 414.27 | 414.27 | 414.03 | 414.03 | 565.0 |
| 2024-09-11 05:00:00 | MSFT | Stock | 414.04 | 414.18 | 414.01 | 414.01 | 526.0 |
| 2024-09-11 06:00:00 | MSFT | Stock | 414.39 | 414.39 | 414.39 | 414.39 | 100.0 |
| 2024-09-11 06:30:00 | MSFT | Stock | 414.21 | 414.21 | 414.17 | 414.2 | 669.0 |
| 2024-09-11 07:00:00 | MSFT | Stock | 414.2 | 414.2 | 413.89 | 414.2 | 3046.0 |
| 2024-09-11 07:30:00 | MSFT | Stock | 414.18 | 414.4 | 413.98 | 414.4 | 3349.0 |
| 2024-09-11 08:00:00 | MSFT | Stock | 413.705 | 414.45 | 413.705 | 414.4226 | 9100.0 |
| 2024-09-11 08:30:00 | MSFT | Stock | 414.45 | 415.29 | 412.15 | 415.2 | 25333.0 |
| 2024-09-11 09:00:00 | MSFT | Stock | 415.2 | 417.32 | 414.52 | 414.94 | 53611.0 |
| 2024-09-11 09:30:00 | MSFT | Stock | 415.5 | 417.01 | 414.25 | 415.27 | 1267825.0 |
| 2024-09-11 10:00:00 | MSFT | Stock | 415.31 | 415.35 | 411.84 | 411.91 | 542016.0 |
| 2024-09-11 10:30:00 | MSFT | Stock | 411.96 | 412.15 | 409.745 | 410.38 | 583057.0 |
| 2024-09-11 11:00:00 | MSFT | Stock | 410.31 | 411.89 | 409.58 | 411.6 | 393008.0 |
| 2024-09-11 11:30:00 | MSFT | Stock | 411.58 | 414.0 | 411.19 | 413.79 | 446853.0 |
| 2024-09-11 12:00:00 | MSFT | Stock | 413.81 | 416.0 | 413.65 | 415.96 | 397653.0 |
| 2024-09-11 12:30:00 | MSFT | Stock | 415.99 | 416.56 | 415.28 | 415.95 | 295906.0 |
| 2024-09-11 13:00:00 | MSFT | Stock | 416.005 | 417.25 | 415.85 | 417.06 | 435076.0 |
> showing 50 of 97,694 rows — these rows as CSV