PREVIEW / stock_daily / 2005-11-28
file: by_date/stock_daily/2005/2005-11-28.parquet size: 143 KB rows: 4,292 symbols: 2,712
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-28 | AAPL | Stock | 2.5257 | 2.5382 | 2.4668 | 2.4879 | 1018519600.0 |
| 2005-11-28 | MSFT | Stock | 27.79 | 27.85 | 27.53 | 27.75 | 57517200.0 |
| 2005-11-28 | NVDA | Stock | 0.3181 | 0.3208 | 0.31 | 0.3157 | 424524000.0 |
| 2005-11-28 | AMZN | Stock | 2.4075 | 2.456 | 2.381 | 2.4175 | 213418000.0 |
| 2005-11-28 | CL | Stock | 27.06 | 27.295 | 26.95 | 27.155 | 4280000.0 |
| 2005-11-28 | A | Stock | 25.4649 | 25.5007 | 25.3362 | 25.5007 | 4608507.0 |
| 2005-11-28 | AABA-DELISTED | Stock | 41.6300010681152 | 41.7700004577637 | 40.6599998474121 | 41.1100006103516 | 23190900.0 |
| 2005-11-28 | AACC-DELISTED | Stock | 20.58 | 20.89 | 20.4 | 20.83 | 168448.0 |
| 2005-11-28 | AACQ-DELISTED | Stock | 5.11 | 5.13 | 5.11 | 5.13 | 15500.0 |
| 2005-11-28 | AACQU-DELISTED | Stock | 5.93 | 5.95 | 5.93 | 5.95 | 1000.0 |
| 2005-11-28 | AACQW-DELISTED | Stock | 0.43 | 0.43 | 0.43 | 0.43 | 2000.0 |
| 2005-11-28 | AAI-DELISTED | Stock | 15.98 | 16.04 | 15.14 | 15.18 | 1535100.0 |
| 2005-11-28 | AAIC-DELISTED | Stock | 218.0 | 222.0 | 211.2 | 214.6 | 2077900.0 |
| 2005-11-28 | AAME | Stock | 2.51 | 2.7 | 2.51 | 2.69 | 500.0 |
| 2005-11-28 | AAON | Stock | 2.1939 | 2.2058 | 2.1939 | 2.1965 | 132891.0 |
| 2005-11-28 | AAP | Stock | 43.6 | 43.6 | 42.17 | 42.25 | 621600.0 |
| 2005-11-28 | AATI-DELISTED | Stock | 12.58 | 12.58 | 12.1 | 12.17 | 103975.0 |
| 2005-11-28 | AAV-DELISTED | Stock | 18.09 | 18.35 | 18.0 | 18.09 | 104000.0 |
| 2005-11-28 | AAWW-DELISTED | Stock | 32.9 | 33.0 | 32.9 | 33.0 | 21300.0 |
| 2005-11-28 | AAXN-DELISTED | Stock | 6.25 | 6.38000011444092 | 6.01999998092651 | 6.28000020980835 | 4598700.0 |
| 2005-11-28 | ABAX-DELISTED | Stock | 17.75 | 17.75 | 16.76 | 16.98 | 166230.0 |
| 2005-11-28 | ABB-DELISTED | Stock | 8.77 | 8.78 | 8.63 | 8.66 | 2217300.0 |
| 2005-11-28 | ABBC-DELISTED | Stock | 12.66 | 12.74 | 12.66 | 12.74 | 700.0 |
| 2005-11-28 | ABC-DELISTED | Stock | 19.91 | 19.94 | 19.79 | 19.82 | 2831600.0 |
| 2005-11-28 | ABCB | Stock | 19.7933 | 19.8808 | 18.9762 | 19.1026 | 26629.0 |
| 2005-11-28 | ABCO-DELISTED | Stock | 23.79 | 24.11 | 23.6 | 23.91 | 193659.0 |
| 2005-11-28 | ABCW-DELISTED | Stock | 31.29 | 31.29 | 30.77 | 30.85 | 59830.0 |
| 2005-11-28 | ABD-DELISTED | Stock | 23.95 | 23.95 | 23.2 | 23.45 | 196090.0 |
| 2005-11-28 | ABE-DELISTED | Stock | 11.6 | 11.67 | 11.5 | 11.51 | 13000.0 |
| 2005-11-28 | ABFS-DELISTED | Stock | 41.77 | 42.0 | 40.5 | 40.6 | 500805.0 |
| 2005-11-28 | ABG | Stock | 16.55 | 16.55 | 15.96 | 16.01 | 55600.0 |
| 2005-11-28 | ABK-DELISTED | Stock | 76.55 | 76.59 | 75.83 | 76.18 | 336700.0 |
| 2005-11-28 | ABM | Stock | 21.04 | 21.1 | 20.63 | 20.83 | 119700.0 |
| 2005-11-28 | ABMD-DELISTED | Stock | 8.81 | 8.96 | 8.79 | 8.82 | 43640.0 |
| 2005-11-28 | ABP-DELISTED | Stock | 7.03 | 7.06 | 6.59 | 6.59 | 732700.0 |
| 2005-11-28 | ABR | Stock | 27.5 | 27.5 | 27.16 | 27.2 | 48800.0 |
| 2005-11-28 | ABT | Stock | 18.7122 | 18.7554 | 18.645 | 18.6882 | 13638808.0 |
| 2005-11-28 | ABTL-DELISTED | Stock | 27.35 | 27.35 | 25.95 | 26.1 | 61865.0 |
| 2005-11-28 | ABV-DELISTED | Stock | 39.05 | 39.26 | 38.65 | 38.68 | 585800.0 |
| 2005-11-28 | ABVA-DELISTED | Stock | 16.501 | 16.6 | 16.501 | 16.6 | 1762.0 |
| 2005-11-28 | ABX-DELISTED | Stock | 27.42 | 27.62 | 27.14 | 27.21 | 1909600.0 |
| 2005-11-28 | ACAD | Stock | 9.28 | 9.55 | 9.19 | 9.25 | 15000.0 |
| 2005-11-28 | ACAP-DELISTED | Stock | 44.06 | 45.54 | 44.01 | 44.84 | 68959.0 |
| 2005-11-28 | ACAS-DELISTED | Stock | 38.6 | 38.6 | 38.25 | 38.5 | 738270.0 |
| 2005-11-28 | ACAT-DELISTED | Stock | 20.82 | 21.17 | 20.62 | 21.13 | 80300.0 |
| 2005-11-28 | ACC-DELISTED | Stock | 25.6 | 25.64 | 24.861 | 24.91 | 48000.0 |
| 2005-11-28 | ACCL-DELISTED | Stock | 7.55 | 7.63 | 7.34 | 7.51 | 177633.0 |
| 2005-11-28 | ACCO | Stock | 23.95 | 23.95 | 23.2 | 23.45 | 196100.0 |
| 2005-11-28 | ACE-DELISTED | Stock | 56.21 | 56.34 | 55.27 | 55.42 | 1156908.0 |
| 2005-11-28 | ACF-DELISTED | Stock | 25.14 | 25.25 | 24.45 | 24.69 | 1298400.0 |
> showing 50 of 4,292 rows — these rows as CSV