PREVIEW / stock_daily / 2004-07-01
file: by_date/stock_daily/2004/2004-07-01.parquet size: 126 KB rows: 3,746 symbols: 2,331
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-07-01 | AAPL | Stock | 0.5732 | 0.58 | 0.5696 | 0.5768 | 341941600.0 |
| 2004-07-01 | MSFT | Stock | 28.7 | 28.84 | 28.26 | 28.63 | 78441400.0 |
| 2004-07-01 | NVDA | Stock | 0.1725 | 0.1727 | 0.1625 | 0.1627 | 505620000.0 |
| 2004-07-01 | AMZN | Stock | 2.69 | 2.702 | 2.6025 | 2.628 | 144238000.0 |
| 2004-07-01 | CL | Stock | 29.3 | 29.485 | 29.3 | 29.365 | 3957200.0 |
| 2004-07-01 | A | Stock | 20.8298 | 20.8512 | 20.1359 | 20.4864 | 4608787.0 |
| 2004-07-01 | AABA-DELISTED | Stock | 35.1399993896484 | 35.3400001525879 | 34.1100006103516 | 34.2999992370605 | 28525400.0 |
| 2004-07-01 | AACC-DELISTED | Stock | 17.34 | 17.34 | 16.88 | 17.09 | 81591.0 |
| 2004-07-01 | AAI-DELISTED | Stock | 14.11 | 14.2 | 13.91 | 14.05 | 1488900.0 |
| 2004-07-01 | AAIC-DELISTED | Stock | 396.4 | 396.8 | 387.0 | 389.8 | 1308700.0 |
| 2004-07-01 | AAME | Stock | 2.71 | 2.77 | 2.61 | 2.66 | 7500.0 |
| 2004-07-01 | AAON | Stock | 2.614 | 2.614 | 2.5481 | 2.5481 | 91125.0 |
| 2004-07-01 | AAP | Stock | 29.3667 | 29.4 | 29.12 | 29.18 | 940800.0 |
| 2004-07-01 | AAV-DELISTED | Stock | 14.2 | 14.2 | 14.1 | 14.2 | 2800.0 |
| 2004-07-01 | AAXN-DELISTED | Stock | 21.6000003814697 | 22.1450004577637 | 20.8500003814697 | 21.8500003814697 | 28522000.0 |
| 2004-07-01 | ABAX-DELISTED | Stock | 18.62 | 19.07 | 17.7 | 18.09 | 473712.0 |
| 2004-07-01 | ABB-DELISTED | Stock | 5.58 | 5.58 | 5.49 | 5.53 | 519600.0 |
| 2004-07-01 | ABC-DELISTED | Stock | 14.14 | 14.14 | 13.58 | 13.93 | 22335200.0 |
| 2004-07-01 | ABCB | Stock | 16.4944 | 16.5268 | 15.9027 | 15.9027 | 8513.0 |
| 2004-07-01 | ABCO-DELISTED | Stock | 17.795 | 17.99 | 17.605 | 17.81 | 166192.0 |
| 2004-07-01 | ABCW-DELISTED | Stock | 26.4 | 26.54 | 25.78 | 25.78 | 56750.0 |
| 2004-07-01 | ABE-DELISTED | Stock | 7.75 | 7.8 | 7.63 | 7.63 | 26900.0 |
| 2004-07-01 | ABFS-DELISTED | Stock | 32.73 | 33.05 | 32.27 | 32.28 | 238085.0 |
| 2004-07-01 | ABG | Stock | 14.95 | 15.1 | 14.73 | 14.82 | 43500.0 |
| 2004-07-01 | ABK-DELISTED | Stock | 73.19 | 73.25 | 72.07 | 72.55 | 566000.0 |
| 2004-07-01 | ABM | Stock | 19.37 | 19.49 | 18.96 | 19.05 | 136200.0 |
| 2004-07-01 | ABMD-DELISTED | Stock | 12.42 | 12.64 | 12.25 | 12.388 | 138605.0 |
| 2004-07-01 | ABP-DELISTED | Stock | 1.68 | 1.69 | 1.65 | 1.68 | 39400.0 |
| 2004-07-01 | ABR | Stock | 19.55 | 19.77 | 19.5 | 19.5 | 57500.0 |
| 2004-07-01 | ABT | Stock | 19.5758 | 19.7438 | 19.2928 | 19.5375 | 8998333.0 |
| 2004-07-01 | ABTL-DELISTED | Stock | 45.5 | 46.6 | 43.8 | 44.3 | 101900.0 |
| 2004-07-01 | ABV-DELISTED | Stock | 20.03 | 20.33 | 20.02 | 20.05 | 478900.0 |
| 2004-07-01 | ABVA-DELISTED | Stock | 15.25 | 15.25 | 15.25 | 15.25 | 2900.0 |
| 2004-07-01 | ABVT-DELISTED | Stock | 27.0 | 28.99 | 27.0 | 28.99 | 300.0 |
| 2004-07-01 | ABX-DELISTED | Stock | 19.84 | 19.84 | 19.51 | 19.54 | 750174.0 |
| 2004-07-01 | ACAD | Stock | 6.32 | 6.39 | 6.25 | 6.3 | 3100.0 |
| 2004-07-01 | ACAP-DELISTED | Stock | 23.49 | 23.98 | 23.19 | 23.54 | 31495.0 |
| 2004-07-01 | ACAS-DELISTED | Stock | 28.11 | 28.24 | 27.63 | 27.74 | 411599.0 |
| 2004-07-01 | ACAT-DELISTED | Stock | 27.25 | 27.84 | 26.97 | 27.52 | 76949.0 |
| 2004-07-01 | ACCL-DELISTED | Stock | 10.06 | 10.06 | 9.469 | 9.48 | 145633.0 |
| 2004-07-01 | ACE-DELISTED | Stock | 42.22 | 42.92 | 41.92 | 42.11 | 899298.0 |
| 2004-07-01 | ACF-DELISTED | Stock | 19.58 | 19.85 | 19.2 | 19.71 | 1206400.0 |
| 2004-07-01 | ACG-DELISTED | Stock | 7.86 | 7.91 | 7.82 | 7.874 | 577100.0 |
| 2004-07-01 | ACGL | Stock | 4.4367 | 4.47 | 4.41 | 4.4444 | 1518300.0 |
| 2004-07-01 | ACGN-DELISTED | Stock | 736.6712 | 736.6712 | 680.0 | 725.3288 | 123700.0 |
| 2004-07-01 | ACH | Stock | 17.2733 | 17.4 | 16.68 | 16.68 | 256350.0 |
| 2004-07-01 | ACH-DELISTED | Stock | 13.576 | 13.591 | 13.126 | 13.226 | 556784.0 |
| 2004-07-01 | ACLS | Stock | 49.6 | 50.04 | 47.6 | 47.64 | 216950.0 |
| 2004-07-01 | ACO-DELISTED | Stock | 19.0 | 19.2 | 18.6 | 18.85 | 117200.0 |
| 2004-07-01 | ACPW-DELISTED | Stock | 15.55 | 16.0 | 15.55 | 15.75 | 14977.0 |
> showing 50 of 3,746 rows — these rows as CSV