PREVIEW / stock_daily / 2009-11-10
file: by_date/stock_daily/2009/2009-11-10.parquet size: 186 KB rows: 5,862 symbols: 3,488
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-10 | AAPL | Stock | 7.1793 | 7.3207 | 7.1789 | 7.2493 | 401195200.0 |
| 2009-11-10 | MSFT | Stock | 28.9 | 29.28 | 28.81 | 29.01 | 65881100.0 |
| 2009-11-10 | NVDA | Stock | 0.3378 | 0.3378 | 0.324 | 0.3283 | 781472000.0 |
| 2009-11-10 | AMZN | Stock | 6.34 | 6.5305 | 6.3 | 6.5075 | 210586000.0 |
| 2009-11-10 | TLT | Stock | 94.05 | 94.1 | 92.91 | 93.27 | 2549848.0 |
| 2009-11-10 | ES | Stock | 23.21 | 23.69 | 23.2 | 23.56 | 1436400.0 |
| 2009-11-10 | CL | Stock | 40.585 | 41.02 | 40.415 | 40.735 | 4930600.0 |
| 2009-11-10 | A | Stock | 19.3205 | 19.4564 | 19.1631 | 19.3133 | 3696731.0 |
| 2009-11-10 | AABA-DELISTED | Stock | 16.07 | 16.36 | 16.01 | 16.04 | 21738976.0 |
| 2009-11-10 | AACC-DELISTED | Stock | 5.37 | 5.43 | 5.19 | 5.23 | 50860.0 |
| 2009-11-10 | AACG | Stock | 4.31 | 4.5 | 4.18 | 4.18 | 42800.0 |
| 2009-11-10 | AAI-DELISTED | Stock | 4.66 | 4.67 | 4.47 | 4.5201 | 2665431.0 |
| 2009-11-10 | AAIC-DELISTED | Stock | 12.7 | 13.96 | 12.7 | 13.7 | 103805.0 |
| 2009-11-10 | AAME | Stock | 1.2 | 1.3 | 1.01 | 1.25 | 6900.0 |
| 2009-11-10 | AAON | Stock | 3.8914 | 3.9506 | 3.8914 | 3.9467 | 376650.0 |
| 2009-11-10 | AAP | Stock | 38.13 | 39.42 | 37.76 | 39.0 | 3349300.0 |
| 2009-11-10 | AATI-DELISTED | Stock | 3.05 | 3.12 | 2.99 | 3.03 | 489585.0 |
| 2009-11-10 | AAU-DELISTED | Stock | 0.72 | 0.72 | 0.685 | 0.69 | 92975.0 |
| 2009-11-10 | AAUAF-DELISTED | Stock | 0.69 | 0.7201 | 0.6851 | 0.6901 | 98064.0 |
| 2009-11-10 | AAV-DELISTED | Stock | 6.46 | 6.65 | 6.35 | 6.6225 | 775008.0 |
| 2009-11-10 | AAWW-DELISTED | Stock | 28.04 | 28.37 | 27.23 | 28.0 | 456874.0 |
| 2009-11-10 | AAXJ | Stock | 54.26 | 54.71 | 54.0001 | 54.66 | 134938.0 |
| 2009-11-10 | AAXN-DELISTED | Stock | 4.5 | 4.58 | 4.26 | 4.28 | 549337.0 |
| 2009-11-10 | AB | Stock | 26.93 | 27.19 | 26.75 | 26.92 | 413300.0 |
| 2009-11-10 | ABAX-DELISTED | Stock | 23.31 | 23.49 | 22.51 | 22.65 | 180768.0 |
| 2009-11-10 | ABB-DELISTED | Stock | 19.75 | 20.05 | 19.7 | 20.04 | 4791691.0 |
| 2009-11-10 | ABBC-DELISTED | Stock | 6.62 | 6.62 | 6.51 | 6.54 | 153107.0 |
| 2009-11-10 | ABBNY-DELISTED | Stock | 19.75 | 20.05 | 19.7 | 20.04 | 4794441.0 |
| 2009-11-10 | ABC-DELISTED | Stock | 23.9 | 24.37 | 23.79 | 24.35 | 3061057.0 |
| 2009-11-10 | ABCB | Stock | 5.9102 | 6.2238 | 5.9004 | 6.1944 | 55401.0 |
| 2009-11-10 | ABCO-DELISTED | Stock | 13.165 | 13.32 | 13.15 | 13.23 | 61028.0 |
| 2009-11-10 | ABCW-DELISTED | Stock | 0.57 | 0.57 | 0.37 | 0.48 | 865100.0 |
| 2009-11-10 | ABD-DELISTED | Stock | 6.84 | 7.24 | 6.8 | 6.95 | 301150.0 |
| 2009-11-10 | ABE-DELISTED | Stock | 16.54 | 16.87 | 16.42 | 16.66 | 8813.0 |
| 2009-11-10 | ABEO | Stock | 3750.0 | 3962.5 | 3450.0 | 3750.0 | 39.0 |
| 2009-11-10 | ABFS-DELISTED | Stock | 23.85 | 24.58 | 23.76 | 24.5 | 949137.0 |
| 2009-11-10 | ABG | Stock | 10.66 | 10.7 | 9.81 | 10.15 | 281800.0 |
| 2009-11-10 | ABII-DELISTED | Stock | 35.42 | 35.52 | 34.5 | 35.02 | 21302.0 |
| 2009-11-10 | ABK-DELISTED | Stock | 1.11 | 1.1199 | 0.745 | 0.79 | 110177212.0 |
| 2009-11-10 | ABM | Stock | 19.23 | 19.52 | 19.19 | 19.41 | 146500.0 |
| 2009-11-10 | ABMD-DELISTED | Stock | 9.47 | 9.59 | 9.31 | 9.33 | 256927.0 |
| 2009-11-10 | ABR | Stock | 1.96 | 2.07 | 1.96 | 2.07 | 160000.0 |
| 2009-11-10 | ABT | Stock | 25.0408 | 25.4246 | 25.0216 | 25.3334 | 11546895.0 |
| 2009-11-10 | ABTL-DELISTED | Stock | 4.1503 | 4.1503 | 4.0502 | 4.1497 | 3950.0 |
| 2009-11-10 | ABV-DELISTED | Stock | 99.36 | 101.01 | 98.73 | 100.69 | 961096.0 |
| 2009-11-10 | ABVA-DELISTED | Stock | 2.47 | 2.47 | 2.2 | 2.2 | 1000.0 |
| 2009-11-10 | ABVT-DELISTED | Stock | 54.69 | 54.6999 | 53.14 | 53.49 | 229916.0 |
| 2009-11-10 | ABX-DELISTED | Stock | 42.67 | 43.21 | 42.27 | 43.13 | 12108748.0 |
| 2009-11-10 | ACAD | Stock | 1.63 | 1.63 | 1.46 | 1.58 | 1552700.0 |
| 2009-11-10 | ACAP-DELISTED | Stock | 29.36 | 29.74 | 28.92 | 29.25 | 40153.0 |
> showing 50 of 5,862 rows — these rows as CSV