PREVIEW / stock_30min / 2024-05-24
file: by_date/stock_30min/2024/2024-05-24.parquet size: 2.0 MB rows: 96,252 symbols: 946
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-05-24 04:00:00 | AAPL | Stock | 187.9 | 188.32 | 187.58 | 188.25 | 20034.0 |
| 2024-05-24 04:30:00 | AAPL | Stock | 188.25 | 188.65 | 188.25 | 188.4 | 11220.0 |
| 2024-05-24 05:00:00 | AAPL | Stock | 188.36 | 188.36 | 188.21 | 188.21 | 4167.0 |
| 2024-05-24 05:30:00 | AAPL | Stock | 188.21 | 188.21 | 188.07 | 188.07 | 1416.0 |
| 2024-05-24 06:00:00 | AAPL | Stock | 188.18 | 188.29 | 188.18 | 188.23 | 1708.0 |
| 2024-05-24 06:30:00 | AAPL | Stock | 188.25 | 188.4 | 188.25 | 188.35 | 3703.0 |
| 2024-05-24 07:00:00 | AAPL | Stock | 188.35 | 188.4 | 188.02 | 188.06 | 18998.0 |
| 2024-05-24 07:30:00 | AAPL | Stock | 188.15 | 188.15 | 187.94 | 188.01 | 7990.0 |
| 2024-05-24 08:00:00 | AAPL | Stock | 188.25 | 188.4 | 187.14 | 187.7603 | 70309.0 |
| 2024-05-24 08:30:00 | AAPL | Stock | 187.76 | 188.4 | 186.88 | 188.2 | 59905.0 |
| 2024-05-24 09:00:00 | AAPL | Stock | 188.23 | 188.8981 | 188.1601 | 188.8 | 61702.0 |
| 2024-05-24 09:30:00 | AAPL | Stock | 188.82 | 189.1858 | 188.0404 | 188.75 | 4639879.0 |
| 2024-05-24 10:00:00 | AAPL | Stock | 188.75 | 189.52 | 188.67 | 189.52 | 2644453.0 |
| 2024-05-24 10:30:00 | AAPL | Stock | 189.515 | 189.75 | 189.26 | 189.7401 | 1703432.0 |
| 2024-05-24 11:00:00 | AAPL | Stock | 189.75 | 190.29 | 189.65 | 190.12 | 2260510.0 |
| 2024-05-24 11:30:00 | AAPL | Stock | 190.11 | 190.28 | 189.73 | 190.175 | 1350464.0 |
| 2024-05-24 12:00:00 | AAPL | Stock | 190.175 | 190.58 | 190.16 | 190.38 | 1591628.0 |
| 2024-05-24 12:30:00 | AAPL | Stock | 190.38 | 190.55 | 190.23 | 190.355 | 1027954.0 |
| 2024-05-24 13:00:00 | AAPL | Stock | 190.36 | 190.56 | 190.2512 | 190.415 | 938591.0 |
| 2024-05-24 13:30:00 | AAPL | Stock | 190.42 | 190.42 | 190.06 | 190.075 | 1115572.0 |
| 2024-05-24 14:00:00 | AAPL | Stock | 190.075 | 190.465 | 190.055 | 190.15 | 1291805.0 |
| 2024-05-24 14:30:00 | AAPL | Stock | 190.15 | 190.39 | 190.1033 | 190.21 | 917384.0 |
| 2024-05-24 15:00:00 | AAPL | Stock | 190.2 | 190.29 | 189.935 | 190.09 | 1254769.0 |
| 2024-05-24 15:30:00 | AAPL | Stock | 190.085 | 190.24 | 189.82 | 190.0 | 2920535.0 |
| 2024-05-24 16:00:00 | AAPL | Stock | 190.02 | 190.03 | 189.95 | 190.0 | 5701860.0 |
| 2024-05-24 16:30:00 | AAPL | Stock | 190.01 | 190.02 | 189.98 | 190.0 | 76173.0 |
| 2024-05-24 17:00:00 | AAPL | Stock | 189.99 | 190.04 | 189.98 | 189.99 | 3741.0 |
| 2024-05-24 17:30:00 | AAPL | Stock | 189.98 | 189.9946 | 189.98 | 189.99 | 7897.0 |
| 2024-05-24 18:00:00 | AAPL | Stock | 190.0 | 190.0 | 189.99 | 189.99 | 2521.0 |
| 2024-05-24 18:30:00 | AAPL | Stock | 189.982 | 190.09 | 189.95 | 190.09 | 12333.0 |
| 2024-05-24 19:00:00 | AAPL | Stock | 190.1 | 190.1 | 189.91 | 189.91 | 1849.0 |
| 2024-05-24 19:30:00 | AAPL | Stock | 189.92 | 190.07 | 189.92 | 189.95 | 6455.0 |
| 2024-05-24 04:00:00 | MSFT | Stock | 427.16 | 428.52 | 427.16 | 428.02 | 1065.0 |
| 2024-05-24 04:30:00 | MSFT | Stock | 428.38 | 428.4 | 428.31 | 428.31 | 1420.0 |
| 2024-05-24 05:00:00 | MSFT | Stock | 428.19 | 428.19 | 428.0 | 428.0 | 572.0 |
| 2024-05-24 05:30:00 | MSFT | Stock | 428.0 | 428.0 | 427.75 | 427.75 | 520.0 |
| 2024-05-24 06:00:00 | MSFT | Stock | 427.92 | 428.08 | 427.92 | 428.08 | 579.0 |
| 2024-05-24 07:00:00 | MSFT | Stock | 428.44 | 428.44 | 427.8 | 427.8 | 3853.0 |
| 2024-05-24 07:30:00 | MSFT | Stock | 428.26 | 428.26 | 428.26 | 428.26 | 100.0 |
| 2024-05-24 08:00:00 | MSFT | Stock | 428.385 | 428.44 | 426.5 | 427.7 | 17660.0 |
| 2024-05-24 08:30:00 | MSFT | Stock | 427.65 | 428.2 | 427.65 | 427.7 | 6644.0 |
| 2024-05-24 09:00:00 | MSFT | Stock | 427.95 | 428.2423 | 427.3 | 427.3 | 10990.0 |
| 2024-05-24 09:30:00 | MSFT | Stock | 427.23 | 427.41 | 424.41 | 425.51 | 1182275.0 |
| 2024-05-24 10:00:00 | MSFT | Stock | 425.51 | 427.28 | 425.3601 | 427.01 | 591714.0 |
| 2024-05-24 10:30:00 | MSFT | Stock | 427.04 | 428.16 | 426.87 | 427.939 | 398607.0 |
| 2024-05-24 11:00:00 | MSFT | Stock | 427.95 | 429.66 | 427.95 | 429.25 | 390102.0 |
| 2024-05-24 11:30:00 | MSFT | Stock | 429.25 | 429.97 | 428.77 | 429.78 | 349470.0 |
| 2024-05-24 12:00:00 | MSFT | Stock | 429.74 | 430.3321 | 429.635 | 430.1 | 273960.0 |
| 2024-05-24 12:30:00 | MSFT | Stock | 430.13 | 430.15 | 429.35 | 429.7328 | 179671.0 |
| 2024-05-24 13:00:00 | MSFT | Stock | 429.73 | 430.47 | 429.62 | 430.27 | 199487.0 |
> showing 50 of 96,252 rows — these rows as CSV