PREVIEW / stock_30min / 2024-06-13
file: by_date/stock_30min/2024/2024-06-13.parquet size: 2.0 MB rows: 98,003 symbols: 969
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-06-13 04:00:00 | AAPL | Stock | 214.52 | 215.25 | 213.71 | 214.16 | 67180.0 |
| 2024-06-13 04:30:00 | AAPL | Stock | 214.05 | 214.25 | 213.89 | 214.19 | 26441.0 |
| 2024-06-13 05:00:00 | AAPL | Stock | 214.26 | 214.29 | 213.31 | 213.6 | 22993.0 |
| 2024-06-13 05:30:00 | AAPL | Stock | 213.58 | 213.58 | 213.07 | 213.5 | 29396.0 |
| 2024-06-13 06:00:00 | AAPL | Stock | 213.45 | 213.51 | 213.27 | 213.32 | 17282.0 |
| 2024-06-13 06:30:00 | AAPL | Stock | 213.3 | 213.3 | 213.1 | 213.23 | 29087.0 |
| 2024-06-13 07:00:00 | AAPL | Stock | 213.24 | 213.55 | 212.49 | 212.85 | 66516.0 |
| 2024-06-13 07:30:00 | AAPL | Stock | 212.85 | 213.3 | 212.84 | 213.0 | 44139.0 |
| 2024-06-13 08:00:00 | AAPL | Stock | 213.43 | 215.33 | 212.46 | 214.17 | 936284.0 |
| 2024-06-13 08:30:00 | AAPL | Stock | 214.14 | 214.75 | 213.3 | 213.93 | 358885.0 |
| 2024-06-13 09:00:00 | AAPL | Stock | 213.94 | 214.92 | 213.3 | 214.8 | 380408.0 |
| 2024-06-13 09:30:00 | AAPL | Stock | 214.74 | 216.75 | 213.9372 | 214.73 | 16302642.0 |
| 2024-06-13 10:00:00 | AAPL | Stock | 214.75 | 214.98 | 213.14 | 213.8502 | 6448695.0 |
| 2024-06-13 10:30:00 | AAPL | Stock | 213.8643 | 214.57 | 212.82 | 212.8601 | 4188713.0 |
| 2024-06-13 11:00:00 | AAPL | Stock | 212.88 | 214.0 | 212.17 | 213.445 | 5543268.0 |
| 2024-06-13 11:30:00 | AAPL | Stock | 213.4359 | 214.0618 | 213.28 | 213.74 | 2532087.0 |
| 2024-06-13 12:00:00 | AAPL | Stock | 213.745 | 213.745 | 211.6 | 212.1 | 4617962.0 |
| 2024-06-13 12:30:00 | AAPL | Stock | 212.11 | 212.86 | 212.03 | 212.296 | 2837583.0 |
| 2024-06-13 13:00:00 | AAPL | Stock | 212.29 | 213.74 | 212.23 | 213.6 | 2739383.0 |
| 2024-06-13 13:30:00 | AAPL | Stock | 213.605 | 213.79 | 212.4 | 212.6937 | 2351597.0 |
| 2024-06-13 14:00:00 | AAPL | Stock | 212.7 | 213.41 | 212.57 | 213.21 | 2134399.0 |
| 2024-06-13 14:30:00 | AAPL | Stock | 213.2 | 214.1399 | 213.04 | 213.98 | 3256550.0 |
| 2024-06-13 15:00:00 | AAPL | Stock | 213.97 | 214.4 | 213.22 | 214.33 | 3992153.0 |
| 2024-06-13 15:30:00 | AAPL | Stock | 214.33 | 214.88 | 213.832 | 214.13 | 7111498.0 |
| 2024-06-13 16:00:00 | AAPL | Stock | 214.12 | 214.95 | 214.07 | 214.93 | 9236839.0 |
| 2024-06-13 16:30:00 | AAPL | Stock | 214.94 | 215.0997 | 214.24 | 214.71 | 165197.0 |
| 2024-06-13 17:00:00 | AAPL | Stock | 214.71 | 214.74 | 214.24 | 214.4 | 374049.0 |
| 2024-06-13 17:30:00 | AAPL | Stock | 214.33 | 214.6892 | 214.3 | 214.5 | 27377.0 |
| 2024-06-13 18:00:00 | AAPL | Stock | 214.46 | 214.503 | 214.23 | 214.4 | 19975.0 |
| 2024-06-13 18:30:00 | AAPL | Stock | 214.4 | 214.49 | 214.3388 | 214.38 | 18884.0 |
| 2024-06-13 19:00:00 | AAPL | Stock | 214.4 | 214.4 | 214.0403 | 214.3 | 20882.0 |
| 2024-06-13 19:30:00 | AAPL | Stock | 214.25 | 214.6 | 214.2 | 214.6 | 32566.0 |
| 2024-06-13 04:00:00 | MSFT | Stock | 441.0 | 442.0 | 440.62 | 440.62 | 5990.0 |
| 2024-06-13 04:30:00 | MSFT | Stock | 440.7 | 440.7 | 440.0 | 440.33 | 2647.0 |
| 2024-06-13 05:00:00 | MSFT | Stock | 440.42 | 440.53 | 439.0 | 439.0 | 2053.0 |
| 2024-06-13 05:30:00 | MSFT | Stock | 439.01 | 439.15 | 438.0 | 438.85 | 5380.0 |
| 2024-06-13 06:00:00 | MSFT | Stock | 438.96 | 439.54 | 438.91 | 439.54 | 1976.0 |
| 2024-06-13 06:30:00 | MSFT | Stock | 439.5 | 439.5 | 439.37 | 439.37 | 1091.0 |
| 2024-06-13 07:00:00 | MSFT | Stock | 440.0 | 440.25 | 439.31 | 439.55 | 6618.0 |
| 2024-06-13 07:30:00 | MSFT | Stock | 439.42 | 439.42 | 439.05 | 439.05 | 5037.0 |
| 2024-06-13 08:00:00 | MSFT | Stock | 439.69 | 442.85 | 439.0167 | 440.0 | 38114.0 |
| 2024-06-13 08:30:00 | MSFT | Stock | 439.97 | 441.3 | 439.412 | 440.0 | 25697.0 |
| 2024-06-13 09:00:00 | MSFT | Stock | 439.5 | 441.2 | 439.2201 | 441.14 | 45720.0 |
| 2024-06-13 09:30:00 | MSFT | Stock | 441.02 | 443.06 | 439.37 | 441.7023 | 1534513.0 |
| 2024-06-13 10:00:00 | MSFT | Stock | 441.64 | 442.1 | 440.44 | 441.955 | 610156.0 |
| 2024-06-13 10:30:00 | MSFT | Stock | 441.96 | 442.97 | 441.745 | 442.18 | 717430.0 |
| 2024-06-13 11:00:00 | MSFT | Stock | 442.27 | 443.32 | 442.08 | 442.99 | 605744.0 |
| 2024-06-13 11:30:00 | MSFT | Stock | 442.9842 | 443.39 | 442.16 | 442.25 | 369743.0 |
| 2024-06-13 12:00:00 | MSFT | Stock | 442.29 | 442.3 | 439.8 | 439.94 | 439610.0 |
| 2024-06-13 12:30:00 | MSFT | Stock | 439.9 | 441.6 | 439.6603 | 441.42 | 346412.0 |
> showing 50 of 98,003 rows — these rows as CSV