PREVIEW / stock_30min / 2024-08-28
file: by_date/stock_30min/2024/2024-08-28.parquet size: 2.0 MB rows: 97,323 symbols: 823
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-28 04:00:00 | AAPL | Stock | 228.0 | 228.5 | 228.0 | 228.5 | 4267.0 |
| 2024-08-28 04:30:00 | AAPL | Stock | 228.51 | 229.0 | 228.51 | 228.9 | 10347.0 |
| 2024-08-28 05:00:00 | AAPL | Stock | 228.9 | 228.97 | 228.6 | 228.86 | 3242.0 |
| 2024-08-28 05:30:00 | AAPL | Stock | 228.82 | 228.82 | 228.58 | 228.58 | 1401.0 |
| 2024-08-28 06:00:00 | AAPL | Stock | 228.61 | 228.64 | 228.59 | 228.59 | 1611.0 |
| 2024-08-28 06:30:00 | AAPL | Stock | 228.59 | 228.66 | 228.5 | 228.65 | 3425.0 |
| 2024-08-28 07:00:00 | AAPL | Stock | 228.54 | 228.68 | 228.49 | 228.5 | 5040.0 |
| 2024-08-28 07:30:00 | AAPL | Stock | 228.46 | 228.52 | 228.23 | 228.25 | 4804.0 |
| 2024-08-28 08:00:00 | AAPL | Stock | 228.6 | 228.6 | 227.84 | 228.35 | 34464.0 |
| 2024-08-28 08:30:00 | AAPL | Stock | 228.35 | 228.41 | 228.15 | 228.28 | 27953.0 |
| 2024-08-28 09:00:00 | AAPL | Stock | 228.3 | 228.3548 | 227.58 | 227.9 | 69125.0 |
| 2024-08-28 09:30:00 | AAPL | Stock | 227.92 | 229.64 | 227.87 | 228.6 | 3869909.0 |
| 2024-08-28 10:00:00 | AAPL | Stock | 228.6 | 229.66 | 228.282 | 229.64 | 2387634.0 |
| 2024-08-28 10:30:00 | AAPL | Stock | 229.63 | 229.86 | 227.43 | 227.48 | 2658856.0 |
| 2024-08-28 11:00:00 | AAPL | Stock | 227.45 | 227.71 | 226.33 | 226.81 | 1923305.0 |
| 2024-08-28 11:30:00 | AAPL | Stock | 226.8 | 226.9099 | 226.26 | 226.83 | 1396879.0 |
| 2024-08-28 12:00:00 | AAPL | Stock | 226.82 | 227.27 | 226.65 | 227.03 | 1352742.0 |
| 2024-08-28 12:30:00 | AAPL | Stock | 227.02 | 227.572 | 227.01 | 227.519 | 799247.0 |
| 2024-08-28 13:00:00 | AAPL | Stock | 227.515 | 227.76 | 227.0501 | 227.47 | 775389.0 |
| 2024-08-28 13:30:00 | AAPL | Stock | 227.461 | 227.6 | 225.8079 | 225.895 | 982554.0 |
| 2024-08-28 14:00:00 | AAPL | Stock | 225.895 | 226.3 | 225.68 | 226.08 | 980447.0 |
| 2024-08-28 14:30:00 | AAPL | Stock | 226.08 | 227.2299 | 225.955 | 227.1639 | 895079.0 |
| 2024-08-28 15:00:00 | AAPL | Stock | 227.16 | 227.64 | 226.97 | 227.46 | 1355008.0 |
| 2024-08-28 15:30:00 | AAPL | Stock | 227.45 | 227.54 | 226.25 | 226.51 | 2816585.0 |
| 2024-08-28 16:00:00 | AAPL | Stock | 226.49 | 226.49 | 225.59 | 225.73 | 5898202.0 |
| 2024-08-28 16:30:00 | AAPL | Stock | 225.81 | 226.49 | 225.6072 | 225.7 | 61814.0 |
| 2024-08-28 17:00:00 | AAPL | Stock | 225.8 | 226.49 | 225.75 | 226.2118 | 49378.0 |
| 2024-08-28 17:30:00 | AAPL | Stock | 226.21 | 226.5 | 226.0 | 226.25 | 45079.0 |
| 2024-08-28 18:00:00 | AAPL | Stock | 226.41 | 226.99 | 226.2018 | 226.44 | 49345.0 |
| 2024-08-28 18:30:00 | AAPL | Stock | 226.38 | 226.49 | 225.53 | 225.6396 | 26899.0 |
| 2024-08-28 19:00:00 | AAPL | Stock | 225.63 | 226.4 | 225.63 | 226.1 | 11515.0 |
| 2024-08-28 19:30:00 | AAPL | Stock | 226.11 | 226.24 | 225.7 | 225.7 | 21309.0 |
| 2024-08-28 04:00:00 | MSFT | Stock | 413.93 | 414.36 | 413.93 | 413.97 | 2927.0 |
| 2024-08-28 04:30:00 | MSFT | Stock | 414.2 | 414.74 | 414.2 | 414.74 | 869.0 |
| 2024-08-28 05:00:00 | MSFT | Stock | 414.79 | 414.79 | 414.43 | 414.53 | 1139.0 |
| 2024-08-28 05:30:00 | MSFT | Stock | 414.42 | 414.42 | 414.18 | 414.29 | 1153.0 |
| 2024-08-28 06:00:00 | MSFT | Stock | 414.32 | 414.32 | 414.32 | 414.32 | 200.0 |
| 2024-08-28 06:30:00 | MSFT | Stock | 414.2 | 414.29 | 414.17 | 414.29 | 675.0 |
| 2024-08-28 07:00:00 | MSFT | Stock | 414.21 | 414.21 | 414.0 | 414.0 | 2388.0 |
| 2024-08-28 07:30:00 | MSFT | Stock | 414.0 | 414.0 | 413.48 | 413.48 | 2473.0 |
| 2024-08-28 08:00:00 | MSFT | Stock | 414.2119 | 414.3 | 412.83 | 413.4 | 9215.0 |
| 2024-08-28 08:30:00 | MSFT | Stock | 413.83 | 413.98 | 413.83 | 413.97 | 1300.0 |
| 2024-08-28 09:00:00 | MSFT | Stock | 414.06 | 415.15 | 413.3017 | 415.0 | 16192.0 |
| 2024-08-28 09:30:00 | MSFT | Stock | 415.16 | 415.16 | 411.51 | 412.47 | 848322.0 |
| 2024-08-28 10:00:00 | MSFT | Stock | 412.575 | 412.72 | 411.44 | 412.4 | 432132.0 |
| 2024-08-28 10:30:00 | MSFT | Stock | 412.41 | 412.655 | 409.6 | 409.72 | 488171.0 |
| 2024-08-28 11:00:00 | MSFT | Stock | 409.74 | 409.94 | 407.72 | 409.1773 | 681900.0 |
| 2024-08-28 11:30:00 | MSFT | Stock | 409.081 | 409.2819 | 408.26 | 408.95 | 294942.0 |
| 2024-08-28 12:00:00 | MSFT | Stock | 408.95 | 409.58 | 408.39 | 409.0 | 314572.0 |
| 2024-08-28 12:30:00 | MSFT | Stock | 408.99 | 410.44 | 408.96 | 410.25 | 198350.0 |
> showing 50 of 97,323 rows — these rows as CSV