PREVIEW / stock_daily / 2002-01-23
file: by_date/stock_daily/2002/2002-01-23.parquet size: 104 KB rows: 3,034 symbols: 1,879
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-23 | AAPL | Stock | 0.3893 | 0.4114 | 0.3855 | 0.4111 | 443279200.0 |
| 2002-01-23 | MSFT | Stock | 32.025 | 32.355 | 31.62 | 31.87 | 80403000.0 |
| 2002-01-23 | NVDA | Stock | 0.523 | 0.5318 | 0.5127 | 0.5281 | 889164000.0 |
| 2002-01-23 | AMZN | Stock | 0.6245 | 0.63 | 0.595 | 0.6235 | 360632000.0 |
| 2002-01-23 | CL | Stock | 28.2 | 28.375 | 27.86 | 28.15 | 3579600.0 |
| 2002-01-23 | A | Stock | 19.2561 | 20.5579 | 19.2561 | 20.0286 | 3078815.0 |
| 2002-01-23 | AABA-DELISTED | Stock | 9.39999961853027 | 9.42500019073486 | 8.98499965667725 | 9.22000026702881 | 21565200.0 |
| 2002-01-23 | AAI-DELISTED | Stock | 6.5 | 6.6 | 6.1 | 6.2 | 244300.0 |
| 2002-01-23 | AAIC-DELISTED | Stock | 119.0 | 127.0 | 119.0 | 127.0 | 49400.0 |
| 2002-01-23 | AAME | Stock | 2.49 | 2.5 | 2.36 | 2.39 | 13300.0 |
| 2002-01-23 | AAON | Stock | 1.7339 | 1.7866 | 1.7339 | 1.7567 | 215283.0 |
| 2002-01-23 | AAP | Stock | 15.6 | 15.7167 | 15.5667 | 15.6333 | 38700.0 |
| 2002-01-23 | AAXN-DELISTED | Stock | 1.43416666984558 | 1.44916665554047 | 1.38333332538605 | 1.40166664123535 | 1048800.0 |
| 2002-01-23 | ABAX-DELISTED | Stock | 5.65 | 5.8 | 5.55 | 5.8 | 72400.0 |
| 2002-01-23 | ABB-DELISTED | Stock | 9.48 | 9.48 | 9.2 | 9.4 | 28700.0 |
| 2002-01-23 | ABC-DELISTED | Stock | 15.22 | 15.26 | 14.78 | 15.18 | 3910800.0 |
| 2002-01-23 | ABCB | Stock | 10.9422 | 11.0233 | 10.6585 | 10.8612 | 236881.0 |
| 2002-01-23 | ABCO-DELISTED | Stock | 14.517 | 14.96 | 14.517 | 14.96 | 38380.0 |
| 2002-01-23 | ABCW-DELISTED | Stock | 17.45 | 18.0 | 17.4 | 17.77 | 53200.0 |
| 2002-01-23 | ABE-DELISTED | Stock | 6.92 | 6.95 | 6.9 | 6.95 | 11400.0 |
| 2002-01-23 | ABFS-DELISTED | Stock | 27.41 | 28.4 | 27.23 | 28.4 | 368900.0 |
| 2002-01-23 | ABK-DELISTED | Stock | 58.77 | 59.54 | 58.4 | 59.03 | 1219600.0 |
| 2002-01-23 | ABM | Stock | 14.275 | 14.275 | 14.07 | 14.21 | 131800.0 |
| 2002-01-23 | ABMD-DELISTED | Stock | 15.05 | 15.4 | 14.63 | 15.4 | 197700.0 |
| 2002-01-23 | ABP-DELISTED | Stock | 1.2 | 1.2 | 1.12 | 1.13 | 62600.0 |
| 2002-01-23 | ABT | Stock | 25.8028 | 25.9644 | 25.6412 | 25.7624 | 7488736.0 |
| 2002-01-23 | ABTL-DELISTED | Stock | 15.45 | 15.55 | 14.65 | 15.45 | 44800.0 |
| 2002-01-23 | ABV-DELISTED | Stock | 20.31 | 20.5 | 20.27 | 20.4 | 830000.0 |
| 2002-01-23 | ABX-DELISTED | Stock | 17.0 | 17.03 | 16.28 | 16.35 | 3515200.0 |
| 2002-01-23 | ACAP-DELISTED | Stock | 19.55 | 20.67 | 19.46 | 20.67 | 49200.0 |
| 2002-01-23 | ACAS-DELISTED | Stock | 28.04 | 28.2 | 27.65 | 27.8 | 388600.0 |
| 2002-01-23 | ACAT-DELISTED | Stock | 16.57 | 17.25 | 16.57 | 17.25 | 30800.0 |
| 2002-01-23 | ACCL-DELISTED | Stock | 9.38449954986572 | 10.0651998519897 | 9.38449954986572 | 10.0651998519897 | 1176300.0 |
| 2002-01-23 | ACE-DELISTED | Stock | 35.47 | 35.55 | 34.91 | 35.3 | 1618158.0 |
| 2002-01-23 | ACF-DELISTED | Stock | 22.1 | 22.95 | 21.65 | 22.34 | 2184700.0 |
| 2002-01-23 | ACG-DELISTED | Stock | 7.66 | 7.66 | 7.62 | 7.63 | 819200.0 |
| 2002-01-23 | ACGL | Stock | 2.8778 | 2.8889 | 2.8722 | 2.8889 | 153900.0 |
| 2002-01-23 | ACGN-DELISTED | Stock | 1802.0 | 1960.6712 | 1768.0 | 1926.6712 | 32200.0 |
| 2002-01-23 | ACH | Stock | 12.9067 | 13.3333 | 12.7133 | 13.2067 | 153300.0 |
| 2002-01-23 | ACH-DELISTED | Stock | 4.8005 | 4.813 | 4.738 | 4.813 | 295977.0 |
| 2002-01-23 | ACLS | Stock | 50.8 | 53.2 | 50.04 | 52.88 | 292475.0 |
| 2002-01-23 | ACO-DELISTED | Stock | 7.07 | 7.16 | 7.0 | 7.15 | 15400.0 |
| 2002-01-23 | ACPW-DELISTED | Stock | 27.75 | 28.75 | 26.9 | 27.25 | 49780.0 |
| 2002-01-23 | ACS-DELISTED | Stock | 51.5 | 51.505 | 47.125 | 48.75 | 3174500.0 |
| 2002-01-23 | ACTA-DELISTED | Stock | 23.0 | 23.4 | 20.4 | 22.4 | 120100.0 |
| 2002-01-23 | ACTT-DELISTED | Stock | 7.3 | 7.55 | 7.0 | 7.4 | 324000.0 |
| 2002-01-23 | ACTU-DELISTED | Stock | 6.65 | 7.14 | 6.64 | 6.9 | 1218800.0 |
| 2002-01-23 | ACXM-DELISTED | Stock | 16.76 | 16.76 | 15.9 | 16.17 | 2018200.0 |
| 2002-01-23 | AD | Stock | 26.6 | 27.6 | 26.48 | 27.4667 | 352800.0 |
| 2002-01-23 | ADAT-DELISTED | Stock | 58.63 | 60.97 | 54.32 | 56.21 | 3011.0 |
> showing 50 of 3,034 rows — these rows as CSV