PREVIEW / stock_daily / 2002-03-18
file: by_date/stock_daily/2002/2002-03-18.parquet size: 107 KB rows: 3,114 symbols: 1,939
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-03-18 | AAPL | Stock | 0.4455 | 0.4473 | 0.4343 | 0.4418 | 304556000.0 |
| 2002-03-18 | MSFT | Stock | 31.37 | 31.495 | 30.6 | 31.07 | 52296800.0 |
| 2002-03-18 | NVDA | Stock | 0.4477 | 0.4574 | 0.4347 | 0.4397 | 1236996000.0 |
| 2002-03-18 | AMZN | Stock | 0.7075 | 0.764 | 0.707 | 0.7505 | 196636000.0 |
| 2002-03-18 | CL | Stock | 28.0 | 28.325 | 27.83 | 28.215 | 3556000.0 |
| 2002-03-18 | A | Stock | 26.6881 | 27.1817 | 26.2876 | 26.5093 | 5432768.0 |
| 2002-03-18 | AABA-DELISTED | Stock | 9.36999988555908 | 9.63000011444092 | 9.32999992370605 | 9.60499954223633 | 15079000.0 |
| 2002-03-18 | AAI-DELISTED | Stock | 6.5 | 6.58 | 6.41 | 6.5 | 245000.0 |
| 2002-03-18 | AAIC-DELISTED | Stock | 137.0 | 140.4 | 137.0 | 138.6 | 81300.0 |
| 2002-03-18 | AAME | Stock | 2.24 | 2.24 | 2.24 | 2.24 | 200.0 |
| 2002-03-18 | AAON | Stock | 2.1667 | 2.1684 | 2.1465 | 2.1465 | 222117.0 |
| 2002-03-18 | AAP | Stock | 14.6667 | 14.77 | 14.5833 | 14.75 | 1295700.0 |
| 2002-03-18 | AAXN-DELISTED | Stock | 1.58166670799255 | 1.58166670799255 | 1.50833332538605 | 1.53583335876465 | 2524800.0 |
| 2002-03-18 | ABAX-DELISTED | Stock | 6.5 | 6.5113 | 6.32 | 6.32 | 11500.0 |
| 2002-03-18 | ABB-DELISTED | Stock | 8.6 | 8.6 | 8.35 | 8.36 | 20800.0 |
| 2002-03-18 | ABC-DELISTED | Stock | 17.51 | 17.62 | 17.3 | 17.39 | 3421600.0 |
| 2002-03-18 | ABCB | Stock | 10.9827 | 11.0638 | 10.7233 | 10.7233 | 9993.0 |
| 2002-03-18 | ABCO-DELISTED | Stock | 14.483 | 14.857 | 14.383 | 14.787 | 74881.0 |
| 2002-03-18 | ABCW-DELISTED | Stock | 21.7 | 21.71 | 20.88 | 21.09 | 56100.0 |
| 2002-03-18 | ABE-DELISTED | Stock | 7.4 | 7.48 | 7.34 | 7.34 | 9200.0 |
| 2002-03-18 | ABFS-DELISTED | Stock | 29.2 | 29.22 | 28.51 | 29.05 | 47500.0 |
| 2002-03-18 | ABK-DELISTED | Stock | 60.55 | 60.7 | 59.05 | 59.27 | 490400.0 |
| 2002-03-18 | ABM | Stock | 16.55 | 17.125 | 16.54 | 16.99 | 293600.0 |
| 2002-03-18 | ABMD-DELISTED | Stock | 10.37 | 10.42 | 10.01 | 10.2 | 135500.0 |
| 2002-03-18 | ABP-DELISTED | Stock | 1.24 | 1.44 | 1.22 | 1.32 | 414400.0 |
| 2002-03-18 | ABT | Stock | 24.3529 | 24.3753 | 23.7693 | 24.0207 | 11854733.0 |
| 2002-03-18 | ABTL-DELISTED | Stock | 14.8 | 15.15 | 14.75 | 14.75 | 20600.0 |
| 2002-03-18 | ABV-DELISTED | Stock | 19.42 | 19.76 | 19.3 | 19.7 | 398700.0 |
| 2002-03-18 | ABX-DELISTED | Stock | 17.7 | 18.14 | 17.65 | 18.06 | 2636100.0 |
| 2002-03-18 | ACAP-DELISTED | Stock | 18.13 | 18.2 | 17.93 | 17.93 | 28300.0 |
| 2002-03-18 | ACAS-DELISTED | Stock | 30.25 | 30.38 | 29.84 | 30.28 | 171458.0 |
| 2002-03-18 | ACAT-DELISTED | Stock | 17.8 | 18.5 | 17.61 | 18.49 | 37000.0 |
| 2002-03-18 | ACCL-DELISTED | Stock | 9.58001041412354 | 9.92759037017822 | 9.58001041412354 | 9.92759037017822 | 312900.0 |
| 2002-03-18 | ACE-DELISTED | Stock | 43.35 | 43.52 | 41.5 | 42.11 | 1665100.0 |
| 2002-03-18 | ACF-DELISTED | Stock | 37.25 | 39.33 | 37.25 | 38.0 | 1855500.0 |
| 2002-03-18 | ACG-DELISTED | Stock | 7.71 | 7.73 | 7.7 | 7.72 | 688300.0 |
| 2002-03-18 | ACGL | Stock | 3.0167 | 3.02 | 2.9578 | 2.9889 | 378900.0 |
| 2002-03-18 | ACGN-DELISTED | Stock | 1666.0 | 1734.0 | 1666.0 | 1734.0 | 5400.0 |
| 2002-03-18 | ACH | Stock | 13.2 | 13.3267 | 12.9333 | 13.0667 | 278100.0 |
| 2002-03-18 | ACH-DELISTED | Stock | 5.4375 | 5.4425 | 5.29 | 5.36 | 220800.0 |
| 2002-03-18 | ACLS | Stock | 53.76 | 56.64 | 53.4 | 54.12 | 134550.0 |
| 2002-03-18 | ACO-DELISTED | Stock | 6.98 | 6.98 | 6.6 | 6.68 | 18400.0 |
| 2002-03-18 | ACPW-DELISTED | Stock | 24.95 | 24.95 | 22.8 | 23.25 | 40200.0 |
| 2002-03-18 | ACS-DELISTED | Stock | 55.0 | 57.0 | 54.51 | 56.75 | 2539400.0 |
| 2002-03-18 | ACTA-DELISTED | Stock | 17.8 | 18.6 | 17.2 | 17.2 | 29800.0 |
| 2002-03-18 | ACTT-DELISTED | Stock | 5.2 | 5.5 | 5.05 | 5.15 | 18400.0 |
| 2002-03-18 | ACTU-DELISTED | Stock | 6.88 | 7.06 | 6.2 | 6.31 | 1014300.0 |
| 2002-03-18 | ACXM-DELISTED | Stock | 16.05 | 16.65 | 16.02 | 16.61 | 499200.0 |
| 2002-03-18 | AD | Stock | 26.3667 | 26.72 | 26.26 | 26.4667 | 148650.0 |
| 2002-03-18 | ADAT-DELISTED | Stock | 82.44 | 87.66 | 80.1 | 86.4 | 11911.0 |
> showing 50 of 3,114 rows — these rows as CSV