PREVIEW / stock_30min / 2024-07-24
file: by_date/stock_30min/2024/2024-07-24.parquet size: 2.0 MB rows: 98,933 symbols: 882
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-24 04:00:00 | AAPL | Stock | 223.44 | 224.1 | 223.44 | 223.5 | 13014.0 |
| 2024-07-24 04:30:00 | AAPL | Stock | 223.51 | 224.0 | 223.4 | 223.76 | 3435.0 |
| 2024-07-24 05:00:00 | AAPL | Stock | 223.84 | 225.0 | 223.83 | 224.01 | 14692.0 |
| 2024-07-24 05:30:00 | AAPL | Stock | 224.07 | 224.18 | 224.03 | 224.1 | 4254.0 |
| 2024-07-24 06:00:00 | AAPL | Stock | 224.27 | 225.77 | 224.14 | 225.6 | 26793.0 |
| 2024-07-24 06:30:00 | AAPL | Stock | 225.41 | 225.64 | 225.0 | 225.0 | 11592.0 |
| 2024-07-24 07:00:00 | AAPL | Stock | 225.0 | 225.43 | 224.69 | 225.21 | 9861.0 |
| 2024-07-24 07:30:00 | AAPL | Stock | 225.44 | 225.47 | 224.57 | 224.8 | 14688.0 |
| 2024-07-24 08:00:00 | AAPL | Stock | 225.0 | 225.4495 | 223.07 | 223.7 | 73375.0 |
| 2024-07-24 08:30:00 | AAPL | Stock | 223.72 | 223.88 | 223.42 | 223.88 | 87422.0 |
| 2024-07-24 09:00:00 | AAPL | Stock | 223.8 | 224.37 | 223.73 | 224.0 | 59732.0 |
| 2024-07-24 09:30:00 | AAPL | Stock | 224.06 | 224.8 | 220.7 | 221.29 | 5769844.0 |
| 2024-07-24 10:00:00 | AAPL | Stock | 221.28 | 221.41 | 220.3 | 220.89 | 2729212.0 |
| 2024-07-24 10:30:00 | AAPL | Stock | 220.9 | 221.03 | 218.8 | 218.8302 | 4026069.0 |
| 2024-07-24 11:00:00 | AAPL | Stock | 218.86 | 219.2 | 218.29 | 218.675 | 3159445.0 |
| 2024-07-24 11:30:00 | AAPL | Stock | 218.67 | 218.84 | 218.02 | 218.04 | 2081645.0 |
| 2024-07-24 12:00:00 | AAPL | Stock | 218.04 | 218.09 | 217.13 | 217.905 | 2398799.0 |
| 2024-07-24 12:30:00 | AAPL | Stock | 217.9099 | 218.55 | 217.72 | 217.815 | 2084956.0 |
| 2024-07-24 13:00:00 | AAPL | Stock | 217.83 | 218.55 | 217.77 | 218.0258 | 1491288.0 |
| 2024-07-24 13:30:00 | AAPL | Stock | 218.02 | 218.42 | 217.84 | 218.1803 | 1407065.0 |
| 2024-07-24 14:00:00 | AAPL | Stock | 218.19 | 218.86 | 218.09 | 218.165 | 1566860.0 |
| 2024-07-24 14:30:00 | AAPL | Stock | 218.16 | 218.44 | 217.81 | 218.1735 | 1548974.0 |
| 2024-07-24 15:00:00 | AAPL | Stock | 218.17 | 218.23 | 217.7563 | 217.89 | 1762559.0 |
| 2024-07-24 15:30:00 | AAPL | Stock | 217.88 | 218.79 | 217.7 | 218.57 | 6278038.0 |
| 2024-07-24 16:00:00 | AAPL | Stock | 218.57 | 218.64 | 217.91 | 218.6 | 10283760.0 |
| 2024-07-24 16:30:00 | AAPL | Stock | 218.69 | 218.79 | 218.12 | 218.41 | 168173.0 |
| 2024-07-24 17:00:00 | AAPL | Stock | 218.4101 | 218.54 | 217.86 | 217.9 | 185110.0 |
| 2024-07-24 17:30:00 | AAPL | Stock | 217.91 | 217.91 | 217.6 | 217.85 | 26038.0 |
| 2024-07-24 18:00:00 | AAPL | Stock | 217.86 | 218.49 | 217.86 | 218.15 | 57473.0 |
| 2024-07-24 18:30:00 | AAPL | Stock | 218.16 | 218.26 | 217.9601 | 217.9601 | 15540.0 |
| 2024-07-24 19:00:00 | AAPL | Stock | 217.9841 | 218.2499 | 217.82 | 218.02 | 20243.0 |
| 2024-07-24 19:30:00 | AAPL | Stock | 218.0 | 218.1448 | 217.62 | 218.1448 | 39547.0 |
| 2024-07-24 04:00:00 | MSFT | Stock | 442.85 | 443.26 | 442.14 | 442.22 | 4508.0 |
| 2024-07-24 04:30:00 | MSFT | Stock | 442.17 | 442.49 | 442.04 | 442.49 | 2123.0 |
| 2024-07-24 05:00:00 | MSFT | Stock | 442.7 | 442.7 | 441.9 | 441.9 | 1942.0 |
| 2024-07-24 05:30:00 | MSFT | Stock | 441.89 | 441.89 | 441.0 | 441.58 | 1442.0 |
| 2024-07-24 06:00:00 | MSFT | Stock | 441.67 | 442.26 | 441.47 | 442.26 | 2051.0 |
| 2024-07-24 06:30:00 | MSFT | Stock | 442.44 | 442.44 | 441.5 | 441.5 | 2182.0 |
| 2024-07-24 07:00:00 | MSFT | Stock | 441.55 | 441.64 | 441.0 | 441.4 | 6841.0 |
| 2024-07-24 07:30:00 | MSFT | Stock | 441.51 | 441.7 | 441.19 | 441.5 | 3632.0 |
| 2024-07-24 08:00:00 | MSFT | Stock | 441.7 | 442.79 | 439.77 | 439.77 | 25456.0 |
| 2024-07-24 08:30:00 | MSFT | Stock | 439.85 | 440.01 | 439.2 | 439.299 | 17366.0 |
| 2024-07-24 09:00:00 | MSFT | Stock | 439.4175 | 440.26 | 438.5 | 440.26 | 32819.0 |
| 2024-07-24 09:30:00 | MSFT | Stock | 440.45 | 441.48 | 437.15 | 439.415 | 1278229.0 |
| 2024-07-24 10:00:00 | MSFT | Stock | 439.33 | 439.42 | 436.58 | 436.64 | 652783.0 |
| 2024-07-24 10:30:00 | MSFT | Stock | 436.63 | 437.08 | 433.4307 | 434.18 | 999561.0 |
| 2024-07-24 11:00:00 | MSFT | Stock | 434.2157 | 434.33 | 431.08 | 431.9926 | 1105100.0 |
| 2024-07-24 11:30:00 | MSFT | Stock | 431.93 | 432.69 | 430.81 | 431.61 | 889112.0 |
| 2024-07-24 12:00:00 | MSFT | Stock | 431.63 | 431.99 | 430.44 | 430.7501 | 882269.0 |
| 2024-07-24 12:30:00 | MSFT | Stock | 430.7364 | 431.31 | 429.12 | 429.15 | 1007079.0 |
> showing 50 of 98,933 rows — these rows as CSV