PREVIEW / stock_daily / 2001-11-05
file: by_date/stock_daily/2001/2001-11-05.parquet size: 102 KB rows: 3,009 symbols: 1,872
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-11-05 | AAPL | Stock | 0.3364 | 0.3438 | 0.3323 | 0.3405 | 235793600.0 |
| 2001-11-05 | MSFT | Stock | 30.93 | 32.015 | 30.875 | 31.635 | 66401600.0 |
| 2001-11-05 | NVDA | Stock | 0.3999 | 0.4108 | 0.392 | 0.3945 | 933456000.0 |
| 2001-11-05 | AMZN | Stock | 0.355 | 0.36 | 0.348 | 0.3495 | 125756000.0 |
| 2001-11-05 | CL | Stock | 29.375 | 29.565 | 29.135 | 29.275 | 2755000.0 |
| 2001-11-05 | A | Stock | 16.774 | 17.7396 | 16.774 | 17.5107 | 2738263.0 |
| 2001-11-05 | AABA-DELISTED | Stock | 5.63000011444092 | 6.0 | 5.59000015258789 | 5.99499988555908 | 15136800.0 |
| 2001-11-05 | AAI-DELISTED | Stock | 3.98 | 4.09 | 3.98 | 4.05 | 271700.0 |
| 2001-11-05 | AAIC-DELISTED | Stock | 99.0 | 101.0 | 99.0 | 100.0 | 8700.0 |
| 2001-11-05 | AAME | Stock | 1.41 | 1.5 | 1.41 | 1.5 | 5900.0 |
| 2001-11-05 | AAON | Stock | 1.4916 | 1.5144 | 1.4889 | 1.5144 | 128714.0 |
| 2001-11-05 | AAXN-DELISTED | Stock | 0.8125 | 0.820833325386047 | 0.8125 | 0.820833325386047 | 50400.0 |
| 2001-11-05 | ABAX-DELISTED | Stock | 3.85 | 4.0 | 3.85 | 4.0 | 8500.0 |
| 2001-11-05 | ABB-DELISTED | Stock | 9.09 | 9.23 | 9.01 | 9.12 | 19500.0 |
| 2001-11-05 | ABC-DELISTED | Stock | 15.6 | 15.82 | 15.56 | 15.72 | 3832000.0 |
| 2001-11-05 | ABCB | Stock | 10.3748 | 10.3748 | 10.3748 | 10.3748 | 247.0 |
| 2001-11-05 | ABCW-DELISTED | Stock | 15.72 | 15.87 | 15.67 | 15.7 | 34700.0 |
| 2001-11-05 | ABE-DELISTED | Stock | 6.57 | 6.8 | 6.57 | 6.79 | 13900.0 |
| 2001-11-05 | ABFS-DELISTED | Stock | 24.46 | 24.7 | 23.86 | 24.43 | 78800.0 |
| 2001-11-05 | ABK-DELISTED | Stock | 50.45 | 52.4 | 50.45 | 52.15 | 780900.0 |
| 2001-11-05 | ABM | Stock | 13.65 | 13.89 | 13.6 | 13.89 | 104800.0 |
| 2001-11-05 | ABMD-DELISTED | Stock | 23.195 | 23.24 | 22.0 | 22.15 | 76000.0 |
| 2001-11-05 | ABP-DELISTED | Stock | 1.55 | 1.62 | 1.54 | 1.62 | 34700.0 |
| 2001-11-05 | ABT | Stock | 24.6626 | 24.6626 | 24.0117 | 24.1509 | 9097777.0 |
| 2001-11-05 | ABTL-DELISTED | Stock | 6.75 | 7.1 | 6.75 | 7.1 | 17500.0 |
| 2001-11-05 | ABV-DELISTED | Stock | 18.0 | 18.6 | 17.54 | 18.2 | 426900.0 |
| 2001-11-05 | ABX-DELISTED | Stock | 15.79 | 15.9 | 15.66 | 15.75 | 1065927.0 |
| 2001-11-05 | ACAP-DELISTED | Stock | 22.6 | 22.6 | 18.65 | 18.74 | 276000.0 |
| 2001-11-05 | ACAS-DELISTED | Stock | 26.26 | 26.63 | 25.6 | 25.99 | 245600.0 |
| 2001-11-05 | ACAT-DELISTED | Stock | 15.915 | 16.0 | 15.53 | 15.8 | 33400.0 |
| 2001-11-05 | ACCL-DELISTED | Stock | 9.99275970458984 | 10.1375999450684 | 9.63070011138916 | 10.1375999450684 | 248900.0 |
| 2001-11-05 | ACE-DELISTED | Stock | 39.95 | 40.03 | 39.08 | 40.01 | 3255600.0 |
| 2001-11-05 | ACF-DELISTED | Stock | 14.98 | 15.9 | 14.35 | 15.04 | 2802800.0 |
| 2001-11-05 | ACG-DELISTED | Stock | 8.73 | 8.84 | 8.71 | 8.81 | 312600.0 |
| 2001-11-05 | ACGL | Stock | 2.6422 | 2.6422 | 2.6222 | 2.6422 | 101700.0 |
| 2001-11-05 | ACGN-DELISTED | Stock | 1099.3288 | 1224.0 | 1099.3288 | 1224.0 | 900.0 |
| 2001-11-05 | ACH | Stock | 12.3333 | 12.6333 | 12.2533 | 12.3 | 318600.0 |
| 2001-11-05 | ACLS | Stock | 56.72 | 59.0 | 56.0 | 56.0 | 199675.0 |
| 2001-11-05 | ACO-DELISTED | Stock | 5.75 | 5.9 | 5.71 | 5.8 | 5800.0 |
| 2001-11-05 | ACPW-DELISTED | Stock | 26.75 | 28.25 | 26.55 | 27.05 | 41380.0 |
| 2001-11-05 | ACS-DELISTED | Stock | 45.96 | 46.925 | 45.875 | 46.65 | 523000.0 |
| 2001-11-05 | ACTA-DELISTED | Stock | 18.8 | 21.4 | 18.0 | 20.2 | 117000.0 |
| 2001-11-05 | ACTT-DELISTED | Stock | 10.5 | 10.85 | 10.24 | 10.85 | 90200.0 |
| 2001-11-05 | ACTU-DELISTED | Stock | 5.0 | 6.2 | 4.95 | 6.1 | 1388700.0 |
| 2001-11-05 | ACXM-DELISTED | Stock | 11.46 | 12.2 | 11.45 | 12.06 | 460100.0 |
| 2001-11-05 | AD | Stock | 29.2 | 30.1333 | 29.2 | 30.0333 | 51750.0 |
| 2001-11-05 | ADAT-DELISTED | Stock | 79.38 | 88.2 | 79.38 | 81.0 | 4693.0 |
| 2001-11-05 | ADBE | Stock | 13.695 | 14.185 | 13.66 | 14.125 | 5651200.0 |
| 2001-11-05 | ADC | Stock | 19.24 | 19.24 | 19.05 | 19.14 | 2400.0 |
| 2001-11-05 | ADEP-DELISTED | Stock | 18.15 | 19.5 | 17.0 | 17.45 | 23600.0 |
> showing 50 of 3,009 rows — these rows as CSV