PREVIEW / stock_daily / 2004-03-23
file: by_date/stock_daily/2004/2004-03-23.parquet size: 125 KB rows: 3,681 symbols: 2,293
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-03-23 | AAPL | Stock | 0.4621 | 0.4643 | 0.4504 | 0.4516 | 385515200.0 |
| 2004-03-23 | MSFT | Stock | 24.65 | 24.66 | 24.11 | 24.15 | 91696300.0 |
| 2004-03-23 | NVDA | Stock | 0.1858 | 0.1878 | 0.182 | 0.1841 | 576036000.0 |
| 2004-03-23 | AMZN | Stock | 2.066 | 2.087 | 1.9925 | 2.0115 | 224514000.0 |
| 2004-03-23 | CL | Stock | 26.775 | 26.81 | 26.45 | 26.495 | 6473000.0 |
| 2004-03-23 | A | Stock | 21.6023 | 21.6738 | 20.608 | 20.6724 | 6607927.0 |
| 2004-03-23 | AABA-DELISTED | Stock | 22.375 | 22.4200000762939 | 21.9200000762939 | 22.0400009155273 | 18597400.0 |
| 2004-03-23 | AACC-DELISTED | Stock | 17.96 | 17.96 | 17.44 | 17.44 | 112985.0 |
| 2004-03-23 | AAI-DELISTED | Stock | 10.78 | 10.89 | 10.56 | 10.6 | 1203600.0 |
| 2004-03-23 | AAIC-DELISTED | Stock | 533.0 | 540.4 | 528.0 | 528.0 | 1180500.0 |
| 2004-03-23 | AAME | Stock | 3.05 | 3.15 | 2.99 | 3.08 | 11600.0 |
| 2004-03-23 | AAON | Stock | 2.61 | 2.61 | 2.4494 | 2.6087 | 100237.0 |
| 2004-03-23 | AAP | Stock | 25.6867 | 25.9933 | 25.6 | 25.72 | 702300.0 |
| 2004-03-23 | AAXN-DELISTED | Stock | 16.1749992370605 | 16.1875 | 15.102499961853 | 15.2974996566772 | 20158400.0 |
| 2004-03-23 | ABAX-DELISTED | Stock | 18.94 | 19.39 | 18.85 | 18.9 | 90436.0 |
| 2004-03-23 | ABB-DELISTED | Stock | 5.5 | 5.59 | 5.49 | 5.55 | 156800.0 |
| 2004-03-23 | ABC-DELISTED | Stock | 13.39 | 13.45 | 13.14 | 13.23 | 4185600.0 |
| 2004-03-23 | ABCB | Stock | 14.9139 | 15.2948 | 14.9139 | 15.003 | 10364.0 |
| 2004-03-23 | ABCO-DELISTED | Stock | 17.18 | 17.595 | 17.075 | 17.29 | 131968.0 |
| 2004-03-23 | ABCW-DELISTED | Stock | 25.07 | 25.1 | 24.8 | 24.8 | 69920.0 |
| 2004-03-23 | ABE-DELISTED | Stock | 7.96 | 8.0 | 7.94 | 8.0 | 11100.0 |
| 2004-03-23 | ABFS-DELISTED | Stock | 25.71 | 25.71 | 25.25 | 25.43 | 220879.0 |
| 2004-03-23 | ABG | Stock | 15.72 | 16.04 | 15.65 | 16.01 | 88700.0 |
| 2004-03-23 | ABK-DELISTED | Stock | 72.9 | 73.49 | 72.5 | 72.9 | 412300.0 |
| 2004-03-23 | ABM | Stock | 17.25 | 17.8 | 17.12 | 17.42 | 266500.0 |
| 2004-03-23 | ABMD-DELISTED | Stock | 7.65 | 8.11 | 7.65 | 8.1 | 54758.0 |
| 2004-03-23 | ABP-DELISTED | Stock | 2.72 | 2.77 | 2.5 | 2.54 | 418000.0 |
| 2004-03-23 | ABT | Stock | 17.8663 | 18.0907 | 17.8663 | 17.974 | 9696795.0 |
| 2004-03-23 | ABTL-DELISTED | Stock | 61.3 | 63.0 | 59.5 | 60.15 | 75600.0 |
| 2004-03-23 | ABV-DELISTED | Stock | 19.53 | 19.54 | 19.05 | 19.12 | 877800.0 |
| 2004-03-23 | ABVA-DELISTED | Stock | 18.06 | 18.07 | 18.01 | 18.07 | 7950.0 |
| 2004-03-23 | ABVT-DELISTED | Stock | 35.0 | 39.0 | 35.0 | 39.0 | 22300.0 |
| 2004-03-23 | ABX-DELISTED | Stock | 21.99 | 22.39 | 21.87 | 22.29 | 1907000.0 |
| 2004-03-23 | ACAP-DELISTED | Stock | 20.49 | 20.75 | 20.44 | 20.59 | 29939.0 |
| 2004-03-23 | ACAS-DELISTED | Stock | 33.18 | 33.4 | 33.06 | 33.07 | 308924.0 |
| 2004-03-23 | ACAT-DELISTED | Stock | 23.32 | 24.15 | 22.68 | 23.53 | 30603.0 |
| 2004-03-23 | ACCL-DELISTED | Stock | 19.02 | 19.5 | 18.62 | 19.1 | 110711.0 |
| 2004-03-23 | ACE-DELISTED | Stock | 42.01 | 42.44 | 41.58 | 42.18 | 698800.0 |
| 2004-03-23 | ACF-DELISTED | Stock | 17.0 | 17.15 | 16.73 | 16.91 | 1252900.0 |
| 2004-03-23 | ACG-DELISTED | Stock | 8.73 | 8.75 | 8.71 | 8.71 | 619700.0 |
| 2004-03-23 | ACGL | Stock | 4.4444 | 4.4489 | 4.3344 | 4.3722 | 22108500.0 |
| 2004-03-23 | ACGN-DELISTED | Stock | 1156.0 | 1178.6712 | 1133.3288 | 1144.6712 | 121500.0 |
| 2004-03-23 | ACH | Stock | 16.0333 | 16.1667 | 15.9933 | 16.1067 | 283800.0 |
| 2004-03-23 | ACH-DELISTED | Stock | 20.53 | 20.97 | 20.53 | 20.87 | 435139.0 |
| 2004-03-23 | ACLS | Stock | 38.8 | 39.72 | 37.8 | 39.16 | 258525.0 |
| 2004-03-23 | ACO-DELISTED | Stock | 16.1 | 16.61 | 15.94 | 16.36 | 208300.0 |
| 2004-03-23 | ACPW-DELISTED | Stock | 15.35 | 17.05 | 15.35 | 16.65 | 26857.0 |
| 2004-03-23 | ACS-DELISTED | Stock | 49.99 | 49.99 | 48.83 | 49.0 | 1568900.0 |
| 2004-03-23 | ACTA-DELISTED | Stock | 7.2 | 7.4 | 7.0 | 7.2 | 614600.0 |
| 2004-03-23 | ACTG | Stock | 6.56 | 6.6 | 6.5 | 6.5 | 41600.0 |
> showing 50 of 3,681 rows — these rows as CSV