PREVIEW / stock_daily / 2009-11-03
file: by_date/stock_daily/2009/2009-11-03.parquet size: 186 KB rows: 5,868 symbols: 3,489
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-03 | AAPL | Stock | 6.7089 | 6.7686 | 6.64 | 6.7411 | 522541600.0 |
| 2009-11-03 | MSFT | Stock | 27.64 | 27.74 | 27.43 | 27.53 | 50294800.0 |
| 2009-11-03 | NVDA | Stock | 0.292 | 0.3018 | 0.289 | 0.3002 | 876472000.0 |
| 2009-11-03 | AMZN | Stock | 5.8835 | 5.944 | 5.8315 | 5.9185 | 189570000.0 |
| 2009-11-03 | TLT | Stock | 95.28 | 95.36 | 94.0 | 94.1 | 4471119.0 |
| 2009-11-03 | ES | Stock | 22.44 | 22.76 | 22.31 | 22.73 | 2998300.0 |
| 2009-11-03 | CL | Stock | 39.23 | 39.325 | 38.63 | 38.775 | 6450400.0 |
| 2009-11-03 | A | Stock | 17.897 | 18.0186 | 17.7039 | 17.9041 | 3225885.0 |
| 2009-11-03 | AABA-DELISTED | Stock | 15.71 | 15.785 | 15.63 | 15.71 | 15872203.0 |
| 2009-11-03 | AACC-DELISTED | Stock | 6.9 | 7.01 | 5.85 | 5.96 | 186391.0 |
| 2009-11-03 | AACG | Stock | 5.15 | 5.15 | 5.15 | 5.15 | 1000.0 |
| 2009-11-03 | AAI-DELISTED | Stock | 4.26 | 4.34 | 4.15 | 4.24 | 5933270.0 |
| 2009-11-03 | AAIC-DELISTED | Stock | 11.88 | 12.24 | 11.52 | 12.18 | 27212.0 |
| 2009-11-03 | AAME | Stock | 1.3 | 1.3 | 1.25 | 1.26 | 4000.0 |
| 2009-11-03 | AAON | Stock | 3.6681 | 3.763 | 3.6464 | 3.7551 | 468787.0 |
| 2009-11-03 | AAP | Stock | 36.63 | 38.62 | 36.63 | 38.54 | 3108600.0 |
| 2009-11-03 | AATI-DELISTED | Stock | 3.08 | 3.11 | 3.03 | 3.07 | 456374.0 |
| 2009-11-03 | AAU-DELISTED | Stock | 0.68 | 0.74 | 0.68 | 0.691 | 588066.0 |
| 2009-11-03 | AAUAF-DELISTED | Stock | 0.68 | 0.74 | 0.68 | 0.691 | 584166.0 |
| 2009-11-03 | AAV-DELISTED | Stock | 5.79 | 6.32 | 5.77 | 6.32 | 1252635.0 |
| 2009-11-03 | AAWW-DELISTED | Stock | 25.05 | 25.9 | 24.86 | 25.84 | 514366.0 |
| 2009-11-03 | AAXJ | Stock | 51.22 | 51.69 | 50.96 | 51.69 | 160500.0 |
| 2009-11-03 | AAXN-DELISTED | Stock | 4.05 | 4.1 | 4.01 | 4.08 | 357874.0 |
| 2009-11-03 | AB | Stock | 26.35 | 26.79 | 26.0 | 26.21 | 624900.0 |
| 2009-11-03 | ABAX-DELISTED | Stock | 22.66 | 23.01 | 22.53 | 22.94 | 141108.0 |
| 2009-11-03 | ABB-DELISTED | Stock | 18.36 | 18.8 | 18.36 | 18.78 | 4135714.0 |
| 2009-11-03 | ABBC-DELISTED | Stock | 6.66 | 6.71 | 6.525 | 6.61 | 40851.0 |
| 2009-11-03 | ABBNY-DELISTED | Stock | 18.36 | 18.8 | 18.36 | 18.8 | 4144692.0 |
| 2009-11-03 | ABC-DELISTED | Stock | 23.72 | 24.0 | 22.78 | 23.18 | 5571747.0 |
| 2009-11-03 | ABCB | Stock | 5.8906 | 5.8906 | 5.4299 | 5.8808 | 42648.0 |
| 2009-11-03 | ABCO-DELISTED | Stock | 12.337 | 12.758 | 12.337 | 12.733 | 101318.0 |
| 2009-11-03 | ABCW-DELISTED | Stock | 0.72 | 0.72 | 0.64 | 0.65 | 110580.0 |
| 2009-11-03 | ABD-DELISTED | Stock | 6.11 | 6.48 | 5.74 | 6.31 | 293260.0 |
| 2009-11-03 | ABE-DELISTED | Stock | 15.8 | 16.1564 | 15.78 | 16.07 | 19253.0 |
| 2009-11-03 | ABEO | Stock | 3887.5 | 4050.0 | 3875.0 | 3937.5 | 11.0 |
| 2009-11-03 | ABFS-DELISTED | Stock | 24.29 | 24.84 | 24.07 | 24.55 | 560089.0 |
| 2009-11-03 | ABG | Stock | 10.38 | 11.05 | 10.0 | 10.8 | 418300.0 |
| 2009-11-03 | ABII-DELISTED | Stock | 31.93 | 33.47 | 31.28 | 33.17 | 25250.0 |
| 2009-11-03 | ABK-DELISTED | Stock | 1.03 | 1.13 | 1.02 | 1.11 | 8522397.0 |
| 2009-11-03 | ABM | Stock | 18.41 | 18.79 | 18.31 | 18.77 | 163800.0 |
| 2009-11-03 | ABMD-DELISTED | Stock | 8.81 | 9.13 | 8.61 | 9.12 | 250899.0 |
| 2009-11-03 | ABR | Stock | 1.9 | 2.12 | 1.86 | 2.12 | 72900.0 |
| 2009-11-03 | ABT | Stock | 24.4122 | 24.417 | 24.0236 | 24.1963 | 12898708.0 |
| 2009-11-03 | ABTL-DELISTED | Stock | 3.75 | 3.85 | 3.7 | 3.75 | 5668.0 |
| 2009-11-03 | ABV-DELISTED | Stock | 90.0 | 92.07 | 88.45 | 91.42 | 710250.0 |
| 2009-11-03 | ABVT-DELISTED | Stock | 48.35 | 49.07 | 48.15 | 48.84 | 106156.0 |
| 2009-11-03 | ABX-DELISTED | Stock | 36.2 | 39.25 | 35.94 | 39.19 | 25473002.0 |
| 2009-11-03 | ACAD | Stock | 1.24 | 1.35 | 1.24 | 1.31 | 510900.0 |
| 2009-11-03 | ACAP-DELISTED | Stock | 28.63 | 29.03 | 28.36 | 28.74 | 41565.0 |
| 2009-11-03 | ACAS-DELISTED | Stock | 2.63 | 2.72 | 2.555 | 2.71 | 5913173.0 |
> showing 50 of 5,868 rows — these rows as CSV