PREVIEW / stock_daily / 2010-05-21
file: by_date/stock_daily/2010/2010-05-21.parquet size: 191 KB rows: 5,969 symbols: 3,525
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-21 | AAPL | Stock | 8.315 | 8.7321 | 8.2625 | 8.6543 | 1223891200.0 |
| 2010-05-21 | MSFT | Stock | 26.63 | 27.11 | 26.44 | 26.84 | 117596300.0 |
| 2010-05-21 | NVDA | Stock | 0.3025 | 0.327 | 0.3025 | 0.3183 | 1069600000.0 |
| 2010-05-21 | AMZN | Stock | 5.895 | 6.2485 | 5.876 | 6.136 | 159338000.0 |
| 2010-05-21 | TLT | Stock | 99.61 | 99.75 | 97.86 | 98.43 | 18671087.0 |
| 2010-05-21 | ES | Stock | 25.66 | 26.3 | 25.55 | 26.11 | 2190400.0 |
| 2010-05-21 | CL | Stock | 39.935 | 40.115 | 39.355 | 39.795 | 10941400.0 |
| 2010-05-21 | A | Stock | 21.6881 | 22.7396 | 21.588 | 22.4177 | 8263858.0 |
| 2010-05-21 | AABA-DELISTED | Stock | 14.81 | 15.9 | 14.63 | 15.48 | 29089191.0 |
| 2010-05-21 | AACC-DELISTED | Stock | 6.46 | 6.46 | 6.0 | 6.21 | 63011.0 |
| 2010-05-21 | AACG | Stock | 3.5 | 3.5 | 3.35 | 3.38 | 2400.0 |
| 2010-05-21 | AAI-DELISTED | Stock | 4.89 | 5.14 | 4.83 | 5.04 | 4468338.0 |
| 2010-05-21 | AAIC-DELISTED | Stock | 18.05 | 18.56 | 17.9 | 17.94 | 61355.0 |
| 2010-05-21 | AAON | Stock | 4.6479 | 4.7625 | 4.642 | 4.7447 | 389306.0 |
| 2010-05-21 | AAP | Stock | 48.67 | 50.98 | 48.29 | 49.47 | 3299400.0 |
| 2010-05-21 | AATI-DELISTED | Stock | 3.3 | 3.45 | 3.27 | 3.44 | 232863.0 |
| 2010-05-21 | AAU-DELISTED | Stock | 0.9713 | 1.04 | 0.91 | 1.01 | 462189.0 |
| 2010-05-21 | AAUAF-DELISTED | Stock | 0.9713 | 1.04 | 0.91 | 1.01 | 466389.0 |
| 2010-05-21 | AAV-DELISTED | Stock | 5.36 | 5.86 | 5.31 | 5.8 | 614510.0 |
| 2010-05-21 | AAWW-DELISTED | Stock | 46.1 | 50.66 | 45.51 | 50.22 | 889039.0 |
| 2010-05-21 | AAXJ | Stock | 48.76 | 51.46 | 48.76 | 51.46 | 302781.0 |
| 2010-05-21 | AAXN-DELISTED | Stock | 4.45 | 4.64 | 4.45 | 4.53 | 1056656.0 |
| 2010-05-21 | AB | Stock | 26.69 | 28.38 | 26.12 | 28.23 | 590400.0 |
| 2010-05-21 | ABAX-DELISTED | Stock | 22.76 | 23.49 | 22.4 | 22.99 | 271971.0 |
| 2010-05-21 | ABB-DELISTED | Stock | 16.38 | 16.99 | 16.26 | 16.98 | 6319612.0 |
| 2010-05-21 | ABBC-DELISTED | Stock | 8.95 | 9.34 | 8.68 | 9.11 | 109017.0 |
| 2010-05-21 | ABBNY-DELISTED | Stock | 16.37 | 16.99 | 16.26 | 16.97 | 6354575.0 |
| 2010-05-21 | ABC-DELISTED | Stock | 30.07 | 30.98 | 30.05 | 30.83 | 6468055.0 |
| 2010-05-21 | ABCB | Stock | 10.1716 | 10.6991 | 9.9626 | 10.5796 | 164881.0 |
| 2010-05-21 | ABCD-DELISTED | Stock | 4.85 | 5.05 | 4.85 | 5.0 | 65981.0 |
| 2010-05-21 | ABCO-DELISTED | Stock | 18.655 | 19.55 | 18.51 | 19.475 | 203960.0 |
| 2010-05-21 | ABCW-DELISTED | Stock | 0.64 | 0.76 | 0.61 | 0.69 | 116650.0 |
| 2010-05-21 | ABD-DELISTED | Stock | 6.06 | 6.63 | 5.93 | 6.53 | 420580.0 |
| 2010-05-21 | ABE-DELISTED | Stock | 14.84 | 15.105 | 14.11 | 15.08 | 36024.0 |
| 2010-05-21 | ABEO | Stock | 2750.0 | 2937.5 | 2737.5 | 2737.5 | 38.0 |
| 2010-05-21 | ABFS-DELISTED | Stock | 25.58 | 26.22 | 25.15 | 26.0 | 771962.0 |
| 2010-05-21 | ABG | Stock | 11.79 | 12.89 | 11.68 | 12.46 | 471600.0 |
| 2010-05-21 | ABII-DELISTED | Stock | 42.59 | 43.93 | 40.03 | 42.9 | 124788.0 |
| 2010-05-21 | ABK-DELISTED | Stock | 0.96 | 1.09 | 0.95 | 1.02 | 27938028.0 |
| 2010-05-21 | ABM | Stock | 20.47 | 21.06 | 20.25 | 20.89 | 354500.0 |
| 2010-05-21 | ABMD-DELISTED | Stock | 8.84 | 9.05 | 8.62 | 9.05 | 481669.0 |
| 2010-05-21 | ABR | Stock | 3.28 | 3.51 | 3.12 | 3.23 | 363900.0 |
| 2010-05-21 | ABT | Stock | 21.8213 | 22.541 | 21.7157 | 22.5218 | 34482701.0 |
| 2010-05-21 | ABTL-DELISTED | Stock | 4.5595 | 4.8505 | 4.5595 | 4.85 | 31399.0 |
| 2010-05-21 | ABV-DELISTED | Stock | 90.59 | 95.81 | 90.14 | 95.06 | 1098646.0 |
| 2010-05-21 | ABVT-DELISTED | Stock | 44.2 | 45.1 | 43.76 | 44.9 | 340068.0 |
| 2010-05-21 | ABX-DELISTED | Stock | 40.18 | 41.4 | 39.95 | 41.03 | 11794248.0 |
| 2010-05-21 | ACAD | Stock | 1.25 | 1.34 | 1.22 | 1.31 | 434900.0 |
| 2010-05-21 | ACAP-DELISTED | Stock | 30.01 | 31.12 | 30.01 | 30.66 | 47272.0 |
| 2010-05-21 | ACAS-DELISTED | Stock | 4.5 | 5.15 | 4.4 | 5.04 | 13659151.0 |
> showing 50 of 5,969 rows — these rows as CSV