PREVIEW / stock_daily / 2009-08-20
file: by_date/stock_daily/2009/2009-08-20.parquet size: 184 KB rows: 5,802 symbols: 3,455
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-20 | AAPL | Stock | 5.8921 | 5.9543 | 5.8789 | 5.9404 | 342031200.0 |
| 2009-08-20 | MSFT | Stock | 23.6 | 23.87 | 23.54 | 23.67 | 39505900.0 |
| 2009-08-20 | NVDA | Stock | 0.328 | 0.344 | 0.3273 | 0.3425 | 819840000.0 |
| 2009-08-20 | AMZN | Stock | 4.149 | 4.2175 | 4.133 | 4.2045 | 107500000.0 |
| 2009-08-20 | TLT | Stock | 95.38 | 95.87 | 94.7775 | 95.74 | 3282655.0 |
| 2009-08-20 | ES | Stock | 23.57 | 23.75 | 23.54 | 23.73 | 722500.0 |
| 2009-08-20 | CL | Stock | 35.97 | 36.465 | 35.77 | 36.385 | 5105600.0 |
| 2009-08-20 | A | Stock | 17.9828 | 18.1903 | 17.9685 | 18.1116 | 4521412.0 |
| 2009-08-20 | AABA-DELISTED | Stock | 14.76 | 14.9 | 14.7 | 14.74 | 15471223.0 |
| 2009-08-20 | AACC-DELISTED | Stock | 7.64 | 8.05 | 7.64 | 7.9 | 71160.0 |
| 2009-08-20 | AACG | Stock | 6.75 | 7.14 | 6.75 | 6.89 | 12800.0 |
| 2009-08-20 | AAI-DELISTED | Stock | 6.35 | 6.65 | 6.34 | 6.4 | 1733773.0 |
| 2009-08-20 | AAIC-DELISTED | Stock | 8.6 | 9.6 | 8.448 | 9.2 | 510689.0 |
| 2009-08-20 | AAON | Stock | 4.2825 | 4.3042 | 4.2331 | 4.2864 | 454106.0 |
| 2009-08-20 | AAP | Stock | 43.7 | 43.8 | 43.01 | 43.09 | 2125400.0 |
| 2009-08-20 | AATI-DELISTED | Stock | 4.5703 | 4.73 | 4.45 | 4.68 | 153690.0 |
| 2009-08-20 | AAU-DELISTED | Stock | 0.61 | 0.64 | 0.61 | 0.62 | 37254.0 |
| 2009-08-20 | AAUAF-DELISTED | Stock | 0.61 | 0.64 | 0.61 | 0.62 | 37554.0 |
| 2009-08-20 | AAV-DELISTED | Stock | 5.24 | 5.39 | 5.24 | 5.37 | 848201.0 |
| 2009-08-20 | AAWW-DELISTED | Stock | 23.8 | 24.23 | 23.35 | 23.8 | 302527.0 |
| 2009-08-20 | AAXJ | Stock | 47.98 | 48.83 | 47.74 | 48.81 | 128065.0 |
| 2009-08-20 | AAXN-DELISTED | Stock | 4.91 | 4.98 | 4.84 | 4.97 | 223977.0 |
| 2009-08-20 | AB | Stock | 20.56 | 21.39 | 20.45 | 21.3 | 458200.0 |
| 2009-08-20 | ABAX-DELISTED | Stock | 27.59 | 27.74 | 27.21 | 27.6 | 197489.0 |
| 2009-08-20 | ABB-DELISTED | Stock | 18.31 | 18.55 | 18.27 | 18.47 | 1977465.0 |
| 2009-08-20 | ABBC-DELISTED | Stock | 8.22 | 8.42 | 8.22 | 8.3 | 33868.0 |
| 2009-08-20 | ABBNY-DELISTED | Stock | 18.31 | 18.55 | 18.27 | 18.47 | 1982025.0 |
| 2009-08-20 | ABC-DELISTED | Stock | 20.85 | 21.04 | 20.64 | 21.0 | 2149831.0 |
| 2009-08-20 | ABCB | Stock | 6.1277 | 6.5362 | 6.0109 | 6.5362 | 59940.0 |
| 2009-08-20 | ABCO-DELISTED | Stock | 13.629 | 13.773 | 13.217 | 13.475 | 147229.0 |
| 2009-08-20 | ABCW-DELISTED | Stock | 1.4103 | 1.4596 | 1.4004 | 1.43 | 25480.0 |
| 2009-08-20 | ABD-DELISTED | Stock | 5.18 | 5.56 | 5.18 | 5.37 | 932630.0 |
| 2009-08-20 | ABE-DELISTED | Stock | 15.82 | 16.3 | 15.58 | 16.3 | 29517.0 |
| 2009-08-20 | ABEO | Stock | 4812.5 | 4875.0 | 4750.0 | 4875.0 | 5.0 |
| 2009-08-20 | ABFS-DELISTED | Stock | 29.89 | 30.74 | 29.4 | 29.98 | 369239.0 |
| 2009-08-20 | ABG | Stock | 13.11 | 13.42 | 12.98 | 13.32 | 144400.0 |
| 2009-08-20 | ABII-DELISTED | Stock | 27.47 | 28.85 | 27.15 | 28.58 | 40319.0 |
| 2009-08-20 | ABK-DELISTED | Stock | 1.05 | 1.17 | 1.05 | 1.12 | 16769555.0 |
| 2009-08-20 | ABM | Stock | 21.72 | 21.97 | 21.56 | 21.97 | 69400.0 |
| 2009-08-20 | ABMD-DELISTED | Stock | 7.63 | 7.99 | 7.63 | 7.94 | 207942.0 |
| 2009-08-20 | ABR | Stock | 1.88 | 1.9 | 1.82 | 1.85 | 77700.0 |
| 2009-08-20 | ABT | Stock | 21.6822 | 21.7973 | 21.5094 | 21.7253 | 10642559.0 |
| 2009-08-20 | ABTL-DELISTED | Stock | 3.2 | 3.5 | 3.05 | 3.15 | 65716.0 |
| 2009-08-20 | ABV-DELISTED | Stock | 73.45 | 75.63 | 73.33 | 75.57 | 340289.0 |
| 2009-08-20 | ABVT-DELISTED | Stock | 93.16 | 93.205 | 92.345 | 93.12 | 43792.0 |
| 2009-08-20 | ABX-DELISTED | Stock | 33.69 | 34.37 | 33.67 | 34.13 | 5743945.0 |
| 2009-08-20 | ACAD | Stock | 5.81 | 5.84 | 5.61 | 5.73 | 898600.0 |
| 2009-08-20 | ACAP-DELISTED | Stock | 31.11 | 31.402 | 30.69 | 30.95 | 52675.0 |
| 2009-08-20 | ACAS-DELISTED | Stock | 2.82 | 2.89 | 2.81 | 2.88 | 3179633.0 |
| 2009-08-20 | ACAT-DELISTED | Stock | 7.06 | 7.21 | 6.8394 | 7.21 | 37316.0 |
> showing 50 of 5,802 rows — these rows as CSV