PREVIEW / stock_daily / 2005-12-09
file: by_date/stock_daily/2005/2005-12-09.parquet size: 144 KB rows: 4,209 symbols: 2,627
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-12-09 | AAPL | Stock | 2.6504 | 2.6639 | 2.6196 | 2.6546 | 555402400.0 |
| 2005-12-09 | MSFT | Stock | 27.71 | 27.83 | 27.64 | 27.71 | 48467000.0 |
| 2005-12-09 | NVDA | Stock | 0.2995 | 0.3032 | 0.2953 | 0.3028 | 262896000.0 |
| 2005-12-09 | AMZN | Stock | 2.4325 | 2.452 | 2.4125 | 2.437 | 94180000.0 |
| 2005-12-09 | CL | Stock | 27.6 | 27.7 | 27.425 | 27.52 | 2100600.0 |
| 2005-12-09 | A | Stock | 24.8212 | 25.2933 | 24.7854 | 25.2289 | 12569837.0 |
| 2005-12-09 | AABA-DELISTED | Stock | 40.5 | 40.8699989318848 | 40.2000007629395 | 40.310001373291 | 11116900.0 |
| 2005-12-09 | AACC-DELISTED | Stock | 20.89 | 21.76 | 20.89 | 21.63 | 332148.0 |
| 2005-12-09 | AACQ-DELISTED | Stock | 5.18 | 5.2 | 5.18 | 5.2 | 22500.0 |
| 2005-12-09 | AACQU-DELISTED | Stock | 6.2 | 6.2 | 6.2 | 6.2 | 1000.0 |
| 2005-12-09 | AAI-DELISTED | Stock | 14.71 | 14.81 | 14.29 | 14.36 | 1167000.0 |
| 2005-12-09 | AAIC-DELISTED | Stock | 206.8 | 211.4 | 206.4 | 209.6 | 817100.0 |
| 2005-12-09 | AAME | Stock | 2.5 | 2.99 | 2.5 | 2.85 | 13500.0 |
| 2005-12-09 | AAON | Stock | 2.3506 | 2.3928 | 2.3506 | 2.3901 | 132891.0 |
| 2005-12-09 | AAP | Stock | 43.75 | 44.13 | 43.4 | 44.08 | 630100.0 |
| 2005-12-09 | AATI-DELISTED | Stock | 14.5 | 14.56 | 14.11 | 14.48 | 82501.0 |
| 2005-12-09 | AAV-DELISTED | Stock | 19.4 | 19.67 | 19.35 | 19.4899 | 571600.0 |
| 2005-12-09 | AAWW-DELISTED | Stock | 39.0 | 42.0 | 39.0 | 41.5 | 181300.0 |
| 2005-12-09 | AAXN-DELISTED | Stock | 6.1399998664856 | 6.28000020980835 | 6.1100001335144 | 6.1399998664856 | 908300.0 |
| 2005-12-09 | ABAX-DELISTED | Stock | 16.39 | 16.66 | 16.32 | 16.41 | 90456.0 |
| 2005-12-09 | ABB-DELISTED | Stock | 9.13 | 9.34 | 9.13 | 9.29 | 2733100.0 |
| 2005-12-09 | ABC-DELISTED | Stock | 20.35 | 20.45 | 20.3 | 20.37 | 2266000.0 |
| 2005-12-09 | ABCB | Stock | 19.4529 | 20.1823 | 19.4529 | 19.9878 | 11618.0 |
| 2005-12-09 | ABCO-DELISTED | Stock | 23.82 | 24.16 | 23.8 | 24.0 | 95752.0 |
| 2005-12-09 | ABCW-DELISTED | Stock | 31.37 | 31.67 | 30.9 | 31.19 | 73130.0 |
| 2005-12-09 | ABD-DELISTED | Stock | 23.08 | 23.37 | 22.92 | 23.25 | 239630.0 |
| 2005-12-09 | ABE-DELISTED | Stock | 11.61 | 11.75 | 11.61 | 11.73 | 19400.0 |
| 2005-12-09 | ABFS-DELISTED | Stock | 41.56 | 42.28 | 41.56 | 41.74 | 258377.0 |
| 2005-12-09 | ABG | Stock | 17.32 | 17.75 | 17.16 | 17.5 | 57900.0 |
| 2005-12-09 | ABK-DELISTED | Stock | 76.65 | 77.57 | 76.47 | 76.94 | 394000.0 |
| 2005-12-09 | ABM | Stock | 20.83 | 21.24 | 20.54 | 20.75 | 145300.0 |
| 2005-12-09 | ABMD-DELISTED | Stock | 9.01 | 9.45 | 9.01 | 9.3 | 66577.0 |
| 2005-12-09 | ABP-DELISTED | Stock | 6.55 | 6.68 | 6.4 | 6.42 | 616000.0 |
| 2005-12-09 | ABR | Stock | 26.65 | 26.9 | 26.59 | 26.68 | 103400.0 |
| 2005-12-09 | ABT | Stock | 18.4483 | 18.8226 | 18.4339 | 18.7074 | 17688203.0 |
| 2005-12-09 | ABTL-DELISTED | Stock | 26.07 | 26.58 | 26.07 | 26.48 | 15650.0 |
| 2005-12-09 | ABV-DELISTED | Stock | 37.54 | 38.05 | 37.3 | 37.8 | 242900.0 |
| 2005-12-09 | ABX-DELISTED | Stock | 28.54 | 28.58 | 27.7159 | 27.83 | 4089673.0 |
| 2005-12-09 | ACAD | Stock | 9.92 | 9.92 | 9.63 | 9.67 | 9400.0 |
| 2005-12-09 | ACAP-DELISTED | Stock | 45.34 | 47.33 | 45.26 | 47.05 | 88115.0 |
| 2005-12-09 | ACAS-DELISTED | Stock | 37.87 | 38.27 | 37.6 | 37.88 | 698431.0 |
| 2005-12-09 | ACAT-DELISTED | Stock | 20.79 | 21.36 | 20.75 | 20.86 | 60755.0 |
| 2005-12-09 | ACC-DELISTED | Stock | 25.74 | 25.78 | 25.61 | 25.66 | 51031.0 |
| 2005-12-09 | ACCL-DELISTED | Stock | 7.8 | 7.86 | 7.72 | 7.72 | 80891.0 |
| 2005-12-09 | ACCO | Stock | 23.08 | 23.37 | 22.92 | 23.25 | 240400.0 |
| 2005-12-09 | ACE-DELISTED | Stock | 53.96 | 55.05 | 53.82 | 54.99 | 1737600.0 |
| 2005-12-09 | ACF-DELISTED | Stock | 25.8 | 25.98 | 25.67 | 25.91 | 677600.0 |
| 2005-12-09 | ACFC-DELISTED | Stock | 74.18 | 74.49 | 73.16 | 73.47 | 5942.0 |
| 2005-12-09 | ACG-DELISTED | Stock | 8.22 | 8.27 | 8.2 | 8.2101 | 249800.0 |
| 2005-12-09 | ACGL | Stock | 5.91 | 5.9833 | 5.8811 | 5.98 | 3096900.0 |
> showing 50 of 4,209 rows — these rows as CSV