PREVIEW / stock_daily / 2022-02-16
file: by_date/stock_daily/2022/2022-02-16.parquet size: 261 KB rows: 8,045 symbols: 2,532
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-02-16 | AAPL | Stock | 171.85 | 173.34 | 170.05 | 172.55 | 61177400.0 |
| 2022-02-16 | MSFT | Stock | 298.37 | 300.87 | 293.68 | 299.5 | 29982100.0 |
| 2022-02-16 | NVDA | Stock | 26.259 | 26.582 | 25.552 | 26.511 | 732676000.0 |
| 2022-02-16 | AMZN | Stock | 155.7905 | 158.834 | 154.7345 | 158.1005 | 52704000.0 |
| 2022-02-16 | GOOGL | Stock | 136.6465 | 138.086 | 134.9238 | 137.738 | 25021300.0 |
| 2022-02-16 | META | Stock | 212.41 | 217.46 | 212.36 | 216.54 | 45817500.0 |
| 2022-02-16 | TSLA | Stock | 304.6833 | 308.81 | 300.4033 | 307.7967 | 51294300.0 |
| 2022-02-16 | TLT | Stock | 135.95 | 136.07 | 134.51 | 135.78 | 16473677.0 |
| 2022-02-16 | ES | Stock | 82.12 | 82.48 | 81.09 | 81.65 | 2374500.0 |
| 2022-02-16 | CL | Stock | 78.64 | 79.02 | 77.38 | 78.34 | 3825700.0 |
| 2022-02-16 | A | Stock | 135.55 | 135.6 | 132.11 | 135.15 | 3187500.0 |
| 2022-02-16 | AA | Stock | 75.0 | 77.95 | 74.72 | 77.84 | 7355800.0 |
| 2022-02-16 | AAC-DELISTED | Stock | 9.77 | 9.77 | 9.74 | 9.745 | 88895.0 |
| 2022-02-16 | AACG | Stock | 1.5 | 1.58 | 1.5 | 1.55 | 19500.0 |
| 2022-02-16 | AACIW-DELISTED | Stock | 0.32 | 0.338 | 0.32 | 0.338 | 909.0 |
| 2022-02-16 | AAIC-DELISTED | Stock | 3.37 | 3.46 | 3.37 | 3.42 | 54566.0 |
| 2022-02-16 | AAIC.C-DELISTED | Stock | 24.75 | 24.9998 | 24.75 | 24.9998 | 1191.0 |
| 2022-02-16 | AAL | Stock | 18.57 | 19.11 | 18.5 | 18.82 | 30557500.0 |
| 2022-02-16 | AAM.A-DELISTED | Stock | 25.23 | 25.27 | 25.223 | 25.27 | 27347.0 |
| 2022-02-16 | AAM.B-DELISTED | Stock | 25.44 | 25.67 | 25.44 | 25.63 | 13031.0 |
| 2022-02-16 | AAME | Stock | 2.7 | 2.87 | 2.7 | 2.78 | 2800.0 |
| 2022-02-16 | AAMI | Stock | 24.61 | 25.41 | 24.57 | 25.26 | 764400.0 |
| 2022-02-16 | AAN-DELISTED | Stock | 21.58 | 21.84 | 21.2 | 21.44 | 169600.0 |
| 2022-02-16 | AAOI | Stock | 3.87 | 4.39 | 3.83 | 4.31 | 876600.0 |
| 2022-02-16 | AAON | Stock | 39.9467 | 40.1133 | 39.48 | 39.7933 | 354150.0 |
| 2022-02-16 | AAP | Stock | 221.27 | 225.78 | 218.88 | 222.39 | 1182700.0 |
| 2022-02-16 | AAQC-DELISTED | Stock | 9.7 | 9.71 | 9.69 | 9.71 | 12684.0 |
| 2022-02-16 | AAT | Stock | 35.54 | 36.57 | 35.54 | 36.41 | 290300.0 |
| 2022-02-16 | AATC | Stock | 7.44 | 7.65 | 7.345 | 7.65 | 51510.0 |
| 2022-02-16 | AAU-DELISTED | Stock | 0.3628 | 0.3699 | 0.3575 | 0.365 | 231897.0 |
| 2022-02-16 | AAUAF-DELISTED | Stock | 0.3628 | 0.3699 | 0.3575 | 0.3592 | 235409.0 |
| 2022-02-16 | AAWW-DELISTED | Stock | 78.24 | 80.0 | 77.83 | 79.02 | 446023.0 |
| 2022-02-16 | AAXJ | Stock | 82.09 | 83.05 | 82.065 | 82.76 | 1201662.0 |
| 2022-02-16 | AB | Stock | 47.52 | 47.94 | 47.24 | 47.78 | 593000.0 |
| 2022-02-16 | ABB-DELISTED | Stock | 34.87 | 35.405 | 34.8583 | 35.34 | 1297364.0 |
| 2022-02-16 | ABBNY-DELISTED | Stock | 34.87 | 35.405 | 34.8583 | 35.33 | 1516555.0 |
| 2022-02-16 | ABBV | Stock | 144.74 | 147.22 | 144.16 | 145.87 | 8028900.0 |
| 2022-02-16 | ABC-DELISTED | Stock | 140.99 | 143.03 | 140.77 | 142.7 | 975182.0 |
| 2022-02-16 | ABCB | Stock | 50.65 | 51.58 | 50.65 | 51.32 | 283500.0 |
| 2022-02-16 | ABCL | Stock | 9.98 | 9.99 | 9.7 | 9.8 | 1434500.0 |
| 2022-02-16 | ABCM-DELISTED | Stock | 17.5 | 17.685 | 17.31 | 17.53 | 50796.0 |
| 2022-02-16 | ABEO | Stock | 6.5 | 6.75 | 6.25 | 6.5 | 29200.0 |
| 2022-02-16 | ABEV | Stock | 2.93 | 2.94 | 2.89 | 2.94 | 18249000.0 |
| 2022-02-16 | ABG | Stock | 176.2 | 185.81 | 176.2 | 184.73 | 506700.0 |
| 2022-02-16 | ABGI-DELISTED | Stock | 9.7 | 9.74 | 9.7 | 9.74 | 1291.0 |
| 2022-02-16 | ABM | Stock | 42.47 | 43.12 | 42.47 | 42.91 | 282800.0 |
| 2022-02-16 | ABMD-DELISTED | Stock | 301.96 | 328.55 | 293.38 | 325.84 | 602335.0 |
| 2022-02-16 | ABNB | Stock | 178.295 | 191.73 | 178.0 | 186.64 | 22252900.0 |
| 2022-02-16 | ABOS | Stock | 5.46 | 5.86 | 5.29 | 5.83 | 146300.0 |
| 2022-02-16 | ABR | Stock | 17.0 | 17.12 | 16.91 | 17.04 | 1350900.0 |
> showing 50 of 8,045 rows — these rows as CSV