PREVIEW / stock_daily / 2009-05-26
file: by_date/stock_daily/2009/2009-05-26.parquet size: 180 KB rows: 5,781 symbols: 3,452
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-26 | AAPL | Stock | 4.4557 | 4.6725 | 4.4482 | 4.6707 | 636927200.0 |
| 2009-05-26 | MSFT | Stock | 19.54 | 20.45 | 19.45 | 20.34 | 44991700.0 |
| 2009-05-26 | NVDA | Stock | 0.2432 | 0.2608 | 0.2408 | 0.2588 | 865540000.0 |
| 2009-05-26 | AMZN | Stock | 3.7515 | 3.924 | 3.7275 | 3.9195 | 133992000.0 |
| 2009-05-26 | TLT | Stock | 94.05 | 94.1 | 92.12 | 92.12 | 3635200.0 |
| 2009-05-26 | ES | Stock | 20.37 | 20.85 | 20.07 | 20.81 | 1392400.0 |
| 2009-05-26 | CL | Stock | 31.91 | 32.46 | 31.78 | 32.38 | 7397000.0 |
| 2009-05-26 | A | Stock | 12.6323 | 12.9399 | 12.4464 | 12.9113 | 3461588.0 |
| 2009-05-26 | AABA-DELISTED | Stock | 14.7 | 15.44 | 14.67 | 15.27 | 19864971.0 |
| 2009-05-26 | AACC-DELISTED | Stock | 7.03 | 8.18 | 6.91 | 8.13 | 52877.0 |
| 2009-05-26 | AACG | Stock | 5.12 | 5.91 | 4.93 | 5.66 | 47900.0 |
| 2009-05-26 | AAI-DELISTED | Stock | 5.37 | 5.71 | 5.37 | 5.63 | 2207955.0 |
| 2009-05-26 | AAIC-DELISTED | Stock | 8.398 | 8.6 | 8.0 | 8.2 | 1162402.0 |
| 2009-05-26 | AAME | Stock | 0.76 | 0.76 | 0.7 | 0.7 | 6100.0 |
| 2009-05-26 | AAON | Stock | 4.0099 | 4.1817 | 4.0099 | 4.1422 | 536119.0 |
| 2009-05-26 | AAP | Stock | 42.6 | 45.2 | 42.43 | 45.13 | 3451300.0 |
| 2009-05-26 | AATI-DELISTED | Stock | 4.22 | 4.44 | 4.18 | 4.3 | 234859.0 |
| 2009-05-26 | AAU-DELISTED | Stock | 0.73 | 0.75 | 0.68 | 0.73 | 155440.0 |
| 2009-05-26 | AAUAF-DELISTED | Stock | 0.73 | 0.75 | 0.68 | 0.73 | 157140.0 |
| 2009-05-26 | AAV-DELISTED | Stock | 4.0 | 4.0701 | 3.95 | 4.02 | 1232548.0 |
| 2009-05-26 | AAWW-DELISTED | Stock | 23.01 | 24.96 | 23.0 | 24.74 | 498389.0 |
| 2009-05-26 | AAXJ | Stock | 42.67 | 44.7 | 42.02 | 43.36 | 620994.0 |
| 2009-05-26 | AAXN-DELISTED | Stock | 4.04 | 4.32 | 4.04 | 4.3 | 431482.0 |
| 2009-05-26 | AB | Stock | 18.2 | 19.1 | 18.2 | 18.68 | 436300.0 |
| 2009-05-26 | ABAX-DELISTED | Stock | 16.67 | 17.46 | 16.61 | 17.33 | 179935.0 |
| 2009-05-26 | ABB-DELISTED | Stock | 15.53 | 16.275 | 15.5 | 16.18 | 4989509.0 |
| 2009-05-26 | ABBC-DELISTED | Stock | 7.98 | 8.78 | 7.76 | 8.78 | 82774.0 |
| 2009-05-26 | ABBNY-DELISTED | Stock | 15.53 | 16.275 | 15.5 | 16.18 | 5321209.0 |
| 2009-05-26 | ABC-DELISTED | Stock | 18.27 | 18.78 | 18.2 | 18.68 | 2387608.0 |
| 2009-05-26 | ABCB | Stock | 5.9331 | 6.4195 | 5.9331 | 6.4195 | 20563.0 |
| 2009-05-26 | ABCO-DELISTED | Stock | 11.226 | 12.219 | 11.226 | 12.084 | 246726.0 |
| 2009-05-26 | ABCW-DELISTED | Stock | 1.29 | 1.41 | 1.29 | 1.41 | 118970.0 |
| 2009-05-26 | ABD-DELISTED | Stock | 2.69 | 3.01 | 2.67 | 2.91 | 252520.0 |
| 2009-05-26 | ABE-DELISTED | Stock | 14.71 | 15.1 | 14.71 | 15.0501 | 4600.0 |
| 2009-05-26 | ABEO | Stock | 1750.0 | 1750.0 | 1512.5 | 1625.0 | 14.0 |
| 2009-05-26 | ABFS-DELISTED | Stock | 26.4 | 28.24 | 26.39 | 28.06 | 644722.0 |
| 2009-05-26 | ABG | Stock | 9.17 | 10.0 | 9.06 | 9.88 | 585700.0 |
| 2009-05-26 | ABII-DELISTED | Stock | 49.78 | 51.28 | 49.658 | 50.2399 | 16108.0 |
| 2009-05-26 | ABK-DELISTED | Stock | 1.3 | 1.35 | 1.27 | 1.3 | 6513817.0 |
| 2009-05-26 | ABM | Stock | 15.92 | 16.84 | 15.92 | 16.7 | 270100.0 |
| 2009-05-26 | ABMD-DELISTED | Stock | 5.52 | 5.97 | 5.49 | 5.95 | 298360.0 |
| 2009-05-26 | ABR | Stock | 1.79 | 1.93 | 1.75 | 1.88 | 170100.0 |
| 2009-05-26 | ABT | Stock | 21.2264 | 21.5478 | 20.9433 | 21.3847 | 15573572.0 |
| 2009-05-26 | ABTL-DELISTED | Stock | 2.2 | 2.4 | 2.2 | 2.25 | 10632.0 |
| 2009-05-26 | ABV-DELISTED | Stock | 61.46 | 63.91 | 61.23 | 63.71 | 805171.0 |
| 2009-05-26 | ABVA-DELISTED | Stock | 3.02 | 3.48 | 3.02 | 3.48 | 2013.0 |
| 2009-05-26 | ABVT-DELISTED | Stock | 62.5 | 65.95 | 62.5 | 64.5 | 135461.0 |
| 2009-05-26 | ABX-DELISTED | Stock | 37.1 | 37.5 | 36.24 | 36.98 | 12916038.0 |
| 2009-05-26 | ACAD | Stock | 1.86 | 2.04 | 1.86 | 2.0 | 325600.0 |
| 2009-05-26 | ACAP-DELISTED | Stock | 36.39 | 38.86 | 36.39 | 38.38 | 63705.0 |
> showing 50 of 5,781 rows — these rows as CSV