PREVIEW / stock_daily / 2009-11-24
file: by_date/stock_daily/2009/2009-11-24.parquet size: 187 KB rows: 5,871 symbols: 3,477
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-11-24 | AAPL | Stock | 7.3332 | 7.3529 | 7.2464 | 7.3014 | 318438400.0 |
| 2009-11-24 | MSFT | Stock | 29.95 | 29.99 | 29.75 | 29.91 | 37341400.0 |
| 2009-11-24 | NVDA | Stock | 0.3235 | 0.3258 | 0.3178 | 0.323 | 418504000.0 |
| 2009-11-24 | AMZN | Stock | 6.6785 | 6.7165 | 6.611 | 6.647 | 146394000.0 |
| 2009-11-24 | TLT | Stock | 95.11 | 95.7 | 94.99 | 95.6 | 2895637.0 |
| 2009-11-24 | ES | Stock | 24.21 | 24.38 | 24.01 | 24.38 | 2009600.0 |
| 2009-11-24 | CL | Stock | 42.465 | 42.57 | 42.0 | 42.53 | 4345600.0 |
| 2009-11-24 | A | Stock | 20.9728 | 20.9728 | 20.6581 | 20.9156 | 2167319.0 |
| 2009-11-24 | AABA-DELISTED | Stock | 15.38 | 15.49 | 15.2 | 15.25 | 19061426.0 |
| 2009-11-24 | AACC-DELISTED | Stock | 5.77 | 5.87 | 5.71 | 5.76 | 17051.0 |
| 2009-11-24 | AACG | Stock | 5.31 | 5.57 | 5.29 | 5.56 | 19400.0 |
| 2009-11-24 | AAI-DELISTED | Stock | 4.15 | 4.25 | 4.05 | 4.11 | 2404339.0 |
| 2009-11-24 | AAIC-DELISTED | Stock | 13.2 | 13.33 | 12.99 | 13.28 | 7835.0 |
| 2009-11-24 | AAME | Stock | 1.33 | 1.38 | 1.33 | 1.38 | 2100.0 |
| 2009-11-24 | AAON | Stock | 3.9012 | 3.9012 | 3.7926 | 3.8677 | 144281.0 |
| 2009-11-24 | AAP | Stock | 39.31 | 39.51 | 39.02 | 39.16 | 1415500.0 |
| 2009-11-24 | AATI-DELISTED | Stock | 3.35 | 3.43 | 3.3 | 3.41 | 184572.0 |
| 2009-11-24 | AAU-DELISTED | Stock | 0.76 | 0.7728 | 0.75 | 0.77 | 105737.0 |
| 2009-11-24 | AAUAF-DELISTED | Stock | 0.76 | 0.7727 | 0.75 | 0.7699 | 106245.0 |
| 2009-11-24 | AAV-DELISTED | Stock | 5.89 | 5.89 | 5.4 | 5.6 | 1186504.0 |
| 2009-11-24 | AAWW-DELISTED | Stock | 30.82 | 30.9899 | 30.47 | 30.8 | 276845.0 |
| 2009-11-24 | AAXJ | Stock | 55.37 | 55.73 | 55.05 | 55.73 | 925384.0 |
| 2009-11-24 | AAXN-DELISTED | Stock | 4.24 | 4.45 | 4.16 | 4.31 | 1317345.0 |
| 2009-11-24 | AB | Stock | 26.7 | 26.98 | 26.59 | 26.63 | 203900.0 |
| 2009-11-24 | ABAX-DELISTED | Stock | 23.02 | 23.39 | 22.75 | 23.37 | 154441.0 |
| 2009-11-24 | ABB-DELISTED | Stock | 19.21 | 19.21 | 18.97 | 18.99 | 5697639.0 |
| 2009-11-24 | ABBC-DELISTED | Stock | 6.77 | 6.9 | 6.73 | 6.87 | 12992.0 |
| 2009-11-24 | ABBNY-DELISTED | Stock | 19.21 | 19.21 | 18.97 | 19.01 | 5733426.0 |
| 2009-11-24 | ABC-DELISTED | Stock | 25.01 | 25.07 | 24.81 | 25.03 | 2314796.0 |
| 2009-11-24 | ABCB | Stock | 6.1846 | 6.3708 | 6.0081 | 6.3022 | 78153.0 |
| 2009-11-24 | ABCO-DELISTED | Stock | 12.513 | 12.578 | 12.397 | 12.502 | 234236.0 |
| 2009-11-24 | ABCW-DELISTED | Stock | 0.5994 | 0.6405 | 0.5605 | 0.6006 | 196380.0 |
| 2009-11-24 | ABD-DELISTED | Stock | 6.3 | 6.37 | 6.02 | 6.17 | 315570.0 |
| 2009-11-24 | ABE-DELISTED | Stock | 16.81 | 16.868 | 16.66 | 16.76 | 16095.0 |
| 2009-11-24 | ABEO | Stock | 3512.5 | 3850.0 | 3512.5 | 3850.0 | 9.0 |
| 2009-11-24 | ABFS-DELISTED | Stock | 25.38 | 25.38 | 24.82 | 25.07 | 246353.0 |
| 2009-11-24 | ABG | Stock | 10.3 | 11.4 | 10.3 | 11.07 | 654600.0 |
| 2009-11-24 | ABII-DELISTED | Stock | 33.5 | 33.78 | 33.34 | 33.52 | 8696.0 |
| 2009-11-24 | ABK-DELISTED | Stock | 0.9199 | 0.928 | 0.8 | 0.85 | 17840406.0 |
| 2009-11-24 | ABM | Stock | 19.24 | 19.34 | 18.86 | 19.18 | 93400.0 |
| 2009-11-24 | ABMD-DELISTED | Stock | 8.57 | 9.0 | 8.45 | 8.98 | 216485.0 |
| 2009-11-24 | ABR | Stock | 1.86 | 1.89 | 1.8 | 1.83 | 71900.0 |
| 2009-11-24 | ABT | Stock | 25.535 | 26.1443 | 25.1895 | 26.0244 | 18005627.0 |
| 2009-11-24 | ABTL-DELISTED | Stock | 4.75 | 4.9 | 4.4 | 4.9 | 26233.0 |
| 2009-11-24 | ABV-DELISTED | Stock | 98.64 | 99.1 | 97.74 | 98.41 | 372967.0 |
| 2009-11-24 | ABVT-DELISTED | Stock | 54.665 | 54.665 | 52.75 | 53.93 | 101438.0 |
| 2009-11-24 | ABX-DELISTED | Stock | 44.18 | 44.25 | 42.92 | 43.2 | 13704566.0 |
| 2009-11-24 | ACAD | Stock | 1.31 | 1.34 | 1.28 | 1.32 | 165400.0 |
| 2009-11-24 | ACAP-DELISTED | Stock | 27.86 | 28.57 | 27.73 | 28.56 | 35032.0 |
| 2009-11-24 | ACAS-DELISTED | Stock | 3.1 | 3.105 | 3.045 | 3.1 | 3033258.0 |
> showing 50 of 5,871 rows — these rows as CSV