PREVIEW / stock_30min / 2024-10-30
file: by_date/stock_30min/2024/2024-10-30.parquet size: 2.1 MB rows: 101,677 symbols: 742
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-30 04:00:00 | AAPL | Stock | 233.03 | 233.31 | 232.5 | 233.3 | 20057.0 |
| 2024-10-30 04:30:00 | AAPL | Stock | 233.24 | 233.3 | 233.04 | 233.12 | 4891.0 |
| 2024-10-30 05:00:00 | AAPL | Stock | 233.03 | 233.12 | 232.92 | 233.04 | 3761.0 |
| 2024-10-30 05:30:00 | AAPL | Stock | 233.1 | 233.2 | 233.09 | 233.13 | 410.0 |
| 2024-10-30 06:00:00 | AAPL | Stock | 233.15 | 233.16 | 233.01 | 233.02 | 5400.0 |
| 2024-10-30 06:30:00 | AAPL | Stock | 233.03 | 233.16 | 232.95 | 233.02 | 6765.0 |
| 2024-10-30 07:00:00 | AAPL | Stock | 233.0 | 233.4 | 233.0 | 233.16 | 16561.0 |
| 2024-10-30 07:30:00 | AAPL | Stock | 233.17 | 233.4 | 232.89 | 233.07 | 24870.0 |
| 2024-10-30 08:00:00 | AAPL | Stock | 233.25 | 233.4 | 232.71 | 233.0 | 59225.0 |
| 2024-10-30 08:30:00 | AAPL | Stock | 232.9 | 233.0 | 232.74 | 232.753 | 21463.0 |
| 2024-10-30 09:00:00 | AAPL | Stock | 232.89 | 232.89 | 232.3104 | 232.6 | 62212.0 |
| 2024-10-30 09:30:00 | AAPL | Stock | 232.63 | 233.2299 | 231.85 | 232.58 | 3384699.0 |
| 2024-10-30 10:00:00 | AAPL | Stock | 232.599 | 232.782 | 231.69 | 231.86 | 1860016.0 |
| 2024-10-30 10:30:00 | AAPL | Stock | 231.8669 | 231.95 | 231.14 | 231.156 | 1853870.0 |
| 2024-10-30 11:00:00 | AAPL | Stock | 231.16 | 231.6 | 230.505 | 231.555 | 2010836.0 |
| 2024-10-30 11:30:00 | AAPL | Stock | 231.56 | 231.665 | 231.09 | 231.3899 | 1354298.0 |
| 2024-10-30 12:00:00 | AAPL | Stock | 231.385 | 231.55 | 231.06 | 231.1999 | 913816.0 |
| 2024-10-30 12:30:00 | AAPL | Stock | 231.2 | 231.39 | 230.92 | 230.92 | 798903.0 |
| 2024-10-30 13:00:00 | AAPL | Stock | 230.9183 | 231.05 | 230.23 | 230.2411 | 1088699.0 |
| 2024-10-30 13:30:00 | AAPL | Stock | 230.245 | 230.44 | 229.8704 | 230.2188 | 1437852.0 |
| 2024-10-30 14:00:00 | AAPL | Stock | 230.215 | 231.03 | 230.2111 | 230.65 | 1269751.0 |
| 2024-10-30 14:30:00 | AAPL | Stock | 230.625 | 230.89 | 230.43 | 230.505 | 865296.0 |
| 2024-10-30 15:00:00 | AAPL | Stock | 230.51 | 230.94 | 230.15 | 230.73 | 1224235.0 |
| 2024-10-30 15:30:00 | AAPL | Stock | 230.73 | 230.84 | 229.55 | 230.22 | 4360396.0 |
| 2024-10-30 16:00:00 | AAPL | Stock | 229.91 | 230.69 | 229.52 | 230.09 | 9963501.0 |
| 2024-10-30 16:30:00 | AAPL | Stock | 230.1 | 230.12 | 229.57 | 229.68 | 60219.0 |
| 2024-10-30 17:00:00 | AAPL | Stock | 229.65 | 230.16 | 229.62 | 230.07 | 83723.0 |
| 2024-10-30 17:30:00 | AAPL | Stock | 230.0 | 230.11 | 229.6 | 229.95 | 12792.0 |
| 2024-10-30 18:00:00 | AAPL | Stock | 229.66 | 230.7 | 229.6 | 230.7 | 66488.0 |
| 2024-10-30 18:30:00 | AAPL | Stock | 230.61 | 230.61 | 230.3113 | 230.61 | 20655.0 |
| 2024-10-30 19:00:00 | AAPL | Stock | 230.5 | 230.6 | 230.36 | 230.39 | 10547.0 |
| 2024-10-30 19:30:00 | AAPL | Stock | 230.48 | 230.86 | 230.43 | 230.7 | 25751.0 |
| 2024-10-30 04:00:00 | MSFT | Stock | 437.5 | 440.47 | 437.5 | 440.26 | 29136.0 |
| 2024-10-30 04:30:00 | MSFT | Stock | 440.26 | 441.26 | 439.28 | 441.25 | 13021.0 |
| 2024-10-30 05:00:00 | MSFT | Stock | 441.44 | 441.49 | 440.2 | 440.8 | 22414.0 |
| 2024-10-30 05:30:00 | MSFT | Stock | 441.0 | 441.49 | 440.3 | 440.3 | 11036.0 |
| 2024-10-30 06:00:00 | MSFT | Stock | 440.4 | 441.0 | 440.3 | 441.0 | 8545.0 |
| 2024-10-30 06:30:00 | MSFT | Stock | 441.0 | 441.22 | 440.32 | 440.51 | 9261.0 |
| 2024-10-30 07:00:00 | MSFT | Stock | 440.55 | 441.0 | 440.02 | 440.59 | 24750.0 |
| 2024-10-30 07:30:00 | MSFT | Stock | 440.6 | 441.0 | 440.25 | 440.6 | 22188.0 |
| 2024-10-30 08:00:00 | MSFT | Stock | 440.21 | 441.0 | 437.09 | 440.2 | 113778.0 |
| 2024-10-30 08:30:00 | MSFT | Stock | 440.27 | 440.7 | 439.91 | 440.15 | 27420.0 |
| 2024-10-30 09:00:00 | MSFT | Stock | 440.04 | 440.45 | 437.05 | 437.2 | 99670.0 |
| 2024-10-30 09:30:00 | MSFT | Stock | 437.37 | 438.5 | 432.58 | 434.905 | 2566620.0 |
| 2024-10-30 10:00:00 | MSFT | Stock | 434.835 | 438.26 | 434.81 | 437.87 | 1106843.0 |
| 2024-10-30 10:30:00 | MSFT | Stock | 437.865 | 438.29 | 435.76 | 436.31 | 887561.0 |
| 2024-10-30 11:00:00 | MSFT | Stock | 436.31 | 437.14 | 435.6401 | 436.7899 | 730975.0 |
| 2024-10-30 11:30:00 | MSFT | Stock | 436.79 | 436.9 | 435.41 | 436.61 | 618461.0 |
| 2024-10-30 12:00:00 | MSFT | Stock | 436.57 | 437.18 | 436.12 | 436.3299 | 483865.0 |
| 2024-10-30 12:30:00 | MSFT | Stock | 436.315 | 437.45 | 436.24 | 437.2 | 493134.0 |
> showing 50 of 101,677 rows — these rows as CSV