PREVIEW / stock_daily / 2009-06-05
file: by_date/stock_daily/2009/2009-06-05.parquet size: 181 KB rows: 5,781 symbols: 3,457
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-05 | AAPL | Stock | 5.1896 | 5.2286 | 5.1146 | 5.1668 | 632716000.0 |
| 2009-06-05 | MSFT | Stock | 21.96 | 22.31 | 21.81 | 22.14 | 59579200.0 |
| 2009-06-05 | NVDA | Stock | 0.2772 | 0.2772 | 0.2675 | 0.2708 | 559992000.0 |
| 2009-06-05 | AMZN | Stock | 4.3145 | 4.3975 | 4.265 | 4.378 | 165270000.0 |
| 2009-06-05 | TLT | Stock | 89.91 | 90.9 | 89.55 | 89.84 | 8441002.0 |
| 2009-06-05 | ES | Stock | 21.32 | 21.46 | 20.92 | 21.23 | 1403000.0 |
| 2009-06-05 | CL | Stock | 35.635 | 35.85 | 35.25 | 35.45 | 7664600.0 |
| 2009-06-05 | A | Stock | 14.4421 | 14.5494 | 14.1273 | 14.2346 | 3230359.0 |
| 2009-06-05 | AABA-DELISTED | Stock | 16.76 | 16.99 | 16.3 | 16.64 | 17169880.0 |
| 2009-06-05 | AACC-DELISTED | Stock | 9.09 | 9.13 | 8.3 | 8.94 | 20995.0 |
| 2009-06-05 | AACG | Stock | 5.9 | 6.78 | 5.76 | 6.4 | 58600.0 |
| 2009-06-05 | AAI-DELISTED | Stock | 6.4 | 6.4 | 6.07 | 6.18 | 1531479.0 |
| 2009-06-05 | AAIC-DELISTED | Stock | 8.8 | 9.6 | 8.6 | 9.4 | 728141.0 |
| 2009-06-05 | AAME | Stock | 0.76 | 0.76 | 0.76 | 0.76 | 2000.0 |
| 2009-06-05 | AAON | Stock | 4.3319 | 4.3319 | 4.2094 | 4.2844 | 300712.0 |
| 2009-06-05 | AAP | Stock | 44.74 | 44.98 | 43.5 | 43.78 | 2034500.0 |
| 2009-06-05 | AATI-DELISTED | Stock | 4.85 | 4.91 | 4.62 | 4.65 | 207316.0 |
| 2009-06-05 | AAU-DELISTED | Stock | 0.83 | 0.83 | 0.8 | 0.8 | 93195.0 |
| 2009-06-05 | AAUAF-DELISTED | Stock | 0.83 | 0.83 | 0.8 | 0.8 | 93695.0 |
| 2009-06-05 | AAV-DELISTED | Stock | 4.73 | 4.95 | 4.69 | 4.73 | 1268058.0 |
| 2009-06-05 | AAWW-DELISTED | Stock | 26.08 | 26.4 | 25.5 | 26.1 | 255106.0 |
| 2009-06-05 | AAXJ | Stock | 46.27 | 46.4 | 45.2 | 45.75 | 686657.0 |
| 2009-06-05 | AAXN-DELISTED | Stock | 4.72 | 4.77 | 4.65 | 4.67 | 182750.0 |
| 2009-06-05 | AB | Stock | 20.47 | 21.9 | 20.25 | 20.87 | 1063800.0 |
| 2009-06-05 | ABAX-DELISTED | Stock | 17.74 | 18.0 | 17.485 | 17.81 | 165831.0 |
| 2009-06-05 | ABB-DELISTED | Stock | 16.76 | 16.84 | 16.34 | 16.51 | 3726446.0 |
| 2009-06-05 | ABBC-DELISTED | Stock | 9.23 | 9.3 | 9.18 | 9.29 | 58005.0 |
| 2009-06-05 | ABBNY-DELISTED | Stock | 16.76 | 16.84 | 16.34 | 16.51 | 3727273.0 |
| 2009-06-05 | ABC-DELISTED | Stock | 18.22 | 18.32 | 17.68 | 18.2 | 4338244.0 |
| 2009-06-05 | ABCB | Stock | 7.1586 | 7.1975 | 7.0614 | 7.1684 | 7711.0 |
| 2009-06-05 | ABCO-DELISTED | Stock | 12.7 | 12.97 | 12.5 | 12.81 | 145244.0 |
| 2009-06-05 | ABCW-DELISTED | Stock | 1.65 | 1.65 | 1.55 | 1.6 | 56100.0 |
| 2009-06-05 | ABD-DELISTED | Stock | 3.41 | 3.5933 | 3.41 | 3.5 | 218390.0 |
| 2009-06-05 | ABE-DELISTED | Stock | 16.0 | 16.1 | 15.3816 | 15.45 | 51274.0 |
| 2009-06-05 | ABEO | Stock | 2812.5 | 2812.5 | 2750.0 | 2812.5 | 8.0 |
| 2009-06-05 | ABFS-DELISTED | Stock | 29.77 | 30.0 | 28.82 | 29.0 | 402178.0 |
| 2009-06-05 | ABG | Stock | 10.7 | 11.07 | 10.2 | 11.01 | 276000.0 |
| 2009-06-05 | ABII-DELISTED | Stock | 42.85 | 43.14 | 42.17 | 42.17 | 30812.0 |
| 2009-06-05 | ABK-DELISTED | Stock | 1.35 | 1.36 | 1.28 | 1.3 | 4335810.0 |
| 2009-06-05 | ABM | Stock | 18.42 | 19.68 | 18.42 | 19.12 | 932500.0 |
| 2009-06-05 | ABMD-DELISTED | Stock | 6.89 | 7.35 | 6.88 | 7.3 | 628928.0 |
| 2009-06-05 | ABR | Stock | 1.8 | 1.83 | 1.73 | 1.74 | 200200.0 |
| 2009-06-05 | ABT | Stock | 21.5478 | 21.7157 | 21.2791 | 21.5814 | 14827011.0 |
| 2009-06-05 | ABTL-DELISTED | Stock | 1.9502 | 2.2503 | 1.9502 | 2.1998 | 21242.0 |
| 2009-06-05 | ABV-DELISTED | Stock | 66.28 | 66.44 | 64.27 | 64.85 | 614102.0 |
| 2009-06-05 | ABVA-DELISTED | Stock | 3.2 | 3.25 | 3.2 | 3.25 | 1100.0 |
| 2009-06-05 | ABVT-DELISTED | Stock | 73.0 | 75.96 | 71.75 | 75.9599 | 87402.0 |
| 2009-06-05 | ABX-DELISTED | Stock | 36.49 | 36.69 | 35.72 | 36.11 | 9044928.0 |
| 2009-06-05 | ACAD | Stock | 2.49 | 2.57 | 2.4 | 2.47 | 509400.0 |
| 2009-06-05 | ACAP-DELISTED | Stock | 42.25 | 42.25 | 41.35 | 41.99 | 23436.0 |
> showing 50 of 5,781 rows — these rows as CSV