PREVIEW / stock_daily / 2009-11-02
file: by_date/stock_daily/2009/2009-11-02.parquet size: 186 KB rows: 5,864 symbols: 3,485
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-02 | AAPL | Stock | 6.7786 | 6.8886 | 6.6275 | 6.7611 | 678983200.0 |
| 2009-11-02 | MSFT | Stock | 27.7 | 28.05 | 27.41 | 27.88 | 62428900.0 |
| 2009-11-02 | NVDA | Stock | 0.2985 | 0.3083 | 0.2932 | 0.3018 | 593136000.0 |
| 2009-11-02 | AMZN | Stock | 5.933 | 5.975 | 5.8355 | 5.942 | 225600000.0 |
| 2009-11-02 | TLT | Stock | 95.51 | 95.58 | 94.8 | 95.05 | 3463730.0 |
| 2009-11-02 | ES | Stock | 22.43 | 22.98 | 22.2 | 22.54 | 3067600.0 |
| 2009-11-02 | CL | Stock | 39.455 | 39.75 | 38.94 | 39.35 | 6205000.0 |
| 2009-11-02 | A | Stock | 17.6967 | 18.0973 | 17.6609 | 17.9328 | 5675600.0 |
| 2009-11-02 | AABA-DELISTED | Stock | 15.78 | 15.9 | 15.59 | 15.84 | 15148770.0 |
| 2009-11-02 | AACC-DELISTED | Stock | 7.3 | 7.3 | 6.9125 | 7.14 | 21691.0 |
| 2009-11-02 | AACG | Stock | 5.15 | 5.21 | 5.14 | 5.21 | 16900.0 |
| 2009-11-02 | AAI-DELISTED | Stock | 4.3 | 4.51 | 4.18 | 4.28 | 5008538.0 |
| 2009-11-02 | AAIC-DELISTED | Stock | 11.74 | 12.35 | 11.22 | 12.04 | 38883.0 |
| 2009-11-02 | AAME | Stock | 1.38 | 1.39 | 1.31 | 1.35 | 17300.0 |
| 2009-11-02 | AAON | Stock | 3.5911 | 3.7195 | 3.5872 | 3.6859 | 487519.0 |
| 2009-11-02 | AAP | Stock | 37.61 | 37.65 | 36.41 | 36.87 | 1960800.0 |
| 2009-11-02 | AATI-DELISTED | Stock | 3.15 | 3.24 | 3.07 | 3.11 | 582040.0 |
| 2009-11-02 | AAU-DELISTED | Stock | 0.69 | 0.7 | 0.68 | 0.68 | 49747.0 |
| 2009-11-02 | AAUAF-DELISTED | Stock | 0.69 | 0.7 | 0.68 | 0.68 | 50147.0 |
| 2009-11-02 | AAV-DELISTED | Stock | 6.23 | 6.32 | 5.89 | 6.03 | 1677184.0 |
| 2009-11-02 | AAWW-DELISTED | Stock | 26.23 | 26.55 | 24.25 | 25.08 | 1095408.0 |
| 2009-11-02 | AAXJ | Stock | 51.88 | 52.4 | 50.971 | 51.86 | 830595.0 |
| 2009-11-02 | AAXN-DELISTED | Stock | 4.1 | 4.17 | 3.94 | 4.01 | 504442.0 |
| 2009-11-02 | AB | Stock | 27.16 | 27.26 | 26.05 | 26.5 | 1071200.0 |
| 2009-11-02 | ABAX-DELISTED | Stock | 23.04 | 23.31 | 22.55 | 22.81 | 210348.0 |
| 2009-11-02 | ABB-DELISTED | Stock | 18.82 | 19.205 | 18.41 | 18.77 | 6441972.0 |
| 2009-11-02 | ABBC-DELISTED | Stock | 6.88 | 6.92 | 6.64 | 6.72 | 60678.0 |
| 2009-11-02 | ABBNY-DELISTED | Stock | 18.82 | 19.205 | 18.41 | 18.75 | 6444472.0 |
| 2009-11-02 | ABC-DELISTED | Stock | 22.25 | 22.68 | 22.07 | 22.52 | 3992965.0 |
| 2009-11-02 | ABCB | Stock | 5.8612 | 6.1258 | 5.5377 | 5.9298 | 56830.0 |
| 2009-11-02 | ABCO-DELISTED | Stock | 12.358 | 12.503 | 12.127 | 12.352 | 176221.0 |
| 2009-11-02 | ABCW-DELISTED | Stock | 0.7397 | 0.789 | 0.7101 | 0.72 | 177870.0 |
| 2009-11-02 | ABD-DELISTED | Stock | 6.13 | 6.33 | 5.9 | 6.16 | 356010.0 |
| 2009-11-02 | ABE-DELISTED | Stock | 15.9 | 16.1 | 15.245 | 15.9 | 36924.0 |
| 2009-11-02 | ABEO | Stock | 3937.5 | 4062.5 | 3750.0 | 4062.5 | 26.0 |
| 2009-11-02 | ABFS-DELISTED | Stock | 25.85 | 26.03 | 24.06 | 24.4 | 854495.0 |
| 2009-11-02 | ABG | Stock | 9.87 | 10.49 | 9.87 | 10.46 | 612300.0 |
| 2009-11-02 | ABII-DELISTED | Stock | 31.95 | 32.3 | 31.26 | 31.77 | 27797.0 |
| 2009-11-02 | ABK-DELISTED | Stock | 1.15 | 1.15 | 1.01 | 1.04 | 10055352.0 |
| 2009-11-02 | ABM | Stock | 18.83 | 18.84 | 18.22 | 18.57 | 173000.0 |
| 2009-11-02 | ABMD-DELISTED | Stock | 9.13 | 9.15 | 8.7 | 8.85 | 228616.0 |
| 2009-11-02 | ABR | Stock | 2.03 | 2.08 | 1.9 | 1.92 | 49600.0 |
| 2009-11-02 | ABT | Stock | 24.3882 | 24.5418 | 24.2299 | 24.4266 | 11831388.0 |
| 2009-11-02 | ABTL-DELISTED | Stock | 3.7 | 3.999 | 3.7 | 3.8 | 4575.0 |
| 2009-11-02 | ABV-DELISTED | Stock | 90.84 | 91.92 | 88.84 | 90.47 | 654863.0 |
| 2009-11-02 | ABVT-DELISTED | Stock | 48.4 | 48.9314 | 47.93 | 48.13 | 101638.0 |
| 2009-11-02 | ABX-DELISTED | Stock | 36.86 | 37.27 | 35.5 | 36.5 | 14989355.0 |
| 2009-11-02 | ACAD | Stock | 1.3 | 1.33 | 1.17 | 1.31 | 377900.0 |
| 2009-11-02 | ACAP-DELISTED | Stock | 28.4 | 29.09 | 28.24 | 28.72 | 46954.0 |
| 2009-11-02 | ACAS-DELISTED | Stock | 2.7 | 2.805 | 2.55 | 2.6001 | 5349062.0 |
> showing 50 of 5,864 rows — these rows as CSV