PREVIEW / stock_daily / 2009-05-22
file: by_date/stock_daily/2009/2009-05-22.parquet size: 178 KB rows: 5,734 symbols: 3,419
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-05-22 | AAPL | Stock | 4.4304 | 4.435 | 4.3482 | 4.375 | 297998400.0 |
| 2009-05-22 | MSFT | Stock | 19.93 | 20.17 | 19.47 | 19.75 | 37318700.0 |
| 2009-05-22 | NVDA | Stock | 0.2418 | 0.249 | 0.2372 | 0.2455 | 718260000.0 |
| 2009-05-22 | AMZN | Stock | 3.805 | 3.852 | 3.751 | 3.782 | 69694000.0 |
| 2009-05-22 | TLT | Stock | 93.82 | 94.49 | 93.35 | 93.53 | 4484644.0 |
| 2009-05-22 | ES | Stock | 20.21 | 20.37 | 20.0 | 20.24 | 984600.0 |
| 2009-05-22 | CL | Stock | 31.95 | 32.32 | 31.795 | 32.055 | 6333000.0 |
| 2009-05-22 | A | Stock | 12.7039 | 12.804 | 12.4821 | 12.6538 | 3602926.0 |
| 2009-05-22 | AABA-DELISTED | Stock | 14.85 | 15.17 | 14.75 | 14.96 | 18974431.0 |
| 2009-05-22 | AACC-DELISTED | Stock | 7.06 | 7.28 | 7.0 | 7.1 | 21946.0 |
| 2009-05-22 | AACG | Stock | 5.01 | 5.2 | 5.01 | 5.19 | 13400.0 |
| 2009-05-22 | AAI-DELISTED | Stock | 5.99 | 5.99 | 5.4 | 5.43 | 3285845.0 |
| 2009-05-22 | AAIC-DELISTED | Stock | 8.4 | 8.6 | 8.2 | 8.2 | 375242.0 |
| 2009-05-22 | AAME | Stock | 0.76 | 0.76 | 0.76 | 0.76 | 900.0 |
| 2009-05-22 | AAON | Stock | 4.156 | 4.156 | 4.0217 | 4.0237 | 166556.0 |
| 2009-05-22 | AAP | Stock | 43.18 | 43.76 | 42.6 | 43.0 | 2091800.0 |
| 2009-05-22 | AATI-DELISTED | Stock | 4.31 | 4.4 | 4.23 | 4.28 | 124953.0 |
| 2009-05-22 | AAU-DELISTED | Stock | 0.68 | 0.74 | 0.68 | 0.74 | 234827.0 |
| 2009-05-22 | AAUAF-DELISTED | Stock | 0.68 | 0.74 | 0.68 | 0.74 | 237927.0 |
| 2009-05-22 | AAV-DELISTED | Stock | 4.08 | 4.19 | 4.0 | 4.0 | 804547.0 |
| 2009-05-22 | AAWW-DELISTED | Stock | 22.62 | 23.69 | 22.01 | 23.28 | 547599.0 |
| 2009-05-22 | AAXJ | Stock | 43.04 | 43.18 | 42.51 | 42.72 | 155216.0 |
| 2009-05-22 | AAXN-DELISTED | Stock | 4.14 | 4.2 | 4.05 | 4.05 | 368093.0 |
| 2009-05-22 | AB | Stock | 18.43 | 18.95 | 18.29 | 18.49 | 394700.0 |
| 2009-05-22 | ABAX-DELISTED | Stock | 17.08 | 17.12 | 16.86 | 16.86 | 90827.0 |
| 2009-05-22 | ABB-DELISTED | Stock | 16.11 | 16.2 | 15.9 | 16.01 | 2417542.0 |
| 2009-05-22 | ABBC-DELISTED | Stock | 8.14 | 8.37 | 8.04 | 8.04 | 23832.0 |
| 2009-05-22 | ABBNY-DELISTED | Stock | 16.11 | 16.2 | 15.9 | 16.01 | 2522642.0 |
| 2009-05-22 | ABC-DELISTED | Stock | 18.28 | 18.46 | 18.15 | 18.3 | 2307138.0 |
| 2009-05-22 | ABCB | Stock | 6.1957 | 6.1957 | 5.9331 | 5.9331 | 8533.0 |
| 2009-05-22 | ABCO-DELISTED | Stock | 11.522 | 11.662 | 11.253 | 11.268 | 218698.0 |
| 2009-05-22 | ABCW-DELISTED | Stock | 1.48 | 1.59 | 1.31 | 1.33 | 158360.0 |
| 2009-05-22 | ABD-DELISTED | Stock | 2.8 | 2.89 | 2.65 | 2.71 | 216630.0 |
| 2009-05-22 | ABE-DELISTED | Stock | 14.97 | 15.0199 | 14.66 | 14.85 | 5425.0 |
| 2009-05-22 | ABEO | Stock | 1562.5 | 1625.0 | 1375.0 | 1625.0 | 26.0 |
| 2009-05-22 | ABFS-DELISTED | Stock | 26.72 | 27.0 | 26.1 | 26.53 | 571009.0 |
| 2009-05-22 | ABG | Stock | 9.98 | 10.05 | 9.14 | 9.26 | 323200.0 |
| 2009-05-22 | ABII-DELISTED | Stock | 48.34 | 50.07 | 47.65 | 49.73 | 15243.0 |
| 2009-05-22 | ABK-DELISTED | Stock | 1.32 | 1.36 | 1.3 | 1.3 | 4043905.0 |
| 2009-05-22 | ABM | Stock | 16.14 | 16.18 | 15.86 | 16.02 | 203800.0 |
| 2009-05-22 | ABMD-DELISTED | Stock | 5.79 | 5.9 | 5.54 | 5.55 | 202919.0 |
| 2009-05-22 | ABR | Stock | 1.82 | 1.9 | 1.75 | 1.81 | 126800.0 |
| 2009-05-22 | ABT | Stock | 20.8905 | 21.3751 | 20.7849 | 21.0824 | 15513756.0 |
| 2009-05-22 | ABTL-DELISTED | Stock | 2.3 | 2.35 | 2.2025 | 2.25 | 9419.0 |
| 2009-05-22 | ABV-DELISTED | Stock | 62.92 | 63.31 | 62.07 | 62.94 | 332005.0 |
| 2009-05-22 | ABVA-DELISTED | Stock | 3.5 | 3.59 | 3.5 | 3.59 | 391.0 |
| 2009-05-22 | ABVT-DELISTED | Stock | 60.01 | 63.0 | 56.85 | 62.5 | 34793.0 |
| 2009-05-22 | ABX-DELISTED | Stock | 37.55 | 38.47 | 37.32 | 38.09 | 11744291.0 |
| 2009-05-22 | ACAD | Stock | 1.87 | 1.87 | 1.79 | 1.86 | 116900.0 |
| 2009-05-22 | ACAP-DELISTED | Stock | 37.76 | 38.25 | 37.26 | 37.39 | 51000.0 |
> showing 50 of 5,734 rows — these rows as CSV