PREVIEW / stock_30min / 2022-12-22
file: by_date/stock_30min/2022/2022-12-22.parquet size: 2.1 MB rows: 101,602 symbols: 1,961
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-22 04:00:00 | AAPL | Stock | 135.95 | 135.95 | 135.52 | 135.55 | 9299.0 |
| 2022-12-22 04:30:00 | AAPL | Stock | 135.61 | 135.66 | 135.45 | 135.45 | 2560.0 |
| 2022-12-22 05:00:00 | AAPL | Stock | 135.39 | 135.44 | 135.27 | 135.44 | 5297.0 |
| 2022-12-22 05:30:00 | AAPL | Stock | 135.38 | 135.38 | 135.36 | 135.36 | 2143.0 |
| 2022-12-22 06:00:00 | AAPL | Stock | 135.32 | 135.32 | 135.12 | 135.15 | 4880.0 |
| 2022-12-22 06:30:00 | AAPL | Stock | 135.24 | 135.24 | 135.21 | 135.21 | 411.0 |
| 2022-12-22 07:00:00 | AAPL | Stock | 135.25 | 135.44 | 135.02 | 135.05 | 24900.0 |
| 2022-12-22 07:30:00 | AAPL | Stock | 135.02 | 135.03 | 134.8 | 134.93 | 36143.0 |
| 2022-12-22 08:00:00 | AAPL | Stock | 135.29 | 136.0 | 134.8 | 134.87 | 137426.0 |
| 2022-12-22 08:30:00 | AAPL | Stock | 134.84 | 134.84 | 133.8 | 133.8696 | 292599.0 |
| 2022-12-22 09:00:00 | AAPL | Stock | 133.87 | 134.42 | 133.8 | 134.42 | 206386.0 |
| 2022-12-22 09:30:00 | AAPL | Stock | 134.43 | 134.56 | 133.17 | 133.5392 | 6655345.0 |
| 2022-12-22 10:00:00 | AAPL | Stock | 133.53 | 133.535 | 131.86 | 131.92 | 6141501.0 |
| 2022-12-22 10:30:00 | AAPL | Stock | 131.92 | 131.92 | 131.135 | 131.5381 | 5240616.0 |
| 2022-12-22 11:00:00 | AAPL | Stock | 131.535 | 132.01 | 131.43 | 131.62 | 3422762.0 |
| 2022-12-22 11:30:00 | AAPL | Stock | 131.63 | 131.76 | 131.0501 | 131.705 | 3065078.0 |
| 2022-12-22 12:00:00 | AAPL | Stock | 131.701 | 131.775 | 130.7 | 130.79 | 3230364.0 |
| 2022-12-22 12:30:00 | AAPL | Stock | 130.77 | 131.09 | 130.71 | 131.01 | 2681649.0 |
| 2022-12-22 13:00:00 | AAPL | Stock | 131.0117 | 131.015 | 130.35 | 130.4788 | 3060791.0 |
| 2022-12-22 13:30:00 | AAPL | Stock | 130.46 | 131.055 | 130.3 | 130.79 | 3178024.0 |
| 2022-12-22 14:00:00 | AAPL | Stock | 130.808 | 131.35 | 130.65 | 131.25 | 3416379.0 |
| 2022-12-22 14:30:00 | AAPL | Stock | 131.25 | 131.55 | 131.01 | 131.5 | 3517300.0 |
| 2022-12-22 15:00:00 | AAPL | Stock | 131.5 | 132.2 | 131.17 | 132.115 | 5334655.0 |
| 2022-12-22 15:30:00 | AAPL | Stock | 132.12 | 132.36 | 131.365 | 132.25 | 8810947.0 |
| 2022-12-22 16:00:00 | AAPL | Stock | 132.225 | 132.5 | 131.92 | 132.09 | 9663844.0 |
| 2022-12-22 16:30:00 | AAPL | Stock | 132.08 | 132.23 | 132.08 | 132.1726 | 43998.0 |
| 2022-12-22 17:00:00 | AAPL | Stock | 132.1867 | 132.1867 | 132.05 | 132.13 | 28958.0 |
| 2022-12-22 17:30:00 | AAPL | Stock | 132.11 | 132.19 | 132.09 | 132.17 | 23224.0 |
| 2022-12-22 18:00:00 | AAPL | Stock | 132.19 | 132.19 | 132.0 | 132.05 | 34108.0 |
| 2022-12-22 18:30:00 | AAPL | Stock | 132.06 | 132.16 | 132.03 | 132.03 | 26923.0 |
| 2022-12-22 19:00:00 | AAPL | Stock | 132.0 | 132.01 | 131.53 | 131.6 | 24325.0 |
| 2022-12-22 19:30:00 | AAPL | Stock | 131.57 | 131.7 | 131.25 | 131.3 | 37649.0 |
| 2022-12-22 04:00:00 | MSFT | Stock | 244.85 | 244.85 | 244.62 | 244.63 | 2078.0 |
| 2022-12-22 04:30:00 | MSFT | Stock | 244.56 | 244.7 | 244.56 | 244.7 | 200.0 |
| 2022-12-22 05:00:00 | MSFT | Stock | 244.51 | 244.51 | 244.42 | 244.42 | 1836.0 |
| 2022-12-22 06:00:00 | MSFT | Stock | 243.82 | 243.83 | 243.82 | 243.83 | 566.0 |
| 2022-12-22 06:30:00 | MSFT | Stock | 244.08 | 244.15 | 244.08 | 244.15 | 1653.0 |
| 2022-12-22 07:00:00 | MSFT | Stock | 244.1 | 244.1 | 243.41 | 243.41 | 8975.0 |
| 2022-12-22 07:30:00 | MSFT | Stock | 243.43 | 243.6 | 243.31 | 243.6 | 2065.0 |
| 2022-12-22 08:00:00 | MSFT | Stock | 244.0101 | 244.0101 | 243.22 | 243.22 | 11373.0 |
| 2022-12-22 08:30:00 | MSFT | Stock | 243.2 | 243.26 | 240.29 | 240.75 | 19656.0 |
| 2022-12-22 09:00:00 | MSFT | Stock | 240.65 | 241.7 | 240.16 | 241.57 | 30551.0 |
| 2022-12-22 09:30:00 | MSFT | Stock | 241.34 | 241.99 | 238.95 | 239.48 | 1963862.0 |
| 2022-12-22 10:00:00 | MSFT | Stock | 239.48 | 239.48 | 236.37 | 236.37 | 1693563.0 |
| 2022-12-22 10:30:00 | MSFT | Stock | 236.36 | 236.5099 | 234.72 | 236.19 | 1935783.0 |
| 2022-12-22 11:00:00 | MSFT | Stock | 236.19 | 236.48 | 235.68 | 236.06 | 953548.0 |
| 2022-12-22 11:30:00 | MSFT | Stock | 236.08 | 236.31 | 235.04 | 236.11 | 901852.0 |
| 2022-12-22 12:00:00 | MSFT | Stock | 236.09 | 236.44 | 234.99 | 235.2554 | 964786.0 |
| 2022-12-22 12:30:00 | MSFT | Stock | 235.23 | 235.59 | 234.81 | 235.44 | 1076655.0 |
| 2022-12-22 13:00:00 | MSFT | Stock | 235.44 | 235.44 | 234.39 | 234.51 | 658809.0 |
> showing 50 of 101,602 rows — these rows as CSV