PREVIEW / stock_daily / 2009-07-28
file: by_date/stock_daily/2009/2009-07-28.parquet size: 182 KB rows: 5,782 symbols: 3,451
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-28 | AAPL | Stock | 5.6743 | 5.7179 | 5.6286 | 5.7143 | 363554800.0 |
| 2009-07-28 | MSFT | Stock | 22.99 | 23.55 | 22.9 | 23.47 | 70288400.0 |
| 2009-07-28 | NVDA | Stock | 0.3233 | 0.3295 | 0.3205 | 0.326 | 563180000.0 |
| 2009-07-28 | AMZN | Stock | 4.192 | 4.282 | 4.13 | 4.249 | 175498000.0 |
| 2009-07-28 | TLT | Stock | 90.72 | 91.82 | 90.4299 | 91.2 | 3324934.0 |
| 2009-07-28 | ES | Stock | 22.93 | 22.97 | 22.57 | 22.79 | 659700.0 |
| 2009-07-28 | CL | Stock | 37.42 | 37.74 | 37.42 | 37.685 | 3867600.0 |
| 2009-07-28 | A | Stock | 16.123 | 17.0887 | 16.123 | 16.6595 | 8908615.0 |
| 2009-07-28 | AABA-DELISTED | Stock | 16.97 | 17.49 | 16.5167 | 17.26 | 35950264.0 |
| 2009-07-28 | AACC-DELISTED | Stock | 8.4 | 8.5 | 7.882 | 8.5 | 26268.0 |
| 2009-07-28 | AACG | Stock | 8.84 | 8.84 | 8.32 | 8.32 | 18700.0 |
| 2009-07-28 | AAI-DELISTED | Stock | 6.81 | 7.35 | 6.8 | 7.32 | 3615717.0 |
| 2009-07-28 | AAIC-DELISTED | Stock | 8.2 | 8.2 | 7.8 | 8.2 | 130257.0 |
| 2009-07-28 | AAME | Stock | 0.67 | 0.69 | 0.67 | 0.69 | 1500.0 |
| 2009-07-28 | AAON | Stock | 3.836 | 3.9684 | 3.8262 | 3.9328 | 390825.0 |
| 2009-07-28 | AAP | Stock | 46.32 | 46.56 | 45.68 | 45.89 | 906700.0 |
| 2009-07-28 | AATI-DELISTED | Stock | 4.86 | 4.8801 | 4.65 | 4.78 | 421993.0 |
| 2009-07-28 | AAU-DELISTED | Stock | 0.68 | 0.69 | 0.66 | 0.68 | 20514.0 |
| 2009-07-28 | AAUAF-DELISTED | Stock | 0.68 | 0.69 | 0.66 | 0.68 | 23614.0 |
| 2009-07-28 | AAV-DELISTED | Stock | 5.15 | 5.23 | 5.05 | 5.18 | 769220.0 |
| 2009-07-28 | AAWW-DELISTED | Stock | 24.17 | 24.87 | 24.0 | 24.78 | 153182.0 |
| 2009-07-28 | AAXJ | Stock | 49.26 | 49.7 | 49.016 | 49.6 | 266164.0 |
| 2009-07-28 | AAXN-DELISTED | Stock | 5.62 | 5.67 | 5.35 | 5.55 | 529881.0 |
| 2009-07-28 | AB | Stock | 23.35 | 23.42 | 22.4 | 22.6 | 319500.0 |
| 2009-07-28 | ABAX-DELISTED | Stock | 20.0 | 20.65 | 19.91 | 20.64 | 169437.0 |
| 2009-07-28 | ABB-DELISTED | Stock | 17.48 | 17.605 | 17.11 | 17.35 | 4812501.0 |
| 2009-07-28 | ABBC-DELISTED | Stock | 8.66 | 8.76 | 8.22 | 8.29 | 45891.0 |
| 2009-07-28 | ABBNY-DELISTED | Stock | 17.49 | 17.605 | 17.11 | 17.36 | 4814301.0 |
| 2009-07-28 | ABC-DELISTED | Stock | 19.23 | 19.44 | 19.15 | 19.29 | 2375637.0 |
| 2009-07-28 | ABCB | Stock | 6.2346 | 6.5362 | 6.1666 | 6.5362 | 28068.0 |
| 2009-07-28 | ABCO-DELISTED | Stock | 12.015 | 12.175 | 11.85 | 11.995 | 147720.0 |
| 2009-07-28 | ABCW-DELISTED | Stock | 1.18 | 1.25 | 1.12 | 1.22 | 99330.0 |
| 2009-07-28 | ABD-DELISTED | Stock | 4.32 | 4.66 | 4.28 | 4.61 | 761350.0 |
| 2009-07-28 | ABE-DELISTED | Stock | 16.22 | 16.85 | 16.22 | 16.38 | 18797.0 |
| 2009-07-28 | ABEO | Stock | 5812.5 | 5812.5 | 4725.0 | 5125.0 | 60.0 |
| 2009-07-28 | ABFS-DELISTED | Stock | 26.8 | 27.18 | 26.36 | 26.98 | 502498.0 |
| 2009-07-28 | ABG | Stock | 12.2 | 12.41 | 11.86 | 12.11 | 306300.0 |
| 2009-07-28 | ABII-DELISTED | Stock | 30.84 | 31.63 | 30.84 | 31.04 | 35810.0 |
| 2009-07-28 | ABK-DELISTED | Stock | 0.81 | 0.8399 | 0.726 | 0.8101 | 20599627.0 |
| 2009-07-28 | ABM | Stock | 20.35 | 20.85 | 20.23 | 20.63 | 145100.0 |
| 2009-07-28 | ABMD-DELISTED | Stock | 7.65 | 7.68 | 7.54 | 7.61 | 234358.0 |
| 2009-07-28 | ABR | Stock | 1.8 | 1.98 | 1.8 | 1.98 | 317300.0 |
| 2009-07-28 | ABT | Stock | 21.5718 | 21.8789 | 21.543 | 21.7973 | 15297832.0 |
| 2009-07-28 | ABTL-DELISTED | Stock | 2.35 | 2.49 | 2.3 | 2.4 | 33593.0 |
| 2009-07-28 | ABV-DELISTED | Stock | 70.56 | 71.33 | 70.01 | 70.79 | 527995.0 |
| 2009-07-28 | ABVA-DELISTED | Stock | 2.6 | 2.6 | 2.6 | 2.6 | 138.0 |
| 2009-07-28 | ABVT-DELISTED | Stock | 82.71 | 84.85 | 81.5 | 82.01 | 51010.0 |
| 2009-07-28 | ABX-DELISTED | Stock | 34.36 | 34.55 | 33.0 | 33.49 | 8905836.0 |
| 2009-07-28 | ACAD | Stock | 4.59 | 4.63 | 3.97 | 4.38 | 3389700.0 |
| 2009-07-28 | ACAP-DELISTED | Stock | 40.72 | 41.94 | 39.83 | 41.59 | 38137.0 |
> showing 50 of 5,782 rows — these rows as CSV