PREVIEW / stock_daily / 2004-05-27
file: by_date/stock_daily/2004/2004-05-27.parquet size: 126 KB rows: 3,739 symbols: 2,330
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-05-27 | AAPL | Stock | 0.5082 | 0.5107 | 0.4968 | 0.503 | 235972800.0 |
| 2004-05-27 | MSFT | Stock | 26.16 | 26.19 | 25.92 | 26.19 | 49071900.0 |
| 2004-05-27 | NVDA | Stock | 0.1906 | 0.1934 | 0.1878 | 0.1881 | 556548000.0 |
| 2004-05-27 | AMZN | Stock | 2.2635 | 2.3915 | 2.2425 | 2.381 | 283504000.0 |
| 2004-05-27 | CL | Stock | 28.945 | 29.26 | 28.755 | 28.76 | 3792400.0 |
| 2004-05-27 | A | Stock | 17.9399 | 18.3047 | 17.8827 | 18.176 | 5504066.0 |
| 2004-05-27 | AABA-DELISTED | Stock | 30.4099998474121 | 30.7999992370605 | 30.0 | 30.5599994659424 | 18645100.0 |
| 2004-05-27 | AACC-DELISTED | Stock | 20.02 | 20.22 | 19.8 | 19.99 | 97461.0 |
| 2004-05-27 | AAI-DELISTED | Stock | 14.1 | 14.3 | 13.92 | 14.24 | 1481500.0 |
| 2004-05-27 | AAIC-DELISTED | Stock | 392.0 | 397.0 | 385.4 | 392.4 | 1951600.0 |
| 2004-05-27 | AAME | Stock | 2.69 | 2.91 | 2.69 | 2.9 | 4600.0 |
| 2004-05-27 | AAON | Stock | 2.6298 | 2.6298 | 2.5534 | 2.6166 | 85050.0 |
| 2004-05-27 | AAP | Stock | 28.6667 | 28.82 | 28.2333 | 28.2333 | 506700.0 |
| 2004-05-27 | AAV-DELISTED | Stock | 14.25 | 14.49 | 14.25 | 14.25 | 54200.0 |
| 2004-05-27 | AAXN-DELISTED | Stock | 14.3400001525879 | 14.4449996948242 | 13.7600002288818 | 13.9250001907349 | 5913000.0 |
| 2004-05-27 | ABAX-DELISTED | Stock | 18.05 | 18.96 | 17.73 | 18.82 | 110895.0 |
| 2004-05-27 | ABB-DELISTED | Stock | 5.62 | 5.72 | 5.58 | 5.7 | 133000.0 |
| 2004-05-27 | ABC-DELISTED | Stock | 15.04 | 15.11 | 14.94 | 15.04 | 2700400.0 |
| 2004-05-27 | ABCB | Stock | 15.7406 | 16.0405 | 15.7325 | 16.0162 | 8883.0 |
| 2004-05-27 | ABCO-DELISTED | Stock | 17.09 | 17.185 | 16.645 | 17.0 | 66660.0 |
| 2004-05-27 | ABCW-DELISTED | Stock | 27.05 | 27.06 | 26.4 | 26.68 | 40100.0 |
| 2004-05-27 | ABE-DELISTED | Stock | 7.9 | 8.05 | 7.8 | 7.8 | 31700.0 |
| 2004-05-27 | ABFS-DELISTED | Stock | 29.79 | 30.05 | 29.4 | 30.0 | 172971.0 |
| 2004-05-27 | ABG | Stock | 14.23 | 14.3 | 13.95 | 14.24 | 26000.0 |
| 2004-05-27 | ABK-DELISTED | Stock | 68.5 | 69.18 | 68.5 | 68.98 | 677800.0 |
| 2004-05-27 | ABM | Stock | 19.0 | 19.09 | 18.91 | 19.07 | 147100.0 |
| 2004-05-27 | ABMD-DELISTED | Stock | 12.16 | 13.0 | 12.16 | 13.0 | 211630.0 |
| 2004-05-27 | ABP-DELISTED | Stock | 1.83 | 1.88 | 1.8 | 1.8 | 61200.0 |
| 2004-05-27 | ABR | Stock | 18.94 | 19.0 | 18.9 | 18.98 | 44900.0 |
| 2004-05-27 | ABT | Stock | 19.8157 | 19.9741 | 19.6958 | 19.9357 | 6174448.0 |
| 2004-05-27 | ABTL-DELISTED | Stock | 51.75 | 52.35 | 50.5 | 51.4 | 120900.0 |
| 2004-05-27 | ABV-DELISTED | Stock | 18.0 | 18.46 | 17.95 | 18.42 | 765300.0 |
| 2004-05-27 | ABVA-DELISTED | Stock | 14.75 | 14.79 | 14.73 | 14.74 | 600.0 |
| 2004-05-27 | ABVT-DELISTED | Stock | 31.0 | 31.0 | 31.0 | 31.0 | 100.0 |
| 2004-05-27 | ABX-DELISTED | Stock | 21.0 | 21.24 | 20.9 | 20.99 | 3768700.0 |
| 2004-05-27 | ACAP-DELISTED | Stock | 22.76 | 23.37 | 22.3 | 22.38 | 44484.0 |
| 2004-05-27 | ACAS-DELISTED | Stock | 27.23 | 27.26 | 26.53 | 26.63 | 839588.0 |
| 2004-05-27 | ACAT-DELISTED | Stock | 23.18 | 23.18 | 22.22 | 22.91 | 142256.0 |
| 2004-05-27 | ACCL-DELISTED | Stock | 10.3 | 10.5 | 9.71 | 9.88 | 93343.0 |
| 2004-05-27 | ACE-DELISTED | Stock | 41.9 | 41.9 | 41.42 | 41.5 | 1024200.0 |
| 2004-05-27 | ACF-DELISTED | Stock | 18.0 | 18.0 | 17.57 | 17.83 | 982300.0 |
| 2004-05-27 | ACG-DELISTED | Stock | 8.0 | 8.07 | 8.0 | 8.04 | 392800.0 |
| 2004-05-27 | ACGL | Stock | 4.2567 | 4.3056 | 4.1944 | 4.2922 | 1367100.0 |
| 2004-05-27 | ACGN-DELISTED | Stock | 623.3288 | 702.6712 | 623.3288 | 691.3288 | 281600.0 |
| 2004-05-27 | ACH | Stock | 16.5333 | 16.5333 | 15.9867 | 16.1933 | 340650.0 |
| 2004-05-27 | ACH-DELISTED | Stock | 14.414 | 14.521 | 14.201 | 14.456 | 602070.0 |
| 2004-05-27 | ACLS | Stock | 48.76 | 50.76 | 47.76 | 48.72 | 415400.0 |
| 2004-05-27 | ACO-DELISTED | Stock | 17.15 | 17.48 | 16.8 | 17.07 | 114100.0 |
| 2004-05-27 | ACPW-DELISTED | Stock | 17.65 | 17.85 | 16.6 | 17.6 | 21317.0 |
| 2004-05-27 | ACS-DELISTED | Stock | 49.4 | 49.85 | 48.85 | 49.76 | 1160900.0 |
> showing 50 of 3,739 rows — these rows as CSV