PREVIEW / stock_daily / 2004-08-05
file: by_date/stock_daily/2004/2004-08-05.parquet size: 126 KB rows: 3,762 symbols: 2,340
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-05 | AAPL | Stock | 0.568 | 0.5768 | 0.558 | 0.5605 | 244501600.0 |
| 2004-08-05 | MSFT | Stock | 28.16 | 28.21 | 27.52 | 27.53 | 55591700.0 |
| 2004-08-05 | NVDA | Stock | 0.1261 | 0.1267 | 0.1192 | 0.1213 | 859920000.0 |
| 2004-08-05 | AMZN | Stock | 1.8705 | 1.874 | 1.769 | 1.7805 | 168048000.0 |
| 2004-08-05 | CL | Stock | 26.435 | 26.435 | 26.05 | 26.125 | 2023600.0 |
| 2004-08-05 | A | Stock | 16.3662 | 16.5737 | 16.1159 | 16.1302 | 1995925.0 |
| 2004-08-05 | AABA-DELISTED | Stock | 28.4599990844727 | 28.4599990844727 | 26.7000007629395 | 26.7999992370605 | 27642000.0 |
| 2004-08-05 | AACC-DELISTED | Stock | 16.39 | 16.4 | 15.91 | 16.03 | 110746.0 |
| 2004-08-05 | AAI-DELISTED | Stock | 10.57 | 10.57 | 10.05 | 10.06 | 943200.0 |
| 2004-08-05 | AAIC-DELISTED | Stock | 322.2 | 329.0 | 321.8 | 321.8 | 1363200.0 |
| 2004-08-05 | AAME | Stock | 2.96 | 2.96 | 2.95 | 2.96 | 1400.0 |
| 2004-08-05 | AAON | Stock | 2.1728 | 2.2268 | 2.1426 | 2.2058 | 147319.0 |
| 2004-08-05 | AAP | Stock | 23.9267 | 23.94 | 22.8667 | 23.0 | 1541250.0 |
| 2004-08-05 | AAV-DELISTED | Stock | 14.77 | 14.82 | 14.61 | 14.77 | 18600.0 |
| 2004-08-05 | AAXN-DELISTED | Stock | 14.5450000762939 | 14.6850004196167 | 14.0 | 14.1999998092651 | 7383200.0 |
| 2004-08-05 | ABAX-DELISTED | Stock | 14.45 | 14.63 | 14.16 | 14.26 | 136696.0 |
| 2004-08-05 | ABB-DELISTED | Stock | 5.5 | 5.51 | 5.4 | 5.4 | 504900.0 |
| 2004-08-05 | ABC-DELISTED | Stock | 13.55 | 13.66 | 13.37 | 13.38 | 3916000.0 |
| 2004-08-05 | ABCB | Stock | 13.852 | 14.1682 | 13.8196 | 13.8196 | 20357.0 |
| 2004-08-05 | ABCO-DELISTED | Stock | 15.565 | 15.695 | 15.39 | 15.42 | 120814.0 |
| 2004-08-05 | ABCW-DELISTED | Stock | 25.15 | 25.42 | 25.0 | 25.08 | 46970.0 |
| 2004-08-05 | ABE-DELISTED | Stock | 7.61 | 7.67 | 7.61 | 7.63 | 1600.0 |
| 2004-08-05 | ABFS-DELISTED | Stock | 35.58 | 35.8 | 34.01 | 34.02 | 413741.0 |
| 2004-08-05 | ABG | Stock | 13.86 | 13.93 | 13.55 | 13.65 | 64500.0 |
| 2004-08-05 | ABK-DELISTED | Stock | 71.58 | 71.75 | 70.23 | 70.27 | 311200.0 |
| 2004-08-05 | ABM | Stock | 17.75 | 17.79 | 17.19 | 17.25 | 119800.0 |
| 2004-08-05 | ABMD-DELISTED | Stock | 10.51 | 10.77 | 10.46 | 10.77 | 79171.0 |
| 2004-08-05 | ABP-DELISTED | Stock | 1.3 | 1.34 | 1.29 | 1.29 | 73200.0 |
| 2004-08-05 | ABR | Stock | 19.02 | 19.3 | 19.0 | 19.0 | 165800.0 |
| 2004-08-05 | ABT | Stock | 18.6882 | 18.8178 | 18.5683 | 18.5731 | 5597957.0 |
| 2004-08-05 | ABTL-DELISTED | Stock | 32.6 | 33.05 | 31.0 | 31.05 | 33400.0 |
| 2004-08-05 | ABV-DELISTED | Stock | 20.25 | 20.5 | 19.73 | 19.92 | 223100.0 |
| 2004-08-05 | ABVA-DELISTED | Stock | 14.94 | 14.94 | 14.75 | 14.75 | 500.0 |
| 2004-08-05 | ABVT-DELISTED | Stock | 27.55 | 27.55 | 27.5 | 27.5 | 8600.0 |
| 2004-08-05 | ABX-DELISTED | Stock | 19.02 | 19.12 | 18.61 | 18.65 | 988300.0 |
| 2004-08-05 | ACAD | Stock | 5.8 | 5.8 | 5.2 | 5.23 | 15600.0 |
| 2004-08-05 | ACAP-DELISTED | Stock | 28.42 | 28.42 | 27.32 | 27.63 | 53849.0 |
| 2004-08-05 | ACAS-DELISTED | Stock | 30.19 | 30.32 | 29.85 | 29.91 | 1025203.0 |
| 2004-08-05 | ACAT-DELISTED | Stock | 27.25 | 27.9 | 26.95 | 26.97 | 99088.0 |
| 2004-08-05 | ACCL-DELISTED | Stock | 6.92 | 7.15 | 6.58 | 6.71 | 118003.0 |
| 2004-08-05 | ACE-DELISTED | Stock | 39.61 | 39.66 | 38.69 | 38.71 | 1014400.0 |
| 2004-08-05 | ACF-DELISTED | Stock | 18.73 | 18.73 | 18.12 | 18.14 | 871200.0 |
| 2004-08-05 | ACG-DELISTED | Stock | 8.18 | 8.18 | 8.12 | 8.13 | 450600.0 |
| 2004-08-05 | ACGL | Stock | 4.2511 | 4.3011 | 4.2044 | 4.23 | 695700.0 |
| 2004-08-05 | ACGN-DELISTED | Stock | 498.6712 | 544.0 | 498.6712 | 544.0 | 52400.0 |
| 2004-08-05 | ACH | Stock | 17.1667 | 17.1733 | 16.3267 | 16.3333 | 306900.0 |
| 2004-08-05 | ACH-DELISTED | Stock | 11.576 | 11.726 | 11.393 | 11.413 | 369997.0 |
| 2004-08-05 | ACLS | Stock | 35.92 | 36.44 | 34.88 | 35.32 | 139750.0 |
| 2004-08-05 | ACO-DELISTED | Stock | 19.85 | 19.93 | 19.33 | 19.44 | 229000.0 |
| 2004-08-05 | ACPW-DELISTED | Stock | 15.302 | 16.748 | 15.302 | 16.648 | 44796.0 |
> showing 50 of 3,762 rows — these rows as CSV