PREVIEW / stock_daily / 2009-03-24
file: by_date/stock_daily/2009/2009-03-24.parquet size: 174 KB rows: 5,711 symbols: 3,413
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-03-24 | AAPL | Stock | 3.7986 | 3.9086 | 3.7639 | 3.8036 | 640612000.0 |
| 2009-03-24 | MSFT | Stock | 18.04 | 18.21 | 17.84 | 17.93 | 50044100.0 |
| 2009-03-24 | NVDA | Stock | 0.2493 | 0.2515 | 0.2432 | 0.2445 | 1114868000.0 |
| 2009-03-24 | AMZN | Stock | 3.7425 | 3.75 | 3.6155 | 3.6405 | 149158000.0 |
| 2009-03-24 | TLT | Stock | 102.19 | 105.16 | 101.9301 | 104.0 | 5477152.0 |
| 2009-03-24 | ES | Stock | 21.91 | 22.07 | 21.25 | 21.63 | 2008800.0 |
| 2009-03-24 | CL | Stock | 29.39 | 29.775 | 29.225 | 29.235 | 6087800.0 |
| 2009-03-24 | A | Stock | 11.2017 | 11.4878 | 11.1803 | 11.2947 | 3801022.0 |
| 2009-03-24 | AABA-DELISTED | Stock | 13.98 | 14.02 | 13.56 | 13.61 | 17382651.0 |
| 2009-03-24 | AACC-DELISTED | Stock | 5.51 | 6.11 | 5.51 | 5.69 | 68536.0 |
| 2009-03-24 | AACG | Stock | 4.6 | 4.6 | 4.3 | 4.5 | 15100.0 |
| 2009-03-24 | AAI-DELISTED | Stock | 4.06 | 4.2 | 3.95 | 4.03 | 1673709.0 |
| 2009-03-24 | AAIC-DELISTED | Stock | 4.2 | 4.6 | 3.6 | 3.6 | 783266.0 |
| 2009-03-24 | AAME | Stock | 0.67 | 0.9 | 0.6 | 0.89 | 43600.0 |
| 2009-03-24 | AAON | Stock | 3.7274 | 3.7886 | 3.5654 | 3.5674 | 400444.0 |
| 2009-03-24 | AAP | Stock | 40.25 | 40.57 | 39.09 | 39.15 | 2800600.0 |
| 2009-03-24 | AATI-DELISTED | Stock | 3.65 | 3.8 | 3.6 | 3.62 | 167364.0 |
| 2009-03-24 | AAU-DELISTED | Stock | 0.8 | 0.8 | 0.75 | 0.76 | 39451.0 |
| 2009-03-24 | AAUAF-DELISTED | Stock | 0.8 | 0.8 | 0.75 | 0.76 | 40451.0 |
| 2009-03-24 | AAV-DELISTED | Stock | 2.3 | 2.3 | 2.18 | 2.23 | 1751231.0 |
| 2009-03-24 | AAWW-DELISTED | Stock | 19.61 | 19.99 | 18.25 | 18.25 | 258294.0 |
| 2009-03-24 | AAXJ | Stock | 34.95 | 34.95 | 33.52 | 33.54 | 144360.0 |
| 2009-03-24 | AAXN-DELISTED | Stock | 4.74 | 4.81 | 4.52 | 4.73 | 508571.0 |
| 2009-03-24 | AB | Stock | 14.71 | 15.62 | 14.24 | 14.91 | 882400.0 |
| 2009-03-24 | ABAX-DELISTED | Stock | 18.16 | 18.34 | 17.86 | 17.93 | 246071.0 |
| 2009-03-24 | ABB-DELISTED | Stock | 14.04 | 14.42 | 13.97 | 14.05 | 6289134.0 |
| 2009-03-24 | ABBC-DELISTED | Stock | 8.89 | 9.0 | 8.6 | 8.6 | 70297.0 |
| 2009-03-24 | ABBNY-DELISTED | Stock | 14.04 | 14.42 | 13.97 | 14.04 | 6301334.0 |
| 2009-03-24 | ABC-DELISTED | Stock | 15.68 | 16.125 | 15.67 | 16.01 | 4170054.0 |
| 2009-03-24 | ABCB | Stock | 6.361 | 6.4973 | 5.8845 | 5.8845 | 22310.0 |
| 2009-03-24 | ABCO-DELISTED | Stock | 8.17 | 8.385 | 7.96 | 7.96 | 82464.0 |
| 2009-03-24 | ABCW-DELISTED | Stock | 1.05 | 1.08 | 1.0 | 1.03 | 159490.0 |
| 2009-03-24 | ABD-DELISTED | Stock | 1.22 | 1.3 | 1.16 | 1.16 | 219840.0 |
| 2009-03-24 | ABE-DELISTED | Stock | 12.32 | 12.4 | 12.07 | 12.16 | 39473.0 |
| 2009-03-24 | ABEO | Stock | 2250.0 | 2350.0 | 1700.0 | 2312.5 | 34.0 |
| 2009-03-24 | ABFS-DELISTED | Stock | 20.5 | 20.96 | 20.1 | 20.65 | 531869.0 |
| 2009-03-24 | ABG | Stock | 4.64 | 4.65 | 4.13 | 4.14 | 620100.0 |
| 2009-03-24 | ABII-DELISTED | Stock | 44.08 | 46.25 | 43.802 | 44.54 | 20802.0 |
| 2009-03-24 | ABK-DELISTED | Stock | 0.9 | 0.95 | 0.86 | 0.87 | 9560696.0 |
| 2009-03-24 | ABM | Stock | 16.98 | 17.1 | 16.35 | 16.38 | 287400.0 |
| 2009-03-24 | ABMD-DELISTED | Stock | 5.19 | 5.24 | 4.92 | 4.94 | 244871.0 |
| 2009-03-24 | ABR | Stock | 1.2 | 1.2 | 1.1 | 1.11 | 84400.0 |
| 2009-03-24 | ABT | Stock | 23.2031 | 23.4718 | 22.138 | 22.2915 | 32116715.0 |
| 2009-03-24 | ABTL-DELISTED | Stock | 1.3 | 1.45 | 1.2 | 1.45 | 41017.0 |
| 2009-03-24 | ABV-DELISTED | Stock | 48.37 | 48.81 | 47.94 | 48.6 | 915619.0 |
| 2009-03-24 | ABVA-DELISTED | Stock | 1.99 | 1.99 | 1.98 | 1.99 | 1600.0 |
| 2009-03-24 | ABVT-DELISTED | Stock | 45.0 | 47.0 | 45.0 | 47.0 | 32999.0 |
| 2009-03-24 | ABX-DELISTED | Stock | 32.25 | 32.9 | 31.82 | 32.03 | 17936273.0 |
| 2009-03-24 | ACAD | Stock | 0.8 | 1.08 | 0.8 | 0.95 | 86400.0 |
| 2009-03-24 | ACAP-DELISTED | Stock | 43.07 | 44.66 | 42.2 | 42.43 | 58746.0 |
> showing 50 of 5,711 rows — these rows as CSV