PREVIEW / stock_daily / 2009-08-11
file: by_date/stock_daily/2009/2009-08-11.parquet size: 184 KB rows: 5,794 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-11 | AAPL | Stock | 5.8461 | 5.8707 | 5.7814 | 5.8154 | 355342400.0 |
| 2009-08-11 | MSFT | Stock | 23.32 | 23.4 | 23.05 | 23.13 | 33615800.0 |
| 2009-08-11 | NVDA | Stock | 0.3293 | 0.3342 | 0.322 | 0.3238 | 481884000.0 |
| 2009-08-11 | AMZN | Stock | 4.182 | 4.22 | 4.1225 | 4.178 | 100500000.0 |
| 2009-08-11 | TLT | Stock | 92.39 | 92.8673 | 91.99 | 92.68 | 3677733.0 |
| 2009-08-11 | ES | Stock | 23.4 | 23.42 | 23.13 | 23.34 | 674200.0 |
| 2009-08-11 | CL | Stock | 35.64 | 36.09 | 35.55 | 35.885 | 5185000.0 |
| 2009-08-11 | A | Stock | 16.9599 | 17.2461 | 16.7954 | 17.0887 | 4760330.0 |
| 2009-08-11 | AABA-DELISTED | Stock | 14.54 | 14.65 | 14.33 | 14.46 | 17312394.0 |
| 2009-08-11 | AACC-DELISTED | Stock | 7.46 | 7.54 | 7.22 | 7.29 | 41338.0 |
| 2009-08-11 | AACG | Stock | 8.02 | 8.02 | 7.9 | 7.9 | 8200.0 |
| 2009-08-11 | AAI-DELISTED | Stock | 6.61 | 6.73 | 6.53 | 6.69 | 1348718.0 |
| 2009-08-11 | AAIC-DELISTED | Stock | 8.4 | 8.8 | 8.4 | 8.6 | 1248370.0 |
| 2009-08-11 | AAME | Stock | 0.69 | 0.98 | 0.69 | 0.85 | 2900.0 |
| 2009-08-11 | AAON | Stock | 3.9822 | 4.1146 | 3.8973 | 3.9249 | 265275.0 |
| 2009-08-11 | AAP | Stock | 45.79 | 46.0 | 44.98 | 45.23 | 1623800.0 |
| 2009-08-11 | AATI-DELISTED | Stock | 4.46 | 4.497 | 4.275 | 4.36 | 295720.0 |
| 2009-08-11 | AAU-DELISTED | Stock | 0.65 | 0.65 | 0.6203 | 0.63 | 29000.0 |
| 2009-08-11 | AAUAF-DELISTED | Stock | 0.65 | 0.65 | 0.6203 | 0.63 | 29600.0 |
| 2009-08-11 | AAV-DELISTED | Stock | 4.9 | 5.02 | 4.9 | 4.96 | 602638.0 |
| 2009-08-11 | AAWW-DELISTED | Stock | 28.01 | 28.44 | 27.12 | 27.91 | 183038.0 |
| 2009-08-11 | AAXJ | Stock | 50.4 | 50.4 | 48.71 | 48.9 | 56464.0 |
| 2009-08-11 | AAXN-DELISTED | Stock | 5.25 | 5.25 | 5.02 | 5.12 | 314981.0 |
| 2009-08-11 | AB | Stock | 20.94 | 20.94 | 20.34 | 20.68 | 395000.0 |
| 2009-08-11 | ABAX-DELISTED | Stock | 27.69 | 28.45 | 27.53 | 28.2 | 237936.0 |
| 2009-08-11 | ABB-DELISTED | Stock | 18.05 | 18.06 | 17.85 | 17.99 | 2135923.0 |
| 2009-08-11 | ABBC-DELISTED | Stock | 8.05 | 8.4899 | 8.01 | 8.09 | 36000.0 |
| 2009-08-11 | ABBNY-DELISTED | Stock | 18.05 | 18.06 | 17.85 | 17.96 | 2164623.0 |
| 2009-08-11 | ABC-DELISTED | Stock | 20.32 | 20.38 | 20.07 | 20.3 | 2757314.0 |
| 2009-08-11 | ABCB | Stock | 6.5848 | 6.5848 | 6.3221 | 6.361 | 10384.0 |
| 2009-08-11 | ABCO-DELISTED | Stock | 13.585 | 13.83 | 13.31 | 13.39 | 262386.0 |
| 2009-08-11 | ABCW-DELISTED | Stock | 1.47 | 1.64 | 1.47 | 1.54 | 133020.0 |
| 2009-08-11 | ABD-DELISTED | Stock | 4.9 | 4.94 | 4.6394 | 4.72 | 159470.0 |
| 2009-08-11 | ABE-DELISTED | Stock | 16.87 | 16.87 | 16.2401 | 16.62 | 14949.0 |
| 2009-08-11 | ABEO | Stock | 5275.0 | 5337.5 | 5012.5 | 5250.0 | 36.0 |
| 2009-08-11 | ABFS-DELISTED | Stock | 28.65 | 29.19 | 28.17 | 28.97 | 652082.0 |
| 2009-08-11 | ABG | Stock | 14.02 | 14.02 | 13.0 | 13.14 | 250300.0 |
| 2009-08-11 | ABII-DELISTED | Stock | 30.68 | 31.66 | 29.62 | 30.15 | 68058.0 |
| 2009-08-11 | ABK-DELISTED | Stock | 1.16 | 1.16 | 1.04 | 1.06 | 12689185.0 |
| 2009-08-11 | ABM | Stock | 21.83 | 21.95 | 21.25 | 21.59 | 99800.0 |
| 2009-08-11 | ABMD-DELISTED | Stock | 7.31 | 7.44 | 7.23 | 7.29 | 147467.0 |
| 2009-08-11 | ABR | Stock | 2.08 | 2.2 | 1.93 | 2.2 | 273600.0 |
| 2009-08-11 | ABT | Stock | 21.3607 | 21.5334 | 21.3175 | 21.4471 | 13569404.0 |
| 2009-08-11 | ABTL-DELISTED | Stock | 2.447 | 2.5031 | 2.447 | 2.453 | 7993.0 |
| 2009-08-11 | ABV-DELISTED | Stock | 72.76 | 72.98 | 71.6 | 72.53 | 382735.0 |
| 2009-08-11 | ABVA-DELISTED | Stock | 2.55 | 2.65 | 2.5 | 2.56 | 6685.0 |
| 2009-08-11 | ABVT-DELISTED | Stock | 93.23 | 93.23 | 91.47 | 92.26 | 74388.0 |
| 2009-08-11 | ABX-DELISTED | Stock | 34.04 | 34.25 | 33.5 | 33.63 | 6142476.0 |
| 2009-08-11 | ACAD | Stock | 5.5 | 5.63 | 5.11 | 5.38 | 1943900.0 |
| 2009-08-11 | ACAP-DELISTED | Stock | 32.94 | 33.35 | 32.61 | 32.8 | 49189.0 |
> showing 50 of 5,794 rows — these rows as CSV