PREVIEW / stock_daily / 2001-01-19
file: by_date/stock_daily/2001/2001-01-19.parquet size: 91 KB rows: 2,892 symbols: 1,789
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-01-19 | AAPL | Stock | 0.3471 | 0.3493 | 0.3337 | 0.3482 | 776664000.0 |
| 2001-01-19 | MSFT | Stock | 30.0 | 30.7188 | 29.4375 | 30.5 | 209348800.0 |
| 2001-01-19 | NVDA | Stock | 0.2292 | 0.2375 | 0.2135 | 0.2169 | 1018704000.0 |
| 2001-01-19 | AMZN | Stock | 1.0188 | 1.0188 | 0.9344 | 0.9969 | 123550000.0 |
| 2001-01-19 | CL | Stock | 28.44 | 28.7 | 27.75 | 28.325 | 2802600.0 |
| 2001-01-19 | A | Stock | 48.2833 | 48.2833 | 46.182 | 46.8974 | 6185171.0 |
| 2001-01-19 | AABA-DELISTED | Stock | 18.0 | 18.03125 | 16.28125 | 16.90625 | 40979800.0 |
| 2001-01-19 | AAI-DELISTED | Stock | 7.13 | 7.31 | 7.0 | 7.0 | 264400.0 |
| 2001-01-19 | AAIC-DELISTED | Stock | 151.25 | 151.25 | 146.25 | 146.25 | 21300.0 |
| 2001-01-19 | AAME | Stock | 1.9375 | 1.9375 | 1.875 | 1.875 | 3200.0 |
| 2001-01-19 | AAON | Stock | 1.251 | 1.3022 | 1.251 | 1.3022 | 350262.0 |
| 2001-01-19 | ABAX-DELISTED | Stock | 5.90625 | 5.9375 | 5.875 | 5.875 | 12300.0 |
| 2001-01-19 | ABC-DELISTED | Stock | 11.171875 | 11.171875 | 10.03125 | 10.515625 | 6192800.0 |
| 2001-01-19 | ABCB | Stock | 8.1053 | 8.1053 | 7.3962 | 7.7001 | 12214.0 |
| 2001-01-19 | ABCW-DELISTED | Stock | 14.63 | 14.811 | 14.499 | 14.5 | 12900.0 |
| 2001-01-19 | ABE-DELISTED | Stock | 9.25 | 9.375 | 9.125 | 9.3125 | 32700.0 |
| 2001-01-19 | ABFS-DELISTED | Stock | 24.34375 | 24.375 | 21.125 | 22.0625 | 766100.0 |
| 2001-01-19 | ABK-DELISTED | Stock | 47.06 | 47.75 | 46.25 | 47.13 | 936000.0 |
| 2001-01-19 | ABM | Stock | 15.6875 | 15.875 | 15.6875 | 15.8438 | 46200.0 |
| 2001-01-19 | ABMD-DELISTED | Stock | 22.03125 | 22.4375 | 20.9375 | 20.9375 | 93500.0 |
| 2001-01-19 | ABP-DELISTED | Stock | 4.0 | 4.13 | 3.81 | 3.81 | 165700.0 |
| 2001-01-19 | ABT | Stock | 19.9761 | 20.2005 | 19.7516 | 19.7797 | 7406312.0 |
| 2001-01-19 | ABTL-DELISTED | Stock | 12.188 | 12.188 | 10.625 | 11.875 | 14900.0 |
| 2001-01-19 | ABV-DELISTED | Stock | 25.75 | 26.3125 | 25.75 | 26.3125 | 144300.0 |
| 2001-01-19 | ABX-DELISTED | Stock | 15.08 | 15.24 | 15.01 | 15.09 | 1261100.0 |
| 2001-01-19 | ACAS-DELISTED | Stock | 25.031 | 25.06258 | 24.28 | 24.9687 | 83708.0 |
| 2001-01-19 | ACAT-DELISTED | Stock | 13.0625 | 13.0625 | 12.75 | 12.875 | 17900.0 |
| 2001-01-19 | ACCL-DELISTED | Stock | 19.5499992370605 | 19.9130001068115 | 18.7360000610352 | 19.4610004425049 | 97600.0 |
| 2001-01-19 | ACE-DELISTED | Stock | 36.69 | 36.69 | 35.5 | 35.56 | 976000.0 |
| 2001-01-19 | ACF-DELISTED | Stock | 32.19 | 33.25 | 32.19 | 32.94 | 554800.0 |
| 2001-01-19 | ACG-DELISTED | Stock | 7.9375 | 7.9375 | 7.875 | 7.9375 | 300100.0 |
| 2001-01-19 | ACGL | Stock | 1.6875 | 1.7292 | 1.6528 | 1.6528 | 396900.0 |
| 2001-01-19 | ACGN-DELISTED | Stock | 657.3288 | 657.3288 | 521.3288 | 646.0 | 8200.0 |
| 2001-01-19 | ACH | Stock | 10.9167 | 11.0 | 10.5 | 10.5 | 222450.0 |
| 2001-01-19 | ACLS | Stock | 52.25 | 52.25 | 44.0 | 46.5 | 844800.0 |
| 2001-01-19 | ACO-DELISTED | Stock | 4.0625 | 4.4375 | 4.0625 | 4.25 | 31300.0 |
| 2001-01-19 | ACPW-DELISTED | Stock | 140.0 | 157.5 | 137.81 | 145.31 | 198620.0 |
| 2001-01-19 | ACS-DELISTED | Stock | 28.3438 | 29.9063 | 28.1875 | 29.1875 | 696200.0 |
| 2001-01-19 | ACTA-DELISTED | Stock | 106.25 | 106.25 | 90.62 | 95.62 | 207800.0 |
| 2001-01-19 | ACTT-DELISTED | Stock | 7.875 | 7.875 | 7.8125 | 7.8125 | 1500.0 |
| 2001-01-19 | ACTU-DELISTED | Stock | 21.38 | 21.63 | 19.63 | 20.44 | 559200.0 |
| 2001-01-19 | ACXM-DELISTED | Stock | 31.5 | 31.75 | 30.0 | 31.56 | 703499.0 |
| 2001-01-19 | ACY-DELISTED | Stock | 5.12 | 5.12 | 5.0 | 5.06 | 3300.0 |
| 2001-01-19 | AD | Stock | 40.0 | 40.44 | 39.48 | 39.7333 | 190650.0 |
| 2001-01-19 | ADAT-DELISTED | Stock | 83.25 | 88.31 | 79.88 | 82.69 | 11700.0 |
| 2001-01-19 | ADBE | Stock | 29.4062 | 30.0 | 28.6562 | 29.125 | 10374400.0 |
| 2001-01-19 | ADC | Stock | 14.9375 | 15.125 | 14.9375 | 14.9375 | 3900.0 |
| 2001-01-19 | ADEP-DELISTED | Stock | 117.5 | 134.38 | 116.88 | 133.12 | 64800.0 |
| 2001-01-19 | ADGF-DELISTED | Stock | 1.5 | 1.5 | 1.19 | 1.25 | 154400.0 |
| 2001-01-19 | ADI | Stock | 58.3125 | 58.375 | 55.5625 | 57.3125 | 5100600.0 |
> showing 50 of 2,892 rows — these rows as CSV