PREVIEW / stock_30min / 2022-12-08
file: by_date/stock_30min/2022/2022-12-08.parquet size: 2.1 MB rows: 101,581 symbols: 2,060
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-12-08 04:00:00 | AAPL | Stock | 141.46 | 141.52 | 141.02 | 141.36 | 7309.0 |
| 2022-12-08 04:30:00 | AAPL | Stock | 141.42 | 141.58 | 141.35 | 141.41 | 6406.0 |
| 2022-12-08 05:00:00 | AAPL | Stock | 141.41 | 141.5 | 141.24 | 141.4 | 6867.0 |
| 2022-12-08 05:30:00 | AAPL | Stock | 141.38 | 141.38 | 141.22 | 141.3 | 6499.0 |
| 2022-12-08 06:00:00 | AAPL | Stock | 141.24 | 141.39 | 141.11 | 141.34 | 5048.0 |
| 2022-12-08 06:30:00 | AAPL | Stock | 141.34 | 141.64 | 141.34 | 141.61 | 7290.0 |
| 2022-12-08 07:00:00 | AAPL | Stock | 141.5 | 141.6 | 141.39 | 141.55 | 25538.0 |
| 2022-12-08 07:30:00 | AAPL | Stock | 141.54 | 142.21 | 141.5 | 142.05 | 62039.0 |
| 2022-12-08 08:00:00 | AAPL | Stock | 141.34 | 142.33 | 140.5 | 142.31 | 104973.0 |
| 2022-12-08 08:30:00 | AAPL | Stock | 142.3 | 142.75 | 142.26 | 142.57 | 193222.0 |
| 2022-12-08 09:00:00 | AAPL | Stock | 142.58 | 142.78 | 142.0521 | 142.4 | 166129.0 |
| 2022-12-08 09:30:00 | AAPL | Stock | 142.4 | 142.6675 | 141.1 | 142.46 | 6657134.0 |
| 2022-12-08 10:00:00 | AAPL | Stock | 142.47 | 143.36 | 142.17 | 143.15 | 4865207.0 |
| 2022-12-08 10:30:00 | AAPL | Stock | 143.155 | 143.52 | 142.79 | 142.99 | 3783307.0 |
| 2022-12-08 11:00:00 | AAPL | Stock | 143.01 | 143.24 | 142.15 | 142.695 | 3660943.0 |
| 2022-12-08 11:30:00 | AAPL | Stock | 142.69 | 143.08 | 142.5299 | 142.8041 | 2407334.0 |
| 2022-12-08 12:00:00 | AAPL | Stock | 142.8026 | 143.05 | 142.04 | 142.11 | 2508370.0 |
| 2022-12-08 12:30:00 | AAPL | Stock | 142.1 | 142.51 | 141.88 | 142.43 | 2078378.0 |
| 2022-12-08 13:00:00 | AAPL | Stock | 142.425 | 142.77 | 142.19 | 142.76 | 1801539.0 |
| 2022-12-08 13:30:00 | AAPL | Stock | 142.765 | 143.27 | 142.6 | 142.6101 | 2393184.0 |
| 2022-12-08 14:00:00 | AAPL | Stock | 142.6145 | 142.63 | 141.55 | 142.015 | 3334866.0 |
| 2022-12-08 14:30:00 | AAPL | Stock | 142.015 | 142.73 | 141.82 | 142.42 | 2785888.0 |
| 2022-12-08 15:00:00 | AAPL | Stock | 142.42 | 142.94 | 142.1801 | 142.8501 | 2957073.0 |
| 2022-12-08 15:30:00 | AAPL | Stock | 142.855 | 142.9999 | 142.07 | 142.67 | 5036257.0 |
| 2022-12-08 16:00:00 | AAPL | Stock | 142.66 | 143.02 | 142.52 | 143.01 | 8780225.0 |
| 2022-12-08 16:30:00 | AAPL | Stock | 142.99 | 142.99 | 142.65 | 142.71 | 65211.0 |
| 2022-12-08 17:00:00 | AAPL | Stock | 142.7 | 142.75 | 142.67 | 142.67 | 3576.0 |
| 2022-12-08 17:30:00 | AAPL | Stock | 142.67 | 142.79 | 142.6 | 142.68 | 10453.0 |
| 2022-12-08 18:00:00 | AAPL | Stock | 142.7 | 142.9 | 142.7 | 142.78 | 23130.0 |
| 2022-12-08 18:30:00 | AAPL | Stock | 142.78 | 142.78 | 142.62 | 142.73 | 5232.0 |
| 2022-12-08 19:00:00 | AAPL | Stock | 142.73 | 142.73 | 142.5 | 142.58 | 10401.0 |
| 2022-12-08 19:30:00 | AAPL | Stock | 142.51 | 142.7 | 142.37 | 142.7 | 8185.0 |
| 2022-12-08 04:00:00 | MSFT | Stock | 244.53 | 244.53 | 244.46 | 244.46 | 300.0 |
| 2022-12-08 04:30:00 | MSFT | Stock | 244.5 | 244.6 | 244.45 | 244.45 | 3323.0 |
| 2022-12-08 05:00:00 | MSFT | Stock | 244.43 | 244.43 | 244.43 | 244.43 | 248.0 |
| 2022-12-08 05:30:00 | MSFT | Stock | 244.66 | 244.66 | 244.29 | 244.29 | 404.0 |
| 2022-12-08 06:00:00 | MSFT | Stock | 244.4 | 244.4 | 244.03 | 244.16 | 728.0 |
| 2022-12-08 06:30:00 | MSFT | Stock | 244.57 | 244.64 | 244.5 | 244.6 | 833.0 |
| 2022-12-08 07:00:00 | MSFT | Stock | 244.4 | 244.4 | 244.26 | 244.26 | 1737.0 |
| 2022-12-08 07:30:00 | MSFT | Stock | 244.25 | 244.86 | 244.06 | 244.85 | 6299.0 |
| 2022-12-08 08:00:00 | MSFT | Stock | 244.31 | 245.01 | 244.25 | 245.0 | 16350.0 |
| 2022-12-08 08:30:00 | MSFT | Stock | 245.2 | 245.78 | 244.85 | 244.9102 | 18608.0 |
| 2022-12-08 09:00:00 | MSFT | Stock | 245.25 | 245.36 | 244.86 | 245.0 | 24739.0 |
| 2022-12-08 09:30:00 | MSFT | Stock | 245.02 | 245.99 | 243.06 | 245.93 | 2120285.0 |
| 2022-12-08 10:00:00 | MSFT | Stock | 245.925 | 247.3 | 245.7087 | 246.615 | 1495144.0 |
| 2022-12-08 10:30:00 | MSFT | Stock | 246.62 | 246.93 | 245.75 | 246.905 | 887936.0 |
| 2022-12-08 11:00:00 | MSFT | Stock | 246.92 | 247.19 | 245.84 | 246.9 | 760495.0 |
| 2022-12-08 11:30:00 | MSFT | Stock | 246.91 | 247.75 | 246.8 | 247.29 | 791359.0 |
| 2022-12-08 12:00:00 | MSFT | Stock | 247.27 | 247.66 | 246.77 | 246.925 | 631459.0 |
| 2022-12-08 12:30:00 | MSFT | Stock | 246.89 | 247.66 | 246.7 | 247.5216 | 601023.0 |
> showing 50 of 101,581 rows — these rows as CSV