PREVIEW / stock_daily / 2010-02-12
file: by_date/stock_daily/2010/2010-02-12.parquet size: 188 KB rows: 5,863 symbols: 3,470
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-02-12 | AAPL | Stock | 7.0754 | 7.2014 | 6.9821 | 7.1564 | 655468800.0 |
| 2010-02-12 | MSFT | Stock | 27.81 | 28.06 | 27.58 | 27.93 | 81117200.0 |
| 2010-02-12 | NVDA | Stock | 0.425 | 0.4425 | 0.4202 | 0.4338 | 780212000.0 |
| 2010-02-12 | AMZN | Stock | 5.9495 | 5.997 | 5.875 | 5.983 | 161470000.0 |
| 2010-02-12 | TLT | Stock | 90.31 | 90.42 | 89.95 | 90.19 | 2833791.0 |
| 2010-02-12 | ES | Stock | 25.11 | 25.21 | 24.9 | 25.13 | 1187300.0 |
| 2010-02-12 | CL | Stock | 40.055 | 40.13 | 39.545 | 39.83 | 4864600.0 |
| 2010-02-12 | A | Stock | 21.9242 | 21.9886 | 21.1516 | 21.4449 | 11457868.0 |
| 2010-02-12 | AABA-DELISTED | Stock | 15.07 | 15.19 | 14.85 | 15.17 | 18003521.0 |
| 2010-02-12 | AACC-DELISTED | Stock | 5.4 | 5.54 | 5.28 | 5.43 | 35731.0 |
| 2010-02-12 | AACG | Stock | 3.74 | 3.74 | 3.47 | 3.47 | 23000.0 |
| 2010-02-12 | AAI-DELISTED | Stock | 4.66 | 4.93 | 4.62 | 4.93 | 4132501.0 |
| 2010-02-12 | AAIC-DELISTED | Stock | 17.3 | 17.7285 | 16.7 | 16.91 | 35180.0 |
| 2010-02-12 | AAME | Stock | 1.45 | 1.5 | 1.45 | 1.5 | 12700.0 |
| 2010-02-12 | AAON | Stock | 4.1481 | 4.1857 | 4.1126 | 4.1758 | 272869.0 |
| 2010-02-12 | AAP | Stock | 42.37 | 42.81 | 42.0 | 42.81 | 1509800.0 |
| 2010-02-12 | AATI-DELISTED | Stock | 3.63 | 3.71 | 3.57 | 3.685 | 433123.0 |
| 2010-02-12 | AAU-DELISTED | Stock | 0.9417 | 0.97 | 0.92 | 0.9602 | 51756.0 |
| 2010-02-12 | AAUAF-DELISTED | Stock | 0.9417 | 0.97 | 0.92 | 0.9602 | 52016.0 |
| 2010-02-12 | AAV-DELISTED | Stock | 6.8 | 7.0 | 6.8 | 6.99 | 357586.0 |
| 2010-02-12 | AAWW-DELISTED | Stock | 37.96 | 38.64 | 37.1 | 38.41 | 280192.0 |
| 2010-02-12 | AAXJ | Stock | 52.12 | 52.31 | 51.63 | 52.19 | 101757.0 |
| 2010-02-12 | AAXN-DELISTED | Stock | 5.62 | 5.72 | 5.57 | 5.71 | 540044.0 |
| 2010-02-12 | AB | Stock | 25.7 | 26.57 | 25.47 | 26.53 | 694400.0 |
| 2010-02-12 | ABAX-DELISTED | Stock | 24.7 | 25.25 | 24.3001 | 25.25 | 138219.0 |
| 2010-02-12 | ABB-DELISTED | Stock | 17.6 | 17.95 | 17.54 | 17.88 | 2350769.0 |
| 2010-02-12 | ABBC-DELISTED | Stock | 7.25 | 7.32 | 7.22 | 7.3 | 29578.0 |
| 2010-02-12 | ABBNY-DELISTED | Stock | 17.6 | 17.95 | 17.54 | 17.87 | 2351644.0 |
| 2010-02-12 | ABC-DELISTED | Stock | 27.39 | 27.39 | 27.02 | 27.38 | 2582207.0 |
| 2010-02-12 | ABCB | Stock | 9.2742 | 9.5606 | 9.2742 | 9.5508 | 38373.0 |
| 2010-02-12 | ABCD-DELISTED | Stock | 3.51 | 3.75 | 3.41 | 3.75 | 16929.0 |
| 2010-02-12 | ABCO-DELISTED | Stock | 15.975 | 16.14 | 15.925 | 16.055 | 290522.0 |
| 2010-02-12 | ABCW-DELISTED | Stock | 1.22 | 1.24 | 1.19 | 1.21 | 170890.0 |
| 2010-02-12 | ABD-DELISTED | Stock | 7.34 | 7.4 | 7.067 | 7.25 | 914570.0 |
| 2010-02-12 | ABE-DELISTED | Stock | 15.94 | 16.14 | 15.83 | 16.0199 | 7549.0 |
| 2010-02-12 | ABEO | Stock | 3375.0 | 3437.5 | 3375.0 | 3437.5 | 18.0 |
| 2010-02-12 | ABFS-DELISTED | Stock | 23.05 | 23.14 | 22.47 | 23.14 | 668598.0 |
| 2010-02-12 | ABG | Stock | 10.82 | 11.25 | 10.78 | 11.24 | 227300.0 |
| 2010-02-12 | ABII-DELISTED | Stock | 34.6 | 34.86 | 33.2 | 34.03 | 37357.0 |
| 2010-02-12 | ABK-DELISTED | Stock | 0.6 | 0.6 | 0.56 | 0.585 | 4245889.0 |
| 2010-02-12 | ABM | Stock | 19.45 | 19.79 | 19.44 | 19.79 | 117700.0 |
| 2010-02-12 | ABMD-DELISTED | Stock | 9.49 | 9.69 | 9.23 | 9.64 | 283318.0 |
| 2010-02-12 | ABR | Stock | 2.27 | 2.32 | 2.26 | 2.3 | 21900.0 |
| 2010-02-12 | ABT | Stock | 25.5254 | 25.9092 | 25.4822 | 25.8756 | 17566069.0 |
| 2010-02-12 | ABTL-DELISTED | Stock | 5.5991 | 5.7009 | 5.3446 | 5.65 | 17293.0 |
| 2010-02-12 | ABV-DELISTED | Stock | 91.48 | 92.8 | 90.72 | 92.24 | 313993.0 |
| 2010-02-12 | ABVA-DELISTED | Stock | 2.36 | 2.901 | 2.36 | 2.71 | 5500.0 |
| 2010-02-12 | ABVT-DELISTED | Stock | 58.39 | 58.85 | 57.4015 | 58.29 | 61053.0 |
| 2010-02-12 | ABX-DELISTED | Stock | 36.48 | 36.75 | 35.96 | 36.62 | 9102589.0 |
| 2010-02-12 | ACAD | Stock | 1.28 | 1.39 | 1.26 | 1.39 | 390700.0 |
> showing 50 of 5,863 rows — these rows as CSV