PREVIEW / stock_daily / 2009-07-24
file: by_date/stock_daily/2009/2009-07-24.parquet size: 182 KB rows: 5,772 symbols: 3,445
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-24 | AAPL | Stock | 5.6054 | 5.7143 | 5.5893 | 5.7139 | 438362400.0 |
| 2009-07-24 | MSFT | Stock | 23.61 | 23.89 | 22.81 | 23.45 | 215135700.0 |
| 2009-07-24 | NVDA | Stock | 0.315 | 0.325 | 0.313 | 0.324 | 650592000.0 |
| 2009-07-24 | AMZN | Stock | 4.38 | 4.445 | 4.275 | 4.3245 | 384092000.0 |
| 2009-07-24 | TLT | Stock | 91.0 | 91.45 | 90.77 | 91.45 | 1765276.0 |
| 2009-07-24 | ES | Stock | 22.88 | 23.02 | 22.72 | 23.0 | 950600.0 |
| 2009-07-24 | CL | Stock | 37.23 | 37.62 | 37.21 | 37.55 | 4331200.0 |
| 2009-07-24 | A | Stock | 15.6223 | 15.9442 | 15.608 | 15.9299 | 3534144.0 |
| 2009-07-24 | AABA-DELISTED | Stock | 17.44 | 17.59 | 17.02 | 17.47 | 19629366.0 |
| 2009-07-24 | AACC-DELISTED | Stock | 8.36 | 8.5 | 8.14 | 8.47 | 41645.0 |
| 2009-07-24 | AACG | Stock | 8.74 | 9.45 | 8.65 | 9.15 | 13900.0 |
| 2009-07-24 | AAI-DELISTED | Stock | 6.32 | 6.7 | 6.32 | 6.61 | 2354519.0 |
| 2009-07-24 | AAIC-DELISTED | Stock | 9.0 | 9.0 | 8.2 | 8.24 | 271879.0 |
| 2009-07-24 | AAME | Stock | 0.87 | 0.87 | 0.64 | 0.72 | 6700.0 |
| 2009-07-24 | AAON | Stock | 3.9012 | 3.9743 | 3.8084 | 3.8617 | 1074769.0 |
| 2009-07-24 | AAP | Stock | 46.31 | 46.86 | 46.11 | 46.55 | 566100.0 |
| 2009-07-24 | AATI-DELISTED | Stock | 4.99 | 5.1 | 4.73 | 4.97 | 326656.0 |
| 2009-07-24 | AAU-DELISTED | Stock | 0.68 | 0.71 | 0.67 | 0.7 | 51166.0 |
| 2009-07-24 | AAUAF-DELISTED | Stock | 0.68 | 0.71 | 0.67 | 0.7 | 51966.0 |
| 2009-07-24 | AAV-DELISTED | Stock | 5.18 | 5.24 | 5.15 | 5.21 | 766935.0 |
| 2009-07-24 | AAWW-DELISTED | Stock | 23.74 | 24.7 | 23.31 | 24.53 | 185883.0 |
| 2009-07-24 | AAXJ | Stock | 49.34 | 49.34 | 48.25 | 49.03 | 255143.0 |
| 2009-07-24 | AAXN-DELISTED | Stock | 5.26 | 5.54 | 5.26 | 5.53 | 423564.0 |
| 2009-07-24 | AB | Stock | 22.46 | 23.05 | 22.3 | 23.0 | 329400.0 |
| 2009-07-24 | ABAX-DELISTED | Stock | 19.87 | 20.31 | 19.84 | 20.2 | 221328.0 |
| 2009-07-24 | ABB-DELISTED | Stock | 17.33 | 17.66 | 17.11 | 17.64 | 5156187.0 |
| 2009-07-24 | ABBC-DELISTED | Stock | 8.76 | 9.0 | 8.76 | 8.93 | 74773.0 |
| 2009-07-24 | ABBNY-DELISTED | Stock | 17.33 | 17.66 | 17.11 | 17.64 | 5198761.0 |
| 2009-07-24 | ABC-DELISTED | Stock | 19.13 | 19.33 | 18.97 | 19.3 | 2232750.0 |
| 2009-07-24 | ABCB | Stock | 6.2152 | 6.3513 | 6.1471 | 6.3221 | 12646.0 |
| 2009-07-24 | ABCO-DELISTED | Stock | 11.855 | 12.095 | 11.675 | 11.935 | 74610.0 |
| 2009-07-24 | ABCW-DELISTED | Stock | 1.1292 | 1.1702 | 1.1292 | 1.16 | 26860.0 |
| 2009-07-24 | ABD-DELISTED | Stock | 3.7 | 3.82 | 3.39 | 3.67 | 637270.0 |
| 2009-07-24 | ABE-DELISTED | Stock | 16.35 | 16.84 | 16.35 | 16.61 | 4715.0 |
| 2009-07-24 | ABEO | Stock | 4000.0 | 4987.5 | 4000.0 | 4812.5 | 272.0 |
| 2009-07-24 | ABFS-DELISTED | Stock | 25.25 | 26.42 | 24.8452 | 26.36 | 738581.0 |
| 2009-07-24 | ABG | Stock | 12.31 | 12.4 | 11.93 | 12.12 | 215200.0 |
| 2009-07-24 | ABII-DELISTED | Stock | 30.84 | 32.32 | 30.5 | 31.48 | 35792.0 |
| 2009-07-24 | ABK-DELISTED | Stock | 0.91 | 0.97 | 0.85 | 0.93 | 5120158.0 |
| 2009-07-24 | ABM | Stock | 20.69 | 20.98 | 20.52 | 20.79 | 136400.0 |
| 2009-07-24 | ABMD-DELISTED | Stock | 7.62 | 7.62 | 7.14 | 7.24 | 317939.0 |
| 2009-07-24 | ABR | Stock | 1.53 | 1.66 | 1.52 | 1.64 | 197100.0 |
| 2009-07-24 | ABT | Stock | 21.0824 | 21.6342 | 21.0152 | 21.5958 | 19027511.0 |
| 2009-07-24 | ABTL-DELISTED | Stock | 2.45 | 2.45 | 2.25 | 2.35 | 6095.0 |
| 2009-07-24 | ABV-DELISTED | Stock | 69.75 | 70.72 | 69.1001 | 69.99 | 846452.0 |
| 2009-07-24 | ABVA-DELISTED | Stock | 2.74 | 2.74 | 2.55 | 2.5503 | 1695.0 |
| 2009-07-24 | ABVT-DELISTED | Stock | 82.49 | 82.5 | 80.91 | 82.24 | 49207.0 |
| 2009-07-24 | ABX-DELISTED | Stock | 35.4 | 35.78 | 35.07 | 35.33 | 4573817.0 |
| 2009-07-24 | ACAD | Stock | 2.6 | 3.75 | 2.6 | 3.41 | 3451000.0 |
| 2009-07-24 | ACAP-DELISTED | Stock | 38.79 | 39.47 | 38.01 | 39.469 | 15471.0 |
> showing 50 of 5,772 rows — these rows as CSV