PREVIEW / stock_daily / 2004-08-17
file: by_date/stock_daily/2004/2004-08-17.parquet size: 127 KB rows: 3,810 symbols: 2,380
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 |
|---|---|---|---|---|---|---|---|
| 2004-08-17 | AAPL | Stock | 0.5461 | 0.5559 | 0.542 | 0.5513 | 323019200.0 |
| 2004-08-17 | MSFT | Stock | 27.22 | 27.38 | 26.98 | 27.05 | 56879700.0 |
| 2004-08-17 | NVDA | Stock | 0.0886 | 0.0919 | 0.0877 | 0.0914 | 744912000.0 |
| 2004-08-17 | AMZN | Stock | 1.9285 | 1.972 | 1.895 | 1.9115 | 223260000.0 |
| 2004-08-17 | CL | Stock | 26.075 | 26.125 | 25.75 | 25.81 | 2912600.0 |
| 2004-08-17 | A | Stock | 14.9642 | 15.2289 | 14.9142 | 15.1574 | 4587677.0 |
| 2004-08-17 | AABA-DELISTED | Stock | 28.6299991607666 | 29.1599998474121 | 28.1700000762939 | 28.3400001525879 | 19609800.0 |
| 2004-08-17 | AACC-DELISTED | Stock | 17.81 | 17.82 | 17.55 | 17.72 | 12563.0 |
| 2004-08-17 | AAI-DELISTED | Stock | 10.72 | 11.11 | 10.7 | 10.73 | 1511800.0 |
| 2004-08-17 | AAIC-DELISTED | Stock | 331.2 | 341.0 | 331.2 | 338.4 | 1845900.0 |
| 2004-08-17 | AAME | Stock | 3.0 | 3.01 | 2.95 | 3.0 | 10300.0 |
| 2004-08-17 | AAON | Stock | 2.2123 | 2.2611 | 2.19 | 2.2242 | 53916.0 |
| 2004-08-17 | AAP | Stock | 23.1 | 23.7533 | 23.02 | 23.7333 | 1652250.0 |
| 2004-08-17 | AAV-DELISTED | Stock | 14.23 | 14.4 | 14.07 | 14.23 | 30300.0 |
| 2004-08-17 | AAXN-DELISTED | Stock | 13.210000038147 | 13.3999996185303 | 13.0500001907349 | 13.1700000762939 | 6578200.0 |
| 2004-08-17 | ABAX-DELISTED | Stock | 13.35 | 13.5 | 13.07 | 13.25 | 72376.0 |
| 2004-08-17 | ABB-DELISTED | Stock | 5.41 | 5.42 | 5.32 | 5.35 | 108800.0 |
| 2004-08-17 | ABC-DELISTED | Stock | 12.88 | 13.02 | 12.86 | 12.97 | 4450000.0 |
| 2004-08-17 | ABCB | Stock | 14.0709 | 14.0709 | 13.8602 | 14.0222 | 6538.0 |
| 2004-08-17 | ABCO-DELISTED | Stock | 15.23 | 15.26 | 15.075 | 15.15 | 56271.0 |
| 2004-08-17 | ABCW-DELISTED | Stock | 24.95 | 25.42 | 24.8 | 25.31 | 38020.0 |
| 2004-08-17 | ABE-DELISTED | Stock | 7.45 | 7.5 | 7.45 | 7.47 | 3300.0 |
| 2004-08-17 | ABFS-DELISTED | Stock | 36.25 | 36.85 | 35.67 | 36.2 | 280471.0 |
| 2004-08-17 | ABG | Stock | 13.2 | 13.6 | 13.2 | 13.43 | 55000.0 |
| 2004-08-17 | ABK-DELISTED | Stock | 71.25 | 71.45 | 70.68 | 70.69 | 292500.0 |
| 2004-08-17 | ABM | Stock | 17.64 | 17.85 | 17.57 | 17.6 | 59100.0 |
| 2004-08-17 | ABMD-DELISTED | Stock | 10.27 | 10.32 | 9.65 | 9.83 | 31142.0 |
| 2004-08-17 | ABP-DELISTED | Stock | 1.6 | 1.78 | 1.56 | 1.67 | 93400.0 |
| 2004-08-17 | ABR | Stock | 19.5 | 20.15 | 19.4 | 20.08 | 39800.0 |
| 2004-08-17 | ABT | Stock | 19.3839 | 19.3839 | 19.144 | 19.192 | 8861817.0 |
| 2004-08-17 | ABTL-DELISTED | Stock | 36.15 | 36.15 | 32.4 | 32.4 | 44900.0 |
| 2004-08-17 | ABV-DELISTED | Stock | 22.18 | 22.49 | 21.75 | 21.75 | 392200.0 |
| 2004-08-17 | ABVA-DELISTED | Stock | 15.09 | 15.09 | 14.25 | 14.53 | 9470.0 |
| 2004-08-17 | ABVT-DELISTED | Stock | 27.5 | 27.5 | 27.5 | 27.5 | 3000.0 |
| 2004-08-17 | ABX-DELISTED | Stock | 18.94 | 19.29 | 18.88 | 19.18 | 1009900.0 |
| 2004-08-17 | ACAD | Stock | 5.3 | 5.75 | 5.27 | 5.7 | 9800.0 |
| 2004-08-17 | ACAP-DELISTED | Stock | 27.74 | 27.75 | 27.28 | 27.43 | 42986.0 |
| 2004-08-17 | ACAS-DELISTED | Stock | 31.1 | 31.35 | 30.9 | 31.3 | 920849.0 |
| 2004-08-17 | ACAT-DELISTED | Stock | 26.16 | 26.32 | 25.91 | 26.02 | 60851.0 |
| 2004-08-17 | ACC-DELISTED | Stock | 17.35 | 17.4 | 17.15 | 17.34 | 295000.0 |
| 2004-08-17 | ACCL-DELISTED | Stock | 6.17 | 6.28 | 5.77 | 5.93 | 129802.0 |
| 2004-08-17 | ACE-DELISTED | Stock | 39.15 | 39.44 | 38.83 | 38.89 | 847900.0 |
| 2004-08-17 | ACF-DELISTED | Stock | 20.39 | 20.7 | 20.15 | 20.34 | 983700.0 |
| 2004-08-17 | ACG-DELISTED | Stock | 8.34 | 8.34 | 8.29 | 8.33 | 534900.0 |
| 2004-08-17 | ACGL | Stock | 4.1911 | 4.2278 | 4.1444 | 4.1756 | 933300.0 |
| 2004-08-17 | ACGN-DELISTED | Stock | 612.0 | 657.3288 | 612.0 | 657.3288 | 76800.0 |
| 2004-08-17 | ACH | Stock | 16.4267 | 16.4267 | 16.1533 | 16.3733 | 131250.0 |
| 2004-08-17 | ACH-DELISTED | Stock | 10.832 | 10.907 | 10.777 | 10.857 | 335029.0 |
| 2004-08-17 | ACLS | Stock | 32.6 | 33.6 | 32.0 | 33.12 | 245400.0 |
| 2004-08-17 | ACO-DELISTED | Stock | 18.08 | 18.15 | 17.64 | 18.01 | 106900.0 |
> showing 50 of 3,810 rows — these rows as CSV