PREVIEW / stock_daily / 2004-09-28
file: by_date/stock_daily/2004/2004-09-28.parquet size: 128 KB rows: 3,825 symbols: 2,390
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-09-28 | AAPL | Stock | 0.6689 | 0.6838 | 0.6688 | 0.6793 | 353186400.0 |
| 2004-09-28 | MSFT | Stock | 27.21 | 27.36 | 27.04 | 27.27 | 62055100.0 |
| 2004-09-28 | NVDA | Stock | 0.1147 | 0.1177 | 0.1132 | 0.1167 | 474840000.0 |
| 2004-09-28 | AMZN | Stock | 2.0075 | 2.0165 | 1.9485 | 1.9715 | 238058000.0 |
| 2004-09-28 | CL | Stock | 22.65 | 22.825 | 22.6 | 22.675 | 12249600.0 |
| 2004-09-28 | A | Stock | 15.3076 | 15.3433 | 14.9928 | 15.2289 | 2758394.0 |
| 2004-09-28 | AABA-DELISTED | Stock | 32.2700004577637 | 33.0 | 31.6700000762939 | 32.7999992370605 | 18218200.0 |
| 2004-09-28 | AACC-DELISTED | Stock | 16.97 | 17.14 | 16.87 | 17.09 | 43644.0 |
| 2004-09-28 | AAI-DELISTED | Stock | 9.7 | 10.16 | 9.37 | 10.06 | 1905900.0 |
| 2004-09-28 | AAIC-DELISTED | Stock | 386.0 | 387.6 | 378.0 | 383.0 | 1503300.0 |
| 2004-09-28 | AAME | Stock | 3.0 | 3.18 | 3.0 | 3.0 | 6600.0 |
| 2004-09-28 | AAON | Stock | 2.3058 | 2.348 | 2.265 | 2.2716 | 170100.0 |
| 2004-09-28 | AAP | Stock | 23.2 | 23.5133 | 23.1467 | 23.4733 | 1495950.0 |
| 2004-09-28 | AAV-DELISTED | Stock | 16.84 | 16.85 | 16.64 | 16.84 | 20400.0 |
| 2004-09-28 | AAXN-DELISTED | Stock | 19.0699996948242 | 19.1949996948242 | 18.0 | 18.25 | 13280600.0 |
| 2004-09-28 | ABAX-DELISTED | Stock | 13.15 | 13.34 | 12.83 | 13.22 | 143933.0 |
| 2004-09-28 | ABB-DELISTED | Stock | 6.01 | 6.22 | 5.99 | 6.1 | 318100.0 |
| 2004-09-28 | ABC-DELISTED | Stock | 13.64 | 13.67 | 13.53 | 13.6 | 3032400.0 |
| 2004-09-28 | ABCB | Stock | 15.9352 | 16.2026 | 15.6676 | 16.1864 | 18506.0 |
| 2004-09-28 | ABCO-DELISTED | Stock | 16.373 | 16.747 | 16.273 | 16.722 | 109388.0 |
| 2004-09-28 | ABCW-DELISTED | Stock | 25.66 | 25.67 | 25.36 | 25.66 | 34950.0 |
| 2004-09-28 | ABE-DELISTED | Stock | 7.81 | 7.94 | 7.8 | 7.93 | 12500.0 |
| 2004-09-28 | ABFS-DELISTED | Stock | 35.79 | 36.09 | 35.36 | 35.86 | 162808.0 |
| 2004-09-28 | ABG | Stock | 12.8 | 12.95 | 12.55 | 12.9 | 219200.0 |
| 2004-09-28 | ABK-DELISTED | Stock | 77.02 | 77.04 | 76.4 | 76.7 | 283800.0 |
| 2004-09-28 | ABM | Stock | 19.91 | 20.4 | 19.91 | 20.12 | 108700.0 |
| 2004-09-28 | ABMD-DELISTED | Stock | 8.9 | 9.11 | 8.63 | 9.01 | 175744.0 |
| 2004-09-28 | ABP-DELISTED | Stock | 2.3 | 2.36 | 2.27 | 2.35 | 211400.0 |
| 2004-09-28 | ABR | Stock | 20.85 | 21.17 | 20.83 | 21.17 | 23600.0 |
| 2004-09-28 | ABT | Stock | 20.2955 | 20.5354 | 20.2188 | 20.3963 | 7473114.0 |
| 2004-09-28 | ABTL-DELISTED | Stock | 42.05 | 44.65 | 42.05 | 44.35 | 64600.0 |
| 2004-09-28 | ABV-DELISTED | Stock | 22.08 | 22.57 | 21.9 | 22.49 | 250300.0 |
| 2004-09-28 | ABVA-DELISTED | Stock | 14.9 | 14.99 | 14.9 | 14.99 | 7149.0 |
| 2004-09-28 | ABVT-DELISTED | Stock | 23.0 | 24.0 | 23.0 | 24.0 | 500.0 |
| 2004-09-28 | ABX-DELISTED | Stock | 20.28 | 20.5 | 20.24 | 20.26 | 2672078.0 |
| 2004-09-28 | ACAD | Stock | 7.39 | 7.9 | 7.23 | 7.23 | 19800.0 |
| 2004-09-28 | ACAP-DELISTED | Stock | 30.15 | 30.15 | 29.6 | 29.85 | 40776.0 |
| 2004-09-28 | ACAS-DELISTED | Stock | 31.37 | 31.58 | 31.28 | 31.55 | 898773.0 |
| 2004-09-28 | ACAT-DELISTED | Stock | 25.86 | 26.29 | 25.78 | 26.0 | 81108.0 |
| 2004-09-28 | ACC-DELISTED | Stock | 18.45 | 18.61 | 18.44 | 18.6 | 159870.0 |
| 2004-09-28 | ACCL-DELISTED | Stock | 5.74 | 5.86 | 5.55 | 5.75 | 107034.0 |
| 2004-09-28 | ACE-DELISTED | Stock | 38.16 | 39.11 | 38.15 | 38.97 | 1367800.0 |
| 2004-09-28 | ACF-DELISTED | Stock | 21.16 | 21.35 | 20.94 | 21.33 | 1217600.0 |
| 2004-09-28 | ACG-DELISTED | Stock | 8.17 | 8.19 | 8.15 | 8.19 | 282800.0 |
| 2004-09-28 | ACGL | Stock | 4.18 | 4.2189 | 4.18 | 4.1911 | 542700.0 |
| 2004-09-28 | ACGN-DELISTED | Stock | 748.0 | 770.6712 | 714.0 | 748.0 | 138500.0 |
| 2004-09-28 | ACH | Stock | 16.4667 | 16.48 | 16.2533 | 16.3333 | 159300.0 |
| 2004-09-28 | ACH-DELISTED | Stock | 15.195 | 15.896 | 15.123 | 15.856 | 876766.0 |
| 2004-09-28 | ACLS | Stock | 31.6 | 31.96 | 30.6 | 31.96 | 184900.0 |
| 2004-09-28 | ACO-DELISTED | Stock | 18.01 | 19.08 | 18.01 | 18.9 | 150000.0 |
> showing 50 of 3,825 rows — these rows as CSV