PREVIEW / stock_daily / 2004-09-24
file: by_date/stock_daily/2004/2004-09-24.parquet size: 128 KB rows: 3,804 symbols: 2,374
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-09-24 | AAPL | Stock | 0.6688 | 0.6786 | 0.6634 | 0.6659 | 369488000.0 |
| 2004-09-24 | MSFT | Stock | 27.39 | 27.46 | 27.19 | 27.29 | 49859800.0 |
| 2004-09-24 | NVDA | Stock | 0.1212 | 0.1214 | 0.1153 | 0.1171 | 476316000.0 |
| 2004-09-24 | AMZN | Stock | 2.0905 | 2.0955 | 2.0425 | 2.047 | 124114000.0 |
| 2004-09-24 | CL | Stock | 22.915 | 22.96 | 22.525 | 22.575 | 14173200.0 |
| 2004-09-24 | A | Stock | 16.166 | 16.2089 | 15.5937 | 15.608 | 2753780.0 |
| 2004-09-24 | AABA-DELISTED | Stock | 33.189998626709 | 33.25 | 32.560001373291 | 32.5800018310547 | 11285600.0 |
| 2004-09-24 | AACC-DELISTED | Stock | 16.71 | 17.05 | 16.51 | 16.99 | 19118.0 |
| 2004-09-24 | AAI-DELISTED | Stock | 10.48 | 10.48 | 10.16 | 10.27 | 1367500.0 |
| 2004-09-24 | AAIC-DELISTED | Stock | 412.2 | 418.0 | 408.2 | 409.2 | 1252200.0 |
| 2004-09-24 | AAME | Stock | 2.91 | 3.12 | 2.91 | 3.06 | 2100.0 |
| 2004-09-24 | AAON | Stock | 2.4033 | 2.4046 | 2.3901 | 2.3941 | 15187.0 |
| 2004-09-24 | AAP | Stock | 23.6 | 23.6067 | 23.32 | 23.5467 | 2160150.0 |
| 2004-09-24 | AAV-DELISTED | Stock | 16.56 | 16.56 | 16.3 | 16.56 | 25800.0 |
| 2004-09-24 | AAXN-DELISTED | Stock | 19.625 | 20.1749992370605 | 19.4249992370605 | 19.6049995422363 | 13320600.0 |
| 2004-09-24 | ABAX-DELISTED | Stock | 14.57 | 14.57 | 13.29 | 13.38 | 352168.0 |
| 2004-09-24 | ABB-DELISTED | Stock | 6.03 | 6.05 | 5.95 | 5.97 | 178500.0 |
| 2004-09-24 | ABC-DELISTED | Stock | 13.67 | 13.76 | 13.67 | 13.72 | 3340400.0 |
| 2004-09-24 | ABCB | Stock | 15.4164 | 15.6028 | 15.3191 | 15.4001 | 1358.0 |
| 2004-09-24 | ABCO-DELISTED | Stock | 16.592 | 16.642 | 16.568 | 16.583 | 110065.0 |
| 2004-09-24 | ABCW-DELISTED | Stock | 25.68 | 25.81 | 25.35 | 25.55 | 25470.0 |
| 2004-09-24 | ABE-DELISTED | Stock | 8.05 | 8.07 | 7.81 | 7.81 | 42500.0 |
| 2004-09-24 | ABFS-DELISTED | Stock | 34.7 | 36.53 | 34.58 | 36.12 | 353765.0 |
| 2004-09-24 | ABG | Stock | 13.25 | 13.29 | 13.13 | 13.19 | 20600.0 |
| 2004-09-24 | ABK-DELISTED | Stock | 77.35 | 77.88 | 77.29 | 77.54 | 499700.0 |
| 2004-09-24 | ABM | Stock | 20.3 | 20.55 | 20.3 | 20.36 | 69200.0 |
| 2004-09-24 | ABMD-DELISTED | Stock | 10.085 | 10.085 | 9.92 | 9.94 | 47801.0 |
| 2004-09-24 | ABP-DELISTED | Stock | 2.07 | 2.3 | 2.01 | 2.15 | 393600.0 |
| 2004-09-24 | ABR | Stock | 20.8 | 20.96 | 20.5 | 20.95 | 8900.0 |
| 2004-09-24 | ABT | Stock | 20.2763 | 20.3723 | 20.2524 | 20.3147 | 5658608.0 |
| 2004-09-24 | ABTL-DELISTED | Stock | 43.55 | 44.7 | 42.5 | 42.55 | 33100.0 |
| 2004-09-24 | ABV-DELISTED | Stock | 21.7 | 22.18 | 21.7 | 22.09 | 201700.0 |
| 2004-09-24 | ABVA-DELISTED | Stock | 14.99 | 14.99 | 14.81 | 14.81 | 525.0 |
| 2004-09-24 | ABX-DELISTED | Stock | 19.86 | 20.19 | 19.85 | 19.92 | 1446300.0 |
| 2004-09-24 | ACAD | Stock | 7.02 | 7.25 | 7.0 | 7.0 | 1900.0 |
| 2004-09-24 | ACAP-DELISTED | Stock | 30.06 | 30.19 | 30.0 | 30.0 | 18469.0 |
| 2004-09-24 | ACAS-DELISTED | Stock | 31.61 | 31.75 | 31.6 | 31.6 | 796558.0 |
| 2004-09-24 | ACAT-DELISTED | Stock | 26.54 | 26.54 | 25.99 | 26.18 | 306540.0 |
| 2004-09-24 | ACC-DELISTED | Stock | 18.74 | 18.93 | 18.6 | 18.74 | 106717.0 |
| 2004-09-24 | ACCL-DELISTED | Stock | 5.84 | 6.05 | 5.769 | 5.85 | 54694.0 |
| 2004-09-24 | ACE-DELISTED | Stock | 39.2 | 39.24 | 38.84 | 39.16 | 431930.0 |
| 2004-09-24 | ACF-DELISTED | Stock | 21.45 | 21.77 | 21.36 | 21.52 | 401300.0 |
| 2004-09-24 | ACG-DELISTED | Stock | 8.13 | 8.16 | 8.12 | 8.16 | 293000.0 |
| 2004-09-24 | ACGL | Stock | 4.2833 | 4.2867 | 4.2433 | 4.2544 | 1136700.0 |
| 2004-09-24 | ACGN-DELISTED | Stock | 736.6712 | 748.0 | 634.6712 | 702.6712 | 116800.0 |
| 2004-09-24 | ACH | Stock | 16.82 | 17.02 | 16.74 | 16.7467 | 66150.0 |
| 2004-09-24 | ACH-DELISTED | Stock | 15.258 | 15.393 | 15.121 | 15.293 | 562945.0 |
| 2004-09-24 | ACLS | Stock | 34.0 | 34.16 | 31.96 | 32.12 | 134400.0 |
| 2004-09-24 | ACO-DELISTED | Stock | 18.17 | 18.46 | 18.09 | 18.35 | 42100.0 |
| 2004-09-24 | ACPW-DELISTED | Stock | 15.55 | 15.55 | 13.8 | 14.1 | 62937.0 |
> showing 50 of 3,804 rows — these rows as CSV