PREVIEW / stock_30min / 2024-04-03
file: by_date/stock_30min/2024/2024-04-03.parquet size: 2.0 MB rows: 99,840 symbols: 1,038
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-04-03 04:00:00 | AAPL | Stock | 169.3 | 169.3 | 168.81 | 168.87 | 8730.0 |
| 2024-04-03 04:30:00 | AAPL | Stock | 169.0 | 169.0 | 168.86 | 168.86 | 5800.0 |
| 2024-04-03 05:00:00 | AAPL | Stock | 168.86 | 168.9 | 168.54 | 168.54 | 2599.0 |
| 2024-04-03 05:30:00 | AAPL | Stock | 168.61 | 168.65 | 168.6 | 168.6 | 1514.0 |
| 2024-04-03 06:00:00 | AAPL | Stock | 168.6 | 168.75 | 168.5 | 168.7 | 3632.0 |
| 2024-04-03 06:30:00 | AAPL | Stock | 168.7 | 168.7 | 168.6 | 168.68 | 2705.0 |
| 2024-04-03 07:00:00 | AAPL | Stock | 168.72 | 169.09 | 168.72 | 168.97 | 12164.0 |
| 2024-04-03 07:30:00 | AAPL | Stock | 168.9 | 169.1 | 168.85 | 169.06 | 8967.0 |
| 2024-04-03 08:00:00 | AAPL | Stock | 168.74 | 169.35 | 168.72 | 168.9124 | 96862.0 |
| 2024-04-03 08:30:00 | AAPL | Stock | 168.91 | 169.06 | 168.68 | 168.97 | 38259.0 |
| 2024-04-03 09:00:00 | AAPL | Stock | 168.952 | 169.0583 | 168.42 | 168.77 | 56732.0 |
| 2024-04-03 09:30:00 | AAPL | Stock | 168.79 | 169.32 | 168.58 | 169.08 | 3760821.0 |
| 2024-04-03 10:00:00 | AAPL | Stock | 169.08 | 170.08 | 169.08 | 170.0367 | 3176326.0 |
| 2024-04-03 10:30:00 | AAPL | Stock | 170.025 | 170.65 | 169.98 | 170.52 | 2704659.0 |
| 2024-04-03 11:00:00 | AAPL | Stock | 170.5101 | 170.68 | 170.35 | 170.51 | 1681033.0 |
| 2024-04-03 11:30:00 | AAPL | Stock | 170.52 | 170.675 | 170.38 | 170.4 | 1525625.0 |
| 2024-04-03 12:00:00 | AAPL | Stock | 170.405 | 170.45 | 170.2 | 170.32 | 1433208.0 |
| 2024-04-03 12:30:00 | AAPL | Stock | 170.31 | 170.44 | 169.74 | 170.195 | 1867150.0 |
| 2024-04-03 13:00:00 | AAPL | Stock | 170.2 | 170.33 | 170.17 | 170.205 | 1168387.0 |
| 2024-04-03 13:30:00 | AAPL | Stock | 170.21 | 170.39 | 170.15 | 170.17 | 1127454.0 |
| 2024-04-03 14:00:00 | AAPL | Stock | 170.17 | 170.29 | 170.1201 | 170.197 | 976703.0 |
| 2024-04-03 14:30:00 | AAPL | Stock | 170.2 | 170.38 | 170.06 | 170.26 | 1132224.0 |
| 2024-04-03 15:00:00 | AAPL | Stock | 170.2734 | 170.61 | 169.28 | 169.5273 | 4094199.0 |
| 2024-04-03 15:30:00 | AAPL | Stock | 169.53 | 170.15 | 169.38 | 169.66 | 5631045.0 |
| 2024-04-03 16:00:00 | AAPL | Stock | 169.65 | 169.77 | 169.25 | 169.73 | 6172508.0 |
| 2024-04-03 16:30:00 | AAPL | Stock | 169.74 | 169.7598 | 169.6317 | 169.72 | 46074.0 |
| 2024-04-03 17:00:00 | AAPL | Stock | 169.73 | 169.795 | 169.69 | 169.7 | 12671.0 |
| 2024-04-03 17:30:00 | AAPL | Stock | 169.7 | 169.86 | 169.65 | 169.76 | 4836.0 |
| 2024-04-03 18:00:00 | AAPL | Stock | 169.75 | 169.75 | 169.52 | 169.67 | 5236.0 |
| 2024-04-03 18:30:00 | AAPL | Stock | 169.67 | 169.7 | 169.64 | 169.7 | 6712.0 |
| 2024-04-03 19:00:00 | AAPL | Stock | 169.65 | 170.0 | 169.62 | 169.78 | 23297.0 |
| 2024-04-03 19:30:00 | AAPL | Stock | 169.9 | 170.64 | 169.88 | 170.14 | 31481.0 |
| 2024-04-03 04:00:00 | MSFT | Stock | 420.5 | 421.21 | 420.37 | 421.16 | 1652.0 |
| 2024-04-03 04:30:00 | MSFT | Stock | 421.19 | 421.19 | 421.18 | 421.18 | 876.0 |
| 2024-04-03 05:00:00 | MSFT | Stock | 421.0 | 421.5 | 421.0 | 421.5 | 202.0 |
| 2024-04-03 05:30:00 | MSFT | Stock | 421.6 | 421.7 | 421.56 | 421.59 | 1889.0 |
| 2024-04-03 06:30:00 | MSFT | Stock | 421.4 | 421.4 | 421.28 | 421.28 | 418.0 |
| 2024-04-03 07:00:00 | MSFT | Stock | 421.42 | 421.62 | 421.18 | 421.18 | 1443.0 |
| 2024-04-03 07:30:00 | MSFT | Stock | 421.23 | 421.39 | 421.12 | 421.39 | 1434.0 |
| 2024-04-03 08:00:00 | MSFT | Stock | 421.4 | 421.82 | 420.0 | 420.79 | 5936.0 |
| 2024-04-03 08:30:00 | MSFT | Stock | 420.56 | 420.7455 | 420.43 | 420.64 | 2294.0 |
| 2024-04-03 09:00:00 | MSFT | Stock | 421.0 | 421.07 | 419.53 | 419.75 | 11237.0 |
| 2024-04-03 09:30:00 | MSFT | Stock | 419.73 | 420.224 | 419.085 | 419.92 | 1408731.0 |
| 2024-04-03 10:00:00 | MSFT | Stock | 419.96 | 422.83 | 419.88 | 422.67 | 1471132.0 |
| 2024-04-03 10:30:00 | MSFT | Stock | 422.7 | 423.07 | 422.28 | 422.9754 | 664112.0 |
| 2024-04-03 11:00:00 | MSFT | Stock | 423.0 | 423.22 | 422.57 | 422.92 | 429642.0 |
| 2024-04-03 11:30:00 | MSFT | Stock | 422.93 | 423.26 | 422.31 | 422.5 | 378310.0 |
| 2024-04-03 12:00:00 | MSFT | Stock | 422.4601 | 422.8 | 421.88 | 422.76 | 448823.0 |
| 2024-04-03 12:30:00 | MSFT | Stock | 422.76 | 422.85 | 421.35 | 422.2681 | 345004.0 |
| 2024-04-03 13:00:00 | MSFT | Stock | 422.26 | 422.575 | 421.87 | 422.32 | 235217.0 |
> showing 50 of 99,840 rows — these rows as CSV