PREVIEW / stock_daily / 2009-04-16
file: by_date/stock_daily/2009/2009-04-16.parquet size: 177 KB rows: 5,758 symbols: 3,445
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-04-16 | AAPL | Stock | 4.2568 | 4.3982 | 4.2425 | 4.3375 | 593446000.0 |
| 2009-04-16 | MSFT | Stock | 19.16 | 19.78 | 18.99 | 19.76 | 67688700.0 |
| 2009-04-16 | NVDA | Stock | 0.29 | 0.2955 | 0.279 | 0.292 | 1038772000.0 |
| 2009-04-16 | AMZN | Stock | 3.7665 | 3.874 | 3.758 | 3.8625 | 149356000.0 |
| 2009-04-16 | TLT | Stock | 102.85 | 103.45 | 102.78 | 102.83 | 1055573.0 |
| 2009-04-16 | ES | Stock | 21.2 | 21.4 | 21.01 | 21.31 | 1364800.0 |
| 2009-04-16 | CL | Stock | 29.195 | 29.76 | 29.08 | 29.61 | 8947600.0 |
| 2009-04-16 | A | Stock | 11.8169 | 12.1531 | 11.5236 | 12.0315 | 8019208.0 |
| 2009-04-16 | AABA-DELISTED | Stock | 14.15 | 14.53 | 14.05 | 14.43 | 18998105.0 |
| 2009-04-16 | AACC-DELISTED | Stock | 6.42 | 6.66 | 6.31 | 6.61 | 26677.0 |
| 2009-04-16 | AACG | Stock | 4.11 | 4.3 | 4.0 | 4.3 | 4900.0 |
| 2009-04-16 | AAI-DELISTED | Stock | 5.35 | 5.49 | 5.05 | 5.4 | 1976684.0 |
| 2009-04-16 | AAIC-DELISTED | Stock | 6.0 | 6.6 | 6.0 | 6.4 | 543579.0 |
| 2009-04-16 | AAME | Stock | 0.6 | 0.6 | 0.6 | 0.6 | 800.0 |
| 2009-04-16 | AAON | Stock | 3.3284 | 3.439 | 3.281 | 3.4094 | 408544.0 |
| 2009-04-16 | AAP | Stock | 42.52 | 43.83 | 41.97 | 43.54 | 1884700.0 |
| 2009-04-16 | AATI-DELISTED | Stock | 4.64 | 4.8 | 4.61 | 4.74 | 645911.0 |
| 2009-04-16 | AAU-DELISTED | Stock | 0.64 | 0.65 | 0.6 | 0.62 | 118847.0 |
| 2009-04-16 | AAUAF-DELISTED | Stock | 0.64 | 0.65 | 0.6 | 0.62 | 119047.0 |
| 2009-04-16 | AAV-DELISTED | Stock | 3.07 | 3.3 | 2.96 | 3.1726 | 1206574.0 |
| 2009-04-16 | AAWW-DELISTED | Stock | 22.33 | 24.3507 | 21.92 | 23.99 | 185237.0 |
| 2009-04-16 | AAXJ | Stock | 37.91 | 38.15 | 37.17 | 37.7794 | 212238.0 |
| 2009-04-16 | AAXN-DELISTED | Stock | 4.93 | 5.15 | 4.89 | 5.08 | 514133.0 |
| 2009-04-16 | AB | Stock | 19.17 | 19.4 | 18.62 | 18.91 | 570900.0 |
| 2009-04-16 | ABAX-DELISTED | Stock | 15.01 | 15.55 | 14.599 | 15.24 | 517769.0 |
| 2009-04-16 | ABB-DELISTED | Stock | 15.23 | 15.39 | 14.93 | 15.29 | 4287848.0 |
| 2009-04-16 | ABBC-DELISTED | Stock | 9.0 | 9.05 | 8.77 | 9.03 | 132888.0 |
| 2009-04-16 | ABBNY-DELISTED | Stock | 15.23 | 15.39 | 14.93 | 15.28 | 4307248.0 |
| 2009-04-16 | ABC-DELISTED | Stock | 16.43 | 16.99 | 16.37 | 16.94 | 3872768.0 |
| 2009-04-16 | ABCB | Stock | 7.4991 | 7.8589 | 7.0906 | 7.7617 | 15525.0 |
| 2009-04-16 | ABCO-DELISTED | Stock | 9.2 | 9.265 | 8.97 | 9.145 | 96366.0 |
| 2009-04-16 | ABCW-DELISTED | Stock | 1.59 | 1.59 | 1.47 | 1.5 | 85670.0 |
| 2009-04-16 | ABD-DELISTED | Stock | 1.2148 | 1.3165 | 1.2048 | 1.3052 | 185840.0 |
| 2009-04-16 | ABE-DELISTED | Stock | 13.05 | 13.5342 | 13.0 | 13.36 | 7634.0 |
| 2009-04-16 | ABEO | Stock | 1775.0 | 2012.5 | 1775.0 | 1987.5 | 6.0 |
| 2009-04-16 | ABFS-DELISTED | Stock | 23.34 | 24.6 | 22.47 | 24.39 | 771550.0 |
| 2009-04-16 | ABG | Stock | 5.92 | 7.07 | 5.92 | 6.72 | 1143900.0 |
| 2009-04-16 | ABII-DELISTED | Stock | 44.32 | 47.31 | 44.32 | 46.11 | 22597.0 |
| 2009-04-16 | ABK-DELISTED | Stock | 1.11 | 1.13 | 1.04 | 1.1 | 9332878.0 |
| 2009-04-16 | ABM | Stock | 17.43 | 17.74 | 17.15 | 17.59 | 250600.0 |
| 2009-04-16 | ABMD-DELISTED | Stock | 5.67 | 6.13 | 5.4901 | 6.07 | 529749.0 |
| 2009-04-16 | ABR | Stock | 1.26 | 1.27 | 1.1 | 1.19 | 208500.0 |
| 2009-04-16 | ABT | Stock | 20.6314 | 20.6794 | 20.2763 | 20.4827 | 30307003.0 |
| 2009-04-16 | ABTL-DELISTED | Stock | 1.55 | 1.55 | 1.35 | 1.35 | 15100.0 |
| 2009-04-16 | ABV-DELISTED | Stock | 52.88 | 53.22 | 52.06 | 52.91 | 513662.0 |
| 2009-04-16 | ABVA-DELISTED | Stock | 1.95 | 1.95 | 1.95 | 1.95 | 581.0 |
| 2009-04-16 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 49.0 | 49.0 | 9200.0 |
| 2009-04-16 | ABX-DELISTED | Stock | 29.75 | 29.75 | 27.84 | 28.2 | 13640469.0 |
| 2009-04-16 | ACAD | Stock | 1.12 | 1.13 | 1.01 | 1.05 | 78400.0 |
| 2009-04-16 | ACAP-DELISTED | Stock | 42.53 | 42.72 | 41.24 | 42.06 | 37936.0 |
> showing 50 of 5,758 rows — these rows as CSV