PREVIEW / stock_30min / 2022-06-16
file: by_date/stock_30min/2022/2022-06-16.parquet size: 2.2 MB rows: 109,348 symbols: 2,415
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-06-16 04:00:00 | AAPL | Stock | 133.0 | 133.0 | 132.07 | 132.51 | 83119.0 |
| 2022-06-16 04:30:00 | AAPL | Stock | 132.44 | 132.44 | 131.51 | 131.67 | 39210.0 |
| 2022-06-16 05:00:00 | AAPL | Stock | 131.53 | 131.83 | 131.2 | 131.83 | 27629.0 |
| 2022-06-16 05:30:00 | AAPL | Stock | 131.64 | 131.78 | 131.32 | 131.73 | 15096.0 |
| 2022-06-16 06:00:00 | AAPL | Stock | 131.69 | 131.91 | 131.48 | 131.5 | 19214.0 |
| 2022-06-16 06:30:00 | AAPL | Stock | 131.5 | 131.79 | 131.25 | 131.63 | 36572.0 |
| 2022-06-16 07:00:00 | AAPL | Stock | 131.63 | 132.28 | 131.63 | 132.09 | 131782.0 |
| 2022-06-16 07:30:00 | AAPL | Stock | 132.11 | 132.34 | 131.65 | 132.3 | 116170.0 |
| 2022-06-16 08:00:00 | AAPL | Stock | 131.8399 | 134.75 | 131.65 | 132.89 | 684136.0 |
| 2022-06-16 08:30:00 | AAPL | Stock | 132.75 | 133.48 | 132.51 | 132.63 | 360248.0 |
| 2022-06-16 09:00:00 | AAPL | Stock | 132.63 | 132.68 | 131.8 | 132.08 | 570704.0 |
| 2022-06-16 09:30:00 | AAPL | Stock | 132.08 | 132.39 | 130.5 | 131.21 | 11486106.0 |
| 2022-06-16 10:00:00 | AAPL | Stock | 131.21 | 131.44 | 130.7 | 131.16 | 6266335.0 |
| 2022-06-16 10:30:00 | AAPL | Stock | 131.16 | 131.37 | 129.89 | 130.1281 | 6937273.0 |
| 2022-06-16 11:00:00 | AAPL | Stock | 130.1285 | 131.16 | 130.09 | 130.91 | 4744437.0 |
| 2022-06-16 11:30:00 | AAPL | Stock | 130.9 | 130.9699 | 130.25 | 130.89 | 3558615.0 |
| 2022-06-16 12:00:00 | AAPL | Stock | 130.89 | 131.08 | 130.195 | 131.01 | 3963510.0 |
| 2022-06-16 12:30:00 | AAPL | Stock | 131.01 | 131.186 | 130.67 | 131.04 | 3537045.0 |
| 2022-06-16 13:00:00 | AAPL | Stock | 131.03 | 131.53 | 130.745 | 131.255 | 3962787.0 |
| 2022-06-16 13:30:00 | AAPL | Stock | 131.26 | 131.52 | 130.01 | 130.02 | 4000543.0 |
| 2022-06-16 14:00:00 | AAPL | Stock | 130.01 | 130.2 | 129.67 | 129.685 | 4746299.0 |
| 2022-06-16 14:30:00 | AAPL | Stock | 129.68 | 130.205 | 129.29 | 129.55 | 4493453.0 |
| 2022-06-16 15:00:00 | AAPL | Stock | 129.54 | 130.3 | 129.47 | 130.115 | 6207256.0 |
| 2022-06-16 15:30:00 | AAPL | Stock | 130.115 | 130.28 | 129.04 | 130.1 | 11507660.0 |
| 2022-06-16 16:00:00 | AAPL | Stock | 130.11 | 131.195 | 130.05 | 130.37 | 13817733.0 |
| 2022-06-16 16:30:00 | AAPL | Stock | 130.39 | 130.58 | 130.06 | 130.55 | 146581.0 |
| 2022-06-16 17:00:00 | AAPL | Stock | 130.5 | 130.53 | 130.36 | 130.47 | 34624.0 |
| 2022-06-16 17:30:00 | AAPL | Stock | 130.46 | 130.48 | 130.33 | 130.48 | 28126.0 |
| 2022-06-16 18:00:00 | AAPL | Stock | 130.48 | 130.8 | 130.4 | 130.55 | 62597.0 |
| 2022-06-16 18:30:00 | AAPL | Stock | 130.55 | 130.57 | 130.46 | 130.46 | 28645.0 |
| 2022-06-16 19:00:00 | AAPL | Stock | 130.45 | 130.5 | 130.2 | 130.26 | 35322.0 |
| 2022-06-16 19:30:00 | AAPL | Stock | 130.25 | 130.6 | 130.25 | 130.53 | 33765.0 |
| 2022-06-16 04:00:00 | MSFT | Stock | 251.97 | 251.97 | 245.5 | 245.7 | 9636.0 |
| 2022-06-16 04:30:00 | MSFT | Stock | 245.71 | 245.84 | 244.84 | 244.84 | 7942.0 |
| 2022-06-16 05:00:00 | MSFT | Stock | 244.53 | 244.53 | 243.5 | 243.75 | 8652.0 |
| 2022-06-16 05:30:00 | MSFT | Stock | 244.2 | 244.75 | 243.83 | 244.75 | 1724.0 |
| 2022-06-16 06:00:00 | MSFT | Stock | 244.62 | 245.35 | 244.15 | 244.15 | 2834.0 |
| 2022-06-16 06:30:00 | MSFT | Stock | 244.17 | 244.83 | 244.15 | 244.59 | 3490.0 |
| 2022-06-16 07:00:00 | MSFT | Stock | 244.76 | 246.18 | 244.44 | 245.4 | 19460.0 |
| 2022-06-16 07:30:00 | MSFT | Stock | 245.24 | 245.77 | 244.41 | 245.1 | 26735.0 |
| 2022-06-16 08:00:00 | MSFT | Stock | 244.5 | 251.131 | 244.44 | 247.3 | 56941.0 |
| 2022-06-16 08:30:00 | MSFT | Stock | 246.96 | 248.0 | 246.5001 | 246.53 | 57415.0 |
| 2022-06-16 09:00:00 | MSFT | Stock | 246.54 | 246.9 | 246.0 | 246.0 | 24688.0 |
| 2022-06-16 09:30:00 | MSFT | Stock | 246.08 | 247.4174 | 244.9 | 246.67 | 2526542.0 |
| 2022-06-16 10:00:00 | MSFT | Stock | 246.6818 | 246.6818 | 244.71 | 245.51 | 1308096.0 |
| 2022-06-16 10:30:00 | MSFT | Stock | 245.5 | 245.7 | 243.57 | 244.23 | 1262879.0 |
| 2022-06-16 11:00:00 | MSFT | Stock | 244.19 | 246.2 | 244.18 | 245.58 | 1176447.0 |
| 2022-06-16 11:30:00 | MSFT | Stock | 245.6159 | 245.645 | 244.3 | 245.3479 | 883568.0 |
| 2022-06-16 12:00:00 | MSFT | Stock | 245.35 | 245.4 | 244.14 | 244.98 | 737130.0 |
| 2022-06-16 12:30:00 | MSFT | Stock | 245.01 | 245.38 | 244.4 | 245.24 | 895001.0 |
> showing 50 of 109,348 rows — these rows as CSV