PREVIEW / stock_daily / 2022-11-15
file: by_date/stock_daily/2022/2022-11-15.parquet size: 253 KB rows: 7,841 symbols: 2,087
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-15 | AAPL | Stock | 152.22 | 153.59 | 148.56 | 150.04 | 89868300.0 |
| 2022-11-15 | MSFT | Stock | 245.66 | 247.0 | 240.03 | 241.97 | 31390100.0 |
| 2022-11-15 | NVDA | Stock | 16.722 | 16.998 | 16.382 | 16.666 | 545876000.0 |
| 2022-11-15 | AMZN | Stock | 103.21 | 103.79 | 97.34 | 98.94 | 111336300.0 |
| 2022-11-15 | GOOGL | Stock | 98.26 | 100.14 | 96.71 | 98.44 | 41640816.0 |
| 2022-11-15 | META | Stock | 116.07 | 118.74 | 114.41 | 117.08 | 50670500.0 |
| 2022-11-15 | TSLA | Stock | 195.88 | 200.82 | 192.06 | 194.42 | 91293800.0 |
| 2022-11-15 | TLT | Stock | 98.25 | 99.3 | 98.11 | 99.23 | 26608180.0 |
| 2022-11-15 | ES | Stock | 78.62 | 79.34 | 77.62 | 78.65 | 1378600.0 |
| 2022-11-15 | CL | Stock | 75.48 | 75.92 | 74.58 | 75.32 | 3495900.0 |
| 2022-11-15 | A | Stock | 148.27 | 149.46 | 146.5 | 148.0 | 1299200.0 |
| 2022-11-15 | AA | Stock | 49.6 | 49.99 | 48.44 | 49.21 | 5395300.0 |
| 2022-11-15 | AAC-DELISTED | Stock | 9.99 | 10.0 | 9.98 | 9.99 | 20275.0 |
| 2022-11-15 | AACG | Stock | 1.61 | 1.84 | 1.61 | 1.71 | 4300.0 |
| 2022-11-15 | AACIW-DELISTED | Stock | 0.0311 | 0.0406 | 0.0311 | 0.0311 | 15810.0 |
| 2022-11-15 | AAIC-DELISTED | Stock | 3.25 | 3.2863 | 3.1 | 3.12 | 182827.0 |
| 2022-11-15 | AAIC.C-DELISTED | Stock | 21.12 | 21.3 | 21.0798 | 21.0798 | 798.0 |
| 2022-11-15 | AAL | Stock | 15.02 | 15.18 | 14.53 | 14.61 | 29423100.0 |
| 2022-11-15 | AAM.A-DELISTED | Stock | 23.69 | 24.415 | 23.6 | 24.3 | 39492.0 |
| 2022-11-15 | AAM.B-DELISTED | Stock | 24.04 | 25.0 | 24.0 | 24.62 | 10365.0 |
| 2022-11-15 | AAMC-DELISTED | Stock | 5.5882 | 5.8794 | 5.5882 | 5.7353 | 13763.0 |
| 2022-11-15 | AAME | Stock | 3.05 | 3.14 | 2.96 | 2.96 | 5800.0 |
| 2022-11-15 | AAMI | Stock | 20.2 | 20.44 | 19.95 | 20.01 | 148900.0 |
| 2022-11-15 | AAN-DELISTED | Stock | 11.11 | 11.38 | 10.7 | 10.76 | 366500.0 |
| 2022-11-15 | AAOI | Stock | 2.4 | 2.42 | 2.315 | 2.35 | 129000.0 |
| 2022-11-15 | AAON | Stock | 52.2 | 54.1333 | 51.7733 | 53.4933 | 375750.0 |
| 2022-11-15 | AAP | Stock | 184.53 | 185.94 | 178.33 | 183.94 | 1644300.0 |
| 2022-11-15 | AAQC-DELISTED | Stock | 9.91 | 10.01 | 9.89 | 10.01 | 3325949.0 |
| 2022-11-15 | AAT | Stock | 28.2 | 28.44 | 27.84 | 28.24 | 216000.0 |
| 2022-11-15 | AATC | Stock | 4.04 | 4.2323 | 3.94 | 4.1499 | 88974.0 |
| 2022-11-15 | AAU-DELISTED | Stock | 0.2616 | 0.2684 | 0.2528 | 0.2572 | 296131.0 |
| 2022-11-15 | AAUAF-DELISTED | Stock | 0.2616 | 0.2684 | 0.2528 | 0.2562 | 300162.0 |
| 2022-11-15 | AAWW-DELISTED | Stock | 100.55 | 100.65 | 100.165 | 100.48 | 593028.0 |
| 2022-11-15 | AAXJ | Stock | 65.29 | 65.63 | 64.71 | 65.13 | 1153692.0 |
| 2022-11-15 | AB | Stock | 40.53 | 40.99 | 40.33 | 40.52 | 341100.0 |
| 2022-11-15 | ABB-DELISTED | Stock | 31.61 | 31.65 | 31.035 | 31.31 | 1200217.0 |
| 2022-11-15 | ABBNY-DELISTED | Stock | 31.61 | 31.65 | 31.035 | 31.31 | 1345892.0 |
| 2022-11-15 | ABBV | Stock | 153.39 | 153.42 | 149.96 | 153.04 | 5909500.0 |
| 2022-11-15 | ABC-DELISTED | Stock | 154.82 | 156.27 | 151.7 | 152.73 | 958395.0 |
| 2022-11-15 | ABCB | Stock | 53.36 | 53.89 | 52.14 | 52.61 | 299300.0 |
| 2022-11-15 | ABCL | Stock | 14.56 | 14.97 | 14.13 | 14.49 | 2602500.0 |
| 2022-11-15 | ABCM-DELISTED | Stock | 17.06 | 17.1 | 16.72 | 16.88 | 393692.0 |
| 2022-11-15 | ABEO | Stock | 4.28 | 4.36 | 3.96 | 4.04 | 475000.0 |
| 2022-11-15 | ABEV | Stock | 3.03 | 3.04 | 2.98 | 3.0 | 14482700.0 |
| 2022-11-15 | ABG | Stock | 183.0 | 189.62 | 179.0 | 180.27 | 164200.0 |
| 2022-11-15 | ABGI-DELISTED | Stock | 10.0075 | 10.0075 | 10.0075 | 10.0075 | 86355.0 |
| 2022-11-15 | ABM | Stock | 44.82 | 45.27 | 44.02 | 45.05 | 490500.0 |
| 2022-11-15 | ABMD-DELISTED | Stock | 374.53 | 375.32 | 373.51 | 374.36 | 2618397.0 |
| 2022-11-15 | ABNB | Stock | 109.27 | 111.235 | 106.6 | 107.01 | 5357400.0 |
| 2022-11-15 | ABOS | Stock | 6.17 | 7.12 | 6.17 | 6.45 | 283100.0 |
> showing 50 of 7,841 rows — these rows as CSV