PREVIEW / stock_daily / 2001-10-09
file: by_date/stock_daily/2001/2001-10-09.parquet size: 100 KB rows: 2,970 symbols: 1,843
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-09 | AAPL | Stock | 0.2866 | 0.2893 | 0.2791 | 0.2857 | 174025600.0 |
| 2001-10-09 | MSFT | Stock | 28.75 | 28.785 | 27.095 | 27.28 | 99477600.0 |
| 2001-10-09 | NVDA | Stock | 0.2811 | 0.2867 | 0.2602 | 0.2682 | 917556000.0 |
| 2001-10-09 | AMZN | Stock | 0.3555 | 0.356 | 0.3335 | 0.3455 | 55336000.0 |
| 2001-10-09 | CL | Stock | 28.55 | 28.75 | 28.25 | 28.63 | 1924200.0 |
| 2001-10-09 | A | Stock | 15.3219 | 15.3577 | 14.628 | 14.8641 | 1821594.0 |
| 2001-10-09 | AABA-DELISTED | Stock | 5.20499992370605 | 5.30000019073486 | 5.00500011444092 | 5.07999992370605 | 12246400.0 |
| 2001-10-09 | AAI-DELISTED | Stock | 3.9 | 3.94 | 3.64 | 3.75 | 560700.0 |
| 2001-10-09 | AAIC-DELISTED | Stock | 98.0 | 101.0 | 96.2 | 99.4 | 7900.0 |
| 2001-10-09 | AAME | Stock | 1.19 | 1.19 | 1.0 | 1.1 | 3500.0 |
| 2001-10-09 | AAON | Stock | 1.5144 | 1.6953 | 1.4266 | 1.4529 | 744947.0 |
| 2001-10-09 | AAXN-DELISTED | Stock | 0.735833346843719 | 0.949999988079071 | 0.735833346843719 | 0.932500004768372 | 3620400.0 |
| 2001-10-09 | ABAX-DELISTED | Stock | 4.14 | 4.14 | 3.9 | 3.91 | 66500.0 |
| 2001-10-09 | ABB-DELISTED | Stock | 6.55 | 6.69 | 6.5 | 6.65 | 53800.0 |
| 2001-10-09 | ABC-DELISTED | Stock | 17.2 | 17.4 | 17.18 | 17.34 | 2075600.0 |
| 2001-10-09 | ABCB | Stock | 10.5451 | 10.6909 | 10.5451 | 10.6909 | 494.0 |
| 2001-10-09 | ABCW-DELISTED | Stock | 16.03 | 16.39 | 15.51 | 15.55 | 29300.0 |
| 2001-10-09 | ABE-DELISTED | Stock | 6.26 | 6.26 | 6.2 | 6.21 | 7500.0 |
| 2001-10-09 | ABFS-DELISTED | Stock | 20.805 | 20.85 | 19.85 | 19.89 | 273100.0 |
| 2001-10-09 | ABK-DELISTED | Stock | 54.45 | 55.99 | 54.01 | 54.73 | 534600.0 |
| 2001-10-09 | ABM | Stock | 13.035 | 13.425 | 13.035 | 13.25 | 94000.0 |
| 2001-10-09 | ABMD-DELISTED | Stock | 18.99 | 19.37 | 18.52 | 18.52 | 39900.0 |
| 2001-10-09 | ABP-DELISTED | Stock | 1.61 | 1.66 | 1.55 | 1.6 | 55200.0 |
| 2001-10-09 | ABT | Stock | 23.2351 | 23.2396 | 22.6246 | 22.9074 | 6221641.0 |
| 2001-10-09 | ABTL-DELISTED | Stock | 4.05 | 4.2 | 4.0 | 4.1 | 9700.0 |
| 2001-10-09 | ABV-DELISTED | Stock | 14.39 | 14.9 | 14.15 | 14.82 | 370800.0 |
| 2001-10-09 | ABX-DELISTED | Stock | 16.9 | 16.9 | 16.39 | 16.42 | 1893100.0 |
| 2001-10-09 | ACAP-DELISTED | Stock | 23.09 | 23.15 | 22.74 | 22.74 | 102500.0 |
| 2001-10-09 | ACAS-DELISTED | Stock | 26.16 | 26.41 | 25.83 | 26.2499 | 166609.0 |
| 2001-10-09 | ACAT-DELISTED | Stock | 12.5 | 12.8 | 12.25 | 12.26 | 124100.0 |
| 2001-10-09 | ACCL-DELISTED | Stock | 10.289999961853 | 10.456000328064 | 10.1230001449585 | 10.1230001449585 | 30700.0 |
| 2001-10-09 | ACE-DELISTED | Stock | 33.21 | 36.3 | 32.86 | 36.1 | 3332200.0 |
| 2001-10-09 | ACF-DELISTED | Stock | 33.03 | 34.43 | 32.5 | 34.33 | 1630500.0 |
| 2001-10-09 | ACG-DELISTED | Stock | 8.63 | 8.65 | 8.41 | 8.51 | 343800.0 |
| 2001-10-09 | ACGL | Stock | 1.8889 | 1.8889 | 1.8333 | 1.8389 | 43200.0 |
| 2001-10-09 | ACGN-DELISTED | Stock | 906.6712 | 963.3288 | 906.6712 | 963.3288 | 3000.0 |
| 2001-10-09 | ACH | Stock | 12.9333 | 12.9333 | 12.2 | 12.3067 | 151350.0 |
| 2001-10-09 | ACLS | Stock | 42.8 | 44.24 | 41.2 | 42.04 | 193200.0 |
| 2001-10-09 | ACO-DELISTED | Stock | 5.65 | 5.67 | 5.6 | 5.62 | 24200.0 |
| 2001-10-09 | ACPW-DELISTED | Stock | 26.85 | 26.9 | 24.55 | 24.55 | 54540.0 |
| 2001-10-09 | ACS-DELISTED | Stock | 43.25 | 44.5 | 43.25 | 43.7 | 826600.0 |
| 2001-10-09 | ACTA-DELISTED | Stock | 9.8 | 10.4 | 9.4 | 9.6 | 62800.0 |
| 2001-10-09 | ACTT-DELISTED | Stock | 8.17 | 8.88 | 8.0 | 8.5 | 55500.0 |
| 2001-10-09 | ACTU-DELISTED | Stock | 6.35 | 6.5 | 5.77 | 6.07 | 377600.0 |
| 2001-10-09 | ACXM-DELISTED | Stock | 12.72 | 12.76 | 12.01 | 12.24 | 325000.0 |
| 2001-10-09 | AD | Stock | 30.9 | 31.3333 | 30.0667 | 31.3333 | 85050.0 |
| 2001-10-09 | ADAT-DELISTED | Stock | 76.32 | 77.22 | 70.2 | 77.22 | 1302.0 |
| 2001-10-09 | ADBE | Stock | 14.975 | 15.1 | 14.025 | 14.415 | 5030000.0 |
| 2001-10-09 | ADC | Stock | 19.12 | 19.12 | 18.85 | 18.85 | 3000.0 |
| 2001-10-09 | ADEP-DELISTED | Stock | 23.45 | 24.0 | 21.25 | 23.9 | 3800.0 |
> showing 50 of 2,970 rows — these rows as CSV