PREVIEW / stock_daily / 2005-07-14
file: by_date/stock_daily/2005/2005-07-14.parquet size: 138 KB rows: 4,119 symbols: 2,583
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-14 | AAPL | Stock | 1.4568 | 1.5004 | 1.4368 | 1.4554 | 2096060400.0 |
| 2005-07-14 | MSFT | Stock | 25.79 | 26.1 | 25.79 | 25.97 | 69506800.0 |
| 2005-07-14 | NVDA | Stock | 0.2395 | 0.2442 | 0.2262 | 0.2265 | 1871496000.0 |
| 2005-07-14 | AMZN | Stock | 1.8595 | 1.871 | 1.844 | 1.8595 | 117266000.0 |
| 2005-07-14 | CL | Stock | 25.595 | 25.82 | 25.55 | 25.63 | 3109800.0 |
| 2005-07-14 | A | Stock | 18.6338 | 18.7768 | 18.3119 | 18.412 | 2061211.0 |
| 2005-07-14 | AABA-DELISTED | Stock | 37.4000015258789 | 37.5 | 36.7700004577637 | 36.8600006103516 | 14722200.0 |
| 2005-07-14 | AACC-DELISTED | Stock | 24.9 | 24.94 | 24.12 | 24.45 | 96762.0 |
| 2005-07-14 | AACQ-DELISTED | Stock | 4.96 | 4.96 | 4.96 | 4.96 | 2000.0 |
| 2005-07-14 | AACQU-DELISTED | Stock | 5.75 | 5.75 | 5.75 | 5.75 | 2000.0 |
| 2005-07-14 | AACQW-DELISTED | Stock | 0.52 | 0.52 | 0.51 | 0.51 | 4000.0 |
| 2005-07-14 | AAI-DELISTED | Stock | 9.78 | 10.2 | 9.75 | 10.14 | 1678400.0 |
| 2005-07-14 | AAIC-DELISTED | Stock | 302.0 | 307.0 | 301.2 | 305.8 | 943000.0 |
| 2005-07-14 | AAON | Stock | 2.4573 | 2.4639 | 2.344 | 2.3901 | 133650.0 |
| 2005-07-14 | AAP | Stock | 43.8 | 43.9267 | 43.48 | 43.5533 | 957450.0 |
| 2005-07-14 | AAV-DELISTED | Stock | 14.68 | 14.95 | 14.58 | 14.68 | 77300.0 |
| 2005-07-14 | AAXN-DELISTED | Stock | 10.5500001907349 | 10.6199998855591 | 10.1899995803833 | 10.2399997711182 | 2646400.0 |
| 2005-07-14 | ABAX-DELISTED | Stock | 11.32 | 11.45 | 10.91 | 10.91 | 73258.0 |
| 2005-07-14 | ABB-DELISTED | Stock | 6.65 | 6.69 | 6.63 | 6.66 | 515900.0 |
| 2005-07-14 | ABBC-DELISTED | Stock | 11.99 | 12.04 | 11.86 | 11.92 | 5660.0 |
| 2005-07-14 | ABC-DELISTED | Stock | 17.56 | 17.72 | 17.56 | 17.66 | 4174400.0 |
| 2005-07-14 | ABCB | Stock | 19.4529 | 19.4529 | 18.7331 | 18.7331 | 6374.0 |
| 2005-07-14 | ABCO-DELISTED | Stock | 24.26 | 24.41 | 23.75 | 23.93 | 136771.0 |
| 2005-07-14 | ABCW-DELISTED | Stock | 30.7 | 31.0 | 30.08 | 30.1 | 45083.0 |
| 2005-07-14 | ABE-DELISTED | Stock | 10.29 | 10.5 | 10.23 | 10.25 | 29300.0 |
| 2005-07-14 | ABFS-DELISTED | Stock | 34.99 | 35.28 | 34.69 | 34.91 | 372283.0 |
| 2005-07-14 | ABG | Stock | 16.64 | 16.7 | 16.35 | 16.45 | 95400.0 |
| 2005-07-14 | ABK-DELISTED | Stock | 71.5 | 72.49 | 71.47 | 72.41 | 600700.0 |
| 2005-07-14 | ABM | Stock | 19.9 | 19.98 | 19.71 | 19.76 | 112400.0 |
| 2005-07-14 | ABMD-DELISTED | Stock | 9.66 | 9.8 | 9.4 | 9.44 | 76890.0 |
| 2005-07-14 | ABP-DELISTED | Stock | 3.79 | 3.84 | 3.51 | 3.54 | 528800.0 |
| 2005-07-14 | ABR | Stock | 29.78 | 29.78 | 29.35 | 29.36 | 164100.0 |
| 2005-07-14 | ABT | Stock | 22.8433 | 23.0832 | 22.3107 | 22.3683 | 20639642.0 |
| 2005-07-14 | ABTL-DELISTED | Stock | 23.05 | 23.05 | 22.05 | 22.15 | 45890.0 |
| 2005-07-14 | ABV-DELISTED | Stock | 31.7 | 31.79 | 31.39 | 31.45 | 779500.0 |
| 2005-07-14 | ABVA-DELISTED | Stock | 15.6 | 15.616 | 15.5 | 15.5 | 1602.0 |
| 2005-07-14 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 5000.0 |
| 2005-07-14 | ABX-DELISTED | Stock | 24.52 | 24.68 | 24.04 | 24.06 | 1485226.0 |
| 2005-07-14 | ACAD | Stock | 9.07 | 9.09 | 8.91 | 9.04 | 15600.0 |
| 2005-07-14 | ACAP-DELISTED | Stock | 38.22 | 38.35 | 38.02 | 38.05 | 37673.0 |
| 2005-07-14 | ACAS-DELISTED | Stock | 36.93 | 36.96 | 36.76 | 36.84 | 605103.0 |
| 2005-07-14 | ACAT-DELISTED | Stock | 20.42 | 20.55 | 20.22 | 20.25 | 120187.0 |
| 2005-07-14 | ACC-DELISTED | Stock | 23.95 | 24.0 | 23.28 | 23.45 | 147100.0 |
| 2005-07-14 | ACCL-DELISTED | Stock | 5.31 | 5.41 | 5.28 | 5.36 | 98716.0 |
| 2005-07-14 | ACE-DELISTED | Stock | 45.29 | 45.61 | 45.15 | 45.51 | 709100.0 |
| 2005-07-14 | ACF-DELISTED | Stock | 26.38 | 26.51 | 26.09 | 26.43 | 910600.0 |
| 2005-07-14 | ACFC-DELISTED | Stock | 65.05 | 65.48 | 64.8 | 65.15 | 2674.0 |
| 2005-07-14 | ACG-DELISTED | Stock | 8.3 | 8.3 | 8.26 | 8.3 | 315300.0 |
| 2005-07-14 | ACGL | Stock | 5.0278 | 5.0289 | 5.01 | 5.0144 | 772200.0 |
| 2005-07-14 | ACGN-DELISTED | Stock | 612.0 | 634.6712 | 600.6712 | 612.0 | 71400.0 |
> showing 50 of 4,119 rows — these rows as CSV