PREVIEW / stock_daily / 2005-09-21
file: by_date/stock_daily/2005/2005-09-21.parquet size: 140 KB rows: 4,188 symbols: 2,637
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-09-21 | AAPL | Stock | 1.8914 | 1.8946 | 1.8521 | 1.8611 | 434747600.0 |
| 2005-09-21 | MSFT | Stock | 25.8 | 25.9 | 25.43 | 25.49 | 68281800.0 |
| 2005-09-21 | NVDA | Stock | 0.2774 | 0.2829 | 0.2737 | 0.2761 | 625656000.0 |
| 2005-09-21 | AMZN | Stock | 2.0925 | 2.132 | 2.0625 | 2.0625 | 106276000.0 |
| 2005-09-21 | CL | Stock | 26.12 | 26.145 | 25.87 | 25.975 | 4608000.0 |
| 2005-09-21 | A | Stock | 24.1917 | 24.3062 | 23.8555 | 24.0629 | 4228391.0 |
| 2005-09-21 | AABA-DELISTED | Stock | 32.5299987792969 | 33.0999984741211 | 31.6000003814697 | 31.9699993133545 | 21896000.0 |
| 2005-09-21 | AACC-DELISTED | Stock | 29.78 | 29.78 | 28.28 | 28.35 | 294333.0 |
| 2005-09-21 | AACQ-DELISTED | Stock | 5.1 | 5.1 | 5.1 | 5.1 | 1000.0 |
| 2005-09-21 | AAI-DELISTED | Stock | 10.34 | 10.34 | 10.02 | 10.06 | 946200.0 |
| 2005-09-21 | AAIC-DELISTED | Stock | 225.4 | 226.2 | 219.6 | 219.8 | 1243500.0 |
| 2005-09-21 | AAME | Stock | 2.76 | 2.8 | 2.7 | 2.8 | 3000.0 |
| 2005-09-21 | AAON | Stock | 2.3388 | 2.3506 | 2.3309 | 2.3309 | 97200.0 |
| 2005-09-21 | AAP | Stock | 38.4067 | 38.4867 | 37.6733 | 37.7667 | 1737600.0 |
| 2005-09-21 | AATI-DELISTED | Stock | 12.36 | 12.5 | 11.05 | 11.57 | 113249.0 |
| 2005-09-21 | AAV-DELISTED | Stock | 18.43 | 18.53 | 18.2 | 18.43 | 162400.0 |
| 2005-09-21 | AAXN-DELISTED | Stock | 7.5 | 7.51999998092651 | 7.1100001335144 | 7.1399998664856 | 1776800.0 |
| 2005-09-21 | ABAX-DELISTED | Stock | 12.96 | 12.96 | 12.22 | 12.57 | 156078.0 |
| 2005-09-21 | ABB-DELISTED | Stock | 7.3 | 7.33 | 7.26 | 7.27 | 919800.0 |
| 2005-09-21 | ABBC-DELISTED | Stock | 12.75 | 12.75 | 12.35 | 12.53 | 27411.0 |
| 2005-09-21 | ABC-DELISTED | Stock | 19.46 | 19.65 | 19.37 | 19.51 | 3830400.0 |
| 2005-09-21 | ABCB | Stock | 17.5562 | 17.9355 | 17.5172 | 17.5172 | 13571.0 |
| 2005-09-21 | ABCO-DELISTED | Stock | 25.54 | 25.54 | 23.98 | 24.38 | 773950.0 |
| 2005-09-21 | ABCW-DELISTED | Stock | 29.51 | 29.81 | 29.06 | 29.06 | 221760.0 |
| 2005-09-21 | ABD-DELISTED | Stock | 27.57 | 28.0 | 27.43 | 27.73 | 365600.0 |
| 2005-09-21 | ABE-DELISTED | Stock | 10.95 | 10.99 | 10.94 | 10.96 | 12200.0 |
| 2005-09-21 | ABFS-DELISTED | Stock | 32.35 | 32.79 | 32.17 | 32.41 | 235642.0 |
| 2005-09-21 | ABG | Stock | 17.17 | 17.17 | 16.3 | 16.3 | 67800.0 |
| 2005-09-21 | ABK-DELISTED | Stock | 68.6 | 69.24 | 67.7 | 68.21 | 626800.0 |
| 2005-09-21 | ABM | Stock | 20.7 | 21.01 | 20.41 | 20.52 | 224600.0 |
| 2005-09-21 | ABMD-DELISTED | Stock | 10.44 | 10.44 | 9.86 | 10.06 | 98507.0 |
| 2005-09-21 | ABP-DELISTED | Stock | 5.33 | 5.44 | 5.31 | 5.43 | 707200.0 |
| 2005-09-21 | ABR | Stock | 28.36 | 28.52 | 28.14 | 28.4 | 134700.0 |
| 2005-09-21 | ABT | Stock | 20.5067 | 20.8473 | 20.4875 | 20.6794 | 11404335.0 |
| 2005-09-21 | ABTL-DELISTED | Stock | 25.0 | 25.05 | 24.3 | 24.35 | 23214.0 |
| 2005-09-21 | ABV-DELISTED | Stock | 35.35 | 36.4 | 34.9 | 36.21 | 364800.0 |
| 2005-09-21 | ABX-DELISTED | Stock | 28.65 | 29.2 | 28.65 | 29.05 | 2920600.0 |
| 2005-09-21 | ACAD | Stock | 11.3 | 11.3 | 10.69 | 10.71 | 163800.0 |
| 2005-09-21 | ACAP-DELISTED | Stock | 46.29 | 48.45 | 46.29 | 46.56 | 88917.0 |
| 2005-09-21 | ACAS-DELISTED | Stock | 37.06 | 37.16 | 36.52 | 36.89 | 901279.0 |
| 2005-09-21 | ACAT-DELISTED | Stock | 19.95 | 20.306 | 19.86 | 20.21 | 229814.0 |
| 2005-09-21 | ACC-DELISTED | Stock | 22.79 | 22.86 | 22.11 | 22.15 | 146300.0 |
| 2005-09-21 | ACCL-DELISTED | Stock | 6.47 | 6.47 | 6.03 | 6.09 | 100120.0 |
| 2005-09-21 | ACCO | Stock | 27.57 | 28.0 | 27.43 | 27.73 | 366000.0 |
| 2005-09-21 | ACE-DELISTED | Stock | 45.65 | 45.65 | 44.06 | 44.07 | 1885528.0 |
| 2005-09-21 | ACF-DELISTED | Stock | 24.82 | 24.82 | 24.17 | 24.23 | 1221600.0 |
| 2005-09-21 | ACFC-DELISTED | Stock | 70.92 | 70.92 | 70.41 | 70.56 | 588.0 |
| 2005-09-21 | ACG-DELISTED | Stock | 8.3 | 8.33 | 8.28 | 8.33 | 328700.0 |
| 2005-09-21 | ACGL | Stock | 5.4211 | 5.4656 | 5.2378 | 5.2633 | 3207600.0 |
| 2005-09-21 | ACGN-DELISTED | Stock | 748.0 | 793.3288 | 702.6712 | 770.6712 | 443200.0 |
> showing 50 of 4,188 rows — these rows as CSV