PREVIEW / stock_daily / 2009-06-24
file: by_date/stock_daily/2009/2009-06-24.parquet size: 181 KB rows: 5,779 symbols: 3,450
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-06-24 | AAPL | Stock | 4.8364 | 4.9107 | 4.8164 | 4.865 | 485525600.0 |
| 2009-06-24 | MSFT | Stock | 23.45 | 23.75 | 23.36 | 23.47 | 54287700.0 |
| 2009-06-24 | NVDA | Stock | 0.2658 | 0.2775 | 0.2658 | 0.2712 | 515096000.0 |
| 2009-06-24 | AMZN | Stock | 3.9 | 4.0265 | 3.89 | 3.9635 | 121628000.0 |
| 2009-06-24 | TLT | Stock | 93.65 | 94.07 | 92.66 | 92.73 | 6556727.0 |
| 2009-06-24 | ES | Stock | 21.7 | 22.06 | 21.6 | 21.75 | 1238900.0 |
| 2009-06-24 | CL | Stock | 35.37 | 35.43 | 34.91 | 35.095 | 5642200.0 |
| 2009-06-24 | A | Stock | 13.3691 | 13.6481 | 13.3405 | 13.598 | 5450802.0 |
| 2009-06-24 | AABA-DELISTED | Stock | 14.76 | 15.6 | 14.76 | 15.44 | 30686589.0 |
| 2009-06-24 | AACC-DELISTED | Stock | 8.37 | 8.55 | 8.17 | 8.46 | 36864.0 |
| 2009-06-24 | AACG | Stock | 9.35 | 10.0 | 9.2 | 9.26 | 51400.0 |
| 2009-06-24 | AAI-DELISTED | Stock | 5.34 | 5.63 | 5.23 | 5.4 | 2107492.0 |
| 2009-06-24 | AAIC-DELISTED | Stock | 8.2 | 9.0 | 7.2 | 7.8 | 443339.0 |
| 2009-06-24 | AAME | Stock | 0.71 | 0.8 | 0.71 | 0.73 | 1500.0 |
| 2009-06-24 | AAON | Stock | 3.7472 | 3.9131 | 3.6938 | 3.8123 | 321975.0 |
| 2009-06-24 | AAP | Stock | 41.94 | 42.01 | 40.73 | 41.01 | 1477500.0 |
| 2009-06-24 | AATI-DELISTED | Stock | 4.4 | 4.6 | 4.385 | 4.52 | 205210.0 |
| 2009-06-24 | AAU-DELISTED | Stock | 0.62 | 0.64 | 0.62 | 0.62 | 144185.0 |
| 2009-06-24 | AAUAF-DELISTED | Stock | 0.62 | 0.64 | 0.62 | 0.6201 | 225478.0 |
| 2009-06-24 | AAV-DELISTED | Stock | 4.28 | 4.53 | 4.25 | 4.41 | 888358.0 |
| 2009-06-24 | AAWW-DELISTED | Stock | 21.63 | 22.2 | 21.08 | 21.34 | 211907.0 |
| 2009-06-24 | AAXJ | Stock | 43.1 | 43.69 | 42.91 | 43.25 | 222306.0 |
| 2009-06-24 | AAXN-DELISTED | Stock | 4.44 | 4.49 | 4.35 | 4.42 | 262776.0 |
| 2009-06-24 | AB | Stock | 19.42 | 20.24 | 19.17 | 19.44 | 300100.0 |
| 2009-06-24 | ABAX-DELISTED | Stock | 19.05 | 19.574 | 19.0 | 19.18 | 172772.0 |
| 2009-06-24 | ABB-DELISTED | Stock | 15.47 | 15.66 | 15.24 | 15.35 | 3482446.0 |
| 2009-06-24 | ABBC-DELISTED | Stock | 8.47 | 8.47 | 8.0 | 8.02 | 97393.0 |
| 2009-06-24 | ABBNY-DELISTED | Stock | 15.47 | 15.66 | 15.24 | 15.35 | 3483981.0 |
| 2009-06-24 | ABC-DELISTED | Stock | 17.86 | 17.86 | 17.38 | 17.52 | 4726330.0 |
| 2009-06-24 | ABCB | Stock | 5.9137 | 6.3027 | 5.7678 | 5.8845 | 11515.0 |
| 2009-06-24 | ABCO-DELISTED | Stock | 12.939 | 12.959 | 12.734 | 12.866 | 234544.0 |
| 2009-06-24 | ABCW-DELISTED | Stock | 1.4049 | 1.4651 | 1.3447 | 1.4451 | 430660.0 |
| 2009-06-24 | ABD-DELISTED | Stock | 2.92 | 3.02 | 2.65 | 2.75 | 451300.0 |
| 2009-06-24 | ABE-DELISTED | Stock | 14.39 | 14.6468 | 14.39 | 14.54 | 7751.0 |
| 2009-06-24 | ABEO | Stock | 2737.5 | 2812.5 | 2575.0 | 2662.5 | 13.0 |
| 2009-06-24 | ABFS-DELISTED | Stock | 27.53 | 28.21 | 26.98 | 27.18 | 369514.0 |
| 2009-06-24 | ABG | Stock | 9.99 | 10.75 | 9.99 | 10.27 | 288400.0 |
| 2009-06-24 | ABII-DELISTED | Stock | 36.77 | 38.44 | 36.39 | 37.41 | 21765.0 |
| 2009-06-24 | ABK-DELISTED | Stock | 1.15 | 1.17 | 0.98 | 1.0 | 14382182.0 |
| 2009-06-24 | ABM | Stock | 17.0 | 17.3 | 16.75 | 17.2 | 210000.0 |
| 2009-06-24 | ABMD-DELISTED | Stock | 8.31 | 8.5 | 8.08 | 8.36 | 443366.0 |
| 2009-06-24 | ABR | Stock | 1.87 | 1.9 | 1.75 | 1.77 | 178500.0 |
| 2009-06-24 | ABT | Stock | 22.6466 | 22.661 | 22.3443 | 22.5458 | 12463943.0 |
| 2009-06-24 | ABTL-DELISTED | Stock | 2.05 | 2.0728 | 1.9439 | 2.05 | 34767.0 |
| 2009-06-24 | ABV-DELISTED | Stock | 64.08 | 64.2 | 63.02 | 63.56 | 626872.0 |
| 2009-06-24 | ABVA-DELISTED | Stock | 2.99 | 2.99 | 2.5686 | 2.6 | 1381.0 |
| 2009-06-24 | ABVT-DELISTED | Stock | 78.15 | 79.96 | 76.4953 | 79.5 | 69535.0 |
| 2009-06-24 | ABX-DELISTED | Stock | 34.07 | 34.15 | 33.205 | 33.64 | 9177280.0 |
| 2009-06-24 | ACAD | Stock | 1.97 | 2.02 | 1.9 | 1.93 | 71900.0 |
| 2009-06-24 | ACAP-DELISTED | Stock | 39.61 | 39.85 | 38.77 | 38.92 | 45099.0 |
> showing 50 of 5,779 rows — these rows as CSV