PREVIEW / stock_daily / 2008-08-19
file: by_date/stock_daily/2008/2008-08-19.parquet size: 182 KB rows: 5,712 symbols: 3,453
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-08-19 | AAPL | Stock | 6.2336 | 6.3239 | 6.1361 | 6.1975 | 616204400.0 |
| 2008-08-19 | MSFT | Stock | 27.54 | 27.75 | 27.27 | 27.32 | 40332900.0 |
| 2008-08-19 | NVDA | Stock | 0.3238 | 0.3375 | 0.3238 | 0.3355 | 1014140000.0 |
| 2008-08-19 | AMZN | Stock | 4.1545 | 4.1755 | 4.053 | 4.0645 | 132608000.0 |
| 2008-08-19 | TLT | Stock | 93.44 | 93.5265 | 92.89 | 93.05 | 1944609.0 |
| 2008-08-19 | CL | Stock | 38.79 | 39.195 | 38.525 | 38.665 | 4665600.0 |
| 2008-08-19 | A | Stock | 25.4936 | 25.5794 | 25.1144 | 25.2146 | 3299140.0 |
| 2008-08-19 | AABA-DELISTED | Stock | 19.77 | 19.91 | 19.41 | 19.43 | 12535532.0 |
| 2008-08-19 | AACC-DELISTED | Stock | 10.88 | 11.09 | 10.79 | 10.88 | 148151.0 |
| 2008-08-19 | AACG | Stock | 13.5 | 13.5 | 13.01 | 13.05 | 19900.0 |
| 2008-08-19 | AAI-DELISTED | Stock | 3.15 | 3.16 | 2.73 | 2.77 | 3142682.0 |
| 2008-08-19 | AAIC-DELISTED | Stock | 37.4 | 38.6 | 35.6 | 36.2 | 311626.0 |
| 2008-08-19 | AAON | Stock | 4.1975 | 4.1975 | 4.0889 | 4.1165 | 735075.0 |
| 2008-08-19 | AAP | Stock | 44.0 | 44.19 | 42.84 | 42.96 | 1310700.0 |
| 2008-08-19 | AATI-DELISTED | Stock | 4.61 | 4.61 | 4.48 | 4.57 | 192411.0 |
| 2008-08-19 | AAU-DELISTED | Stock | 1.42 | 1.54 | 1.4 | 1.47 | 80420.0 |
| 2008-08-19 | AAUAF-DELISTED | Stock | 1.42 | 1.54 | 1.4 | 1.47 | 83160.0 |
| 2008-08-19 | AAV-DELISTED | Stock | 10.0 | 10.3 | 9.91 | 10.3 | 584079.0 |
| 2008-08-19 | AAWW-DELISTED | Stock | 53.34 | 53.34 | 51.955 | 52.2 | 162070.0 |
| 2008-08-19 | AAXJ | Stock | 48.34 | 48.34 | 48.34 | 48.34 | 100.0 |
| 2008-08-19 | AAXN-DELISTED | Stock | 5.95 | 6.66 | 5.9 | 6.25 | 3094979.0 |
| 2008-08-19 | AB | Stock | 52.0 | 52.0 | 50.16 | 51.42 | 226900.0 |
| 2008-08-19 | ABAX-DELISTED | Stock | 21.76 | 21.94 | 21.453 | 21.59 | 277912.0 |
| 2008-08-19 | ABB-DELISTED | Stock | 23.43 | 23.61 | 23.34 | 23.56 | 2816937.0 |
| 2008-08-19 | ABBC-DELISTED | Stock | 9.86 | 9.94 | 9.81 | 9.91 | 24628.0 |
| 2008-08-19 | ABBNY-DELISTED | Stock | 23.44 | 23.61 | 23.3401 | 23.59 | 2817899.0 |
| 2008-08-19 | ABC-DELISTED | Stock | 20.76 | 20.86 | 20.48 | 20.75 | 2077510.0 |
| 2008-08-19 | ABCB | Stock | 12.2942 | 12.2942 | 11.4286 | 11.8079 | 11823.0 |
| 2008-08-19 | ABCO-DELISTED | Stock | 15.625 | 15.98 | 15.475 | 15.61 | 1059800.0 |
| 2008-08-19 | ABCW-DELISTED | Stock | 7.33 | 7.6 | 7.01 | 7.06 | 251410.0 |
| 2008-08-19 | ABD-DELISTED | Stock | 8.87 | 8.88 | 8.58 | 8.64 | 664130.0 |
| 2008-08-19 | ABE-DELISTED | Stock | 19.27 | 19.3 | 18.92 | 18.92 | 15279.0 |
| 2008-08-19 | ABEO | Stock | 3762.5 | 3762.5 | 3562.5 | 3750.0 | 17.0 |
| 2008-08-19 | ABFS-DELISTED | Stock | 37.16 | 37.16 | 35.58 | 35.94 | 578346.0 |
| 2008-08-19 | ABG | Stock | 12.99 | 13.06 | 12.49 | 12.62 | 245000.0 |
| 2008-08-19 | ABII-DELISTED | Stock | 72.4 | 75.11 | 70.0 | 74.01 | 20535.0 |
| 2008-08-19 | ABK-DELISTED | Stock | 5.7 | 6.17 | 5.62 | 5.64 | 25409387.0 |
| 2008-08-19 | ABM | Stock | 25.41 | 25.51 | 24.77 | 24.95 | 153300.0 |
| 2008-08-19 | ABMD-DELISTED | Stock | 17.76 | 18.33 | 17.75 | 18.08 | 1040517.0 |
| 2008-08-19 | ABR | Stock | 10.49 | 10.49 | 10.0 | 10.05 | 271800.0 |
| 2008-08-19 | ABT | Stock | 28.1403 | 28.5433 | 28.0731 | 28.241 | 7046686.0 |
| 2008-08-19 | ABTL-DELISTED | Stock | 5.9045 | 5.9045 | 5.5991 | 5.65 | 3806.0 |
| 2008-08-19 | ABV-DELISTED | Stock | 59.3 | 60.99 | 59.2 | 60.56 | 513359.0 |
| 2008-08-19 | ABVA-DELISTED | Stock | 2.52 | 3.05 | 2.52 | 2.843 | 12260.0 |
| 2008-08-19 | ABVT-DELISTED | Stock | 65.0 | 65.0 | 65.0 | 65.0 | 300.0 |
| 2008-08-19 | ABX-DELISTED | Stock | 32.45 | 34.23 | 32.41 | 33.46 | 11254751.0 |
| 2008-08-19 | ACAD | Stock | 2.91 | 3.1 | 2.89 | 2.91 | 118500.0 |
| 2008-08-19 | ACAP-DELISTED | Stock | 45.29 | 45.32 | 44.36 | 44.91 | 49857.0 |
| 2008-08-19 | ACAS-DELISTED | Stock | 21.74 | 21.84 | 21.0 | 21.02 | 2528346.0 |
| 2008-08-19 | ACAT-DELISTED | Stock | 10.19 | 10.4 | 9.99 | 10.29 | 60522.0 |
> showing 50 of 5,712 rows — these rows as CSV