PREVIEW / stock_daily / 2004-08-09
file: by_date/stock_daily/2004/2004-08-09.parquet size: 126 KB rows: 3,787 symbols: 2,359
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-09 | AAPL | Stock | 0.533 | 0.5438 | 0.5323 | 0.5411 | 290847200.0 |
| 2004-08-09 | MSFT | Stock | 27.26 | 27.28 | 27.1 | 27.18 | 51877500.0 |
| 2004-08-09 | NVDA | Stock | 0.0806 | 0.0839 | 0.0792 | 0.0821 | 1579212000.0 |
| 2004-08-09 | AMZN | Stock | 1.767 | 1.815 | 1.7425 | 1.766 | 183344000.0 |
| 2004-08-09 | CL | Stock | 25.85 | 25.965 | 25.595 | 25.775 | 2684800.0 |
| 2004-08-09 | A | Stock | 15.6438 | 15.8584 | 15.4864 | 15.7368 | 2351995.0 |
| 2004-08-09 | AABA-DELISTED | Stock | 26.2900009155273 | 26.3899993896484 | 25.5200004577637 | 25.7000007629395 | 18997700.0 |
| 2004-08-09 | AACC-DELISTED | Stock | 15.75 | 16.32 | 15.19 | 16.19 | 65167.0 |
| 2004-08-09 | AAI-DELISTED | Stock | 9.67 | 10.0 | 9.45 | 9.69 | 1092800.0 |
| 2004-08-09 | AAIC-DELISTED | Stock | 334.0 | 338.8 | 322.0 | 327.0 | 1123600.0 |
| 2004-08-09 | AAME | Stock | 2.88 | 2.88 | 2.88 | 2.88 | 100.0 |
| 2004-08-09 | AAON | Stock | 2.1083 | 2.132 | 2.0359 | 2.0438 | 200475.0 |
| 2004-08-09 | AAP | Stock | 22.8 | 23.2 | 22.7533 | 22.8867 | 648150.0 |
| 2004-08-09 | AAV-DELISTED | Stock | 14.59 | 15.06 | 14.47 | 14.59 | 25400.0 |
| 2004-08-09 | AAXN-DELISTED | Stock | 13.3400001525879 | 13.6750001907349 | 12.8199996948242 | 13.3149995803833 | 8737400.0 |
| 2004-08-09 | ABAX-DELISTED | Stock | 13.5 | 13.7 | 12.41 | 13.38 | 237145.0 |
| 2004-08-09 | ABB-DELISTED | Stock | 5.27 | 5.39 | 5.27 | 5.28 | 188800.0 |
| 2004-08-09 | ABC-DELISTED | Stock | 13.25 | 13.31 | 13.1 | 13.18 | 2314400.0 |
| 2004-08-09 | ABCB | Stock | 13.9169 | 14.0709 | 13.6656 | 13.6656 | 11474.0 |
| 2004-08-09 | ABCO-DELISTED | Stock | 15.635 | 15.635 | 14.945 | 14.96 | 150237.0 |
| 2004-08-09 | ABCW-DELISTED | Stock | 24.77 | 25.0 | 24.52 | 24.62 | 49770.0 |
| 2004-08-09 | ABE-DELISTED | Stock | 7.6 | 7.66 | 7.6 | 7.65 | 68200.0 |
| 2004-08-09 | ABFS-DELISTED | Stock | 34.15 | 34.61 | 33.93 | 34.27 | 249103.0 |
| 2004-08-09 | ABG | Stock | 13.23 | 13.25 | 12.94 | 13.0 | 35900.0 |
| 2004-08-09 | ABK-DELISTED | Stock | 69.7 | 69.7 | 69.26 | 69.4 | 361000.0 |
| 2004-08-09 | ABM | Stock | 16.82 | 17.1 | 16.8 | 17.1 | 169500.0 |
| 2004-08-09 | ABMD-DELISTED | Stock | 10.68 | 10.68 | 10.056 | 10.09 | 72052.0 |
| 2004-08-09 | ABP-DELISTED | Stock | 1.31 | 1.35 | 1.3 | 1.34 | 68400.0 |
| 2004-08-09 | ABR | Stock | 18.85 | 19.04 | 18.7 | 19.0 | 35600.0 |
| 2004-08-09 | ABT | Stock | 18.4243 | 18.5683 | 18.3811 | 18.4051 | 7684452.0 |
| 2004-08-09 | ABTL-DELISTED | Stock | 31.65 | 32.35 | 30.3 | 32.25 | 53500.0 |
| 2004-08-09 | ABV-DELISTED | Stock | 20.25 | 20.35 | 20.16 | 20.35 | 286800.0 |
| 2004-08-09 | ABVA-DELISTED | Stock | 15.14 | 15.15 | 14.65 | 14.95 | 2450.0 |
| 2004-08-09 | ABX-DELISTED | Stock | 18.86 | 18.89 | 18.57 | 18.76 | 968700.0 |
| 2004-08-09 | ACAD | Stock | 5.07 | 5.3 | 5.06 | 5.15 | 3900.0 |
| 2004-08-09 | ACAP-DELISTED | Stock | 27.25 | 27.48 | 26.74 | 26.99 | 58585.0 |
| 2004-08-09 | ACAS-DELISTED | Stock | 29.89 | 30.38 | 29.87 | 30.27 | 693216.0 |
| 2004-08-09 | ACAT-DELISTED | Stock | 26.17 | 26.51 | 25.92 | 26.24 | 62637.0 |
| 2004-08-09 | ACCL-DELISTED | Stock | 6.02 | 6.46 | 6.02 | 6.35 | 93395.0 |
| 2004-08-09 | ACE-DELISTED | Stock | 38.3 | 38.56 | 38.23 | 38.28 | 782900.0 |
| 2004-08-09 | ACF-DELISTED | Stock | 17.35 | 17.88 | 17.16 | 17.53 | 1269900.0 |
| 2004-08-09 | ACG-DELISTED | Stock | 8.27 | 8.28 | 8.23 | 8.26 | 294100.0 |
| 2004-08-09 | ACGL | Stock | 4.2056 | 4.2322 | 4.1833 | 4.2 | 642600.0 |
| 2004-08-09 | ACGN-DELISTED | Stock | 510.0 | 510.0 | 464.6712 | 476.0 | 47100.0 |
| 2004-08-09 | ACH | Stock | 16.2 | 16.2 | 15.78 | 15.9333 | 166200.0 |
| 2004-08-09 | ACH-DELISTED | Stock | 11.189 | 11.374 | 11.179 | 11.219 | 268386.0 |
| 2004-08-09 | ACLS | Stock | 32.64 | 34.16 | 32.64 | 33.6 | 171100.0 |
| 2004-08-09 | ACO-DELISTED | Stock | 18.65 | 18.98 | 18.53 | 18.67 | 183300.0 |
| 2004-08-09 | ACPW-DELISTED | Stock | 15.15 | 15.55 | 14.0 | 14.2 | 14922.0 |
| 2004-08-09 | ACS-DELISTED | Stock | 49.65 | 50.2 | 49.52 | 49.95 | 599500.0 |
> showing 50 of 3,787 rows — these rows as CSV