PREVIEW / stock_daily / 2005-08-17
file: by_date/stock_daily/2005/2005-08-17.parquet size: 140 KB rows: 4,169 symbols: 2,621
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-17 | AAPL | Stock | 1.6571 | 1.6943 | 1.6561 | 1.6839 | 499724400.0 |
| 2005-08-17 | MSFT | Stock | 26.82 | 27.15 | 26.66 | 26.95 | 52413100.0 |
| 2005-08-17 | NVDA | Stock | 0.2505 | 0.2547 | 0.2503 | 0.2516 | 607572000.0 |
| 2005-08-17 | AMZN | Stock | 2.2095 | 2.2215 | 2.206 | 2.206 | 61008000.0 |
| 2005-08-17 | CL | Stock | 26.15 | 26.21 | 25.925 | 25.95 | 2719400.0 |
| 2005-08-17 | A | Stock | 21.8169 | 22.2818 | 21.8026 | 22.2532 | 7127144.0 |
| 2005-08-17 | AABA-DELISTED | Stock | 34.2999992370605 | 34.7299995422363 | 34.2299995422363 | 34.3899993896484 | 10443700.0 |
| 2005-08-17 | AACC-DELISTED | Stock | 28.2 | 28.24 | 27.5 | 27.61 | 215128.0 |
| 2005-08-17 | AAI-DELISTED | Stock | 10.92 | 11.24 | 10.77 | 11.17 | 1191900.0 |
| 2005-08-17 | AAIC-DELISTED | Stock | 249.8 | 249.8 | 241.0 | 241.8 | 1458800.0 |
| 2005-08-17 | AAME | Stock | 2.81 | 2.94 | 2.75 | 2.87 | 1700.0 |
| 2005-08-17 | AAON | Stock | 2.2123 | 2.3045 | 2.2123 | 2.2637 | 93403.0 |
| 2005-08-17 | AAP | Stock | 42.9733 | 43.8 | 42.54 | 43.7133 | 1380600.0 |
| 2005-08-17 | AATI-DELISTED | Stock | 12.92 | 13.15 | 12.8 | 13.1 | 127186.0 |
| 2005-08-17 | AAV-DELISTED | Stock | 15.29 | 15.75 | 15.2 | 15.29 | 54600.0 |
| 2005-08-17 | AAXN-DELISTED | Stock | 9.43000030517578 | 9.47999954223633 | 9.14999961853027 | 9.21000003814697 | 1266700.0 |
| 2005-08-17 | ABAX-DELISTED | Stock | 10.69 | 10.91 | 10.5 | 10.88 | 69249.0 |
| 2005-08-17 | ABB-DELISTED | Stock | 7.1 | 7.11 | 7.07 | 7.09 | 669400.0 |
| 2005-08-17 | ABBC-DELISTED | Stock | 12.5 | 12.67 | 12.5 | 12.67 | 10400.0 |
| 2005-08-17 | ABC-DELISTED | Stock | 18.1 | 18.3 | 18.1 | 18.16 | 1648400.0 |
| 2005-08-17 | ABCB | Stock | 17.7507 | 18.1008 | 17.7507 | 17.8188 | 11823.0 |
| 2005-08-17 | ABCO-DELISTED | Stock | 25.31 | 25.93 | 25.23 | 25.63 | 159084.0 |
| 2005-08-17 | ABCW-DELISTED | Stock | 30.02 | 30.31 | 30.02 | 30.03 | 38720.0 |
| 2005-08-17 | ABD-DELISTED | Stock | 22.93 | 24.91 | 22.91 | 24.83 | 3827230.0 |
| 2005-08-17 | ABE-DELISTED | Stock | 10.5 | 10.61 | 10.46 | 10.57 | 18700.0 |
| 2005-08-17 | ABFS-DELISTED | Stock | 34.07 | 34.62 | 33.94 | 34.34 | 149540.0 |
| 2005-08-17 | ABG | Stock | 17.98 | 17.98 | 17.56 | 17.57 | 44300.0 |
| 2005-08-17 | ABK-DELISTED | Stock | 68.2 | 68.32 | 67.76 | 68.03 | 643900.0 |
| 2005-08-17 | ABM | Stock | 18.9 | 19.17 | 18.79 | 19.0 | 179800.0 |
| 2005-08-17 | ABMD-DELISTED | Stock | 9.65 | 9.81 | 9.6 | 9.72 | 56323.0 |
| 2005-08-17 | ABP-DELISTED | Stock | 4.4 | 4.41 | 3.8 | 3.88 | 723600.0 |
| 2005-08-17 | ABR | Stock | 27.23 | 27.45 | 27.0 | 27.22 | 118800.0 |
| 2005-08-17 | ABT | Stock | 22.162 | 22.3539 | 22.114 | 22.114 | 4782201.0 |
| 2005-08-17 | ABTL-DELISTED | Stock | 21.78 | 22.03 | 21.52 | 21.62 | 23143.0 |
| 2005-08-17 | ABV-DELISTED | Stock | 32.65 | 33.05 | 32.38 | 32.9 | 383000.0 |
| 2005-08-17 | ABVA-DELISTED | Stock | 16.358 | 16.68 | 16.358 | 16.68 | 1242.0 |
| 2005-08-17 | ABX-DELISTED | Stock | 26.45 | 26.69 | 26.27 | 26.29 | 3191700.0 |
| 2005-08-17 | ACAD | Stock | 8.9 | 8.9 | 8.66 | 8.66 | 51900.0 |
| 2005-08-17 | ACAP-DELISTED | Stock | 43.62 | 44.28 | 42.86 | 44.13 | 105566.0 |
| 2005-08-17 | ACAS-DELISTED | Stock | 38.43 | 38.43 | 36.05 | 37.24 | 1618849.0 |
| 2005-08-17 | ACAT-DELISTED | Stock | 20.69 | 21.18 | 20.69 | 20.95 | 20918.0 |
| 2005-08-17 | ACC-DELISTED | Stock | 24.32 | 24.37 | 24.07 | 24.2 | 41139.0 |
| 2005-08-17 | ACCL-DELISTED | Stock | 5.32 | 5.51 | 5.26 | 5.34 | 39266.0 |
| 2005-08-17 | ACE-DELISTED | Stock | 44.46 | 44.75 | 44.15 | 44.58 | 481100.0 |
| 2005-08-17 | ACF-DELISTED | Stock | 25.14 | 25.18 | 24.93 | 25.0 | 796100.0 |
| 2005-08-17 | ACFC-DELISTED | Stock | 69.87 | 71.25 | 69.41 | 71.2 | 1728.0 |
| 2005-08-17 | ACG-DELISTED | Stock | 8.27 | 8.27 | 8.23 | 8.25 | 367600.0 |
| 2005-08-17 | ACGL | Stock | 5.1233 | 5.1333 | 5.0744 | 5.1256 | 424800.0 |
| 2005-08-17 | ACGN-DELISTED | Stock | 532.6712 | 544.0 | 510.0 | 521.3288 | 30400.0 |
| 2005-08-17 | ACH | Stock | 19.1533 | 19.3333 | 19.0067 | 19.18 | 238950.0 |
> showing 50 of 4,169 rows — these rows as CSV