PREVIEW / stock_daily / 2005-07-01
file: by_date/stock_daily/2005/2005-07-01.parquet size: 136 KB rows: 4,081 symbols: 2,550
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-01 | AAPL | Stock | 1.3154 | 1.3204 | 1.2961 | 1.3036 | 250000800.0 |
| 2005-07-01 | MSFT | Stock | 24.85 | 24.99 | 24.67 | 24.71 | 69718400.0 |
| 2005-07-01 | NVDA | Stock | 0.2219 | 0.224 | 0.2192 | 0.2237 | 315168000.0 |
| 2005-07-01 | AMZN | Stock | 1.662 | 1.6635 | 1.6395 | 1.6455 | 58654000.0 |
| 2005-07-01 | CL | Stock | 25.07 | 25.325 | 24.965 | 25.025 | 3393000.0 |
| 2005-07-01 | A | Stock | 16.5951 | 16.8455 | 16.5451 | 16.7382 | 2282794.0 |
| 2005-07-01 | AABA-DELISTED | Stock | 34.7599983215332 | 34.8499984741211 | 34.2200012207031 | 34.439998626709 | 9861600.0 |
| 2005-07-01 | AACC-DELISTED | Stock | 25.8 | 26.44 | 25.78 | 25.88 | 135806.0 |
| 2005-07-01 | AACQ-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 1000.0 |
| 2005-07-01 | AAI-DELISTED | Stock | 9.27 | 9.32 | 9.0 | 9.27 | 876300.0 |
| 2005-07-01 | AAIC-DELISTED | Stock | 287.0 | 294.6 | 286.8 | 293.0 | 1076800.0 |
| 2005-07-01 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 3800.0 |
| 2005-07-01 | AAON | Stock | 2.3506 | 2.402 | 2.3506 | 2.3849 | 91884.0 |
| 2005-07-01 | AAP | Stock | 43.16 | 44.0067 | 43.16 | 43.7667 | 738900.0 |
| 2005-07-01 | AAV-DELISTED | Stock | 13.65 | 13.65 | 13.65 | 13.65 | 100.0 |
| 2005-07-01 | AAXN-DELISTED | Stock | 10.2299995422363 | 10.25 | 10.039999961853 | 10.1000003814697 | 1354100.0 |
| 2005-07-01 | ABAX-DELISTED | Stock | 10.8 | 10.94 | 10.77 | 10.93 | 41745.0 |
| 2005-07-01 | ABB-DELISTED | Stock | 6.42 | 6.45 | 6.38 | 6.42 | 2836500.0 |
| 2005-07-01 | ABBC-DELISTED | Stock | 12.31 | 12.38 | 12.08 | 12.25 | 9471.0 |
| 2005-07-01 | ABC-DELISTED | Stock | 17.37 | 17.43 | 17.26 | 17.4 | 2446400.0 |
| 2005-07-01 | ABCB | Stock | 17.809 | 17.809 | 17.3714 | 17.42 | 7608.0 |
| 2005-07-01 | ABCO-DELISTED | Stock | 24.26 | 24.53 | 24.1 | 24.49 | 311053.0 |
| 2005-07-01 | ABCW-DELISTED | Stock | 30.04 | 30.8 | 30.04 | 30.23 | 32550.0 |
| 2005-07-01 | ABE-DELISTED | Stock | 10.07 | 10.07 | 9.96 | 9.97 | 35800.0 |
| 2005-07-01 | ABFS-DELISTED | Stock | 31.8 | 32.57 | 31.64 | 32.56 | 264573.0 |
| 2005-07-01 | ABG | Stock | 15.41 | 15.45 | 15.16 | 15.33 | 36200.0 |
| 2005-07-01 | ABK-DELISTED | Stock | 69.84 | 70.41 | 69.67 | 70.33 | 306300.0 |
| 2005-07-01 | ABM | Stock | 19.43 | 19.83 | 19.39 | 19.83 | 149700.0 |
| 2005-07-01 | ABMD-DELISTED | Stock | 8.6 | 8.6 | 8.31 | 8.6 | 51804.0 |
| 2005-07-01 | ABP-DELISTED | Stock | 2.77 | 2.82 | 2.71 | 2.78 | 56600.0 |
| 2005-07-01 | ABR | Stock | 28.75 | 28.95 | 28.59 | 28.95 | 37600.0 |
| 2005-07-01 | ABT | Stock | 23.6206 | 23.8173 | 23.4958 | 23.5246 | 7019591.0 |
| 2005-07-01 | ABTL-DELISTED | Stock | 24.13 | 24.57 | 23.77 | 24.32 | 16967.0 |
| 2005-07-01 | ABV-DELISTED | Stock | 30.97 | 31.2 | 30.85 | 31.16 | 163100.0 |
| 2005-07-01 | ABVA-DELISTED | Stock | 15.0 | 15.0 | 14.99 | 14.99 | 1067.0 |
| 2005-07-01 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 300.0 |
| 2005-07-01 | ABX-DELISTED | Stock | 25.26 | 25.38 | 24.63 | 25.27 | 1689138.0 |
| 2005-07-01 | ACAD | Stock | 8.33 | 8.5 | 8.06 | 8.34 | 102200.0 |
| 2005-07-01 | ACAP-DELISTED | Stock | 36.82 | 37.35 | 36.73 | 37.32 | 41330.0 |
| 2005-07-01 | ACAS-DELISTED | Stock | 36.41 | 36.46 | 35.98 | 36.2 | 501445.0 |
| 2005-07-01 | ACAT-DELISTED | Stock | 20.67 | 21.02 | 20.61 | 20.91 | 58857.0 |
| 2005-07-01 | ACC-DELISTED | Stock | 22.68 | 22.78 | 22.5 | 22.72 | 124300.0 |
| 2005-07-01 | ACCL-DELISTED | Stock | 4.93 | 5.02 | 4.85 | 4.86 | 109292.0 |
| 2005-07-01 | ACE-DELISTED | Stock | 45.0 | 45.36 | 44.93 | 45.28 | 789300.0 |
| 2005-07-01 | ACF-DELISTED | Stock | 25.64 | 25.84 | 25.55 | 25.69 | 743700.0 |
| 2005-07-01 | ACFC-DELISTED | Stock | 63.11 | 64.74 | 62.81 | 63.06 | 2278.0 |
| 2005-07-01 | ACG-DELISTED | Stock | 8.31 | 8.35 | 8.3 | 8.31 | 298400.0 |
| 2005-07-01 | ACGL | Stock | 5.0211 | 5.0444 | 5.0 | 5.0378 | 566100.0 |
| 2005-07-01 | ACGN-DELISTED | Stock | 612.0 | 634.6712 | 600.6712 | 634.6712 | 55700.0 |
| 2005-07-01 | ACH | Stock | 21.6133 | 21.7533 | 21.3067 | 21.66 | 147600.0 |
> showing 50 of 4,081 rows — these rows as CSV