PREVIEW / stock_daily / 2022-11-30
file: by_date/stock_daily/2022/2022-11-30.parquet size: 253 KB rows: 7,863 symbols: 2,096
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-30 | AAPL | Stock | 141.4 | 148.72 | 140.55 | 148.03 | 111380900.0 |
| 2022-11-30 | MSFT | Stock | 240.57 | 255.33 | 239.86 | 255.14 | 47594200.0 |
| 2022-11-30 | NVDA | Stock | 15.697 | 16.93 | 15.597 | 16.923 | 565298000.0 |
| 2022-11-30 | AMZN | Stock | 92.47 | 96.54 | 91.53 | 96.54 | 102805800.0 |
| 2022-11-30 | GOOGL | Stock | 94.82 | 101.04 | 94.42 | 100.99 | 43647481.0 |
| 2022-11-30 | META | Stock | 109.51 | 118.16 | 109.38 | 118.1 | 43348600.0 |
| 2022-11-30 | TSLA | Stock | 182.43 | 194.76 | 180.63 | 194.7 | 109186400.0 |
| 2022-11-30 | TLT | Stock | 101.615 | 102.73 | 101.37 | 102.73 | 21581659.0 |
| 2022-11-30 | ES | Stock | 80.48 | 82.93 | 80.05 | 82.86 | 3388400.0 |
| 2022-11-30 | CL | Stock | 75.86 | 77.48 | 75.7 | 77.48 | 5816100.0 |
| 2022-11-30 | A | Stock | 151.38 | 154.98 | 149.1 | 154.98 | 2867700.0 |
| 2022-11-30 | AA | Stock | 48.88 | 50.49 | 47.63 | 50.13 | 6778400.0 |
| 2022-11-30 | AAC-DELISTED | Stock | 10.01 | 10.03 | 10.01 | 10.02 | 2044744.0 |
| 2022-11-30 | AACG | Stock | 1.77 | 1.86 | 1.72 | 1.75 | 7200.0 |
| 2022-11-30 | AACIW-DELISTED | Stock | 0.0548 | 0.0548 | 0.0296 | 0.0302 | 39540.0 |
| 2022-11-30 | AAIC-DELISTED | Stock | 3.08 | 3.08 | 3.04 | 3.05 | 47682.0 |
| 2022-11-30 | AAIC.C-DELISTED | Stock | 21.89 | 21.8999 | 21.5001 | 21.8999 | 2339.0 |
| 2022-11-30 | AAL | Stock | 14.12 | 14.45 | 13.93 | 14.43 | 21241800.0 |
| 2022-11-30 | AAM.A-DELISTED | Stock | 23.57 | 24.7 | 23.355 | 24.57 | 72454.0 |
| 2022-11-30 | AAM.B-DELISTED | Stock | 23.19 | 25.1238 | 23.02 | 24.92 | 76906.0 |
| 2022-11-30 | AAMC-DELISTED | Stock | 5.3412 | 6.0882 | 5.3412 | 5.7029 | 20587.0 |
| 2022-11-30 | AAME | Stock | 2.8 | 2.88 | 2.8 | 2.88 | 500.0 |
| 2022-11-30 | AAMI | Stock | 19.81 | 20.43 | 19.44 | 20.36 | 206700.0 |
| 2022-11-30 | AAN-DELISTED | Stock | 11.84 | 12.33 | 11.47 | 12.19 | 418300.0 |
| 2022-11-30 | AAOI | Stock | 2.1 | 2.2 | 2.02 | 2.2 | 118700.0 |
| 2022-11-30 | AAON | Stock | 51.2867 | 52.8733 | 50.5333 | 52.84 | 399750.0 |
| 2022-11-30 | AAP | Stock | 147.34 | 151.0 | 145.14 | 150.99 | 1251400.0 |
| 2022-11-30 | AAQC-DELISTED | Stock | 10.06 | 10.07 | 10.05 | 10.07 | 96008.0 |
| 2022-11-30 | AAT | Stock | 28.42 | 29.36 | 27.99 | 29.29 | 535300.0 |
| 2022-11-30 | AATC | Stock | 4.965 | 4.99 | 4.8624 | 4.99 | 7607.0 |
| 2022-11-30 | AAU-DELISTED | Stock | 0.24 | 0.2437 | 0.2346 | 0.24 | 253611.0 |
| 2022-11-30 | AAUAF-DELISTED | Stock | 0.24 | 0.2437 | 0.2346 | 0.24 | 252813.0 |
| 2022-11-30 | AAWW-DELISTED | Stock | 100.64 | 101.18 | 100.315 | 100.75 | 318948.0 |
| 2022-11-30 | AAXJ | Stock | 66.08 | 66.83 | 65.67 | 66.7 | 1378310.0 |
| 2022-11-30 | AB | Stock | 39.98 | 40.41 | 39.06 | 40.35 | 278200.0 |
| 2022-11-30 | ABB-DELISTED | Stock | 30.91 | 31.49 | 30.56 | 31.49 | 1829162.0 |
| 2022-11-30 | ABBNY-DELISTED | Stock | 30.91 | 31.49 | 30.56 | 31.49 | 2015267.0 |
| 2022-11-30 | ABBV | Stock | 158.79 | 161.18 | 156.46 | 161.18 | 12342500.0 |
| 2022-11-30 | ABC-DELISTED | Stock | 167.18 | 171.24 | 166.8 | 170.63 | 1505816.0 |
| 2022-11-30 | ABCB | Stock | 52.05 | 53.01 | 50.6 | 52.88 | 454100.0 |
| 2022-11-30 | ABCL | Stock | 13.49 | 14.0 | 11.86 | 12.87 | 4888400.0 |
| 2022-11-30 | ABCM-DELISTED | Stock | 15.32 | 16.15 | 15.2 | 16.04 | 612908.0 |
| 2022-11-30 | ABEO | Stock | 3.84 | 3.84 | 3.58 | 3.76 | 222700.0 |
| 2022-11-30 | ABEV | Stock | 2.95 | 3.05 | 2.94 | 3.05 | 26714900.0 |
| 2022-11-30 | ABG | Stock | 180.38 | 189.97 | 179.99 | 187.62 | 224800.0 |
| 2022-11-30 | ABGI-DELISTED | Stock | 10.03 | 10.03 | 10.03 | 10.03 | 60398.0 |
| 2022-11-30 | ABM | Stock | 45.6 | 47.2 | 45.06 | 47.18 | 296700.0 |
| 2022-11-30 | ABMD-DELISTED | Stock | 377.79 | 378.5 | 377.02 | 377.75 | 466612.0 |
| 2022-11-30 | ABNB | Stock | 95.86 | 102.25 | 95.72 | 102.14 | 8387500.0 |
| 2022-11-30 | ABOS | Stock | 5.83 | 5.88 | 5.59 | 5.68 | 191400.0 |
> showing 50 of 7,863 rows — these rows as CSV