PREVIEW / stock_daily / 2004-01-06
file: by_date/stock_daily/2004/2004-01-06.parquet size: 124 KB rows: 3,618 symbols: 2,255
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-01-06 | AAPL | Stock | 0.3973 | 0.4004 | 0.3877 | 0.3945 | 509348000.0 |
| 2004-01-06 | MSFT | Stock | 28.19 | 28.28 | 28.07 | 28.24 | 46950800.0 |
| 2004-01-06 | NVDA | Stock | 0.198 | 0.2094 | 0.1971 | 0.2067 | 1093344000.0 |
| 2004-01-06 | AMZN | Stock | 2.6555 | 2.675 | 2.637 | 2.6515 | 119710000.0 |
| 2004-01-06 | CL | Stock | 25.0 | 25.27 | 24.935 | 25.19 | 9328400.0 |
| 2004-01-06 | A | Stock | 21.1373 | 21.8169 | 21.0801 | 21.8026 | 4921100.0 |
| 2004-01-06 | AABA-DELISTED | Stock | 23.2199993133545 | 23.7250003814697 | 23.1749992370605 | 23.6200008392334 | 20527800.0 |
| 2004-01-06 | AAI-DELISTED | Stock | 12.37 | 13.17 | 12.3 | 13.12 | 2421100.0 |
| 2004-01-06 | AAIC-DELISTED | Stock | 474.4 | 484.0 | 473.0 | 482.0 | 834500.0 |
| 2004-01-06 | AAME | Stock | 3.15 | 3.24 | 3.15 | 3.19 | 15400.0 |
| 2004-01-06 | AAON | Stock | 2.452 | 2.5402 | 2.452 | 2.5402 | 173897.0 |
| 2004-01-06 | AAP | Stock | 26.9333 | 27.6467 | 26.9267 | 27.3733 | 788850.0 |
| 2004-01-06 | AAXN-DELISTED | Stock | 7.0 | 7.35833311080933 | 6.91750001907349 | 7.2649998664856 | 3644400.0 |
| 2004-01-06 | ABAX-DELISTED | Stock | 15.35 | 17.33 | 15.35 | 17.13 | 715544.0 |
| 2004-01-06 | ABB-DELISTED | Stock | 5.15 | 5.2 | 5.11 | 5.16 | 50900.0 |
| 2004-01-06 | ABC-DELISTED | Stock | 13.96 | 13.96 | 13.8 | 13.9 | 14203200.0 |
| 2004-01-06 | ABCB | Stock | 13.6413 | 13.771 | 13.3414 | 13.5035 | 9006.0 |
| 2004-01-06 | ABCO-DELISTED | Stock | 17.585 | 17.585 | 17.17 | 17.44 | 97570.0 |
| 2004-01-06 | ABCW-DELISTED | Stock | 25.07 | 25.23 | 25.01 | 25.05 | 68070.0 |
| 2004-01-06 | ABE-DELISTED | Stock | 7.83 | 7.86 | 7.7 | 7.76 | 29500.0 |
| 2004-01-06 | ABFS-DELISTED | Stock | 31.98 | 32.12 | 31.56 | 31.56 | 64492.0 |
| 2004-01-06 | ABG | Stock | 18.44 | 18.46 | 18.12 | 18.15 | 23500.0 |
| 2004-01-06 | ABK-DELISTED | Stock | 70.23 | 70.25 | 69.86 | 70.0 | 364600.0 |
| 2004-01-06 | ABM | Stock | 17.65 | 17.94 | 17.53 | 17.7 | 116700.0 |
| 2004-01-06 | ABMD-DELISTED | Stock | 7.04 | 7.04 | 6.71 | 6.99 | 28966.0 |
| 2004-01-06 | ABP-DELISTED | Stock | 1.68 | 1.71 | 1.55 | 1.6 | 343200.0 |
| 2004-01-06 | ABT | Stock | 20.8514 | 20.9592 | 20.7213 | 20.8335 | 7790584.0 |
| 2004-01-06 | ABTL-DELISTED | Stock | 46.5 | 50.15 | 46.5 | 50.0 | 153200.0 |
| 2004-01-06 | ABV-DELISTED | Stock | 26.8 | 26.87 | 26.4 | 26.5 | 488100.0 |
| 2004-01-06 | ABX-DELISTED | Stock | 23.5 | 23.53 | 22.77 | 22.94 | 2637300.0 |
| 2004-01-06 | ACAP-DELISTED | Stock | 18.11 | 18.25 | 17.79 | 17.95 | 18284.0 |
| 2004-01-06 | ACAS-DELISTED | Stock | 29.55 | 29.72 | 29.39 | 29.5 | 339764.0 |
| 2004-01-06 | ACAT-DELISTED | Stock | 25.59 | 25.88 | 24.47 | 24.47 | 27397.0 |
| 2004-01-06 | ACCL-DELISTED | Stock | 11.9399995803833 | 12.1000003814697 | 11.2959995269775 | 11.5790004730225 | 186200.0 |
| 2004-01-06 | ACE-DELISTED | Stock | 41.3 | 41.52 | 40.85 | 41.39 | 798600.0 |
| 2004-01-06 | ACF-DELISTED | Stock | 16.15 | 16.26 | 16.01 | 16.16 | 1484800.0 |
| 2004-01-06 | ACG-DELISTED | Stock | 8.61 | 8.66 | 8.59 | 8.65 | 533600.0 |
| 2004-01-06 | ACGL | Stock | 4.4822 | 4.4822 | 4.4278 | 4.45 | 347400.0 |
| 2004-01-06 | ACGN-DELISTED | Stock | 1246.6712 | 1246.6712 | 1178.6712 | 1212.6712 | 112800.0 |
| 2004-01-06 | ACH | Stock | 15.2067 | 15.3467 | 15.1067 | 15.2 | 298500.0 |
| 2004-01-06 | ACH-DELISTED | Stock | 19.5 | 19.503 | 18.525 | 18.835 | 3035200.0 |
| 2004-01-06 | ACLS | Stock | 42.2 | 44.0 | 42.2 | 43.2 | 321525.0 |
| 2004-01-06 | ACO-DELISTED | Stock | 23.45 | 23.45 | 22.67 | 22.97 | 414000.0 |
| 2004-01-06 | ACPW-DELISTED | Stock | 15.4 | 15.5 | 14.7 | 15.5 | 22950.0 |
| 2004-01-06 | ACS-DELISTED | Stock | 56.82 | 57.54 | 56.45 | 57.46 | 934100.0 |
| 2004-01-06 | ACTA-DELISTED | Stock | 7.0 | 7.2 | 6.6 | 7.0 | 1406200.0 |
| 2004-01-06 | ACTG | Stock | 5.2 | 5.75 | 5.15 | 5.7 | 204100.0 |
| 2004-01-06 | ACTI-DELISTED | Stock | 7.87 | 7.9 | 7.58 | 7.67 | 473230.0 |
| 2004-01-06 | ACTT-DELISTED | Stock | 1.23 | 1.3 | 1.18 | 1.28 | 220408.0 |
| 2004-01-06 | ACTU-DELISTED | Stock | 3.35 | 3.4 | 3.32 | 3.35 | 226518.0 |
> showing 50 of 3,618 rows — these rows as CSV