PREVIEW / stock_30min / 2023-03-29
file: by_date/stock_30min/2023/2023-03-29.parquet size: 2.0 MB rows: 100,564 symbols: 1,755
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 |
|---|---|---|---|---|---|---|---|
| 2023-03-29 04:00:00 | AAPL | Stock | 158.66 | 158.68 | 158.33 | 158.5 | 13287.0 |
| 2023-03-29 04:30:00 | AAPL | Stock | 158.56 | 158.7 | 158.35 | 158.54 | 21061.0 |
| 2023-03-29 05:00:00 | AAPL | Stock | 158.56 | 158.76 | 158.56 | 158.76 | 2223.0 |
| 2023-03-29 05:30:00 | AAPL | Stock | 158.76 | 158.8 | 158.67 | 158.73 | 5993.0 |
| 2023-03-29 06:00:00 | AAPL | Stock | 158.75 | 158.75 | 158.55 | 158.59 | 8654.0 |
| 2023-03-29 06:30:00 | AAPL | Stock | 158.6 | 158.66 | 158.54 | 158.54 | 2939.0 |
| 2023-03-29 07:00:00 | AAPL | Stock | 158.52 | 158.71 | 158.5 | 158.7 | 18977.0 |
| 2023-03-29 07:30:00 | AAPL | Stock | 158.66 | 158.8 | 158.65 | 158.74 | 9969.0 |
| 2023-03-29 08:00:00 | AAPL | Stock | 158.6001 | 158.883 | 157.256 | 158.77 | 70886.0 |
| 2023-03-29 08:30:00 | AAPL | Stock | 158.69 | 159.2 | 158.68 | 158.95 | 62818.0 |
| 2023-03-29 09:00:00 | AAPL | Stock | 158.9996 | 159.37 | 158.9109 | 159.37 | 168497.0 |
| 2023-03-29 09:30:00 | AAPL | Stock | 159.37 | 160.08 | 159.35 | 159.848 | 6613679.0 |
| 2023-03-29 10:00:00 | AAPL | Stock | 159.86 | 160.3 | 159.65 | 159.805 | 3817875.0 |
| 2023-03-29 10:30:00 | AAPL | Stock | 159.8 | 160.0 | 159.35 | 159.5106 | 2555070.0 |
| 2023-03-29 11:00:00 | AAPL | Stock | 159.51 | 159.9614 | 159.5 | 159.8719 | 2099234.0 |
| 2023-03-29 11:30:00 | AAPL | Stock | 159.88 | 160.06 | 159.725 | 159.87 | 1899452.0 |
| 2023-03-29 12:00:00 | AAPL | Stock | 159.88 | 159.98 | 159.51 | 159.93 | 1792607.0 |
| 2023-03-29 12:30:00 | AAPL | Stock | 159.9213 | 160.04 | 159.8 | 159.955 | 1673834.0 |
| 2023-03-29 13:00:00 | AAPL | Stock | 159.955 | 160.46 | 159.84 | 160.42 | 2411510.0 |
| 2023-03-29 13:30:00 | AAPL | Stock | 160.43 | 160.44 | 159.9 | 160.02 | 1917693.0 |
| 2023-03-29 14:00:00 | AAPL | Stock | 160.025 | 160.2299 | 159.9 | 160.195 | 1538016.0 |
| 2023-03-29 14:30:00 | AAPL | Stock | 160.2 | 160.51 | 160.1 | 160.445 | 2472309.0 |
| 2023-03-29 15:00:00 | AAPL | Stock | 160.45 | 160.92 | 160.295 | 160.83 | 3037624.0 |
| 2023-03-29 15:30:00 | AAPL | Stock | 160.82 | 161.05 | 160.55 | 160.78 | 5409016.0 |
| 2023-03-29 16:00:00 | AAPL | Stock | 160.78 | 160.94 | 160.62 | 160.71 | 6981326.0 |
| 2023-03-29 16:30:00 | AAPL | Stock | 160.71 | 160.77 | 160.63 | 160.63 | 100225.0 |
| 2023-03-29 17:00:00 | AAPL | Stock | 160.64 | 160.77 | 160.6 | 160.64 | 203126.0 |
| 2023-03-29 17:30:00 | AAPL | Stock | 160.61 | 160.65 | 160.61 | 160.6102 | 6714.0 |
| 2023-03-29 18:00:00 | AAPL | Stock | 160.61 | 160.65 | 160.51 | 160.61 | 8863.0 |
| 2023-03-29 18:30:00 | AAPL | Stock | 160.6 | 160.63 | 160.51 | 160.59 | 7402.0 |
| 2023-03-29 19:00:00 | AAPL | Stock | 160.5999 | 160.6 | 160.52 | 160.55 | 2779.0 |
| 2023-03-29 19:30:00 | AAPL | Stock | 160.57 | 160.57 | 160.21 | 160.35 | 17370.0 |
| 2023-03-29 04:00:00 | MSFT | Stock | 276.88 | 277.7 | 276.8 | 277.67 | 7604.0 |
| 2023-03-29 04:30:00 | MSFT | Stock | 277.69 | 277.79 | 277.06 | 277.06 | 2354.0 |
| 2023-03-29 05:00:00 | MSFT | Stock | 277.32 | 277.66 | 277.32 | 277.66 | 1575.0 |
| 2023-03-29 05:30:00 | MSFT | Stock | 277.69 | 277.8 | 277.57 | 277.6 | 6427.0 |
| 2023-03-29 06:00:00 | MSFT | Stock | 277.67 | 277.67 | 277.3 | 277.3 | 1657.0 |
| 2023-03-29 06:30:00 | MSFT | Stock | 277.4 | 277.65 | 277.4 | 277.51 | 960.0 |
| 2023-03-29 07:00:00 | MSFT | Stock | 277.42 | 277.85 | 277.38 | 277.56 | 15998.0 |
| 2023-03-29 07:30:00 | MSFT | Stock | 277.56 | 277.8 | 277.56 | 277.6 | 4906.0 |
| 2023-03-29 08:00:00 | MSFT | Stock | 277.6397 | 277.88 | 276.1 | 277.6999 | 27568.0 |
| 2023-03-29 08:30:00 | MSFT | Stock | 277.55 | 277.85 | 277.1035 | 277.59 | 18069.0 |
| 2023-03-29 09:00:00 | MSFT | Stock | 277.48 | 279.09 | 277.4 | 278.91 | 38912.0 |
| 2023-03-29 09:30:00 | MSFT | Stock | 278.85 | 279.97 | 278.41 | 279.905 | 2260114.0 |
| 2023-03-29 10:00:00 | MSFT | Stock | 279.93 | 280.66 | 279.59 | 279.76 | 1675764.0 |
| 2023-03-29 10:30:00 | MSFT | Stock | 279.78 | 279.87 | 278.7 | 278.86 | 1282959.0 |
| 2023-03-29 11:00:00 | MSFT | Stock | 278.87 | 279.4613 | 278.41 | 279.44 | 856342.0 |
| 2023-03-29 11:30:00 | MSFT | Stock | 279.48 | 279.95 | 279.08 | 279.69 | 882726.0 |
| 2023-03-29 12:00:00 | MSFT | Stock | 279.7 | 279.98 | 279.5 | 279.6101 | 784070.0 |
| 2023-03-29 12:30:00 | MSFT | Stock | 279.6316 | 280.01 | 279.16 | 279.35 | 586261.0 |
> showing 50 of 100,564 rows — these rows as CSV