PREVIEW / stock_daily / 2005-08-22
file: by_date/stock_daily/2005/2005-08-22.parquet size: 140 KB rows: 4,193 symbols: 2,640
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-08-22 | AAPL | Stock | 1.6482 | 1.6696 | 1.6164 | 1.6382 | 387732800.0 |
| 2005-08-22 | MSFT | Stock | 26.79 | 27.17 | 26.77 | 26.91 | 41691700.0 |
| 2005-08-22 | NVDA | Stock | 0.2429 | 0.2468 | 0.2385 | 0.2413 | 547224000.0 |
| 2005-08-22 | AMZN | Stock | 2.1805 | 2.2135 | 2.147 | 2.1885 | 107482000.0 |
| 2005-08-22 | CL | Stock | 26.075 | 26.32 | 26.075 | 26.205 | 3521200.0 |
| 2005-08-22 | A | Stock | 21.7525 | 22.0315 | 21.7525 | 21.9599 | 5358674.0 |
| 2005-08-22 | AABA-DELISTED | Stock | 34.0699996948242 | 34.0999984741211 | 33.0699996948242 | 33.2000007629395 | 21054400.0 |
| 2005-08-22 | AACC-DELISTED | Stock | 28.07 | 28.49 | 27.98 | 28.25 | 93335.0 |
| 2005-08-22 | AAI-DELISTED | Stock | 10.64 | 10.88 | 10.63 | 10.87 | 1211200.0 |
| 2005-08-22 | AAIC-DELISTED | Stock | 227.8 | 230.4 | 221.6 | 229.2 | 3538000.0 |
| 2005-08-22 | AAME | Stock | 3.0 | 3.02 | 3.0 | 3.0 | 1200.0 |
| 2005-08-22 | AAON | Stock | 2.3045 | 2.3045 | 2.265 | 2.2835 | 154912.0 |
| 2005-08-22 | AAP | Stock | 42.7733 | 42.7733 | 41.3467 | 42.1333 | 1430100.0 |
| 2005-08-22 | AATI-DELISTED | Stock | 13.0 | 13.0 | 12.35 | 12.56 | 76404.0 |
| 2005-08-22 | AAV-DELISTED | Stock | 15.97 | 15.98 | 15.82 | 15.97 | 59800.0 |
| 2005-08-22 | AAXN-DELISTED | Stock | 9.13000011444092 | 9.1899995803833 | 9.0 | 9.01000022888184 | 1095400.0 |
| 2005-08-22 | ABAX-DELISTED | Stock | 10.97 | 11.11 | 10.74 | 10.99 | 64611.0 |
| 2005-08-22 | ABB-DELISTED | Stock | 7.23 | 7.26 | 7.19 | 7.21 | 1231100.0 |
| 2005-08-22 | ABBC-DELISTED | Stock | 12.75 | 12.8 | 12.7 | 12.72 | 32669.0 |
| 2005-08-22 | ABC-DELISTED | Stock | 18.0 | 18.2 | 17.95 | 18.15 | 2041200.0 |
| 2005-08-22 | ABCB | Stock | 18.2662 | 18.2662 | 17.8382 | 18.1106 | 17273.0 |
| 2005-08-22 | ABCO-DELISTED | Stock | 25.66 | 25.87 | 25.51 | 25.8 | 73793.0 |
| 2005-08-22 | ABCW-DELISTED | Stock | 30.38 | 30.52 | 30.0 | 30.23 | 47740.0 |
| 2005-08-22 | ABD-DELISTED | Stock | 26.34 | 27.05 | 26.13 | 27.01 | 931550.0 |
| 2005-08-22 | ABE-DELISTED | Stock | 10.53 | 10.57 | 10.48 | 10.52 | 11900.0 |
| 2005-08-22 | ABFS-DELISTED | Stock | 34.45 | 34.55 | 34.0 | 34.26 | 127600.0 |
| 2005-08-22 | ABG | Stock | 17.67 | 17.98 | 17.44 | 17.98 | 197300.0 |
| 2005-08-22 | ABK-DELISTED | Stock | 67.64 | 68.19 | 67.19 | 67.76 | 385800.0 |
| 2005-08-22 | ABM | Stock | 19.19 | 19.37 | 19.04 | 19.36 | 68100.0 |
| 2005-08-22 | ABMD-DELISTED | Stock | 9.4 | 9.56 | 9.28 | 9.55 | 51599.0 |
| 2005-08-22 | ABP-DELISTED | Stock | 4.15 | 4.38 | 4.1 | 4.34 | 470500.0 |
| 2005-08-22 | ABR | Stock | 27.13 | 27.3 | 27.05 | 27.3 | 84500.0 |
| 2005-08-22 | ABT | Stock | 21.994 | 22.1908 | 21.9221 | 22.0516 | 4861609.0 |
| 2005-08-22 | ABTL-DELISTED | Stock | 21.48 | 21.72 | 21.03 | 21.57 | 21177.0 |
| 2005-08-22 | ABV-DELISTED | Stock | 31.67 | 32.03 | 31.57 | 31.93 | 399200.0 |
| 2005-08-22 | ABVA-DELISTED | Stock | 16.25 | 16.38 | 16.1 | 16.25 | 4450.0 |
| 2005-08-22 | ABVT-DELISTED | Stock | 24.0 | 24.0 | 24.0 | 24.0 | 400.0 |
| 2005-08-22 | ABX-DELISTED | Stock | 26.67 | 26.74 | 25.95 | 26.23 | 2913400.0 |
| 2005-08-22 | ACAD | Stock | 8.97 | 9.28 | 8.97 | 9.24 | 63900.0 |
| 2005-08-22 | ACAP-DELISTED | Stock | 44.01 | 44.58 | 43.97 | 44.56 | 65587.0 |
| 2005-08-22 | ACAS-DELISTED | Stock | 37.77 | 38.16 | 37.58 | 38.03 | 666808.0 |
| 2005-08-22 | ACAT-DELISTED | Stock | 21.26 | 21.26 | 20.85 | 21.06 | 39181.0 |
| 2005-08-22 | ACC-DELISTED | Stock | 24.02 | 24.29 | 23.85 | 23.9 | 297300.0 |
| 2005-08-22 | ACCL-DELISTED | Stock | 5.25 | 5.37 | 5.25 | 5.34 | 59049.0 |
| 2005-08-22 | ACCO | Stock | 26.3 | 27.05 | 26.09 | 27.05 | 932800.0 |
| 2005-08-22 | ACE-DELISTED | Stock | 45.32 | 45.81 | 45.0 | 45.3 | 439588.0 |
| 2005-08-22 | ACF-DELISTED | Stock | 25.02 | 25.29 | 24.84 | 24.94 | 1261800.0 |
| 2005-08-22 | ACFC-DELISTED | Stock | 71.74 | 71.74 | 71.48 | 71.74 | 582.0 |
| 2005-08-22 | ACG-DELISTED | Stock | 8.3 | 8.34 | 8.25 | 8.27 | 541700.0 |
| 2005-08-22 | ACGL | Stock | 5.1278 | 5.1667 | 5.1 | 5.1533 | 434700.0 |
> showing 50 of 4,193 rows — these rows as CSV