PREVIEW / stock_daily / 2006-05-15
file: by_date/stock_daily/2006/2006-05-15.parquet size: 148 KB rows: 4,448 symbols: 2,813
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-15 | AAPL | Stock | 2.4061 | 2.4421 | 2.3971 | 2.4211 | 529177600.0 |
| 2006-05-15 | MSFT | Stock | 23.1 | 23.23 | 23.03 | 23.15 | 67314800.0 |
| 2006-05-15 | NVDA | Stock | 0.438 | 0.449 | 0.4342 | 0.4452 | 553380000.0 |
| 2006-05-15 | AMZN | Stock | 1.6275 | 1.6425 | 1.6105 | 1.639 | 86100000.0 |
| 2006-05-15 | CL | Stock | 29.55 | 29.835 | 29.405 | 29.825 | 4728200.0 |
| 2006-05-15 | A | Stock | 26.7167 | 27.2747 | 26.6452 | 27.1602 | 4782698.0 |
| 2006-05-15 | AABA-DELISTED | Stock | 30.8500003814697 | 31.25 | 30.6000003814697 | 31.0300006866455 | 13350700.0 |
| 2006-05-15 | AACC-DELISTED | Stock | 18.85 | 18.99 | 18.47 | 18.5 | 227267.0 |
| 2006-05-15 | AACQU-DELISTED | Stock | 6.7 | 6.7 | 6.7 | 6.7 | 7755.0 |
| 2006-05-15 | AACQW-DELISTED | Stock | 0.7 | 0.7 | 0.65 | 0.65 | 55000.0 |
| 2006-05-15 | AAI-DELISTED | Stock | 13.33 | 13.66 | 13.22 | 13.56 | 1623400.0 |
| 2006-05-15 | AAIC-DELISTED | Stock | 204.6 | 204.8 | 200.6 | 203.8 | 765800.0 |
| 2006-05-15 | AAME | Stock | 3.05 | 3.18 | 2.95 | 3.1 | 15100.0 |
| 2006-05-15 | AAON | Stock | 3.4568 | 3.5279 | 3.3343 | 3.337 | 145800.0 |
| 2006-05-15 | AAP | Stock | 40.09 | 40.18 | 39.41 | 39.45 | 1392800.0 |
| 2006-05-15 | AATI-DELISTED | Stock | 11.18 | 11.26 | 10.91 | 11.05 | 583215.0 |
| 2006-05-15 | AAU-DELISTED | Stock | 2.9 | 2.91 | 2.65 | 2.7 | 149100.0 |
| 2006-05-15 | AAUAF-DELISTED | Stock | 2.9 | 2.91 | 2.65 | 2.7 | 149100.0 |
| 2006-05-15 | AAV-DELISTED | Stock | 19.31 | 19.31 | 19.02 | 19.15 | 515000.0 |
| 2006-05-15 | AAWW-DELISTED | Stock | 50.0 | 50.0 | 49.25 | 50.0 | 100400.0 |
| 2006-05-15 | AAXN-DELISTED | Stock | 9.4399995803833 | 10.75 | 9.27000045776367 | 9.56999969482422 | 2899100.0 |
| 2006-05-15 | AB | Stock | 64.6 | 65.6 | 63.8 | 65.02 | 196100.0 |
| 2006-05-15 | ABAX-DELISTED | Stock | 18.44 | 18.8075 | 17.65 | 18.06 | 600436.0 |
| 2006-05-15 | ABB-DELISTED | Stock | 13.67 | 13.75 | 13.55 | 13.68 | 2347900.0 |
| 2006-05-15 | ABBC-DELISTED | Stock | 13.74 | 13.86 | 13.74 | 13.83 | 1300.0 |
| 2006-05-15 | ABC-DELISTED | Stock | 22.0 | 22.35 | 21.98 | 22.08 | 2129200.0 |
| 2006-05-15 | ABCB | Stock | 19.8419 | 20.124 | 19.4626 | 19.8127 | 34134.0 |
| 2006-05-15 | ABCO-DELISTED | Stock | 25.77 | 25.84 | 24.31 | 24.63 | 759646.0 |
| 2006-05-15 | ABCW-DELISTED | Stock | 28.46 | 29.3 | 28.46 | 29.0 | 58480.0 |
| 2006-05-15 | ABD-DELISTED | Stock | 23.1 | 23.25 | 22.56 | 23.0 | 341400.0 |
| 2006-05-15 | ABE-DELISTED | Stock | 13.42 | 13.42 | 13.0 | 13.02 | 61700.0 |
| 2006-05-15 | ABFS-DELISTED | Stock | 43.0 | 44.07 | 42.79 | 43.56 | 254136.0 |
| 2006-05-15 | ABG | Stock | 19.5 | 19.64 | 19.23 | 19.58 | 62000.0 |
| 2006-05-15 | ABK-DELISTED | Stock | 82.38 | 83.16 | 82.21 | 82.79 | 1173700.0 |
| 2006-05-15 | ABM | Stock | 17.1 | 17.35 | 17.02 | 17.25 | 289300.0 |
| 2006-05-15 | ABMD-DELISTED | Stock | 12.1 | 12.24 | 12.02 | 12.06 | 88159.0 |
| 2006-05-15 | ABP-DELISTED | Stock | 5.1 | 5.1 | 4.85 | 4.9 | 643200.0 |
| 2006-05-15 | ABR | Stock | 24.49 | 24.55 | 24.28 | 24.5 | 151900.0 |
| 2006-05-15 | ABT | Stock | 19.9933 | 20.4299 | 19.8637 | 20.2955 | 10148187.0 |
| 2006-05-15 | ABTL-DELISTED | Stock | 17.8 | 18.2 | 17.65 | 17.75 | 54671.0 |
| 2006-05-15 | ABV-DELISTED | Stock | 44.25 | 45.35 | 43.56 | 43.85 | 1674700.0 |
| 2006-05-15 | ABVA-DELISTED | Stock | 18.7 | 18.75 | 18.61 | 18.75 | 8705.0 |
| 2006-05-15 | ABX-DELISTED | Stock | 32.31 | 33.02 | 31.85 | 32.26 | 8030000.0 |
| 2006-05-15 | ACAD | Stock | 10.75 | 11.49 | 10.65 | 11.35 | 427100.0 |
| 2006-05-15 | ACAP-DELISTED | Stock | 44.15 | 44.83 | 43.88 | 44.12 | 62458.0 |
| 2006-05-15 | ACAS-DELISTED | Stock | 34.34 | 34.34 | 33.5 | 33.74 | 1960154.0 |
| 2006-05-15 | ACAT-DELISTED | Stock | 18.88 | 19.55 | 18.62 | 19.2 | 150471.0 |
| 2006-05-15 | ACC-DELISTED | Stock | 23.35 | 23.46 | 22.79 | 23.02 | 71800.0 |
| 2006-05-15 | ACCL-DELISTED | Stock | 7.02 | 7.11 | 7.0 | 7.05 | 128062.0 |
| 2006-05-15 | ACCO | Stock | 23.1 | 23.25 | 22.56 | 23.0 | 351500.0 |
> showing 50 of 4,448 rows — these rows as CSV