PREVIEW / stock_daily / 2009-08-13
file: by_date/stock_daily/2009/2009-08-13.parquet size: 184 KB rows: 5,798 symbols: 3,448
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-08-13 | AAPL | Stock | 5.9518 | 6.0239 | 5.9464 | 6.015 | 439980800.0 |
| 2009-08-13 | MSFT | Stock | 23.63 | 23.85 | 23.4 | 23.62 | 38954500.0 |
| 2009-08-13 | NVDA | Stock | 0.3382 | 0.347 | 0.3322 | 0.3458 | 564028000.0 |
| 2009-08-13 | AMZN | Stock | 4.286 | 4.3185 | 4.2035 | 4.23 | 114248000.0 |
| 2009-08-13 | TLT | Stock | 91.8 | 93.15 | 91.5 | 92.99 | 3922266.0 |
| 2009-08-13 | ES | Stock | 23.63 | 23.64 | 23.34 | 23.55 | 1285700.0 |
| 2009-08-13 | CL | Stock | 35.885 | 36.035 | 35.5 | 36.015 | 3523000.0 |
| 2009-08-13 | A | Stock | 17.5536 | 17.7396 | 17.4249 | 17.5894 | 3019960.0 |
| 2009-08-13 | AABA-DELISTED | Stock | 14.73 | 15.07 | 14.61 | 15.04 | 30680975.0 |
| 2009-08-13 | AACC-DELISTED | Stock | 7.74 | 7.74 | 7.36 | 7.55 | 19344.0 |
| 2009-08-13 | AACG | Stock | 7.6 | 7.73 | 7.58 | 7.61 | 2600.0 |
| 2009-08-13 | AAI-DELISTED | Stock | 6.85 | 7.03 | 6.72 | 6.91 | 1878560.0 |
| 2009-08-13 | AAIC-DELISTED | Stock | 9.6 | 10.4 | 9.4 | 9.6 | 710545.0 |
| 2009-08-13 | AAME | Stock | 0.8 | 0.8 | 0.8 | 0.8 | 2700.0 |
| 2009-08-13 | AAON | Stock | 4.3733 | 4.3733 | 4.2667 | 4.3319 | 755831.0 |
| 2009-08-13 | AAP | Stock | 43.12 | 43.56 | 41.54 | 43.27 | 5816600.0 |
| 2009-08-13 | AATI-DELISTED | Stock | 4.5 | 4.9 | 4.5 | 4.8 | 264835.0 |
| 2009-08-13 | AAU-DELISTED | Stock | 0.6487 | 0.67 | 0.64 | 0.66 | 96201.0 |
| 2009-08-13 | AAUAF-DELISTED | Stock | 0.6487 | 0.67 | 0.64 | 0.66 | 97301.0 |
| 2009-08-13 | AAV-DELISTED | Stock | 5.14 | 5.23 | 5.11 | 5.13 | 503373.0 |
| 2009-08-13 | AAWW-DELISTED | Stock | 28.11 | 28.11 | 26.89 | 26.95 | 243522.0 |
| 2009-08-13 | AAXJ | Stock | 50.22 | 50.25 | 49.412 | 50.11 | 227028.0 |
| 2009-08-13 | AAXN-DELISTED | Stock | 5.09 | 5.11 | 5.01 | 5.02 | 289844.0 |
| 2009-08-13 | AB | Stock | 21.64 | 21.92 | 21.14 | 21.85 | 484200.0 |
| 2009-08-13 | ABAX-DELISTED | Stock | 28.55 | 28.93 | 28.23 | 28.93 | 146759.0 |
| 2009-08-13 | ABB-DELISTED | Stock | 18.71 | 18.78 | 18.49 | 18.71 | 2848242.0 |
| 2009-08-13 | ABBC-DELISTED | Stock | 8.56 | 8.63 | 8.16 | 8.4 | 29884.0 |
| 2009-08-13 | ABBNY-DELISTED | Stock | 18.71 | 18.78 | 18.49 | 18.69 | 2850242.0 |
| 2009-08-13 | ABC-DELISTED | Stock | 20.55 | 20.61 | 20.24 | 20.61 | 2027425.0 |
| 2009-08-13 | ABCB | Stock | 6.4681 | 6.4681 | 6.3319 | 6.4195 | 16656.0 |
| 2009-08-13 | ABCO-DELISTED | Stock | 13.74 | 13.745 | 13.431 | 13.655 | 94204.0 |
| 2009-08-13 | ABCW-DELISTED | Stock | 1.5499 | 1.6288 | 1.5301 | 1.54 | 49170.0 |
| 2009-08-13 | ABD-DELISTED | Stock | 4.6851 | 4.8649 | 4.6801 | 4.8049 | 276860.0 |
| 2009-08-13 | ABE-DELISTED | Stock | 16.77 | 16.7801 | 16.674 | 16.78 | 13253.0 |
| 2009-08-13 | ABEO | Stock | 5125.0 | 5187.5 | 5062.5 | 5125.0 | 27.0 |
| 2009-08-13 | ABFS-DELISTED | Stock | 30.17 | 30.4299 | 29.62 | 30.12 | 324448.0 |
| 2009-08-13 | ABG | Stock | 13.76 | 13.9 | 13.2 | 13.8 | 245600.0 |
| 2009-08-13 | ABII-DELISTED | Stock | 29.87 | 30.2 | 28.95 | 29.6 | 44808.0 |
| 2009-08-13 | ABK-DELISTED | Stock | 1.12 | 1.12 | 1.05 | 1.08 | 8485036.0 |
| 2009-08-13 | ABM | Stock | 22.05 | 22.05 | 21.68 | 21.87 | 74100.0 |
| 2009-08-13 | ABMD-DELISTED | Stock | 7.7 | 7.8955 | 7.6 | 7.84 | 147178.0 |
| 2009-08-13 | ABR | Stock | 2.11 | 2.15 | 2.08 | 2.11 | 96100.0 |
| 2009-08-13 | ABT | Stock | 21.1208 | 21.2935 | 20.9481 | 21.2647 | 17061901.0 |
| 2009-08-13 | ABTL-DELISTED | Stock | 2.3 | 2.5 | 2.3 | 2.45 | 15490.0 |
| 2009-08-13 | ABV-DELISTED | Stock | 74.35 | 75.04 | 73.14 | 74.26 | 358238.0 |
| 2009-08-13 | ABVA-DELISTED | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 138.0 |
| 2009-08-13 | ABVT-DELISTED | Stock | 92.86 | 92.99 | 91.0 | 92.75 | 91411.0 |
| 2009-08-13 | ABX-DELISTED | Stock | 34.33 | 34.75 | 33.7 | 34.25 | 6973621.0 |
| 2009-08-13 | ACAD | Stock | 5.39 | 6.6 | 5.22 | 6.11 | 6580400.0 |
| 2009-08-13 | ACAP-DELISTED | Stock | 33.03 | 33.14 | 32.32 | 32.61 | 44446.0 |
> showing 50 of 5,798 rows — these rows as CSV