PREVIEW / stock_30min / 2023-02-10
file: by_date/stock_30min/2023/2023-02-10.parquet size: 2.1 MB rows: 102,105 symbols: 1,858
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-02-10 04:00:00 | AAPL | Stock | 150.4 | 150.75 | 149.78 | 149.91 | 19128.0 |
| 2023-02-10 04:30:00 | AAPL | Stock | 149.9 | 149.95 | 149.34 | 149.34 | 13283.0 |
| 2023-02-10 05:00:00 | AAPL | Stock | 149.39 | 149.48 | 149.0 | 149.07 | 14937.0 |
| 2023-02-10 05:30:00 | AAPL | Stock | 149.19 | 149.37 | 149.09 | 149.37 | 10186.0 |
| 2023-02-10 06:00:00 | AAPL | Stock | 149.25 | 149.25 | 148.8 | 148.84 | 15677.0 |
| 2023-02-10 06:30:00 | AAPL | Stock | 148.81 | 148.89 | 148.7 | 148.73 | 16888.0 |
| 2023-02-10 07:00:00 | AAPL | Stock | 148.86 | 149.07 | 148.75 | 149.07 | 63517.0 |
| 2023-02-10 07:30:00 | AAPL | Stock | 149.01 | 149.09 | 148.9 | 148.93 | 25838.0 |
| 2023-02-10 08:00:00 | AAPL | Stock | 148.8588 | 150.3 | 148.73 | 149.36 | 174385.0 |
| 2023-02-10 08:30:00 | AAPL | Stock | 149.37 | 149.72 | 149.25 | 149.46 | 64825.0 |
| 2023-02-10 09:00:00 | AAPL | Stock | 149.44 | 149.54 | 149.1 | 149.42 | 65346.0 |
| 2023-02-10 09:30:00 | AAPL | Stock | 149.49 | 150.56 | 149.22 | 149.93 | 6080493.0 |
| 2023-02-10 10:00:00 | AAPL | Stock | 149.935 | 151.3401 | 149.35 | 150.78 | 4747929.0 |
| 2023-02-10 10:30:00 | AAPL | Stock | 150.78 | 150.91 | 150.0 | 150.37 | 3371693.0 |
| 2023-02-10 11:00:00 | AAPL | Stock | 150.35 | 150.91 | 150.17 | 150.2854 | 2310967.0 |
| 2023-02-10 11:30:00 | AAPL | Stock | 150.3 | 150.3499 | 149.7 | 149.82 | 1912798.0 |
| 2023-02-10 12:00:00 | AAPL | Stock | 149.81 | 149.9 | 149.43 | 149.763 | 2041771.0 |
| 2023-02-10 12:30:00 | AAPL | Stock | 149.76 | 150.19 | 149.7 | 150.155 | 1814159.0 |
| 2023-02-10 13:00:00 | AAPL | Stock | 150.155 | 151.115 | 150.0699 | 150.76 | 2516192.0 |
| 2023-02-10 13:30:00 | AAPL | Stock | 150.77 | 150.8224 | 150.38 | 150.46 | 1871012.0 |
| 2023-02-10 14:00:00 | AAPL | Stock | 150.465 | 150.59 | 150.23 | 150.235 | 1779655.0 |
| 2023-02-10 14:30:00 | AAPL | Stock | 150.24 | 150.6501 | 150.0101 | 150.65 | 2134233.0 |
| 2023-02-10 15:00:00 | AAPL | Stock | 150.66 | 150.82 | 150.29 | 150.47 | 2334331.0 |
| 2023-02-10 15:30:00 | AAPL | Stock | 150.47 | 151.155 | 150.46 | 151.02 | 4793566.0 |
| 2023-02-10 16:00:00 | AAPL | Stock | 151.01 | 151.05 | 150.91 | 151.0 | 6562799.0 |
| 2023-02-10 16:30:00 | AAPL | Stock | 151.0 | 151.01 | 150.91 | 150.92 | 22192.0 |
| 2023-02-10 17:00:00 | AAPL | Stock | 150.93 | 151.01 | 150.91 | 150.91 | 14050.0 |
| 2023-02-10 17:30:00 | AAPL | Stock | 150.91 | 151.0 | 150.91 | 150.99 | 28189.0 |
| 2023-02-10 18:00:00 | AAPL | Stock | 150.96 | 151.0 | 150.96 | 150.99 | 7979.0 |
| 2023-02-10 18:30:00 | AAPL | Stock | 150.99 | 151.02 | 150.99 | 151.02 | 5650.0 |
| 2023-02-10 19:00:00 | AAPL | Stock | 151.0 | 151.05 | 150.97 | 151.04 | 6320.0 |
| 2023-02-10 19:30:00 | AAPL | Stock | 151.03 | 151.26 | 151.01 | 151.26 | 14491.0 |
| 2023-02-10 04:00:00 | MSFT | Stock | 265.08 | 265.08 | 263.02 | 263.02 | 11473.0 |
| 2023-02-10 04:30:00 | MSFT | Stock | 263.0 | 263.0 | 260.53 | 260.54 | 12738.0 |
| 2023-02-10 05:00:00 | MSFT | Stock | 260.62 | 261.07 | 260.08 | 260.08 | 17286.0 |
| 2023-02-10 05:30:00 | MSFT | Stock | 260.41 | 260.41 | 259.86 | 260.37 | 37075.0 |
| 2023-02-10 06:00:00 | MSFT | Stock | 260.28 | 260.28 | 258.8 | 259.1 | 7142.0 |
| 2023-02-10 06:30:00 | MSFT | Stock | 259.5 | 259.68 | 259.02 | 259.3 | 10773.0 |
| 2023-02-10 07:00:00 | MSFT | Stock | 259.68 | 260.5 | 259.55 | 260.5 | 23344.0 |
| 2023-02-10 07:30:00 | MSFT | Stock | 260.44 | 260.54 | 260.06 | 260.36 | 5662.0 |
| 2023-02-10 08:00:00 | MSFT | Stock | 260.01 | 263.63 | 259.56 | 260.8 | 39995.0 |
| 2023-02-10 08:30:00 | MSFT | Stock | 260.8 | 261.31 | 260.5755 | 260.85 | 23872.0 |
| 2023-02-10 09:00:00 | MSFT | Stock | 260.85 | 262.45 | 260.55 | 261.55 | 25560.0 |
| 2023-02-10 09:30:00 | MSFT | Stock | 261.54 | 263.3 | 260.96 | 262.2351 | 2554980.0 |
| 2023-02-10 10:00:00 | MSFT | Stock | 262.17 | 264.09 | 261.18 | 262.94 | 1857091.0 |
| 2023-02-10 10:30:00 | MSFT | Stock | 262.935 | 263.3594 | 261.46 | 262.42 | 1318233.0 |
| 2023-02-10 11:00:00 | MSFT | Stock | 262.42 | 263.28 | 261.88 | 262.4998 | 926812.0 |
| 2023-02-10 11:30:00 | MSFT | Stock | 262.51 | 262.64 | 261.15 | 261.35 | 780057.0 |
| 2023-02-10 12:00:00 | MSFT | Stock | 261.36 | 261.58 | 260.662 | 261.2984 | 956031.0 |
| 2023-02-10 12:30:00 | MSFT | Stock | 261.28 | 261.674 | 260.8541 | 261.6699 | 670447.0 |
> showing 50 of 102,105 rows — these rows as CSV