PREVIEW / stock_daily / 2022-11-03
file: by_date/stock_daily/2022/2022-11-03.parquet size: 250 KB rows: 7,807 symbols: 2,098
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-11-03 | AAPL | Stock | 142.06 | 142.8 | 138.75 | 138.88 | 97918500.0 |
| 2022-11-03 | MSFT | Stock | 220.09 | 220.41 | 213.98 | 214.25 | 36633900.0 |
| 2022-11-03 | NVDA | Stock | 13.043 | 13.781 | 12.956 | 13.421 | 500065000.0 |
| 2022-11-03 | AMZN | Stock | 92.47 | 93.5 | 89.02 | 89.3 | 136683300.0 |
| 2022-11-03 | GOOGL | Stock | 86.32 | 86.52 | 83.34 | 83.43 | 61288019.0 |
| 2022-11-03 | META | Stock | 90.08 | 90.46 | 88.41 | 88.91 | 60664000.0 |
| 2022-11-03 | TSLA | Stock | 211.36 | 221.2 | 210.14 | 215.31 | 56538800.0 |
| 2022-11-03 | TLT | Stock | 95.17 | 96.38 | 95.09 | 95.83 | 29097497.0 |
| 2022-11-03 | ES | Stock | 75.29 | 76.99 | 73.68 | 76.2 | 1677200.0 |
| 2022-11-03 | CL | Stock | 72.21 | 72.76 | 72.07 | 72.39 | 3001600.0 |
| 2022-11-03 | A | Stock | 133.77 | 135.87 | 130.66 | 134.46 | 1199400.0 |
| 2022-11-03 | AA | Stock | 37.14 | 38.19 | 36.512 | 37.7 | 4407700.0 |
| 2022-11-03 | AAC-DELISTED | Stock | 9.97 | 9.9778 | 9.96 | 9.97 | 29061.0 |
| 2022-11-03 | AACG | Stock | 1.8 | 1.9 | 1.7 | 1.77 | 29300.0 |
| 2022-11-03 | AACIW-DELISTED | Stock | 0.07 | 0.07 | 0.07 | 0.07 | 161.0 |
| 2022-11-03 | AAIC-DELISTED | Stock | 2.88 | 2.98 | 2.88 | 2.96 | 18121.0 |
| 2022-11-03 | AAIC.C-DELISTED | Stock | 20.1234 | 20.95 | 20.1234 | 20.95 | 1000.0 |
| 2022-11-03 | AAL | Stock | 13.36 | 13.87 | 13.2 | 13.73 | 25312300.0 |
| 2022-11-03 | AAM.A-DELISTED | Stock | 21.049 | 21.67 | 20.9533 | 21.33 | 20970.0 |
| 2022-11-03 | AAM.B-DELISTED | Stock | 21.39 | 21.6188 | 21.09 | 21.6188 | 10318.0 |
| 2022-11-03 | AAMC-DELISTED | Stock | 5.4147 | 5.6294 | 5.4147 | 5.4941 | 6416.0 |
| 2022-11-03 | AAME | Stock | 3.02 | 3.04 | 2.84 | 2.89 | 1100.0 |
| 2022-11-03 | AAMI | Stock | 17.86 | 18.9 | 17.61 | 18.65 | 399200.0 |
| 2022-11-03 | AAN-DELISTED | Stock | 9.74 | 10.07 | 9.57 | 9.88 | 350700.0 |
| 2022-11-03 | AAOI | Stock | 2.59 | 2.59 | 2.39 | 2.43 | 419900.0 |
| 2022-11-03 | AAON | Stock | 41.58 | 43.2333 | 41.4333 | 42.92 | 131850.0 |
| 2022-11-03 | AAP | Stock | 185.59 | 186.4 | 183.09 | 184.24 | 865500.0 |
| 2022-11-03 | AAQC-DELISTED | Stock | 9.95 | 9.95 | 9.94 | 9.95 | 288793.0 |
| 2022-11-03 | AAT | Stock | 27.7 | 28.33 | 27.13 | 28.21 | 363900.0 |
| 2022-11-03 | AATC | Stock | 4.28 | 4.32 | 4.22 | 4.2916 | 3364.0 |
| 2022-11-03 | AAU-DELISTED | Stock | 0.22 | 0.2284 | 0.22 | 0.2246 | 321134.0 |
| 2022-11-03 | AAUAF-DELISTED | Stock | 0.22 | 0.2284 | 0.22 | 0.2246 | 303439.0 |
| 2022-11-03 | AAWW-DELISTED | Stock | 100.51 | 100.705 | 99.775 | 100.27 | 1175662.0 |
| 2022-11-03 | AAXJ | Stock | 55.98 | 56.83 | 55.98 | 56.71 | 709465.0 |
| 2022-11-03 | AB | Stock | 36.61 | 37.11 | 35.92 | 35.92 | 396800.0 |
| 2022-11-03 | ABB-DELISTED | Stock | 26.92 | 27.4468 | 26.89 | 27.26 | 1281036.0 |
| 2022-11-03 | ABBNY-DELISTED | Stock | 26.92 | 27.4468 | 26.89 | 27.26 | 1430789.0 |
| 2022-11-03 | ABBV | Stock | 144.0 | 145.42 | 143.03 | 144.42 | 3850700.0 |
| 2022-11-03 | ABC-DELISTED | Stock | 152.99 | 159.52 | 150.85 | 157.73 | 1193024.0 |
| 2022-11-03 | ABCB | Stock | 50.13 | 50.43 | 49.59 | 50.06 | 243800.0 |
| 2022-11-03 | ABCL | Stock | 11.84 | 12.465 | 11.72 | 12.11 | 2096700.0 |
| 2022-11-03 | ABCM-DELISTED | Stock | 14.57 | 14.87 | 14.48 | 14.75 | 206412.0 |
| 2022-11-03 | ABEO | Stock | 4.5 | 4.6 | 3.25 | 3.87 | 3495400.0 |
| 2022-11-03 | ABEV | Stock | 2.97 | 3.09 | 2.96 | 3.08 | 30652300.0 |
| 2022-11-03 | ABG | Stock | 152.23 | 158.96 | 151.56 | 155.86 | 137000.0 |
| 2022-11-03 | ABM | Stock | 43.76 | 43.85 | 43.08 | 43.26 | 200400.0 |
| 2022-11-03 | ABMD-DELISTED | Stock | 373.33 | 375.37 | 373.33 | 373.51 | 1718025.0 |
| 2022-11-03 | ABNB | Stock | 94.08 | 95.31 | 91.272 | 92.02 | 10099300.0 |
| 2022-11-03 | ABOS | Stock | 6.84 | 7.05 | 6.55 | 6.77 | 143500.0 |
| 2022-11-03 | ABR | Stock | 13.1 | 13.29 | 12.79 | 13.16 | 2722200.0 |
> showing 50 of 7,807 rows — these rows as CSV