PREVIEW / stock_daily / 2006-05-04
file: by_date/stock_daily/2006/2006-05-04.parquet size: 148 KB rows: 4,415 symbols: 2,793
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 |
|---|---|---|---|---|---|---|---|
| 2006-05-04 | AAPL | Stock | 2.5436 | 2.6032 | 2.5164 | 2.5404 | 860420400.0 |
| 2006-05-04 | MSFT | Stock | 23.35 | 23.67 | 23.14 | 23.44 | 171257400.0 |
| 2006-05-04 | NVDA | Stock | 0.5075 | 0.52 | 0.5048 | 0.5143 | 511128000.0 |
| 2006-05-04 | AMZN | Stock | 1.731 | 1.736 | 1.719 | 1.7235 | 119958000.0 |
| 2006-05-04 | CL | Stock | 29.55 | 30.0 | 29.55 | 29.895 | 4144600.0 |
| 2006-05-04 | A | Stock | 27.8469 | 28.0973 | 27.6824 | 27.7969 | 2827735.0 |
| 2006-05-04 | AABA-DELISTED | Stock | 32.4000015258789 | 32.560001373291 | 32.0800018310547 | 32.189998626709 | 10402300.0 |
| 2006-05-04 | AACC-DELISTED | Stock | 20.5 | 20.56 | 18.83 | 20.0 | 503962.0 |
| 2006-05-04 | AACQU-DELISTED | Stock | 6.7 | 6.7 | 6.7 | 6.7 | 7500.0 |
| 2006-05-04 | AACQW-DELISTED | Stock | 0.69 | 0.69 | 0.68 | 0.68 | 15000.0 |
| 2006-05-04 | AAI-DELISTED | Stock | 14.03 | 14.33 | 13.96 | 14.3 | 1983100.0 |
| 2006-05-04 | AAIC-DELISTED | Stock | 211.2 | 212.6 | 209.4 | 211.0 | 918600.0 |
| 2006-05-04 | AAME | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 1000.0 |
| 2006-05-04 | AAON | Stock | 3.5924 | 3.6201 | 3.5819 | 3.6003 | 94162.0 |
| 2006-05-04 | AAP | Stock | 38.33 | 39.05 | 38.33 | 38.82 | 1204500.0 |
| 2006-05-04 | AATI-DELISTED | Stock | 11.21 | 11.72 | 11.21 | 11.58 | 756526.0 |
| 2006-05-04 | AAU-DELISTED | Stock | 2.98 | 2.99 | 2.75 | 2.9 | 117100.0 |
| 2006-05-04 | AAUAF-DELISTED | Stock | 2.98 | 2.99 | 2.75 | 2.9 | 117100.0 |
| 2006-05-04 | AAV-DELISTED | Stock | 19.5 | 19.5 | 19.08 | 19.2 | 338300.0 |
| 2006-05-04 | AAWW-DELISTED | Stock | 48.5 | 49.75 | 48.5 | 49.75 | 50700.0 |
| 2006-05-04 | AAXN-DELISTED | Stock | 10.7600002288818 | 10.7600002288818 | 10.3599996566772 | 10.3699998855591 | 974300.0 |
| 2006-05-04 | AB | Stock | 65.05 | 67.0 | 64.46 | 65.47 | 213900.0 |
| 2006-05-04 | ABAX-DELISTED | Stock | 24.0 | 24.29 | 23.75 | 23.87 | 433185.0 |
| 2006-05-04 | ABB-DELISTED | Stock | 14.19 | 14.33 | 14.18 | 14.24 | 839700.0 |
| 2006-05-04 | ABBC-DELISTED | Stock | 13.62 | 13.75 | 13.62 | 13.7399 | 10671.0 |
| 2006-05-04 | ABC-DELISTED | Stock | 21.86 | 21.94 | 21.72 | 21.78 | 2499800.0 |
| 2006-05-04 | ABCB | Stock | 21.1938 | 21.4468 | 21.1938 | 21.4468 | 6683.0 |
| 2006-05-04 | ABCO-DELISTED | Stock | 27.99 | 28.55 | 27.99 | 28.19 | 190421.0 |
| 2006-05-04 | ABCW-DELISTED | Stock | 28.72 | 28.78 | 28.47 | 28.7 | 20310.0 |
| 2006-05-04 | ABD-DELISTED | Stock | 23.65 | 25.0 | 23.63 | 24.62 | 657440.0 |
| 2006-05-04 | ABE-DELISTED | Stock | 14.5 | 14.64 | 14.5 | 14.53 | 41000.0 |
| 2006-05-04 | ABFS-DELISTED | Stock | 41.92 | 43.08 | 41.73 | 42.39 | 243340.0 |
| 2006-05-04 | ABG | Stock | 20.16 | 20.34 | 20.03 | 20.16 | 69900.0 |
| 2006-05-04 | ABK-DELISTED | Stock | 83.0 | 83.05 | 81.79 | 81.97 | 604100.0 |
| 2006-05-04 | ABM | Stock | 17.4 | 17.53 | 17.31 | 17.47 | 213700.0 |
| 2006-05-04 | ABMD-DELISTED | Stock | 12.76 | 13.45 | 12.76 | 13.16 | 84947.0 |
| 2006-05-04 | ABP-DELISTED | Stock | 5.9 | 6.18 | 5.85 | 5.97 | 269200.0 |
| 2006-05-04 | ABR | Stock | 25.1 | 25.5 | 25.1 | 25.38 | 44300.0 |
| 2006-05-04 | ABT | Stock | 20.3627 | 20.4203 | 20.2188 | 20.4059 | 10884118.0 |
| 2006-05-04 | ABTL-DELISTED | Stock | 21.77 | 22.03 | 21.67 | 21.98 | 16882.0 |
| 2006-05-04 | ABV-DELISTED | Stock | 47.15 | 47.59 | 46.88 | 46.93 | 372100.0 |
| 2006-05-04 | ABVA-DELISTED | Stock | 18.85 | 18.85 | 18.66 | 18.75 | 12222.0 |
| 2006-05-04 | ABVT-DELISTED | Stock | 40.0 | 40.0 | 40.0 | 40.0 | 2000.0 |
| 2006-05-04 | ABX-DELISTED | Stock | 31.5 | 33.67 | 31.46 | 33.07 | 11362300.0 |
| 2006-05-04 | ACAD | Stock | 11.89 | 11.9 | 11.6 | 11.78 | 200400.0 |
| 2006-05-04 | ACAP-DELISTED | Stock | 45.95 | 47.2 | 44.96 | 46.05 | 95809.0 |
| 2006-05-04 | ACAS-DELISTED | Stock | 33.03 | 33.43 | 32.5 | 32.83 | 1919835.0 |
| 2006-05-04 | ACAT-DELISTED | Stock | 21.13 | 21.56 | 20.47 | 20.47 | 89169.0 |
| 2006-05-04 | ACC-DELISTED | Stock | 23.69 | 24.19 | 23.69 | 24.1 | 134027.0 |
| 2006-05-04 | ACCL-DELISTED | Stock | 6.96 | 7.02 | 6.8 | 6.98 | 88558.0 |
> showing 50 of 4,415 rows — these rows as CSV