PREVIEW / stock_30min / 2022-09-23
file: by_date/stock_30min/2022/2022-09-23.parquet size: 2.2 MB rows: 108,188 symbols: 2,229
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-23 04:00:00 | AAPL | Stock | 152.33 | 152.55 | 151.8 | 151.8 | 13407.0 |
| 2022-09-23 04:30:00 | AAPL | Stock | 151.82 | 152.19 | 151.62 | 151.62 | 14195.0 |
| 2022-09-23 05:00:00 | AAPL | Stock | 151.63 | 151.7 | 151.41 | 151.41 | 19244.0 |
| 2022-09-23 05:30:00 | AAPL | Stock | 151.42 | 151.42 | 150.5 | 150.96 | 22705.0 |
| 2022-09-23 06:00:00 | AAPL | Stock | 151.02 | 151.19 | 150.55 | 150.6 | 22558.0 |
| 2022-09-23 06:30:00 | AAPL | Stock | 150.6 | 150.77 | 150.16 | 150.3 | 34164.0 |
| 2022-09-23 07:00:00 | AAPL | Stock | 150.27 | 150.45 | 150.0 | 150.25 | 103630.0 |
| 2022-09-23 07:30:00 | AAPL | Stock | 150.2 | 150.59 | 150.03 | 150.45 | 94157.0 |
| 2022-09-23 08:00:00 | AAPL | Stock | 150.4891 | 152.18 | 150.0 | 150.2 | 293369.0 |
| 2022-09-23 08:30:00 | AAPL | Stock | 150.2 | 150.29 | 149.85 | 150.16 | 281642.0 |
| 2022-09-23 09:00:00 | AAPL | Stock | 150.12 | 151.23 | 150.0 | 151.19 | 291280.0 |
| 2022-09-23 09:30:00 | AAPL | Stock | 151.19 | 151.47 | 149.8612 | 150.02 | 13799036.0 |
| 2022-09-23 10:00:00 | AAPL | Stock | 150.025 | 150.44 | 149.312 | 150.4399 | 8091347.0 |
| 2022-09-23 10:30:00 | AAPL | Stock | 150.43 | 150.54 | 149.61 | 149.96 | 5289977.0 |
| 2022-09-23 11:00:00 | AAPL | Stock | 149.97 | 150.65 | 149.76 | 150.05 | 4648473.0 |
| 2022-09-23 11:30:00 | AAPL | Stock | 150.055 | 150.55 | 149.79 | 150.26 | 4646595.0 |
| 2022-09-23 12:00:00 | AAPL | Stock | 150.25 | 150.36 | 149.45 | 149.5 | 4111655.0 |
| 2022-09-23 12:30:00 | AAPL | Stock | 149.475 | 150.37 | 149.41 | 150.1699 | 3650836.0 |
| 2022-09-23 13:00:00 | AAPL | Stock | 150.1609 | 150.3187 | 149.67 | 149.6813 | 3146709.0 |
| 2022-09-23 13:30:00 | AAPL | Stock | 149.68 | 149.9 | 149.46 | 149.7099 | 2980056.0 |
| 2022-09-23 14:00:00 | AAPL | Stock | 149.7 | 150.0 | 148.93 | 149.22 | 4535625.0 |
| 2022-09-23 14:30:00 | AAPL | Stock | 149.215 | 149.23 | 148.56 | 148.7 | 4154673.0 |
| 2022-09-23 15:00:00 | AAPL | Stock | 148.68 | 149.88 | 148.67 | 149.77 | 5744773.0 |
| 2022-09-23 15:30:00 | AAPL | Stock | 149.75 | 150.66 | 149.68 | 150.53 | 9833321.0 |
| 2022-09-23 16:00:00 | AAPL | Stock | 150.53 | 150.78 | 150.34 | 150.6494 | 6204139.0 |
| 2022-09-23 16:30:00 | AAPL | Stock | 150.68 | 150.74 | 150.43 | 150.61 | 60301.0 |
| 2022-09-23 17:00:00 | AAPL | Stock | 150.6 | 150.8 | 150.43 | 150.52 | 65910.0 |
| 2022-09-23 17:30:00 | AAPL | Stock | 150.55 | 150.77 | 150.5 | 150.6 | 28415.0 |
| 2022-09-23 18:00:00 | AAPL | Stock | 150.61 | 150.75 | 150.6 | 150.75 | 9042.0 |
| 2022-09-23 18:30:00 | AAPL | Stock | 150.7 | 150.81 | 150.7 | 150.75 | 9988.0 |
| 2022-09-23 19:00:00 | AAPL | Stock | 150.75 | 150.84 | 150.71 | 150.84 | 8581.0 |
| 2022-09-23 19:30:00 | AAPL | Stock | 150.76 | 150.85 | 150.52 | 150.57 | 49569.0 |
| 2022-09-23 04:00:00 | MSFT | Stock | 240.4 | 240.4 | 239.08 | 239.08 | 3824.0 |
| 2022-09-23 04:30:00 | MSFT | Stock | 239.49 | 239.49 | 239.01 | 239.01 | 1040.0 |
| 2022-09-23 05:00:00 | MSFT | Stock | 238.87 | 238.99 | 238.21 | 238.3 | 3872.0 |
| 2022-09-23 05:30:00 | MSFT | Stock | 238.12 | 238.25 | 237.6 | 238.25 | 6840.0 |
| 2022-09-23 06:00:00 | MSFT | Stock | 238.3 | 238.3 | 237.8 | 237.9 | 2530.0 |
| 2022-09-23 06:30:00 | MSFT | Stock | 237.8 | 237.8 | 237.5 | 237.6 | 3761.0 |
| 2022-09-23 07:00:00 | MSFT | Stock | 238.0 | 238.0 | 237.36 | 237.74 | 13876.0 |
| 2022-09-23 07:30:00 | MSFT | Stock | 237.72 | 238.26 | 237.5 | 238.0 | 17865.0 |
| 2022-09-23 08:00:00 | MSFT | Stock | 237.5115 | 240.0 | 237.32 | 238.25 | 44128.0 |
| 2022-09-23 08:30:00 | MSFT | Stock | 238.35 | 238.49 | 237.766 | 238.1015 | 28087.0 |
| 2022-09-23 09:00:00 | MSFT | Stock | 238.25 | 240.0 | 238.25 | 239.55 | 49951.0 |
| 2022-09-23 09:30:00 | MSFT | Stock | 239.51 | 240.43 | 238.24 | 238.79 | 3318749.0 |
| 2022-09-23 10:00:00 | MSFT | Stock | 238.83 | 239.61 | 238.35 | 239.58 | 1967609.0 |
| 2022-09-23 10:30:00 | MSFT | Stock | 239.56 | 241.13 | 238.93 | 240.13 | 1731171.0 |
| 2022-09-23 11:00:00 | MSFT | Stock | 240.13 | 240.8 | 239.32 | 239.45 | 1584260.0 |
| 2022-09-23 11:30:00 | MSFT | Stock | 239.47 | 239.7951 | 238.05 | 238.22 | 1153385.0 |
| 2022-09-23 12:00:00 | MSFT | Stock | 238.21 | 238.47 | 237.5 | 237.62 | 1108269.0 |
| 2022-09-23 12:30:00 | MSFT | Stock | 237.63 | 238.46 | 237.53 | 238.3 | 913715.0 |
> showing 50 of 108,188 rows — these rows as CSV