PREVIEW / stock_daily / 2002-09-18
file: by_date/stock_daily/2002/2002-09-18.parquet size: 107 KB rows: 3,179 symbols: 1,970
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-09-18 | AAPL | Stock | 0.2623 | 0.2695 | 0.2593 | 0.2682 | 328641600.0 |
| 2002-09-18 | MSFT | Stock | 23.36 | 24.12 | 23.33 | 23.875 | 83951800.0 |
| 2002-09-18 | NVDA | Stock | 0.08 | 0.0816 | 0.0766 | 0.079 | 811692000.0 |
| 2002-09-18 | AMZN | Stock | 0.861 | 0.8965 | 0.8475 | 0.8865 | 167820000.0 |
| 2002-09-18 | CL | Stock | 27.125 | 27.45 | 26.955 | 27.275 | 2613000.0 |
| 2002-09-18 | A | Stock | 10.515 | 10.5866 | 10.2003 | 10.5508 | 5656588.0 |
| 2002-09-18 | AABA-DELISTED | Stock | 5.0 | 5.05999994277954 | 4.83500003814697 | 5.0 | 9826200.0 |
| 2002-09-18 | AAI-DELISTED | Stock | 3.31 | 3.35 | 3.2 | 3.22 | 439800.0 |
| 2002-09-18 | AAIC-DELISTED | Stock | 192.2 | 195.0 | 185.0 | 185.4 | 144800.0 |
| 2002-09-18 | AAME | Stock | 1.75 | 1.96 | 1.75 | 1.9 | 1200.0 |
| 2002-09-18 | AAON | Stock | 2.0872 | 2.1202 | 2.0872 | 2.107 | 205791.0 |
| 2002-09-18 | AAP | Stock | 17.85 | 17.9 | 17.2333 | 17.55 | 762600.0 |
| 2002-09-18 | AAXN-DELISTED | Stock | 0.479166656732559 | 0.479166656732559 | 0.469166666269302 | 0.469999998807907 | 106800.0 |
| 2002-09-18 | ABAX-DELISTED | Stock | 3.25 | 3.25 | 3.09 | 3.25 | 44270.0 |
| 2002-09-18 | ABB-DELISTED | Stock | 3.77 | 4.0 | 3.77 | 4.0 | 50200.0 |
| 2002-09-18 | ABC-DELISTED | Stock | 17.27 | 17.61 | 17.2 | 17.32 | 6289200.0 |
| 2002-09-18 | ABCB | Stock | 10.3019 | 10.9422 | 10.3019 | 10.3829 | 16779.0 |
| 2002-09-18 | ABCO-DELISTED | Stock | 16.24 | 16.24 | 15.175 | 15.56 | 96400.0 |
| 2002-09-18 | ABCW-DELISTED | Stock | 20.4 | 20.6 | 20.38 | 20.4 | 21100.0 |
| 2002-09-18 | ABE-DELISTED | Stock | 5.88 | 5.93 | 5.85 | 5.93 | 8600.0 |
| 2002-09-18 | ABFS-DELISTED | Stock | 27.74 | 27.95 | 26.77 | 27.45 | 485975.0 |
| 2002-09-18 | ABG | Stock | 11.2 | 11.2 | 10.67 | 10.67 | 84000.0 |
| 2002-09-18 | ABK-DELISTED | Stock | 54.33 | 55.5 | 53.5 | 55.1 | 721900.0 |
| 2002-09-18 | ABM | Stock | 14.25 | 14.35 | 13.95 | 14.0 | 221800.0 |
| 2002-09-18 | ABMD-DELISTED | Stock | 4.8 | 4.8 | 4.35 | 4.47 | 61700.0 |
| 2002-09-18 | ABP-DELISTED | Stock | 0.8 | 0.82 | 0.77 | 0.8 | 7300.0 |
| 2002-09-18 | ABT | Stock | 17.7765 | 18.4049 | 17.6867 | 18.1446 | 15731312.0 |
| 2002-09-18 | ABTL-DELISTED | Stock | 7.7 | 10.1 | 7.25 | 9.8 | 48200.0 |
| 2002-09-18 | ABV-DELISTED | Stock | 13.05 | 13.05 | 12.2 | 12.37 | 491200.0 |
| 2002-09-18 | ABVA-DELISTED | Stock | 10.3 | 10.5 | 10.3 | 10.5 | 4800.0 |
| 2002-09-18 | ABX-DELISTED | Stock | 17.4 | 17.75 | 16.77 | 17.04 | 4349200.0 |
| 2002-09-18 | ACAP-DELISTED | Stock | 17.54 | 17.7 | 17.43 | 17.51 | 41200.0 |
| 2002-09-18 | ACAS-DELISTED | Stock | 18.49 | 18.49 | 17.25 | 17.88 | 1708932.0 |
| 2002-09-18 | ACAT-DELISTED | Stock | 14.4 | 14.72 | 14.29 | 14.5 | 60366.0 |
| 2002-09-18 | ACCL-DELISTED | Stock | 5.98117017745972 | 6.22012996673584 | 5.98117017745972 | 6.22012996673584 | 91300.0 |
| 2002-09-18 | ACE-DELISTED | Stock | 31.76 | 33.15 | 31.4 | 32.66 | 1886500.0 |
| 2002-09-18 | ACF-DELISTED | Stock | 8.19 | 8.19 | 6.25 | 7.05 | 8385700.0 |
| 2002-09-18 | ACG-DELISTED | Stock | 8.17 | 8.21 | 8.16 | 8.19 | 526900.0 |
| 2002-09-18 | ACGL | Stock | 3.0989 | 3.1211 | 3.0722 | 3.0889 | 364500.0 |
| 2002-09-18 | ACGN-DELISTED | Stock | 974.6712 | 997.3288 | 963.3288 | 997.3288 | 36000.0 |
| 2002-09-18 | ACH | Stock | 9.9533 | 10.0067 | 9.7333 | 10.0 | 103800.0 |
| 2002-09-18 | ACH-DELISTED | Stock | 3.2375 | 3.275 | 3.2225 | 3.275 | 14800.0 |
| 2002-09-18 | ACLS | Stock | 22.16 | 22.6 | 20.8 | 22.52 | 590225.0 |
| 2002-09-18 | ACO-DELISTED | Stock | 6.08 | 6.1 | 5.85 | 5.9 | 10900.0 |
| 2002-09-18 | ACPW-DELISTED | Stock | 7.722 | 7.722 | 6.0233 | 6.95 | 57508.0 |
| 2002-09-18 | ACS-DELISTED | Stock | 43.7 | 45.5 | 43.7 | 45.02 | 1431900.0 |
| 2002-09-18 | ACTA-DELISTED | Stock | 4.2 | 4.4 | 3.8 | 4.2 | 57100.0 |
| 2002-09-18 | ACTT-DELISTED | Stock | 2.0 | 2.2 | 1.89 | 1.98 | 12500.0 |
| 2002-09-18 | ACTU-DELISTED | Stock | 1.3 | 1.32 | 1.27 | 1.29 | 266200.0 |
| 2002-09-18 | ACXM-DELISTED | Stock | 17.71 | 17.99 | 17.33 | 17.52 | 744638.0 |
> showing 50 of 3,179 rows — these rows as CSV