PREVIEW / stock_daily / 2009-06-11
file: by_date/stock_daily/2009/2009-06-11.parquet size: 182 KB rows: 5,814 symbols: 3,470
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-11 | AAPL | Stock | 4.9839 | 5.0557 | 4.9482 | 4.9982 | 524823600.0 |
| 2009-06-11 | MSFT | Stock | 22.59 | 23.26 | 22.57 | 22.83 | 65124600.0 |
| 2009-06-11 | NVDA | Stock | 0.2938 | 0.305 | 0.2875 | 0.2892 | 835156000.0 |
| 2009-06-11 | AMZN | Stock | 4.315 | 4.3745 | 4.2525 | 4.2845 | 100194000.0 |
| 2009-06-11 | TLT | Stock | 87.76 | 89.52 | 87.69 | 89.17 | 10693783.0 |
| 2009-06-11 | ES | Stock | 21.33 | 21.91 | 21.16 | 21.61 | 1095200.0 |
| 2009-06-11 | CL | Stock | 35.175 | 35.595 | 35.095 | 35.13 | 5168400.0 |
| 2009-06-11 | A | Stock | 13.9342 | 14.3777 | 13.8913 | 14.1059 | 4628638.0 |
| 2009-06-11 | AABA-DELISTED | Stock | 16.29 | 16.46 | 16.15 | 16.18 | 14832819.0 |
| 2009-06-11 | AACC-DELISTED | Stock | 8.95 | 9.06 | 8.71 | 8.91 | 11236.0 |
| 2009-06-11 | AACG | Stock | 6.97 | 7.2 | 6.89 | 7.02 | 31100.0 |
| 2009-06-11 | AAI-DELISTED | Stock | 5.53 | 5.67 | 5.33 | 5.48 | 3360111.0 |
| 2009-06-11 | AAIC-DELISTED | Stock | 9.4 | 9.8 | 8.8 | 9.0 | 309076.0 |
| 2009-06-11 | AAME | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 200.0 |
| 2009-06-11 | AAON | Stock | 4.0928 | 4.2449 | 4.083 | 4.1126 | 184781.0 |
| 2009-06-11 | AAP | Stock | 43.41 | 43.67 | 41.43 | 41.52 | 2995200.0 |
| 2009-06-11 | AATI-DELISTED | Stock | 4.64 | 4.82 | 4.62 | 4.79 | 224294.0 |
| 2009-06-11 | AAU-DELISTED | Stock | 0.7919 | 0.7919 | 0.73 | 0.76 | 121225.0 |
| 2009-06-11 | AAUAF-DELISTED | Stock | 0.7919 | 0.7919 | 0.73 | 0.76 | 131225.0 |
| 2009-06-11 | AAV-DELISTED | Stock | 5.41 | 5.97 | 5.37 | 5.74 | 2813480.0 |
| 2009-06-11 | AAWW-DELISTED | Stock | 25.52 | 25.74 | 25.1 | 25.16 | 168043.0 |
| 2009-06-11 | AAXJ | Stock | 46.16 | 46.88 | 45.89 | 46.48 | 1284161.0 |
| 2009-06-11 | AAXN-DELISTED | Stock | 4.42 | 4.54 | 4.4 | 4.51 | 347538.0 |
| 2009-06-11 | AB | Stock | 21.78 | 22.5 | 21.35 | 22.21 | 369600.0 |
| 2009-06-11 | ABAX-DELISTED | Stock | 17.33 | 17.63 | 17.24 | 17.4 | 172613.0 |
| 2009-06-11 | ABB-DELISTED | Stock | 16.59 | 17.08 | 16.58 | 16.84 | 2977790.0 |
| 2009-06-11 | ABBC-DELISTED | Stock | 8.32 | 8.75 | 8.23 | 8.34 | 36641.0 |
| 2009-06-11 | ABBNY-DELISTED | Stock | 16.58 | 17.08 | 16.58 | 16.83 | 2981190.0 |
| 2009-06-11 | ABC-DELISTED | Stock | 17.92 | 18.81 | 17.92 | 18.51 | 4807044.0 |
| 2009-06-11 | ABCB | Stock | 6.1374 | 6.5459 | 6.0791 | 6.0888 | 23647.0 |
| 2009-06-11 | ABCO-DELISTED | Stock | 12.577 | 13.078 | 12.522 | 12.753 | 280740.0 |
| 2009-06-11 | ABCW-DELISTED | Stock | 1.35 | 1.48 | 1.3 | 1.33 | 151640.0 |
| 2009-06-11 | ABD-DELISTED | Stock | 3.41 | 3.4401 | 3.28 | 3.36 | 185350.0 |
| 2009-06-11 | ABE-DELISTED | Stock | 15.8 | 15.95 | 15.63 | 15.94 | 12315.0 |
| 2009-06-11 | ABEO | Stock | 2800.0 | 2812.5 | 2687.5 | 2725.0 | 49.0 |
| 2009-06-11 | ABFS-DELISTED | Stock | 29.55 | 30.16 | 28.9 | 29.08 | 506942.0 |
| 2009-06-11 | ABG | Stock | 11.9 | 12.02 | 11.32 | 11.91 | 294400.0 |
| 2009-06-11 | ABII-DELISTED | Stock | 42.65 | 42.65 | 41.35 | 42.0 | 20920.0 |
| 2009-06-11 | ABK-DELISTED | Stock | 1.26 | 1.27 | 1.25 | 1.26 | 3264582.0 |
| 2009-06-11 | ABM | Stock | 18.81 | 18.98 | 18.5 | 18.53 | 198800.0 |
| 2009-06-11 | ABMD-DELISTED | Stock | 7.41 | 7.65 | 7.28 | 7.5 | 321988.0 |
| 2009-06-11 | ABR | Stock | 1.63 | 2.15 | 1.59 | 2.06 | 830300.0 |
| 2009-06-11 | ABT | Stock | 21.212 | 21.6342 | 21.2024 | 21.3799 | 19195498.0 |
| 2009-06-11 | ABTL-DELISTED | Stock | 2.0997 | 2.1756 | 2.0744 | 2.1503 | 4127.0 |
| 2009-06-11 | ABV-DELISTED | Stock | 65.87 | 67.76 | 65.87 | 66.9 | 508882.0 |
| 2009-06-11 | ABVT-DELISTED | Stock | 82.0 | 83.17 | 77.37 | 77.9 | 31282.0 |
| 2009-06-11 | ABX-DELISTED | Stock | 34.95 | 35.24 | 34.11 | 34.66 | 10647767.0 |
| 2009-06-11 | ACAD | Stock | 2.34 | 2.37 | 2.15 | 2.17 | 209100.0 |
| 2009-06-11 | ACAP-DELISTED | Stock | 40.83 | 41.7 | 40.4 | 40.54 | 24787.0 |
| 2009-06-11 | ACAS-DELISTED | Stock | 2.82 | 3.47 | 2.72 | 3.35 | 24987686.0 |
> showing 50 of 5,814 rows — these rows as CSV