PREVIEW / stock_daily / 2022-11-14
file: by_date/stock_daily/2022/2022-11-14.parquet size: 253 KB rows: 7,910 symbols: 2,142
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-14 | AAPL | Stock | 148.97 | 150.28 | 147.43 | 148.28 | 73374100.0 |
| 2022-11-14 | MSFT | Stock | 241.99 | 243.91 | 239.21 | 241.55 | 31123300.0 |
| 2022-11-14 | NVDA | Stock | 16.218 | 16.54 | 15.922 | 16.295 | 527852000.0 |
| 2022-11-14 | AMZN | Stock | 98.77 | 100.12 | 97.29 | 98.49 | 99533100.0 |
| 2022-11-14 | GOOGL | Stock | 95.09 | 96.79 | 94.51 | 95.7 | 30179539.0 |
| 2022-11-14 | META | Stock | 110.99 | 116.27 | 110.8 | 114.22 | 53395000.0 |
| 2022-11-14 | TSLA | Stock | 192.77 | 195.73 | 186.34 | 190.95 | 92226600.0 |
| 2022-11-14 | TLT | Stock | 97.91 | 97.985 | 97.09 | 97.65 | 13711928.0 |
| 2022-11-14 | ES | Stock | 78.35 | 78.95 | 77.67 | 77.67 | 1255700.0 |
| 2022-11-14 | CL | Stock | 74.9 | 76.11 | 74.55 | 74.57 | 3243300.0 |
| 2022-11-14 | A | Stock | 149.01 | 149.71 | 146.3 | 146.38 | 1220300.0 |
| 2022-11-14 | AA | Stock | 46.55 | 49.05 | 46.4 | 48.22 | 6575000.0 |
| 2022-11-14 | AAC-DELISTED | Stock | 9.99 | 9.99 | 9.98 | 9.98 | 45879.0 |
| 2022-11-14 | AACG | Stock | 1.72 | 1.78 | 1.72 | 1.77 | 700.0 |
| 2022-11-14 | AACIW-DELISTED | Stock | 0.05 | 0.0532 | 0.05 | 0.0504 | 4400.0 |
| 2022-11-14 | AAIC-DELISTED | Stock | 3.12 | 3.2 | 3.12 | 3.18 | 133927.0 |
| 2022-11-14 | AAIC.C-DELISTED | Stock | 21.12 | 21.12 | 21.12 | 21.12 | 200.0 |
| 2022-11-14 | AAL | Stock | 14.79 | 15.03 | 14.55 | 14.68 | 26266600.0 |
| 2022-11-14 | AAM.A-DELISTED | Stock | 23.73 | 23.73 | 23.24 | 23.51 | 27842.0 |
| 2022-11-14 | AAM.B-DELISTED | Stock | 23.99 | 24.15 | 23.625 | 23.92 | 17821.0 |
| 2022-11-14 | AAMC-DELISTED | Stock | 5.7265 | 5.7353 | 5.1324 | 5.5881 | 11023.0 |
| 2022-11-14 | AAME | Stock | 3.12 | 3.12 | 2.88 | 3.04 | 2600.0 |
| 2022-11-14 | AAMI | Stock | 19.95 | 20.35 | 19.7 | 19.74 | 183400.0 |
| 2022-11-14 | AAN-DELISTED | Stock | 11.28 | 11.355 | 10.67 | 10.74 | 403500.0 |
| 2022-11-14 | AAOI | Stock | 2.28 | 2.34 | 2.28 | 2.34 | 144300.0 |
| 2022-11-14 | AAON | Stock | 51.5267 | 52.22 | 51.0667 | 51.8733 | 346500.0 |
| 2022-11-14 | AAP | Stock | 186.97 | 189.74 | 183.65 | 183.78 | 863400.0 |
| 2022-11-14 | AAQC-DELISTED | Stock | 9.91 | 9.91 | 9.9 | 9.9 | 61530.0 |
| 2022-11-14 | AAT | Stock | 28.33 | 28.67 | 27.95 | 27.97 | 197400.0 |
| 2022-11-14 | AATC | Stock | 4.079 | 4.1458 | 4.07 | 4.1193 | 8295.0 |
| 2022-11-14 | AAU-DELISTED | Stock | 0.26 | 0.2688 | 0.2536 | 0.2542 | 184529.0 |
| 2022-11-14 | AAUAF-DELISTED | Stock | 0.26 | 0.2688 | 0.2536 | 0.254 | 192160.0 |
| 2022-11-14 | AAWW-DELISTED | Stock | 100.26 | 100.59 | 100.26 | 100.4 | 307053.0 |
| 2022-11-14 | AAXJ | Stock | 63.26 | 63.66 | 63.06 | 63.2 | 823735.0 |
| 2022-11-14 | AB | Stock | 38.97 | 40.3 | 38.25 | 40.03 | 559100.0 |
| 2022-11-14 | ABB-DELISTED | Stock | 31.37 | 31.69 | 31.25 | 31.37 | 1604012.0 |
| 2022-11-14 | ABBNY-DELISTED | Stock | 31.36 | 31.69 | 31.25 | 31.36 | 1806460.0 |
| 2022-11-14 | ABBV | Stock | 150.98 | 154.54 | 150.98 | 151.74 | 7077100.0 |
| 2022-11-14 | ABC-DELISTED | Stock | 153.0 | 156.84 | 153.0 | 154.83 | 1171363.0 |
| 2022-11-14 | ABCB | Stock | 53.43 | 54.01 | 52.72 | 52.88 | 312400.0 |
| 2022-11-14 | ABCL | Stock | 13.425 | 14.68 | 13.425 | 14.27 | 3158500.0 |
| 2022-11-14 | ABCM-DELISTED | Stock | 16.68 | 16.92 | 16.6325 | 16.79 | 210184.0 |
| 2022-11-14 | ABEO | Stock | 4.41 | 4.46 | 3.89 | 4.15 | 571400.0 |
| 2022-11-14 | ABEV | Stock | 2.95 | 3.01 | 2.92 | 2.97 | 21104600.0 |
| 2022-11-14 | ABG | Stock | 178.84 | 184.74 | 178.82 | 178.96 | 156100.0 |
| 2022-11-14 | ABGI-DELISTED | Stock | 10.0 | 10.0 | 9.98 | 10.0 | 602560.0 |
| 2022-11-14 | ABLV | Stock | 10.07 | 10.07 | 10.06 | 10.07 | 62620.0 |
| 2022-11-14 | ABM | Stock | 44.64 | 45.34 | 44.13 | 44.15 | 388800.0 |
| 2022-11-14 | ABMD-DELISTED | Stock | 373.76 | 375.43 | 373.66 | 374.11 | 2010168.0 |
| 2022-11-14 | ABNB | Stock | 107.74 | 108.69 | 105.04 | 105.16 | 4951400.0 |
> showing 50 of 7,910 rows — these rows as CSV