PREVIEW / stock_30min / 2024-10-03
file: by_date/stock_30min/2024/2024-10-03.parquet size: 2.0 MB rows: 97,668 symbols: 746
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-03 04:00:00 | AAPL | Stock | 226.2 | 226.2 | 225.8 | 225.95 | 10761.0 |
| 2024-10-03 04:30:00 | AAPL | Stock | 225.9 | 225.94 | 225.67 | 225.86 | 1038.0 |
| 2024-10-03 05:00:00 | AAPL | Stock | 225.86 | 225.86 | 225.74 | 225.74 | 736.0 |
| 2024-10-03 06:00:00 | AAPL | Stock | 225.79 | 225.88 | 225.75 | 225.88 | 1170.0 |
| 2024-10-03 06:30:00 | AAPL | Stock | 225.9 | 225.9 | 225.53 | 225.75 | 10197.0 |
| 2024-10-03 07:00:00 | AAPL | Stock | 225.8 | 226.09 | 225.29 | 225.38 | 27844.0 |
| 2024-10-03 07:30:00 | AAPL | Stock | 225.38 | 225.56 | 225.15 | 225.53 | 12427.0 |
| 2024-10-03 08:00:00 | AAPL | Stock | 225.5 | 226.37 | 224.79 | 225.53 | 107406.0 |
| 2024-10-03 08:30:00 | AAPL | Stock | 225.4 | 225.83 | 225.15 | 225.21 | 44733.0 |
| 2024-10-03 09:00:00 | AAPL | Stock | 225.15 | 225.3235 | 224.57 | 225.04 | 56084.0 |
| 2024-10-03 09:30:00 | AAPL | Stock | 225.14 | 226.7 | 224.89 | 226.305 | 2569807.0 |
| 2024-10-03 10:00:00 | AAPL | Stock | 226.31 | 226.805 | 224.71 | 224.835 | 1943555.0 |
| 2024-10-03 10:30:00 | AAPL | Stock | 224.82 | 225.53 | 224.25 | 224.34 | 1860259.0 |
| 2024-10-03 11:00:00 | AAPL | Stock | 224.33 | 225.01 | 224.282 | 224.8742 | 1201332.0 |
| 2024-10-03 11:30:00 | AAPL | Stock | 224.87 | 225.25 | 224.83 | 225.13 | 923574.0 |
| 2024-10-03 12:00:00 | AAPL | Stock | 225.1472 | 225.37 | 224.9631 | 225.0712 | 724680.0 |
| 2024-10-03 12:30:00 | AAPL | Stock | 225.08 | 225.0963 | 223.57 | 223.82 | 1375455.0 |
| 2024-10-03 13:00:00 | AAPL | Stock | 223.8 | 224.285 | 223.32 | 223.86 | 1191786.0 |
| 2024-10-03 13:30:00 | AAPL | Stock | 223.84 | 224.34 | 223.795 | 224.3 | 679625.0 |
| 2024-10-03 14:00:00 | AAPL | Stock | 224.29 | 224.4099 | 223.7 | 223.8401 | 677994.0 |
| 2024-10-03 14:30:00 | AAPL | Stock | 223.83 | 224.04 | 223.6102 | 223.63 | 679480.0 |
| 2024-10-03 15:00:00 | AAPL | Stock | 223.62 | 223.89 | 223.5 | 223.7 | 1044380.0 |
| 2024-10-03 15:30:00 | AAPL | Stock | 223.71 | 225.84 | 223.66 | 225.67 | 4737328.0 |
| 2024-10-03 16:00:00 | AAPL | Stock | 225.66 | 225.9499 | 225.613 | 225.75 | 5111067.0 |
| 2024-10-03 16:30:00 | AAPL | Stock | 225.76 | 225.8 | 225.66 | 225.73 | 53525.0 |
| 2024-10-03 17:00:00 | AAPL | Stock | 225.71 | 225.79 | 225.5645 | 225.5645 | 126866.0 |
| 2024-10-03 17:30:00 | AAPL | Stock | 225.6455 | 225.67 | 225.51 | 225.65 | 6929.0 |
| 2024-10-03 18:00:00 | AAPL | Stock | 225.5252 | 225.579 | 225.48 | 225.55 | 9630.0 |
| 2024-10-03 18:30:00 | AAPL | Stock | 225.56 | 226.0 | 225.56 | 225.8 | 20634.0 |
| 2024-10-03 19:00:00 | AAPL | Stock | 225.8805 | 226.2005 | 225.8805 | 225.95 | 23143.0 |
| 2024-10-03 19:30:00 | AAPL | Stock | 225.99 | 226.1362 | 225.83 | 226.07 | 10597.0 |
| 2024-10-03 04:00:00 | MSFT | Stock | 416.91 | 416.99 | 416.05 | 416.31 | 988.0 |
| 2024-10-03 04:30:00 | MSFT | Stock | 416.3 | 416.53 | 416.3 | 416.53 | 625.0 |
| 2024-10-03 05:00:00 | MSFT | Stock | 416.4 | 416.43 | 416.4 | 416.43 | 217.0 |
| 2024-10-03 05:30:00 | MSFT | Stock | 416.18 | 416.27 | 416.18 | 416.27 | 218.0 |
| 2024-10-03 06:00:00 | MSFT | Stock | 416.24 | 416.48 | 416.24 | 416.48 | 221.0 |
| 2024-10-03 06:30:00 | MSFT | Stock | 416.5 | 416.78 | 416.5 | 416.78 | 441.0 |
| 2024-10-03 07:00:00 | MSFT | Stock | 417.12 | 417.25 | 417.0 | 417.0 | 1075.0 |
| 2024-10-03 07:30:00 | MSFT | Stock | 417.18 | 417.99 | 417.18 | 417.99 | 1955.0 |
| 2024-10-03 08:00:00 | MSFT | Stock | 417.12 | 419.077 | 416.01 | 418.5 | 33213.0 |
| 2024-10-03 08:30:00 | MSFT | Stock | 418.49 | 418.7 | 417.0 | 417.0 | 9888.0 |
| 2024-10-03 09:00:00 | MSFT | Stock | 417.0 | 417.8288 | 416.8 | 417.7 | 12504.0 |
| 2024-10-03 09:30:00 | MSFT | Stock | 417.8 | 418.34 | 415.7613 | 418.1899 | 1334949.0 |
| 2024-10-03 10:00:00 | MSFT | Stock | 418.19 | 419.55 | 416.14 | 416.28 | 805704.0 |
| 2024-10-03 10:30:00 | MSFT | Stock | 416.18 | 418.22 | 415.88 | 416.29 | 555616.0 |
| 2024-10-03 11:00:00 | MSFT | Stock | 416.24 | 417.2 | 416.09 | 416.75 | 406090.0 |
| 2024-10-03 11:30:00 | MSFT | Stock | 416.74 | 418.01 | 416.74 | 417.81 | 256225.0 |
| 2024-10-03 12:00:00 | MSFT | Stock | 417.81 | 417.95 | 417.269 | 417.46 | 267727.0 |
| 2024-10-03 12:30:00 | MSFT | Stock | 417.43 | 417.46 | 414.52 | 415.1 | 422426.0 |
| 2024-10-03 13:00:00 | MSFT | Stock | 415.03 | 416.0299 | 414.29 | 415.535 | 489819.0 |
> showing 50 of 97,668 rows — these rows as CSV