PREVIEW / stock_daily / 2001-12-14
file: by_date/stock_daily/2001/2001-12-14.parquet size: 104 KB rows: 3,043 symbols: 1,897
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-12-14 | AAPL | Stock | 0.3702 | 0.372 | 0.3588 | 0.3641 | 189884800.0 |
| 2001-12-14 | MSFT | Stock | 33.01 | 33.975 | 32.965 | 33.72 | 43000600.0 |
| 2001-12-14 | NVDA | Stock | 0.5233 | 0.5496 | 0.5209 | 0.547 | 754680000.0 |
| 2001-12-14 | AMZN | Stock | 0.555 | 0.56 | 0.5035 | 0.55 | 200492000.0 |
| 2001-12-14 | CL | Stock | 28.55 | 28.55 | 27.935 | 28.275 | 2470600.0 |
| 2001-12-14 | A | Stock | 20.0644 | 20.7368 | 20.0358 | 20.6223 | 3045263.0 |
| 2001-12-14 | AABA-DELISTED | Stock | 9.02000045776367 | 9.02000045776367 | 8.27000045776367 | 8.60499954223633 | 20105600.0 |
| 2001-12-14 | AAI-DELISTED | Stock | 6.61 | 6.8 | 6.57 | 6.57 | 126100.0 |
| 2001-12-14 | AAIC-DELISTED | Stock | 104.0 | 108.0 | 104.0 | 108.0 | 30900.0 |
| 2001-12-14 | AAME | Stock | 2.1 | 2.1 | 1.81 | 1.9 | 12400.0 |
| 2001-12-14 | AAON | Stock | 1.8313 | 1.8392 | 1.7953 | 1.7997 | 307547.0 |
| 2001-12-14 | AAP | Stock | 13.95 | 13.95 | 13.5167 | 13.63 | 233400.0 |
| 2001-12-14 | AAXN-DELISTED | Stock | 1.02166664600372 | 1.05833327770233 | 1.00999999046326 | 1.03250002861023 | 734400.0 |
| 2001-12-14 | ABAX-DELISTED | Stock | 4.6999 | 5.49 | 4.6999 | 5.25 | 59300.0 |
| 2001-12-14 | ABB-DELISTED | Stock | 10.5 | 10.5 | 10.15 | 10.2 | 21900.0 |
| 2001-12-14 | ABC-DELISTED | Stock | 14.59 | 14.95 | 14.4 | 14.86 | 4219200.0 |
| 2001-12-14 | ABCB | Stock | 10.6261 | 10.6261 | 10.537 | 10.537 | 2221.0 |
| 2001-12-14 | ABCO-DELISTED | Stock | 13.73 | 14.055 | 13.65 | 13.65 | 100600.0 |
| 2001-12-14 | ABCW-DELISTED | Stock | 17.61 | 18.06 | 17.6 | 17.9 | 21400.0 |
| 2001-12-14 | ABE-DELISTED | Stock | 7.16 | 7.17 | 6.95 | 7.01 | 64400.0 |
| 2001-12-14 | ABFS-DELISTED | Stock | 25.0 | 25.52 | 24.75 | 25.42 | 133600.0 |
| 2001-12-14 | ABK-DELISTED | Stock | 54.22 | 55.2 | 53.78 | 54.99 | 596100.0 |
| 2001-12-14 | ABM | Stock | 15.36 | 15.49 | 15.18 | 15.375 | 69800.0 |
| 2001-12-14 | ABMD-DELISTED | Stock | 17.25 | 17.36 | 16.25 | 16.75 | 148700.0 |
| 2001-12-14 | ABP-DELISTED | Stock | 1.03 | 1.09 | 0.97 | 0.99 | 273700.0 |
| 2001-12-14 | ABT | Stock | 23.9713 | 24.6222 | 23.9174 | 24.4202 | 6481386.0 |
| 2001-12-14 | ABTL-DELISTED | Stock | 8.7 | 8.85 | 8.5 | 8.55 | 54200.0 |
| 2001-12-14 | ABV-DELISTED | Stock | 20.2 | 20.2 | 19.78 | 19.97 | 755600.0 |
| 2001-12-14 | ABX-DELISTED | Stock | 15.67 | 16.35 | 15.67 | 16.35 | 5366000.0 |
| 2001-12-14 | ACAP-DELISTED | Stock | 20.55 | 21.0 | 20.55 | 21.0 | 51900.0 |
| 2001-12-14 | ACAS-DELISTED | Stock | 27.31 | 27.9 | 26.35 | 27.05 | 352100.0 |
| 2001-12-14 | ACAT-DELISTED | Stock | 16.19 | 16.3 | 16.0 | 16.3 | 19300.0 |
| 2001-12-14 | ACCL-DELISTED | Stock | 10.6400003433228 | 10.6520004272461 | 10.210000038147 | 10.5139999389648 | 85100.0 |
| 2001-12-14 | ACE-DELISTED | Stock | 37.35 | 37.51 | 36.85 | 37.5 | 2050100.0 |
| 2001-12-14 | ACF-DELISTED | Stock | 27.76 | 27.85 | 26.11 | 26.98 | 1905500.0 |
| 2001-12-14 | ACG-DELISTED | Stock | 7.38 | 7.62 | 7.37 | 7.46 | 2308900.0 |
| 2001-12-14 | ACGL | Stock | 2.6322 | 2.6856 | 2.6278 | 2.6856 | 160200.0 |
| 2001-12-14 | ACGN-DELISTED | Stock | 1813.3288 | 2153.3288 | 1813.3288 | 2142.0 | 15200.0 |
| 2001-12-14 | ACH | Stock | 11.9 | 12.1 | 11.6667 | 11.8733 | 83700.0 |
| 2001-12-14 | ACH-DELISTED | Stock | 4.2875 | 4.2875 | 4.25 | 4.275 | 1186000.0 |
| 2001-12-14 | ACLS | Stock | 53.2 | 55.2 | 52.0 | 53.56 | 192575.0 |
| 2001-12-14 | ACO-DELISTED | Stock | 5.95 | 6.22 | 5.95 | 6.22 | 16100.0 |
| 2001-12-14 | ACPW-DELISTED | Stock | 28.05 | 30.0 | 27.85 | 28.45 | 33760.0 |
| 2001-12-14 | ACS-DELISTED | Stock | 49.0 | 49.375 | 48.74 | 49.35 | 450600.0 |
| 2001-12-14 | ACTA-DELISTED | Stock | 27.2 | 27.8 | 25.0 | 25.6 | 101200.0 |
| 2001-12-14 | ACTT-DELISTED | Stock | 8.41 | 8.7392 | 8.4 | 8.65 | 57900.0 |
| 2001-12-14 | ACTU-DELISTED | Stock | 5.02 | 5.06 | 4.87 | 5.0 | 575000.0 |
| 2001-12-14 | ACXM-DELISTED | Stock | 14.1 | 15.64 | 14.08 | 15.62 | 2022746.0 |
| 2001-12-14 | AD | Stock | 29.2 | 29.5667 | 29.1 | 29.28 | 156600.0 |
| 2001-12-14 | ADAT-DELISTED | Stock | 74.52 | 74.52 | 68.94 | 73.8 | 1576.0 |
> showing 50 of 3,043 rows — these rows as CSV