PREVIEW / stock_daily / 2004-08-27
file: by_date/stock_daily/2004/2004-08-27.parquet size: 127 KB rows: 3,797 symbols: 2,362
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-27 | AAPL | Stock | 0.6193 | 0.6207 | 0.6071 | 0.6134 | 388813600.0 |
| 2004-08-27 | MSFT | Stock | 27.5 | 27.65 | 27.45 | 27.46 | 33248700.0 |
| 2004-08-27 | NVDA | Stock | 0.1059 | 0.1093 | 0.1058 | 0.1078 | 565128000.0 |
| 2004-08-27 | AMZN | Stock | 2.016 | 2.0195 | 1.98 | 1.995 | 84808000.0 |
| 2004-08-27 | CL | Stock | 26.935 | 27.025 | 26.865 | 26.975 | 1384600.0 |
| 2004-08-27 | A | Stock | 15.5007 | 15.6152 | 15.422 | 15.4793 | 1972298.0 |
| 2004-08-27 | AABA-DELISTED | Stock | 29.4300003051758 | 29.5699996948242 | 29.1900005340576 | 29.2999992370605 | 8327500.0 |
| 2004-08-27 | AACC-DELISTED | Stock | 18.17 | 18.59 | 18.0 | 18.25 | 54189.0 |
| 2004-08-27 | AAI-DELISTED | Stock | 12.25 | 12.25 | 11.97 | 12.15 | 1530700.0 |
| 2004-08-27 | AAIC-DELISTED | Stock | 364.0 | 375.2 | 360.0 | 372.2 | 1141800.0 |
| 2004-08-27 | AAME | Stock | 3.0 | 3.0 | 2.95 | 3.0 | 10000.0 |
| 2004-08-27 | AAON | Stock | 2.2677 | 2.3045 | 2.2413 | 2.3045 | 32653.0 |
| 2004-08-27 | AAP | Stock | 25.0467 | 25.0533 | 24.5733 | 24.8467 | 2359650.0 |
| 2004-08-27 | AAV-DELISTED | Stock | 14.9 | 14.99 | 14.84 | 14.9 | 33700.0 |
| 2004-08-27 | AAXN-DELISTED | Stock | 14.3999996185303 | 14.4049997329712 | 13.8249998092651 | 13.9200000762939 | 5175200.0 |
| 2004-08-27 | ABAX-DELISTED | Stock | 14.75 | 15.53 | 14.68 | 15.5 | 163948.0 |
| 2004-08-27 | ABB-DELISTED | Stock | 5.68 | 5.75 | 5.66 | 5.7 | 134000.0 |
| 2004-08-27 | ABC-DELISTED | Stock | 13.42 | 13.6 | 13.4 | 13.5 | 2015600.0 |
| 2004-08-27 | ABCB | Stock | 14.9058 | 14.9382 | 14.7031 | 14.7842 | 3208.0 |
| 2004-08-27 | ABCO-DELISTED | Stock | 15.64 | 15.875 | 15.63 | 15.85 | 148658.0 |
| 2004-08-27 | ABCW-DELISTED | Stock | 25.68 | 25.89 | 25.52 | 25.87 | 40110.0 |
| 2004-08-27 | ABE-DELISTED | Stock | 7.59 | 7.7 | 7.58 | 7.69 | 13800.0 |
| 2004-08-27 | ABFS-DELISTED | Stock | 35.29 | 35.5 | 35.14 | 35.25 | 136184.0 |
| 2004-08-27 | ABG | Stock | 13.55 | 13.95 | 13.5 | 13.82 | 28400.0 |
| 2004-08-27 | ABK-DELISTED | Stock | 75.05 | 75.2 | 74.65 | 74.9 | 328400.0 |
| 2004-08-27 | ABM | Stock | 17.95 | 18.3 | 17.85 | 18.26 | 47600.0 |
| 2004-08-27 | ABMD-DELISTED | Stock | 10.39 | 10.39 | 10.16 | 10.2 | 38743.0 |
| 2004-08-27 | ABP-DELISTED | Stock | 1.58 | 1.67 | 1.56 | 1.59 | 35800.0 |
| 2004-08-27 | ABR | Stock | 20.36 | 20.53 | 20.27 | 20.5 | 10100.0 |
| 2004-08-27 | ABT | Stock | 19.7582 | 19.9549 | 19.7486 | 19.9165 | 4437891.0 |
| 2004-08-27 | ABTL-DELISTED | Stock | 34.0 | 35.3 | 33.25 | 35.1 | 32500.0 |
| 2004-08-27 | ABV-DELISTED | Stock | 21.5 | 21.6 | 21.35 | 21.35 | 180700.0 |
| 2004-08-27 | ABVA-DELISTED | Stock | 14.45 | 14.96 | 14.45 | 14.93 | 1230.0 |
| 2004-08-27 | ABVT-DELISTED | Stock | 24.0 | 24.5 | 24.0 | 24.0 | 10100.0 |
| 2004-08-27 | ABX-DELISTED | Stock | 19.7 | 19.98 | 19.58 | 19.98 | 1500101.0 |
| 2004-08-27 | ACAD | Stock | 5.81 | 5.98 | 5.81 | 5.91 | 6600.0 |
| 2004-08-27 | ACAP-DELISTED | Stock | 27.42 | 27.59 | 27.25 | 27.42 | 80445.0 |
| 2004-08-27 | ACAS-DELISTED | Stock | 31.53 | 31.87 | 31.43 | 31.71 | 369837.0 |
| 2004-08-27 | ACAT-DELISTED | Stock | 25.83 | 26.06 | 25.72 | 25.81 | 32371.0 |
| 2004-08-27 | ACC-DELISTED | Stock | 17.3 | 17.59 | 17.3 | 17.59 | 38100.0 |
| 2004-08-27 | ACCL-DELISTED | Stock | 6.28 | 6.51 | 6.17 | 6.25 | 61638.0 |
| 2004-08-27 | ACE-DELISTED | Stock | 38.91 | 39.14 | 38.81 | 39.03 | 652800.0 |
| 2004-08-27 | ACF-DELISTED | Stock | 21.16 | 21.29 | 21.0 | 21.15 | 595200.0 |
| 2004-08-27 | ACG-DELISTED | Stock | 8.1 | 8.13 | 8.07 | 8.1 | 455500.0 |
| 2004-08-27 | ACGL | Stock | 4.0389 | 4.04 | 4.0144 | 4.0144 | 941400.0 |
| 2004-08-27 | ACGN-DELISTED | Stock | 612.0 | 612.0 | 578.0 | 600.6712 | 120200.0 |
| 2004-08-27 | ACH | Stock | 16.4133 | 16.5133 | 16.3 | 16.4333 | 101250.0 |
| 2004-08-27 | ACH-DELISTED | Stock | 12.328 | 12.491 | 12.253 | 12.471 | 242974.0 |
| 2004-08-27 | ACLS | Stock | 33.2 | 33.88 | 32.84 | 33.0 | 245225.0 |
| 2004-08-27 | ACO-DELISTED | Stock | 16.99 | 17.34 | 16.97 | 17.3 | 59900.0 |
> showing 50 of 3,797 rows — these rows as CSV