PREVIEW / stock_30min / 2024-05-06
file: by_date/stock_30min/2024/2024-05-06.parquet size: 2.1 MB rows: 100,077 symbols: 991
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-06 04:00:00 | AAPL | Stock | 180.4 | 181.63 | 180.3 | 181.37 | 87711.0 |
| 2024-05-06 04:30:00 | AAPL | Stock | 181.24 | 181.4 | 181.24 | 181.38 | 11958.0 |
| 2024-05-06 05:00:00 | AAPL | Stock | 181.39 | 181.99 | 181.35 | 181.99 | 16881.0 |
| 2024-05-06 05:30:00 | AAPL | Stock | 181.94 | 182.0 | 181.61 | 181.67 | 16537.0 |
| 2024-05-06 06:00:00 | AAPL | Stock | 181.64 | 182.18 | 181.31 | 182.0 | 18229.0 |
| 2024-05-06 06:30:00 | AAPL | Stock | 182.0 | 182.32 | 182.0 | 182.32 | 27040.0 |
| 2024-05-06 07:00:00 | AAPL | Stock | 182.35 | 182.73 | 182.32 | 182.6 | 55740.0 |
| 2024-05-06 07:30:00 | AAPL | Stock | 182.57 | 182.99 | 182.5 | 182.62 | 45403.0 |
| 2024-05-06 08:00:00 | AAPL | Stock | 182.39 | 182.96 | 180.5 | 182.52 | 233497.0 |
| 2024-05-06 08:30:00 | AAPL | Stock | 182.59 | 182.6 | 182.15 | 182.33 | 193487.0 |
| 2024-05-06 09:00:00 | AAPL | Stock | 182.297 | 183.15 | 182.0 | 182.39 | 304684.0 |
| 2024-05-06 09:30:00 | AAPL | Stock | 182.4 | 184.2 | 181.63 | 182.4701 | 10290474.0 |
| 2024-05-06 10:00:00 | AAPL | Stock | 182.48 | 183.0899 | 181.89 | 182.53 | 5571503.0 |
| 2024-05-06 10:30:00 | AAPL | Stock | 182.53 | 182.96 | 182.27 | 182.39 | 3203773.0 |
| 2024-05-06 11:00:00 | AAPL | Stock | 182.38 | 182.38 | 181.73 | 181.9971 | 3155300.0 |
| 2024-05-06 11:30:00 | AAPL | Stock | 182.0 | 182.4 | 181.69 | 182.315 | 2636204.0 |
| 2024-05-06 12:00:00 | AAPL | Stock | 182.315 | 182.38 | 181.5 | 181.6 | 2684390.0 |
| 2024-05-06 12:30:00 | AAPL | Stock | 181.6 | 181.83 | 181.28 | 181.53 | 3717859.0 |
| 2024-05-06 13:00:00 | AAPL | Stock | 181.52 | 181.718 | 180.58 | 180.59 | 3600049.0 |
| 2024-05-06 13:30:00 | AAPL | Stock | 180.59 | 181.155 | 180.42 | 181.09 | 3513514.0 |
| 2024-05-06 14:00:00 | AAPL | Stock | 181.085 | 181.34 | 180.69 | 180.81 | 3160991.0 |
| 2024-05-06 14:30:00 | AAPL | Stock | 180.81 | 181.205 | 180.7 | 181.15 | 2316420.0 |
| 2024-05-06 15:00:00 | AAPL | Stock | 181.1576 | 181.62 | 180.86 | 181.49 | 3199404.0 |
| 2024-05-06 15:30:00 | AAPL | Stock | 181.49 | 182.02 | 181.24 | 181.7 | 7179913.0 |
| 2024-05-06 16:00:00 | AAPL | Stock | 181.61 | 181.88 | 181.3 | 181.78 | 6864830.0 |
| 2024-05-06 16:30:00 | AAPL | Stock | 181.7996 | 181.9 | 181.71 | 181.82 | 128771.0 |
| 2024-05-06 17:00:00 | AAPL | Stock | 181.83 | 182.01 | 181.71 | 181.9316 | 56444.0 |
| 2024-05-06 17:30:00 | AAPL | Stock | 181.9686 | 182.05 | 181.7515 | 181.83 | 19902.0 |
| 2024-05-06 18:00:00 | AAPL | Stock | 181.77 | 181.87 | 181.7617 | 181.87 | 15558.0 |
| 2024-05-06 18:30:00 | AAPL | Stock | 181.87 | 182.0 | 181.8603 | 181.97 | 20304.0 |
| 2024-05-06 19:00:00 | AAPL | Stock | 181.95 | 183.5 | 181.89 | 183.48 | 158596.0 |
| 2024-05-06 19:30:00 | AAPL | Stock | 183.4 | 183.9 | 182.8 | 182.89 | 225996.0 |
| 2024-05-06 04:00:00 | MSFT | Stock | 407.23 | 407.45 | 407.13 | 407.45 | 872.0 |
| 2024-05-06 04:30:00 | MSFT | Stock | 407.76 | 407.76 | 407.6 | 407.6 | 1084.0 |
| 2024-05-06 05:00:00 | MSFT | Stock | 407.54 | 407.59 | 407.39 | 407.59 | 672.0 |
| 2024-05-06 05:30:00 | MSFT | Stock | 407.9 | 407.93 | 407.9 | 407.93 | 395.0 |
| 2024-05-06 06:00:00 | MSFT | Stock | 407.99 | 408.8 | 407.99 | 408.8 | 2872.0 |
| 2024-05-06 06:30:00 | MSFT | Stock | 408.8 | 408.8 | 408.51 | 408.55 | 1047.0 |
| 2024-05-06 07:00:00 | MSFT | Stock | 408.27 | 408.3 | 408.16 | 408.29 | 2204.0 |
| 2024-05-06 07:30:00 | MSFT | Stock | 408.39 | 408.39 | 408.0 | 408.1 | 2379.0 |
| 2024-05-06 08:00:00 | MSFT | Stock | 408.2619 | 408.66 | 406.59 | 408.66 | 20397.0 |
| 2024-05-06 08:30:00 | MSFT | Stock | 408.8468 | 409.1 | 408.64 | 408.78 | 14728.0 |
| 2024-05-06 09:00:00 | MSFT | Stock | 408.7604 | 409.0 | 408.2141 | 408.65 | 15143.0 |
| 2024-05-06 09:30:00 | MSFT | Stock | 408.7 | 409.42 | 406.3701 | 407.365 | 1306255.0 |
| 2024-05-06 10:00:00 | MSFT | Stock | 407.4 | 408.74 | 406.52 | 408.18 | 876851.0 |
| 2024-05-06 10:30:00 | MSFT | Stock | 408.26 | 409.32 | 408.06 | 409.165 | 558102.0 |
| 2024-05-06 11:00:00 | MSFT | Stock | 409.2 | 409.93 | 408.868 | 409.49 | 414989.0 |
| 2024-05-06 11:30:00 | MSFT | Stock | 409.51 | 410.23 | 409.38 | 409.92 | 455488.0 |
| 2024-05-06 12:00:00 | MSFT | Stock | 409.9231 | 410.03 | 409.36 | 409.99 | 253761.0 |
| 2024-05-06 12:30:00 | MSFT | Stock | 410.01 | 410.83 | 410.01 | 410.41 | 355425.0 |
> showing 50 of 100,077 rows — these rows as CSV