PREVIEW / stock_daily / 2004-01-20
file: by_date/stock_daily/2004/2004-01-20.parquet size: 125 KB rows: 3,656 symbols: 2,284
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-20 | AAPL | Stock | 0.4048 | 0.4071 | 0.3973 | 0.4059 | 315946400.0 |
| 2004-01-20 | MSFT | Stock | 27.98 | 28.2 | 27.93 | 28.1 | 63068500.0 |
| 2004-01-20 | NVDA | Stock | 0.208 | 0.2116 | 0.2057 | 0.2112 | 487764000.0 |
| 2004-01-20 | AMZN | Stock | 2.7785 | 2.842 | 2.7705 | 2.8305 | 154968000.0 |
| 2004-01-20 | CL | Stock | 25.75 | 25.86 | 25.45 | 25.54 | 6880400.0 |
| 2004-01-20 | A | Stock | 24.4993 | 24.5207 | 24.0057 | 24.3276 | 5185601.0 |
| 2004-01-20 | AABA-DELISTED | Stock | 23.9500007629395 | 24.0 | 23.3799991607666 | 23.8299999237061 | 21289000.0 |
| 2004-01-20 | AAI-DELISTED | Stock | 12.85 | 12.87 | 12.35 | 12.54 | 1277100.0 |
| 2004-01-20 | AAIC-DELISTED | Stock | 490.0 | 500.0 | 484.4 | 500.0 | 672900.0 |
| 2004-01-20 | AAME | Stock | 3.1 | 3.1 | 3.01 | 3.09 | 73800.0 |
| 2004-01-20 | AAON | Stock | 2.7878 | 2.9498 | 2.7878 | 2.9498 | 186806.0 |
| 2004-01-20 | AAP | Stock | 27.8733 | 27.8733 | 27.1733 | 27.3933 | 765750.0 |
| 2004-01-20 | AAXN-DELISTED | Stock | 10.2008333206177 | 10.4083337783813 | 9.71666622161865 | 9.875 | 11574000.0 |
| 2004-01-20 | ABAX-DELISTED | Stock | 18.33 | 20.2 | 17.93 | 19.65 | 403180.0 |
| 2004-01-20 | ABB-DELISTED | Stock | 6.05 | 6.14 | 5.9 | 6.02 | 291800.0 |
| 2004-01-20 | ABC-DELISTED | Stock | 13.97 | 14.0 | 13.8 | 13.86 | 3822800.0 |
| 2004-01-20 | ABCB | Stock | 14.2249 | 14.5896 | 14.0871 | 14.5653 | 14683.0 |
| 2004-01-20 | ABCO-DELISTED | Stock | 17.23 | 17.235 | 16.895 | 17.11 | 201122.0 |
| 2004-01-20 | ABCW-DELISTED | Stock | 25.38 | 25.83 | 25.38 | 25.8 | 41270.0 |
| 2004-01-20 | ABE-DELISTED | Stock | 8.71 | 8.8 | 8.55 | 8.72 | 71700.0 |
| 2004-01-20 | ABFS-DELISTED | Stock | 32.11 | 32.58 | 31.87 | 32.28 | 62990.0 |
| 2004-01-20 | ABG | Stock | 19.5 | 19.55 | 18.6 | 18.8 | 44600.0 |
| 2004-01-20 | ABK-DELISTED | Stock | 74.5 | 75.2 | 74.23 | 74.97 | 529000.0 |
| 2004-01-20 | ABM | Stock | 18.55 | 18.73 | 18.36 | 18.72 | 112300.0 |
| 2004-01-20 | ABMD-DELISTED | Stock | 7.15 | 8.399 | 7.11 | 7.91 | 154164.0 |
| 2004-01-20 | ABP-DELISTED | Stock | 1.76 | 1.79 | 1.66 | 1.78 | 401000.0 |
| 2004-01-20 | ABT | Stock | 19.4599 | 19.6349 | 19.397 | 19.4284 | 11832456.0 |
| 2004-01-20 | ABTL-DELISTED | Stock | 54.95 | 60.5 | 54.95 | 59.85 | 136700.0 |
| 2004-01-20 | ABV-DELISTED | Stock | 25.65 | 26.09 | 25.6 | 25.92 | 491800.0 |
| 2004-01-20 | ABVA-DELISTED | Stock | 18.51 | 19.0 | 18.5 | 19.0 | 6615.0 |
| 2004-01-20 | ABX-DELISTED | Stock | 21.1 | 21.45 | 20.96 | 21.12 | 3321600.0 |
| 2004-01-20 | ACAP-DELISTED | Stock | 16.61 | 17.15 | 16.61 | 16.91 | 12335.0 |
| 2004-01-20 | ACAS-DELISTED | Stock | 31.41 | 31.75 | 30.68 | 30.92 | 793165.0 |
| 2004-01-20 | ACAT-DELISTED | Stock | 27.48 | 27.5 | 26.9 | 27.4 | 45250.0 |
| 2004-01-20 | ACCL-DELISTED | Stock | 15.2497997283936 | 15.6045999526978 | 15.2497997283936 | 15.6045999526978 | 487300.0 |
| 2004-01-20 | ACE-DELISTED | Stock | 42.6 | 43.05 | 42.12 | 42.8 | 1327000.0 |
| 2004-01-20 | ACF-DELISTED | Stock | 18.19 | 18.35 | 18.07 | 18.1 | 2073800.0 |
| 2004-01-20 | ACG-DELISTED | Stock | 8.83 | 8.84 | 8.79 | 8.83 | 612100.0 |
| 2004-01-20 | ACGL | Stock | 4.8011 | 4.8333 | 4.7922 | 4.8333 | 921600.0 |
| 2004-01-20 | ACGN-DELISTED | Stock | 1212.6712 | 1235.3288 | 1190.0 | 1224.0 | 161900.0 |
| 2004-01-20 | ACH | Stock | 15.3333 | 15.5933 | 15.1333 | 15.5933 | 228750.0 |
| 2004-01-20 | ACH-DELISTED | Stock | 18.25 | 18.625 | 18.175 | 18.41 | 969200.0 |
| 2004-01-20 | ACLS | Stock | 52.0 | 52.96 | 49.04 | 52.88 | 535325.0 |
| 2004-01-20 | ACO-DELISTED | Stock | 20.75 | 23.0 | 20.15 | 23.0 | 1004500.0 |
| 2004-01-20 | ACPW-DELISTED | Stock | 16.995 | 19.395 | 16.745 | 19.255 | 58618.0 |
| 2004-01-20 | ACS-DELISTED | Stock | 56.78 | 56.78 | 53.38 | 55.18 | 4588700.0 |
| 2004-01-20 | ACTA-DELISTED | Stock | 10.6 | 10.8 | 9.8 | 10.0 | 3552100.0 |
| 2004-01-20 | ACTG | Stock | 6.98 | 7.15 | 6.48 | 6.58 | 253900.0 |
| 2004-01-20 | ACTI-DELISTED | Stock | 7.9 | 7.9 | 7.72 | 7.81 | 130165.0 |
| 2004-01-20 | ACTT-DELISTED | Stock | 1.55 | 1.64 | 1.46 | 1.59 | 628310.0 |
> showing 50 of 3,656 rows — these rows as CSV