PREVIEW / stock_daily / 2002-04-18
file: by_date/stock_daily/2002/2002-04-18.parquet size: 106 KB rows: 3,076 symbols: 1,913
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-04-18 | AAPL | Stock | 0.4554 | 0.4557 | 0.4443 | 0.4538 | 401710400.0 |
| 2002-04-18 | MSFT | Stock | 28.395 | 28.655 | 26.34 | 28.185 | 74794800.0 |
| 2002-04-18 | NVDA | Stock | 0.3323 | 0.3359 | 0.3229 | 0.3302 | 693156000.0 |
| 2002-04-18 | AMZN | Stock | 0.735 | 0.743 | 0.6975 | 0.713 | 77528000.0 |
| 2002-04-18 | CL | Stock | 27.025 | 27.9 | 26.55 | 26.975 | 23881000.0 |
| 2002-04-18 | A | Stock | 24.7854 | 24.8569 | 23.9771 | 24.7496 | 3828423.0 |
| 2002-04-18 | AABA-DELISTED | Stock | 7.88500022888184 | 7.92000007629395 | 7.5 | 7.53000020980835 | 16957400.0 |
| 2002-04-18 | AAI-DELISTED | Stock | 6.25 | 6.3 | 6.08 | 6.22 | 307300.0 |
| 2002-04-18 | AAIC-DELISTED | Stock | 159.0 | 161.0 | 158.2 | 160.2 | 38900.0 |
| 2002-04-18 | AAME | Stock | 2.25 | 2.35 | 2.25 | 2.35 | 2100.0 |
| 2002-04-18 | AAON | Stock | 2.4064 | 2.4582 | 2.3923 | 2.4582 | 801900.0 |
| 2002-04-18 | AAP | Stock | 16.3333 | 16.4 | 16.0 | 16.36 | 707400.0 |
| 2002-04-18 | AAXN-DELISTED | Stock | 1.62416660785675 | 1.68499994277954 | 1.59666669368744 | 1.60166668891907 | 1119600.0 |
| 2002-04-18 | ABAX-DELISTED | Stock | 6.2 | 6.25 | 5.56 | 5.85 | 45000.0 |
| 2002-04-18 | ABB-DELISTED | Stock | 9.1 | 9.12 | 9.05 | 9.08 | 5100.0 |
| 2002-04-18 | ABC-DELISTED | Stock | 17.0 | 17.71 | 16.98 | 17.63 | 4009600.0 |
| 2002-04-18 | ABCB | Stock | 13.0091 | 13.0496 | 12.4579 | 12.4579 | 18631.0 |
| 2002-04-18 | ABCO-DELISTED | Stock | 17.075 | 17.345 | 16.95 | 17.16 | 35000.0 |
| 2002-04-18 | ABCW-DELISTED | Stock | 21.84 | 21.9 | 21.5 | 21.72 | 25100.0 |
| 2002-04-18 | ABE-DELISTED | Stock | 7.43 | 7.5 | 7.43 | 7.47 | 9800.0 |
| 2002-04-18 | ABFS-DELISTED | Stock | 26.25 | 26.48 | 25.1 | 25.16 | 440300.0 |
| 2002-04-18 | ABK-DELISTED | Stock | 62.05 | 62.5 | 61.59 | 62.3 | 431100.0 |
| 2002-04-18 | ABM | Stock | 19.05 | 19.155 | 18.945 | 19.15 | 204800.0 |
| 2002-04-18 | ABMD-DELISTED | Stock | 8.3 | 9.04 | 8.06 | 9.0 | 91900.0 |
| 2002-04-18 | ABP-DELISTED | Stock | 1.15 | 1.15 | 1.08 | 1.08 | 49100.0 |
| 2002-04-18 | ABT | Stock | 24.3753 | 24.5728 | 24.1329 | 24.5414 | 6933602.0 |
| 2002-04-18 | ABTL-DELISTED | Stock | 18.25 | 18.5 | 17.6 | 18.5 | 21400.0 |
| 2002-04-18 | ABV-DELISTED | Stock | 21.0 | 21.03 | 20.76 | 21.02 | 398000.0 |
| 2002-04-18 | ABVA-DELISTED | Stock | 8.2 | 8.2 | 8.0 | 8.0 | 2600.0 |
| 2002-04-18 | ABX-DELISTED | Stock | 18.66 | 18.78 | 17.92 | 17.96 | 3110300.0 |
| 2002-04-18 | ACAP-DELISTED | Stock | 19.85 | 19.85 | 19.17 | 19.17 | 38400.0 |
| 2002-04-18 | ACAS-DELISTED | Stock | 31.3 | 31.848 | 31.27 | 31.5 | 178100.0 |
| 2002-04-18 | ACAT-DELISTED | Stock | 19.45 | 19.53 | 19.153 | 19.45 | 29600.0 |
| 2002-04-18 | ACCL-DELISTED | Stock | 9.94999980926514 | 10.2530002593994 | 9.60900020599365 | 10.1809997558594 | 112100.0 |
| 2002-04-18 | ACE-DELISTED | Stock | 43.37 | 43.82 | 42.46 | 43.43 | 1701157.0 |
| 2002-04-18 | ACF-DELISTED | Stock | 44.67 | 45.4 | 43.75 | 45.31 | 1753800.0 |
| 2002-04-18 | ACG-DELISTED | Stock | 7.89 | 7.94 | 7.87 | 7.93 | 631900.0 |
| 2002-04-18 | ACGL | Stock | 3.2 | 3.2533 | 3.1944 | 3.2522 | 1922400.0 |
| 2002-04-18 | ACGN-DELISTED | Stock | 1541.3288 | 1586.6712 | 1484.6712 | 1575.3288 | 6800.0 |
| 2002-04-18 | ACH | Stock | 13.6667 | 13.7333 | 13.3533 | 13.5467 | 111600.0 |
| 2002-04-18 | ACH-DELISTED | Stock | 5.275 | 5.275 | 5.255 | 5.255 | 25200.0 |
| 2002-04-18 | ACLS | Stock | 59.64 | 60.36 | 55.76 | 55.88 | 363375.0 |
| 2002-04-18 | ACO-DELISTED | Stock | 6.2 | 6.5 | 6.2 | 6.5 | 8700.0 |
| 2002-04-18 | ACPW-DELISTED | Stock | 25.5 | 25.75 | 23.65 | 25.0 | 32780.0 |
| 2002-04-18 | ACS-DELISTED | Stock | 51.6 | 52.4 | 50.75 | 50.94 | 1309800.0 |
| 2002-04-18 | ACTA-DELISTED | Stock | 12.8 | 13.0 | 12.0 | 12.4 | 35500.0 |
| 2002-04-18 | ACTT-DELISTED | Stock | 5.37 | 5.65 | 5.26 | 5.65 | 28700.0 |
| 2002-04-18 | ACTU-DELISTED | Stock | 5.99 | 6.39 | 5.75 | 6.28 | 242500.0 |
| 2002-04-18 | ACXM-DELISTED | Stock | 16.5 | 16.5 | 16.19 | 16.2 | 301300.0 |
| 2002-04-18 | ACY-DELISTED | Stock | 4.84 | 4.84 | 4.84 | 4.84 | 1600.0 |
> showing 50 of 3,076 rows — these rows as CSV