PREVIEW / stock_daily / 2009-07-30
file: by_date/stock_daily/2009/2009-07-30.parquet size: 183 KB rows: 5,796 symbols: 3,464
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-30 | AAPL | Stock | 5.775 | 5.8829 | 5.7679 | 5.8139 | 469604800.0 |
| 2009-07-30 | MSFT | Stock | 24.2 | 24.43 | 23.71 | 23.81 | 67820000.0 |
| 2009-07-30 | NVDA | Stock | 0.325 | 0.3293 | 0.3193 | 0.322 | 468444000.0 |
| 2009-07-30 | AMZN | Stock | 4.282 | 4.3625 | 4.2585 | 4.3045 | 145064000.0 |
| 2009-07-30 | TLT | Stock | 91.54 | 93.15 | 91.23 | 93.0 | 4040621.0 |
| 2009-07-30 | ES | Stock | 22.66 | 23.25 | 22.56 | 23.14 | 1878000.0 |
| 2009-07-30 | CL | Stock | 37.1 | 37.15 | 35.545 | 35.915 | 23081800.0 |
| 2009-07-30 | A | Stock | 16.3662 | 16.8884 | 16.3591 | 16.5665 | 5819455.0 |
| 2009-07-30 | AABA-DELISTED | Stock | 15.13 | 15.14 | 14.24 | 14.62 | 100247856.0 |
| 2009-07-30 | AACC-DELISTED | Stock | 8.35 | 8.62 | 7.69 | 7.88 | 82650.0 |
| 2009-07-30 | AACG | Stock | 8.31 | 8.55 | 8.0 | 8.0 | 41700.0 |
| 2009-07-30 | AAI-DELISTED | Stock | 7.41 | 7.47 | 7.11 | 7.26 | 2065159.0 |
| 2009-07-30 | AAIC-DELISTED | Stock | 8.0 | 8.2 | 7.8 | 7.8 | 245823.0 |
| 2009-07-30 | AAME | Stock | 0.68 | 0.87 | 0.68 | 0.85 | 2200.0 |
| 2009-07-30 | AAON | Stock | 3.9151 | 3.9506 | 3.8123 | 3.9131 | 231862.0 |
| 2009-07-30 | AAP | Stock | 45.6 | 47.41 | 45.6 | 47.0 | 1919200.0 |
| 2009-07-30 | AATI-DELISTED | Stock | 4.69 | 4.94 | 4.67 | 4.86 | 774413.0 |
| 2009-07-30 | AAU-DELISTED | Stock | 0.66 | 0.66 | 0.6313 | 0.66 | 87880.0 |
| 2009-07-30 | AAUAF-DELISTED | Stock | 0.66 | 0.66 | 0.6313 | 0.66 | 88480.0 |
| 2009-07-30 | AAV-DELISTED | Stock | 4.99 | 5.2 | 4.96 | 5.12 | 999449.0 |
| 2009-07-30 | AAWW-DELISTED | Stock | 25.36 | 25.87 | 24.89 | 25.31 | 199495.0 |
| 2009-07-30 | AAXJ | Stock | 49.81 | 50.349 | 49.68 | 49.71 | 396465.0 |
| 2009-07-30 | AAXN-DELISTED | Stock | 5.3 | 5.47 | 5.26 | 5.37 | 451582.0 |
| 2009-07-30 | AB | Stock | 22.11 | 22.42 | 21.63 | 21.68 | 1833800.0 |
| 2009-07-30 | ABAX-DELISTED | Stock | 20.92 | 21.98 | 20.91 | 21.92 | 513015.0 |
| 2009-07-30 | ABB-DELISTED | Stock | 17.74 | 18.04 | 17.63 | 17.92 | 5254194.0 |
| 2009-07-30 | ABBC-DELISTED | Stock | 8.32 | 8.75 | 8.09 | 8.51 | 47315.0 |
| 2009-07-30 | ABBNY-DELISTED | Stock | 17.74 | 18.04 | 17.63 | 17.91 | 5264785.0 |
| 2009-07-30 | ABC-DELISTED | Stock | 20.6 | 20.77 | 19.56 | 19.78 | 4077147.0 |
| 2009-07-30 | ABCB | Stock | 6.7015 | 6.8474 | 6.3221 | 6.4778 | 32489.0 |
| 2009-07-30 | ABCO-DELISTED | Stock | 11.985 | 12.82 | 11.795 | 12.75 | 184778.0 |
| 2009-07-30 | ABCW-DELISTED | Stock | 1.21 | 1.36 | 1.2 | 1.25 | 146080.0 |
| 2009-07-30 | ABD-DELISTED | Stock | 4.61 | 4.9 | 4.56 | 4.64 | 685320.0 |
| 2009-07-30 | ABE-DELISTED | Stock | 16.38 | 16.76 | 16.09 | 16.12 | 11472.0 |
| 2009-07-30 | ABEO | Stock | 5725.0 | 6250.0 | 5725.0 | 5812.5 | 82.0 |
| 2009-07-30 | ABFS-DELISTED | Stock | 26.25 | 26.56 | 25.92 | 26.25 | 423090.0 |
| 2009-07-30 | ABG | Stock | 12.76 | 14.4 | 12.76 | 13.05 | 1169300.0 |
| 2009-07-30 | ABII-DELISTED | Stock | 31.4699 | 31.72 | 31.0 | 31.15 | 15107.0 |
| 2009-07-30 | ABK-DELISTED | Stock | 0.78 | 0.8 | 0.73 | 0.75 | 8936604.0 |
| 2009-07-30 | ABM | Stock | 20.56 | 21.0 | 20.48 | 20.95 | 152600.0 |
| 2009-07-30 | ABMD-DELISTED | Stock | 7.7 | 7.83 | 7.58 | 7.63 | 228575.0 |
| 2009-07-30 | ABR | Stock | 1.8 | 1.96 | 1.8 | 1.88 | 197200.0 |
| 2009-07-30 | ABT | Stock | 22.0612 | 22.2099 | 21.8069 | 21.9269 | 20062526.0 |
| 2009-07-30 | ABTL-DELISTED | Stock | 2.5062 | 2.5062 | 2.4439 | 2.4938 | 5545.0 |
| 2009-07-30 | ABV-DELISTED | Stock | 71.28 | 71.58 | 70.82 | 70.97 | 498971.0 |
| 2009-07-30 | ABVT-DELISTED | Stock | 82.55 | 83.0 | 81.823 | 82.32 | 20357.0 |
| 2009-07-30 | ABX-DELISTED | Stock | 34.0 | 34.25 | 33.72 | 33.89 | 7962790.0 |
| 2009-07-30 | ACAD | Stock | 4.53 | 4.7 | 4.26 | 4.5 | 1820900.0 |
| 2009-07-30 | ACAP-DELISTED | Stock | 41.81 | 43.08 | 41.2 | 43.02 | 47088.0 |
| 2009-07-30 | ACAS-DELISTED | Stock | 3.28 | 3.45 | 3.26 | 3.44 | 3682013.0 |
> showing 50 of 5,796 rows — these rows as CSV