PREVIEW / stock_30min / 2024-11-14
file: by_date/stock_30min/2024/2024-11-14.parquet size: 2.2 MB rows: 105,181 symbols: 703
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-14 04:00:00 | AAPL | Stock | 224.85 | 224.85 | 224.18 | 224.35 | 8858.0 |
| 2024-11-14 04:30:00 | AAPL | Stock | 224.35 | 224.46 | 224.21 | 224.22 | 3870.0 |
| 2024-11-14 05:00:00 | AAPL | Stock | 224.23 | 224.45 | 224.23 | 224.3 | 3577.0 |
| 2024-11-14 05:30:00 | AAPL | Stock | 224.47 | 224.51 | 224.41 | 224.42 | 2368.0 |
| 2024-11-14 06:00:00 | AAPL | Stock | 224.51 | 224.6 | 224.42 | 224.6 | 2885.0 |
| 2024-11-14 06:30:00 | AAPL | Stock | 224.6 | 224.88 | 224.6 | 224.6 | 7822.0 |
| 2024-11-14 07:00:00 | AAPL | Stock | 224.8 | 225.06 | 224.7 | 224.85 | 10000.0 |
| 2024-11-14 07:30:00 | AAPL | Stock | 224.81 | 225.04 | 224.61 | 224.7 | 6142.0 |
| 2024-11-14 08:00:00 | AAPL | Stock | 225.0 | 225.0999 | 224.22 | 224.95 | 35596.0 |
| 2024-11-14 08:30:00 | AAPL | Stock | 224.8 | 224.8704 | 224.37 | 224.75 | 29033.0 |
| 2024-11-14 09:00:00 | AAPL | Stock | 224.75 | 225.22 | 224.51 | 225.15 | 63071.0 |
| 2024-11-14 09:30:00 | AAPL | Stock | 225.11 | 226.48 | 225.0 | 225.7215 | 3316794.0 |
| 2024-11-14 10:00:00 | AAPL | Stock | 225.72 | 226.6 | 225.05 | 226.57 | 2093957.0 |
| 2024-11-14 10:30:00 | AAPL | Stock | 226.565 | 227.03 | 226.34 | 226.53 | 2047156.0 |
| 2024-11-14 11:00:00 | AAPL | Stock | 226.52 | 227.06 | 226.35 | 226.42 | 1270987.0 |
| 2024-11-14 11:30:00 | AAPL | Stock | 226.43 | 227.09 | 226.43 | 226.7401 | 923889.0 |
| 2024-11-14 12:00:00 | AAPL | Stock | 226.75 | 227.07 | 226.5122 | 227.0 | 766828.0 |
| 2024-11-14 12:30:00 | AAPL | Stock | 227.01 | 228.23 | 226.77 | 227.925 | 2134879.0 |
| 2024-11-14 13:00:00 | AAPL | Stock | 227.925 | 228.645 | 227.85 | 228.4728 | 1229485.0 |
| 2024-11-14 13:30:00 | AAPL | Stock | 228.4701 | 228.71 | 227.83 | 228.06 | 1210980.0 |
| 2024-11-14 14:00:00 | AAPL | Stock | 228.05 | 228.87 | 228.03 | 228.5275 | 1289457.0 |
| 2024-11-14 14:30:00 | AAPL | Stock | 228.51 | 228.72 | 228.21 | 228.27 | 1026497.0 |
| 2024-11-14 15:00:00 | AAPL | Stock | 228.275 | 228.28 | 226.98 | 227.035 | 1971512.0 |
| 2024-11-14 15:30:00 | AAPL | Stock | 227.035 | 228.38 | 227.035 | 228.19 | 3062797.0 |
| 2024-11-14 16:00:00 | AAPL | Stock | 228.19 | 228.25 | 227.51 | 227.79 | 7801645.0 |
| 2024-11-14 16:30:00 | AAPL | Stock | 227.75 | 228.22 | 227.66 | 227.81 | 56570.0 |
| 2024-11-14 17:00:00 | AAPL | Stock | 227.81 | 227.81 | 227.6044 | 227.65 | 7876.0 |
| 2024-11-14 17:30:00 | AAPL | Stock | 228.22 | 228.22 | 227.65 | 227.8219 | 26864.0 |
| 2024-11-14 18:00:00 | AAPL | Stock | 227.71 | 227.78 | 227.5019 | 227.5315 | 17017.0 |
| 2024-11-14 18:30:00 | AAPL | Stock | 227.5 | 227.57 | 227.5 | 227.5 | 3592.0 |
| 2024-11-14 19:00:00 | AAPL | Stock | 227.47 | 227.58 | 227.47 | 227.55 | 15043.0 |
| 2024-11-14 19:30:00 | AAPL | Stock | 227.53 | 227.57 | 227.36 | 227.42 | 4700.0 |
| 2024-11-14 04:00:00 | MSFT | Stock | 425.22 | 425.51 | 424.5 | 424.5 | 1995.0 |
| 2024-11-14 04:30:00 | MSFT | Stock | 424.8 | 424.8 | 424.8 | 424.8 | 100.0 |
| 2024-11-14 05:00:00 | MSFT | Stock | 424.83 | 424.9 | 424.82 | 424.9 | 2093.0 |
| 2024-11-14 05:30:00 | MSFT | Stock | 424.9 | 424.99 | 424.79 | 424.82 | 1953.0 |
| 2024-11-14 06:00:00 | MSFT | Stock | 425.03 | 425.03 | 425.03 | 425.03 | 103.0 |
| 2024-11-14 06:30:00 | MSFT | Stock | 425.03 | 425.12 | 424.82 | 424.99 | 3750.0 |
| 2024-11-14 07:00:00 | MSFT | Stock | 424.9 | 425.0 | 424.84 | 424.93 | 1706.0 |
| 2024-11-14 07:30:00 | MSFT | Stock | 424.8 | 425.05 | 424.64 | 424.64 | 3079.0 |
| 2024-11-14 08:00:00 | MSFT | Stock | 424.79 | 425.09 | 424.32 | 424.3331 | 9385.0 |
| 2024-11-14 08:30:00 | MSFT | Stock | 424.36 | 424.65 | 423.7 | 424.29 | 7956.0 |
| 2024-11-14 09:00:00 | MSFT | Stock | 424.13 | 425.0 | 423.67 | 425.0 | 16027.0 |
| 2024-11-14 09:30:00 | MSFT | Stock | 425.0 | 428.03 | 424.42 | 425.39 | 1672278.0 |
| 2024-11-14 10:00:00 | MSFT | Stock | 425.375 | 426.59 | 423.75 | 426.0 | 804020.0 |
| 2024-11-14 10:30:00 | MSFT | Stock | 425.96 | 427.31 | 425.64 | 425.91 | 562238.0 |
| 2024-11-14 11:00:00 | MSFT | Stock | 425.83 | 426.04 | 424.55 | 425.71 | 533993.0 |
| 2024-11-14 11:30:00 | MSFT | Stock | 425.71 | 427.565 | 425.42 | 427.04 | 797188.0 |
| 2024-11-14 12:00:00 | MSFT | Stock | 427.07 | 427.83 | 426.504 | 427.52 | 258078.0 |
| 2024-11-14 12:30:00 | MSFT | Stock | 427.52 | 428.17 | 420.0 | 423.7323 | 2530089.0 |
> showing 50 of 105,181 rows — these rows as CSV