PREVIEW / stock_30min / 2024-10-21
file: by_date/stock_30min/2024/2024-10-21.parquet size: 2.1 MB rows: 102,380 symbols: 736
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-10-21 04:00:00 | AAPL | Stock | 234.8 | 234.8 | 233.75 | 234.26 | 16770.0 |
| 2024-10-21 04:30:00 | AAPL | Stock | 234.24 | 234.4 | 234.1 | 234.4 | 1940.0 |
| 2024-10-21 05:00:00 | AAPL | Stock | 234.42 | 234.53 | 234.1 | 234.1 | 5998.0 |
| 2024-10-21 05:30:00 | AAPL | Stock | 234.06 | 234.34 | 234.0 | 234.03 | 4268.0 |
| 2024-10-21 06:00:00 | AAPL | Stock | 234.02 | 234.25 | 234.0 | 234.0 | 6898.0 |
| 2024-10-21 06:30:00 | AAPL | Stock | 234.0 | 234.1 | 233.3 | 233.52 | 14533.0 |
| 2024-10-21 07:00:00 | AAPL | Stock | 233.52 | 233.94 | 233.3 | 233.57 | 18378.0 |
| 2024-10-21 07:30:00 | AAPL | Stock | 233.56 | 233.75 | 233.53 | 233.75 | 11049.0 |
| 2024-10-21 08:00:00 | AAPL | Stock | 233.79 | 234.87 | 233.4999 | 233.8599 | 80341.0 |
| 2024-10-21 08:30:00 | AAPL | Stock | 233.8 | 233.994 | 233.7289 | 233.85 | 24008.0 |
| 2024-10-21 09:00:00 | AAPL | Stock | 233.85 | 234.61 | 233.5 | 234.5 | 91965.0 |
| 2024-10-21 09:30:00 | AAPL | Stock | 234.5 | 235.5 | 234.45 | 235.1703 | 2873736.0 |
| 2024-10-21 10:00:00 | AAPL | Stock | 235.175 | 236.0 | 234.955 | 235.67 | 1733582.0 |
| 2024-10-21 10:30:00 | AAPL | Stock | 235.67 | 236.09 | 235.12 | 235.88 | 1492643.0 |
| 2024-10-21 11:00:00 | AAPL | Stock | 235.88 | 236.1 | 235.17 | 235.42 | 1201284.0 |
| 2024-10-21 11:30:00 | AAPL | Stock | 235.4 | 236.4591 | 235.28 | 236.24 | 1236353.0 |
| 2024-10-21 12:00:00 | AAPL | Stock | 236.23 | 236.61 | 235.94 | 236.28 | 1035726.0 |
| 2024-10-21 12:30:00 | AAPL | Stock | 236.29 | 236.57 | 236.114 | 236.51 | 682249.0 |
| 2024-10-21 13:00:00 | AAPL | Stock | 236.51 | 236.615 | 236.24 | 236.3701 | 708753.0 |
| 2024-10-21 13:30:00 | AAPL | Stock | 236.38 | 236.85 | 236.2 | 236.67 | 759356.0 |
| 2024-10-21 14:00:00 | AAPL | Stock | 236.69 | 236.81 | 236.2 | 236.225 | 776229.0 |
| 2024-10-21 14:30:00 | AAPL | Stock | 236.23 | 236.27 | 235.93 | 235.985 | 687946.0 |
| 2024-10-21 15:00:00 | AAPL | Stock | 235.99 | 236.22 | 235.89 | 236.135 | 901795.0 |
| 2024-10-21 15:30:00 | AAPL | Stock | 236.135 | 236.58 | 235.8275 | 236.58 | 2116572.0 |
| 2024-10-21 16:00:00 | AAPL | Stock | 236.46 | 236.81 | 236.2 | 236.59 | 6406109.0 |
| 2024-10-21 16:30:00 | AAPL | Stock | 236.6 | 236.6347 | 236.48 | 236.55 | 48174.0 |
| 2024-10-21 17:00:00 | AAPL | Stock | 236.57 | 236.62 | 236.48 | 236.58 | 167322.0 |
| 2024-10-21 17:30:00 | AAPL | Stock | 236.59 | 236.61 | 236.59 | 236.6 | 5747.0 |
| 2024-10-21 18:00:00 | AAPL | Stock | 236.6 | 236.61 | 236.55 | 236.6 | 5263.0 |
| 2024-10-21 18:30:00 | AAPL | Stock | 236.56 | 236.58 | 236.49 | 236.49 | 4761.0 |
| 2024-10-21 19:00:00 | AAPL | Stock | 236.56 | 236.56 | 236.5 | 236.52 | 5135.0 |
| 2024-10-21 19:30:00 | AAPL | Stock | 236.52 | 236.6 | 236.24 | 236.57 | 8532.0 |
| 2024-10-21 04:00:00 | MSFT | Stock | 417.5 | 417.69 | 417.37 | 417.49 | 1365.0 |
| 2024-10-21 04:30:00 | MSFT | Stock | 417.49 | 417.49 | 417.4 | 417.48 | 1002.0 |
| 2024-10-21 05:00:00 | MSFT | Stock | 417.48 | 417.48 | 417.0 | 417.0 | 1141.0 |
| 2024-10-21 05:30:00 | MSFT | Stock | 416.73 | 416.98 | 416.6 | 416.86 | 4618.0 |
| 2024-10-21 06:00:00 | MSFT | Stock | 416.91 | 417.0 | 416.91 | 417.0 | 1045.0 |
| 2024-10-21 06:30:00 | MSFT | Stock | 417.13 | 417.13 | 416.5 | 416.52 | 995.0 |
| 2024-10-21 07:00:00 | MSFT | Stock | 416.71 | 416.71 | 415.95 | 416.07 | 7355.0 |
| 2024-10-21 07:30:00 | MSFT | Stock | 416.07 | 416.45 | 416.0 | 416.26 | 1626.0 |
| 2024-10-21 08:00:00 | MSFT | Stock | 416.7 | 418.53 | 415.8 | 416.9925 | 25780.0 |
| 2024-10-21 08:30:00 | MSFT | Stock | 416.99 | 417.19 | 416.5 | 417.05 | 8894.0 |
| 2024-10-21 09:00:00 | MSFT | Stock | 416.95 | 417.5 | 415.55 | 416.02 | 22874.0 |
| 2024-10-21 09:30:00 | MSFT | Stock | 416.19 | 418.1 | 415.4 | 416.88 | 1089674.0 |
| 2024-10-21 10:00:00 | MSFT | Stock | 416.905 | 417.79 | 416.67 | 417.0746 | 519874.0 |
| 2024-10-21 10:30:00 | MSFT | Stock | 417.065 | 417.13 | 414.58 | 415.0 | 737798.0 |
| 2024-10-21 11:00:00 | MSFT | Stock | 415.005 | 415.215 | 413.81 | 413.95 | 480554.0 |
| 2024-10-21 11:30:00 | MSFT | Stock | 413.95 | 415.43 | 413.7501 | 415.11 | 436008.0 |
| 2024-10-21 12:00:00 | MSFT | Stock | 415.1 | 415.37 | 414.66 | 415.15 | 278965.0 |
| 2024-10-21 12:30:00 | MSFT | Stock | 415.185 | 416.25 | 415.185 | 415.8432 | 221629.0 |
> showing 50 of 102,380 rows — these rows as CSV