PREVIEW / stock_daily / 2005-06-30
file: by_date/stock_daily/2005/2005-06-30.parquet size: 138 KB rows: 4,135 symbols: 2,595
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-06-30 | AAPL | Stock | 1.3075 | 1.3271 | 1.2968 | 1.3146 | 418390000.0 |
| 2005-06-30 | MSFT | Stock | 25.06 | 25.14 | 24.82 | 24.84 | 82018200.0 |
| 2005-06-30 | NVDA | Stock | 0.2247 | 0.2268 | 0.2209 | 0.2227 | 593232000.0 |
| 2005-06-30 | AMZN | Stock | 1.6735 | 1.678 | 1.6465 | 1.6545 | 114314000.0 |
| 2005-06-30 | CL | Stock | 25.45 | 25.495 | 24.945 | 24.955 | 5119600.0 |
| 2005-06-30 | A | Stock | 16.5093 | 16.5951 | 16.4163 | 16.4664 | 2410851.0 |
| 2005-06-30 | AABA-DELISTED | Stock | 34.8400001525879 | 35.1699981689453 | 34.439998626709 | 34.6500015258789 | 16699500.0 |
| 2005-06-30 | AACC-DELISTED | Stock | 26.43 | 26.549 | 25.83 | 25.9 | 109491.0 |
| 2005-06-30 | AACQ-DELISTED | Stock | 5.0 | 5.0 | 5.0 | 5.0 | 30000.0 |
| 2005-06-30 | AAI-DELISTED | Stock | 9.58 | 9.61 | 9.21 | 9.24 | 799800.0 |
| 2005-06-30 | AAIC-DELISTED | Stock | 283.6 | 288.2 | 282.6 | 286.0 | 1489700.0 |
| 2005-06-30 | AAON | Stock | 2.3453 | 2.4928 | 2.3243 | 2.3388 | 533841.0 |
| 2005-06-30 | AAP | Stock | 43.5 | 43.5333 | 42.94 | 43.0333 | 647250.0 |
| 2005-06-30 | AAV-DELISTED | Stock | 13.83 | 13.99 | 13.29 | 13.83 | 37300.0 |
| 2005-06-30 | AAXN-DELISTED | Stock | 10.2200002670288 | 10.2799997329712 | 10.0100002288818 | 10.039999961853 | 1845900.0 |
| 2005-06-30 | ABAX-DELISTED | Stock | 11.13 | 11.3 | 10.89 | 10.89 | 69876.0 |
| 2005-06-30 | ABB-DELISTED | Stock | 6.58 | 6.59 | 6.47 | 6.47 | 5403500.0 |
| 2005-06-30 | ABBC-DELISTED | Stock | 12.35 | 12.4 | 12.26 | 12.38 | 4602.0 |
| 2005-06-30 | ABC-DELISTED | Stock | 17.19 | 17.36 | 17.16 | 17.27 | 4162400.0 |
| 2005-06-30 | ABCB | Stock | 17.7507 | 17.8479 | 17.3811 | 17.5854 | 15936.0 |
| 2005-06-30 | ABCO-DELISTED | Stock | 24.75 | 24.95 | 24.36 | 24.39 | 134386.0 |
| 2005-06-30 | ABCW-DELISTED | Stock | 30.45 | 30.69 | 29.75 | 30.26 | 154920.0 |
| 2005-06-30 | ABE-DELISTED | Stock | 10.03 | 10.07 | 9.97 | 9.97 | 22000.0 |
| 2005-06-30 | ABFS-DELISTED | Stock | 32.34 | 32.41 | 31.63 | 31.8 | 310224.0 |
| 2005-06-30 | ABG | Stock | 15.67 | 15.7 | 15.4 | 15.41 | 46600.0 |
| 2005-06-30 | ABK-DELISTED | Stock | 70.4 | 70.77 | 69.8 | 69.8 | 521600.0 |
| 2005-06-30 | ABM | Stock | 19.53 | 19.68 | 19.38 | 19.5 | 157300.0 |
| 2005-06-30 | ABMD-DELISTED | Stock | 8.5 | 8.67 | 8.49 | 8.58 | 66563.0 |
| 2005-06-30 | ABP-DELISTED | Stock | 2.8 | 2.8 | 2.75 | 2.76 | 51200.0 |
| 2005-06-30 | ABR | Stock | 28.75 | 28.81 | 28.57 | 28.7 | 68300.0 |
| 2005-06-30 | ABT | Stock | 23.5102 | 23.587 | 23.467 | 23.515 | 9824927.0 |
| 2005-06-30 | ABTL-DELISTED | Stock | 24.3 | 24.96 | 23.85 | 24.15 | 28063.0 |
| 2005-06-30 | ABV-DELISTED | Stock | 30.86 | 31.2 | 30.64 | 30.9 | 434200.0 |
| 2005-06-30 | ABVA-DELISTED | Stock | 14.67 | 15.32 | 14.41 | 15.25 | 22100.0 |
| 2005-06-30 | ABX-DELISTED | Stock | 25.82 | 25.9 | 24.89 | 25.03 | 2374300.0 |
| 2005-06-30 | ACAD | Stock | 8.85 | 8.86 | 8.37 | 8.4 | 52300.0 |
| 2005-06-30 | ACAP-DELISTED | Stock | 36.83 | 37.24 | 36.83 | 37.09 | 34706.0 |
| 2005-06-30 | ACAS-DELISTED | Stock | 36.0 | 36.45 | 35.99 | 36.13 | 540904.0 |
| 2005-06-30 | ACAT-DELISTED | Stock | 20.72 | 21.09 | 20.49 | 20.51 | 51684.0 |
| 2005-06-30 | ACC-DELISTED | Stock | 22.7 | 22.76 | 22.56 | 22.67 | 220020.0 |
| 2005-06-30 | ACCL-DELISTED | Stock | 5.1 | 5.1 | 4.9 | 4.93 | 86935.0 |
| 2005-06-30 | ACE-DELISTED | Stock | 45.02 | 45.14 | 44.72 | 44.84 | 1114200.0 |
| 2005-06-30 | ACF-DELISTED | Stock | 25.6 | 26.0 | 25.49 | 25.51 | 1622800.0 |
| 2005-06-30 | ACFC-DELISTED | Stock | 64.44 | 64.44 | 63.06 | 63.11 | 958.0 |
| 2005-06-30 | ACG-DELISTED | Stock | 8.29 | 8.31 | 8.28 | 8.31 | 389800.0 |
| 2005-06-30 | ACGL | Stock | 5.0233 | 5.0422 | 5.0 | 5.0056 | 625500.0 |
| 2005-06-30 | ACGN-DELISTED | Stock | 634.6712 | 634.6712 | 600.6712 | 600.6712 | 71800.0 |
| 2005-06-30 | ACH | Stock | 21.6533 | 21.74 | 21.48 | 21.5667 | 170700.0 |
| 2005-06-30 | ACH-DELISTED | Stock | 13.756 | 13.783 | 13.688 | 13.743 | 61600.0 |
| 2005-06-30 | ACLS | Stock | 28.44 | 28.56 | 27.36 | 27.44 | 130750.0 |
> showing 50 of 4,135 rows — these rows as CSV