PREVIEW / stock_daily / 2009-11-30
file: by_date/stock_daily/2009/2009-11-30.parquet size: 188 KB rows: 5,899 symbols: 3,498
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-11-30 | AAPL | Stock | 7.1825 | 7.2029 | 7.0989 | 7.1396 | 424858000.0 |
| 2009-11-30 | MSFT | Stock | 29.15 | 29.45 | 29.0 | 29.41 | 44172000.0 |
| 2009-11-30 | NVDA | Stock | 0.321 | 0.3268 | 0.3175 | 0.3265 | 509836000.0 |
| 2009-11-30 | AMZN | Stock | 6.6095 | 6.804 | 6.608 | 6.7955 | 202390000.0 |
| 2009-11-30 | TLT | Stock | 96.2 | 96.73 | 96.0 | 96.63 | 3115775.0 |
| 2009-11-30 | ES | Stock | 24.04 | 24.16 | 23.92 | 24.11 | 1788400.0 |
| 2009-11-30 | CL | Stock | 41.84 | 42.34 | 41.57 | 42.095 | 5738200.0 |
| 2009-11-30 | A | Stock | 20.5866 | 20.7082 | 20.4292 | 20.6867 | 3572170.0 |
| 2009-11-30 | AABA-DELISTED | Stock | 14.91 | 15.1 | 14.8 | 14.96 | 17326527.0 |
| 2009-11-30 | AACC-DELISTED | Stock | 5.72 | 5.84 | 5.6 | 5.83 | 105486.0 |
| 2009-11-30 | AACG | Stock | 4.81 | 5.39 | 4.8 | 5.2 | 12000.0 |
| 2009-11-30 | AAI-DELISTED | Stock | 4.17 | 4.2 | 4.09 | 4.13 | 3877687.0 |
| 2009-11-30 | AAIC-DELISTED | Stock | 13.21 | 13.5 | 13.01 | 13.25 | 7347.0 |
| 2009-11-30 | AAME | Stock | 1.3 | 1.3 | 1.25 | 1.3 | 3600.0 |
| 2009-11-30 | AAON | Stock | 3.7353 | 3.7768 | 3.6662 | 3.7412 | 718875.0 |
| 2009-11-30 | AAP | Stock | 39.53 | 39.85 | 39.02 | 39.3 | 1613100.0 |
| 2009-11-30 | AATI-DELISTED | Stock | 3.32 | 3.32 | 3.06 | 3.19 | 377903.0 |
| 2009-11-30 | AAU-DELISTED | Stock | 0.77 | 0.78 | 0.73 | 0.7493 | 43450.0 |
| 2009-11-30 | AAUAF-DELISTED | Stock | 0.77 | 0.78 | 0.73 | 0.7493 | 46950.0 |
| 2009-11-30 | AAV-DELISTED | Stock | 5.61 | 5.83 | 5.61 | 5.79 | 548115.0 |
| 2009-11-30 | AAWW-DELISTED | Stock | 29.8 | 30.54 | 28.7 | 29.3 | 543448.0 |
| 2009-11-30 | AAXJ | Stock | 54.42 | 54.63 | 54.0 | 54.55 | 417526.0 |
| 2009-11-30 | AAXN-DELISTED | Stock | 4.26 | 4.26 | 4.15 | 4.23 | 420214.0 |
| 2009-11-30 | AB | Stock | 25.63 | 25.69 | 25.11 | 25.3 | 424400.0 |
| 2009-11-30 | ABAX-DELISTED | Stock | 22.5 | 22.66 | 21.95 | 22.47 | 282445.0 |
| 2009-11-30 | ABB-DELISTED | Stock | 18.31 | 18.45 | 18.12 | 18.35 | 6112381.0 |
| 2009-11-30 | ABBC-DELISTED | Stock | 6.55 | 6.82 | 6.5 | 6.82 | 87277.0 |
| 2009-11-30 | ABBNY-DELISTED | Stock | 18.29 | 18.45 | 18.12 | 18.36 | 6124629.0 |
| 2009-11-30 | ABC-DELISTED | Stock | 24.92 | 24.92 | 24.48 | 24.69 | 3795972.0 |
| 2009-11-30 | ABCB | Stock | 6.3708 | 6.5864 | 6.2924 | 6.4786 | 46933.0 |
| 2009-11-30 | ABCO-DELISTED | Stock | 12.985 | 13.135 | 12.825 | 13.1 | 183928.0 |
| 2009-11-30 | ABCW-DELISTED | Stock | 0.6 | 0.6 | 0.52 | 0.53 | 232150.0 |
| 2009-11-30 | ABD-DELISTED | Stock | 6.0 | 6.56 | 6.0 | 6.53 | 627760.0 |
| 2009-11-30 | ABE-DELISTED | Stock | 16.67 | 16.68 | 16.51 | 16.51 | 5323.0 |
| 2009-11-30 | ABEO | Stock | 3750.0 | 3912.5 | 3687.5 | 3900.0 | 14.0 |
| 2009-11-30 | ABFS-DELISTED | Stock | 24.16 | 24.75 | 23.67 | 24.63 | 312076.0 |
| 2009-11-30 | ABG | Stock | 10.6 | 10.7 | 10.23 | 10.66 | 440600.0 |
| 2009-11-30 | ABII-DELISTED | Stock | 34.97 | 35.355 | 33.41 | 33.49 | 36030.0 |
| 2009-11-30 | ABK-DELISTED | Stock | 0.8 | 0.84 | 0.77 | 0.7799 | 11414602.0 |
| 2009-11-30 | ABM | Stock | 18.56 | 18.6 | 17.94 | 18.43 | 218900.0 |
| 2009-11-30 | ABMD-DELISTED | Stock | 8.71 | 8.73 | 8.3 | 8.46 | 196821.0 |
| 2009-11-30 | ABR | Stock | 1.78 | 1.8 | 1.77 | 1.78 | 38000.0 |
| 2009-11-30 | ABT | Stock | 26.0052 | 26.1731 | 25.7605 | 26.1443 | 14685286.0 |
| 2009-11-30 | ABTL-DELISTED | Stock | 5.051 | 5.051 | 4.751 | 4.95 | 2529.0 |
| 2009-11-30 | ABV-DELISTED | Stock | 98.61 | 98.73 | 96.38 | 98.53 | 582450.0 |
| 2009-11-30 | ABVT-DELISTED | Stock | 52.1 | 52.69 | 50.49 | 51.7 | 614721.0 |
| 2009-11-30 | ABX-DELISTED | Stock | 42.45 | 43.31 | 42.31 | 42.74 | 9219498.0 |
| 2009-11-30 | ACAD | Stock | 1.31 | 1.32 | 1.23 | 1.23 | 507500.0 |
| 2009-11-30 | ACAP-DELISTED | Stock | 27.63 | 27.89 | 26.18 | 27.28 | 127028.0 |
| 2009-11-30 | ACAS-DELISTED | Stock | 2.84 | 3.0 | 2.81 | 2.93 | 4639194.0 |
> showing 50 of 5,899 rows — these rows as CSV