PREVIEW / stock_daily / 2009-11-19
file: by_date/stock_daily/2009/2009-11-19.parquet size: 186 KB rows: 5,854 symbols: 3,474
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-19 | AAPL | Stock | 7.3075 | 7.3075 | 7.1357 | 7.1611 | 542326400.0 |
| 2009-11-19 | MSFT | Stock | 29.99 | 30.0 | 29.7 | 29.78 | 51967700.0 |
| 2009-11-19 | NVDA | Stock | 0.3308 | 0.3308 | 0.3185 | 0.3245 | 833840000.0 |
| 2009-11-19 | AMZN | Stock | 6.527 | 6.527 | 6.424 | 6.4495 | 119964000.0 |
| 2009-11-19 | TLT | Stock | 95.24 | 95.82 | 94.91 | 95.14 | 2969787.0 |
| 2009-11-19 | ES | Stock | 23.88 | 23.98 | 23.55 | 23.63 | 1643900.0 |
| 2009-11-19 | CL | Stock | 42.5 | 42.5 | 41.79 | 42.21 | 10827800.0 |
| 2009-11-19 | A | Stock | 20.8083 | 21.0014 | 20.5079 | 20.8369 | 3094473.0 |
| 2009-11-19 | AABA-DELISTED | Stock | 15.85 | 15.85 | 15.52 | 15.61 | 15544007.0 |
| 2009-11-19 | AACC-DELISTED | Stock | 5.41 | 5.46 | 5.35 | 5.36 | 32206.0 |
| 2009-11-19 | AACG | Stock | 4.95 | 5.18 | 4.71 | 4.71 | 30000.0 |
| 2009-11-19 | AAI-DELISTED | Stock | 4.33 | 4.33 | 4.18 | 4.31 | 12189439.0 |
| 2009-11-19 | AAIC-DELISTED | Stock | 13.21 | 13.29 | 12.87 | 13.11 | 20873.0 |
| 2009-11-19 | AAME | Stock | 1.28 | 1.34 | 1.28 | 1.28 | 4400.0 |
| 2009-11-19 | AAON | Stock | 3.9447 | 3.996 | 3.844 | 3.8854 | 388800.0 |
| 2009-11-19 | AAP | Stock | 40.84 | 40.95 | 40.01 | 40.12 | 2239900.0 |
| 2009-11-19 | AATI-DELISTED | Stock | 3.26 | 3.3 | 3.08 | 3.24 | 451298.0 |
| 2009-11-19 | AAU-DELISTED | Stock | 0.76 | 0.77 | 0.75 | 0.75 | 159630.0 |
| 2009-11-19 | AAUAF-DELISTED | Stock | 0.76 | 0.77 | 0.75 | 0.75 | 167130.0 |
| 2009-11-19 | AAV-DELISTED | Stock | 5.88 | 5.94 | 5.6 | 5.77 | 940045.0 |
| 2009-11-19 | AAWW-DELISTED | Stock | 29.57 | 30.132 | 28.82 | 30.04 | 759495.0 |
| 2009-11-19 | AAXJ | Stock | 55.35 | 55.35 | 54.5801 | 54.96 | 212115.0 |
| 2009-11-19 | AAXN-DELISTED | Stock | 4.15 | 4.19 | 4.07 | 4.07 | 361453.0 |
| 2009-11-19 | AB | Stock | 26.82 | 27.12 | 26.25 | 26.73 | 254300.0 |
| 2009-11-19 | ABAX-DELISTED | Stock | 23.29 | 23.29 | 22.39 | 22.58 | 124822.0 |
| 2009-11-19 | ABB-DELISTED | Stock | 18.73 | 18.74 | 18.43 | 18.66 | 3467476.0 |
| 2009-11-19 | ABBC-DELISTED | Stock | 6.94 | 6.94 | 6.79 | 6.86 | 52303.0 |
| 2009-11-19 | ABBNY-DELISTED | Stock | 18.73 | 18.74 | 18.43 | 18.63 | 3468776.0 |
| 2009-11-19 | ABC-DELISTED | Stock | 24.6 | 24.61 | 24.12 | 24.2 | 3430692.0 |
| 2009-11-19 | ABCB | Stock | 6.165 | 6.263 | 5.9787 | 6.0277 | 60605.0 |
| 2009-11-19 | ABCO-DELISTED | Stock | 12.91 | 12.93 | 12.555 | 12.6 | 154224.0 |
| 2009-11-19 | ABCW-DELISTED | Stock | 0.7193 | 0.75 | 0.6714 | 0.75 | 338900.0 |
| 2009-11-19 | ABD-DELISTED | Stock | 6.8 | 6.8 | 6.3087 | 6.34 | 227380.0 |
| 2009-11-19 | ABE-DELISTED | Stock | 16.75 | 16.8 | 16.65 | 16.7 | 7879.0 |
| 2009-11-19 | ABEO | Stock | 3900.0 | 3937.5 | 3737.5 | 3875.0 | 4.0 |
| 2009-11-19 | ABFS-DELISTED | Stock | 25.64 | 25.8 | 24.25 | 24.56 | 531389.0 |
| 2009-11-19 | ABG | Stock | 10.06 | 10.1 | 9.57 | 9.63 | 342200.0 |
| 2009-11-19 | ABII-DELISTED | Stock | 34.2 | 34.4 | 33.02 | 33.57 | 30433.0 |
| 2009-11-19 | ABK-DELISTED | Stock | 0.98 | 1.09 | 0.9603 | 1.0 | 34558359.0 |
| 2009-11-19 | ABM | Stock | 19.35 | 19.42 | 18.81 | 19.02 | 107800.0 |
| 2009-11-19 | ABMD-DELISTED | Stock | 8.94 | 8.99 | 8.5 | 8.56 | 171121.0 |
| 2009-11-19 | ABR | Stock | 1.76 | 1.84 | 1.76 | 1.82 | 47500.0 |
| 2009-11-19 | ABT | Stock | 25.3766 | 25.5254 | 25.2231 | 25.4102 | 14050646.0 |
| 2009-11-19 | ABTL-DELISTED | Stock | 4.15 | 4.35 | 3.95 | 4.25 | 7251.0 |
| 2009-11-19 | ABV-DELISTED | Stock | 100.0 | 100.12 | 96.84 | 98.0 | 863528.0 |
| 2009-11-19 | ABVT-DELISTED | Stock | 56.24 | 56.3 | 54.6801 | 55.81 | 292703.0 |
| 2009-11-19 | ABX-DELISTED | Stock | 43.34 | 44.54 | 42.66 | 44.36 | 11027791.0 |
| 2009-11-19 | ACAD | Stock | 1.35 | 1.42 | 1.32 | 1.42 | 322000.0 |
| 2009-11-19 | ACAP-DELISTED | Stock | 27.93 | 28.04 | 27.34 | 27.44 | 60589.0 |
| 2009-11-19 | ACAS-DELISTED | Stock | 3.03 | 3.04 | 2.97 | 2.98 | 4586646.0 |
> showing 50 of 5,854 rows — these rows as CSV