PREVIEW / stock_daily / 2009-12-21
file: by_date/stock_daily/2009/2009-12-21.parquet size: 189 KB rows: 5,927 symbols: 3,508
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-12-21 | AAPL | Stock | 7.0018 | 7.1339 | 6.9882 | 7.0796 | 611906400.0 |
| 2009-12-21 | MSFT | Stock | 30.4 | 30.84 | 30.37 | 30.52 | 40129100.0 |
| 2009-12-21 | NVDA | Stock | 0.423 | 0.4372 | 0.4225 | 0.4355 | 427792000.0 |
| 2009-12-21 | AMZN | Stock | 6.524 | 6.66 | 6.5095 | 6.6395 | 189472000.0 |
| 2009-12-21 | TLT | Stock | 92.06 | 92.2 | 91.14 | 91.14 | 3523999.0 |
| 2009-12-21 | ES | Stock | 26.17 | 26.48 | 26.13 | 26.2 | 1918700.0 |
| 2009-12-21 | CL | Stock | 41.39 | 41.91 | 41.37 | 41.615 | 4686200.0 |
| 2009-12-21 | A | Stock | 21.1731 | 21.4163 | 20.9585 | 21.3948 | 4401743.0 |
| 2009-12-21 | AABA-DELISTED | Stock | 16.13 | 16.17 | 15.85 | 15.89 | 17550377.0 |
| 2009-12-21 | AACC-DELISTED | Stock | 6.03 | 6.08 | 6.0 | 6.03 | 41905.0 |
| 2009-12-21 | AACG | Stock | 4.83 | 4.84 | 4.43 | 4.43 | 7700.0 |
| 2009-12-21 | AAI-DELISTED | Stock | 5.15 | 5.26 | 5.12 | 5.25 | 2375628.0 |
| 2009-12-21 | AAIC-DELISTED | Stock | 15.15 | 15.85 | 15.15 | 15.4 | 18128.0 |
| 2009-12-21 | AAME | Stock | 1.03 | 1.2 | 1.03 | 1.2 | 4100.0 |
| 2009-12-21 | AAON | Stock | 3.923 | 3.9467 | 3.844 | 3.9447 | 247050.0 |
| 2009-12-21 | AAP | Stock | 40.79 | 41.75 | 40.79 | 41.58 | 1967900.0 |
| 2009-12-21 | AATI-DELISTED | Stock | 3.83 | 3.93 | 3.72 | 3.84 | 471758.0 |
| 2009-12-21 | AAU-DELISTED | Stock | 1.05 | 1.09 | 1.03 | 1.05 | 138087.0 |
| 2009-12-21 | AAUAF-DELISTED | Stock | 1.05 | 1.09 | 1.03 | 1.05 | 138583.0 |
| 2009-12-21 | AAV-DELISTED | Stock | 6.63 | 6.8 | 6.63 | 6.71 | 722012.0 |
| 2009-12-21 | AAWW-DELISTED | Stock | 37.15 | 37.54 | 36.73 | 37.36 | 221200.0 |
| 2009-12-21 | AAXJ | Stock | 54.61 | 54.8 | 54.32 | 54.41 | 798496.0 |
| 2009-12-21 | AAXN-DELISTED | Stock | 4.48 | 4.5 | 4.39 | 4.44 | 321074.0 |
| 2009-12-21 | AB | Stock | 25.94 | 26.64 | 25.88 | 26.62 | 379200.0 |
| 2009-12-21 | ABAX-DELISTED | Stock | 22.62 | 22.85 | 22.285 | 22.4 | 132256.0 |
| 2009-12-21 | ABB-DELISTED | Stock | 18.52 | 18.61 | 18.42 | 18.45 | 2501890.0 |
| 2009-12-21 | ABBC-DELISTED | Stock | 6.83 | 6.89 | 6.7 | 6.79 | 36569.0 |
| 2009-12-21 | ABBNY-DELISTED | Stock | 18.52 | 18.61 | 18.42 | 18.48 | 2505094.0 |
| 2009-12-21 | ABC-DELISTED | Stock | 26.18 | 26.55 | 26.0 | 26.1 | 2633872.0 |
| 2009-12-21 | ABCB | Stock | 6.704 | 6.8119 | 6.4982 | 6.557 | 17753.0 |
| 2009-12-21 | ABCD-DELISTED | Stock | 5.9 | 5.99 | 5.32 | 5.76 | 12237.0 |
| 2009-12-21 | ABCO-DELISTED | Stock | 13.83 | 14.04 | 13.235 | 13.975 | 106562.0 |
| 2009-12-21 | ABCW-DELISTED | Stock | 0.62 | 0.68 | 0.62 | 0.63 | 201710.0 |
| 2009-12-21 | ABD-DELISTED | Stock | 7.5 | 7.61 | 7.34 | 7.39 | 261060.0 |
| 2009-12-21 | ABE-DELISTED | Stock | 16.43 | 16.56 | 16.43 | 16.545 | 16255.0 |
| 2009-12-21 | ABEO | Stock | 3875.0 | 4050.0 | 3687.5 | 3812.5 | 34.0 |
| 2009-12-21 | ABFS-DELISTED | Stock | 31.34 | 32.38 | 31.25 | 31.65 | 371952.0 |
| 2009-12-21 | ABG | Stock | 11.11 | 11.58 | 11.08 | 11.49 | 285700.0 |
| 2009-12-21 | ABII-DELISTED | Stock | 35.17 | 39.27 | 35.17 | 39.03 | 48518.0 |
| 2009-12-21 | ABK-DELISTED | Stock | 0.78 | 0.79 | 0.75 | 0.788 | 6961424.0 |
| 2009-12-21 | ABM | Stock | 20.38 | 21.16 | 20.23 | 20.96 | 389600.0 |
| 2009-12-21 | ABMD-DELISTED | Stock | 8.2 | 8.55 | 8.175 | 8.53 | 142316.0 |
| 2009-12-21 | ABR | Stock | 1.66 | 1.7 | 1.65 | 1.68 | 108400.0 |
| 2009-12-21 | ABT | Stock | 25.7077 | 26.0052 | 25.6309 | 25.8708 | 12256982.0 |
| 2009-12-21 | ABTL-DELISTED | Stock | 5.151 | 5.151 | 4.7975 | 5.05 | 6741.0 |
| 2009-12-21 | ABV-DELISTED | Stock | 96.19 | 96.86 | 94.02 | 94.34 | 413217.0 |
| 2009-12-21 | ABVA-DELISTED | Stock | 3.46 | 3.56 | 3.02 | 3.31 | 4100.0 |
| 2009-12-21 | ABVT-DELISTED | Stock | 65.92 | 65.92 | 65.26 | 65.66 | 275440.0 |
| 2009-12-21 | ABX-DELISTED | Stock | 39.78 | 40.0 | 38.26 | 38.93 | 12190500.0 |
| 2009-12-21 | ACAD | Stock | 1.34 | 1.37 | 1.28 | 1.37 | 356600.0 |
> showing 50 of 5,927 rows — these rows as CSV