PREVIEW / stock_30min / 2024-11-13
file: by_date/stock_30min/2024/2024-11-13.parquet size: 2.2 MB rows: 105,630 symbols: 708
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-13 04:00:00 | AAPL | Stock | 223.88 | 224.05 | 223.57 | 223.84 | 2953.0 |
| 2024-11-13 04:30:00 | AAPL | Stock | 223.88 | 223.89 | 223.7 | 223.75 | 2655.0 |
| 2024-11-13 05:00:00 | AAPL | Stock | 223.83 | 223.84 | 223.71 | 223.71 | 693.0 |
| 2024-11-13 05:30:00 | AAPL | Stock | 223.7 | 223.71 | 223.55 | 223.59 | 2632.0 |
| 2024-11-13 06:00:00 | AAPL | Stock | 223.59 | 223.59 | 223.4 | 223.4 | 2166.0 |
| 2024-11-13 06:30:00 | AAPL | Stock | 223.33 | 223.33 | 223.12 | 223.15 | 3054.0 |
| 2024-11-13 07:00:00 | AAPL | Stock | 223.3 | 223.5 | 223.2 | 223.45 | 14853.0 |
| 2024-11-13 07:30:00 | AAPL | Stock | 223.42 | 223.55 | 223.25 | 223.52 | 7101.0 |
| 2024-11-13 08:00:00 | AAPL | Stock | 223.35 | 224.18 | 223.27 | 223.53 | 44292.0 |
| 2024-11-13 08:30:00 | AAPL | Stock | 223.53 | 224.05 | 223.48 | 223.52 | 67269.0 |
| 2024-11-13 09:00:00 | AAPL | Stock | 223.5 | 224.09 | 223.25 | 224.0 | 67369.0 |
| 2024-11-13 09:30:00 | AAPL | Stock | 224.01 | 225.2099 | 222.76 | 223.54 | 3439972.0 |
| 2024-11-13 10:00:00 | AAPL | Stock | 223.55 | 224.17 | 223.15 | 223.21 | 1854784.0 |
| 2024-11-13 10:30:00 | AAPL | Stock | 223.24 | 224.31 | 223.22 | 224.05 | 1398953.0 |
| 2024-11-13 11:00:00 | AAPL | Stock | 224.05 | 224.47 | 224.04 | 224.43 | 1214376.0 |
| 2024-11-13 11:30:00 | AAPL | Stock | 224.44 | 224.6 | 223.77 | 224.55 | 1125970.0 |
| 2024-11-13 12:00:00 | AAPL | Stock | 224.555 | 225.55 | 224.555 | 225.02 | 1373863.0 |
| 2024-11-13 12:30:00 | AAPL | Stock | 225.025 | 226.61 | 224.94 | 226.521 | 1614143.0 |
| 2024-11-13 13:00:00 | AAPL | Stock | 226.53 | 226.65 | 226.175 | 226.3638 | 1004054.0 |
| 2024-11-13 13:30:00 | AAPL | Stock | 226.36 | 226.44 | 225.82 | 226.025 | 979176.0 |
| 2024-11-13 14:00:00 | AAPL | Stock | 226.03 | 226.23 | 225.75 | 225.9199 | 851748.0 |
| 2024-11-13 14:30:00 | AAPL | Stock | 225.91 | 225.9913 | 225.34 | 225.43 | 847329.0 |
| 2024-11-13 15:00:00 | AAPL | Stock | 225.42 | 225.73 | 225.1186 | 225.3702 | 1124185.0 |
| 2024-11-13 15:30:00 | AAPL | Stock | 225.38 | 225.93 | 224.42 | 225.22 | 3751677.0 |
| 2024-11-13 16:00:00 | AAPL | Stock | 225.12 | 225.38 | 224.92 | 225.25 | 9510773.0 |
| 2024-11-13 16:30:00 | AAPL | Stock | 225.3 | 225.5 | 225.12 | 225.27 | 657691.0 |
| 2024-11-13 17:00:00 | AAPL | Stock | 225.3 | 225.3 | 225.14 | 225.1406 | 2392.0 |
| 2024-11-13 17:30:00 | AAPL | Stock | 225.15 | 225.22 | 225.05 | 225.0503 | 4637.0 |
| 2024-11-13 18:00:00 | AAPL | Stock | 225.14 | 225.15 | 224.98 | 225.0 | 7607.0 |
| 2024-11-13 18:30:00 | AAPL | Stock | 225.04 | 225.09 | 224.95 | 224.9699 | 6421.0 |
| 2024-11-13 19:00:00 | AAPL | Stock | 224.9 | 224.97 | 224.81 | 224.91 | 3529.0 |
| 2024-11-13 19:30:00 | AAPL | Stock | 224.93 | 224.9898 | 224.73 | 224.73 | 11949.0 |
| 2024-11-13 04:00:00 | MSFT | Stock | 423.03 | 423.03 | 422.03 | 422.03 | 3703.0 |
| 2024-11-13 04:30:00 | MSFT | Stock | 422.02 | 422.3 | 422.02 | 422.3 | 1687.0 |
| 2024-11-13 05:00:00 | MSFT | Stock | 422.23 | 422.23 | 421.55 | 421.55 | 730.0 |
| 2024-11-13 05:30:00 | MSFT | Stock | 421.33 | 421.54 | 421.1 | 421.52 | 1427.0 |
| 2024-11-13 06:00:00 | MSFT | Stock | 421.2 | 421.3 | 421.16 | 421.29 | 1479.0 |
| 2024-11-13 06:30:00 | MSFT | Stock | 421.11 | 421.45 | 421.11 | 421.45 | 1057.0 |
| 2024-11-13 07:00:00 | MSFT | Stock | 421.27 | 422.06 | 421.27 | 422.0 | 5020.0 |
| 2024-11-13 07:30:00 | MSFT | Stock | 421.55 | 421.7 | 421.51 | 421.61 | 3126.0 |
| 2024-11-13 08:00:00 | MSFT | Stock | 421.29 | 422.82 | 421.27 | 421.8 | 20125.0 |
| 2024-11-13 08:30:00 | MSFT | Stock | 421.88 | 423.0439 | 421.68 | 421.84 | 16727.0 |
| 2024-11-13 09:00:00 | MSFT | Stock | 421.72 | 422.121 | 421.09 | 421.09 | 16410.0 |
| 2024-11-13 09:30:00 | MSFT | Stock | 421.64 | 422.47 | 418.65 | 419.15 | 1284119.0 |
| 2024-11-13 10:00:00 | MSFT | Stock | 419.21 | 419.74 | 418.21 | 419.15 | 728043.0 |
| 2024-11-13 10:30:00 | MSFT | Stock | 419.18 | 420.53 | 419.15 | 419.83 | 526425.0 |
| 2024-11-13 11:00:00 | MSFT | Stock | 419.83 | 422.95 | 419.55 | 422.78 | 474736.0 |
| 2024-11-13 11:30:00 | MSFT | Stock | 422.8065 | 425.57 | 422.2671 | 424.79 | 692150.0 |
| 2024-11-13 12:00:00 | MSFT | Stock | 424.73 | 427.14 | 424.5401 | 426.69 | 620835.0 |
| 2024-11-13 12:30:00 | MSFT | Stock | 426.74 | 428.73 | 426.65 | 428.5646 | 612722.0 |
> showing 50 of 105,630 rows — these rows as CSV