PREVIEW / stock_30min / 2022-12-05
file: by_date/stock_30min/2022/2022-12-05.parquet size: 2.1 MB rows: 104,466 symbols: 2,056
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-05 04:00:00 | AAPL | Stock | 148.0 | 148.0 | 147.37 | 147.7 | 39593.0 |
| 2022-12-05 04:30:00 | AAPL | Stock | 147.71 | 147.75 | 147.57 | 147.61 | 4530.0 |
| 2022-12-05 05:00:00 | AAPL | Stock | 147.61 | 147.73 | 147.59 | 147.65 | 4730.0 |
| 2022-12-05 05:30:00 | AAPL | Stock | 147.65 | 147.9 | 147.61 | 147.85 | 10152.0 |
| 2022-12-05 06:00:00 | AAPL | Stock | 147.85 | 148.1 | 147.85 | 148.06 | 9748.0 |
| 2022-12-05 06:30:00 | AAPL | Stock | 147.89 | 148.42 | 147.89 | 148.29 | 14098.0 |
| 2022-12-05 07:00:00 | AAPL | Stock | 148.15 | 148.28 | 147.59 | 147.61 | 51104.0 |
| 2022-12-05 07:30:00 | AAPL | Stock | 147.7 | 147.8 | 147.54 | 147.78 | 19842.0 |
| 2022-12-05 08:00:00 | AAPL | Stock | 148.07 | 148.21 | 147.441 | 147.95 | 118571.0 |
| 2022-12-05 08:30:00 | AAPL | Stock | 147.9105 | 148.11 | 147.3043 | 147.4 | 125702.0 |
| 2022-12-05 09:00:00 | AAPL | Stock | 147.4 | 147.95 | 147.32 | 147.73 | 119751.0 |
| 2022-12-05 09:30:00 | AAPL | Stock | 147.73 | 150.9199 | 147.5 | 149.96 | 11856617.0 |
| 2022-12-05 10:00:00 | AAPL | Stock | 149.96 | 150.01 | 148.18 | 148.4808 | 7148099.0 |
| 2022-12-05 10:30:00 | AAPL | Stock | 148.48 | 148.75 | 147.62 | 147.89 | 4333522.0 |
| 2022-12-05 11:00:00 | AAPL | Stock | 147.9 | 148.2 | 146.82 | 146.88 | 4241631.0 |
| 2022-12-05 11:30:00 | AAPL | Stock | 146.8801 | 147.0 | 146.37 | 146.468 | 2941659.0 |
| 2022-12-05 12:00:00 | AAPL | Stock | 146.451 | 147.28 | 146.42 | 147.19 | 2520658.0 |
| 2022-12-05 12:30:00 | AAPL | Stock | 147.1798 | 147.28 | 146.57 | 146.66 | 2135689.0 |
| 2022-12-05 13:00:00 | AAPL | Stock | 146.66 | 146.895 | 146.535 | 146.69 | 1763954.0 |
| 2022-12-05 13:30:00 | AAPL | Stock | 146.69 | 146.9 | 146.12 | 146.1602 | 2462272.0 |
| 2022-12-05 14:00:00 | AAPL | Stock | 146.16 | 146.43 | 145.99 | 146.1 | 2478068.0 |
| 2022-12-05 14:30:00 | AAPL | Stock | 146.11 | 146.21 | 145.77 | 146.0353 | 2218724.0 |
| 2022-12-05 15:00:00 | AAPL | Stock | 146.03 | 146.17 | 145.8 | 145.8609 | 2830196.0 |
| 2022-12-05 15:30:00 | AAPL | Stock | 145.8604 | 146.8 | 145.85 | 146.61 | 5680662.0 |
| 2022-12-05 16:00:00 | AAPL | Stock | 146.62 | 146.98 | 146.6 | 146.81 | 7519239.0 |
| 2022-12-05 16:30:00 | AAPL | Stock | 146.83 | 146.88 | 146.63 | 146.88 | 76444.0 |
| 2022-12-05 17:00:00 | AAPL | Stock | 146.87 | 146.88 | 146.74 | 146.84 | 21604.0 |
| 2022-12-05 17:30:00 | AAPL | Stock | 146.8101 | 146.82 | 146.63 | 146.7982 | 7754.0 |
| 2022-12-05 18:00:00 | AAPL | Stock | 146.78 | 146.99 | 146.76 | 146.96 | 25656.0 |
| 2022-12-05 18:30:00 | AAPL | Stock | 146.91 | 146.98 | 146.85 | 146.85 | 11700.0 |
| 2022-12-05 19:00:00 | AAPL | Stock | 146.9 | 146.99 | 146.86 | 146.95 | 13260.0 |
| 2022-12-05 19:30:00 | AAPL | Stock | 146.99 | 147.04 | 146.86 | 146.96 | 27895.0 |
| 2022-12-05 04:00:00 | MSFT | Stock | 253.92 | 253.92 | 253.03 | 253.22 | 2508.0 |
| 2022-12-05 04:30:00 | MSFT | Stock | 253.8 | 253.8 | 253.4 | 253.4 | 676.0 |
| 2022-12-05 05:00:00 | MSFT | Stock | 253.67 | 253.77 | 253.51 | 253.72 | 2996.0 |
| 2022-12-05 05:30:00 | MSFT | Stock | 253.73 | 253.73 | 253.5 | 253.69 | 555.0 |
| 2022-12-05 06:30:00 | MSFT | Stock | 253.9 | 254.15 | 253.85 | 254.13 | 876.0 |
| 2022-12-05 07:00:00 | MSFT | Stock | 254.03 | 254.39 | 253.79 | 253.79 | 2393.0 |
| 2022-12-05 07:30:00 | MSFT | Stock | 253.8 | 253.9 | 253.65 | 253.83 | 5135.0 |
| 2022-12-05 08:00:00 | MSFT | Stock | 254.0047 | 254.51 | 253.4 | 253.67 | 13282.0 |
| 2022-12-05 08:30:00 | MSFT | Stock | 253.86 | 253.99 | 253.15 | 253.15 | 22472.0 |
| 2022-12-05 09:00:00 | MSFT | Stock | 253.25 | 253.35 | 252.0 | 252.0 | 25903.0 |
| 2022-12-05 09:30:00 | MSFT | Stock | 252.01 | 253.819 | 251.61 | 252.63 | 2013588.0 |
| 2022-12-05 10:00:00 | MSFT | Stock | 252.63 | 252.63 | 251.07 | 251.58 | 991457.0 |
| 2022-12-05 10:30:00 | MSFT | Stock | 251.54 | 252.86 | 251.21 | 252.76 | 746940.0 |
| 2022-12-05 11:00:00 | MSFT | Stock | 252.77 | 253.38 | 251.95 | 252.05 | 854295.0 |
| 2022-12-05 11:30:00 | MSFT | Stock | 252.07 | 252.11 | 250.47 | 250.8935 | 1097324.0 |
| 2022-12-05 12:00:00 | MSFT | Stock | 250.88 | 250.99 | 250.1 | 250.675 | 827313.0 |
| 2022-12-05 12:30:00 | MSFT | Stock | 250.68 | 250.79 | 249.15 | 249.2 | 1065905.0 |
| 2022-12-05 13:00:00 | MSFT | Stock | 249.17 | 249.71 | 249.03 | 249.56 | 730283.0 |
> showing 50 of 104,466 rows — these rows as CSV