PREVIEW / stock_daily / 2004-12-20
file: by_date/stock_daily/2004/2004-12-20.parquet size: 133 KB rows: 3,967 symbols: 2,497
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-12-20 | AAPL | Stock | 1.1691 | 1.1786 | 1.1029 | 1.12 | 1168126400.0 |
| 2004-12-20 | MSFT | Stock | 27.01 | 27.15 | 26.89 | 26.95 | 85552800.0 |
| 2004-12-20 | NVDA | Stock | 0.1944 | 0.1974 | 0.1891 | 0.1901 | 898728000.0 |
| 2004-12-20 | AMZN | Stock | 1.9965 | 2.0245 | 1.9405 | 1.9475 | 144314000.0 |
| 2004-12-20 | CL | Stock | 24.96 | 25.31 | 24.92 | 25.155 | 5314400.0 |
| 2004-12-20 | A | Stock | 17.0959 | 17.3033 | 16.8455 | 16.8598 | 2171234.0 |
| 2004-12-20 | AABA-DELISTED | Stock | 36.8899993896484 | 37.5299987792969 | 36.2099990844727 | 36.6599998474121 | 18330400.0 |
| 2004-12-20 | AACC-DELISTED | Stock | 20.2 | 20.48 | 20.11 | 20.11 | 23670.0 |
| 2004-12-20 | AAI-DELISTED | Stock | 10.55 | 10.64 | 10.45 | 10.46 | 933300.0 |
| 2004-12-20 | AAIC-DELISTED | Stock | 395.8 | 396.4 | 388.2 | 388.2 | 1331800.0 |
| 2004-12-20 | AAME | Stock | 2.95 | 3.0 | 2.95 | 3.0 | 1100.0 |
| 2004-12-20 | AAON | Stock | 1.8779 | 1.9424 | 1.8779 | 1.9042 | 44803.0 |
| 2004-12-20 | AAP | Stock | 28.1533 | 28.16 | 27.5067 | 27.62 | 905550.0 |
| 2004-12-20 | AAV-DELISTED | Stock | 18.02 | 18.12 | 17.84 | 18.02 | 29600.0 |
| 2004-12-20 | AAXN-DELISTED | Stock | 27.6700000762939 | 28.9799995422363 | 27.6700000762939 | 28.3400001525879 | 12563900.0 |
| 2004-12-20 | ABAX-DELISTED | Stock | 14.99 | 14.99 | 14.4 | 14.5 | 156442.0 |
| 2004-12-20 | ABB-DELISTED | Stock | 5.51 | 5.58 | 5.5 | 5.52 | 186900.0 |
| 2004-12-20 | ABBC-DELISTED | Stock | 13.48 | 13.5 | 13.3 | 13.3 | 293019.0 |
| 2004-12-20 | ABC-DELISTED | Stock | 15.44 | 15.63 | 15.33 | 15.49 | 3589600.0 |
| 2004-12-20 | ABCB | Stock | 16.4133 | 16.9158 | 16.4133 | 16.9158 | 6416.0 |
| 2004-12-20 | ABCO-DELISTED | Stock | 18.715 | 18.715 | 18.225 | 18.245 | 291554.0 |
| 2004-12-20 | ABCW-DELISTED | Stock | 28.63 | 29.04 | 28.39 | 28.61 | 36670.0 |
| 2004-12-20 | ABE-DELISTED | Stock | 9.4 | 9.47 | 9.34 | 9.47 | 8400.0 |
| 2004-12-20 | ABFS-DELISTED | Stock | 44.25 | 44.55 | 43.9 | 44.3 | 227670.0 |
| 2004-12-20 | ABG | Stock | 13.7 | 13.92 | 13.59 | 13.79 | 19300.0 |
| 2004-12-20 | ABK-DELISTED | Stock | 82.45 | 83.05 | 81.8 | 82.2 | 371500.0 |
| 2004-12-20 | ABM | Stock | 19.62 | 19.68 | 19.23 | 19.34 | 305100.0 |
| 2004-12-20 | ABMD-DELISTED | Stock | 14.3 | 14.5 | 13.67 | 13.75 | 80494.0 |
| 2004-12-20 | ABP-DELISTED | Stock | 2.48 | 2.54 | 2.45 | 2.49 | 103600.0 |
| 2004-12-20 | ABR | Stock | 24.3 | 24.3 | 23.96 | 23.99 | 27000.0 |
| 2004-12-20 | ABT | Stock | 22.5026 | 22.5554 | 22.1524 | 22.2723 | 10273030.0 |
| 2004-12-20 | ABTL-DELISTED | Stock | 27.05 | 28.2 | 26.75 | 26.8 | 89600.0 |
| 2004-12-20 | ABV-DELISTED | Stock | 28.05 | 28.05 | 26.96 | 27.37 | 372400.0 |
| 2004-12-20 | ABVA-DELISTED | Stock | 14.794 | 14.794 | 14.75 | 14.77 | 2411.0 |
| 2004-12-20 | ABVT-DELISTED | Stock | 29.0 | 35.0 | 29.0 | 32.0 | 21200.0 |
| 2004-12-20 | ABX-DELISTED | Stock | 23.37 | 23.67 | 23.37 | 23.56 | 1543600.0 |
| 2004-12-20 | ACAD | Stock | 6.78 | 6.84 | 6.72 | 6.72 | 4800.0 |
| 2004-12-20 | ACAP-DELISTED | Stock | 37.63 | 37.83 | 37.31 | 37.57 | 120699.0 |
| 2004-12-20 | ACAS-DELISTED | Stock | 32.57 | 32.61 | 32.35 | 32.38 | 476266.0 |
| 2004-12-20 | ACAT-DELISTED | Stock | 26.23 | 26.23 | 25.77 | 25.82 | 44934.0 |
| 2004-12-20 | ACC-DELISTED | Stock | 21.93 | 21.95 | 21.5 | 21.7 | 33200.0 |
| 2004-12-20 | ACCL-DELISTED | Stock | 7.95 | 7.97 | 7.41 | 7.44 | 132313.0 |
| 2004-12-20 | ACE-DELISTED | Stock | 42.45 | 42.65 | 41.98 | 42.18 | 969100.0 |
| 2004-12-20 | ACF-DELISTED | Stock | 22.98 | 23.35 | 22.85 | 23.02 | 1179000.0 |
| 2004-12-20 | ACFC-DELISTED | Stock | 73.37 | 73.37 | 68.88 | 69.29 | 16484.0 |
| 2004-12-20 | ACG-DELISTED | Stock | 8.12 | 8.15 | 8.1 | 8.12 | 465900.0 |
| 2004-12-20 | ACGL | Stock | 4.36 | 4.36 | 4.2889 | 4.3322 | 984600.0 |
| 2004-12-20 | ACGN-DELISTED | Stock | 476.0 | 555.3288 | 464.6712 | 544.0 | 521800.0 |
| 2004-12-20 | ACH | Stock | 19.2267 | 19.2867 | 18.6333 | 18.6333 | 239700.0 |
| 2004-12-20 | ACH-DELISTED | Stock | 14.75 | 14.929 | 14.715 | 14.757 | 471605.0 |
> showing 50 of 3,967 rows — these rows as CSV