PREVIEW / stock_daily / 2001-09-17
file: by_date/stock_daily/2001/2001-09-17.parquet size: 100 KB rows: 3,033 symbols: 1,893
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-09-17 | AAPL | Stock | 0.2857 | 0.3048 | 0.2809 | 0.3034 | 458007200.0 |
| 2001-09-17 | MSFT | Stock | 27.01 | 27.55 | 26.4 | 26.455 | 127502000.0 |
| 2001-09-17 | NVDA | Stock | 0.296 | 0.3032 | 0.2818 | 0.2832 | 1138596000.0 |
| 2001-09-17 | AMZN | Stock | 0.365 | 0.4025 | 0.3525 | 0.3745 | 211470000.0 |
| 2001-09-17 | CL | Stock | 28.375 | 28.75 | 27.925 | 28.7 | 5216400.0 |
| 2001-09-17 | A | Stock | 15.1288 | 16.0801 | 15.0215 | 15.5579 | 3550920.0 |
| 2001-09-17 | AABA-DELISTED | Stock | 5.27500009536743 | 5.65999984741211 | 5.125 | 5.44000005722046 | 34958200.0 |
| 2001-09-17 | AAI-DELISTED | Stock | 3.6 | 3.85 | 3.3 | 3.62 | 3497400.0 |
| 2001-09-17 | AAIC-DELISTED | Stock | 115.0 | 118.0 | 110.0 | 113.0 | 44100.0 |
| 2001-09-17 | AAME | Stock | 1.4 | 1.4 | 1.2 | 1.2 | 8800.0 |
| 2001-09-17 | AAON | Stock | 1.7125 | 1.7131 | 1.2057 | 1.6675 | 1424967.0 |
| 2001-09-17 | AAXN-DELISTED | Stock | 0.75 | 0.75 | 0.633333325386047 | 0.699999988079071 | 1316400.0 |
| 2001-09-17 | ABAX-DELISTED | Stock | 4.5 | 4.5 | 3.65 | 4.38 | 15300.0 |
| 2001-09-17 | ABB-DELISTED | Stock | 8.0 | 8.75 | 8.0 | 8.5 | 41400.0 |
| 2001-09-17 | ABC-DELISTED | Stock | 15.56 | 16.22 | 15.56 | 16.0 | 8548800.0 |
| 2001-09-17 | ABCB | Stock | 10.5775 | 10.699 | 10.4559 | 10.5856 | 25539.0 |
| 2001-09-17 | ABCW-DELISTED | Stock | 16.15 | 16.2 | 14.9 | 15.84 | 69700.0 |
| 2001-09-17 | ABE-DELISTED | Stock | 6.6 | 6.65 | 6.3 | 6.32 | 24800.0 |
| 2001-09-17 | ABFS-DELISTED | Stock | 22.125 | 23.31 | 21.31 | 22.95 | 235000.0 |
| 2001-09-17 | ABK-DELISTED | Stock | 54.0 | 55.16 | 53.65 | 54.6 | 856100.0 |
| 2001-09-17 | ABM | Stock | 15.25 | 15.25 | 14.75 | 14.78 | 434800.0 |
| 2001-09-17 | ABMD-DELISTED | Stock | 16.015 | 17.9 | 15.0 | 15.3 | 207300.0 |
| 2001-09-17 | ABP-DELISTED | Stock | 2.55 | 2.8 | 2.11 | 2.21 | 123300.0 |
| 2001-09-17 | ABT | Stock | 21.5472 | 22.9388 | 21.4575 | 22.683 | 15170610.0 |
| 2001-09-17 | ABTL-DELISTED | Stock | 6.1 | 6.2 | 5.0 | 5.95 | 17500.0 |
| 2001-09-17 | ABV-DELISTED | Stock | 16.25 | 17.83 | 16.01 | 17.5 | 251200.0 |
| 2001-09-17 | ABX-DELISTED | Stock | 17.75 | 17.75 | 16.6 | 16.65 | 5298600.0 |
| 2001-09-17 | ACAP-DELISTED | Stock | 21.6 | 21.6 | 20.5 | 20.95 | 88700.0 |
| 2001-09-17 | ACAS-DELISTED | Stock | 27.74 | 27.75 | 26.07 | 26.8 | 207800.0 |
| 2001-09-17 | ACAT-DELISTED | Stock | 15.85 | 15.85 | 14.95 | 14.95 | 8600.0 |
| 2001-09-17 | ACCL-DELISTED | Stock | 10.1300001144409 | 10.2390003204346 | 9.2180004119873 | 9.65999984741211 | 609600.0 |
| 2001-09-17 | ACE-DELISTED | Stock | 26.75 | 29.6 | 26.75 | 28.5 | 8678500.0 |
| 2001-09-17 | ACF-DELISTED | Stock | 30.5 | 35.15 | 30.5 | 35.0 | 3015200.0 |
| 2001-09-17 | ACG-DELISTED | Stock | 8.75 | 8.93 | 8.71 | 8.85 | 275400.0 |
| 2001-09-17 | ACGL | Stock | 1.8711 | 2.1111 | 1.76 | 2.0111 | 119700.0 |
| 2001-09-17 | ACGN-DELISTED | Stock | 952.0 | 1156.0 | 884.0 | 1054.0 | 43800.0 |
| 2001-09-17 | ACH | Stock | 12.14 | 12.8 | 12.14 | 12.76 | 165300.0 |
| 2001-09-17 | ACLS | Stock | 48.96 | 51.6 | 45.36 | 47.88 | 263325.0 |
| 2001-09-17 | ACO-DELISTED | Stock | 5.85 | 6.02 | 5.7 | 6.0 | 19200.0 |
| 2001-09-17 | ACPW-DELISTED | Stock | 24.45 | 28.75 | 23.0 | 25.6 | 119220.0 |
| 2001-09-17 | ACS-DELISTED | Stock | 39.0 | 41.245 | 38.9 | 41.125 | 970500.0 |
| 2001-09-17 | ACTA-DELISTED | Stock | 9.8 | 10.6 | 7.0 | 9.4 | 71000.0 |
| 2001-09-17 | ACTT-DELISTED | Stock | 6.9 | 7.6 | 6.75 | 7.35 | 332400.0 |
| 2001-09-17 | ACTU-DELISTED | Stock | 5.73 | 5.84 | 4.9 | 5.26 | 519400.0 |
| 2001-09-17 | ACXM-DELISTED | Stock | 11.68 | 11.99 | 10.76 | 11.35 | 359300.0 |
| 2001-09-17 | ACY-DELISTED | Stock | 5.4 | 5.4 | 5.3 | 5.4 | 10500.0 |
| 2001-09-17 | AD | Stock | 32.7667 | 32.8333 | 31.8667 | 32.5333 | 179700.0 |
| 2001-09-17 | ADAT-DELISTED | Stock | 57.6 | 67.14 | 46.8 | 59.4 | 4532.0 |
| 2001-09-17 | ADBE | Stock | 15.07 | 16.215 | 14.895 | 15.125 | 9278600.0 |
| 2001-09-17 | ADC | Stock | 18.55 | 18.95 | 18.55 | 18.95 | 5200.0 |
> showing 50 of 3,033 rows — these rows as CSV