PREVIEW / stock_daily / 2005-07-26
file: by_date/stock_daily/2005/2005-07-26.parquet size: 139 KB rows: 4,164 symbols: 2,620
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-26 | AAPL | Stock | 1.5718 | 1.5754 | 1.5486 | 1.5582 | 268592800.0 |
| 2005-07-26 | MSFT | Stock | 25.72 | 25.74 | 25.53 | 25.54 | 51476400.0 |
| 2005-07-26 | NVDA | Stock | 0.2156 | 0.2213 | 0.2147 | 0.221 | 759492000.0 |
| 2005-07-26 | AMZN | Stock | 1.911 | 1.9375 | 1.886 | 1.887 | 295646000.0 |
| 2005-07-26 | CL | Stock | 25.89 | 26.115 | 25.84 | 25.875 | 4318200.0 |
| 2005-07-26 | A | Stock | 18.3119 | 18.7339 | 18.3119 | 18.5837 | 2810679.0 |
| 2005-07-26 | AABA-DELISTED | Stock | 34.0499992370605 | 34.2999992370605 | 33.9099998474121 | 34.1500015258789 | 16819200.0 |
| 2005-07-26 | AACC-DELISTED | Stock | 24.78 | 24.79 | 24.4901 | 24.59 | 62977.0 |
| 2005-07-26 | AACQ-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 9300.0 |
| 2005-07-26 | AACQU-DELISTED | Stock | 5.8 | 5.82 | 5.8 | 5.8 | 6300.0 |
| 2005-07-26 | AACQW-DELISTED | Stock | 0.51 | 0.51 | 0.51 | 0.51 | 10000.0 |
| 2005-07-26 | AAI-DELISTED | Stock | 10.8 | 11.49 | 10.5 | 11.2 | 2660100.0 |
| 2005-07-26 | AAIC-DELISTED | Stock | 293.2 | 293.2 | 287.0 | 291.0 | 919500.0 |
| 2005-07-26 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 700.0 |
| 2005-07-26 | AAON | Stock | 2.4691 | 2.5534 | 2.4652 | 2.5455 | 44044.0 |
| 2005-07-26 | AAP | Stock | 43.9867 | 44.1467 | 43.5667 | 43.9267 | 902850.0 |
| 2005-07-26 | AAV-DELISTED | Stock | 15.06 | 15.12 | 14.84 | 15.06 | 62000.0 |
| 2005-07-26 | AAXN-DELISTED | Stock | 9.65999984741211 | 9.72000026702881 | 9.5600004196167 | 9.57999992370605 | 868100.0 |
| 2005-07-26 | ABAX-DELISTED | Stock | 12.29 | 12.75 | 12.29 | 12.55 | 123888.0 |
| 2005-07-26 | ABB-DELISTED | Stock | 6.45 | 6.52 | 6.4 | 6.51 | 438300.0 |
| 2005-07-26 | ABBC-DELISTED | Stock | 12.5 | 12.75 | 12.29 | 12.75 | 20719.0 |
| 2005-07-26 | ABC-DELISTED | Stock | 17.38 | 17.64 | 17.36 | 17.57 | 3841600.0 |
| 2005-07-26 | ABCB | Stock | 19.0637 | 19.268 | 18.8498 | 19.1514 | 6991.0 |
| 2005-07-26 | ABCO-DELISTED | Stock | 24.58 | 25.11 | 24.51 | 25.0 | 265595.0 |
| 2005-07-26 | ABCW-DELISTED | Stock | 31.96 | 32.24 | 31.39 | 32.13 | 28133.0 |
| 2005-07-26 | ABE-DELISTED | Stock | 10.36 | 10.47 | 10.29 | 10.3 | 11200.0 |
| 2005-07-26 | ABFS-DELISTED | Stock | 34.8 | 35.13 | 34.37 | 34.59 | 464333.0 |
| 2005-07-26 | ABG | Stock | 16.81 | 17.0 | 16.68 | 16.92 | 106000.0 |
| 2005-07-26 | ABK-DELISTED | Stock | 71.3 | 71.97 | 70.76 | 71.48 | 879700.0 |
| 2005-07-26 | ABM | Stock | 19.75 | 19.95 | 19.59 | 19.79 | 139300.0 |
| 2005-07-26 | ABMD-DELISTED | Stock | 9.68 | 9.74 | 9.5 | 9.69 | 48163.0 |
| 2005-07-26 | ABP-DELISTED | Stock | 4.25 | 4.3 | 4.1 | 4.17 | 567500.0 |
| 2005-07-26 | ABR | Stock | 29.91 | 30.15 | 29.7 | 30.15 | 64900.0 |
| 2005-07-26 | ABT | Stock | 21.8981 | 22.0708 | 21.7445 | 21.9461 | 6768445.0 |
| 2005-07-26 | ABTL-DELISTED | Stock | 23.85 | 24.45 | 23.45 | 23.55 | 20144.0 |
| 2005-07-26 | ABV-DELISTED | Stock | 29.3 | 30.24 | 28.99 | 29.78 | 254100.0 |
| 2005-07-26 | ABVA-DELISTED | Stock | 15.55 | 15.8 | 15.55 | 15.61 | 2400.0 |
| 2005-07-26 | ABX-DELISTED | Stock | 24.5 | 24.5 | 24.15 | 24.32 | 1759000.0 |
| 2005-07-26 | ACAD | Stock | 9.35 | 9.75 | 9.35 | 9.49 | 66600.0 |
| 2005-07-26 | ACAP-DELISTED | Stock | 38.42 | 38.93 | 38.32 | 38.75 | 14638.0 |
| 2005-07-26 | ACAS-DELISTED | Stock | 37.58 | 37.66 | 37.35 | 37.49 | 377458.0 |
| 2005-07-26 | ACAT-DELISTED | Stock | 21.39 | 21.42 | 20.34 | 20.78 | 100943.0 |
| 2005-07-26 | ACC-DELISTED | Stock | 23.85 | 24.3 | 23.85 | 24.16 | 235700.0 |
| 2005-07-26 | ACCL-DELISTED | Stock | 5.58 | 5.7 | 5.49 | 5.58 | 83344.0 |
| 2005-07-26 | ACE-DELISTED | Stock | 46.2 | 46.2 | 45.18 | 45.75 | 1583400.0 |
| 2005-07-26 | ACF-DELISTED | Stock | 26.82 | 26.99 | 26.76 | 26.94 | 555000.0 |
| 2005-07-26 | ACFC-DELISTED | Stock | 68.88 | 69.49 | 68.57 | 69.03 | 3394.0 |
| 2005-07-26 | ACG-DELISTED | Stock | 8.32 | 8.34 | 8.31 | 8.34 | 340900.0 |
| 2005-07-26 | ACGL | Stock | 4.93 | 5.0344 | 4.9233 | 5.0178 | 921600.0 |
| 2005-07-26 | ACGN-DELISTED | Stock | 578.0 | 600.6712 | 555.3288 | 600.6712 | 51900.0 |
> showing 50 of 4,164 rows — these rows as CSV