PREVIEW / stock_daily / 2005-06-20
file: by_date/stock_daily/2005/2005-06-20.parquet size: 137 KB rows: 4,094 symbols: 2,561
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 |
|---|---|---|---|---|---|---|---|
| 2005-06-20 | AAPL | Stock | 1.3518 | 1.3604 | 1.3375 | 1.3432 | 323716400.0 |
| 2005-06-20 | MSFT | Stock | 24.98 | 25.28 | 24.93 | 25.11 | 50538900.0 |
| 2005-06-20 | NVDA | Stock | 0.2242 | 0.2292 | 0.2206 | 0.2277 | 606060000.0 |
| 2005-06-20 | AMZN | Stock | 1.7525 | 1.7985 | 1.752 | 1.7845 | 101946000.0 |
| 2005-06-20 | CL | Stock | 24.925 | 25.445 | 24.845 | 25.37 | 6404000.0 |
| 2005-06-20 | A | Stock | 17.5608 | 17.8827 | 17.5465 | 17.8255 | 2084558.0 |
| 2005-06-20 | AABA-DELISTED | Stock | 35.9599990844727 | 36.8400001525879 | 35.7900009155273 | 36.4500007629395 | 12753200.0 |
| 2005-06-20 | AACC-DELISTED | Stock | 25.3 | 25.4599 | 25.09 | 25.16 | 29270.0 |
| 2005-06-20 | AAI-DELISTED | Stock | 9.69 | 9.85 | 9.55 | 9.75 | 641700.0 |
| 2005-06-20 | AAIC-DELISTED | Stock | 278.0 | 278.4 | 274.2 | 274.8 | 985600.0 |
| 2005-06-20 | AAME | Stock | 3.05 | 3.05 | 3.0 | 3.0 | 38400.0 |
| 2005-06-20 | AAON | Stock | 2.4296 | 2.4678 | 2.4296 | 2.4336 | 241481.0 |
| 2005-06-20 | AAP | Stock | 42.1933 | 42.2533 | 41.6933 | 42.1933 | 580350.0 |
| 2005-06-20 | AAV-DELISTED | Stock | 15.01 | 15.01 | 14.9 | 15.01 | 62500.0 |
| 2005-06-20 | AAXN-DELISTED | Stock | 10.5600004196167 | 10.8299999237061 | 10.5 | 10.5200004577637 | 2671000.0 |
| 2005-06-20 | ABAX-DELISTED | Stock | 11.12 | 11.35 | 10.88 | 11.21 | 65039.0 |
| 2005-06-20 | ABB-DELISTED | Stock | 6.9 | 6.92 | 6.85 | 6.9 | 1206000.0 |
| 2005-06-20 | ABBC-DELISTED | Stock | 11.2 | 11.32 | 11.2 | 11.3 | 6440.0 |
| 2005-06-20 | ABC-DELISTED | Stock | 16.98 | 17.21 | 16.98 | 17.14 | 2158400.0 |
| 2005-06-20 | ABCB | Stock | 17.8967 | 17.8967 | 17.3519 | 17.3519 | 5963.0 |
| 2005-06-20 | ABCO-DELISTED | Stock | 24.07 | 24.78 | 24.03 | 24.58 | 213625.0 |
| 2005-06-20 | ABCW-DELISTED | Stock | 29.44 | 29.87 | 29.27 | 29.51 | 40090.0 |
| 2005-06-20 | ABE-DELISTED | Stock | 9.94 | 10.09 | 9.94 | 10.06 | 25400.0 |
| 2005-06-20 | ABFS-DELISTED | Stock | 32.01 | 32.13 | 31.15 | 31.37 | 917002.0 |
| 2005-06-20 | ABG | Stock | 15.43 | 15.45 | 15.01 | 15.01 | 44600.0 |
| 2005-06-20 | ABK-DELISTED | Stock | 71.03 | 71.14 | 70.36 | 70.77 | 497600.0 |
| 2005-06-20 | ABM | Stock | 19.58 | 19.6 | 19.26 | 19.3 | 197900.0 |
| 2005-06-20 | ABMD-DELISTED | Stock | 9.69 | 10.58 | 9.68 | 10.51 | 246080.0 |
| 2005-06-20 | ABP-DELISTED | Stock | 2.85 | 2.97 | 2.83 | 2.87 | 350600.0 |
| 2005-06-20 | ABR | Stock | 28.65 | 29.2 | 28.47 | 28.77 | 220000.0 |
| 2005-06-20 | ABT | Stock | 23.5774 | 23.7405 | 23.467 | 23.6973 | 3832430.0 |
| 2005-06-20 | ABTL-DELISTED | Stock | 24.29 | 24.74 | 22.86 | 23.65 | 49523.0 |
| 2005-06-20 | ABV-DELISTED | Stock | 30.39 | 30.78 | 30.2 | 30.43 | 415300.0 |
| 2005-06-20 | ABX-DELISTED | Stock | 24.81 | 24.85 | 24.25 | 24.29 | 1494900.0 |
| 2005-06-20 | ACAD | Stock | 9.38 | 9.38 | 9.0 | 9.07 | 22400.0 |
| 2005-06-20 | ACAP-DELISTED | Stock | 34.53 | 35.91 | 34.42 | 35.49 | 73410.0 |
| 2005-06-20 | ACAS-DELISTED | Stock | 35.78 | 35.89 | 35.51 | 35.61 | 646892.0 |
| 2005-06-20 | ACAT-DELISTED | Stock | 22.18 | 22.18 | 21.71 | 21.79 | 120535.0 |
| 2005-06-20 | ACC-DELISTED | Stock | 21.95 | 21.95 | 21.71 | 21.71 | 26000.0 |
| 2005-06-20 | ACCL-DELISTED | Stock | 5.05 | 5.14 | 4.95 | 5.04 | 161452.0 |
| 2005-06-20 | ACE-DELISTED | Stock | 45.75 | 45.92 | 45.03 | 45.39 | 1493200.0 |
| 2005-06-20 | ACF-DELISTED | Stock | 25.04 | 25.36 | 24.98 | 25.27 | 780100.0 |
| 2005-06-20 | ACFC-DELISTED | Stock | 62.04 | 62.04 | 61.17 | 61.22 | 1800.0 |
| 2005-06-20 | ACG-DELISTED | Stock | 8.24 | 8.25 | 8.21 | 8.23 | 591400.0 |
| 2005-06-20 | ACGL | Stock | 4.8 | 4.8333 | 4.78 | 4.8122 | 344700.0 |
| 2005-06-20 | ACGN-DELISTED | Stock | 714.0 | 725.3288 | 657.3288 | 668.6712 | 182800.0 |
| 2005-06-20 | ACH | Stock | 21.0333 | 21.24 | 20.88 | 21.08 | 160950.0 |
| 2005-06-20 | ACH-DELISTED | Stock | 13.375 | 13.532 | 13.35 | 13.507 | 98000.0 |
| 2005-06-20 | ACLS | Stock | 29.2 | 29.32 | 28.68 | 28.84 | 183700.0 |
| 2005-06-20 | ACO-DELISTED | Stock | 19.5 | 19.5 | 19.02 | 19.15 | 25300.0 |
> showing 50 of 4,094 rows — these rows as CSV