PREVIEW / stock_daily / 2004-11-05
file: by_date/stock_daily/2004/2004-11-05.parquet size: 132 KB rows: 3,915 symbols: 2,457
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-11-05 | AAPL | Stock | 0.9796 | 0.9821 | 0.9293 | 0.9771 | 1205047200.0 |
| 2004-11-05 | MSFT | Stock | 29.21 | 29.36 | 29.03 | 29.31 | 95337700.0 |
| 2004-11-05 | NVDA | Stock | 0.1483 | 0.1564 | 0.1453 | 0.147 | 3849012000.0 |
| 2004-11-05 | AMZN | Stock | 1.865 | 1.8695 | 1.801 | 1.828 | 147982000.0 |
| 2004-11-05 | CL | Stock | 23.35 | 23.555 | 23.3 | 23.455 | 4823600.0 |
| 2004-11-05 | A | Stock | 17.8112 | 18.226 | 17.7611 | 18.0329 | 3431251.0 |
| 2004-11-05 | AABA-DELISTED | Stock | 37.6800003051758 | 37.8499984741211 | 35.7599983215332 | 36.3499984741211 | 25428100.0 |
| 2004-11-05 | AACC-DELISTED | Stock | 17.9 | 18.49 | 17.83 | 18.03 | 36511.0 |
| 2004-11-05 | AAI-DELISTED | Stock | 12.75 | 13.0 | 12.65 | 12.74 | 1247600.0 |
| 2004-11-05 | AAIC-DELISTED | Stock | 366.8 | 367.0 | 347.4 | 347.6 | 2019300.0 |
| 2004-11-05 | AAME | Stock | 3.01 | 3.01 | 3.0 | 3.0 | 1800.0 |
| 2004-11-05 | AAON | Stock | 2.0135 | 2.1728 | 2.0122 | 2.0741 | 861131.0 |
| 2004-11-05 | AAP | Stock | 27.1667 | 27.98 | 27.1667 | 27.7 | 1456950.0 |
| 2004-11-05 | AAV-DELISTED | Stock | 18.05 | 18.05 | 17.78 | 18.05 | 16700.0 |
| 2004-11-05 | AAXN-DELISTED | Stock | 23.4500007629395 | 24.0499992370605 | 22.7700004577637 | 23.2450008392334 | 28444000.0 |
| 2004-11-05 | ABAX-DELISTED | Stock | 12.7 | 12.841 | 12.36 | 12.41 | 98059.0 |
| 2004-11-05 | ABB-DELISTED | Stock | 5.74 | 5.82 | 5.72 | 5.8 | 269100.0 |
| 2004-11-05 | ABC-DELISTED | Stock | 14.22 | 14.38 | 14.18 | 14.38 | 5558125.0 |
| 2004-11-05 | ABCB | Stock | 16.9807 | 17.1509 | 16.6646 | 16.7295 | 17150.0 |
| 2004-11-05 | ABCO-DELISTED | Stock | 17.284 | 17.561 | 17.281 | 17.341 | 522427.0 |
| 2004-11-05 | ABCW-DELISTED | Stock | 26.32 | 26.78 | 26.27 | 26.73 | 49920.0 |
| 2004-11-05 | ABE-DELISTED | Stock | 8.72 | 8.8 | 8.72 | 8.8 | 15100.0 |
| 2004-11-05 | ABFS-DELISTED | Stock | 40.55 | 41.43 | 39.71 | 40.57 | 270509.0 |
| 2004-11-05 | ABG | Stock | 13.83 | 14.0 | 13.8 | 13.91 | 38400.0 |
| 2004-11-05 | ABK-DELISTED | Stock | 79.65 | 79.97 | 78.58 | 78.89 | 403800.0 |
| 2004-11-05 | ABM | Stock | 21.49 | 21.55 | 21.13 | 21.41 | 213600.0 |
| 2004-11-05 | ABMD-DELISTED | Stock | 14.3 | 14.95 | 13.9 | 14.73 | 330832.0 |
| 2004-11-05 | ABP-DELISTED | Stock | 2.9 | 2.99 | 2.82 | 2.9 | 372200.0 |
| 2004-11-05 | ABR | Stock | 20.88 | 20.9 | 20.29 | 20.38 | 61900.0 |
| 2004-11-05 | ABT | Stock | 21.3751 | 21.3991 | 21.1112 | 21.3271 | 8573364.0 |
| 2004-11-05 | ABTL-DELISTED | Stock | 35.9 | 36.0 | 34.0 | 35.25 | 87700.0 |
| 2004-11-05 | ABV-DELISTED | Stock | 24.77 | 24.8 | 24.62 | 24.74 | 388800.0 |
| 2004-11-05 | ABVA-DELISTED | Stock | 14.94 | 15.0 | 14.94 | 15.0 | 1300.0 |
| 2004-11-05 | ABX-DELISTED | Stock | 22.2 | 22.98 | 22.2 | 22.93 | 2531894.0 |
| 2004-11-05 | ACAD | Stock | 7.25 | 7.28 | 7.19 | 7.19 | 1700.0 |
| 2004-11-05 | ACAP-DELISTED | Stock | 34.14 | 34.14 | 33.35 | 33.55 | 64336.0 |
| 2004-11-05 | ACAS-DELISTED | Stock | 31.88 | 32.09 | 31.5 | 31.77 | 1250116.0 |
| 2004-11-05 | ACAT-DELISTED | Stock | 25.71 | 26.92 | 25.71 | 26.24 | 152306.0 |
| 2004-11-05 | ACC-DELISTED | Stock | 19.05 | 19.25 | 18.95 | 19.09 | 10800.0 |
| 2004-11-05 | ACCL-DELISTED | Stock | 6.18 | 6.2 | 5.93 | 6.01 | 115183.0 |
| 2004-11-05 | ACE-DELISTED | Stock | 39.02 | 39.66 | 38.9 | 39.07 | 1062100.0 |
| 2004-11-05 | ACF-DELISTED | Stock | 19.97 | 20.2 | 19.93 | 20.02 | 1133900.0 |
| 2004-11-05 | ACFC-DELISTED | Stock | 65.82 | 66.33 | 65.56 | 66.33 | 13204.0 |
| 2004-11-05 | ACG-DELISTED | Stock | 8.14 | 8.15 | 8.05 | 8.08 | 675200.0 |
| 2004-11-05 | ACGL | Stock | 4.2378 | 4.2889 | 4.1956 | 4.2622 | 688500.0 |
| 2004-11-05 | ACGN-DELISTED | Stock | 600.6712 | 600.6712 | 589.3288 | 600.6712 | 25900.0 |
| 2004-11-05 | ACH | Stock | 18.3133 | 18.7 | 18.1267 | 18.5467 | 269100.0 |
| 2004-11-05 | ACH-DELISTED | Stock | 14.912 | 15.112 | 14.809 | 14.927 | 421165.0 |
| 2004-11-05 | ACLS | Stock | 29.08 | 29.08 | 27.76 | 28.24 | 472225.0 |
| 2004-11-05 | ACO-DELISTED | Stock | 18.3 | 18.5 | 18.11 | 18.37 | 123400.0 |
> showing 50 of 3,915 rows — these rows as CSV