PREVIEW / stock_30min / 2024-12-20
file: by_date/stock_30min/2024/2024-12-20.parquet size: 2.3 MB rows: 110,833 symbols: 663
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-12-20 04:00:00 | AAPL | Stock | 248.01 | 248.29 | 247.5 | 247.75 | 17419.0 |
| 2024-12-20 04:30:00 | AAPL | Stock | 247.65 | 247.8 | 247.17 | 247.52 | 13945.0 |
| 2024-12-20 05:00:00 | AAPL | Stock | 247.37 | 248.05 | 247.34 | 248.01 | 15815.0 |
| 2024-12-20 05:30:00 | AAPL | Stock | 247.98 | 248.14 | 247.51 | 247.64 | 15091.0 |
| 2024-12-20 06:00:00 | AAPL | Stock | 247.6 | 247.8 | 247.45 | 247.45 | 7642.0 |
| 2024-12-20 06:30:00 | AAPL | Stock | 247.56 | 247.69 | 247.34 | 247.45 | 17557.0 |
| 2024-12-20 07:00:00 | AAPL | Stock | 247.48 | 247.9 | 246.84 | 246.92 | 43879.0 |
| 2024-12-20 07:30:00 | AAPL | Stock | 246.87 | 247.01 | 246.74 | 246.99 | 42356.0 |
| 2024-12-20 08:00:00 | AAPL | Stock | 246.95 | 248.71 | 246.75 | 247.3 | 98907.0 |
| 2024-12-20 08:30:00 | AAPL | Stock | 247.35 | 248.32 | 247.35 | 247.68 | 97681.0 |
| 2024-12-20 09:00:00 | AAPL | Stock | 247.69 | 248.91 | 246.911 | 248.04 | 198574.0 |
| 2024-12-20 09:30:00 | AAPL | Stock | 248.04 | 248.72 | 245.69 | 246.8313 | 12553594.0 |
| 2024-12-20 10:00:00 | AAPL | Stock | 246.85 | 249.6241 | 246.81 | 249.595 | 2254953.0 |
| 2024-12-20 10:30:00 | AAPL | Stock | 249.59 | 250.39 | 249.4 | 249.95 | 1745181.0 |
| 2024-12-20 11:00:00 | AAPL | Stock | 249.985 | 252.0 | 249.86 | 251.99 | 1763310.0 |
| 2024-12-20 11:30:00 | AAPL | Stock | 251.98 | 253.39 | 251.89 | 253.115 | 3229284.0 |
| 2024-12-20 12:00:00 | AAPL | Stock | 253.115 | 253.93 | 252.97 | 253.735 | 2110279.0 |
| 2024-12-20 12:30:00 | AAPL | Stock | 253.735 | 253.78 | 253.19 | 253.3559 | 1302569.0 |
| 2024-12-20 13:00:00 | AAPL | Stock | 253.3608 | 253.43 | 252.772 | 252.87 | 1571132.0 |
| 2024-12-20 13:30:00 | AAPL | Stock | 252.91 | 253.46 | 252.7 | 252.865 | 1449471.0 |
| 2024-12-20 14:00:00 | AAPL | Stock | 252.84 | 253.65 | 252.68 | 253.6203 | 1162846.0 |
| 2024-12-20 14:30:00 | AAPL | Stock | 253.63 | 253.82 | 253.3 | 253.6028 | 1310931.0 |
| 2024-12-20 15:00:00 | AAPL | Stock | 253.61 | 254.19 | 253.41 | 253.49 | 2060983.0 |
| 2024-12-20 15:30:00 | AAPL | Stock | 253.5 | 255.0 | 252.51 | 254.6 | 7125408.0 |
| 2024-12-20 16:00:00 | AAPL | Stock | 254.59 | 255.06 | 254.4895 | 254.73 | 42489422.0 |
| 2024-12-20 16:30:00 | AAPL | Stock | 254.7 | 254.98 | 254.49 | 254.95 | 116740.0 |
| 2024-12-20 17:00:00 | AAPL | Stock | 254.95 | 255.05 | 254.78 | 254.99 | 34872.0 |
| 2024-12-20 17:30:00 | AAPL | Stock | 255.0 | 255.1 | 254.9 | 255.0018 | 25899.0 |
| 2024-12-20 18:00:00 | AAPL | Stock | 255.0013 | 255.55 | 255.0013 | 255.54 | 15272.0 |
| 2024-12-20 18:30:00 | AAPL | Stock | 255.55 | 255.57 | 254.49 | 255.31 | 247374.0 |
| 2024-12-20 19:00:00 | AAPL | Stock | 255.31 | 255.53 | 255.31 | 255.5 | 9370.0 |
| 2024-12-20 19:30:00 | AAPL | Stock | 255.49 | 255.4987 | 254.49 | 255.35 | 46962.0 |
| 2024-12-20 04:00:00 | MSFT | Stock | 434.3 | 434.3 | 430.75 | 431.86 | 8480.0 |
| 2024-12-20 04:30:00 | MSFT | Stock | 431.71 | 432.12 | 431.5 | 431.96 | 6458.0 |
| 2024-12-20 05:00:00 | MSFT | Stock | 432.21 | 432.42 | 431.35 | 431.61 | 4135.0 |
| 2024-12-20 05:30:00 | MSFT | Stock | 431.75 | 431.87 | 431.38 | 431.38 | 5572.0 |
| 2024-12-20 06:00:00 | MSFT | Stock | 431.33 | 431.45 | 431.0 | 431.1 | 3478.0 |
| 2024-12-20 06:30:00 | MSFT | Stock | 431.13 | 431.52 | 431.05 | 431.52 | 2795.0 |
| 2024-12-20 07:00:00 | MSFT | Stock | 431.69 | 432.2 | 431.35 | 431.45 | 14826.0 |
| 2024-12-20 07:30:00 | MSFT | Stock | 431.39 | 432.55 | 431.38 | 432.51 | 23417.0 |
| 2024-12-20 08:00:00 | MSFT | Stock | 431.61 | 435.938 | 431.27 | 432.58 | 19770.0 |
| 2024-12-20 08:30:00 | MSFT | Stock | 432.7 | 434.51 | 432.5 | 433.4 | 29271.0 |
| 2024-12-20 09:00:00 | MSFT | Stock | 433.3 | 434.73 | 432.0 | 432.67 | 35104.0 |
| 2024-12-20 09:30:00 | MSFT | Stock | 432.66 | 433.205 | 428.63 | 429.11 | 5868111.0 |
| 2024-12-20 10:00:00 | MSFT | Stock | 429.3 | 434.42 | 429.24 | 434.315 | 913822.0 |
| 2024-12-20 10:30:00 | MSFT | Stock | 434.29 | 436.95 | 434.03 | 436.04 | 755250.0 |
| 2024-12-20 11:00:00 | MSFT | Stock | 436.04 | 440.33 | 435.9353 | 440.25 | 679131.0 |
| 2024-12-20 11:30:00 | MSFT | Stock | 440.21 | 442.94 | 440.14 | 442.03 | 835351.0 |
| 2024-12-20 12:00:00 | MSFT | Stock | 442.09 | 443.74 | 441.6601 | 443.35 | 720056.0 |
| 2024-12-20 12:30:00 | MSFT | Stock | 443.39 | 443.465 | 441.51 | 441.5322 | 480318.0 |
> showing 50 of 110,833 rows — these rows as CSV