PREVIEW / stock_30min / 2024-11-12
file: by_date/stock_30min/2024/2024-11-12.parquet size: 2.2 MB rows: 108,133 symbols: 727
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-11-12 04:00:00 | AAPL | Stock | 223.2 | 223.61 | 223.06 | 223.4 | 11746.0 |
| 2024-11-12 04:30:00 | AAPL | Stock | 223.38 | 223.75 | 223.01 | 223.2 | 6462.0 |
| 2024-11-12 05:00:00 | AAPL | Stock | 223.28 | 223.93 | 223.28 | 223.65 | 15850.0 |
| 2024-11-12 05:30:00 | AAPL | Stock | 223.65 | 224.0 | 223.65 | 223.97 | 4442.0 |
| 2024-11-12 06:00:00 | AAPL | Stock | 223.99 | 224.04 | 223.82 | 223.9 | 3146.0 |
| 2024-11-12 06:30:00 | AAPL | Stock | 223.75 | 224.19 | 223.61 | 224.19 | 6784.0 |
| 2024-11-12 07:00:00 | AAPL | Stock | 224.19 | 224.26 | 223.86 | 224.06 | 18951.0 |
| 2024-11-12 07:30:00 | AAPL | Stock | 224.06 | 224.5 | 224.06 | 224.23 | 11703.0 |
| 2024-11-12 08:00:00 | AAPL | Stock | 224.25 | 224.54 | 223.45 | 224.07 | 49423.0 |
| 2024-11-12 08:30:00 | AAPL | Stock | 224.0001 | 224.7 | 224.0001 | 224.5 | 48703.0 |
| 2024-11-12 09:00:00 | AAPL | Stock | 224.521 | 224.89 | 224.11 | 224.64 | 72496.0 |
| 2024-11-12 09:30:00 | AAPL | Stock | 224.43 | 225.04 | 223.55 | 224.25 | 3208906.0 |
| 2024-11-12 10:00:00 | AAPL | Stock | 224.25 | 224.3721 | 223.66 | 224.17 | 1430380.0 |
| 2024-11-12 10:30:00 | AAPL | Stock | 224.19 | 225.03 | 224.18 | 224.6 | 1622280.0 |
| 2024-11-12 11:00:00 | AAPL | Stock | 224.59 | 225.59 | 224.53 | 225.0 | 1582920.0 |
| 2024-11-12 11:30:00 | AAPL | Stock | 224.9999 | 225.51 | 224.8 | 224.97 | 1293200.0 |
| 2024-11-12 12:00:00 | AAPL | Stock | 224.9695 | 225.07 | 223.885 | 223.92 | 1340055.0 |
| 2024-11-12 12:30:00 | AAPL | Stock | 223.92 | 224.4 | 223.386 | 223.4199 | 1081810.0 |
| 2024-11-12 13:00:00 | AAPL | Stock | 223.42 | 224.47 | 223.355 | 224.47 | 943028.0 |
| 2024-11-12 13:30:00 | AAPL | Stock | 224.45 | 224.6 | 224.14 | 224.1498 | 909920.0 |
| 2024-11-12 14:00:00 | AAPL | Stock | 224.13 | 224.77 | 224.13 | 224.6199 | 890638.0 |
| 2024-11-12 14:30:00 | AAPL | Stock | 224.63 | 224.73 | 224.46 | 224.53 | 596808.0 |
| 2024-11-12 15:00:00 | AAPL | Stock | 224.53 | 224.82 | 224.44 | 224.6 | 831197.0 |
| 2024-11-12 15:30:00 | AAPL | Stock | 224.59 | 224.8 | 223.9404 | 224.24 | 4269519.0 |
| 2024-11-12 16:00:00 | AAPL | Stock | 224.21 | 224.31 | 223.81 | 224.25 | 8682211.0 |
| 2024-11-12 16:30:00 | AAPL | Stock | 224.3 | 224.3 | 223.9 | 224.0 | 17522.0 |
| 2024-11-12 17:00:00 | AAPL | Stock | 223.98 | 224.23 | 223.98 | 224.23 | 6876.0 |
| 2024-11-12 17:30:00 | AAPL | Stock | 224.0105 | 224.35 | 224.0105 | 224.19 | 10120.0 |
| 2024-11-12 18:00:00 | AAPL | Stock | 224.2 | 224.2736 | 224.0318 | 224.0318 | 43671.0 |
| 2024-11-12 18:30:00 | AAPL | Stock | 224.1 | 224.21 | 224.01 | 224.2 | 3491.0 |
| 2024-11-12 19:00:00 | AAPL | Stock | 224.19 | 224.2 | 224.03 | 224.12 | 5368.0 |
| 2024-11-12 19:30:00 | AAPL | Stock | 224.01 | 224.14 | 224.01 | 224.09 | 2316.0 |
| 2024-11-12 04:00:00 | MSFT | Stock | 417.28 | 417.28 | 416.79 | 416.87 | 1284.0 |
| 2024-11-12 04:30:00 | MSFT | Stock | 417.03 | 417.2 | 417.03 | 417.2 | 273.0 |
| 2024-11-12 05:00:00 | MSFT | Stock | 417.4 | 418.0 | 416.98 | 417.16 | 2840.0 |
| 2024-11-12 05:30:00 | MSFT | Stock | 417.4 | 417.88 | 417.04 | 417.88 | 437.0 |
| 2024-11-12 06:00:00 | MSFT | Stock | 417.5 | 417.55 | 417.0 | 417.0 | 1574.0 |
| 2024-11-12 06:30:00 | MSFT | Stock | 417.8 | 418.01 | 417.79 | 418.01 | 4333.0 |
| 2024-11-12 07:00:00 | MSFT | Stock | 418.05 | 418.05 | 417.55 | 417.61 | 6834.0 |
| 2024-11-12 07:30:00 | MSFT | Stock | 417.51 | 417.86 | 417.45 | 417.5 | 4596.0 |
| 2024-11-12 08:00:00 | MSFT | Stock | 417.83 | 418.26 | 416.86 | 417.58 | 29068.0 |
| 2024-11-12 08:30:00 | MSFT | Stock | 417.7 | 418.799 | 417.7 | 418.3 | 16207.0 |
| 2024-11-12 09:00:00 | MSFT | Stock | 418.289 | 419.68 | 417.1 | 418.24 | 30924.0 |
| 2024-11-12 09:30:00 | MSFT | Stock | 418.25 | 420.5899 | 417.2 | 418.745 | 1501508.0 |
| 2024-11-12 10:00:00 | MSFT | Stock | 418.8 | 420.3 | 417.71 | 418.99 | 646135.0 |
| 2024-11-12 10:30:00 | MSFT | Stock | 419.02 | 420.02 | 418.75 | 419.0002 | 500558.0 |
| 2024-11-12 11:00:00 | MSFT | Stock | 419.01 | 420.43 | 419.01 | 419.77 | 383091.0 |
| 2024-11-12 11:30:00 | MSFT | Stock | 419.77 | 420.2709 | 419.38 | 419.94 | 376214.0 |
| 2024-11-12 12:00:00 | MSFT | Stock | 419.945 | 421.3512 | 419.895 | 421.095 | 595634.0 |
| 2024-11-12 12:30:00 | MSFT | Stock | 421.07 | 421.73 | 419.72 | 419.79 | 431955.0 |
> showing 50 of 108,133 rows — these rows as CSV