PREVIEW / stock_daily / 2004-07-28
file: by_date/stock_daily/2004/2004-07-28.parquet size: 126 KB rows: 3,768 symbols: 2,347
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-07-28 | AAPL | Stock | 0.577 | 0.5788 | 0.5564 | 0.5763 | 285051200.0 |
| 2004-07-28 | MSFT | Stock | 28.34 | 28.79 | 28.28 | 28.58 | 62718800.0 |
| 2004-07-28 | NVDA | Stock | 0.1221 | 0.1225 | 0.1158 | 0.1192 | 505116000.0 |
| 2004-07-28 | AMZN | Stock | 1.9645 | 1.9785 | 1.869 | 1.8985 | 203672000.0 |
| 2004-07-28 | CL | Stock | 26.42 | 26.8 | 26.245 | 26.725 | 4924000.0 |
| 2004-07-28 | A | Stock | 16.5236 | 16.6381 | 16.1874 | 16.3162 | 5490365.0 |
| 2004-07-28 | AABA-DELISTED | Stock | 29.7900009155273 | 30.3799991607666 | 28.8600006103516 | 29.7000007629395 | 24592700.0 |
| 2004-07-28 | AACC-DELISTED | Stock | 16.19 | 16.56 | 15.78 | 16.05 | 39227.0 |
| 2004-07-28 | AAI-DELISTED | Stock | 11.29 | 11.29 | 10.67 | 10.94 | 1990900.0 |
| 2004-07-28 | AAIC-DELISTED | Stock | 323.0 | 329.8 | 317.6 | 317.8 | 3180600.0 |
| 2004-07-28 | AAME | Stock | 2.8 | 2.95 | 2.8 | 2.95 | 400.0 |
| 2004-07-28 | AAON | Stock | 2.344 | 2.373 | 2.2927 | 2.3243 | 336403.0 |
| 2004-07-28 | AAP | Stock | 24.2 | 24.24 | 23.7933 | 23.96 | 1330950.0 |
| 2004-07-28 | AAV-DELISTED | Stock | 14.69 | 14.73 | 14.45 | 14.69 | 32100.0 |
| 2004-07-28 | AAXN-DELISTED | Stock | 16.0699996948242 | 16.6000003814697 | 15.3249998092651 | 16.0400009155273 | 32175200.0 |
| 2004-07-28 | ABAX-DELISTED | Stock | 15.0 | 15.0 | 14.47 | 14.74 | 180538.0 |
| 2004-07-28 | ABB-DELISTED | Stock | 5.06 | 5.15 | 5.03 | 5.13 | 216700.0 |
| 2004-07-28 | ABC-DELISTED | Stock | 13.36 | 13.4 | 13.12 | 13.24 | 3476800.0 |
| 2004-07-28 | ABCB | Stock | 14.5005 | 14.5815 | 14.2006 | 14.2006 | 13941.0 |
| 2004-07-28 | ABCO-DELISTED | Stock | 15.125 | 15.505 | 14.975 | 15.27 | 216194.0 |
| 2004-07-28 | ABCW-DELISTED | Stock | 25.9 | 25.98 | 25.25 | 25.44 | 44100.0 |
| 2004-07-28 | ABE-DELISTED | Stock | 7.55 | 7.6 | 7.55 | 7.59 | 13500.0 |
| 2004-07-28 | ABFS-DELISTED | Stock | 34.5 | 34.5 | 33.64 | 34.15 | 329807.0 |
| 2004-07-28 | ABG | Stock | 14.02 | 14.26 | 13.24 | 14.21 | 77600.0 |
| 2004-07-28 | ABK-DELISTED | Stock | 70.74 | 71.18 | 70.12 | 70.56 | 501800.0 |
| 2004-07-28 | ABM | Stock | 18.17 | 18.28 | 17.6 | 18.03 | 96600.0 |
| 2004-07-28 | ABMD-DELISTED | Stock | 9.72 | 9.72 | 9.2 | 9.44 | 58662.0 |
| 2004-07-28 | ABP-DELISTED | Stock | 1.26 | 1.35 | 1.25 | 1.31 | 76000.0 |
| 2004-07-28 | ABR | Stock | 18.93 | 18.99 | 18.5 | 18.6 | 138200.0 |
| 2004-07-28 | ABT | Stock | 18.7122 | 18.7986 | 18.3619 | 18.7362 | 5865777.0 |
| 2004-07-28 | ABTL-DELISTED | Stock | 34.6 | 34.75 | 32.5 | 33.3 | 58900.0 |
| 2004-07-28 | ABV-DELISTED | Stock | 20.22 | 20.55 | 20.14 | 20.45 | 342200.0 |
| 2004-07-28 | ABVT-DELISTED | Stock | 29.0 | 29.0 | 29.0 | 29.0 | 100.0 |
| 2004-07-28 | ABX-DELISTED | Stock | 18.8 | 18.8 | 18.52 | 18.59 | 3051100.0 |
| 2004-07-28 | ACAD | Stock | 6.15 | 6.3 | 6.15 | 6.29 | 33500.0 |
| 2004-07-28 | ACAP-DELISTED | Stock | 23.24 | 24.12 | 23.24 | 23.8 | 14019.0 |
| 2004-07-28 | ACAS-DELISTED | Stock | 28.51 | 29.0 | 28.47 | 28.96 | 322261.0 |
| 2004-07-28 | ACAT-DELISTED | Stock | 26.61 | 27.9 | 26.58 | 27.37 | 83683.0 |
| 2004-07-28 | ACCL-DELISTED | Stock | 7.35 | 7.36 | 6.75 | 7.14 | 156641.0 |
| 2004-07-28 | ACE-DELISTED | Stock | 39.57 | 40.79 | 39.57 | 39.91 | 2007400.0 |
| 2004-07-28 | ACF-DELISTED | Stock | 19.07 | 19.25 | 18.56 | 18.9 | 922300.0 |
| 2004-07-28 | ACG-DELISTED | Stock | 8.15 | 8.18 | 8.12 | 8.16 | 348800.0 |
| 2004-07-28 | ACGL | Stock | 4.1111 | 4.1467 | 4.0833 | 4.1267 | 1161000.0 |
| 2004-07-28 | ACGN-DELISTED | Stock | 532.6712 | 555.3288 | 510.0 | 555.3288 | 47000.0 |
| 2004-07-28 | ACH | Stock | 17.0733 | 17.48 | 16.98 | 17.26 | 291600.0 |
| 2004-07-28 | ACH-DELISTED | Stock | 12.987 | 13.232 | 12.822 | 13.194 | 514223.0 |
| 2004-07-28 | ACLS | Stock | 35.6 | 35.84 | 33.16 | 33.16 | 745175.0 |
| 2004-07-28 | ACO-DELISTED | Stock | 18.5 | 19.1 | 18.27 | 18.93 | 120100.0 |
| 2004-07-28 | ACPW-DELISTED | Stock | 13.5 | 14.85 | 12.65 | 14.5 | 31296.0 |
| 2004-07-28 | ACS-DELISTED | Stock | 53.4 | 53.54 | 51.93 | 52.66 | 678500.0 |
> showing 50 of 3,768 rows — these rows as CSV