PREVIEW / stock_daily / 2002-01-04
file: by_date/stock_daily/2002/2002-01-04.parquet size: 106 KB rows: 3,065 symbols: 1,909
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 |
|---|---|---|---|---|---|---|---|
| 2002-01-04 | AAPL | Stock | 0.4168 | 0.4277 | 0.4105 | 0.423 | 409976000.0 |
| 2002-01-04 | MSFT | Stock | 34.625 | 34.955 | 34.335 | 34.45 | 52731400.0 |
| 2002-01-04 | NVDA | Stock | 0.6055 | 0.6055 | 0.57 | 0.5802 | 936288000.0 |
| 2002-01-04 | AMZN | Stock | 0.601 | 0.62 | 0.5975 | 0.6125 | 253746000.0 |
| 2002-01-04 | CL | Stock | 28.585 | 28.59 | 27.815 | 28.12 | 4467600.0 |
| 2002-01-04 | A | Stock | 22.8183 | 23.5622 | 22.6395 | 23.4478 | 7155244.0 |
| 2002-01-04 | AABA-DELISTED | Stock | 9.5 | 9.90499973297119 | 9.26500034332275 | 9.44999980926514 | 24050200.0 |
| 2002-01-04 | AAI-DELISTED | Stock | 6.8 | 6.92 | 6.7 | 6.85 | 289300.0 |
| 2002-01-04 | AAIC-DELISTED | Stock | 117.0 | 120.4 | 117.0 | 119.6 | 36500.0 |
| 2002-01-04 | AAME | Stock | 2.3 | 2.41 | 2.24 | 2.27 | 800.0 |
| 2002-01-04 | AAON | Stock | 1.8269 | 1.848 | 1.8041 | 1.8436 | 265402.0 |
| 2002-01-04 | AAP | Stock | 15.1 | 15.2 | 13.6667 | 14.1667 | 346500.0 |
| 2002-01-04 | AAXN-DELISTED | Stock | 1.12083327770233 | 1.14166665077209 | 1.10000002384186 | 1.10083329677582 | 234000.0 |
| 2002-01-04 | ABAX-DELISTED | Stock | 5.56 | 5.75 | 5.55 | 5.74 | 29700.0 |
| 2002-01-04 | ABB-DELISTED | Stock | 11.0 | 11.22 | 10.9 | 11.11 | 37500.0 |
| 2002-01-04 | ABC-DELISTED | Stock | 15.36 | 15.36 | 14.7 | 15.03 | 7653200.0 |
| 2002-01-04 | ABCB | Stock | 11.1043 | 11.1043 | 10.8612 | 11.1043 | 3948.0 |
| 2002-01-04 | ABCO-DELISTED | Stock | 14.585 | 14.96 | 14.5 | 14.96 | 56200.0 |
| 2002-01-04 | ABCW-DELISTED | Stock | 18.0 | 18.05 | 17.73 | 17.99 | 28800.0 |
| 2002-01-04 | ABE-DELISTED | Stock | 7.28 | 7.3 | 7.13 | 7.21 | 29600.0 |
| 2002-01-04 | ABFS-DELISTED | Stock | 29.75 | 31.45 | 29.55 | 31.2 | 523600.0 |
| 2002-01-04 | ABK-DELISTED | Stock | 58.1 | 58.6 | 57.14 | 58.2 | 767400.0 |
| 2002-01-04 | ABM | Stock | 15.35 | 15.605 | 15.25 | 15.605 | 111000.0 |
| 2002-01-04 | ABMD-DELISTED | Stock | 15.93 | 16.45 | 15.72 | 16.06 | 280700.0 |
| 2002-01-04 | ABP-DELISTED | Stock | 1.49 | 1.5 | 1.36 | 1.48 | 101600.0 |
| 2002-01-04 | ABT | Stock | 25.1609 | 25.1609 | 24.7838 | 25.0442 | 5953653.0 |
| 2002-01-04 | ABTL-DELISTED | Stock | 9.15 | 9.2 | 8.8 | 9.15 | 19300.0 |
| 2002-01-04 | ABV-DELISTED | Stock | 21.53 | 21.91 | 21.35 | 21.49 | 164400.0 |
| 2002-01-04 | ABVA-DELISTED | Stock | 8.0 | 8.35 | 8.0 | 8.35 | 2000.0 |
| 2002-01-04 | ABX-DELISTED | Stock | 16.5 | 16.65 | 16.37 | 16.61 | 1520500.0 |
| 2002-01-04 | ACAP-DELISTED | Stock | 21.35 | 21.44 | 20.67 | 21.04 | 19000.0 |
| 2002-01-04 | ACAS-DELISTED | Stock | 28.75 | 28.91 | 28.4 | 28.79 | 155900.0 |
| 2002-01-04 | ACAT-DELISTED | Stock | 16.99 | 17.7098 | 16.37 | 17.34 | 31300.0 |
| 2002-01-04 | ACCL-DELISTED | Stock | 9.97103977203369 | 10.3837995529175 | 9.97103977203369 | 10.3837995529175 | 192500.0 |
| 2002-01-04 | ACE-DELISTED | Stock | 39.05 | 39.19 | 38.39 | 38.5 | 1377000.0 |
| 2002-01-04 | ACF-DELISTED | Stock | 30.55 | 32.23 | 30.55 | 32.0 | 1221600.0 |
| 2002-01-04 | ACG-DELISTED | Stock | 7.37 | 7.39 | 7.34 | 7.37 | 993300.0 |
| 2002-01-04 | ACGL | Stock | 3.0322 | 3.0556 | 2.9844 | 2.9844 | 63000.0 |
| 2002-01-04 | ACGN-DELISTED | Stock | 1983.3288 | 2040.0 | 1824.6712 | 1983.3288 | 84300.0 |
| 2002-01-04 | ACH | Stock | 12.3333 | 12.4667 | 12.1 | 12.1 | 74100.0 |
| 2002-01-04 | ACH-DELISTED | Stock | 4.6005 | 4.688 | 4.563 | 4.688 | 1796614.0 |
| 2002-01-04 | ACLS | Stock | 58.68 | 65.04 | 58.44 | 64.16 | 550325.0 |
| 2002-01-04 | ACO-DELISTED | Stock | 7.0 | 7.25 | 7.0 | 7.15 | 32700.0 |
| 2002-01-04 | ACPW-DELISTED | Stock | 33.85 | 34.0 | 30.99 | 31.55 | 42814.0 |
| 2002-01-04 | ACS-DELISTED | Stock | 52.125 | 52.61 | 51.675 | 52.375 | 557000.0 |
| 2002-01-04 | ACTA-DELISTED | Stock | 27.6 | 29.4 | 26.8 | 29.0 | 138400.0 |
| 2002-01-04 | ACTT-DELISTED | Stock | 7.5 | 8.15 | 7.46 | 8.05 | 277600.0 |
| 2002-01-04 | ACTU-DELISTED | Stock | 5.37 | 5.83 | 5.31 | 5.6 | 686400.0 |
| 2002-01-04 | ACXM-DELISTED | Stock | 18.04 | 18.68 | 18.0 | 18.25 | 934500.0 |
| 2002-01-04 | ACY-DELISTED | Stock | 4.87 | 4.87 | 4.85 | 4.85 | 700.0 |
> showing 50 of 3,065 rows — these rows as CSV