PREVIEW / stock_daily / 2004-11-24
file: by_date/stock_daily/2004/2004-11-24.parquet size: 131 KB rows: 3,911 symbols: 2,449
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 |
|---|---|---|---|---|---|---|---|
| 2004-11-24 | AAPL | Stock | 1.1016 | 1.1643 | 1.0991 | 1.1438 | 1390788000.0 |
| 2004-11-24 | MSFT | Stock | 26.62 | 26.73 | 26.4 | 26.64 | 60069200.0 |
| 2004-11-24 | NVDA | Stock | 0.163 | 0.1665 | 0.1626 | 0.1638 | 428580000.0 |
| 2004-11-24 | AMZN | Stock | 1.9435 | 1.958 | 1.905 | 1.9375 | 118818000.0 |
| 2004-11-24 | CL | Stock | 22.95 | 23.08 | 22.8 | 22.895 | 4517000.0 |
| 2004-11-24 | A | Stock | 16.2876 | 16.6309 | 16.2589 | 16.5808 | 2250640.0 |
| 2004-11-24 | AABA-DELISTED | Stock | 37.1500015258789 | 37.6399993896484 | 36.6599998474121 | 37.6100006103516 | 16495200.0 |
| 2004-11-24 | AACC-DELISTED | Stock | 19.28 | 19.49 | 18.81 | 19.45 | 67991.0 |
| 2004-11-24 | AAI-DELISTED | Stock | 12.01 | 12.35 | 12.01 | 12.18 | 915500.0 |
| 2004-11-24 | AAIC-DELISTED | Stock | 368.2 | 376.4 | 368.0 | 369.2 | 1914000.0 |
| 2004-11-24 | AAME | Stock | 3.1 | 3.1 | 3.09 | 3.09 | 1800.0 |
| 2004-11-24 | AAON | Stock | 2.1109 | 2.1347 | 2.0833 | 2.1083 | 40247.0 |
| 2004-11-24 | AAP | Stock | 28.1133 | 28.2533 | 28.1 | 28.16 | 930300.0 |
| 2004-11-24 | AAV-DELISTED | Stock | 18.63 | 18.63 | 18.37 | 18.63 | 97700.0 |
| 2004-11-24 | AAXN-DELISTED | Stock | 26.0 | 26.2700004577637 | 25.0149993896484 | 25.2549991607666 | 8712800.0 |
| 2004-11-24 | ABAX-DELISTED | Stock | 12.22 | 12.4 | 12.22 | 12.26 | 59583.0 |
| 2004-11-24 | ABB-DELISTED | Stock | 6.08 | 6.15 | 6.06 | 6.1 | 209100.0 |
| 2004-11-24 | ABC-DELISTED | Stock | 14.55 | 14.56 | 14.35 | 14.46 | 2167600.0 |
| 2004-11-24 | ABCB | Stock | 16.8996 | 16.9645 | 16.7943 | 16.8348 | 14434.0 |
| 2004-11-24 | ABCO-DELISTED | Stock | 17.328 | 17.657 | 17.258 | 17.442 | 178958.0 |
| 2004-11-24 | ABCW-DELISTED | Stock | 29.17 | 29.25 | 28.81 | 28.89 | 33960.0 |
| 2004-11-24 | ABE-DELISTED | Stock | 8.9 | 9.0 | 8.9 | 8.94 | 97200.0 |
| 2004-11-24 | ABFS-DELISTED | Stock | 41.46 | 42.0 | 41.041 | 41.86 | 104123.0 |
| 2004-11-24 | ABG | Stock | 13.75 | 13.93 | 13.69 | 13.93 | 15900.0 |
| 2004-11-24 | ABK-DELISTED | Stock | 80.52 | 81.44 | 80.52 | 81.24 | 280700.0 |
| 2004-11-24 | ABM | Stock | 21.5 | 21.85 | 21.44 | 21.77 | 108300.0 |
| 2004-11-24 | ABMD-DELISTED | Stock | 15.1 | 15.34 | 14.52 | 15.18 | 76386.0 |
| 2004-11-24 | ABP-DELISTED | Stock | 2.6 | 2.61 | 2.53 | 2.56 | 156400.0 |
| 2004-11-24 | ABR | Stock | 22.75 | 23.1 | 22.75 | 22.99 | 35200.0 |
| 2004-11-24 | ABT | Stock | 20.3195 | 20.4731 | 20.166 | 20.3387 | 6435390.0 |
| 2004-11-24 | ABTL-DELISTED | Stock | 34.5 | 35.55 | 34.15 | 35.4 | 63800.0 |
| 2004-11-24 | ABV-DELISTED | Stock | 24.79 | 25.14 | 24.79 | 25.0 | 243200.0 |
| 2004-11-24 | ABVA-DELISTED | Stock | 14.75 | 14.98 | 14.7 | 14.78 | 5250.0 |
| 2004-11-24 | ABVT-DELISTED | Stock | 27.5 | 29.0 | 27.5 | 29.0 | 6800.0 |
| 2004-11-24 | ABX-DELISTED | Stock | 24.94 | 25.28 | 24.58 | 24.59 | 2348459.0 |
| 2004-11-24 | ACAD | Stock | 6.71 | 6.9 | 6.68 | 6.68 | 8100.0 |
| 2004-11-24 | ACAP-DELISTED | Stock | 31.98 | 32.24 | 31.91 | 31.91 | 58482.0 |
| 2004-11-24 | ACAS-DELISTED | Stock | 31.49 | 31.6 | 31.353 | 31.56 | 670783.0 |
| 2004-11-24 | ACAT-DELISTED | Stock | 25.69 | 26.38 | 25.69 | 26.05 | 52453.0 |
| 2004-11-24 | ACC-DELISTED | Stock | 20.61 | 20.8 | 20.54 | 20.69 | 26845.0 |
| 2004-11-24 | ACCL-DELISTED | Stock | 6.33 | 6.47 | 6.15 | 6.16 | 68445.0 |
| 2004-11-24 | ACE-DELISTED | Stock | 39.9 | 40.27 | 39.78 | 40.17 | 886700.0 |
| 2004-11-24 | ACF-DELISTED | Stock | 20.35 | 20.62 | 20.3 | 20.56 | 384600.0 |
| 2004-11-24 | ACFC-DELISTED | Stock | 70.82 | 73.21 | 70.36 | 71.94 | 7117.0 |
| 2004-11-24 | ACG-DELISTED | Stock | 8.16 | 8.18 | 8.15 | 8.18 | 333500.0 |
| 2004-11-24 | ACGL | Stock | 4.3433 | 4.36 | 4.3311 | 4.3344 | 617400.0 |
| 2004-11-24 | ACGN-DELISTED | Stock | 544.0 | 555.3288 | 521.3288 | 532.6712 | 42200.0 |
| 2004-11-24 | ACH | Stock | 18.6733 | 18.98 | 18.4333 | 18.74 | 199950.0 |
| 2004-11-24 | ACH-DELISTED | Stock | 15.753 | 15.815 | 15.698 | 15.787 | 132812.0 |
| 2004-11-24 | ACLS | Stock | 28.36 | 29.32 | 28.0 | 28.8 | 298375.0 |
> showing 50 of 3,911 rows — these rows as CSV