PREVIEW / stock_daily / 2022-10-11
file: by_date/stock_daily/2022/2022-10-11.parquet size: 252 KB rows: 7,906 symbols: 2,197
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2022-10-11 | AAPL | Stock | 139.9 | 141.35 | 138.22 | 138.98 | 77033700.0 |
| 2022-10-11 | MSFT | Stock | 227.62 | 229.06 | 224.11 | 225.41 | 30474000.0 |
| 2022-10-11 | NVDA | Stock | 11.561 | 11.846 | 11.283 | 11.586 | 667482000.0 |
| 2022-10-11 | AMZN | Stock | 112.71 | 115.48 | 110.39 | 112.21 | 56432200.0 |
| 2022-10-11 | GOOGL | Stock | 97.43 | 99.245 | 96.31 | 97.18 | 26507103.0 |
| 2022-10-11 | META | Stock | 131.62 | 132.66 | 126.99 | 128.54 | 38481400.0 |
| 2022-10-11 | TSLA | Stock | 220.95 | 225.75 | 215.0 | 216.5 | 77013200.0 |
| 2022-10-11 | TLT | Stock | 99.74 | 100.9 | 98.99 | 99.86 | 33246713.0 |
| 2022-10-11 | ES | Stock | 74.75 | 75.43 | 74.25 | 74.43 | 1827400.0 |
| 2022-10-11 | CL | Stock | 68.69 | 69.63 | 68.66 | 69.05 | 3974400.0 |
| 2022-10-11 | A | Stock | 125.0 | 127.89 | 124.16 | 125.64 | 1985300.0 |
| 2022-10-11 | AA | Stock | 37.86 | 39.07 | 37.29 | 37.85 | 4918700.0 |
| 2022-10-11 | AAC-DELISTED | Stock | 9.94 | 9.96 | 9.93 | 9.96 | 251807.0 |
| 2022-10-11 | AACG | Stock | 1.9 | 1.9 | 1.86 | 1.9 | 1200.0 |
| 2022-10-11 | AAIC-DELISTED | Stock | 2.7065 | 2.87 | 2.7065 | 2.83 | 71815.0 |
| 2022-10-11 | AAIC.C-DELISTED | Stock | 19.4 | 20.0 | 19.4 | 20.0 | 1902.0 |
| 2022-10-11 | AAL | Stock | 12.74 | 12.86 | 11.79 | 12.26 | 64438100.0 |
| 2022-10-11 | AAM.A-DELISTED | Stock | 23.175 | 23.3795 | 22.9 | 22.93 | 4680.0 |
| 2022-10-11 | AAM.B-DELISTED | Stock | 22.7 | 23.162 | 22.7 | 22.9262 | 3376.0 |
| 2022-10-11 | AAMC-DELISTED | Stock | 4.1259 | 4.5235 | 4.0588 | 4.0882 | 30209.0 |
| 2022-10-11 | AAME | Stock | 2.76 | 2.76 | 2.75 | 2.76 | 1300.0 |
| 2022-10-11 | AAMI | Stock | 17.32 | 17.54 | 17.03 | 17.31 | 335900.0 |
| 2022-10-11 | AAN-DELISTED | Stock | 8.93 | 9.22 | 8.79 | 8.91 | 719700.0 |
| 2022-10-11 | AAOI | Stock | 2.66 | 2.7 | 2.52 | 2.63 | 395700.0 |
| 2022-10-11 | AAON | Stock | 35.8133 | 37.1533 | 35.7 | 36.6267 | 289950.0 |
| 2022-10-11 | AAP | Stock | 166.41 | 171.43 | 165.99 | 168.86 | 966500.0 |
| 2022-10-11 | AAT | Stock | 24.86 | 25.66 | 24.61 | 25.3 | 582300.0 |
| 2022-10-11 | AATC | Stock | 4.51 | 4.6015 | 4.26 | 4.34 | 7481.0 |
| 2022-10-11 | AAU-DELISTED | Stock | 0.2388 | 0.24 | 0.225 | 0.235 | 174720.0 |
| 2022-10-11 | AAUAF-DELISTED | Stock | 0.2388 | 0.24 | 0.225 | 0.235 | 176189.0 |
| 2022-10-11 | AAWW-DELISTED | Stock | 98.36 | 98.95 | 98.325 | 98.81 | 337280.0 |
| 2022-10-11 | AAXJ | Stock | 57.76 | 58.09 | 57.24 | 57.49 | 961725.0 |
| 2022-10-11 | AB | Stock | 33.98 | 34.34 | 33.24 | 33.26 | 390200.0 |
| 2022-10-11 | ABB-DELISTED | Stock | 25.0 | 25.21 | 24.625 | 24.77 | 1767853.0 |
| 2022-10-11 | ABBNY-DELISTED | Stock | 24.99 | 25.21 | 24.625 | 24.77 | 2026056.0 |
| 2022-10-11 | ABBV | Stock | 138.02 | 143.68 | 138.02 | 141.51 | 5675100.0 |
| 2022-10-11 | ABC-DELISTED | Stock | 139.37 | 143.265 | 139.37 | 141.71 | 1129171.0 |
| 2022-10-11 | ABCB | Stock | 47.56 | 48.6 | 47.56 | 48.06 | 322000.0 |
| 2022-10-11 | ABCL | Stock | 10.88 | 11.135 | 10.38 | 10.94 | 1355800.0 |
| 2022-10-11 | ABCM-DELISTED | Stock | 14.71 | 14.93 | 14.4 | 14.84 | 314445.0 |
| 2022-10-11 | ABEO | Stock | 4.91 | 5.8 | 4.9 | 5.65 | 1415000.0 |
| 2022-10-11 | ABEV | Stock | 2.88 | 2.89 | 2.79 | 2.8 | 27728900.0 |
| 2022-10-11 | ABG | Stock | 155.21 | 159.84 | 153.11 | 157.53 | 164800.0 |
| 2022-10-11 | ABGI-DELISTED | Stock | 9.9 | 9.9 | 9.9 | 9.9 | 500.0 |
| 2022-10-11 | ABM | Stock | 41.05 | 41.5 | 40.83 | 41.22 | 332700.0 |
| 2022-10-11 | ABMD-DELISTED | Stock | 246.47 | 249.32 | 239.04 | 242.97 | 199523.0 |
| 2022-10-11 | ABNB | Stock | 110.988 | 111.0 | 103.595 | 106.82 | 5696700.0 |
| 2022-10-11 | ABOS | Stock | 9.77 | 9.77 | 8.85 | 9.0 | 454600.0 |
| 2022-10-11 | ABR | Stock | 11.65 | 12.36 | 11.51 | 12.29 | 2880200.0 |
| 2022-10-11 | ABR.D | Stock | 18.8864 | 19.2047 | 18.7301 | 18.7301 | 5788.0 |
> showing 50 of 7,906 rows — these rows as CSV