PREVIEW / stock_30min / 2022-10-25
file: by_date/stock_30min/2022/2022-10-25.parquet size: 2.1 MB rows: 103,248 symbols: 2,164
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-10-25 04:00:00 | AAPL | Stock | 149.5 | 150.17 | 149.5 | 149.85 | 14292.0 |
| 2022-10-25 04:30:00 | AAPL | Stock | 149.9 | 150.09 | 149.79 | 149.8 | 9752.0 |
| 2022-10-25 05:00:00 | AAPL | Stock | 149.81 | 149.81 | 149.55 | 149.55 | 8150.0 |
| 2022-10-25 05:30:00 | AAPL | Stock | 149.41 | 149.62 | 149.31 | 149.61 | 4346.0 |
| 2022-10-25 06:00:00 | AAPL | Stock | 149.53 | 149.53 | 149.18 | 149.3 | 22325.0 |
| 2022-10-25 06:30:00 | AAPL | Stock | 149.27 | 149.28 | 148.9 | 149.2 | 46701.0 |
| 2022-10-25 07:00:00 | AAPL | Stock | 149.31 | 149.34 | 148.76 | 149.04 | 100393.0 |
| 2022-10-25 07:30:00 | AAPL | Stock | 149.05 | 149.05 | 148.79 | 148.82 | 50113.0 |
| 2022-10-25 08:00:00 | AAPL | Stock | 148.8501 | 149.84 | 148.62 | 149.0 | 120952.0 |
| 2022-10-25 08:30:00 | AAPL | Stock | 149.0 | 149.25 | 148.5 | 149.25 | 51397.0 |
| 2022-10-25 09:00:00 | AAPL | Stock | 149.21 | 150.29 | 149.21 | 150.16 | 253002.0 |
| 2022-10-25 09:30:00 | AAPL | Stock | 150.16 | 151.43 | 149.36 | 151.3163 | 10668007.0 |
| 2022-10-25 10:00:00 | AAPL | Stock | 151.35 | 151.49 | 150.64 | 151.15 | 6119906.0 |
| 2022-10-25 10:30:00 | AAPL | Stock | 151.155 | 151.3 | 150.775 | 150.925 | 4246728.0 |
| 2022-10-25 11:00:00 | AAPL | Stock | 150.9201 | 151.63 | 150.8 | 151.585 | 3948685.0 |
| 2022-10-25 11:30:00 | AAPL | Stock | 151.581 | 151.88 | 151.46 | 151.675 | 3437170.0 |
| 2022-10-25 12:00:00 | AAPL | Stock | 151.685 | 151.875 | 151.51 | 151.8 | 2698975.0 |
| 2022-10-25 12:30:00 | AAPL | Stock | 151.79 | 151.84 | 151.47 | 151.555 | 2364062.0 |
| 2022-10-25 13:00:00 | AAPL | Stock | 151.555 | 151.75 | 151.15 | 151.495 | 2758216.0 |
| 2022-10-25 13:30:00 | AAPL | Stock | 151.49 | 151.75 | 151.155 | 151.44 | 2543457.0 |
| 2022-10-25 14:00:00 | AAPL | Stock | 151.43 | 152.05 | 151.41 | 152.045 | 3279649.0 |
| 2022-10-25 14:30:00 | AAPL | Stock | 152.05 | 152.22 | 151.76 | 151.78 | 2405831.0 |
| 2022-10-25 15:00:00 | AAPL | Stock | 151.79 | 152.3 | 151.78 | 152.2687 | 3680868.0 |
| 2022-10-25 15:30:00 | AAPL | Stock | 152.265 | 152.49 | 152.02 | 152.39 | 6872809.0 |
| 2022-10-25 16:00:00 | AAPL | Stock | 152.38 | 152.5 | 150.2 | 151.15 | 9028873.0 |
| 2022-10-25 16:30:00 | AAPL | Stock | 151.0 | 152.34 | 150.8 | 151.17 | 267708.0 |
| 2022-10-25 17:00:00 | AAPL | Stock | 151.17 | 152.34 | 150.59 | 150.6 | 130388.0 |
| 2022-10-25 17:30:00 | AAPL | Stock | 150.6 | 150.89 | 150.35 | 150.5 | 124203.0 |
| 2022-10-25 18:00:00 | AAPL | Stock | 150.5 | 151.45 | 150.42 | 150.97 | 286331.0 |
| 2022-10-25 18:30:00 | AAPL | Stock | 150.96 | 151.08 | 150.72 | 150.85 | 78307.0 |
| 2022-10-25 19:00:00 | AAPL | Stock | 150.82 | 150.85 | 150.4 | 150.5 | 80690.0 |
| 2022-10-25 19:30:00 | AAPL | Stock | 150.46 | 150.95 | 150.41 | 150.9 | 49999.0 |
| 2022-10-25 04:00:00 | MSFT | Stock | 247.36 | 247.87 | 247.36 | 247.55 | 1200.0 |
| 2022-10-25 04:30:00 | MSFT | Stock | 247.56 | 247.7 | 247.0 | 247.5 | 4387.0 |
| 2022-10-25 05:00:00 | MSFT | Stock | 247.49 | 247.49 | 247.0 | 247.39 | 1002.0 |
| 2022-10-25 05:30:00 | MSFT | Stock | 247.35 | 247.35 | 246.7 | 246.7 | 2897.0 |
| 2022-10-25 06:00:00 | MSFT | Stock | 246.79 | 246.86 | 246.79 | 246.86 | 202.0 |
| 2022-10-25 06:30:00 | MSFT | Stock | 246.81 | 247.5 | 246.81 | 247.5 | 1420.0 |
| 2022-10-25 07:00:00 | MSFT | Stock | 247.7 | 248.0 | 247.3 | 248.0 | 7900.0 |
| 2022-10-25 07:30:00 | MSFT | Stock | 248.0 | 248.09 | 247.51 | 247.51 | 24071.0 |
| 2022-10-25 08:00:00 | MSFT | Stock | 247.4467 | 248.1975 | 247.02 | 247.8 | 34708.0 |
| 2022-10-25 08:30:00 | MSFT | Stock | 247.79 | 247.88 | 247.38 | 247.77 | 17351.0 |
| 2022-10-25 09:00:00 | MSFT | Stock | 247.8 | 248.6 | 246.6 | 247.32 | 71725.0 |
| 2022-10-25 09:30:00 | MSFT | Stock | 247.47 | 249.79 | 245.83 | 249.465 | 3593088.0 |
| 2022-10-25 10:00:00 | MSFT | Stock | 249.49 | 249.7 | 248.25 | 248.76 | 1338840.0 |
| 2022-10-25 10:30:00 | MSFT | Stock | 248.765 | 249.59 | 247.74 | 248.59 | 1318762.0 |
| 2022-10-25 11:00:00 | MSFT | Stock | 248.63 | 249.71 | 248.32 | 249.6541 | 1075979.0 |
| 2022-10-25 11:30:00 | MSFT | Stock | 249.63 | 250.0 | 249.385 | 249.75 | 1220405.0 |
| 2022-10-25 12:00:00 | MSFT | Stock | 249.78 | 249.92 | 249.41 | 249.89 | 840025.0 |
| 2022-10-25 12:30:00 | MSFT | Stock | 249.89 | 249.9523 | 248.7814 | 248.88 | 877263.0 |
> showing 50 of 103,248 rows — these rows as CSV