PREVIEW / stock_daily / 2009-05-27
file: by_date/stock_daily/2009/2009-05-27.parquet size: 180 KB rows: 5,779 symbols: 3,451
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-27 | AAPL | Stock | 4.7064 | 4.8207 | 4.6754 | 4.7518 | 646422000.0 |
| 2009-05-27 | MSFT | Stock | 20.25 | 20.6 | 20.07 | 20.13 | 42892900.0 |
| 2009-05-27 | NVDA | Stock | 0.2575 | 0.267 | 0.255 | 0.2592 | 814152000.0 |
| 2009-05-27 | AMZN | Stock | 3.9255 | 3.975 | 3.8375 | 3.855 | 111342000.0 |
| 2009-05-27 | TLT | Stock | 92.24 | 92.58 | 90.38 | 90.492 | 7490809.0 |
| 2009-05-27 | ES | Stock | 20.76 | 20.8 | 20.47 | 20.6 | 2034400.0 |
| 2009-05-27 | CL | Stock | 32.325 | 32.38 | 31.65 | 31.75 | 6959800.0 |
| 2009-05-27 | A | Stock | 12.9399 | 13.0901 | 12.7539 | 12.7969 | 3757824.0 |
| 2009-05-27 | AABA-DELISTED | Stock | 15.27 | 15.53 | 14.88 | 14.94 | 18924999.0 |
| 2009-05-27 | AACC-DELISTED | Stock | 8.14 | 8.31 | 7.56 | 7.56 | 48090.0 |
| 2009-05-27 | AACG | Stock | 5.6 | 5.88 | 5.6 | 5.88 | 24000.0 |
| 2009-05-27 | AAI-DELISTED | Stock | 5.55 | 5.63 | 5.3 | 5.3 | 2705950.0 |
| 2009-05-27 | AAIC-DELISTED | Stock | 8.2 | 8.52 | 7.6 | 7.8 | 3556567.0 |
| 2009-05-27 | AAME | Stock | 0.72 | 0.72 | 0.71 | 0.71 | 4800.0 |
| 2009-05-27 | AAON | Stock | 4.1422 | 4.1659 | 4.0217 | 4.0612 | 423225.0 |
| 2009-05-27 | AAP | Stock | 44.6 | 45.0 | 43.87 | 44.15 | 2489700.0 |
| 2009-05-27 | AATI-DELISTED | Stock | 4.26 | 4.54 | 4.24 | 4.5 | 228705.0 |
| 2009-05-27 | AAU-DELISTED | Stock | 0.75 | 0.802 | 0.74 | 0.76 | 160156.0 |
| 2009-05-27 | AAUAF-DELISTED | Stock | 0.75 | 0.802 | 0.74 | 0.76 | 161656.0 |
| 2009-05-27 | AAV-DELISTED | Stock | 4.03 | 4.09 | 3.96 | 4.03 | 643890.0 |
| 2009-05-27 | AAWW-DELISTED | Stock | 24.74 | 25.49 | 24.612 | 24.74 | 408730.0 |
| 2009-05-27 | AAXJ | Stock | 43.62 | 43.96 | 42.86 | 43.05 | 180433.0 |
| 2009-05-27 | AAXN-DELISTED | Stock | 4.24 | 4.32 | 4.17 | 4.2 | 321462.0 |
| 2009-05-27 | AB | Stock | 18.47 | 18.78 | 18.32 | 18.34 | 539000.0 |
| 2009-05-27 | ABAX-DELISTED | Stock | 17.28 | 17.58 | 17.09 | 17.48 | 130826.0 |
| 2009-05-27 | ABB-DELISTED | Stock | 16.25 | 16.34 | 15.92 | 15.93 | 3211332.0 |
| 2009-05-27 | ABBC-DELISTED | Stock | 8.64 | 8.66 | 8.24 | 8.24 | 42877.0 |
| 2009-05-27 | ABBNY-DELISTED | Stock | 16.25 | 16.34 | 15.92 | 15.93 | 3265120.0 |
| 2009-05-27 | ABC-DELISTED | Stock | 18.72 | 18.79 | 18.34 | 18.38 | 2807942.0 |
| 2009-05-27 | ABCB | Stock | 6.3513 | 6.361 | 5.8067 | 5.8164 | 19432.0 |
| 2009-05-27 | ABCO-DELISTED | Stock | 12.01 | 12.01 | 11.415 | 11.515 | 339064.0 |
| 2009-05-27 | ABCW-DELISTED | Stock | 1.41 | 1.52 | 1.4 | 1.46 | 158720.0 |
| 2009-05-27 | ABD-DELISTED | Stock | 2.91 | 3.14 | 2.91 | 2.99 | 235480.0 |
| 2009-05-27 | ABE-DELISTED | Stock | 15.0 | 15.25 | 15.0 | 15.11 | 3664.0 |
| 2009-05-27 | ABEO | Stock | 1625.0 | 1750.0 | 1625.0 | 1725.0 | 23.0 |
| 2009-05-27 | ABFS-DELISTED | Stock | 27.8 | 28.6 | 27.54 | 27.69 | 455942.0 |
| 2009-05-27 | ABG | Stock | 9.81 | 10.33 | 9.16 | 9.22 | 318000.0 |
| 2009-05-27 | ABII-DELISTED | Stock | 50.18 | 50.25 | 49.6 | 50.0 | 3972.0 |
| 2009-05-27 | ABK-DELISTED | Stock | 1.32 | 1.34 | 1.27 | 1.27 | 4270749.0 |
| 2009-05-27 | ABM | Stock | 16.65 | 16.75 | 16.2 | 16.24 | 120100.0 |
| 2009-05-27 | ABMD-DELISTED | Stock | 5.92 | 6.24 | 5.8 | 6.05 | 291813.0 |
| 2009-05-27 | ABR | Stock | 1.88 | 1.88 | 1.79 | 1.83 | 136200.0 |
| 2009-05-27 | ABT | Stock | 21.3511 | 21.4663 | 21.2455 | 21.2983 | 12402251.0 |
| 2009-05-27 | ABTL-DELISTED | Stock | 2.3011 | 2.3011 | 2.1477 | 2.25 | 14209.0 |
| 2009-05-27 | ABV-DELISTED | Stock | 64.49 | 64.58 | 62.63 | 62.86 | 664551.0 |
| 2009-05-27 | ABVA-DELISTED | Stock | 3.1 | 3.3599 | 3.1 | 3.19 | 1220.0 |
| 2009-05-27 | ABVT-DELISTED | Stock | 64.02 | 70.21 | 64.02 | 70.1 | 258066.0 |
| 2009-05-27 | ABX-DELISTED | Stock | 37.02 | 37.24 | 35.94 | 36.02 | 10931172.0 |
| 2009-05-27 | ACAD | Stock | 1.99 | 2.04 | 1.88 | 1.89 | 185000.0 |
| 2009-05-27 | ACAP-DELISTED | Stock | 38.37 | 38.63 | 37.75 | 37.83 | 46973.0 |
> showing 50 of 5,779 rows — these rows as CSV