PREVIEW / stock_daily / 2009-04-24
file: by_date/stock_daily/2009/2009-04-24.parquet size: 178 KB rows: 5,752 symbols: 3,442
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-24 | AAPL | Stock | 4.4514 | 4.4693 | 4.3918 | 4.425 | 540764000.0 |
| 2009-04-24 | MSFT | Stock | 19.82 | 21.2 | 19.5 | 20.91 | 168478500.0 |
| 2009-04-24 | NVDA | Stock | 0.282 | 0.2878 | 0.2752 | 0.2858 | 759508000.0 |
| 2009-04-24 | AMZN | Stock | 4.1015 | 4.334 | 4.0365 | 4.223 | 469686000.0 |
| 2009-04-24 | TLT | Stock | 100.79 | 100.98 | 100.1 | 100.57 | 2829905.0 |
| 2009-04-24 | ES | Stock | 20.32 | 20.43 | 20.11 | 20.24 | 2606600.0 |
| 2009-04-24 | CL | Stock | 29.645 | 29.785 | 29.205 | 29.58 | 5394600.0 |
| 2009-04-24 | A | Stock | 11.8169 | 12.2103 | 11.5951 | 12.0887 | 3901818.0 |
| 2009-04-24 | AABA-DELISTED | Stock | 14.79 | 14.9425 | 14.36 | 14.73 | 25460536.0 |
| 2009-04-24 | AACC-DELISTED | Stock | 6.16 | 6.54 | 6.1 | 6.34 | 29312.0 |
| 2009-04-24 | AACG | Stock | 4.1 | 4.48 | 3.99 | 4.0 | 34700.0 |
| 2009-04-24 | AAI-DELISTED | Stock | 7.5 | 7.52 | 7.0801 | 7.37 | 5394663.0 |
| 2009-04-24 | AAIC-DELISTED | Stock | 5.0 | 5.6 | 4.8 | 5.6 | 731510.0 |
| 2009-04-24 | AAON | Stock | 3.5556 | 3.6168 | 3.4706 | 3.5477 | 344756.0 |
| 2009-04-24 | AAP | Stock | 44.19 | 44.39 | 42.5 | 42.63 | 1818800.0 |
| 2009-04-24 | AATI-DELISTED | Stock | 5.03 | 5.26 | 4.91 | 5.02 | 825718.0 |
| 2009-04-24 | AAU-DELISTED | Stock | 0.6774 | 0.7023 | 0.66 | 0.6626 | 20431.0 |
| 2009-04-24 | AAUAF-DELISTED | Stock | 0.6751 | 0.7 | 0.66 | 0.6604 | 20497.0 |
| 2009-04-24 | AAV-DELISTED | Stock | 2.89 | 2.96 | 2.86 | 2.93 | 703694.0 |
| 2009-04-24 | AAWW-DELISTED | Stock | 23.87 | 26.11 | 23.63 | 25.63 | 264171.0 |
| 2009-04-24 | AAXJ | Stock | 37.64 | 37.85 | 37.25 | 37.61 | 310427.0 |
| 2009-04-24 | AAXN-DELISTED | Stock | 4.95 | 5.0917 | 4.84 | 5.01 | 780905.0 |
| 2009-04-24 | AB | Stock | 16.11 | 16.62 | 15.88 | 16.29 | 700100.0 |
| 2009-04-24 | ABAX-DELISTED | Stock | 14.53 | 15.03 | 14.25 | 14.79 | 414223.0 |
| 2009-04-24 | ABB-DELISTED | Stock | 14.77 | 15.18 | 14.69 | 15.01 | 4430994.0 |
| 2009-04-24 | ABBC-DELISTED | Stock | 8.83 | 9.0 | 8.79 | 8.89 | 57793.0 |
| 2009-04-24 | ABBNY-DELISTED | Stock | 14.77 | 15.18 | 14.69 | 15.0 | 4501265.0 |
| 2009-04-24 | ABC-DELISTED | Stock | 17.7 | 18.03 | 17.075 | 17.26 | 6730770.0 |
| 2009-04-24 | ABCB | Stock | 6.1666 | 6.4195 | 6.0401 | 6.2832 | 23441.0 |
| 2009-04-24 | ABCO-DELISTED | Stock | 8.31 | 8.43 | 8.085 | 8.15 | 442944.0 |
| 2009-04-24 | ABCW-DELISTED | Stock | 1.75 | 1.85 | 1.65 | 1.68 | 104740.0 |
| 2009-04-24 | ABD-DELISTED | Stock | 2.2405 | 2.3428 | 2.087 | 2.22 | 442550.0 |
| 2009-04-24 | ABE-DELISTED | Stock | 13.12 | 13.45 | 13.12 | 13.42 | 15597.0 |
| 2009-04-24 | ABEO | Stock | 1687.5 | 1725.0 | 1400.0 | 1687.5 | 12.0 |
| 2009-04-24 | ABFS-DELISTED | Stock | 21.32 | 22.33 | 20.88 | 22.03 | 479140.0 |
| 2009-04-24 | ABG | Stock | 8.2 | 8.29 | 7.57 | 7.8 | 564000.0 |
| 2009-04-24 | ABII-DELISTED | Stock | 51.5 | 53.75 | 48.595 | 49.84 | 13560.0 |
| 2009-04-24 | ABK-DELISTED | Stock | 1.0 | 1.02 | 0.95 | 1.0 | 4877704.0 |
| 2009-04-24 | ABM | Stock | 17.06 | 17.72 | 16.9 | 17.45 | 253900.0 |
| 2009-04-24 | ABMD-DELISTED | Stock | 5.97 | 5.97 | 5.66 | 5.91 | 502962.0 |
| 2009-04-24 | ABR | Stock | 1.35 | 1.69 | 1.35 | 1.48 | 372100.0 |
| 2009-04-24 | ABT | Stock | 20.9049 | 21.0632 | 20.5738 | 20.6746 | 19403085.0 |
| 2009-04-24 | ABTL-DELISTED | Stock | 2.1457 | 2.4302 | 1.9909 | 2.35 | 13835.0 |
| 2009-04-24 | ABV-DELISTED | Stock | 54.12 | 54.73 | 53.61 | 53.86 | 771479.0 |
| 2009-04-24 | ABVA-DELISTED | Stock | 2.0 | 2.05 | 2.0 | 2.05 | 740.0 |
| 2009-04-24 | ABVT-DELISTED | Stock | 49.0 | 49.0 | 49.0 | 49.0 | 300.0 |
| 2009-04-24 | ABX-DELISTED | Stock | 30.1 | 30.87 | 29.75 | 30.8 | 10650080.0 |
| 2009-04-24 | ACAD | Stock | 0.97 | 0.99 | 0.93 | 0.95 | 87900.0 |
| 2009-04-24 | ACAP-DELISTED | Stock | 40.5 | 41.6 | 40.5 | 41.08 | 62237.0 |
| 2009-04-24 | ACAS-DELISTED | Stock | 2.79 | 2.83 | 2.64 | 2.78 | 4140766.0 |
> showing 50 of 5,752 rows — these rows as CSV