PREVIEW / stock_daily / 2022-05-24
file: by_date/stock_daily/2022/2022-05-24.parquet size: 257 KB rows: 7,962 symbols: 2,389
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-05-24 | AAPL | Stock | 140.81 | 141.97 | 137.33 | 140.36 | 104132700.0 |
| 2022-05-24 | MSFT | Stock | 257.89 | 261.33 | 253.5 | 259.62 | 29043900.0 |
| 2022-05-24 | NVDA | Stock | 16.51 | 16.597 | 15.78 | 16.154 | 588550000.0 |
| 2022-05-24 | AMZN | Stock | 104.025 | 105.4 | 101.26 | 104.1 | 102934000.0 |
| 2022-05-24 | GOOGL | Stock | 105.772 | 106.4582 | 101.8847 | 105.97 | 76779780.0 |
| 2022-05-24 | META | Stock | 180.55 | 183.68 | 176.11 | 181.28 | 50406300.0 |
| 2022-05-24 | TSLA | Stock | 217.8433 | 217.9733 | 206.8567 | 209.3867 | 89092500.0 |
| 2022-05-24 | TLT | Stock | 117.9 | 119.638 | 117.86 | 118.86 | 23388212.0 |
| 2022-05-24 | ES | Stock | 91.62 | 92.68 | 90.04 | 92.64 | 2652600.0 |
| 2022-05-24 | CL | Stock | 76.64 | 78.3 | 76.36 | 78.12 | 3539700.0 |
| 2022-05-24 | A | Stock | 125.32 | 126.0 | 123.8 | 124.41 | 2187700.0 |
| 2022-05-24 | AA | Stock | 61.99 | 62.18 | 60.09 | 61.33 | 6208100.0 |
| 2022-05-24 | AAC-DELISTED | Stock | 9.81 | 9.81 | 9.8 | 9.8 | 116823.0 |
| 2022-05-24 | AACG | Stock | 1.01 | 1.04 | 0.99 | 0.99 | 22100.0 |
| 2022-05-24 | AAIC-DELISTED | Stock | 3.42 | 3.48 | 3.38 | 3.45 | 46325.0 |
| 2022-05-24 | AAIC.C-DELISTED | Stock | 22.75 | 22.825 | 22.75 | 22.8 | 1600.0 |
| 2022-05-24 | AAL | Stock | 16.53 | 16.53 | 15.32 | 15.5 | 38817400.0 |
| 2022-05-24 | AAM.A-DELISTED | Stock | 24.08 | 24.47 | 24.07 | 24.31 | 24626.0 |
| 2022-05-24 | AAM.B-DELISTED | Stock | 24.97 | 25.07 | 24.7201 | 24.82 | 7236.0 |
| 2022-05-24 | AAMC-DELISTED | Stock | 2.9882 | 3.0029 | 2.9735 | 2.9735 | 8344.0 |
| 2022-05-24 | AAME | Stock | 2.93 | 2.93 | 2.57 | 2.65 | 7900.0 |
| 2022-05-24 | AAMI | Stock | 19.62 | 19.83 | 18.635 | 19.48 | 429100.0 |
| 2022-05-24 | AAN-DELISTED | Stock | 17.95 | 18.0 | 17.27 | 17.66 | 348200.0 |
| 2022-05-24 | AAOI | Stock | 2.26 | 2.26 | 2.12 | 2.16 | 190300.0 |
| 2022-05-24 | AAON | Stock | 33.9533 | 34.1333 | 32.76 | 33.9933 | 523500.0 |
| 2022-05-24 | AAP | Stock | 175.31 | 182.73 | 172.86 | 180.23 | 2128600.0 |
| 2022-05-24 | AAQC-DELISTED | Stock | 9.76 | 9.76 | 9.74 | 9.74 | 77929.0 |
| 2022-05-24 | AAT | Stock | 32.0 | 32.84 | 31.61 | 32.77 | 168900.0 |
| 2022-05-24 | AATC | Stock | 5.53 | 5.6444 | 5.5 | 5.5 | 21138.0 |
| 2022-05-24 | AAU-DELISTED | Stock | 0.285 | 0.285 | 0.2613 | 0.2747 | 366038.0 |
| 2022-05-24 | AAUAF-DELISTED | Stock | 0.285 | 0.285 | 0.2613 | 0.2747 | 370809.0 |
| 2022-05-24 | AAWW-DELISTED | Stock | 66.65 | 66.73 | 63.29 | 65.8 | 277781.0 |
| 2022-05-24 | AAXJ | Stock | 68.48 | 68.57 | 67.76 | 68.27 | 2921335.0 |
| 2022-05-24 | AB | Stock | 39.77 | 40.06 | 38.74 | 39.63 | 391300.0 |
| 2022-05-24 | ABB-DELISTED | Stock | 30.16 | 30.245 | 29.85 | 30.1 | 3117677.0 |
| 2022-05-24 | ABBNY-DELISTED | Stock | 30.16 | 30.245 | 29.85 | 30.1 | 3371311.0 |
| 2022-05-24 | ABBV | Stock | 147.03 | 151.35 | 146.61 | 149.11 | 6367200.0 |
| 2022-05-24 | ABC-DELISTED | Stock | 153.0 | 153.71 | 150.09 | 153.1 | 654325.0 |
| 2022-05-24 | ABCB | Stock | 43.53 | 43.85 | 42.3 | 43.6 | 275800.0 |
| 2022-05-24 | ABCL | Stock | 7.54 | 7.6 | 7.05 | 7.26 | 1454400.0 |
| 2022-05-24 | ABCM-DELISTED | Stock | 14.1 | 14.23 | 13.87 | 13.99 | 79623.0 |
| 2022-05-24 | ABEO | Stock | 4.0 | 4.25 | 3.75 | 3.75 | 40220.0 |
| 2022-05-24 | ABEV | Stock | 2.87 | 2.9 | 2.83 | 2.89 | 33850900.0 |
| 2022-05-24 | ABG | Stock | 167.19 | 169.04 | 164.13 | 168.84 | 230600.0 |
| 2022-05-24 | ABM | Stock | 45.8 | 46.77 | 45.12 | 46.57 | 331400.0 |
| 2022-05-24 | ABMD-DELISTED | Stock | 244.69 | 249.43 | 242.89 | 249.29 | 235898.0 |
| 2022-05-24 | ABNB | Stock | 111.28 | 111.42 | 103.741 | 106.24 | 6415800.0 |
| 2022-05-24 | ABOS | Stock | 3.4 | 3.46 | 3.26 | 3.37 | 78700.0 |
| 2022-05-24 | ABR | Stock | 16.15 | 16.26 | 15.77 | 16.2 | 2357600.0 |
| 2022-05-24 | ABR.D | Stock | 20.71 | 20.77 | 20.5824 | 20.65 | 15213.0 |
> showing 50 of 7,962 rows — these rows as CSV