PREVIEW / stock_30min / 2023-09-26
file: by_date/stock_30min/2023/2023-09-26.parquet size: 2.0 MB rows: 96,237 symbols: 1,400
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 |
|---|---|---|---|---|---|---|---|
| 2023-09-26 04:00:00 | AAPL | Stock | 175.19 | 175.34 | 175.06 | 175.2 | 11317.0 |
| 2023-09-26 04:30:00 | AAPL | Stock | 175.2 | 175.21 | 174.98 | 174.98 | 6660.0 |
| 2023-09-26 05:00:00 | AAPL | Stock | 175.01 | 175.1 | 174.96 | 175.05 | 2052.0 |
| 2023-09-26 05:30:00 | AAPL | Stock | 175.1 | 175.14 | 174.93 | 174.95 | 4177.0 |
| 2023-09-26 06:00:00 | AAPL | Stock | 175.1 | 175.22 | 175.0 | 175.19 | 2916.0 |
| 2023-09-26 06:30:00 | AAPL | Stock | 175.1 | 175.29 | 175.1 | 175.29 | 1591.0 |
| 2023-09-26 07:00:00 | AAPL | Stock | 175.32 | 175.37 | 175.04 | 175.36 | 13526.0 |
| 2023-09-26 07:30:00 | AAPL | Stock | 175.34 | 175.51 | 175.3 | 175.42 | 5797.0 |
| 2023-09-26 08:00:00 | AAPL | Stock | 175.2 | 175.5927 | 174.85 | 175.31 | 63894.0 |
| 2023-09-26 08:30:00 | AAPL | Stock | 175.31 | 175.35 | 175.03 | 175.15 | 46168.0 |
| 2023-09-26 09:00:00 | AAPL | Stock | 175.0322 | 175.1213 | 174.59 | 174.82 | 83576.0 |
| 2023-09-26 09:30:00 | AAPL | Stock | 174.82 | 175.2 | 172.93 | 173.04 | 7573507.0 |
| 2023-09-26 10:00:00 | AAPL | Stock | 173.04 | 173.46 | 172.48 | 173.1 | 5665030.0 |
| 2023-09-26 10:30:00 | AAPL | Stock | 173.09 | 173.65 | 172.69 | 172.77 | 3887543.0 |
| 2023-09-26 11:00:00 | AAPL | Stock | 172.77 | 172.91 | 172.415 | 172.57 | 2823878.0 |
| 2023-09-26 11:30:00 | AAPL | Stock | 172.58 | 173.19 | 172.53 | 172.86 | 2514146.0 |
| 2023-09-26 12:00:00 | AAPL | Stock | 172.8599 | 173.04 | 172.52 | 173.01 | 2049773.0 |
| 2023-09-26 12:30:00 | AAPL | Stock | 173.01 | 173.36 | 172.9 | 173.21 | 1424633.0 |
| 2023-09-26 13:00:00 | AAPL | Stock | 173.21 | 173.53 | 172.845 | 172.845 | 2195294.0 |
| 2023-09-26 13:30:00 | AAPL | Stock | 172.855 | 173.005 | 172.56 | 172.8 | 2022196.0 |
| 2023-09-26 14:00:00 | AAPL | Stock | 172.795 | 172.87 | 172.22 | 172.305 | 2567725.0 |
| 2023-09-26 14:30:00 | AAPL | Stock | 172.3 | 172.44 | 172.03 | 172.26 | 2728909.0 |
| 2023-09-26 15:00:00 | AAPL | Stock | 172.2579 | 172.35 | 171.66 | 171.74 | 3729782.0 |
| 2023-09-26 15:30:00 | AAPL | Stock | 171.74 | 172.33 | 171.72 | 171.9 | 7475910.0 |
| 2023-09-26 16:00:00 | AAPL | Stock | 171.89 | 172.29 | 171.89 | 172.16 | 7568915.0 |
| 2023-09-26 16:30:00 | AAPL | Stock | 172.18 | 172.3 | 171.96 | 172.2 | 174112.0 |
| 2023-09-26 17:00:00 | AAPL | Stock | 172.1999 | 172.23 | 172.13 | 172.21 | 21993.0 |
| 2023-09-26 17:30:00 | AAPL | Stock | 172.2 | 172.2096 | 171.99 | 172.11 | 42274.0 |
| 2023-09-26 18:00:00 | AAPL | Stock | 172.11 | 172.17 | 172.0 | 172.0687 | 10370.0 |
| 2023-09-26 18:30:00 | AAPL | Stock | 172.07 | 172.19 | 172.02 | 172.02 | 19966.0 |
| 2023-09-26 19:00:00 | AAPL | Stock | 172.06 | 172.28 | 172.04 | 172.19 | 11369.0 |
| 2023-09-26 19:30:00 | AAPL | Stock | 172.28 | 172.4 | 172.16 | 172.36 | 16985.0 |
| 2023-09-26 04:00:00 | MSFT | Stock | 316.48 | 316.48 | 315.6 | 315.7 | 4922.0 |
| 2023-09-26 04:30:00 | MSFT | Stock | 315.8 | 315.8 | 315.45 | 315.45 | 699.0 |
| 2023-09-26 05:00:00 | MSFT | Stock | 315.4 | 315.4 | 315.21 | 315.21 | 433.0 |
| 2023-09-26 05:30:00 | MSFT | Stock | 315.9 | 315.9 | 315.55 | 315.55 | 1217.0 |
| 2023-09-26 06:00:00 | MSFT | Stock | 315.5 | 315.75 | 315.5 | 315.75 | 315.0 |
| 2023-09-26 06:30:00 | MSFT | Stock | 316.1 | 316.3 | 316.1 | 316.3 | 800.0 |
| 2023-09-26 07:00:00 | MSFT | Stock | 316.25 | 316.45 | 315.75 | 316.45 | 1808.0 |
| 2023-09-26 07:30:00 | MSFT | Stock | 316.2 | 316.37 | 316.1 | 316.37 | 489.0 |
| 2023-09-26 08:00:00 | MSFT | Stock | 315.7625 | 316.8995 | 315.34 | 316.45 | 15188.0 |
| 2023-09-26 08:30:00 | MSFT | Stock | 316.25 | 316.48 | 315.7 | 315.7 | 8419.0 |
| 2023-09-26 09:00:00 | MSFT | Stock | 315.67 | 315.92 | 314.9 | 315.13 | 54008.0 |
| 2023-09-26 09:30:00 | MSFT | Stock | 315.19 | 315.88 | 313.185 | 313.27 | 2171132.0 |
| 2023-09-26 10:00:00 | MSFT | Stock | 313.24 | 313.7199 | 311.56 | 312.56 | 1788250.0 |
| 2023-09-26 10:30:00 | MSFT | Stock | 312.54 | 313.41 | 312.09 | 312.89 | 1239773.0 |
| 2023-09-26 11:00:00 | MSFT | Stock | 312.89 | 313.14 | 311.08 | 311.08 | 837259.0 |
| 2023-09-26 11:30:00 | MSFT | Stock | 311.0838 | 312.28 | 310.83 | 311.455 | 962864.0 |
| 2023-09-26 12:00:00 | MSFT | Stock | 311.46 | 312.7 | 311.25 | 312.28 | 775628.0 |
| 2023-09-26 12:30:00 | MSFT | Stock | 312.2799 | 312.81 | 312.0901 | 312.3328 | 538271.0 |
> showing 50 of 96,237 rows — these rows as CSV