PREVIEW / stock_30min / 2024-10-15
file: by_date/stock_30min/2024/2024-10-15.parquet size: 2.1 MB rows: 100,956 symbols: 757
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-15 04:00:00 | AAPL | Stock | 231.34 | 231.34 | 230.38 | 230.72 | 9845.0 |
| 2024-10-15 04:30:00 | AAPL | Stock | 230.59 | 230.7 | 230.3 | 230.54 | 8905.0 |
| 2024-10-15 05:00:00 | AAPL | Stock | 230.55 | 230.7 | 230.45 | 230.7 | 3909.0 |
| 2024-10-15 05:30:00 | AAPL | Stock | 230.7 | 230.81 | 230.55 | 230.81 | 6220.0 |
| 2024-10-15 06:00:00 | AAPL | Stock | 230.86 | 231.2 | 230.75 | 231.0 | 6602.0 |
| 2024-10-15 06:30:00 | AAPL | Stock | 231.1 | 233.02 | 231.1 | 232.65 | 75539.0 |
| 2024-10-15 07:00:00 | AAPL | Stock | 232.54 | 233.29 | 232.3 | 233.2 | 63621.0 |
| 2024-10-15 07:30:00 | AAPL | Stock | 233.23 | 233.99 | 233.14 | 233.99 | 56684.0 |
| 2024-10-15 08:00:00 | AAPL | Stock | 232.68 | 234.4 | 230.722 | 234.1595 | 162802.0 |
| 2024-10-15 08:30:00 | AAPL | Stock | 234.3 | 234.48 | 234.0 | 234.3185 | 85841.0 |
| 2024-10-15 09:00:00 | AAPL | Stock | 234.21 | 234.47 | 233.36 | 233.5 | 219717.0 |
| 2024-10-15 09:30:00 | AAPL | Stock | 233.6 | 237.13 | 232.37 | 236.635 | 10638540.0 |
| 2024-10-15 10:00:00 | AAPL | Stock | 236.635 | 237.49 | 235.75 | 235.82 | 4821093.0 |
| 2024-10-15 10:30:00 | AAPL | Stock | 235.83 | 236.13 | 235.14 | 235.38 | 3377138.0 |
| 2024-10-15 11:00:00 | AAPL | Stock | 235.37 | 235.81 | 234.6701 | 235.4314 | 2216768.0 |
| 2024-10-15 11:30:00 | AAPL | Stock | 235.43 | 236.29 | 235.32 | 235.37 | 1586238.0 |
| 2024-10-15 12:00:00 | AAPL | Stock | 235.38 | 235.82 | 234.55 | 234.76 | 1662744.0 |
| 2024-10-15 12:30:00 | AAPL | Stock | 234.75 | 235.2 | 234.31 | 234.48 | 1226589.0 |
| 2024-10-15 13:00:00 | AAPL | Stock | 234.4699 | 234.66 | 233.84 | 234.02 | 1101567.0 |
| 2024-10-15 13:30:00 | AAPL | Stock | 233.99 | 234.47 | 233.73 | 233.76 | 1095083.0 |
| 2024-10-15 14:00:00 | AAPL | Stock | 233.77 | 234.17 | 233.5 | 233.94 | 1074283.0 |
| 2024-10-15 14:30:00 | AAPL | Stock | 233.935 | 234.08 | 233.735 | 233.78 | 815822.0 |
| 2024-10-15 15:00:00 | AAPL | Stock | 233.8 | 233.9 | 233.045 | 233.24 | 1650580.0 |
| 2024-10-15 15:30:00 | AAPL | Stock | 233.25 | 234.07 | 232.81 | 233.8 | 4337881.0 |
| 2024-10-15 16:00:00 | AAPL | Stock | 233.83 | 234.07 | 233.6 | 233.92 | 6945209.0 |
| 2024-10-15 16:30:00 | AAPL | Stock | 233.91 | 233.95 | 233.8103 | 233.8436 | 63950.0 |
| 2024-10-15 17:00:00 | AAPL | Stock | 233.85 | 233.89 | 233.5013 | 233.719 | 11128.0 |
| 2024-10-15 17:30:00 | AAPL | Stock | 233.6047 | 233.67 | 233.5 | 233.6 | 4363.0 |
| 2024-10-15 18:00:00 | AAPL | Stock | 233.56 | 233.73 | 233.5036 | 233.73 | 6807.0 |
| 2024-10-15 18:30:00 | AAPL | Stock | 233.7965 | 234.0 | 233.5601 | 233.83 | 9889.0 |
| 2024-10-15 19:00:00 | AAPL | Stock | 233.99 | 234.08 | 233.95 | 234.042 | 6597.0 |
| 2024-10-15 19:30:00 | AAPL | Stock | 234.042 | 234.14 | 233.9532 | 234.1 | 11640.0 |
| 2024-10-15 04:00:00 | MSFT | Stock | 420.34 | 420.34 | 419.1 | 419.1 | 6229.0 |
| 2024-10-15 04:30:00 | MSFT | Stock | 419.29 | 419.72 | 419.29 | 419.62 | 1372.0 |
| 2024-10-15 05:00:00 | MSFT | Stock | 419.38 | 419.38 | 419.38 | 419.38 | 387.0 |
| 2024-10-15 05:30:00 | MSFT | Stock | 419.8 | 419.8 | 419.64 | 419.72 | 2068.0 |
| 2024-10-15 06:00:00 | MSFT | Stock | 419.8 | 419.94 | 419.8 | 419.94 | 1624.0 |
| 2024-10-15 06:30:00 | MSFT | Stock | 419.94 | 420.67 | 419.83 | 420.3 | 1984.0 |
| 2024-10-15 07:00:00 | MSFT | Stock | 420.26 | 420.39 | 419.8 | 420.0 | 6937.0 |
| 2024-10-15 07:30:00 | MSFT | Stock | 420.02 | 420.02 | 419.81 | 420.0 | 2104.0 |
| 2024-10-15 08:00:00 | MSFT | Stock | 420.3 | 420.48 | 419.41 | 420.1 | 24150.0 |
| 2024-10-15 08:30:00 | MSFT | Stock | 420.15 | 420.9 | 420.1 | 420.9 | 12038.0 |
| 2024-10-15 09:00:00 | MSFT | Stock | 420.79 | 422.25 | 420.74 | 422.11 | 22121.0 |
| 2024-10-15 09:30:00 | MSFT | Stock | 422.2 | 422.48 | 419.84 | 420.57 | 1120813.0 |
| 2024-10-15 10:00:00 | MSFT | Stock | 420.54 | 420.81 | 418.05 | 418.11 | 666114.0 |
| 2024-10-15 10:30:00 | MSFT | Stock | 418.03 | 418.03 | 415.26 | 416.63 | 999415.0 |
| 2024-10-15 11:00:00 | MSFT | Stock | 416.6 | 418.15 | 416.32 | 416.69 | 403648.0 |
| 2024-10-15 11:30:00 | MSFT | Stock | 416.67 | 417.3297 | 415.64 | 415.88 | 387041.0 |
| 2024-10-15 12:00:00 | MSFT | Stock | 415.89 | 417.1 | 415.89 | 416.54 | 374416.0 |
| 2024-10-15 12:30:00 | MSFT | Stock | 416.6 | 417.62 | 416.5401 | 417.555 | 272663.0 |
> showing 50 of 100,956 rows — these rows as CSV