PREVIEW / stock_daily / 2006-01-03
file: by_date/stock_daily/2006/2006-01-03.parquet size: 145 KB rows: 4,341 symbols: 2,750
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 |
|---|---|---|---|---|---|---|---|
| 2006-01-03 | AAPL | Stock | 2.585 | 2.6696 | 2.5804 | 2.6696 | 807234400.0 |
| 2006-01-03 | MSFT | Stock | 26.25 | 27.0 | 26.1 | 26.84 | 79973000.0 |
| 2006-01-03 | NVDA | Stock | 0.3064 | 0.3208 | 0.3054 | 0.3185 | 472812000.0 |
| 2006-01-03 | AMZN | Stock | 2.3735 | 2.3925 | 2.3125 | 2.379 | 151644000.0 |
| 2006-01-03 | CL | Stock | 27.49 | 27.56 | 27.255 | 27.455 | 3674200.0 |
| 2006-01-03 | A | Stock | 23.8913 | 24.02 | 23.4764 | 23.9628 | 5307088.0 |
| 2006-01-03 | AABA-DELISTED | Stock | 39.689998626709 | 41.2200012207031 | 38.7900009155273 | 40.9099998474121 | 24227700.0 |
| 2006-01-03 | AACC-DELISTED | Stock | 22.25 | 22.81 | 21.82 | 22.6 | 124470.0 |
| 2006-01-03 | AACQ-DELISTED | Stock | 5.2 | 5.2 | 5.19 | 5.19 | 1300.0 |
| 2006-01-03 | AAI-DELISTED | Stock | 16.26 | 16.39 | 15.72 | 16.32 | 3223100.0 |
| 2006-01-03 | AAIC-DELISTED | Stock | 198.2 | 208.0 | 197.6 | 207.8 | 1824800.0 |
| 2006-01-03 | AAME | Stock | 2.75 | 2.82 | 2.74 | 2.82 | 800.0 |
| 2006-01-03 | AAON | Stock | 2.3704 | 2.3967 | 2.3256 | 2.3954 | 41766.0 |
| 2006-01-03 | AAP | Stock | 43.47 | 43.85 | 43.3 | 43.52 | 1613400.0 |
| 2006-01-03 | AATI-DELISTED | Stock | 13.76 | 14.0 | 13.66 | 13.92 | 240367.0 |
| 2006-01-03 | AAU-DELISTED | Stock | 2.21 | 2.34 | 2.12 | 2.27 | 222600.0 |
| 2006-01-03 | AAUAF-DELISTED | Stock | 2.21 | 2.34 | 2.12 | 2.27 | 222600.0 |
| 2006-01-03 | AAV-DELISTED | Stock | 19.34 | 19.6 | 19.28 | 19.43 | 118000.0 |
| 2006-01-03 | AAWW-DELISTED | Stock | 44.5 | 45.0 | 44.0 | 44.5 | 202100.0 |
| 2006-01-03 | AAXN-DELISTED | Stock | 7.11999988555908 | 7.17999982833862 | 6.94999980926514 | 7.05999994277954 | 1443000.0 |
| 2006-01-03 | ABAX-DELISTED | Stock | 16.44 | 16.8 | 16.23 | 16.7 | 78900.0 |
| 2006-01-03 | ABB-DELISTED | Stock | 10.09 | 10.3699 | 10.04 | 10.18 | 4145400.0 |
| 2006-01-03 | ABBC-DELISTED | Stock | 13.15 | 13.3 | 12.7788 | 13.15 | 28884.0 |
| 2006-01-03 | ABC-DELISTED | Stock | 20.7 | 21.16 | 20.66 | 21.11 | 3675000.0 |
| 2006-01-03 | ABCB | Stock | 19.5307 | 19.5307 | 18.8207 | 19.1708 | 12235.0 |
| 2006-01-03 | ABCO-DELISTED | Stock | 23.76 | 24.05 | 22.67 | 23.94 | 477833.0 |
| 2006-01-03 | ABCW-DELISTED | Stock | 30.4 | 31.08 | 30.34 | 31.02 | 101980.0 |
| 2006-01-03 | ABD-DELISTED | Stock | 24.4 | 24.5 | 24.16 | 24.25 | 358110.0 |
| 2006-01-03 | ABE-DELISTED | Stock | 11.7 | 11.91 | 11.7 | 11.91 | 18100.0 |
| 2006-01-03 | ABFS-DELISTED | Stock | 43.52 | 44.68 | 41.93 | 44.55 | 449215.0 |
| 2006-01-03 | ABG | Stock | 16.11 | 16.52 | 15.85 | 16.33 | 88300.0 |
| 2006-01-03 | ABK-DELISTED | Stock | 77.09 | 78.19 | 76.79 | 78.15 | 346400.0 |
| 2006-01-03 | ABM | Stock | 19.6 | 19.8 | 19.44 | 19.68 | 406200.0 |
| 2006-01-03 | ABMD-DELISTED | Stock | 9.24 | 9.44 | 9.12 | 9.35 | 62586.0 |
| 2006-01-03 | ABP-DELISTED | Stock | 5.24 | 5.56 | 5.24 | 5.53 | 426300.0 |
| 2006-01-03 | ABR | Stock | 26.08 | 26.44 | 25.65 | 26.42 | 106900.0 |
| 2006-01-03 | ABT | Stock | 18.9761 | 19.168 | 18.8034 | 18.9761 | 17258233.0 |
| 2006-01-03 | ABTL-DELISTED | Stock | 25.03 | 25.03 | 23.22 | 24.47 | 21298.0 |
| 2006-01-03 | ABV-DELISTED | Stock | 38.52 | 38.7 | 38.24 | 38.58 | 253000.0 |
| 2006-01-03 | ABVA-DELISTED | Stock | 16.0 | 16.0 | 16.0 | 16.0 | 705.0 |
| 2006-01-03 | ABX-DELISTED | Stock | 28.15 | 28.819 | 28.13 | 28.81 | 6515800.0 |
| 2006-01-03 | ACAD | Stock | 10.0 | 10.1 | 9.95 | 9.99 | 122600.0 |
| 2006-01-03 | ACAP-DELISTED | Stock | 45.75 | 46.47 | 45.25 | 46.42 | 35320.0 |
| 2006-01-03 | ACAS-DELISTED | Stock | 36.11 | 36.67 | 35.7 | 36.51 | 797704.0 |
| 2006-01-03 | ACAT-DELISTED | Stock | 20.05 | 20.67 | 20.05 | 20.63 | 92926.0 |
| 2006-01-03 | ACC-DELISTED | Stock | 24.85 | 24.92 | 24.37 | 24.71 | 160800.0 |
| 2006-01-03 | ACCL-DELISTED | Stock | 7.92 | 8.09 | 7.8 | 7.9 | 52642.0 |
| 2006-01-03 | ACCO | Stock | 24.4 | 24.5 | 24.16 | 24.25 | 363900.0 |
| 2006-01-03 | ACE-DELISTED | Stock | 54.05 | 54.73 | 53.32 | 54.6 | 1129900.0 |
| 2006-01-03 | ACF-DELISTED | Stock | 25.87 | 26.05 | 25.43 | 25.84 | 1455500.0 |
> showing 50 of 4,341 rows — these rows as CSV