PREVIEW / stock_daily / 2007-12-12
file: by_date/stock_daily/2007/2007-12-12.parquet size: 182 KB rows: 5,652 symbols: 3,427
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 |
|---|---|---|---|---|---|---|---|
| 2007-12-12 | AAPL | Stock | 6.9086 | 6.9457 | 6.6343 | 6.8164 | 1225660800.0 |
| 2007-12-12 | MSFT | Stock | 34.61 | 35.09 | 33.93 | 34.47 | 63345400.0 |
| 2007-12-12 | NVDA | Stock | 0.8935 | 0.9023 | 0.8695 | 0.8868 | 617504000.0 |
| 2007-12-12 | AMZN | Stock | 4.642 | 4.6875 | 4.466 | 4.564 | 144562000.0 |
| 2007-12-12 | TLT | Stock | 91.45 | 92.65 | 91.27 | 91.93 | 2225400.0 |
| 2007-12-12 | CL | Stock | 40.125 | 40.16 | 39.485 | 39.9 | 5539200.0 |
| 2007-12-12 | A | Stock | 26.867 | 27.2961 | 26.1588 | 26.5308 | 3051974.0 |
| 2007-12-12 | AABA-DELISTED | Stock | 24.83 | 25.0 | 24.11 | 24.55 | 26262566.0 |
| 2007-12-12 | AACC-DELISTED | Stock | 11.37 | 11.59 | 11.0 | 11.29 | 283691.0 |
| 2007-12-12 | AAI-DELISTED | Stock | 8.34 | 8.57 | 7.92 | 8.04 | 2198110.0 |
| 2007-12-12 | AAIC-DELISTED | Stock | 56.4 | 58.4 | 53.8 | 55.8 | 1662602.0 |
| 2007-12-12 | AAME | Stock | 1.41 | 1.54 | 1.41 | 1.5 | 2300.0 |
| 2007-12-12 | AAON | Stock | 3.8321 | 3.8341 | 3.7412 | 3.8064 | 508781.0 |
| 2007-12-12 | AAP | Stock | 39.21 | 39.42 | 38.19 | 38.47 | 1714700.0 |
| 2007-12-12 | AATI-DELISTED | Stock | 11.81 | 12.05 | 11.65 | 11.73 | 812584.0 |
| 2007-12-12 | AAU-DELISTED | Stock | 2.4 | 2.64 | 2.4 | 2.53 | 22500.0 |
| 2007-12-12 | AAUAF-DELISTED | Stock | 2.4 | 2.64 | 2.4 | 2.531 | 26100.0 |
| 2007-12-12 | AAV-DELISTED | Stock | 10.15 | 10.15 | 10.01 | 10.06 | 792057.0 |
| 2007-12-12 | AAWW-DELISTED | Stock | 54.23 | 54.55 | 53.51 | 54.18 | 196721.0 |
| 2007-12-12 | AAXN-DELISTED | Stock | 15.06 | 15.5 | 14.86 | 15.02 | 1272655.0 |
| 2007-12-12 | AB | Stock | 82.19 | 82.61 | 79.77 | 80.07 | 325900.0 |
| 2007-12-12 | ABAX-DELISTED | Stock | 35.86 | 37.19 | 35.54 | 35.9 | 160291.0 |
| 2007-12-12 | ABB-DELISTED | Stock | 29.59 | 29.69 | 28.89 | 29.22 | 3397103.0 |
| 2007-12-12 | ABBC-DELISTED | Stock | 9.0 | 9.05 | 8.92 | 9.0 | 94462.0 |
| 2007-12-12 | ABBNY-DELISTED | Stock | 29.59 | 29.69 | 28.89 | 29.28 | 3397103.0 |
| 2007-12-12 | ABC-DELISTED | Stock | 22.58 | 22.58 | 21.8 | 22.1 | 4172726.0 |
| 2007-12-12 | ABCB | Stock | 17.2352 | 17.2352 | 16.3404 | 16.5446 | 47191.0 |
| 2007-12-12 | ABCO-DELISTED | Stock | 32.83 | 33.3 | 32.16 | 32.59 | 147601.0 |
| 2007-12-12 | ABCW-DELISTED | Stock | 25.17 | 25.44 | 23.77 | 24.25 | 96630.0 |
| 2007-12-12 | ABD-DELISTED | Stock | 17.27 | 17.63 | 16.34 | 16.72 | 514780.0 |
| 2007-12-12 | ABE-DELISTED | Stock | 28.16 | 28.4099 | 27.2 | 27.35 | 25100.0 |
| 2007-12-12 | ABEO | Stock | 3087.5 | 3187.5 | 3062.5 | 3062.5 | 8.0 |
| 2007-12-12 | ABFS-DELISTED | Stock | 24.91 | 25.19 | 23.01 | 23.1 | 1028943.0 |
| 2007-12-12 | ABG | Stock | 16.72 | 16.98 | 15.75 | 16.01 | 422700.0 |
| 2007-12-12 | ABII-DELISTED | Stock | 68.66 | 71.41 | 68.3801 | 70.13 | 121308.0 |
| 2007-12-12 | ABK-DELISTED | Stock | 28.49 | 28.64 | 23.5 | 24.86 | 9772130.0 |
| 2007-12-12 | ABM | Stock | 20.88 | 20.88 | 19.36 | 19.95 | 824900.0 |
| 2007-12-12 | ABMD-DELISTED | Stock | 14.94 | 14.97 | 14.38 | 14.5 | 310639.0 |
| 2007-12-12 | ABP-DELISTED | Stock | 3.42 | 3.49 | 3.41 | 3.42 | 159400.0 |
| 2007-12-12 | ABR | Stock | 18.12 | 18.6 | 17.55 | 18.01 | 456700.0 |
| 2007-12-12 | ABT | Stock | 28.0683 | 28.5385 | 27.5885 | 27.8812 | 19864318.0 |
| 2007-12-12 | ABTL-DELISTED | Stock | 15.201 | 15.303 | 15.099 | 15.15 | 6183.0 |
| 2007-12-12 | ABV-DELISTED | Stock | 73.57 | 76.59 | 73.57 | 74.86 | 736111.0 |
| 2007-12-12 | ABVA-DELISTED | Stock | 6.96 | 7.1 | 6.96 | 6.96 | 4385.0 |
| 2007-12-12 | ABX-DELISTED | Stock | 39.95 | 39.98 | 39.32 | 39.79 | 6721948.0 |
| 2007-12-12 | ACAD | Stock | 12.18 | 12.9 | 11.66 | 12.22 | 950200.0 |
| 2007-12-12 | ACAP-DELISTED | Stock | 45.18 | 45.5 | 43.27 | 44.14 | 87165.0 |
| 2007-12-12 | ACAS-DELISTED | Stock | 37.73 | 38.04 | 36.52 | 37.23 | 3149258.0 |
| 2007-12-12 | ACAT-DELISTED | Stock | 12.36 | 12.43 | 12.06 | 12.15 | 118216.0 |
| 2007-12-12 | ACC-DELISTED | Stock | 27.38 | 27.83 | 26.6 | 26.94 | 425082.0 |
> showing 50 of 5,652 rows — these rows as CSV