PREVIEW / stock_daily / 2009-09-25
file: by_date/stock_daily/2009/2009-09-25.parquet size: 186 KB rows: 5,823 symbols: 3,480
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-09-25 | AAPL | Stock | 6.5004 | 6.625 | 6.48 | 6.5132 | 445239200.0 |
| 2009-09-25 | MSFT | Stock | 25.69 | 25.82 | 25.52 | 25.55 | 50158900.0 |
| 2009-09-25 | NVDA | Stock | 0.3665 | 0.3682 | 0.3598 | 0.3625 | 377556000.0 |
| 2009-09-25 | AMZN | Stock | 4.572 | 4.6125 | 4.4875 | 4.526 | 85136000.0 |
| 2009-09-25 | TLT | Stock | 97.36 | 98.06 | 96.77 | 97.98 | 3855025.0 |
| 2009-09-25 | ES | Stock | 23.75 | 24.03 | 23.66 | 23.83 | 1025800.0 |
| 2009-09-25 | CL | Stock | 38.185 | 38.595 | 38.1 | 38.25 | 4824800.0 |
| 2009-09-25 | A | Stock | 19.8641 | 19.9142 | 19.6567 | 19.7282 | 5157502.0 |
| 2009-09-25 | AABA-DELISTED | Stock | 16.8 | 17.15 | 16.75 | 17.09 | 20467363.0 |
| 2009-09-25 | AACC-DELISTED | Stock | 7.52 | 7.66 | 7.4 | 7.46 | 26449.0 |
| 2009-09-25 | AACG | Stock | 6.2 | 6.33 | 5.8 | 5.96 | 21400.0 |
| 2009-09-25 | AAI-DELISTED | Stock | 6.35 | 6.5405 | 6.35 | 6.45 | 1536431.0 |
| 2009-09-25 | AAIC-DELISTED | Stock | 10.0 | 11.0 | 9.8 | 10.286 | 599369.0 |
| 2009-09-25 | AAON | Stock | 4.0395 | 4.1027 | 3.9941 | 4.0178 | 396900.0 |
| 2009-09-25 | AAP | Stock | 38.94 | 39.53 | 38.63 | 39.17 | 1685400.0 |
| 2009-09-25 | AATI-DELISTED | Stock | 4.05 | 4.1 | 4.0 | 4.02 | 235737.0 |
| 2009-09-25 | AAU-DELISTED | Stock | 0.66 | 0.68 | 0.66 | 0.67 | 44875.0 |
| 2009-09-25 | AAUAF-DELISTED | Stock | 0.66 | 0.68 | 0.66 | 0.67 | 46875.0 |
| 2009-09-25 | AAV-DELISTED | Stock | 6.63 | 6.79 | 6.42 | 6.469 | 1029578.0 |
| 2009-09-25 | AAWW-DELISTED | Stock | 32.53 | 33.08 | 31.39 | 32.0 | 316536.0 |
| 2009-09-25 | AAXJ | Stock | 51.93 | 52.01 | 51.29 | 51.79 | 69769.0 |
| 2009-09-25 | AAXN-DELISTED | Stock | 4.5 | 4.56 | 4.46 | 4.48 | 368190.0 |
| 2009-09-25 | AB | Stock | 25.81 | 26.25 | 25.25 | 25.4 | 383900.0 |
| 2009-09-25 | ABAX-DELISTED | Stock | 26.68 | 27.075 | 26.6701 | 27.03 | 118968.0 |
| 2009-09-25 | ABB-DELISTED | Stock | 20.06 | 20.26 | 19.85 | 20.1 | 5040206.0 |
| 2009-09-25 | ABBC-DELISTED | Stock | 7.83 | 7.899 | 7.69 | 7.86 | 49962.0 |
| 2009-09-25 | ABBNY-DELISTED | Stock | 20.06 | 20.26 | 19.85 | 20.1 | 5042464.0 |
| 2009-09-25 | ABC-DELISTED | Stock | 21.55 | 21.76 | 21.44 | 21.51 | 1902625.0 |
| 2009-09-25 | ABCB | Stock | 6.9349 | 7.3338 | 6.9349 | 7.11 | 22105.0 |
| 2009-09-25 | ABCO-DELISTED | Stock | 12.817 | 13.108 | 12.692 | 12.833 | 74486.0 |
| 2009-09-25 | ABCW-DELISTED | Stock | 1.32 | 1.38 | 1.27 | 1.33 | 29990.0 |
| 2009-09-25 | ABD-DELISTED | Stock | 7.16 | 7.281 | 7.0 | 7.18 | 246650.0 |
| 2009-09-25 | ABE-DELISTED | Stock | 17.12 | 17.12 | 16.58 | 17.1 | 85886.0 |
| 2009-09-25 | ABEO | Stock | 4000.0 | 4012.5 | 3512.5 | 3575.0 | 172.0 |
| 2009-09-25 | ABFS-DELISTED | Stock | 31.05 | 31.3 | 29.5 | 29.94 | 502638.0 |
| 2009-09-25 | ABG | Stock | 12.45 | 12.72 | 12.41 | 12.71 | 197400.0 |
| 2009-09-25 | ABII-DELISTED | Stock | 31.11 | 34.42 | 31.11 | 34.24 | 103082.0 |
| 2009-09-25 | ABK-DELISTED | Stock | 1.77 | 1.82 | 1.7 | 1.74 | 16363803.0 |
| 2009-09-25 | ABM | Stock | 20.12 | 20.45 | 20.08 | 20.26 | 126500.0 |
| 2009-09-25 | ABMD-DELISTED | Stock | 9.28 | 9.48 | 9.1 | 9.32 | 168682.0 |
| 2009-09-25 | ABR | Stock | 2.72 | 2.95 | 2.71 | 2.77 | 409200.0 |
| 2009-09-25 | ABT | Stock | 22.4354 | 22.9248 | 22.4354 | 22.7089 | 23838058.0 |
| 2009-09-25 | ABTL-DELISTED | Stock | 3.0023 | 3.0028 | 2.9027 | 2.9977 | 7306.0 |
| 2009-09-25 | ABV-DELISTED | Stock | 79.25 | 79.63 | 78.32 | 79.38 | 344054.0 |
| 2009-09-25 | ABVA-DELISTED | Stock | 2.525 | 2.525 | 2.13 | 2.3 | 15798.0 |
| 2009-09-25 | ABVT-DELISTED | Stock | 48.2 | 49.57 | 48.13 | 48.58 | 148218.0 |
| 2009-09-25 | ABX-DELISTED | Stock | 35.94 | 36.56 | 35.48 | 36.15 | 15095822.0 |
| 2009-09-25 | ACAD | Stock | 1.77 | 1.81 | 1.73 | 1.75 | 857000.0 |
| 2009-09-25 | ACAP-DELISTED | Stock | 28.92 | 30.24 | 28.92 | 29.92 | 46681.0 |
| 2009-09-25 | ACAS-DELISTED | Stock | 3.17 | 3.36 | 3.12 | 3.22 | 4260128.0 |
> showing 50 of 5,823 rows — these rows as CSV