PREVIEW / stock_daily / 2009-07-27
file: by_date/stock_daily/2009/2009-07-27.parquet size: 182 KB rows: 5,779 symbols: 3,436
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-07-27 | AAPL | Stock | 5.7204 | 5.7457 | 5.6164 | 5.7179 | 433311200.0 |
| 2009-07-27 | MSFT | Stock | 23.44 | 23.45 | 22.9 | 23.11 | 80950000.0 |
| 2009-07-27 | NVDA | Stock | 0.321 | 0.3303 | 0.318 | 0.3255 | 677484000.0 |
| 2009-07-27 | AMZN | Stock | 4.312 | 4.3245 | 4.178 | 4.212 | 225586000.0 |
| 2009-07-27 | TLT | Stock | 90.23 | 90.66 | 89.94 | 90.4 | 2756169.0 |
| 2009-07-27 | ES | Stock | 23.06 | 23.12 | 22.73 | 23.0 | 724700.0 |
| 2009-07-27 | CL | Stock | 37.62 | 37.63 | 37.305 | 37.55 | 4093000.0 |
| 2009-07-27 | A | Stock | 15.515 | 16.4163 | 15.515 | 16.2089 | 7331531.0 |
| 2009-07-27 | AABA-DELISTED | Stock | 17.37 | 17.4 | 16.85 | 16.99 | 19786212.0 |
| 2009-07-27 | AACC-DELISTED | Stock | 8.46 | 8.52 | 8.29 | 8.5 | 220955.0 |
| 2009-07-27 | AACG | Stock | 9.15 | 9.15 | 8.7 | 8.7 | 25500.0 |
| 2009-07-27 | AAI-DELISTED | Stock | 6.61 | 6.93 | 6.48 | 6.9 | 2913258.0 |
| 2009-07-27 | AAIC-DELISTED | Stock | 8.4 | 8.4 | 8.2 | 8.4 | 289091.0 |
| 2009-07-27 | AAON | Stock | 3.8617 | 3.8835 | 3.8143 | 3.8756 | 226800.0 |
| 2009-07-27 | AAP | Stock | 46.63 | 46.77 | 45.77 | 46.48 | 740900.0 |
| 2009-07-27 | AATI-DELISTED | Stock | 4.99 | 5.12 | 4.83 | 4.86 | 460377.0 |
| 2009-07-27 | AAU-DELISTED | Stock | 0.71 | 0.71 | 0.68 | 0.68 | 12350.0 |
| 2009-07-27 | AAUAF-DELISTED | Stock | 0.71 | 0.71 | 0.68 | 0.68 | 13250.0 |
| 2009-07-27 | AAV-DELISTED | Stock | 5.19 | 5.25 | 5.15 | 5.23 | 606936.0 |
| 2009-07-27 | AAWW-DELISTED | Stock | 24.53 | 24.7019 | 23.98 | 24.54 | 147076.0 |
| 2009-07-27 | AAXJ | Stock | 49.7 | 49.7 | 48.904 | 49.43 | 200469.0 |
| 2009-07-27 | AAXN-DELISTED | Stock | 5.5 | 5.7 | 5.5 | 5.56 | 389274.0 |
| 2009-07-27 | AB | Stock | 23.04 | 23.66 | 22.9 | 23.43 | 393400.0 |
| 2009-07-27 | ABAX-DELISTED | Stock | 20.11 | 20.27 | 19.84 | 20.0 | 158365.0 |
| 2009-07-27 | ABB-DELISTED | Stock | 17.45 | 17.69 | 17.31 | 17.65 | 4234734.0 |
| 2009-07-27 | ABBC-DELISTED | Stock | 8.9 | 8.9 | 8.51 | 8.73 | 35690.0 |
| 2009-07-27 | ABBNY-DELISTED | Stock | 17.45 | 17.69 | 17.31 | 17.64 | 4392308.0 |
| 2009-07-27 | ABC-DELISTED | Stock | 19.34 | 19.42 | 19.07 | 19.25 | 1762505.0 |
| 2009-07-27 | ABCB | Stock | 6.186 | 6.3903 | 6.186 | 6.3124 | 25498.0 |
| 2009-07-27 | ABCO-DELISTED | Stock | 11.755 | 12.135 | 11.695 | 12.11 | 96422.0 |
| 2009-07-27 | ABCW-DELISTED | Stock | 1.14 | 1.2 | 1.1 | 1.16 | 56730.0 |
| 2009-07-27 | ABD-DELISTED | Stock | 3.52 | 4.95 | 3.52 | 4.41 | 1401340.0 |
| 2009-07-27 | ABE-DELISTED | Stock | 16.45 | 16.5979 | 16.42 | 16.532 | 9204.0 |
| 2009-07-27 | ABEO | Stock | 5112.5 | 5925.0 | 5062.5 | 5625.0 | 297.0 |
| 2009-07-27 | ABFS-DELISTED | Stock | 26.23 | 27.19 | 26.1 | 27.18 | 645280.0 |
| 2009-07-27 | ABG | Stock | 12.13 | 12.31 | 11.43 | 12.27 | 550900.0 |
| 2009-07-27 | ABII-DELISTED | Stock | 30.42 | 31.92 | 30.42 | 31.42 | 26536.0 |
| 2009-07-27 | ABK-DELISTED | Stock | 0.95 | 0.98 | 0.92 | 0.9408 | 4701393.0 |
| 2009-07-27 | ABM | Stock | 20.82 | 20.82 | 20.14 | 20.51 | 144400.0 |
| 2009-07-27 | ABMD-DELISTED | Stock | 7.2 | 7.97 | 7.2 | 7.64 | 288021.0 |
| 2009-07-27 | ABR | Stock | 1.64 | 1.81 | 1.63 | 1.78 | 242700.0 |
| 2009-07-27 | ABT | Stock | 21.6534 | 21.7733 | 21.3463 | 21.6054 | 13140058.0 |
| 2009-07-27 | ABTL-DELISTED | Stock | 2.3256 | 2.416 | 2.3 | 2.3 | 13243.0 |
| 2009-07-27 | ABV-DELISTED | Stock | 70.6 | 70.87 | 70.0 | 70.8501 | 669187.0 |
| 2009-07-27 | ABVA-DELISTED | Stock | 2.7 | 2.7 | 2.65 | 2.65 | 600.0 |
| 2009-07-27 | ABVT-DELISTED | Stock | 82.39 | 82.39 | 80.962 | 82.36 | 34997.0 |
| 2009-07-27 | ABX-DELISTED | Stock | 35.73 | 35.79 | 34.88 | 34.96 | 5115086.0 |
| 2009-07-27 | ACAD | Stock | 4.14 | 5.24 | 4.1 | 4.4 | 13080000.0 |
| 2009-07-27 | ACAP-DELISTED | Stock | 39.6 | 40.84 | 39.6 | 40.84 | 29334.0 |
| 2009-07-27 | ACAS-DELISTED | Stock | 3.02 | 3.25 | 3.02 | 3.24 | 2552861.0 |
> showing 50 of 5,779 rows — these rows as CSV