PREVIEW / stock_daily / 2005-07-05
file: by_date/stock_daily/2005/2005-07-05.parquet size: 137 KB rows: 4,125 symbols: 2,584
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-07-05 | AAPL | Stock | 1.3054 | 1.3625 | 1.3036 | 1.3564 | 454269200.0 |
| 2005-07-05 | MSFT | Stock | 24.66 | 25.19 | 24.62 | 24.98 | 61883500.0 |
| 2005-07-05 | NVDA | Stock | 0.2245 | 0.2281 | 0.2223 | 0.2272 | 388440000.0 |
| 2005-07-05 | AMZN | Stock | 1.675 | 1.724 | 1.6725 | 1.704 | 147676000.0 |
| 2005-07-05 | CL | Stock | 24.95 | 25.315 | 24.865 | 25.185 | 2903200.0 |
| 2005-07-05 | A | Stock | 16.6381 | 17.0243 | 16.5451 | 16.8956 | 1992430.0 |
| 2005-07-05 | AABA-DELISTED | Stock | 34.25 | 35.0800018310547 | 34.2000007629395 | 34.5999984741211 | 16086700.0 |
| 2005-07-05 | AACC-DELISTED | Stock | 26.16 | 26.28 | 25.9 | 26.2 | 110598.0 |
| 2005-07-05 | AAI-DELISTED | Stock | 9.26 | 9.26 | 8.99 | 9.14 | 1087100.0 |
| 2005-07-05 | AAIC-DELISTED | Stock | 293.0 | 297.2 | 289.4 | 296.0 | 1231900.0 |
| 2005-07-05 | AAME | Stock | 3.01 | 3.01 | 3.01 | 3.01 | 200.0 |
| 2005-07-05 | AAON | Stock | 2.3717 | 2.4665 | 2.3717 | 2.4441 | 198197.0 |
| 2005-07-05 | AAP | Stock | 43.7667 | 44.1733 | 43.5933 | 43.7267 | 748950.0 |
| 2005-07-05 | AAV-DELISTED | Stock | 13.85 | 14.17 | 13.73 | 13.85 | 96600.0 |
| 2005-07-05 | AAXN-DELISTED | Stock | 9.89999961853027 | 10.0 | 9.5 | 9.75 | 3746700.0 |
| 2005-07-05 | ABAX-DELISTED | Stock | 10.83 | 11.28 | 10.82 | 11.23 | 92927.0 |
| 2005-07-05 | ABB-DELISTED | Stock | 6.27 | 6.33 | 6.15 | 6.24 | 2665400.0 |
| 2005-07-05 | ABBC-DELISTED | Stock | 12.3 | 12.3 | 12.01 | 12.01 | 2939.0 |
| 2005-07-05 | ABC-DELISTED | Stock | 17.37 | 17.53 | 17.34 | 17.39 | 4376800.0 |
| 2005-07-05 | ABCB | Stock | 17.3908 | 17.8772 | 17.3908 | 17.8772 | 17581.0 |
| 2005-07-05 | ABCO-DELISTED | Stock | 24.5 | 24.61 | 24.33 | 24.5 | 256971.0 |
| 2005-07-05 | ABCW-DELISTED | Stock | 30.0 | 30.98 | 29.99 | 30.95 | 45790.0 |
| 2005-07-05 | ABE-DELISTED | Stock | 9.97 | 10.17 | 9.97 | 10.17 | 15000.0 |
| 2005-07-05 | ABFS-DELISTED | Stock | 32.9 | 33.39 | 32.06 | 33.33 | 270029.0 |
| 2005-07-05 | ABG | Stock | 15.32 | 15.5 | 15.25 | 15.49 | 50600.0 |
| 2005-07-05 | ABK-DELISTED | Stock | 69.85 | 70.93 | 69.77 | 70.75 | 510700.0 |
| 2005-07-05 | ABM | Stock | 19.84 | 19.95 | 19.58 | 19.8 | 185900.0 |
| 2005-07-05 | ABMD-DELISTED | Stock | 8.61 | 8.68 | 8.4 | 8.68 | 89775.0 |
| 2005-07-05 | ABP-DELISTED | Stock | 2.85 | 2.86 | 2.8 | 2.84 | 90600.0 |
| 2005-07-05 | ABR | Stock | 28.95 | 29.5 | 28.95 | 29.44 | 65200.0 |
| 2005-07-05 | ABT | Stock | 23.4718 | 23.7021 | 23.443 | 23.4862 | 5530846.0 |
| 2005-07-05 | ABTL-DELISTED | Stock | 24.15 | 24.9 | 23.75 | 24.75 | 24282.0 |
| 2005-07-05 | ABV-DELISTED | Stock | 30.75 | 31.11 | 30.5 | 30.71 | 329100.0 |
| 2005-07-05 | ABVA-DELISTED | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 1500.0 |
| 2005-07-05 | ABX-DELISTED | Stock | 24.4 | 24.48 | 24.06 | 24.2 | 2651287.0 |
| 2005-07-05 | ACAD | Stock | 8.34 | 8.4 | 8.24 | 8.36 | 52900.0 |
| 2005-07-05 | ACAP-DELISTED | Stock | 36.99 | 37.49 | 36.99 | 37.31 | 94179.0 |
| 2005-07-05 | ACAS-DELISTED | Stock | 36.33 | 36.87 | 36.21 | 36.75 | 751238.0 |
| 2005-07-05 | ACAT-DELISTED | Stock | 20.84 | 20.95 | 20.57 | 20.79 | 52034.0 |
| 2005-07-05 | ACC-DELISTED | Stock | 22.71 | 22.73 | 22.51 | 22.73 | 78939.0 |
| 2005-07-05 | ACCL-DELISTED | Stock | 4.85 | 4.91 | 4.75 | 4.84 | 94605.0 |
| 2005-07-05 | ACE-DELISTED | Stock | 45.0 | 45.73 | 44.96 | 45.65 | 566400.0 |
| 2005-07-05 | ACF-DELISTED | Stock | 25.72 | 26.18 | 25.53 | 25.88 | 989700.0 |
| 2005-07-05 | ACFC-DELISTED | Stock | 63.83 | 65.15 | 63.37 | 63.37 | 1733.0 |
| 2005-07-05 | ACG-DELISTED | Stock | 8.31 | 8.35 | 8.3 | 8.33 | 493100.0 |
| 2005-07-05 | ACGL | Stock | 5.0489 | 5.0489 | 5.0233 | 5.0389 | 339300.0 |
| 2005-07-05 | ACGN-DELISTED | Stock | 623.3288 | 634.6712 | 600.6712 | 634.6712 | 32100.0 |
| 2005-07-05 | ACH | Stock | 21.7733 | 22.12 | 21.6467 | 21.9867 | 237300.0 |
| 2005-07-05 | ACH-DELISTED | Stock | 13.725 | 13.727 | 13.587 | 13.722 | 129200.0 |
| 2005-07-05 | ACLS | Stock | 27.52 | 28.2 | 27.08 | 27.8 | 176575.0 |
> showing 50 of 4,125 rows — these rows as CSV