PREVIEW / stock_daily / 2006-05-05
file: by_date/stock_daily/2006/2006-05-05.parquet size: 148 KB rows: 4,422 symbols: 2,796
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-05 | AAPL | Stock | 2.5664 | 2.5804 | 2.5411 | 2.5675 | 563911600.0 |
| 2006-05-05 | MSFT | Stock | 23.66 | 23.95 | 23.52 | 23.8 | 131604300.0 |
| 2006-05-05 | NVDA | Stock | 0.517 | 0.5232 | 0.5098 | 0.5213 | 338184000.0 |
| 2006-05-05 | AMZN | Stock | 1.7325 | 1.752 | 1.7075 | 1.752 | 114818000.0 |
| 2006-05-05 | CL | Stock | 29.895 | 30.31 | 29.7 | 30.165 | 4498600.0 |
| 2006-05-05 | A | Stock | 27.897 | 28.0758 | 27.7897 | 28.0043 | 2047371.0 |
| 2006-05-05 | AABA-DELISTED | Stock | 32.6300010681152 | 32.75 | 32.2200012207031 | 32.6599998474121 | 14689200.0 |
| 2006-05-05 | AACC-DELISTED | Stock | 19.98 | 20.35 | 19.54 | 20.18 | 285694.0 |
| 2006-05-05 | AACQ-DELISTED | Stock | 5.38 | 5.38 | 5.38 | 5.38 | 20000.0 |
| 2006-05-05 | AACQU-DELISTED | Stock | 6.75 | 6.75 | 6.75 | 6.75 | 1295.0 |
| 2006-05-05 | AACQW-DELISTED | Stock | 0.67 | 0.7 | 0.67 | 0.69 | 42400.0 |
| 2006-05-05 | AAI-DELISTED | Stock | 14.43 | 14.58 | 14.37 | 14.42 | 1270400.0 |
| 2006-05-05 | AAIC-DELISTED | Stock | 212.0 | 215.2 | 210.6 | 213.0 | 1056500.0 |
| 2006-05-05 | AAON | Stock | 3.6214 | 3.6609 | 3.5569 | 3.6543 | 142762.0 |
| 2006-05-05 | AAP | Stock | 38.99 | 39.77 | 38.94 | 39.66 | 1031400.0 |
| 2006-05-05 | AATI-DELISTED | Stock | 11.7 | 12.73 | 11.6 | 11.96 | 607743.0 |
| 2006-05-05 | AAU-DELISTED | Stock | 2.9 | 2.91 | 2.8 | 2.85 | 59000.0 |
| 2006-05-05 | AAUAF-DELISTED | Stock | 2.9 | 2.91 | 2.8 | 2.85 | 59000.0 |
| 2006-05-05 | AAV-DELISTED | Stock | 19.33 | 19.37 | 19.15 | 19.22 | 229200.0 |
| 2006-05-05 | AAWW-DELISTED | Stock | 49.75 | 51.0 | 49.5 | 50.0 | 101000.0 |
| 2006-05-05 | AAXN-DELISTED | Stock | 10.5 | 10.6400003433228 | 10.4099998474121 | 10.6099996566772 | 904500.0 |
| 2006-05-05 | AB | Stock | 66.47 | 69.16 | 66.47 | 68.75 | 318400.0 |
| 2006-05-05 | ABAX-DELISTED | Stock | 24.0 | 24.47 | 23.86 | 24.19 | 330033.0 |
| 2006-05-05 | ABB-DELISTED | Stock | 14.4 | 14.45 | 14.34 | 14.42 | 1177900.0 |
| 2006-05-05 | ABBC-DELISTED | Stock | 13.66 | 13.74 | 13.65 | 13.6801 | 31650.0 |
| 2006-05-05 | ABC-DELISTED | Stock | 21.85 | 22.02 | 21.74 | 21.98 | 2920800.0 |
| 2006-05-05 | ABCB | Stock | 21.437 | 21.4468 | 21.3009 | 21.4468 | 9150.0 |
| 2006-05-05 | ABCO-DELISTED | Stock | 28.5 | 28.53 | 26.09 | 26.47 | 827718.0 |
| 2006-05-05 | ABCW-DELISTED | Stock | 28.79 | 29.39 | 28.53 | 29.27 | 31420.0 |
| 2006-05-05 | ABD-DELISTED | Stock | 24.6 | 25.5 | 24.55 | 25.15 | 849800.0 |
| 2006-05-05 | ABE-DELISTED | Stock | 14.63 | 14.7399 | 14.1501 | 14.25 | 42300.0 |
| 2006-05-05 | ABFS-DELISTED | Stock | 42.71 | 43.69 | 42.31 | 43.43 | 209105.0 |
| 2006-05-05 | ABG | Stock | 20.27 | 20.37 | 20.18 | 20.22 | 33100.0 |
| 2006-05-05 | ABK-DELISTED | Stock | 82.2 | 83.1 | 81.82 | 83.04 | 658200.0 |
| 2006-05-05 | ABM | Stock | 17.44 | 17.66 | 17.41 | 17.55 | 131500.0 |
| 2006-05-05 | ABMD-DELISTED | Stock | 13.33 | 13.58 | 13.16 | 13.49 | 83512.0 |
| 2006-05-05 | ABP-DELISTED | Stock | 5.97 | 6.15 | 5.97 | 6.1 | 354900.0 |
| 2006-05-05 | ABR | Stock | 25.75 | 26.0 | 25.34 | 25.34 | 94700.0 |
| 2006-05-05 | ABT | Stock | 20.1516 | 20.617 | 20.1516 | 20.521 | 6629846.0 |
| 2006-05-05 | ABTL-DELISTED | Stock | 22.0 | 22.45 | 21.6 | 21.9 | 33885.0 |
| 2006-05-05 | ABV-DELISTED | Stock | 47.52 | 48.03 | 47.35 | 47.7 | 523600.0 |
| 2006-05-05 | ABVA-DELISTED | Stock | 18.9 | 18.924 | 18.83 | 18.85 | 8636.0 |
| 2006-05-05 | ABVT-DELISTED | Stock | 41.0 | 42.0 | 41.0 | 42.0 | 400.0 |
| 2006-05-05 | ABX-DELISTED | Stock | 33.39 | 34.59 | 33.39 | 34.22 | 9626800.0 |
| 2006-05-05 | ACAD | Stock | 11.8 | 12.28 | 11.66 | 12.02 | 544800.0 |
| 2006-05-05 | ACAP-DELISTED | Stock | 46.08 | 46.93 | 45.33 | 46.55 | 38338.0 |
| 2006-05-05 | ACAS-DELISTED | Stock | 33.07 | 33.88 | 33.05 | 33.81 | 1446404.0 |
| 2006-05-05 | ACAT-DELISTED | Stock | 20.68 | 21.62 | 20.65 | 20.69 | 63612.0 |
| 2006-05-05 | ACC-DELISTED | Stock | 24.18 | 24.53 | 23.76 | 24.31 | 115000.0 |
| 2006-05-05 | ACCL-DELISTED | Stock | 6.99 | 7.11 | 6.94 | 6.98 | 87690.0 |
> showing 50 of 4,422 rows — these rows as CSV