PREVIEW / stock_30min / 2022-11-04
file: by_date/stock_30min/2022/2022-11-04.parquet size: 2.1 MB rows: 102,576 symbols: 2,099
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-11-04 04:00:00 | AAPL | Stock | 138.01 | 138.88 | 138.01 | 138.61 | 36843.0 |
| 2022-11-04 04:30:00 | AAPL | Stock | 138.6 | 139.0 | 138.46 | 139.0 | 14564.0 |
| 2022-11-04 05:00:00 | AAPL | Stock | 138.98 | 139.8 | 138.98 | 139.55 | 31824.0 |
| 2022-11-04 05:30:00 | AAPL | Stock | 139.5 | 139.62 | 139.4 | 139.47 | 31118.0 |
| 2022-11-04 06:00:00 | AAPL | Stock | 139.52 | 139.68 | 139.4 | 139.46 | 28820.0 |
| 2022-11-04 06:30:00 | AAPL | Stock | 139.5 | 139.95 | 139.5 | 139.87 | 32595.0 |
| 2022-11-04 07:00:00 | AAPL | Stock | 139.84 | 140.38 | 139.7 | 140.06 | 99552.0 |
| 2022-11-04 07:30:00 | AAPL | Stock | 140.1 | 140.43 | 139.9 | 140.27 | 64373.0 |
| 2022-11-04 08:00:00 | AAPL | Stock | 139.77 | 140.43 | 138.53 | 140.12 | 356736.0 |
| 2022-11-04 08:30:00 | AAPL | Stock | 140.12 | 141.74 | 139.1 | 141.67 | 1011865.0 |
| 2022-11-04 09:00:00 | AAPL | Stock | 141.72 | 142.55 | 141.65 | 142.09 | 780237.0 |
| 2022-11-04 09:30:00 | AAPL | Stock | 142.09 | 142.67 | 136.56 | 138.9159 | 18685656.0 |
| 2022-11-04 10:00:00 | AAPL | Stock | 138.92 | 140.18 | 138.43 | 139.5501 | 10933041.0 |
| 2022-11-04 10:30:00 | AAPL | Stock | 139.55 | 139.73 | 137.77 | 138.19 | 8095564.0 |
| 2022-11-04 11:00:00 | AAPL | Stock | 138.2 | 138.3 | 136.4 | 136.5502 | 9995821.0 |
| 2022-11-04 11:30:00 | AAPL | Stock | 136.56 | 136.82 | 134.9 | 135.03 | 9294075.0 |
| 2022-11-04 12:00:00 | AAPL | Stock | 135.04 | 136.5599 | 134.55 | 136.3057 | 8794115.0 |
| 2022-11-04 12:30:00 | AAPL | Stock | 136.3 | 136.41 | 134.49 | 134.8004 | 6139345.0 |
| 2022-11-04 13:00:00 | AAPL | Stock | 134.81 | 135.65 | 134.45 | 134.8599 | 5459114.0 |
| 2022-11-04 13:30:00 | AAPL | Stock | 134.85 | 135.16 | 134.7 | 134.88 | 3245975.0 |
| 2022-11-04 14:00:00 | AAPL | Stock | 134.87 | 135.73 | 134.38 | 135.37 | 4579062.0 |
| 2022-11-04 14:30:00 | AAPL | Stock | 135.38 | 136.88 | 135.2096 | 136.76 | 6614402.0 |
| 2022-11-04 15:00:00 | AAPL | Stock | 136.77 | 137.82 | 136.62 | 137.28 | 7853661.0 |
| 2022-11-04 15:30:00 | AAPL | Stock | 137.285 | 138.5 | 136.9 | 138.39 | 10717497.0 |
| 2022-11-04 16:00:00 | AAPL | Stock | 138.39 | 138.62 | 138.12 | 138.31 | 10512779.0 |
| 2022-11-04 16:30:00 | AAPL | Stock | 138.32 | 138.4 | 138.13 | 138.24 | 258585.0 |
| 2022-11-04 17:00:00 | AAPL | Stock | 138.2 | 138.3 | 138.07 | 138.2 | 58449.0 |
| 2022-11-04 17:30:00 | AAPL | Stock | 138.19 | 138.27 | 138.08 | 138.2138 | 37651.0 |
| 2022-11-04 18:00:00 | AAPL | Stock | 138.19 | 138.24 | 138.13 | 138.21 | 14109.0 |
| 2022-11-04 18:30:00 | AAPL | Stock | 138.18 | 138.24 | 138.17 | 138.23 | 16176.0 |
| 2022-11-04 19:00:00 | AAPL | Stock | 138.22 | 138.22 | 138.12 | 138.13 | 22399.0 |
| 2022-11-04 19:30:00 | AAPL | Stock | 138.17 | 138.18 | 138.07 | 138.12 | 28608.0 |
| 2022-11-04 04:00:00 | MSFT | Stock | 214.81 | 215.3 | 214.81 | 214.85 | 2408.0 |
| 2022-11-04 04:30:00 | MSFT | Stock | 214.85 | 215.3 | 214.7 | 215.3 | 2067.0 |
| 2022-11-04 05:00:00 | MSFT | Stock | 215.31 | 215.99 | 215.31 | 215.79 | 4261.0 |
| 2022-11-04 05:30:00 | MSFT | Stock | 215.8 | 215.8 | 215.5 | 215.57 | 971.0 |
| 2022-11-04 06:00:00 | MSFT | Stock | 215.72 | 215.84 | 215.23 | 215.51 | 3896.0 |
| 2022-11-04 06:30:00 | MSFT | Stock | 215.75 | 216.05 | 215.75 | 215.76 | 3395.0 |
| 2022-11-04 07:00:00 | MSFT | Stock | 215.71 | 215.95 | 215.12 | 215.2 | 13870.0 |
| 2022-11-04 07:30:00 | MSFT | Stock | 215.25 | 215.42 | 215.17 | 215.35 | 7740.0 |
| 2022-11-04 08:00:00 | MSFT | Stock | 215.385 | 215.72 | 214.54 | 214.8 | 44675.0 |
| 2022-11-04 08:30:00 | MSFT | Stock | 215.1 | 216.25 | 212.25 | 216.25 | 163437.0 |
| 2022-11-04 09:00:00 | MSFT | Stock | 216.25 | 217.54 | 216.15 | 217.5 | 107474.0 |
| 2022-11-04 09:30:00 | MSFT | Stock | 217.59 | 218.48 | 213.431 | 216.39 | 3874693.0 |
| 2022-11-04 10:00:00 | MSFT | Stock | 216.42 | 219.18 | 215.56 | 218.555 | 2293009.0 |
| 2022-11-04 10:30:00 | MSFT | Stock | 218.57 | 219.98 | 218.0377 | 218.56 | 1780579.0 |
| 2022-11-04 11:00:00 | MSFT | Stock | 218.57 | 218.9 | 215.96 | 216.075 | 1561229.0 |
| 2022-11-04 11:30:00 | MSFT | Stock | 216.07 | 216.69 | 215.475 | 215.73 | 1469880.0 |
| 2022-11-04 12:00:00 | MSFT | Stock | 215.69 | 218.56 | 215.105 | 218.305 | 1552389.0 |
| 2022-11-04 12:30:00 | MSFT | Stock | 218.31 | 218.61 | 216.97 | 217.58 | 1150662.0 |
> showing 50 of 102,576 rows — these rows as CSV