PREVIEW / stock_daily / 2001-08-24
file: by_date/stock_daily/2001/2001-08-24.parquet size: 101 KB rows: 2,970 symbols: 1,841
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 |
|---|---|---|---|---|---|---|---|
| 2001-08-24 | AAPL | Stock | 0.3214 | 0.3325 | 0.3152 | 0.3316 | 290332000.0 |
| 2001-08-24 | MSFT | Stock | 29.8 | 31.14 | 29.615 | 31.025 | 63399000.0 |
| 2001-08-24 | NVDA | Stock | 0.3492 | 0.3625 | 0.3471 | 0.3553 | 1110936000.0 |
| 2001-08-24 | AMZN | Stock | 0.492 | 0.515 | 0.486 | 0.5115 | 75598000.0 |
| 2001-08-24 | CL | Stock | 27.985 | 28.03 | 27.765 | 27.93 | 3114600.0 |
| 2001-08-24 | A | Stock | 18.9557 | 20.0644 | 18.8126 | 19.8784 | 1958598.0 |
| 2001-08-24 | AABA-DELISTED | Stock | 6.69000005722046 | 7.13500022888184 | 6.59999990463257 | 7.05499982833862 | 13311000.0 |
| 2001-08-24 | AAI-DELISTED | Stock | 5.98 | 6.04 | 5.92 | 5.97 | 2359500.0 |
| 2001-08-24 | AAIC-DELISTED | Stock | 126.0 | 130.0 | 126.0 | 130.0 | 18100.0 |
| 2001-08-24 | AAME | Stock | 1.45 | 1.54 | 1.45 | 1.5 | 3400.0 |
| 2001-08-24 | AAON | Stock | 1.7997 | 1.8144 | 1.7974 | 1.8114 | 196488.0 |
| 2001-08-24 | AAXN-DELISTED | Stock | 0.656666696071625 | 0.712499976158142 | 0.655833303928375 | 0.712499976158142 | 1924800.0 |
| 2001-08-24 | ABAX-DELISTED | Stock | 5.09 | 5.16 | 5.0 | 5.16 | 11200.0 |
| 2001-08-24 | ABB-DELISTED | Stock | 11.37 | 11.53 | 11.3 | 11.53 | 22000.0 |
| 2001-08-24 | ABC-DELISTED | Stock | 15.3625001907349 | 15.5749998092651 | 15.25 | 15.5474996566772 | 5396800.0 |
| 2001-08-24 | ABCB | Stock | 10.618 | 10.8612 | 10.5775 | 10.699 | 5306.0 |
| 2001-08-24 | ABCW-DELISTED | Stock | 18.39 | 18.39 | 17.84 | 17.94 | 116400.0 |
| 2001-08-24 | ABE-DELISTED | Stock | 7.27 | 7.34 | 7.27 | 7.34 | 36300.0 |
| 2001-08-24 | ABFS-DELISTED | Stock | 26.74 | 27.8 | 26.56 | 27.7 | 104200.0 |
| 2001-08-24 | ABK-DELISTED | Stock | 60.3 | 60.56 | 60.1 | 60.1 | 422200.0 |
| 2001-08-24 | ABM | Stock | 17.9 | 18.05 | 17.815 | 17.95 | 119000.0 |
| 2001-08-24 | ABMD-DELISTED | Stock | 19.02 | 19.65 | 18.92 | 19.6 | 87000.0 |
| 2001-08-24 | ABP-DELISTED | Stock | 3.09 | 3.09 | 2.95 | 2.96 | 58100.0 |
| 2001-08-24 | ABT | Stock | 23.473 | 23.5673 | 23.2531 | 23.5673 | 7560689.0 |
| 2001-08-24 | ABTL-DELISTED | Stock | 4.05 | 4.85 | 3.9 | 4.75 | 23900.0 |
| 2001-08-24 | ABV-DELISTED | Stock | 19.42 | 19.59 | 19.41 | 19.5 | 97300.0 |
| 2001-08-24 | ABX-DELISTED | Stock | 16.55 | 16.89 | 16.5 | 16.84 | 1441600.0 |
| 2001-08-24 | ACAP-DELISTED | Stock | 22.37 | 22.6 | 22.35 | 22.43 | 17500.0 |
| 2001-08-24 | ACAS-DELISTED | Stock | 28.42 | 29.0 | 28.2 | 28.67 | 151600.0 |
| 2001-08-24 | ACAT-DELISTED | Stock | 16.35 | 16.35 | 15.91 | 16.1 | 7000.0 |
| 2001-08-24 | ACCL-DELISTED | Stock | 12.5500001907349 | 12.8459997177124 | 12.4619998931885 | 12.7150001525879 | 812600.0 |
| 2001-08-24 | ACE-DELISTED | Stock | 34.59 | 34.7 | 34.0 | 34.25 | 1220700.0 |
| 2001-08-24 | ACF-DELISTED | Stock | 49.9 | 50.99 | 46.25 | 47.84 | 2083400.0 |
| 2001-08-24 | ACG-DELISTED | Stock | 8.85 | 8.86 | 8.79 | 8.82 | 199900.0 |
| 2001-08-24 | ACGL | Stock | 1.9333 | 1.9433 | 1.9167 | 1.9433 | 23400.0 |
| 2001-08-24 | ACGN-DELISTED | Stock | 1303.3288 | 1371.3288 | 1235.3288 | 1235.3288 | 76500.0 |
| 2001-08-24 | ACH | Stock | 13.1667 | 13.4667 | 13.12 | 13.34 | 190950.0 |
| 2001-08-24 | ACLS | Stock | 56.8 | 59.52 | 56.0 | 59.4 | 131475.0 |
| 2001-08-24 | ACO-DELISTED | Stock | 6.15 | 6.4 | 6.15 | 6.38 | 29000.0 |
| 2001-08-24 | ACPW-DELISTED | Stock | 34.8 | 35.25 | 34.0 | 34.5 | 78420.0 |
| 2001-08-24 | ACS-DELISTED | Stock | 42.65 | 42.725 | 42.355 | 42.625 | 469200.0 |
| 2001-08-24 | ACTA-DELISTED | Stock | 17.0 | 18.2 | 16.2 | 17.6 | 74000.0 |
| 2001-08-24 | ACTT-DELISTED | Stock | 6.11 | 6.29 | 6.1 | 6.29 | 16900.0 |
| 2001-08-24 | ACTU-DELISTED | Stock | 6.75 | 6.75 | 6.33 | 6.62 | 302900.0 |
| 2001-08-24 | ACXM-DELISTED | Stock | 12.79 | 13.45 | 12.68 | 13.12 | 420000.0 |
| 2001-08-24 | ACY-DELISTED | Stock | 5.8 | 5.8 | 5.8 | 5.8 | 1700.0 |
| 2001-08-24 | AD | Stock | 36.0 | 36.0 | 35.66 | 35.7333 | 81450.0 |
| 2001-08-24 | ADAT-DELISTED | Stock | 71.82 | 71.82 | 63.0 | 67.5 | 10237.0 |
| 2001-08-24 | ADBE | Stock | 17.51 | 17.95 | 17.275 | 17.89 | 4831200.0 |
| 2001-08-24 | ADC | Stock | 20.25 | 20.25 | 20.15 | 20.18 | 5300.0 |
> showing 50 of 2,970 rows — these rows as CSV