PREVIEW / stock_30min / 2024-09-12
file: by_date/stock_30min/2024/2024-09-12.parquet size: 2.0 MB rows: 97,656 symbols: 868
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-09-12 04:00:00 | AAPL | Stock | 222.5 | 223.45 | 221.92 | 222.3 | 7404.0 |
| 2024-09-12 04:30:00 | AAPL | Stock | 222.2 | 222.66 | 222.2 | 222.65 | 3648.0 |
| 2024-09-12 05:00:00 | AAPL | Stock | 222.61 | 222.97 | 222.61 | 222.97 | 2652.0 |
| 2024-09-12 05:30:00 | AAPL | Stock | 222.99 | 222.99 | 222.6 | 222.62 | 2703.0 |
| 2024-09-12 06:00:00 | AAPL | Stock | 222.6 | 222.6 | 222.5 | 222.56 | 11211.0 |
| 2024-09-12 06:30:00 | AAPL | Stock | 222.59 | 222.67 | 222.59 | 222.66 | 898.0 |
| 2024-09-12 07:00:00 | AAPL | Stock | 222.6 | 223.0 | 222.6 | 223.0 | 9933.0 |
| 2024-09-12 07:30:00 | AAPL | Stock | 222.85 | 223.0 | 222.6 | 222.6 | 7212.0 |
| 2024-09-12 08:00:00 | AAPL | Stock | 222.69 | 223.16 | 222.104 | 223.035 | 50845.0 |
| 2024-09-12 08:30:00 | AAPL | Stock | 223.0394 | 223.0394 | 222.5321 | 222.76 | 23436.0 |
| 2024-09-12 09:00:00 | AAPL | Stock | 222.6014 | 223.0 | 222.2 | 222.5 | 45782.0 |
| 2024-09-12 09:30:00 | AAPL | Stock | 222.51 | 222.58 | 219.82 | 221.04 | 4013786.0 |
| 2024-09-12 10:00:00 | AAPL | Stock | 221.04 | 222.3794 | 220.94 | 222.07 | 2213394.0 |
| 2024-09-12 10:30:00 | AAPL | Stock | 222.0712 | 222.37 | 221.09 | 221.8 | 1451666.0 |
| 2024-09-12 11:00:00 | AAPL | Stock | 221.81 | 223.0675 | 221.67 | 221.9 | 1798883.0 |
| 2024-09-12 11:30:00 | AAPL | Stock | 221.9 | 222.54 | 221.77 | 221.975 | 922326.0 |
| 2024-09-12 12:00:00 | AAPL | Stock | 221.98 | 222.2 | 221.62 | 221.93 | 747246.0 |
| 2024-09-12 12:30:00 | AAPL | Stock | 221.95 | 222.5399 | 221.7 | 222.5 | 826353.0 |
| 2024-09-12 13:00:00 | AAPL | Stock | 222.49 | 223.05 | 222.43 | 222.62 | 1037748.0 |
| 2024-09-12 13:30:00 | AAPL | Stock | 222.6 | 223.23 | 222.58 | 223.08 | 1168579.0 |
| 2024-09-12 14:00:00 | AAPL | Stock | 223.09 | 223.17 | 222.7 | 223.1401 | 1061462.0 |
| 2024-09-12 14:30:00 | AAPL | Stock | 223.14 | 223.55 | 222.16 | 223.19 | 1623067.0 |
| 2024-09-12 15:00:00 | AAPL | Stock | 223.18 | 223.5 | 222.655 | 222.94 | 1258335.0 |
| 2024-09-12 15:30:00 | AAPL | Stock | 222.93 | 223.349 | 222.25 | 222.87 | 3954207.0 |
| 2024-09-12 16:00:00 | AAPL | Stock | 222.87 | 222.87 | 222.35 | 222.57 | 6845953.0 |
| 2024-09-12 16:30:00 | AAPL | Stock | 222.56 | 222.77 | 222.15 | 222.29 | 19457.0 |
| 2024-09-12 17:00:00 | AAPL | Stock | 222.282 | 222.4 | 222.0 | 222.13 | 27739.0 |
| 2024-09-12 17:30:00 | AAPL | Stock | 222.1 | 222.2 | 222.0661 | 222.2 | 16490.0 |
| 2024-09-12 18:00:00 | AAPL | Stock | 222.41 | 222.65 | 222.2383 | 222.4695 | 13648.0 |
| 2024-09-12 18:30:00 | AAPL | Stock | 222.65 | 222.75 | 222.4695 | 222.64 | 17963.0 |
| 2024-09-12 19:00:00 | AAPL | Stock | 222.6 | 222.85 | 222.6 | 222.7 | 4199.0 |
| 2024-09-12 19:30:00 | AAPL | Stock | 222.77 | 222.95 | 222.7 | 222.757 | 7847.0 |
| 2024-09-12 04:00:00 | MSFT | Stock | 423.7 | 424.05 | 422.81 | 423.29 | 4428.0 |
| 2024-09-12 04:30:00 | MSFT | Stock | 423.22 | 423.22 | 422.52 | 423.06 | 2193.0 |
| 2024-09-12 05:00:00 | MSFT | Stock | 423.15 | 423.15 | 423.15 | 423.15 | 554.0 |
| 2024-09-12 06:00:00 | MSFT | Stock | 423.13 | 423.13 | 422.87 | 422.87 | 650.0 |
| 2024-09-12 06:30:00 | MSFT | Stock | 423.36 | 423.81 | 423.36 | 423.81 | 702.0 |
| 2024-09-12 07:00:00 | MSFT | Stock | 423.15 | 423.69 | 423.15 | 423.5 | 3306.0 |
| 2024-09-12 07:30:00 | MSFT | Stock | 423.5 | 423.64 | 423.48 | 423.51 | 1195.0 |
| 2024-09-12 08:00:00 | MSFT | Stock | 423.3 | 425.0 | 423.2 | 423.35 | 13325.0 |
| 2024-09-12 08:30:00 | MSFT | Stock | 423.35 | 423.55 | 422.004 | 422.65 | 18282.0 |
| 2024-09-12 09:00:00 | MSFT | Stock | 422.55 | 424.0 | 422.05 | 423.58 | 17152.0 |
| 2024-09-12 09:30:00 | MSFT | Stock | 423.58 | 424.01 | 420.14 | 421.07 | 1315137.0 |
| 2024-09-12 10:00:00 | MSFT | Stock | 421.06 | 423.0 | 420.3702 | 421.6 | 697868.0 |
| 2024-09-12 10:30:00 | MSFT | Stock | 421.61 | 422.25 | 420.0 | 420.24 | 619848.0 |
| 2024-09-12 11:00:00 | MSFT | Stock | 420.21 | 421.8658 | 419.75 | 420.53 | 435915.0 |
| 2024-09-12 11:30:00 | MSFT | Stock | 420.53 | 420.97 | 419.77 | 420.02 | 465387.0 |
| 2024-09-12 12:00:00 | MSFT | Stock | 420.0 | 421.14 | 419.8 | 421.14 | 325346.0 |
| 2024-09-12 12:30:00 | MSFT | Stock | 421.1103 | 422.965 | 420.8 | 422.75 | 336196.0 |
| 2024-09-12 13:00:00 | MSFT | Stock | 422.755 | 424.17 | 422.5 | 423.96 | 518767.0 |
> showing 50 of 97,656 rows — these rows as CSV