PREVIEW / stock_daily / 2001-01-05
file: by_date/stock_daily/2001/2001-01-05.parquet size: 91 KB rows: 2,874 symbols: 1,782
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-05 | AAPL | Stock | 0.3025 | 0.3103 | 0.2868 | 0.2924 | 412356000.0 |
| 2001-01-05 | MSFT | Stock | 24.25 | 24.9375 | 23.7812 | 24.5625 | 93414600.0 |
| 2001-01-05 | NVDA | Stock | 0.1802 | 0.181 | 0.151 | 0.1546 | 432768000.0 |
| 2001-01-05 | AMZN | Stock | 0.775 | 0.7938 | 0.6781 | 0.7281 | 175976000.0 |
| 2001-01-05 | CL | Stock | 28.45 | 29.225 | 28.395 | 28.8 | 4510600.0 |
| 2001-01-05 | A | Stock | 40.9514 | 41.6667 | 38.269 | 39.3866 | 3277052.0 |
| 2001-01-05 | AABA-DELISTED | Stock | 14.6875 | 15.6875 | 13.9375 | 14.25 | 26867400.0 |
| 2001-01-05 | AAI-DELISTED | Stock | 7.38 | 7.44 | 7.25 | 7.38 | 259100.0 |
| 2001-01-05 | AAIC-DELISTED | Stock | 127.5 | 127.5 | 122.5 | 122.5 | 57500.0 |
| 2001-01-05 | AAME | Stock | 1.875 | 1.875 | 1.6875 | 1.75 | 42000.0 |
| 2001-01-05 | AAON | Stock | 1.1706 | 1.1779 | 1.1047 | 1.1706 | 242620.0 |
| 2001-01-05 | ABAX-DELISTED | Stock | 5.6875 | 5.875 | 5.5625 | 5.625 | 11500.0 |
| 2001-01-05 | ABC-DELISTED | Stock | 11.625 | 11.6875 | 11.015625 | 11.28125 | 2172400.0 |
| 2001-01-05 | ABCB | Stock | 8.1053 | 8.1053 | 7.5987 | 8.004 | 2468.0 |
| 2001-01-05 | ABCW-DELISTED | Stock | 16.75 | 16.75 | 15.0 | 15.56 | 19170.0 |
| 2001-01-05 | ABE-DELISTED | Stock | 8.625 | 8.6875 | 8.4375 | 8.4375 | 13400.0 |
| 2001-01-05 | ABFS-DELISTED | Stock | 21.0 | 22.0 | 20.9375 | 21.6875 | 830400.0 |
| 2001-01-05 | ABK-DELISTED | Stock | 51.19 | 52.19 | 50.0 | 51.19 | 697900.0 |
| 2001-01-05 | ABM | Stock | 15.375 | 15.4375 | 15.1562 | 15.4375 | 60800.0 |
| 2001-01-05 | ABMD-DELISTED | Stock | 22.625 | 22.625 | 20.0625 | 20.375 | 148700.0 |
| 2001-01-05 | ABP-DELISTED | Stock | 4.0 | 4.25 | 4.0 | 4.19 | 52000.0 |
| 2001-01-05 | ABT | Stock | 19.3869 | 19.6394 | 18.9941 | 19.3027 | 16300258.0 |
| 2001-01-05 | ABTL-DELISTED | Stock | 10.704 | 10.704 | 10.0 | 10.313 | 11700.0 |
| 2001-01-05 | ABV-DELISTED | Stock | 24.1875 | 24.1875 | 23.25 | 23.75 | 309100.0 |
| 2001-01-05 | ABX-DELISTED | Stock | 15.88 | 16.24 | 15.24 | 15.37 | 1678100.0 |
| 2001-01-05 | ACAS-DELISTED | Stock | 23.25 | 23.25 | 21.875 | 21.875 | 421200.0 |
| 2001-01-05 | ACAT-DELISTED | Stock | 12.501 | 12.501 | 12.063 | 12.063 | 7600.0 |
| 2001-01-05 | ACCL-DELISTED | Stock | 18.0499992370605 | 18.1480007171631 | 15.5679998397827 | 15.5679998397827 | 264200.0 |
| 2001-01-05 | ACE-DELISTED | Stock | 37.0 | 38.75 | 36.5 | 37.94 | 2589100.0 |
| 2001-01-05 | ACF-DELISTED | Stock | 29.19 | 29.25 | 27.0 | 27.25 | 964000.0 |
| 2001-01-05 | ACG-DELISTED | Stock | 7.6875 | 7.875 | 7.625 | 7.75 | 320400.0 |
| 2001-01-05 | ACGL | Stock | 1.6181 | 1.625 | 1.6111 | 1.6111 | 54900.0 |
| 2001-01-05 | ACGN-DELISTED | Stock | 510.0 | 657.3288 | 510.0 | 657.3288 | 5100.0 |
| 2001-01-05 | ACH | Stock | 11.2083 | 11.2917 | 11.0 | 11.25 | 265500.0 |
| 2001-01-05 | ACLS | Stock | 38.5 | 39.75 | 34.0 | 35.0 | 918625.0 |
| 2001-01-05 | ACO-DELISTED | Stock | 4.75 | 4.875 | 4.5 | 4.625 | 85500.0 |
| 2001-01-05 | ACPW-DELISTED | Stock | 100.31 | 105.0 | 98.44 | 99.06 | 50560.0 |
| 2001-01-05 | ACS-DELISTED | Stock | 29.3125 | 29.3125 | 27.125 | 27.5625 | 488400.0 |
| 2001-01-05 | ACTA-DELISTED | Stock | 87.5 | 88.75 | 78.75 | 80.62 | 156800.0 |
| 2001-01-05 | ACTT-DELISTED | Stock | 6.875 | 6.875 | 6.75 | 6.75 | 300.0 |
| 2001-01-05 | ACTU-DELISTED | Stock | 17.63 | 17.63 | 14.38 | 15.88 | 574400.0 |
| 2001-01-05 | ACXM-DELISTED | Stock | 38.2826 | 38.6 | 36.6535 | 37.217 | 561837.0 |
| 2001-01-05 | ACY-DELISTED | Stock | 4.5 | 4.5 | 4.5 | 4.5 | 300.0 |
| 2001-01-05 | AD | Stock | 38.4333 | 38.8667 | 37.2533 | 37.9667 | 197550.0 |
| 2001-01-05 | ADAT-DELISTED | Stock | 78.75 | 86.62 | 78.75 | 86.62 | 8100.0 |
| 2001-01-05 | ADBE | Stock | 26.75 | 27.5 | 25.0 | 25.75 | 8422200.0 |
| 2001-01-05 | ADC | Stock | 14.75 | 14.875 | 14.5625 | 14.5625 | 11100.0 |
| 2001-01-05 | ADEP-DELISTED | Stock | 82.5 | 84.06 | 72.81 | 80.62 | 22000.0 |
| 2001-01-05 | ADGF-DELISTED | Stock | 0.44 | 0.47 | 0.41 | 0.44 | 35800.0 |
| 2001-01-05 | ADI | Stock | 52.125 | 52.125 | 46.9375 | 47.625 | 3621200.0 |
> showing 50 of 2,874 rows — these rows as CSV