PREVIEW / stock_daily / 2005-07-07
file: by_date/stock_daily/2005/2005-07-07.parquet size: 136 KB rows: 4,098 symbols: 2,567
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-07 | AAPL | Stock | 1.3146 | 1.3486 | 1.3143 | 1.3439 | 383723200.0 |
| 2005-07-07 | MSFT | Stock | 24.58 | 24.71 | 24.5 | 24.65 | 80082900.0 |
| 2005-07-07 | NVDA | Stock | 0.2296 | 0.2333 | 0.2288 | 0.2316 | 465900000.0 |
| 2005-07-07 | AMZN | Stock | 1.69 | 1.7255 | 1.69 | 1.698 | 84858000.0 |
| 2005-07-07 | CL | Stock | 24.75 | 25.04 | 24.525 | 24.995 | 6156200.0 |
| 2005-07-07 | A | Stock | 16.7382 | 17.0887 | 16.5451 | 17.0815 | 3442016.0 |
| 2005-07-07 | AABA-DELISTED | Stock | 33.8699989318848 | 34.7700004577637 | 33.7200012207031 | 34.6300010681152 | 16354300.0 |
| 2005-07-07 | AACC-DELISTED | Stock | 25.23 | 25.57 | 24.74 | 25.55 | 93634.0 |
| 2005-07-07 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 13000.0 |
| 2005-07-07 | AAI-DELISTED | Stock | 8.75 | 9.03 | 8.72 | 9.01 | 1332600.0 |
| 2005-07-07 | AAIC-DELISTED | Stock | 299.6 | 299.8 | 295.0 | 297.2 | 859400.0 |
| 2005-07-07 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 500.0 |
| 2005-07-07 | AAON | Stock | 2.3941 | 2.4138 | 2.3519 | 2.4033 | 38728.0 |
| 2005-07-07 | AAP | Stock | 42.9333 | 42.9333 | 42.2933 | 42.5867 | 838350.0 |
| 2005-07-07 | AAV-DELISTED | Stock | 14.29 | 14.34 | 14.29 | 14.29 | 91100.0 |
| 2005-07-07 | AAXN-DELISTED | Stock | 10.0900001525879 | 10.1199998855591 | 9.89000034332275 | 9.89999961853027 | 1740900.0 |
| 2005-07-07 | ABAX-DELISTED | Stock | 10.81 | 11.02 | 10.61 | 10.95 | 40604.0 |
| 2005-07-07 | ABB-DELISTED | Stock | 6.31 | 6.39 | 6.31 | 6.38 | 1036600.0 |
| 2005-07-07 | ABBC-DELISTED | Stock | 12.12 | 12.146 | 11.98 | 11.99 | 8134.0 |
| 2005-07-07 | ABC-DELISTED | Stock | 17.14 | 17.51 | 17.14 | 17.5 | 2658837.0 |
| 2005-07-07 | ABCB | Stock | 17.3714 | 17.9842 | 17.3714 | 17.9842 | 4934.0 |
| 2005-07-07 | ABCO-DELISTED | Stock | 23.73 | 23.84 | 23.36 | 23.79 | 232248.0 |
| 2005-07-07 | ABCW-DELISTED | Stock | 30.25 | 30.69 | 30.13 | 30.54 | 58000.0 |
| 2005-07-07 | ABE-DELISTED | Stock | 10.02 | 10.02 | 9.86 | 9.97 | 20700.0 |
| 2005-07-07 | ABFS-DELISTED | Stock | 33.23 | 34.32 | 32.65 | 33.9 | 501044.0 |
| 2005-07-07 | ABG | Stock | 15.8 | 16.06 | 15.64 | 16.01 | 40600.0 |
| 2005-07-07 | ABK-DELISTED | Stock | 68.8 | 69.46 | 68.34 | 69.3 | 868600.0 |
| 2005-07-07 | ABM | Stock | 19.57 | 19.97 | 19.5 | 19.8 | 220400.0 |
| 2005-07-07 | ABMD-DELISTED | Stock | 8.7 | 8.99 | 8.53 | 8.86 | 65308.0 |
| 2005-07-07 | ABP-DELISTED | Stock | 2.93 | 3.0 | 2.9 | 3.0 | 498400.0 |
| 2005-07-07 | ABR | Stock | 29.42 | 29.56 | 29.12 | 29.45 | 68900.0 |
| 2005-07-07 | ABT | Stock | 23.4382 | 23.6062 | 23.3759 | 23.4958 | 12606294.0 |
| 2005-07-07 | ABTL-DELISTED | Stock | 22.92 | 23.78 | 22.92 | 23.08 | 33596.0 |
| 2005-07-07 | ABV-DELISTED | Stock | 30.55 | 31.5 | 30.46 | 31.42 | 271200.0 |
| 2005-07-07 | ABVA-DELISTED | Stock | 15.55 | 16.0 | 15.55 | 16.0 | 5775.0 |
| 2005-07-07 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 500.0 |
| 2005-07-07 | ABX-DELISTED | Stock | 24.58 | 24.73 | 24.4 | 24.57 | 1725700.0 |
| 2005-07-07 | ACAD | Stock | 8.1 | 8.26 | 7.85 | 8.1 | 43400.0 |
| 2005-07-07 | ACAP-DELISTED | Stock | 35.94 | 37.44 | 35.94 | 37.36 | 91615.0 |
| 2005-07-07 | ACAS-DELISTED | Stock | 37.0 | 37.17 | 36.8 | 37.17 | 577113.0 |
| 2005-07-07 | ACAT-DELISTED | Stock | 20.09 | 20.28 | 19.52 | 20.11 | 223696.0 |
| 2005-07-07 | ACC-DELISTED | Stock | 22.75 | 23.09 | 22.65 | 22.98 | 107200.0 |
| 2005-07-07 | ACCL-DELISTED | Stock | 4.8 | 5.06 | 4.74 | 5.02 | 118238.0 |
| 2005-07-07 | ACE-DELISTED | Stock | 44.49 | 45.36 | 44.34 | 45.3 | 711213.0 |
| 2005-07-07 | ACF-DELISTED | Stock | 26.12 | 26.12 | 25.71 | 26.11 | 1049700.0 |
| 2005-07-07 | ACFC-DELISTED | Stock | 63.52 | 63.52 | 62.45 | 62.96 | 1227.0 |
| 2005-07-07 | ACG-DELISTED | Stock | 8.3 | 8.33 | 8.28 | 8.32 | 244700.0 |
| 2005-07-07 | ACGL | Stock | 5.0133 | 5.0289 | 4.9478 | 4.9633 | 981900.0 |
| 2005-07-07 | ACGN-DELISTED | Stock | 612.0 | 623.3288 | 566.6712 | 600.6712 | 87700.0 |
| 2005-07-07 | ACH | Stock | 21.4667 | 21.7333 | 21.1333 | 21.6933 | 184950.0 |
> showing 50 of 4,098 rows — these rows as CSV