PREVIEW / stock_30min / 2024-07-15
file: by_date/stock_30min/2024/2024-07-15.parquet size: 2.1 MB rows: 102,084 symbols: 907
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-15 04:00:00 | AAPL | Stock | 232.22 | 234.0 | 232.0 | 233.39 | 85673.0 |
| 2024-07-15 04:30:00 | AAPL | Stock | 233.38 | 234.77 | 233.38 | 234.4 | 68423.0 |
| 2024-07-15 05:00:00 | AAPL | Stock | 234.5 | 234.8 | 234.08 | 234.68 | 33703.0 |
| 2024-07-15 05:30:00 | AAPL | Stock | 235.1 | 235.21 | 234.64 | 235.07 | 9710.0 |
| 2024-07-15 06:00:00 | AAPL | Stock | 235.0 | 235.56 | 234.89 | 235.33 | 22598.0 |
| 2024-07-15 06:30:00 | AAPL | Stock | 235.4 | 235.48 | 235.09 | 235.09 | 10388.0 |
| 2024-07-15 07:00:00 | AAPL | Stock | 235.03 | 235.3 | 234.81 | 235.14 | 66674.0 |
| 2024-07-15 07:30:00 | AAPL | Stock | 235.16 | 235.38 | 234.7 | 234.7 | 68772.0 |
| 2024-07-15 08:00:00 | AAPL | Stock | 234.9101 | 235.48 | 231.0 | 235.06 | 300068.0 |
| 2024-07-15 08:30:00 | AAPL | Stock | 235.05 | 235.18 | 234.9 | 235.06 | 103126.0 |
| 2024-07-15 09:00:00 | AAPL | Stock | 235.1 | 236.67 | 235.1 | 236.42 | 487407.0 |
| 2024-07-15 09:30:00 | AAPL | Stock | 236.47 | 237.23 | 233.33 | 234.4901 | 11224324.0 |
| 2024-07-15 10:00:00 | AAPL | Stock | 234.5 | 235.49 | 234.13 | 234.7901 | 4096347.0 |
| 2024-07-15 10:30:00 | AAPL | Stock | 234.82 | 235.62 | 234.48 | 235.5013 | 2632439.0 |
| 2024-07-15 11:00:00 | AAPL | Stock | 235.51 | 236.3101 | 235.31 | 235.6 | 2784858.0 |
| 2024-07-15 11:30:00 | AAPL | Stock | 235.58 | 235.9498 | 234.66 | 235.09 | 2048175.0 |
| 2024-07-15 12:00:00 | AAPL | Stock | 235.09 | 235.39 | 234.5 | 235.308 | 1524471.0 |
| 2024-07-15 12:30:00 | AAPL | Stock | 235.32 | 235.88 | 235.15 | 235.4529 | 1340676.0 |
| 2024-07-15 13:00:00 | AAPL | Stock | 235.46 | 235.49 | 234.62 | 234.68 | 1830675.0 |
| 2024-07-15 13:30:00 | AAPL | Stock | 234.6595 | 234.8 | 234.11 | 234.5499 | 1674131.0 |
| 2024-07-15 14:00:00 | AAPL | Stock | 234.538 | 234.61 | 233.904 | 234.205 | 1425745.0 |
| 2024-07-15 14:30:00 | AAPL | Stock | 234.21 | 234.8401 | 233.97 | 234.7837 | 1461042.0 |
| 2024-07-15 15:00:00 | AAPL | Stock | 234.78 | 235.08 | 234.5 | 234.58 | 1850579.0 |
| 2024-07-15 15:30:00 | AAPL | Stock | 234.58 | 234.79 | 233.09 | 234.42 | 4402094.0 |
| 2024-07-15 16:00:00 | AAPL | Stock | 234.43 | 234.75 | 234.4 | 234.74 | 8191451.0 |
| 2024-07-15 16:30:00 | AAPL | Stock | 234.73 | 234.99 | 234.4 | 234.95 | 522811.0 |
| 2024-07-15 17:00:00 | AAPL | Stock | 234.9799 | 234.98 | 234.9 | 234.94 | 27105.0 |
| 2024-07-15 17:30:00 | AAPL | Stock | 234.94 | 234.99 | 234.4 | 234.99 | 62921.0 |
| 2024-07-15 18:00:00 | AAPL | Stock | 234.99 | 235.15 | 234.97 | 235.05 | 18561.0 |
| 2024-07-15 18:30:00 | AAPL | Stock | 235.05 | 235.29 | 235.0301 | 235.26 | 11073.0 |
| 2024-07-15 19:00:00 | AAPL | Stock | 235.26 | 235.4 | 235.25 | 235.3799 | 13704.0 |
| 2024-07-15 19:30:00 | AAPL | Stock | 235.38 | 235.57 | 235.3601 | 235.57 | 27283.0 |
| 2024-07-15 04:00:00 | MSFT | Stock | 454.97 | 455.0 | 454.0 | 454.0 | 6412.0 |
| 2024-07-15 04:30:00 | MSFT | Stock | 454.05 | 454.53 | 454.05 | 454.53 | 1458.0 |
| 2024-07-15 05:00:00 | MSFT | Stock | 454.21 | 454.21 | 453.79 | 453.79 | 400.0 |
| 2024-07-15 05:30:00 | MSFT | Stock | 453.34 | 453.34 | 453.3 | 453.3 | 200.0 |
| 2024-07-15 06:00:00 | MSFT | Stock | 453.14 | 453.14 | 452.71 | 452.73 | 1863.0 |
| 2024-07-15 06:30:00 | MSFT | Stock | 452.7 | 452.7 | 452.14 | 452.38 | 1350.0 |
| 2024-07-15 07:00:00 | MSFT | Stock | 452.71 | 453.51 | 452.71 | 453.15 | 4879.0 |
| 2024-07-15 07:30:00 | MSFT | Stock | 453.4 | 453.45 | 452.6 | 453.28 | 4458.0 |
| 2024-07-15 08:00:00 | MSFT | Stock | 452.78 | 456.0 | 452.5 | 453.19 | 20125.0 |
| 2024-07-15 08:30:00 | MSFT | Stock | 453.27 | 453.27 | 452.75 | 452.75 | 9870.0 |
| 2024-07-15 09:00:00 | MSFT | Stock | 452.8936 | 453.1 | 452.5 | 453.1 | 12196.0 |
| 2024-07-15 09:30:00 | MSFT | Stock | 453.3 | 456.25 | 452.25 | 454.515 | 1117266.0 |
| 2024-07-15 10:00:00 | MSFT | Stock | 454.52 | 454.98 | 453.67 | 454.39 | 539771.0 |
| 2024-07-15 10:30:00 | MSFT | Stock | 454.39 | 456.13 | 454.19 | 455.48 | 516066.0 |
| 2024-07-15 11:00:00 | MSFT | Stock | 455.57 | 457.26 | 455.52 | 455.56 | 446618.0 |
| 2024-07-15 11:30:00 | MSFT | Stock | 455.58 | 456.09 | 453.88 | 455.14 | 389232.0 |
| 2024-07-15 12:00:00 | MSFT | Stock | 455.12 | 455.12 | 451.43 | 452.87 | 469983.0 |
| 2024-07-15 12:30:00 | MSFT | Stock | 452.85 | 453.77 | 452.7 | 453.48 | 228890.0 |
> showing 50 of 102,084 rows — these rows as CSV