PREVIEW / stock_30min / 2024-07-12
file: by_date/stock_30min/2024/2024-07-12.parquet size: 2.1 MB rows: 100,301 symbols: 900
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-07-12 04:00:00 | AAPL | Stock | 228.0 | 228.5 | 227.29 | 228.5 | 13297.0 |
| 2024-07-12 04:30:00 | AAPL | Stock | 228.5 | 228.5 | 228.16 | 228.37 | 4749.0 |
| 2024-07-12 05:00:00 | AAPL | Stock | 228.47 | 228.69 | 228.2 | 228.2 | 6379.0 |
| 2024-07-12 05:30:00 | AAPL | Stock | 228.34 | 228.47 | 228.09 | 228.44 | 5005.0 |
| 2024-07-12 06:00:00 | AAPL | Stock | 228.47 | 228.47 | 228.3 | 228.34 | 3412.0 |
| 2024-07-12 06:30:00 | AAPL | Stock | 228.33 | 228.35 | 228.17 | 228.3 | 5903.0 |
| 2024-07-12 07:00:00 | AAPL | Stock | 228.3 | 228.45 | 227.88 | 228.4 | 17566.0 |
| 2024-07-12 07:30:00 | AAPL | Stock | 228.4 | 228.76 | 228.32 | 228.58 | 20285.0 |
| 2024-07-12 08:00:00 | AAPL | Stock | 228.31 | 228.77 | 227.44 | 228.38 | 102741.0 |
| 2024-07-12 08:30:00 | AAPL | Stock | 228.3 | 228.64 | 227.68 | 228.2 | 70641.0 |
| 2024-07-12 09:00:00 | AAPL | Stock | 228.27 | 229.29 | 227.8379 | 229.05 | 127687.0 |
| 2024-07-12 09:30:00 | AAPL | Stock | 228.92 | 231.39 | 228.68 | 231.35 | 6631568.0 |
| 2024-07-12 10:00:00 | AAPL | Stock | 231.36 | 231.5 | 230.3 | 230.88 | 3927847.0 |
| 2024-07-12 10:30:00 | AAPL | Stock | 230.88 | 232.15 | 230.62 | 231.85 | 3205949.0 |
| 2024-07-12 11:00:00 | AAPL | Stock | 231.84 | 232.398 | 231.39 | 231.8999 | 3036461.0 |
| 2024-07-12 11:30:00 | AAPL | Stock | 231.89 | 231.99 | 230.84 | 230.9001 | 2239083.0 |
| 2024-07-12 12:00:00 | AAPL | Stock | 230.9 | 231.1597 | 230.51 | 230.71 | 1787570.0 |
| 2024-07-12 12:30:00 | AAPL | Stock | 230.71 | 231.4601 | 230.57 | 231.445 | 1205017.0 |
| 2024-07-12 13:00:00 | AAPL | Stock | 231.45 | 231.91 | 231.335 | 231.9025 | 1422869.0 |
| 2024-07-12 13:30:00 | AAPL | Stock | 231.9 | 232.64 | 231.83 | 232.295 | 2305048.0 |
| 2024-07-12 14:00:00 | AAPL | Stock | 232.28 | 232.4809 | 231.87 | 232.27 | 1469283.0 |
| 2024-07-12 14:30:00 | AAPL | Stock | 232.265 | 232.36 | 232.02 | 232.22 | 1106826.0 |
| 2024-07-12 15:00:00 | AAPL | Stock | 232.215 | 232.25 | 231.56 | 231.8599 | 1680003.0 |
| 2024-07-12 15:30:00 | AAPL | Stock | 231.86 | 231.87 | 229.91 | 230.56 | 4720050.0 |
| 2024-07-12 16:00:00 | AAPL | Stock | 230.63 | 230.63 | 229.51 | 230.07 | 6573465.0 |
| 2024-07-12 16:30:00 | AAPL | Stock | 230.1 | 230.54 | 230.01 | 230.18 | 62104.0 |
| 2024-07-12 17:00:00 | AAPL | Stock | 230.18 | 230.54 | 230.17 | 230.25 | 149974.0 |
| 2024-07-12 17:30:00 | AAPL | Stock | 230.25 | 230.3 | 230.2 | 230.28 | 12526.0 |
| 2024-07-12 18:00:00 | AAPL | Stock | 230.27 | 230.29 | 230.2 | 230.24 | 5189.0 |
| 2024-07-12 18:30:00 | AAPL | Stock | 230.21 | 230.24 | 230.19 | 230.23 | 3564.0 |
| 2024-07-12 19:00:00 | AAPL | Stock | 230.23 | 230.25 | 230.2 | 230.2417 | 5930.0 |
| 2024-07-12 19:30:00 | AAPL | Stock | 230.25 | 230.5 | 230.25 | 230.427 | 13411.0 |
| 2024-07-12 04:00:00 | MSFT | Stock | 454.47 | 455.94 | 454.47 | 455.94 | 1689.0 |
| 2024-07-12 05:00:00 | MSFT | Stock | 455.59 | 455.84 | 455.0 | 455.0 | 1638.0 |
| 2024-07-12 05:30:00 | MSFT | Stock | 455.4 | 455.4 | 455.33 | 455.33 | 325.0 |
| 2024-07-12 06:00:00 | MSFT | Stock | 455.53 | 455.66 | 454.73 | 454.79 | 2766.0 |
| 2024-07-12 06:30:00 | MSFT | Stock | 454.79 | 454.8 | 454.79 | 454.8 | 368.0 |
| 2024-07-12 07:00:00 | MSFT | Stock | 454.35 | 455.0 | 454.12 | 455.0 | 3739.0 |
| 2024-07-12 07:30:00 | MSFT | Stock | 455.21 | 455.26 | 455.0 | 455.14 | 1640.0 |
| 2024-07-12 08:00:00 | MSFT | Stock | 454.92 | 455.4987 | 453.0 | 454.17 | 14255.0 |
| 2024-07-12 08:30:00 | MSFT | Stock | 454.07 | 456.2166 | 452.52 | 454.84 | 19735.0 |
| 2024-07-12 09:00:00 | MSFT | Stock | 455.41 | 455.87 | 454.0 | 454.78 | 16795.0 |
| 2024-07-12 09:30:00 | MSFT | Stock | 454.58 | 454.58 | 450.645 | 453.35 | 1498746.0 |
| 2024-07-12 10:00:00 | MSFT | Stock | 453.37 | 454.22 | 452.41 | 453.55 | 647746.0 |
| 2024-07-12 10:30:00 | MSFT | Stock | 453.54 | 454.865 | 453.425 | 454.1 | 535081.0 |
| 2024-07-12 11:00:00 | MSFT | Stock | 454.08 | 454.865 | 453.63 | 454.625 | 447579.0 |
| 2024-07-12 11:30:00 | MSFT | Stock | 454.61 | 454.96 | 453.57 | 453.66 | 382265.0 |
| 2024-07-12 12:00:00 | MSFT | Stock | 453.6 | 454.16 | 452.75 | 453.81 | 342314.0 |
| 2024-07-12 12:30:00 | MSFT | Stock | 453.82 | 454.05 | 453.435 | 453.7 | 296268.0 |
| 2024-07-12 13:00:00 | MSFT | Stock | 453.68 | 454.94 | 453.6 | 454.795 | 300438.0 |
> showing 50 of 100,301 rows — these rows as CSV