PREVIEW / stock_daily / 2005-04-20
file: by_date/stock_daily/2005/2005-04-20.parquet size: 135 KB rows: 4,032 symbols: 2,525
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-20 | AAPL | Stock | 1.345 | 1.3479 | 1.2657 | 1.2682 | 945131600.0 |
| 2005-04-20 | MSFT | Stock | 24.66 | 24.7 | 24.3 | 24.32 | 91923500.0 |
| 2005-04-20 | NVDA | Stock | 0.1859 | 0.1871 | 0.1771 | 0.1772 | 564672000.0 |
| 2005-04-20 | AMZN | Stock | 1.655 | 1.688 | 1.645 | 1.6625 | 184310000.0 |
| 2005-04-20 | CL | Stock | 25.985 | 25.99 | 25.5 | 25.545 | 4875800.0 |
| 2005-04-20 | A | Stock | 14.907 | 15.0215 | 14.6352 | 14.671 | 2722046.0 |
| 2005-04-20 | AABA-DELISTED | Stock | 34.9599990844727 | 35.25 | 34.3600006103516 | 34.6500015258789 | 50104400.0 |
| 2005-04-20 | AACC-DELISTED | Stock | 20.01 | 20.28 | 19.86 | 19.92 | 135255.0 |
| 2005-04-20 | AAI-DELISTED | Stock | 8.89 | 9.09 | 8.73 | 8.76 | 894100.0 |
| 2005-04-20 | AAIC-DELISTED | Stock | 283.4 | 284.8 | 275.4 | 276.2 | 1352600.0 |
| 2005-04-20 | AAME | Stock | 3.15 | 3.15 | 3.02 | 3.1 | 6300.0 |
| 2005-04-20 | AAON | Stock | 2.2123 | 2.2927 | 2.2123 | 2.2387 | 262744.0 |
| 2005-04-20 | AAP | Stock | 34.1 | 34.1 | 33.5333 | 33.5667 | 904350.0 |
| 2005-04-20 | AAV-DELISTED | Stock | 15.51 | 15.7 | 15.38 | 15.51 | 37000.0 |
| 2005-04-20 | AAXN-DELISTED | Stock | 7.94999980926514 | 8.0 | 7.59999990463257 | 7.6399998664856 | 3770600.0 |
| 2005-04-20 | ABAX-DELISTED | Stock | 7.97 | 8.07 | 7.78 | 7.78 | 76788.0 |
| 2005-04-20 | ABB-DELISTED | Stock | 6.21 | 6.26 | 6.15 | 6.15 | 308000.0 |
| 2005-04-20 | ABBC-DELISTED | Stock | 12.0 | 12.0 | 11.49 | 11.5 | 22287.0 |
| 2005-04-20 | ABC-DELISTED | Stock | 14.92 | 14.96 | 14.65 | 14.84 | 9629600.0 |
| 2005-04-20 | ABCB | Stock | 17.6535 | 17.7118 | 16.8364 | 17.0115 | 16347.0 |
| 2005-04-20 | ABCO-DELISTED | Stock | 21.01 | 21.1 | 20.81 | 20.95 | 263077.0 |
| 2005-04-20 | ABCW-DELISTED | Stock | 27.4 | 27.41 | 26.71 | 26.71 | 87020.0 |
| 2005-04-20 | ABE-DELISTED | Stock | 9.4 | 9.53 | 9.35 | 9.35 | 46600.0 |
| 2005-04-20 | ABFS-DELISTED | Stock | 34.1 | 34.27 | 32.62 | 32.67 | 514821.0 |
| 2005-04-20 | ABG | Stock | 14.05 | 14.05 | 13.7 | 13.8 | 37200.0 |
| 2005-04-20 | ABK-DELISTED | Stock | 72.0 | 72.0 | 62.2 | 62.2 | 6586000.0 |
| 2005-04-20 | ABM | Stock | 18.62 | 18.62 | 18.01 | 18.15 | 138500.0 |
| 2005-04-20 | ABMD-DELISTED | Stock | 11.15 | 11.2 | 10.64 | 10.66 | 74326.0 |
| 2005-04-20 | ABP-DELISTED | Stock | 2.67 | 2.77 | 2.65 | 2.65 | 91400.0 |
| 2005-04-20 | ABR | Stock | 26.08 | 26.1 | 25.89 | 26.0 | 70100.0 |
| 2005-04-20 | ABT | Stock | 22.9344 | 23.1024 | 22.6562 | 22.6945 | 7894331.0 |
| 2005-04-20 | ABTL-DELISTED | Stock | 22.8 | 24.95 | 22.5 | 22.6 | 25800.0 |
| 2005-04-20 | ABV-DELISTED | Stock | 27.5 | 27.55 | 26.73 | 26.81 | 289900.0 |
| 2005-04-20 | ABVT-DELISTED | Stock | 30.0 | 31.0 | 30.0 | 31.0 | 10600.0 |
| 2005-04-20 | ABX-DELISTED | Stock | 22.85 | 23.05 | 22.58 | 22.74 | 1842600.0 |
| 2005-04-20 | ACAD | Stock | 6.54 | 6.89 | 6.52 | 6.74 | 13400.0 |
| 2005-04-20 | ACAP-DELISTED | Stock | 33.47 | 34.25 | 32.9 | 33.04 | 37279.0 |
| 2005-04-20 | ACAS-DELISTED | Stock | 31.99 | 32.07 | 31.61 | 31.79 | 610974.0 |
| 2005-04-20 | ACAT-DELISTED | Stock | 24.88 | 26.1 | 23.99 | 24.16 | 157419.0 |
| 2005-04-20 | ACC-DELISTED | Stock | 20.25 | 20.25 | 19.04 | 19.1 | 82900.0 |
| 2005-04-20 | ACCL-DELISTED | Stock | 5.71 | 5.71 | 5.47 | 5.52 | 117601.0 |
| 2005-04-20 | ACE-DELISTED | Stock | 39.44 | 39.54 | 38.63 | 38.66 | 1041234.0 |
| 2005-04-20 | ACF-DELISTED | Stock | 23.32 | 23.72 | 23.06 | 23.13 | 1018100.0 |
| 2005-04-20 | ACFC-DELISTED | Stock | 57.81 | 57.81 | 56.17 | 56.17 | 1269.0 |
| 2005-04-20 | ACG-DELISTED | Stock | 8.14 | 8.16 | 8.1 | 8.13 | 201500.0 |
| 2005-04-20 | ACGL | Stock | 4.4533 | 4.4678 | 4.4389 | 4.45 | 777600.0 |
| 2005-04-20 | ACGN-DELISTED | Stock | 702.6712 | 725.3288 | 657.3288 | 691.3288 | 180500.0 |
| 2005-04-20 | ACH | Stock | 17.9867 | 17.9867 | 17.4667 | 17.5667 | 284850.0 |
| 2005-04-20 | ACH-DELISTED | Stock | 14.12 | 14.12 | 13.91 | 13.91 | 154000.0 |
| 2005-04-20 | ACLS | Stock | 27.64 | 28.0 | 26.32 | 26.36 | 343825.0 |
> showing 50 of 4,032 rows — these rows as CSV