PREVIEW / stock_daily / 2005-06-21
file: by_date/stock_daily/2005/2005-06-21.parquet size: 137 KB rows: 4,107 symbols: 2,571
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-21 | AAPL | Stock | 1.3471 | 1.3639 | 1.335 | 1.3521 | 370526800.0 |
| 2005-06-21 | MSFT | Stock | 25.08 | 25.19 | 25.04 | 25.15 | 81084000.0 |
| 2005-06-21 | NVDA | Stock | 0.2292 | 0.2309 | 0.227 | 0.2298 | 428172000.0 |
| 2005-06-21 | AMZN | Stock | 1.78 | 1.7905 | 1.764 | 1.769 | 89142000.0 |
| 2005-06-21 | CL | Stock | 25.325 | 25.43 | 25.14 | 25.42 | 3817600.0 |
| 2005-06-21 | A | Stock | 17.7754 | 17.8827 | 17.6538 | 17.6538 | 1939306.0 |
| 2005-06-21 | AABA-DELISTED | Stock | 36.3699989318848 | 37.310001373291 | 36.3600006103516 | 36.9500007629395 | 16219200.0 |
| 2005-06-21 | AACC-DELISTED | Stock | 25.13 | 25.47 | 24.91 | 24.94 | 40908.0 |
| 2005-06-21 | AACQU-DELISTED | Stock | 6.05 | 6.1 | 6.05 | 6.1 | 4000.0 |
| 2005-06-21 | AAI-DELISTED | Stock | 9.64 | 9.78 | 9.57 | 9.69 | 761800.0 |
| 2005-06-21 | AAIC-DELISTED | Stock | 277.0 | 282.8 | 275.0 | 282.0 | 1061700.0 |
| 2005-06-21 | AAME | Stock | 3.0 | 3.0 | 3.0 | 3.0 | 6900.0 |
| 2005-06-21 | AAON | Stock | 2.4494 | 2.4494 | 2.3928 | 2.3993 | 39487.0 |
| 2005-06-21 | AAP | Stock | 42.3 | 43.0067 | 42.3 | 42.8533 | 603450.0 |
| 2005-06-21 | AAV-DELISTED | Stock | 14.6 | 14.9 | 14.6 | 14.6 | 112100.0 |
| 2005-06-21 | AAXN-DELISTED | Stock | 10.4899997711182 | 11.2399997711182 | 10.3800001144409 | 10.7700004577637 | 8562300.0 |
| 2005-06-21 | ABAX-DELISTED | Stock | 11.2 | 11.27 | 11.02 | 11.06 | 55444.0 |
| 2005-06-21 | ABB-DELISTED | Stock | 6.88 | 6.97 | 6.87 | 6.94 | 580000.0 |
| 2005-06-21 | ABBC-DELISTED | Stock | 11.35 | 11.36 | 11.23 | 11.24 | 10042.0 |
| 2005-06-21 | ABC-DELISTED | Stock | 17.15 | 17.17 | 16.93 | 16.96 | 4058000.0 |
| 2005-06-21 | ABCB | Stock | 17.3131 | 17.7118 | 17.2742 | 17.6049 | 9767.0 |
| 2005-06-21 | ABCO-DELISTED | Stock | 24.74 | 24.85 | 24.35 | 24.4 | 153704.0 |
| 2005-06-21 | ABCW-DELISTED | Stock | 29.71 | 29.95 | 29.56 | 29.88 | 53000.0 |
| 2005-06-21 | ABE-DELISTED | Stock | 10.08 | 10.4 | 10.08 | 10.32 | 18800.0 |
| 2005-06-21 | ABFS-DELISTED | Stock | 31.4 | 31.73 | 31.34 | 31.5 | 402249.0 |
| 2005-06-21 | ABG | Stock | 15.05 | 15.4 | 15.05 | 15.3 | 24300.0 |
| 2005-06-21 | ABK-DELISTED | Stock | 70.82 | 71.27 | 70.6 | 71.03 | 414400.0 |
| 2005-06-21 | ABM | Stock | 19.33 | 19.52 | 19.29 | 19.44 | 228200.0 |
| 2005-06-21 | ABMD-DELISTED | Stock | 10.64 | 10.66 | 10.3 | 10.34 | 112596.0 |
| 2005-06-21 | ABP-DELISTED | Stock | 2.94 | 2.95 | 2.8 | 2.9 | 255700.0 |
| 2005-06-21 | ABR | Stock | 28.95 | 28.98 | 28.6 | 28.61 | 163600.0 |
| 2005-06-21 | ABT | Stock | 23.7501 | 23.7933 | 23.6733 | 23.7261 | 5424135.0 |
| 2005-06-21 | ABTL-DELISTED | Stock | 23.67 | 24.83 | 23.57 | 23.88 | 36706.0 |
| 2005-06-21 | ABV-DELISTED | Stock | 30.45 | 30.85 | 30.0 | 30.46 | 229000.0 |
| 2005-06-21 | ABVA-DELISTED | Stock | 14.518 | 14.518 | 14.518 | 14.518 | 300.0 |
| 2005-06-21 | ABX-DELISTED | Stock | 24.23 | 24.61 | 23.97 | 24.4 | 1252800.0 |
| 2005-06-21 | ACAD | Stock | 9.0 | 9.18 | 8.81 | 9.1 | 25100.0 |
| 2005-06-21 | ACAP-DELISTED | Stock | 35.72 | 36.26 | 35.7 | 36.11 | 152490.0 |
| 2005-06-21 | ACAS-DELISTED | Stock | 35.69 | 35.85 | 35.58 | 35.71 | 413274.0 |
| 2005-06-21 | ACAT-DELISTED | Stock | 21.76 | 22.14 | 21.35 | 21.81 | 116928.0 |
| 2005-06-21 | ACC-DELISTED | Stock | 21.71 | 21.79 | 21.55 | 21.56 | 34702.0 |
| 2005-06-21 | ACCL-DELISTED | Stock | 5.04 | 5.18 | 5.04 | 5.09 | 101565.0 |
| 2005-06-21 | ACE-DELISTED | Stock | 45.47 | 45.77 | 45.36 | 45.72 | 1228901.0 |
| 2005-06-21 | ACF-DELISTED | Stock | 25.21 | 25.4 | 24.85 | 25.3 | 747500.0 |
| 2005-06-21 | ACFC-DELISTED | Stock | 61.94 | 62.14 | 61.22 | 61.79 | 2551.0 |
| 2005-06-21 | ACG-DELISTED | Stock | 8.22 | 8.25 | 8.22 | 8.24 | 434200.0 |
| 2005-06-21 | ACGL | Stock | 4.8122 | 4.8222 | 4.7867 | 4.81 | 684900.0 |
| 2005-06-21 | ACGN-DELISTED | Stock | 680.0 | 691.3288 | 646.0 | 668.6712 | 234700.0 |
| 2005-06-21 | ACH | Stock | 21.0733 | 21.24 | 21.0067 | 21.1667 | 151050.0 |
| 2005-06-21 | ACH-DELISTED | Stock | 13.506 | 13.684 | 13.506 | 13.679 | 122822.0 |
> showing 50 of 4,107 rows — these rows as CSV