PREVIEW / stock_daily / 2001-10-05
file: by_date/stock_daily/2001/2001-10-05.parquet size: 100 KB rows: 2,974 symbols: 1,848
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-10-05 | AAPL | Stock | 0.275 | 0.2884 | 0.2677 | 0.2882 | 342686400.0 |
| 2001-10-05 | MSFT | Stock | 28.08 | 29.0 | 27.47 | 28.86 | 80844400.0 |
| 2001-10-05 | NVDA | Stock | 0.265 | 0.2807 | 0.2549 | 0.2742 | 1078212000.0 |
| 2001-10-05 | AMZN | Stock | 0.3485 | 0.395 | 0.337 | 0.36 | 118018000.0 |
| 2001-10-05 | CL | Stock | 28.075 | 29.0 | 27.975 | 28.925 | 3236400.0 |
| 2001-10-05 | A | Stock | 15.3791 | 15.4149 | 14.5923 | 15.093 | 2721487.0 |
| 2001-10-05 | AABA-DELISTED | Stock | 5.15000009536743 | 5.30000019073486 | 5.02500009536743 | 5.17500019073486 | 12420400.0 |
| 2001-10-05 | AAI-DELISTED | Stock | 4.44 | 4.45 | 4.1 | 4.17 | 506900.0 |
| 2001-10-05 | AAIC-DELISTED | Stock | 99.0 | 100.0 | 97.0 | 97.0 | 15300.0 |
| 2001-10-05 | AAME | Stock | 1.19 | 1.19 | 1.19 | 1.19 | 700.0 |
| 2001-10-05 | AAON | Stock | 1.7058 | 1.7058 | 1.5759 | 1.5802 | 184528.0 |
| 2001-10-05 | AAXN-DELISTED | Stock | 0.741666674613953 | 0.741666674613953 | 0.704166650772095 | 0.737500011920929 | 103200.0 |
| 2001-10-05 | ABAX-DELISTED | Stock | 4.06 | 4.15 | 4.0 | 4.15 | 17400.0 |
| 2001-10-05 | ABB-DELISTED | Stock | 6.3 | 6.5 | 6.18 | 6.5 | 93900.0 |
| 2001-10-05 | ABC-DELISTED | Stock | 17.26 | 17.41 | 16.9 | 17.37 | 2886000.0 |
| 2001-10-05 | ABCB | Stock | 10.5856 | 10.5856 | 10.5856 | 10.5856 | 1851.0 |
| 2001-10-05 | ABCW-DELISTED | Stock | 16.37 | 16.5 | 16.2 | 16.49 | 14100.0 |
| 2001-10-05 | ABE-DELISTED | Stock | 6.37 | 6.4 | 6.32 | 6.4 | 3400.0 |
| 2001-10-05 | ABFS-DELISTED | Stock | 19.4 | 21.45 | 19.4 | 21.45 | 132000.0 |
| 2001-10-05 | ABK-DELISTED | Stock | 56.45 | 56.5 | 54.43 | 54.99 | 537600.0 |
| 2001-10-05 | ABM | Stock | 12.975 | 13.235 | 12.975 | 13.025 | 295200.0 |
| 2001-10-05 | ABMD-DELISTED | Stock | 18.5 | 19.24 | 17.95 | 18.38 | 68700.0 |
| 2001-10-05 | ABP-DELISTED | Stock | 1.7 | 1.7 | 1.61 | 1.61 | 50900.0 |
| 2001-10-05 | ABT | Stock | 23.1274 | 23.4012 | 23.0645 | 23.3339 | 8477150.0 |
| 2001-10-05 | ABTL-DELISTED | Stock | 4.1 | 4.5 | 4.05 | 4.1 | 5000.0 |
| 2001-10-05 | ABV-DELISTED | Stock | 15.2 | 15.2 | 14.5 | 14.73 | 373000.0 |
| 2001-10-05 | ABX-DELISTED | Stock | 17.0 | 17.34 | 16.97 | 17.22 | 2222300.0 |
| 2001-10-05 | ACAP-DELISTED | Stock | 22.86 | 23.1 | 22.85 | 23.1 | 39800.0 |
| 2001-10-05 | ACAS-DELISTED | Stock | 27.192 | 27.2 | 26.82 | 26.84 | 65900.0 |
| 2001-10-05 | ACAT-DELISTED | Stock | 13.0 | 13.497 | 13.0 | 13.12 | 37600.0 |
| 2001-10-05 | ACCL-DELISTED | Stock | 10.4499998092651 | 10.6440000534058 | 9.81900024414063 | 10.6440000534058 | 266500.0 |
| 2001-10-05 | ACE-DELISTED | Stock | 33.9 | 34.45 | 32.07 | 33.31 | 2445900.0 |
| 2001-10-05 | ACF-DELISTED | Stock | 35.0 | 35.1 | 33.5 | 35.01 | 1142400.0 |
| 2001-10-05 | ACG-DELISTED | Stock | 8.67 | 8.68 | 8.58 | 8.6 | 239900.0 |
| 2001-10-05 | ACGL | Stock | 1.8833 | 1.9167 | 1.8833 | 1.8889 | 22500.0 |
| 2001-10-05 | ACGN-DELISTED | Stock | 1133.3288 | 1133.3288 | 1133.3288 | 1133.3288 | 100.0 |
| 2001-10-05 | ACH | Stock | 12.9667 | 13.1333 | 12.6333 | 12.8667 | 163500.0 |
| 2001-10-05 | ACLS | Stock | 40.4 | 40.8 | 39.16 | 39.56 | 195925.0 |
| 2001-10-05 | ACO-DELISTED | Stock | 5.85 | 6.05 | 5.6 | 5.94 | 38100.0 |
| 2001-10-05 | ACPW-DELISTED | Stock | 26.8 | 28.0 | 24.4 | 27.8 | 40840.0 |
| 2001-10-05 | ACS-DELISTED | Stock | 41.75 | 42.925 | 41.75 | 42.635 | 968900.0 |
| 2001-10-05 | ACTA-DELISTED | Stock | 10.4 | 10.6 | 9.8 | 10.2 | 62200.0 |
| 2001-10-05 | ACTT-DELISTED | Stock | 8.65 | 9.0 | 7.08 | 7.8 | 140300.0 |
| 2001-10-05 | ACTU-DELISTED | Stock | 5.52 | 6.6 | 5.25 | 6.6 | 275900.0 |
| 2001-10-05 | ACXM-DELISTED | Stock | 13.1 | 13.28 | 12.52 | 12.9 | 1354800.0 |
| 2001-10-05 | AD | Stock | 31.6667 | 31.7333 | 31.1333 | 31.4667 | 122700.0 |
| 2001-10-05 | ADAT-DELISTED | Stock | 71.76 | 77.29 | 70.1 | 76.38 | 1604.0 |
| 2001-10-05 | ADBE | Stock | 14.005 | 14.98 | 13.6 | 14.445 | 6360800.0 |
| 2001-10-05 | ADC | Stock | 18.56 | 19.05 | 18.55 | 18.7 | 7300.0 |
| 2001-10-05 | ADEP-DELISTED | Stock | 21.35 | 22.05 | 20.25 | 21.5 | 16000.0 |
> showing 50 of 2,974 rows — these rows as CSV