PREVIEW / stock_daily / 2005-06-28
file: by_date/stock_daily/2005/2005-06-28.parquet size: 138 KB rows: 4,117 symbols: 2,580
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-06-28 | AAPL | Stock | 1.3389 | 1.3425 | 1.3275 | 1.3325 | 350299600.0 |
| 2005-06-28 | MSFT | Stock | 25.09 | 25.2 | 25.03 | 25.07 | 53058100.0 |
| 2005-06-28 | NVDA | Stock | 0.2248 | 0.2268 | 0.2223 | 0.2253 | 262308000.0 |
| 2005-06-28 | AMZN | Stock | 1.73 | 1.7315 | 1.6795 | 1.6855 | 140686000.0 |
| 2005-06-28 | CL | Stock | 25.16 | 25.49 | 25.075 | 25.315 | 4817000.0 |
| 2005-06-28 | A | Stock | 16.7024 | 16.8312 | 16.6524 | 16.8026 | 2806345.0 |
| 2005-06-28 | AABA-DELISTED | Stock | 35.9500007629395 | 36.2400016784668 | 35.5099983215332 | 35.7999992370605 | 13346200.0 |
| 2005-06-28 | AACC-DELISTED | Stock | 25.0 | 25.5 | 24.85 | 25.35 | 171058.0 |
| 2005-06-28 | AACQ-DELISTED | Stock | 5.01 | 5.01 | 4.95 | 5.0 | 21000.0 |
| 2005-06-28 | AACQU-DELISTED | Stock | 6.05 | 6.095 | 6.05 | 6.095 | 46047.0 |
| 2005-06-28 | AACQW-DELISTED | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 50000.0 |
| 2005-06-28 | AAI-DELISTED | Stock | 9.07 | 9.47 | 9.01 | 9.47 | 1382300.0 |
| 2005-06-28 | AAIC-DELISTED | Stock | 280.4 | 287.6 | 280.4 | 283.6 | 1848000.0 |
| 2005-06-28 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 400.0 |
| 2005-06-28 | AAON | Stock | 2.3177 | 2.4244 | 2.3058 | 2.3888 | 141244.0 |
| 2005-06-28 | AAP | Stock | 42.7 | 43.6533 | 42.7 | 43.4333 | 357750.0 |
| 2005-06-28 | AAV-DELISTED | Stock | 14.12 | 14.3 | 13.32 | 14.12 | 117200.0 |
| 2005-06-28 | AAXN-DELISTED | Stock | 10.1499996185303 | 10.5200004577637 | 10.1499996185303 | 10.25 | 3543900.0 |
| 2005-06-28 | ABAX-DELISTED | Stock | 10.9 | 11.24 | 10.76 | 11.22 | 73472.0 |
| 2005-06-28 | ABB-DELISTED | Stock | 6.79 | 6.92 | 6.79 | 6.89 | 1780100.0 |
| 2005-06-28 | ABBC-DELISTED | Stock | 12.65 | 12.65 | 12.11 | 12.14 | 44580.0 |
| 2005-06-28 | ABC-DELISTED | Stock | 16.75 | 17.0 | 16.75 | 16.99 | 4160774.0 |
| 2005-06-28 | ABCB | Stock | 17.2157 | 17.5367 | 17.0213 | 17.5075 | 19123.0 |
| 2005-06-28 | ABCO-DELISTED | Stock | 23.43 | 24.72 | 23.29 | 24.55 | 220800.0 |
| 2005-06-28 | ABCW-DELISTED | Stock | 29.93 | 30.42 | 29.73 | 30.32 | 64250.0 |
| 2005-06-28 | ABE-DELISTED | Stock | 10.0 | 10.09 | 9.95 | 10.09 | 4000.0 |
| 2005-06-28 | ABFS-DELISTED | Stock | 30.96 | 32.22 | 30.78 | 32.21 | 252304.0 |
| 2005-06-28 | ABG | Stock | 15.6 | 15.96 | 15.55 | 15.89 | 44300.0 |
| 2005-06-28 | ABK-DELISTED | Stock | 69.53 | 70.81 | 69.38 | 70.69 | 596900.0 |
| 2005-06-28 | ABM | Stock | 19.0 | 19.25 | 18.89 | 19.24 | 167900.0 |
| 2005-06-28 | ABMD-DELISTED | Stock | 8.46 | 8.7 | 8.35 | 8.68 | 106983.0 |
| 2005-06-28 | ABP-DELISTED | Stock | 2.84 | 2.84 | 2.75 | 2.77 | 68700.0 |
| 2005-06-28 | ABR | Stock | 28.4 | 28.7 | 28.25 | 28.45 | 90500.0 |
| 2005-06-28 | ABT | Stock | 23.5822 | 23.7837 | 23.5054 | 23.7501 | 5129221.0 |
| 2005-06-28 | ABTL-DELISTED | Stock | 23.4 | 24.45 | 23.3 | 24.45 | 32242.0 |
| 2005-06-28 | ABV-DELISTED | Stock | 30.7 | 30.76 | 30.29 | 30.69 | 172300.0 |
| 2005-06-28 | ABVT-DELISTED | Stock | 25.0 | 25.0 | 25.0 | 25.0 | 200.0 |
| 2005-06-28 | ABX-DELISTED | Stock | 24.5 | 24.81 | 24.35 | 24.7 | 1156900.0 |
| 2005-06-28 | ACAD | Stock | 8.72 | 8.89 | 8.63 | 8.84 | 36300.0 |
| 2005-06-28 | ACAP-DELISTED | Stock | 36.08 | 36.99 | 36.0 | 36.99 | 63525.0 |
| 2005-06-28 | ACAS-DELISTED | Stock | 35.87 | 35.91 | 35.75 | 35.83 | 549408.0 |
| 2005-06-28 | ACAT-DELISTED | Stock | 20.43 | 20.81 | 20.35 | 20.58 | 161187.0 |
| 2005-06-28 | ACC-DELISTED | Stock | 22.2 | 23.36 | 22.2 | 23.05 | 267600.0 |
| 2005-06-28 | ACCL-DELISTED | Stock | 4.81 | 4.85 | 4.73 | 4.85 | 193885.0 |
| 2005-06-28 | ACE-DELISTED | Stock | 44.18 | 44.77 | 43.75 | 44.71 | 1436840.0 |
| 2005-06-28 | ACF-DELISTED | Stock | 24.97 | 25.45 | 24.96 | 25.28 | 968100.0 |
| 2005-06-28 | ACFC-DELISTED | Stock | 62.65 | 63.83 | 62.65 | 63.78 | 5642.0 |
| 2005-06-28 | ACG-DELISTED | Stock | 8.29 | 8.31 | 8.27 | 8.3 | 365600.0 |
| 2005-06-28 | ACGL | Stock | 4.9544 | 5.0444 | 4.9533 | 5.0 | 2440800.0 |
| 2005-06-28 | ACGN-DELISTED | Stock | 646.0 | 646.0 | 623.3288 | 646.0 | 40000.0 |
> showing 50 of 4,117 rows — these rows as CSV