PREVIEW / stock_daily / 2005-08-05
file: by_date/stock_daily/2005/2005-08-05.parquet size: 139 KB rows: 4,143 symbols: 2,598
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-05 | AAPL | Stock | 1.5175 | 1.5486 | 1.5007 | 1.5354 | 241931200.0 |
| 2005-08-05 | MSFT | Stock | 27.29 | 27.94 | 27.25 | 27.76 | 82212400.0 |
| 2005-08-05 | NVDA | Stock | 0.2292 | 0.2359 | 0.2277 | 0.2354 | 684096000.0 |
| 2005-08-05 | AMZN | Stock | 2.2625 | 2.2855 | 2.2585 | 2.2635 | 99030000.0 |
| 2005-08-05 | CL | Stock | 26.2 | 26.375 | 26.125 | 26.31 | 2299600.0 |
| 2005-08-05 | A | Stock | 18.5622 | 18.7124 | 18.4692 | 18.505 | 1944059.0 |
| 2005-08-05 | AABA-DELISTED | Stock | 34.0900001525879 | 34.2799987792969 | 33.4900016784668 | 33.5200004577637 | 11873800.0 |
| 2005-08-05 | AACC-DELISTED | Stock | 26.68 | 27.19 | 26.56 | 27.0 | 105707.0 |
| 2005-08-05 | AACQ-DELISTED | Stock | 5.05 | 5.05 | 5.0 | 5.01 | 157500.0 |
| 2005-08-05 | AACQU-DELISTED | Stock | 6.05 | 6.1 | 6.05 | 6.1 | 4000.0 |
| 2005-08-05 | AACQW-DELISTED | Stock | 0.48 | 0.48 | 0.48 | 0.48 | 6000.0 |
| 2005-08-05 | AAI-DELISTED | Stock | 11.2 | 11.36 | 10.85 | 11.0 | 957200.0 |
| 2005-08-05 | AAIC-DELISTED | Stock | 264.0 | 264.2 | 254.0 | 258.0 | 2977700.0 |
| 2005-08-05 | AAME | Stock | 2.92 | 3.01 | 2.91 | 2.99 | 3500.0 |
| 2005-08-05 | AAON | Stock | 2.2993 | 2.2993 | 2.1267 | 2.2255 | 363741.0 |
| 2005-08-05 | AAP | Stock | 46.3533 | 46.44 | 45.92 | 46.2 | 487350.0 |
| 2005-08-05 | AATI-DELISTED | Stock | 11.84 | 11.84 | 10.8 | 11.15 | 1027269.0 |
| 2005-08-05 | AAV-DELISTED | Stock | 15.14 | 15.3 | 15.04 | 15.14 | 61100.0 |
| 2005-08-05 | AAXN-DELISTED | Stock | 9.14999961853027 | 9.27000045776367 | 9.01000022888184 | 9.05000019073486 | 1434200.0 |
| 2005-08-05 | ABAX-DELISTED | Stock | 12.85 | 12.89 | 12.14 | 12.24 | 99247.0 |
| 2005-08-05 | ABB-DELISTED | Stock | 7.13 | 7.13 | 7.06 | 7.09 | 490000.0 |
| 2005-08-05 | ABBC-DELISTED | Stock | 12.85 | 12.99 | 12.85 | 12.9 | 13008.0 |
| 2005-08-05 | ABC-DELISTED | Stock | 17.94 | 18.06 | 17.86 | 18.01 | 2937600.0 |
| 2005-08-05 | ABCB | Stock | 18.6261 | 18.9471 | 18.4997 | 18.5094 | 13777.0 |
| 2005-08-05 | ABCO-DELISTED | Stock | 25.33 | 25.57 | 25.1 | 25.49 | 120453.0 |
| 2005-08-05 | ABCW-DELISTED | Stock | 31.13 | 31.56 | 30.2 | 30.2 | 20430.0 |
| 2005-08-05 | ABE-DELISTED | Stock | 10.58 | 10.64 | 10.33 | 10.35 | 15100.0 |
| 2005-08-05 | ABFS-DELISTED | Stock | 34.6 | 34.85 | 34.18 | 34.24 | 188801.0 |
| 2005-08-05 | ABG | Stock | 17.12 | 17.65 | 17.12 | 17.44 | 134100.0 |
| 2005-08-05 | ABK-DELISTED | Stock | 69.6 | 69.69 | 68.72 | 69.38 | 598600.0 |
| 2005-08-05 | ABM | Stock | 19.4 | 19.56 | 19.16 | 19.5 | 143800.0 |
| 2005-08-05 | ABMD-DELISTED | Stock | 10.28 | 10.43 | 9.95 | 10.39 | 90333.0 |
| 2005-08-05 | ABP-DELISTED | Stock | 4.59 | 4.7 | 4.31 | 4.63 | 437000.0 |
| 2005-08-05 | ABR | Stock | 30.59 | 30.75 | 27.33 | 28.3 | 411600.0 |
| 2005-08-05 | ABT | Stock | 22.5026 | 22.5746 | 22.2867 | 22.3059 | 5758233.0 |
| 2005-08-05 | ABTL-DELISTED | Stock | 27.63 | 28.32 | 27.48 | 27.82 | 38782.0 |
| 2005-08-05 | ABV-DELISTED | Stock | 32.65 | 32.66 | 32.17 | 32.3 | 339100.0 |
| 2005-08-05 | ABVA-DELISTED | Stock | 16.5 | 16.62 | 16.0 | 16.5 | 6302.0 |
| 2005-08-05 | ABX-DELISTED | Stock | 26.18 | 26.18 | 25.91 | 26.1 | 2123100.0 |
| 2005-08-05 | ACAD | Stock | 9.33 | 9.35 | 9.09 | 9.09 | 14000.0 |
| 2005-08-05 | ACAP-DELISTED | Stock | 40.53 | 40.8 | 39.33 | 39.9 | 295862.0 |
| 2005-08-05 | ACAS-DELISTED | Stock | 39.09 | 39.69 | 38.82 | 39.59 | 1152178.0 |
| 2005-08-05 | ACAT-DELISTED | Stock | 21.59 | 21.72 | 20.67 | 20.71 | 80844.0 |
| 2005-08-05 | ACC-DELISTED | Stock | 24.55 | 24.58 | 24.02 | 24.29 | 433400.0 |
| 2005-08-05 | ACCL-DELISTED | Stock | 5.28 | 5.88 | 5.28 | 5.62 | 278865.0 |
| 2005-08-05 | ACE-DELISTED | Stock | 46.3 | 46.32 | 45.63 | 45.7 | 547300.0 |
| 2005-08-05 | ACF-DELISTED | Stock | 26.2 | 26.37 | 25.8 | 25.89 | 1167300.0 |
| 2005-08-05 | ACFC-DELISTED | Stock | 70.66 | 70.66 | 70.0 | 70.26 | 1503.0 |
| 2005-08-05 | ACG-DELISTED | Stock | 8.34 | 8.34 | 8.3 | 8.31 | 286100.0 |
| 2005-08-05 | ACGL | Stock | 5.08 | 5.0878 | 5.0089 | 5.0611 | 493200.0 |
> showing 50 of 4,143 rows — these rows as CSV