PREVIEW / stock_daily / 2006-03-24
file: by_date/stock_daily/2006/2006-03-24.parquet size: 146 KB rows: 4,351 symbols: 2,742
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-03-24 | AAPL | Stock | 2.1518 | 2.1764 | 2.1082 | 2.1414 | 1071980000.0 |
| 2006-03-24 | MSFT | Stock | 26.71 | 27.21 | 26.62 | 27.01 | 69157600.0 |
| 2006-03-24 | NVDA | Stock | 0.4198 | 0.4337 | 0.4192 | 0.4329 | 687936000.0 |
| 2006-03-24 | AMZN | Stock | 1.786 | 1.806 | 1.7655 | 1.7735 | 73640000.0 |
| 2006-03-24 | CL | Stock | 28.65 | 28.905 | 28.515 | 28.9 | 3625400.0 |
| 2006-03-24 | A | Stock | 26.5379 | 26.824 | 26.5021 | 26.731 | 2495849.0 |
| 2006-03-24 | AABA-DELISTED | Stock | 32.2799987792969 | 32.310001373291 | 31.5300006866455 | 31.7700004577637 | 17816500.0 |
| 2006-03-24 | AACC-DELISTED | Stock | 19.2 | 19.26 | 18.7632 | 19.08 | 217108.0 |
| 2006-03-24 | AACQ-DELISTED | Stock | 5.47 | 5.47 | 5.44 | 5.46 | 4500.0 |
| 2006-03-24 | AACQU-DELISTED | Stock | 7.0 | 7.0 | 7.0 | 7.0 | 1250.0 |
| 2006-03-24 | AAI-DELISTED | Stock | 17.72 | 17.92 | 17.28 | 17.89 | 1127300.0 |
| 2006-03-24 | AAIC-DELISTED | Stock | 186.4 | 189.0 | 186.0 | 187.4 | 619700.0 |
| 2006-03-24 | AAME | Stock | 2.81 | 2.84 | 2.77 | 2.84 | 500.0 |
| 2006-03-24 | AAON | Stock | 2.9959 | 2.9985 | 2.9656 | 2.9919 | 31894.0 |
| 2006-03-24 | AAP | Stock | 41.84 | 42.15 | 41.8 | 42.0 | 630900.0 |
| 2006-03-24 | AATI-DELISTED | Stock | 10.74 | 10.8 | 10.6 | 10.69 | 212219.0 |
| 2006-03-24 | AAU-DELISTED | Stock | 2.55 | 2.66 | 2.55 | 2.65 | 100600.0 |
| 2006-03-24 | AAUAF-DELISTED | Stock | 2.55 | 2.66 | 2.55 | 2.65 | 100600.0 |
| 2006-03-24 | AAV-DELISTED | Stock | 19.44 | 19.44 | 19.16 | 19.29 | 297100.0 |
| 2006-03-24 | AAWW-DELISTED | Stock | 47.0 | 47.5 | 47.0 | 47.5 | 25300.0 |
| 2006-03-24 | AAXN-DELISTED | Stock | 10.789999961853 | 11.1300001144409 | 10.6999998092651 | 10.8500003814697 | 1557100.0 |
| 2006-03-24 | AB | Stock | 64.5 | 64.69 | 64.15 | 64.34 | 125400.0 |
| 2006-03-24 | ABAX-DELISTED | Stock | 23.67 | 24.395 | 23.35 | 24.37 | 265788.0 |
| 2006-03-24 | ABB-DELISTED | Stock | 11.97 | 12.08 | 11.94 | 12.08 | 901300.0 |
| 2006-03-24 | ABBC-DELISTED | Stock | 13.32 | 13.38 | 13.3 | 13.38 | 1115.0 |
| 2006-03-24 | ABC-DELISTED | Stock | 23.52 | 23.72 | 23.4 | 23.66 | 1500600.0 |
| 2006-03-24 | ABCB | Stock | 21.9526 | 22.1179 | 21.5829 | 21.9234 | 9870.0 |
| 2006-03-24 | ABCO-DELISTED | Stock | 28.17 | 28.37 | 27.91 | 28.14 | 131596.0 |
| 2006-03-24 | ABCW-DELISTED | Stock | 29.4 | 29.67 | 29.32 | 29.5 | 28770.0 |
| 2006-03-24 | ABD-DELISTED | Stock | 21.99 | 22.0 | 21.6 | 21.69 | 158900.0 |
| 2006-03-24 | ABE-DELISTED | Stock | 12.8 | 12.8 | 12.58 | 12.6 | 18000.0 |
| 2006-03-24 | ABFS-DELISTED | Stock | 40.7 | 41.25 | 40.321 | 40.97 | 313891.0 |
| 2006-03-24 | ABG | Stock | 20.15 | 20.55 | 19.8 | 20.32 | 59400.0 |
| 2006-03-24 | ABK-DELISTED | Stock | 79.42 | 79.64 | 78.96 | 79.42 | 329700.0 |
| 2006-03-24 | ABM | Stock | 17.62 | 17.67 | 17.48 | 17.53 | 144000.0 |
| 2006-03-24 | ABMD-DELISTED | Stock | 12.91 | 13.28 | 12.84 | 13.18 | 187194.0 |
| 2006-03-24 | ABP-DELISTED | Stock | 5.73 | 5.87 | 5.7 | 5.86 | 242200.0 |
| 2006-03-24 | ABR | Stock | 27.3 | 27.35 | 26.94 | 27.11 | 104000.0 |
| 2006-03-24 | ABT | Stock | 20.9673 | 21.1016 | 20.8137 | 21.0488 | 12538141.0 |
| 2006-03-24 | ABTL-DELISTED | Stock | 23.0 | 23.1 | 22.75 | 23.0 | 25618.0 |
| 2006-03-24 | ABV-DELISTED | Stock | 41.88 | 42.3 | 41.52 | 41.7 | 465200.0 |
| 2006-03-24 | ABX-DELISTED | Stock | 25.93 | 26.36 | 25.87 | 26.19 | 4328100.0 |
| 2006-03-24 | ACAD | Stock | 15.3 | 15.35 | 14.55 | 14.81 | 1547200.0 |
| 2006-03-24 | ACAP-DELISTED | Stock | 48.86 | 49.16 | 47.77 | 48.2 | 45874.0 |
| 2006-03-24 | ACAS-DELISTED | Stock | 35.015 | 35.05 | 34.92 | 34.99 | 903286.0 |
| 2006-03-24 | ACAT-DELISTED | Stock | 23.88 | 24.041 | 23.79 | 23.93 | 21642.0 |
| 2006-03-24 | ACC-DELISTED | Stock | 26.85 | 26.87 | 26.36 | 26.56 | 33100.0 |
| 2006-03-24 | ACCL-DELISTED | Stock | 7.38 | 7.39 | 7.25 | 7.27 | 62483.0 |
| 2006-03-24 | ACCO | Stock | 21.99 | 22.0 | 21.6 | 21.69 | 161100.0 |
| 2006-03-24 | ACCP-DELISTED | Stock | 1.45 | 1.6 | 1.45 | 1.55 | 19900.0 |
> showing 50 of 4,351 rows — these rows as CSV