PREVIEW / stock_30min / 2022-10-10
file: by_date/stock_30min/2022/2022-10-10.parquet size: 2.0 MB rows: 99,123 symbols: 2,134
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-10 04:00:00 | AAPL | Stock | 139.95 | 139.95 | 139.02 | 139.1 | 40356.0 |
| 2022-10-10 04:30:00 | AAPL | Stock | 139.1 | 139.29 | 138.9 | 139.24 | 23860.0 |
| 2022-10-10 05:00:00 | AAPL | Stock | 139.26 | 139.46 | 139.26 | 139.44 | 5405.0 |
| 2022-10-10 05:30:00 | AAPL | Stock | 139.44 | 139.9 | 139.41 | 139.9 | 19149.0 |
| 2022-10-10 06:00:00 | AAPL | Stock | 139.95 | 140.08 | 139.86 | 139.87 | 57221.0 |
| 2022-10-10 06:30:00 | AAPL | Stock | 139.91 | 140.03 | 139.84 | 139.93 | 13449.0 |
| 2022-10-10 07:00:00 | AAPL | Stock | 139.95 | 140.4 | 139.9 | 140.28 | 93913.0 |
| 2022-10-10 07:30:00 | AAPL | Stock | 140.32 | 140.34 | 140.09 | 140.18 | 34733.0 |
| 2022-10-10 08:00:00 | AAPL | Stock | 140.14 | 140.35 | 139.8115 | 140.0 | 95763.0 |
| 2022-10-10 08:30:00 | AAPL | Stock | 140.0 | 140.8 | 139.91 | 140.8 | 112296.0 |
| 2022-10-10 09:00:00 | AAPL | Stock | 140.8 | 140.85 | 140.17 | 140.38 | 191860.0 |
| 2022-10-10 09:30:00 | AAPL | Stock | 140.42 | 140.63 | 138.67 | 138.77 | 9625335.0 |
| 2022-10-10 10:00:00 | AAPL | Stock | 138.79 | 140.46 | 138.5729 | 140.05 | 5750018.0 |
| 2022-10-10 10:30:00 | AAPL | Stock | 140.0433 | 140.25 | 139.1 | 139.5822 | 4487626.0 |
| 2022-10-10 11:00:00 | AAPL | Stock | 139.58 | 140.315 | 139.23 | 140.02 | 4109086.0 |
| 2022-10-10 11:30:00 | AAPL | Stock | 140.02 | 140.82 | 139.92 | 140.46 | 3667574.0 |
| 2022-10-10 12:00:00 | AAPL | Stock | 140.4679 | 140.5195 | 139.65 | 139.7475 | 2713980.0 |
| 2022-10-10 12:30:00 | AAPL | Stock | 139.75 | 140.0 | 139.56 | 139.581 | 2423590.0 |
| 2022-10-10 13:00:00 | AAPL | Stock | 139.57 | 140.03 | 139.055 | 139.95 | 3427753.0 |
| 2022-10-10 13:30:00 | AAPL | Stock | 139.95 | 141.89 | 139.92 | 141.2699 | 5268110.0 |
| 2022-10-10 14:00:00 | AAPL | Stock | 141.27 | 141.34 | 140.4194 | 140.91 | 3626319.0 |
| 2022-10-10 14:30:00 | AAPL | Stock | 140.905 | 141.3992 | 140.545 | 140.79 | 3317465.0 |
| 2022-10-10 15:00:00 | AAPL | Stock | 140.79 | 141.51 | 140.6 | 141.065 | 3831567.0 |
| 2022-10-10 15:30:00 | AAPL | Stock | 141.08 | 141.54 | 140.12 | 140.35 | 6562807.0 |
| 2022-10-10 16:00:00 | AAPL | Stock | 140.36 | 140.66 | 140.26 | 140.45 | 6110948.0 |
| 2022-10-10 16:30:00 | AAPL | Stock | 140.45 | 140.58 | 140.42 | 140.5 | 51768.0 |
| 2022-10-10 17:00:00 | AAPL | Stock | 140.47 | 140.54 | 140.35 | 140.37 | 9403.0 |
| 2022-10-10 17:30:00 | AAPL | Stock | 140.44 | 140.47 | 140.41 | 140.43 | 7101.0 |
| 2022-10-10 18:00:00 | AAPL | Stock | 140.47 | 140.63 | 140.45 | 140.63 | 8824.0 |
| 2022-10-10 18:30:00 | AAPL | Stock | 140.63 | 140.97 | 140.55 | 140.86 | 13083.0 |
| 2022-10-10 19:00:00 | AAPL | Stock | 140.86 | 141.2 | 140.85 | 140.98 | 21789.0 |
| 2022-10-10 19:30:00 | AAPL | Stock | 141.05 | 141.07 | 140.75 | 140.92 | 13379.0 |
| 2022-10-10 04:00:00 | MSFT | Stock | 233.31 | 233.31 | 232.22 | 232.4 | 5059.0 |
| 2022-10-10 04:30:00 | MSFT | Stock | 232.3 | 232.5 | 232.08 | 232.5 | 1626.0 |
| 2022-10-10 05:00:00 | MSFT | Stock | 232.68 | 233.2 | 232.68 | 233.2 | 400.0 |
| 2022-10-10 05:30:00 | MSFT | Stock | 233.8 | 234.0 | 233.8 | 234.0 | 430.0 |
| 2022-10-10 06:00:00 | MSFT | Stock | 233.5 | 233.6 | 233.22 | 233.22 | 533.0 |
| 2022-10-10 06:30:00 | MSFT | Stock | 233.24 | 233.26 | 233.2 | 233.2 | 1477.0 |
| 2022-10-10 07:00:00 | MSFT | Stock | 233.23 | 233.74 | 233.23 | 233.74 | 2154.0 |
| 2022-10-10 07:30:00 | MSFT | Stock | 233.59 | 233.66 | 233.4 | 233.56 | 5832.0 |
| 2022-10-10 08:00:00 | MSFT | Stock | 233.3612 | 233.88 | 232.71 | 233.05 | 39149.0 |
| 2022-10-10 08:30:00 | MSFT | Stock | 233.05 | 233.72 | 233.0 | 233.62 | 44574.0 |
| 2022-10-10 09:00:00 | MSFT | Stock | 233.71 | 233.75 | 232.66 | 232.92 | 56644.0 |
| 2022-10-10 09:30:00 | MSFT | Stock | 233.05 | 234.559 | 230.5999 | 230.97 | 3081445.0 |
| 2022-10-10 10:00:00 | MSFT | Stock | 230.99 | 231.6 | 229.85 | 230.83 | 1802426.0 |
| 2022-10-10 10:30:00 | MSFT | Stock | 230.8308 | 231.24 | 228.36 | 229.03 | 1855033.0 |
| 2022-10-10 11:00:00 | MSFT | Stock | 229.02 | 229.97 | 228.44 | 229.43 | 1216251.0 |
| 2022-10-10 11:30:00 | MSFT | Stock | 229.44 | 230.32 | 229.11 | 229.2 | 1063902.0 |
| 2022-10-10 12:00:00 | MSFT | Stock | 229.2 | 229.2183 | 227.77 | 227.9107 | 1367259.0 |
| 2022-10-10 12:30:00 | MSFT | Stock | 227.87 | 228.25 | 227.41 | 227.42 | 779415.0 |
> showing 50 of 99,123 rows — these rows as CSV