PREVIEW / stock_daily / 2010-02-22
file: by_date/stock_daily/2010/2010-02-22.parquet size: 190 KB rows: 5,940 symbols: 3,511
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-22 | AAPL | Stock | 7.2264 | 7.2321 | 7.1139 | 7.1579 | 390563600.0 |
| 2010-02-22 | MSFT | Stock | 28.84 | 28.94 | 28.65 | 28.73 | 36707100.0 |
| 2010-02-22 | NVDA | Stock | 0.4162 | 0.4225 | 0.4125 | 0.4152 | 458084000.0 |
| 2010-02-22 | AMZN | Stock | 5.8685 | 5.9485 | 5.809 | 5.9005 | 136146000.0 |
| 2010-02-22 | TLT | Stock | 89.12 | 89.32 | 88.92 | 89.08 | 3382558.0 |
| 2010-02-22 | ES | Stock | 26.75 | 26.83 | 26.62 | 26.68 | 648300.0 |
| 2010-02-22 | CL | Stock | 40.925 | 41.175 | 40.75 | 41.04 | 4043400.0 |
| 2010-02-22 | A | Stock | 22.382 | 22.382 | 22.0672 | 22.2818 | 4038123.0 |
| 2010-02-22 | AABA-DELISTED | Stock | 15.6 | 15.68 | 15.44 | 15.49 | 10125439.0 |
| 2010-02-22 | AACC-DELISTED | Stock | 5.77 | 5.9 | 5.75 | 5.78 | 39136.0 |
| 2010-02-22 | AACG | Stock | 3.4 | 3.55 | 3.32 | 3.5 | 31000.0 |
| 2010-02-22 | AAI-DELISTED | Stock | 5.05 | 5.13 | 5.02 | 5.04 | 1685520.0 |
| 2010-02-22 | AAIC-DELISTED | Stock | 17.9 | 18.66 | 17.8499 | 18.2 | 48379.0 |
| 2010-02-22 | AAME | Stock | 1.4 | 1.45 | 1.4 | 1.41 | 8700.0 |
| 2010-02-22 | AAON | Stock | 4.3081 | 4.3457 | 4.2923 | 4.3101 | 377662.0 |
| 2010-02-22 | AAP | Stock | 39.97 | 40.46 | 39.88 | 40.24 | 1706100.0 |
| 2010-02-22 | AATI-DELISTED | Stock | 3.47 | 3.49 | 3.37 | 3.38 | 204081.0 |
| 2010-02-22 | AAU-DELISTED | Stock | 0.95 | 0.97 | 0.95 | 0.96 | 47295.0 |
| 2010-02-22 | AAUAF-DELISTED | Stock | 0.95 | 0.97 | 0.95 | 0.96 | 51795.0 |
| 2010-02-22 | AAV-DELISTED | Stock | 7.08 | 7.11 | 6.93 | 6.98 | 318241.0 |
| 2010-02-22 | AAWW-DELISTED | Stock | 39.98 | 40.61 | 39.82 | 40.01 | 247019.0 |
| 2010-02-22 | AAXJ | Stock | 53.31 | 53.31 | 52.85 | 53.01 | 131191.0 |
| 2010-02-22 | AAXN-DELISTED | Stock | 7.16 | 7.88 | 7.15 | 7.62 | 3853037.0 |
| 2010-02-22 | AB | Stock | 26.83 | 26.87 | 26.49 | 26.83 | 252900.0 |
| 2010-02-22 | ABAX-DELISTED | Stock | 25.61 | 25.97 | 25.61 | 25.95 | 134140.0 |
| 2010-02-22 | ABB-DELISTED | Stock | 20.08 | 20.13 | 19.96 | 20.02 | 2491844.0 |
| 2010-02-22 | ABBC-DELISTED | Stock | 7.71 | 7.72 | 7.57 | 7.65 | 19978.0 |
| 2010-02-22 | ABBNY-DELISTED | Stock | 20.08 | 20.13 | 19.96 | 20.05 | 2680774.0 |
| 2010-02-22 | ABC-DELISTED | Stock | 28.07 | 28.24 | 27.76 | 27.91 | 3246355.0 |
| 2010-02-22 | ABCB | Stock | 9.689 | 9.7285 | 9.1457 | 9.6989 | 33210.0 |
| 2010-02-22 | ABCD-DELISTED | Stock | 3.75 | 3.79 | 3.75 | 3.75 | 7688.0 |
| 2010-02-22 | ABCO-DELISTED | Stock | 16.2 | 16.285 | 16.05 | 16.255 | 118124.0 |
| 2010-02-22 | ABCW-DELISTED | Stock | 1.2391 | 1.2587 | 1.1899 | 1.19 | 65750.0 |
| 2010-02-22 | ABD-DELISTED | Stock | 7.555 | 7.775 | 7.515 | 7.535 | 267300.0 |
| 2010-02-22 | ABE-DELISTED | Stock | 16.15 | 16.18 | 16.09 | 16.09 | 14330.0 |
| 2010-02-22 | ABEO | Stock | 3275.0 | 3375.0 | 3250.0 | 3375.0 | 25.0 |
| 2010-02-22 | ABFS-DELISTED | Stock | 25.21 | 25.82 | 25.18 | 25.35 | 480242.0 |
| 2010-02-22 | ABG | Stock | 11.79 | 11.93 | 11.54 | 11.56 | 155700.0 |
| 2010-02-22 | ABII-DELISTED | Stock | 33.7 | 33.92 | 33.0 | 33.01 | 80256.0 |
| 2010-02-22 | ABK-DELISTED | Stock | 0.68 | 0.7 | 0.67 | 0.699 | 5911115.0 |
| 2010-02-22 | ABM | Stock | 20.76 | 20.86 | 20.54 | 20.75 | 72000.0 |
| 2010-02-22 | ABMD-DELISTED | Stock | 10.01 | 10.1 | 9.8 | 10.02 | 205225.0 |
| 2010-02-22 | ABR | Stock | 2.48 | 2.5 | 2.45 | 2.48 | 50600.0 |
| 2010-02-22 | ABT | Stock | 26.1443 | 26.1587 | 25.89 | 26.1011 | 11966236.0 |
| 2010-02-22 | ABTL-DELISTED | Stock | 5.55 | 5.55 | 5.25 | 5.45 | 9171.0 |
| 2010-02-22 | ABV-DELISTED | Stock | 100.89 | 100.93 | 98.79 | 99.03 | 500583.0 |
| 2010-02-22 | ABVA-DELISTED | Stock | 2.56 | 2.6 | 2.52 | 2.6 | 1900.0 |
| 2010-02-22 | ABVT-DELISTED | Stock | 61.9 | 62.0 | 61.43 | 61.92 | 54043.0 |
| 2010-02-22 | ABX-DELISTED | Stock | 39.54 | 39.66 | 38.32 | 38.4 | 10034100.0 |
| 2010-02-22 | ACAD | Stock | 1.29 | 1.32 | 1.29 | 1.31 | 206900.0 |
> showing 50 of 5,940 rows — these rows as CSV