PREVIEW / stock_daily / 2005-07-19
file: by_date/stock_daily/2005/2005-07-19.parquet size: 139 KB rows: 4,146 symbols: 2,607
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-19 | AAPL | Stock | 1.4829 | 1.5439 | 1.4668 | 1.5425 | 671062000.0 |
| 2005-07-19 | MSFT | Stock | 25.79 | 26.25 | 25.75 | 26.16 | 113290100.0 |
| 2005-07-19 | NVDA | Stock | 0.2198 | 0.222 | 0.2182 | 0.2215 | 517896000.0 |
| 2005-07-19 | AMZN | Stock | 1.869 | 1.9085 | 1.8345 | 1.9085 | 116812000.0 |
| 2005-07-19 | CL | Stock | 25.85 | 25.895 | 25.615 | 25.715 | 2545000.0 |
| 2005-07-19 | A | Stock | 18.3619 | 18.6552 | 18.2117 | 18.5622 | 2267276.0 |
| 2005-07-19 | AABA-DELISTED | Stock | 37.0200004577637 | 38.0200004577637 | 36.560001373291 | 37.7299995422363 | 32685500.0 |
| 2005-07-19 | AACC-DELISTED | Stock | 24.98 | 25.19 | 24.51 | 25.06 | 84697.0 |
| 2005-07-19 | AACQ-DELISTED | Stock | 4.99 | 4.99 | 4.99 | 4.99 | 1000.0 |
| 2005-07-19 | AACQW-DELISTED | Stock | 0.51 | 0.51 | 0.5 | 0.5 | 12000.0 |
| 2005-07-19 | AAI-DELISTED | Stock | 10.25 | 10.65 | 10.21 | 10.65 | 2501400.0 |
| 2005-07-19 | AAIC-DELISTED | Stock | 294.6 | 297.2 | 293.0 | 295.6 | 1023300.0 |
| 2005-07-19 | AAME | Stock | 3.0 | 3.02 | 3.0 | 3.0 | 16200.0 |
| 2005-07-19 | AAON | Stock | 2.3533 | 2.4955 | 2.3533 | 2.4586 | 182250.0 |
| 2005-07-19 | AAP | Stock | 44.3333 | 44.68 | 43.9667 | 44.6533 | 856950.0 |
| 2005-07-19 | AAV-DELISTED | Stock | 14.8 | 14.89 | 14.65 | 14.8 | 28000.0 |
| 2005-07-19 | AAXN-DELISTED | Stock | 10.1199998855591 | 10.1800003051758 | 9.93000030517578 | 10.0299997329712 | 1726900.0 |
| 2005-07-19 | ABAX-DELISTED | Stock | 10.95 | 11.17 | 10.91 | 11.06 | 63656.0 |
| 2005-07-19 | ABB-DELISTED | Stock | 6.52 | 6.58 | 6.5 | 6.56 | 1117600.0 |
| 2005-07-19 | ABBC-DELISTED | Stock | 11.99 | 12.1 | 11.99 | 12.06 | 14524.0 |
| 2005-07-19 | ABC-DELISTED | Stock | 17.66 | 17.72 | 17.48 | 17.52 | 4272800.0 |
| 2005-07-19 | ABCB | Stock | 18.8011 | 18.8985 | 18.5386 | 18.8985 | 4729.0 |
| 2005-07-19 | ABCO-DELISTED | Stock | 23.65 | 24.15 | 23.65 | 23.95 | 69254.0 |
| 2005-07-19 | ABCW-DELISTED | Stock | 29.98 | 30.34 | 29.77 | 30.34 | 21743.0 |
| 2005-07-19 | ABE-DELISTED | Stock | 10.23 | 10.24 | 10.2 | 10.206 | 15100.0 |
| 2005-07-19 | ABFS-DELISTED | Stock | 34.02 | 34.2 | 33.4 | 33.99 | 208970.0 |
| 2005-07-19 | ABG | Stock | 16.59 | 16.91 | 16.57 | 16.75 | 110900.0 |
| 2005-07-19 | ABK-DELISTED | Stock | 72.92 | 73.24 | 72.6 | 73.24 | 569900.0 |
| 2005-07-19 | ABM | Stock | 19.5 | 19.66 | 19.5 | 19.62 | 219000.0 |
| 2005-07-19 | ABMD-DELISTED | Stock | 8.88 | 9.1698 | 8.88 | 9.08 | 41018.0 |
| 2005-07-19 | ABP-DELISTED | Stock | 3.56 | 3.7 | 3.53 | 3.65 | 232900.0 |
| 2005-07-19 | ABR | Stock | 29.77 | 30.0 | 29.67 | 29.93 | 90200.0 |
| 2005-07-19 | ABT | Stock | 22.3587 | 22.4402 | 22.1955 | 22.2387 | 8056273.0 |
| 2005-07-19 | ABTL-DELISTED | Stock | 22.77 | 24.2 | 22.67 | 24.2 | 36145.0 |
| 2005-07-19 | ABV-DELISTED | Stock | 31.1 | 31.33 | 30.75 | 31.12 | 480300.0 |
| 2005-07-19 | ABVA-DELISTED | Stock | 16.0 | 16.0 | 15.7 | 15.85 | 1927.0 |
| 2005-07-19 | ABVT-DELISTED | Stock | 23.0 | 23.0 | 23.0 | 23.0 | 300.0 |
| 2005-07-19 | ABX-DELISTED | Stock | 23.44 | 23.85 | 23.36 | 23.8 | 1348852.0 |
| 2005-07-19 | ACAD | Stock | 8.83 | 9.34 | 8.83 | 9.27 | 30900.0 |
| 2005-07-19 | ACAP-DELISTED | Stock | 37.8 | 38.98 | 37.7 | 38.79 | 59185.0 |
| 2005-07-19 | ACAS-DELISTED | Stock | 37.3 | 37.62 | 37.3 | 37.51 | 486644.0 |
| 2005-07-19 | ACAT-DELISTED | Stock | 20.4 | 20.87 | 20.27 | 20.6 | 129831.0 |
| 2005-07-19 | ACC-DELISTED | Stock | 23.79 | 23.94 | 23.7 | 23.83 | 76600.0 |
| 2005-07-19 | ACCL-DELISTED | Stock | 5.46 | 5.5 | 5.31 | 5.44 | 107148.0 |
| 2005-07-19 | ACE-DELISTED | Stock | 45.94 | 46.25 | 45.72 | 46.18 | 879600.0 |
| 2005-07-19 | ACF-DELISTED | Stock | 26.89 | 26.94 | 26.56 | 26.74 | 1157700.0 |
| 2005-07-19 | ACFC-DELISTED | Stock | 66.58 | 68.06 | 66.48 | 67.35 | 11113.0 |
| 2005-07-19 | ACG-DELISTED | Stock | 8.31 | 8.33 | 8.28 | 8.29 | 446700.0 |
| 2005-07-19 | ACGL | Stock | 5.0367 | 5.0467 | 4.9944 | 4.9944 | 611100.0 |
| 2005-07-19 | ACGN-DELISTED | Stock | 578.0 | 612.0 | 566.6712 | 612.0 | 171300.0 |
> showing 50 of 4,146 rows — these rows as CSV