PREVIEW / stock_daily / 2008-11-04
file: by_date/stock_daily/2008/2008-11-04.parquet size: 177 KB rows: 5,727 symbols: 3,434
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 |
|---|---|---|---|---|---|---|---|
| 2008-11-04 | AAPL | Stock | 3.9282 | 3.9925 | 3.8096 | 3.9639 | 1398681200.0 |
| 2008-11-04 | MSFT | Stock | 23.13 | 23.66 | 22.87 | 23.53 | 72123000.0 |
| 2008-11-04 | NVDA | Stock | 0.2183 | 0.2245 | 0.2125 | 0.2245 | 619560000.0 |
| 2008-11-04 | AMZN | Stock | 2.858 | 2.9365 | 2.761 | 2.9225 | 153276000.0 |
| 2008-11-04 | TLT | Stock | 92.96 | 94.71 | 92.59 | 94.45 | 1608756.0 |
| 2008-11-04 | CL | Stock | 32.57 | 33.26 | 32.185 | 33.075 | 7230400.0 |
| 2008-11-04 | A | Stock | 16.7954 | 17.9328 | 16.7668 | 17.6252 | 4493731.0 |
| 2008-11-04 | AABA-DELISTED | Stock | 13.03 | 13.49 | 12.84 | 13.36 | 25041683.0 |
| 2008-11-04 | AACC-DELISTED | Stock | 7.61 | 8.22 | 7.4 | 7.52 | 107018.0 |
| 2008-11-04 | AACG | Stock | 8.41 | 8.5 | 8.3 | 8.3 | 15100.0 |
| 2008-11-04 | AAI-DELISTED | Stock | 4.13 | 4.23 | 3.72 | 3.93 | 4882877.0 |
| 2008-11-04 | AAIC-DELISTED | Stock | 12.2 | 14.2 | 12.2 | 13.6 | 684073.0 |
| 2008-11-04 | AAME | Stock | 1.1 | 1.2 | 1.1 | 1.2 | 1800.0 |
| 2008-11-04 | AAON | Stock | 3.5556 | 3.5556 | 3.3817 | 3.4627 | 419175.0 |
| 2008-11-04 | AAP | Stock | 30.68 | 31.46 | 30.02 | 31.42 | 1425300.0 |
| 2008-11-04 | AATI-DELISTED | Stock | 2.93 | 3.08 | 2.73 | 3.06 | 322331.0 |
| 2008-11-04 | AAU-DELISTED | Stock | 0.72 | 0.82 | 0.72 | 0.78 | 42721.0 |
| 2008-11-04 | AAUAF-DELISTED | Stock | 0.72 | 0.82 | 0.72 | 0.78 | 45721.0 |
| 2008-11-04 | AAV-DELISTED | Stock | 6.27 | 6.48 | 6.16 | 6.46 | 807070.0 |
| 2008-11-04 | AAWW-DELISTED | Stock | 21.04 | 23.13 | 21.04 | 22.76 | 421913.0 |
| 2008-11-04 | AAXJ | Stock | 34.08 | 35.63 | 33.57 | 34.99 | 263658.0 |
| 2008-11-04 | AAXN-DELISTED | Stock | 5.35 | 5.38 | 5.21 | 5.34 | 402666.0 |
| 2008-11-04 | AB | Stock | 24.8 | 26.31 | 23.71 | 23.79 | 651300.0 |
| 2008-11-04 | ABAX-DELISTED | Stock | 16.79 | 17.35 | 16.58 | 17.1 | 323378.0 |
| 2008-11-04 | ABB-DELISTED | Stock | 13.23 | 14.16 | 13.22 | 13.94 | 8369795.0 |
| 2008-11-04 | ABBC-DELISTED | Stock | 10.19 | 10.19 | 9.75 | 9.95 | 48857.0 |
| 2008-11-04 | ABBNY-DELISTED | Stock | 13.23 | 14.16 | 13.22 | 13.96 | 8463351.0 |
| 2008-11-04 | ABC-DELISTED | Stock | 15.92 | 15.92 | 15.3 | 15.64 | 4674388.0 |
| 2008-11-04 | ABCB | Stock | 11.1368 | 11.3508 | 10.1933 | 10.9422 | 17478.0 |
| 2008-11-04 | ABCO-DELISTED | Stock | 13.113 | 13.498 | 12.472 | 12.667 | 337371.0 |
| 2008-11-04 | ABCW-DELISTED | Stock | 6.03 | 6.45 | 5.74 | 6.1 | 241740.0 |
| 2008-11-04 | ABD-DELISTED | Stock | 3.06 | 3.13 | 2.68 | 2.76 | 316930.0 |
| 2008-11-04 | ABE-DELISTED | Stock | 13.2 | 14.0 | 13.2 | 13.95 | 30920.0 |
| 2008-11-04 | ABEO | Stock | 2375.0 | 2500.0 | 2375.0 | 2500.0 | 12.0 |
| 2008-11-04 | ABFS-DELISTED | Stock | 28.99 | 30.15 | 28.27 | 29.66 | 397378.0 |
| 2008-11-04 | ABG | Stock | 3.32 | 3.82 | 3.29 | 3.82 | 984700.0 |
| 2008-11-04 | ABII-DELISTED | Stock | 62.5 | 64.64 | 62.08 | 63.14 | 16539.0 |
| 2008-11-04 | ABK-DELISTED | Stock | 3.39 | 3.58 | 3.12 | 3.38 | 36893469.0 |
| 2008-11-04 | ABM | Stock | 16.95 | 17.24 | 16.2 | 16.5 | 228400.0 |
| 2008-11-04 | ABMD-DELISTED | Stock | 15.22 | 15.42 | 15.01 | 15.25 | 314296.0 |
| 2008-11-04 | ABR | Stock | 4.88 | 4.9 | 4.25 | 4.9 | 654700.0 |
| 2008-11-04 | ABT | Stock | 27.3198 | 27.3486 | 26.6625 | 27.0655 | 14427678.0 |
| 2008-11-04 | ABTL-DELISTED | Stock | 3.7 | 3.85 | 3.7 | 3.8 | 1315.0 |
| 2008-11-04 | ABV-DELISTED | Stock | 44.19 | 45.1 | 43.75 | 44.74 | 2185739.0 |
| 2008-11-04 | ABVA-DELISTED | Stock | 3.74 | 3.88 | 3.7 | 3.85 | 5900.0 |
| 2008-11-04 | ABX-DELISTED | Stock | 23.35 | 25.59 | 23.35 | 25.51 | 14522246.0 |
| 2008-11-04 | ACAD | Stock | 1.98 | 2.0 | 1.93 | 1.97 | 73200.0 |
| 2008-11-04 | ACAP-DELISTED | Stock | 42.72 | 42.72 | 38.99 | 39.79 | 66036.0 |
| 2008-11-04 | ACAS-DELISTED | Stock | 14.76 | 16.35 | 14.75 | 15.6 | 3819974.0 |
| 2008-11-04 | ACAT-DELISTED | Stock | 8.37 | 8.93 | 8.15 | 8.24 | 52292.0 |
> showing 50 of 5,727 rows — these rows as CSV