PREVIEW / stock_30min / 2024-03-21
file: by_date/stock_30min/2024/2024-03-21.parquet size: 2.1 MB rows: 102,373 symbols: 1,077
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-03-21 04:00:00 | AAPL | Stock | 177.03 | 177.03 | 176.11 | 176.88 | 23885.0 |
| 2024-03-21 04:30:00 | AAPL | Stock | 176.81 | 176.97 | 176.51 | 176.79 | 18316.0 |
| 2024-03-21 05:00:00 | AAPL | Stock | 176.78 | 176.78 | 176.34 | 176.56 | 7063.0 |
| 2024-03-21 05:30:00 | AAPL | Stock | 176.55 | 176.67 | 176.43 | 176.58 | 5502.0 |
| 2024-03-21 06:00:00 | AAPL | Stock | 176.62 | 176.62 | 176.46 | 176.53 | 6438.0 |
| 2024-03-21 06:30:00 | AAPL | Stock | 176.49 | 176.51 | 176.36 | 176.46 | 13116.0 |
| 2024-03-21 07:00:00 | AAPL | Stock | 176.52 | 176.83 | 176.4 | 176.8 | 56635.0 |
| 2024-03-21 07:30:00 | AAPL | Stock | 176.77 | 177.02 | 176.75 | 176.9 | 16914.0 |
| 2024-03-21 08:00:00 | AAPL | Stock | 176.68 | 177.4 | 176.4 | 177.26 | 168371.0 |
| 2024-03-21 08:30:00 | AAPL | Stock | 177.35 | 177.66 | 177.1 | 177.53 | 90139.0 |
| 2024-03-21 09:00:00 | AAPL | Stock | 177.47 | 177.5799 | 176.9 | 176.93 | 169827.0 |
| 2024-03-21 09:30:00 | AAPL | Stock | 177.05 | 177.49 | 175.99 | 176.05 | 6952007.0 |
| 2024-03-21 10:00:00 | AAPL | Stock | 176.05 | 176.19 | 175.005 | 175.0218 | 5347342.0 |
| 2024-03-21 10:30:00 | AAPL | Stock | 175.03 | 175.06 | 172.58 | 172.5907 | 12905363.0 |
| 2024-03-21 11:00:00 | AAPL | Stock | 172.61 | 172.97 | 171.83 | 172.8213 | 10603684.0 |
| 2024-03-21 11:30:00 | AAPL | Stock | 172.82 | 173.24 | 171.89 | 171.98 | 6781700.0 |
| 2024-03-21 12:00:00 | AAPL | Stock | 171.985 | 172.6 | 171.86 | 172.565 | 4680301.0 |
| 2024-03-21 12:30:00 | AAPL | Stock | 172.57 | 172.6 | 171.95 | 172.14 | 2893964.0 |
| 2024-03-21 13:00:00 | AAPL | Stock | 172.14 | 172.41 | 172.015 | 172.1083 | 2848013.0 |
| 2024-03-21 13:30:00 | AAPL | Stock | 172.11 | 172.13 | 171.07 | 171.095 | 4259594.0 |
| 2024-03-21 14:00:00 | AAPL | Stock | 171.095 | 171.48 | 170.91 | 171.075 | 4387531.0 |
| 2024-03-21 14:30:00 | AAPL | Stock | 171.08 | 171.255 | 170.85 | 171.1174 | 3760725.0 |
| 2024-03-21 15:00:00 | AAPL | Stock | 171.1199 | 171.33 | 170.87 | 171.25 | 3781702.0 |
| 2024-03-21 15:30:00 | AAPL | Stock | 171.24 | 171.57 | 170.84 | 171.4 | 8125547.0 |
| 2024-03-21 16:00:00 | AAPL | Stock | 171.37 | 171.55 | 171.04 | 171.54 | 9864108.0 |
| 2024-03-21 16:30:00 | AAPL | Stock | 171.54 | 171.64 | 171.37 | 171.54 | 308906.0 |
| 2024-03-21 17:00:00 | AAPL | Stock | 171.52 | 171.79 | 171.5 | 171.66 | 95183.0 |
| 2024-03-21 17:30:00 | AAPL | Stock | 171.65 | 171.69 | 171.5 | 171.55 | 41314.0 |
| 2024-03-21 18:00:00 | AAPL | Stock | 171.55 | 171.78 | 171.37 | 171.73 | 97559.0 |
| 2024-03-21 18:30:00 | AAPL | Stock | 171.73 | 171.77 | 171.57 | 171.65 | 78782.0 |
| 2024-03-21 19:00:00 | AAPL | Stock | 171.6789 | 171.72 | 171.6 | 171.69 | 35688.0 |
| 2024-03-21 19:30:00 | AAPL | Stock | 171.65 | 171.75 | 171.6 | 171.6999 | 49534.0 |
| 2024-03-21 04:00:00 | MSFT | Stock | 428.99 | 428.99 | 428.0 | 428.34 | 2630.0 |
| 2024-03-21 04:30:00 | MSFT | Stock | 428.02 | 428.1 | 427.51 | 427.86 | 2653.0 |
| 2024-03-21 05:00:00 | MSFT | Stock | 427.93 | 428.1 | 427.73 | 428.03 | 2489.0 |
| 2024-03-21 05:30:00 | MSFT | Stock | 427.83 | 428.0 | 427.3 | 428.0 | 1645.0 |
| 2024-03-21 06:00:00 | MSFT | Stock | 427.8 | 428.09 | 427.8 | 428.09 | 408.0 |
| 2024-03-21 06:30:00 | MSFT | Stock | 428.0 | 428.06 | 428.0 | 428.06 | 1188.0 |
| 2024-03-21 07:00:00 | MSFT | Stock | 428.06 | 429.0 | 428.0 | 428.85 | 13749.0 |
| 2024-03-21 07:30:00 | MSFT | Stock | 428.78 | 429.44 | 428.26 | 429.44 | 8316.0 |
| 2024-03-21 08:00:00 | MSFT | Stock | 428.0 | 429.89 | 428.0 | 429.8 | 38492.0 |
| 2024-03-21 08:30:00 | MSFT | Stock | 429.67 | 429.74 | 428.99 | 429.22 | 22510.0 |
| 2024-03-21 09:00:00 | MSFT | Stock | 429.33 | 430.0 | 425.23 | 429.85 | 29059.0 |
| 2024-03-21 09:30:00 | MSFT | Stock | 429.83 | 430.82 | 427.64 | 429.3 | 2127680.0 |
| 2024-03-21 10:00:00 | MSFT | Stock | 429.27 | 429.525 | 427.96 | 428.0 | 841420.0 |
| 2024-03-21 10:30:00 | MSFT | Stock | 428.01 | 429.0399 | 427.16 | 427.96 | 765632.0 |
| 2024-03-21 11:00:00 | MSFT | Stock | 428.0 | 428.6099 | 427.22 | 428.0 | 691316.0 |
| 2024-03-21 11:30:00 | MSFT | Stock | 428.0 | 429.1 | 427.85 | 428.9 | 530781.0 |
| 2024-03-21 12:00:00 | MSFT | Stock | 428.88 | 430.535 | 428.85 | 430.14 | 1172966.0 |
| 2024-03-21 12:30:00 | MSFT | Stock | 430.16 | 430.41 | 429.9 | 430.135 | 512637.0 |
> showing 50 of 102,373 rows — these rows as CSV