PREVIEW / stock_daily / 2009-09-03
file: by_date/stock_daily/2009/2009-09-03.parquet size: 183 KB rows: 5,783 symbols: 3,440
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-09-03 | AAPL | Stock | 5.9443 | 5.9679 | 5.8929 | 5.9482 | 293955200.0 |
| 2009-09-03 | MSFT | Stock | 23.91 | 24.14 | 23.76 | 24.11 | 34120000.0 |
| 2009-09-03 | NVDA | Stock | 0.3558 | 0.3648 | 0.3548 | 0.3642 | 534020000.0 |
| 2009-09-03 | AMZN | Stock | 3.9195 | 3.948 | 3.8755 | 3.923 | 82804000.0 |
| 2009-09-03 | TLT | Stock | 96.84 | 97.12 | 96.55 | 96.86 | 2703715.0 |
| 2009-09-03 | ES | Stock | 23.69 | 23.83 | 23.48 | 23.66 | 856800.0 |
| 2009-09-03 | CL | Stock | 36.14 | 36.14 | 35.225 | 35.585 | 6738000.0 |
| 2009-09-03 | A | Stock | 18.2189 | 18.269 | 17.8827 | 18.0901 | 6482526.0 |
| 2009-09-03 | AABA-DELISTED | Stock | 14.35 | 14.43 | 14.1601 | 14.27 | 14598443.0 |
| 2009-09-03 | AACC-DELISTED | Stock | 7.1 | 7.115 | 6.87 | 7.04 | 48402.0 |
| 2009-09-03 | AACG | Stock | 7.0 | 7.34 | 6.82 | 7.01 | 11800.0 |
| 2009-09-03 | AAI-DELISTED | Stock | 6.29 | 6.48 | 6.2 | 6.43 | 857083.0 |
| 2009-09-03 | AAIC-DELISTED | Stock | 9.4 | 9.8 | 8.8 | 9.2 | 1118393.0 |
| 2009-09-03 | AAME | Stock | 0.81 | 0.81 | 0.71 | 0.71 | 4600.0 |
| 2009-09-03 | AAON | Stock | 4.0395 | 4.0454 | 3.9526 | 4.0415 | 348806.0 |
| 2009-09-03 | AAP | Stock | 41.77 | 41.9 | 41.1 | 41.62 | 1580300.0 |
| 2009-09-03 | AATI-DELISTED | Stock | 4.36 | 4.56 | 4.35 | 4.39 | 215657.0 |
| 2009-09-03 | AAU-DELISTED | Stock | 0.75 | 0.77 | 0.73 | 0.77 | 338653.0 |
| 2009-09-03 | AAUAF-DELISTED | Stock | 0.75 | 0.77 | 0.73 | 0.77 | 339253.0 |
| 2009-09-03 | AAV-DELISTED | Stock | 5.34 | 5.53 | 5.32 | 5.52 | 772798.0 |
| 2009-09-03 | AAWW-DELISTED | Stock | 23.67 | 24.1199 | 23.29 | 23.55 | 153553.0 |
| 2009-09-03 | AAXJ | Stock | 48.93 | 49.23 | 48.44 | 49.23 | 54330.0 |
| 2009-09-03 | AAXN-DELISTED | Stock | 4.5 | 4.56 | 4.45 | 4.52 | 189054.0 |
| 2009-09-03 | AB | Stock | 21.81 | 22.15 | 21.59 | 22.13 | 529800.0 |
| 2009-09-03 | ABAX-DELISTED | Stock | 26.01 | 26.27 | 25.65 | 26.08 | 83755.0 |
| 2009-09-03 | ABB-DELISTED | Stock | 18.83 | 18.85 | 18.62 | 18.8 | 3424472.0 |
| 2009-09-03 | ABBC-DELISTED | Stock | 7.76 | 7.79 | 7.56 | 7.6 | 50486.0 |
| 2009-09-03 | ABBNY-DELISTED | Stock | 18.83 | 18.85 | 18.62 | 18.8 | 3426282.0 |
| 2009-09-03 | ABC-DELISTED | Stock | 21.12 | 21.14 | 20.87 | 21.13 | 2173343.0 |
| 2009-09-03 | ABCB | Stock | 6.293 | 6.3027 | 6.0693 | 6.0985 | 9664.0 |
| 2009-09-03 | ABCO-DELISTED | Stock | 13.325 | 13.58 | 13.05 | 13.515 | 61664.0 |
| 2009-09-03 | ABCW-DELISTED | Stock | 1.2602 | 1.2941 | 1.2098 | 1.23 | 56140.0 |
| 2009-09-03 | ABD-DELISTED | Stock | 5.59 | 5.64 | 5.34 | 5.59 | 116050.0 |
| 2009-09-03 | ABE-DELISTED | Stock | 16.1 | 16.75 | 16.1 | 16.52 | 22818.0 |
| 2009-09-03 | ABEO | Stock | 4750.0 | 4750.0 | 4112.5 | 4200.0 | 59.0 |
| 2009-09-03 | ABFS-DELISTED | Stock | 31.77 | 32.07 | 31.44 | 32.03 | 253766.0 |
| 2009-09-03 | ABG | Stock | 12.59 | 12.7 | 12.02 | 12.48 | 155600.0 |
| 2009-09-03 | ABII-DELISTED | Stock | 25.13 | 25.74 | 24.66 | 25.15 | 65771.0 |
| 2009-09-03 | ABK-DELISTED | Stock | 1.59 | 1.62 | 1.49 | 1.59 | 18652175.0 |
| 2009-09-03 | ABM | Stock | 21.34 | 21.86 | 19.59 | 20.95 | 648100.0 |
| 2009-09-03 | ABMD-DELISTED | Stock | 7.95 | 8.03 | 7.8 | 7.83 | 245590.0 |
| 2009-09-03 | ABR | Stock | 1.88 | 1.93 | 1.84 | 1.88 | 70400.0 |
| 2009-09-03 | ABT | Stock | 21.7014 | 21.7014 | 21.4711 | 21.6198 | 11511046.0 |
| 2009-09-03 | ABTL-DELISTED | Stock | 3.2 | 3.2005 | 2.95 | 2.95 | 6350.0 |
| 2009-09-03 | ABV-DELISTED | Stock | 73.48 | 73.93 | 72.26 | 73.8 | 357642.0 |
| 2009-09-03 | ABVT-DELISTED | Stock | 89.14 | 91.0199 | 89.14 | 90.0 | 25083.0 |
| 2009-09-03 | ABX-DELISTED | Stock | 38.15 | 39.88 | 37.97 | 39.56 | 18854870.0 |
| 2009-09-03 | ACAD | Stock | 2.21 | 2.22 | 1.92 | 2.03 | 8093400.0 |
| 2009-09-03 | ACAP-DELISTED | Stock | 32.09 | 32.19 | 31.56 | 31.8 | 31944.0 |
| 2009-09-03 | ACAS-DELISTED | Stock | 2.235 | 2.28 | 2.15 | 2.24 | 2780473.0 |
> showing 50 of 5,783 rows — these rows as CSV