PREVIEW / stock_30min / 2024-08-30
file: by_date/stock_30min/2024/2024-08-30.parquet size: 2.0 MB rows: 96,003 symbols: 826
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-30 04:00:00 | AAPL | Stock | 230.55 | 231.09 | 230.55 | 230.75 | 6750.0 |
| 2024-08-30 04:30:00 | AAPL | Stock | 230.75 | 230.84 | 230.64 | 230.64 | 4585.0 |
| 2024-08-30 05:00:00 | AAPL | Stock | 230.68 | 230.71 | 230.64 | 230.64 | 4300.0 |
| 2024-08-30 05:30:00 | AAPL | Stock | 230.69 | 230.89 | 230.69 | 230.89 | 4569.0 |
| 2024-08-30 06:00:00 | AAPL | Stock | 230.85 | 230.98 | 230.8 | 230.91 | 4763.0 |
| 2024-08-30 06:30:00 | AAPL | Stock | 230.89 | 231.29 | 230.8 | 231.27 | 11433.0 |
| 2024-08-30 07:00:00 | AAPL | Stock | 231.29 | 231.29 | 230.91 | 231.15 | 11891.0 |
| 2024-08-30 07:30:00 | AAPL | Stock | 231.09 | 231.12 | 230.92 | 230.99 | 6256.0 |
| 2024-08-30 08:00:00 | AAPL | Stock | 231.3 | 231.3 | 229.88 | 231.2014 | 95613.0 |
| 2024-08-30 08:30:00 | AAPL | Stock | 231.31 | 231.75 | 230.5023 | 230.6019 | 87194.0 |
| 2024-08-30 09:00:00 | AAPL | Stock | 230.67 | 230.84 | 229.65 | 230.07 | 219114.0 |
| 2024-08-30 09:30:00 | AAPL | Stock | 230.19 | 230.4 | 228.81 | 229.07 | 4271905.0 |
| 2024-08-30 10:00:00 | AAPL | Stock | 229.1 | 229.32 | 228.5401 | 229.195 | 2411091.0 |
| 2024-08-30 10:30:00 | AAPL | Stock | 229.2 | 230.01 | 228.57 | 228.69 | 1853370.0 |
| 2024-08-30 11:00:00 | AAPL | Stock | 228.7 | 229.0 | 227.72 | 228.245 | 1835197.0 |
| 2024-08-30 11:30:00 | AAPL | Stock | 228.2315 | 228.775 | 227.545 | 228.62 | 1373150.0 |
| 2024-08-30 12:00:00 | AAPL | Stock | 228.61 | 228.875 | 227.94 | 228.03 | 991471.0 |
| 2024-08-30 12:30:00 | AAPL | Stock | 228.0202 | 228.49 | 227.48 | 228.36 | 1347316.0 |
| 2024-08-30 13:00:00 | AAPL | Stock | 228.37 | 228.72 | 227.92 | 228.15 | 797350.0 |
| 2024-08-30 13:30:00 | AAPL | Stock | 228.135 | 228.32 | 227.6793 | 227.76 | 765354.0 |
| 2024-08-30 14:00:00 | AAPL | Stock | 227.77 | 228.06 | 227.66 | 227.99 | 1088092.0 |
| 2024-08-30 14:30:00 | AAPL | Stock | 228.0 | 228.69 | 227.95 | 228.56 | 1140982.0 |
| 2024-08-30 15:00:00 | AAPL | Stock | 228.56 | 229.05 | 228.24 | 229.04 | 1504883.0 |
| 2024-08-30 15:30:00 | AAPL | Stock | 229.04 | 229.85 | 228.38 | 228.86 | 5656991.0 |
| 2024-08-30 16:00:00 | AAPL | Stock | 229.04 | 229.23 | 228.65 | 228.93 | 16842567.0 |
| 2024-08-30 16:30:00 | AAPL | Stock | 228.94 | 229.09 | 228.9 | 228.9801 | 78381.0 |
| 2024-08-30 17:00:00 | AAPL | Stock | 229.0 | 229.16 | 229.0 | 229.11 | 14714.0 |
| 2024-08-30 17:30:00 | AAPL | Stock | 229.1 | 229.15 | 229.04 | 229.15 | 4232.0 |
| 2024-08-30 18:00:00 | AAPL | Stock | 229.09 | 229.09 | 229.01 | 229.05 | 6063.0 |
| 2024-08-30 18:30:00 | AAPL | Stock | 229.02 | 229.15 | 229.0 | 229.15 | 7419.0 |
| 2024-08-30 19:00:00 | AAPL | Stock | 229.14 | 229.18 | 229.05 | 229.05 | 4084.0 |
| 2024-08-30 19:30:00 | AAPL | Stock | 229.05 | 229.1991 | 229.0421 | 229.1114 | 6748.0 |
| 2024-08-30 04:00:00 | MSFT | Stock | 415.52 | 416.28 | 415.52 | 416.28 | 1245.0 |
| 2024-08-30 04:30:00 | MSFT | Stock | 416.24 | 416.4 | 416.24 | 416.4 | 300.0 |
| 2024-08-30 05:00:00 | MSFT | Stock | 416.59 | 416.62 | 416.5 | 416.5 | 1349.0 |
| 2024-08-30 05:30:00 | MSFT | Stock | 416.39 | 416.44 | 416.25 | 416.35 | 722.0 |
| 2024-08-30 06:00:00 | MSFT | Stock | 416.17 | 416.18 | 415.9 | 415.9 | 1327.0 |
| 2024-08-30 06:30:00 | MSFT | Stock | 415.95 | 416.3 | 415.95 | 416.3 | 1705.0 |
| 2024-08-30 07:00:00 | MSFT | Stock | 416.72 | 416.73 | 416.0 | 416.0 | 3253.0 |
| 2024-08-30 07:30:00 | MSFT | Stock | 415.87 | 416.0 | 415.83 | 415.88 | 2546.0 |
| 2024-08-30 08:00:00 | MSFT | Stock | 416.5 | 416.7 | 414.152 | 416.1 | 13049.0 |
| 2024-08-30 08:30:00 | MSFT | Stock | 416.237 | 416.25 | 414.9 | 415.18 | 20596.0 |
| 2024-08-30 09:00:00 | MSFT | Stock | 415.07 | 416.25 | 414.8 | 415.3 | 19095.0 |
| 2024-08-30 09:30:00 | MSFT | Stock | 414.91 | 417.02 | 414.19 | 416.625 | 1011230.0 |
| 2024-08-30 10:00:00 | MSFT | Stock | 416.69 | 417.39 | 415.4 | 415.95 | 417671.0 |
| 2024-08-30 10:30:00 | MSFT | Stock | 415.94 | 416.85 | 414.43 | 414.43 | 317060.0 |
| 2024-08-30 11:00:00 | MSFT | Stock | 414.43 | 415.6 | 413.95 | 415.25 | 384520.0 |
| 2024-08-30 11:30:00 | MSFT | Stock | 415.25 | 415.48 | 414.3 | 414.8 | 375382.0 |
| 2024-08-30 12:00:00 | MSFT | Stock | 414.8 | 414.845 | 412.85 | 413.04 | 392007.0 |
| 2024-08-30 12:30:00 | MSFT | Stock | 413.0401 | 414.17 | 412.13 | 413.92 | 317858.0 |
> showing 50 of 96,003 rows — these rows as CSV