PREVIEW / stock_daily / 2004-02-18
file: by_date/stock_daily/2004/2004-02-18.parquet size: 124 KB rows: 3,646 symbols: 2,275
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-02-18 | AAPL | Stock | 0.4139 | 0.4186 | 0.4116 | 0.4154 | 141635200.0 |
| 2004-02-18 | MSFT | Stock | 26.9 | 27.11 | 26.74 | 26.77 | 50334700.0 |
| 2004-02-18 | NVDA | Stock | 0.1969 | 0.1979 | 0.195 | 0.1963 | 320244000.0 |
| 2004-02-18 | AMZN | Stock | 2.268 | 2.2685 | 2.232 | 2.2435 | 159070000.0 |
| 2004-02-18 | CL | Stock | 27.8 | 27.8 | 27.67 | 27.75 | 2639400.0 |
| 2004-02-18 | A | Stock | 25.7511 | 26.2446 | 25.2575 | 25.7368 | 12329102.0 |
| 2004-02-18 | AABA-DELISTED | Stock | 23.2999992370605 | 23.3700008392334 | 23.0 | 23.0450000762939 | 10064000.0 |
| 2004-02-18 | AAI-DELISTED | Stock | 12.89 | 12.91 | 12.52 | 12.54 | 1571100.0 |
| 2004-02-18 | AAIC-DELISTED | Stock | 540.0 | 541.8 | 533.2 | 539.0 | 1620800.0 |
| 2004-02-18 | AAME | Stock | 3.15 | 3.18 | 3.0 | 3.06 | 13900.0 |
| 2004-02-18 | AAON | Stock | 2.5244 | 2.5508 | 2.506 | 2.5389 | 29616.0 |
| 2004-02-18 | AAP | Stock | 28.3667 | 28.5667 | 28.0133 | 28.0133 | 617400.0 |
| 2004-02-18 | AAXN-DELISTED | Stock | 14.9375 | 15.3074998855591 | 14.664999961853 | 14.8500003814697 | 13725600.0 |
| 2004-02-18 | ABAX-DELISTED | Stock | 19.33 | 19.44 | 18.5 | 18.63 | 222939.0 |
| 2004-02-18 | ABB-DELISTED | Stock | 5.96 | 5.99 | 5.85 | 5.94 | 243500.0 |
| 2004-02-18 | ABC-DELISTED | Stock | 14.24 | 14.29 | 14.14 | 14.23 | 2698400.0 |
| 2004-02-18 | ABCB | Stock | 15.4001 | 15.4407 | 15.2867 | 15.3839 | 25169.0 |
| 2004-02-18 | ABCO-DELISTED | Stock | 19.225 | 19.477 | 18.877 | 18.89 | 116711.0 |
| 2004-02-18 | ABCW-DELISTED | Stock | 27.0 | 27.0 | 26.32 | 26.32 | 26220.0 |
| 2004-02-18 | ABE-DELISTED | Stock | 8.26 | 8.4 | 8.22 | 8.33 | 27500.0 |
| 2004-02-18 | ABFS-DELISTED | Stock | 29.011 | 29.29 | 28.44 | 28.71 | 145533.0 |
| 2004-02-18 | ABG | Stock | 18.64 | 18.84 | 17.39 | 17.81 | 50200.0 |
| 2004-02-18 | ABK-DELISTED | Stock | 77.42 | 77.6 | 76.59 | 77.0 | 297700.0 |
| 2004-02-18 | ABM | Stock | 18.3 | 18.71 | 18.23 | 18.38 | 127700.0 |
| 2004-02-18 | ABMD-DELISTED | Stock | 7.3 | 7.3 | 6.95 | 7.0 | 52760.0 |
| 2004-02-18 | ABP-DELISTED | Stock | 2.96 | 3.0 | 2.86 | 2.9 | 397400.0 |
| 2004-02-18 | ABT | Stock | 20.0973 | 20.2005 | 19.9761 | 20.0165 | 12227198.0 |
| 2004-02-18 | ABTL-DELISTED | Stock | 63.55 | 65.5 | 63.0 | 64.4 | 56600.0 |
| 2004-02-18 | ABV-DELISTED | Stock | 25.25 | 25.25 | 24.64 | 25.09 | 818600.0 |
| 2004-02-18 | ABVA-DELISTED | Stock | 18.25 | 18.25 | 18.05 | 18.05 | 14537.0 |
| 2004-02-18 | ABVT-DELISTED | Stock | 48.05 | 48.05 | 47.0 | 48.0 | 3900.0 |
| 2004-02-18 | ABX-DELISTED | Stock | 21.4 | 21.47 | 20.51 | 20.56 | 2119600.0 |
| 2004-02-18 | ACAP-DELISTED | Stock | 19.0 | 19.16 | 18.86 | 18.99 | 12715.0 |
| 2004-02-18 | ACAS-DELISTED | Stock | 34.85 | 34.91 | 33.64 | 34.32 | 694119.0 |
| 2004-02-18 | ACAT-DELISTED | Stock | 26.0 | 26.73 | 25.5 | 25.55 | 44885.0 |
| 2004-02-18 | ACCL-DELISTED | Stock | 13.0412998199463 | 14.6632995605469 | 13.0412998199463 | 14.6632995605469 | 883000.0 |
| 2004-02-18 | ACE-DELISTED | Stock | 44.9 | 44.91 | 44.57 | 44.71 | 1061300.0 |
| 2004-02-18 | ACF-DELISTED | Stock | 19.3 | 19.31 | 18.94 | 19.03 | 1712400.0 |
| 2004-02-18 | ACG-DELISTED | Stock | 8.87 | 8.87 | 8.79 | 8.79 | 553700.0 |
| 2004-02-18 | ACGL | Stock | 4.7744 | 4.7778 | 4.6544 | 4.6567 | 1132200.0 |
| 2004-02-18 | ACGN-DELISTED | Stock | 1416.6712 | 1462.0 | 1416.6712 | 1462.0 | 150500.0 |
| 2004-02-18 | ACH | Stock | 16.96 | 16.9867 | 16.4 | 16.5133 | 159750.0 |
| 2004-02-18 | ACH-DELISTED | Stock | 20.75 | 20.88 | 20.1 | 20.28 | 752000.0 |
| 2004-02-18 | ACLS | Stock | 49.24 | 49.84 | 48.6 | 49.0 | 411375.0 |
| 2004-02-18 | ACO-DELISTED | Stock | 18.52 | 18.9 | 18.46 | 18.7 | 195600.0 |
| 2004-02-18 | ACPW-DELISTED | Stock | 17.55 | 17.8 | 17.1 | 17.35 | 12626.0 |
| 2004-02-18 | ACS-DELISTED | Stock | 51.47 | 51.47 | 50.22 | 50.29 | 1383200.0 |
| 2004-02-18 | ACTA-DELISTED | Stock | 8.0 | 8.2 | 7.6 | 7.8 | 2107000.0 |
| 2004-02-18 | ACTG | Stock | 6.01 | 6.16 | 5.82 | 5.82 | 118900.0 |
| 2004-02-18 | ACTI-DELISTED | Stock | 6.26 | 6.35 | 6.24 | 6.27 | 307097.0 |
> showing 50 of 3,646 rows — these rows as CSV