PREVIEW / stock_daily / 2009-06-18
file: by_date/stock_daily/2009/2009-06-18.parquet size: 180 KB rows: 5,750 symbols: 3,431
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-18 | AAPL | Stock | 4.8611 | 4.9286 | 4.8425 | 4.8529 | 427680400.0 |
| 2009-06-18 | MSFT | Stock | 23.62 | 23.69 | 23.3 | 23.5 | 58852200.0 |
| 2009-06-18 | NVDA | Stock | 0.281 | 0.2862 | 0.2735 | 0.2765 | 566376000.0 |
| 2009-06-18 | AMZN | Stock | 4.1405 | 4.1475 | 4.05 | 4.08 | 109062000.0 |
| 2009-06-18 | TLT | Stock | 91.25 | 91.58 | 90.11 | 90.45 | 6794601.0 |
| 2009-06-18 | ES | Stock | 21.65 | 22.41 | 21.65 | 22.37 | 1400200.0 |
| 2009-06-18 | CL | Stock | 34.855 | 35.54 | 34.715 | 35.405 | 5114000.0 |
| 2009-06-18 | A | Stock | 13.1187 | 13.5193 | 12.9971 | 13.3906 | 3287816.0 |
| 2009-06-18 | AABA-DELISTED | Stock | 15.62 | 15.64 | 15.23 | 15.34 | 15948261.0 |
| 2009-06-18 | AACC-DELISTED | Stock | 8.89 | 8.89 | 8.34 | 8.45 | 76061.0 |
| 2009-06-18 | AACG | Stock | 7.08 | 7.35 | 6.87 | 7.35 | 11300.0 |
| 2009-06-18 | AAI-DELISTED | Stock | 5.96 | 5.96 | 5.68 | 5.69 | 3080341.0 |
| 2009-06-18 | AAIC-DELISTED | Stock | 8.2 | 8.4 | 7.2 | 8.0 | 800813.0 |
| 2009-06-18 | AAME | Stock | 0.71 | 0.89 | 0.71 | 0.88 | 6300.0 |
| 2009-06-18 | AAON | Stock | 3.8538 | 3.8716 | 3.7748 | 3.7946 | 314381.0 |
| 2009-06-18 | AAP | Stock | 42.39 | 42.87 | 41.88 | 42.58 | 1310500.0 |
| 2009-06-18 | AATI-DELISTED | Stock | 4.57 | 4.8 | 4.5 | 4.55 | 272944.0 |
| 2009-06-18 | AAU-DELISTED | Stock | 0.7 | 0.7 | 0.66 | 0.67 | 46090.0 |
| 2009-06-18 | AAUAF-DELISTED | Stock | 0.7 | 0.7 | 0.66 | 0.67 | 46390.0 |
| 2009-06-18 | AAV-DELISTED | Stock | 4.87 | 4.96 | 4.64 | 4.86 | 785662.0 |
| 2009-06-18 | AAWW-DELISTED | Stock | 22.66 | 23.61 | 21.71 | 23.4 | 255927.0 |
| 2009-06-18 | AAXJ | Stock | 42.92 | 43.19 | 42.5 | 43.05 | 983002.0 |
| 2009-06-18 | AAXN-DELISTED | Stock | 4.37 | 4.53 | 4.3095 | 4.44 | 436192.0 |
| 2009-06-18 | AB | Stock | 20.38 | 20.73 | 20.2 | 20.44 | 203200.0 |
| 2009-06-18 | ABAX-DELISTED | Stock | 17.5 | 17.95 | 17.5 | 17.75 | 138768.0 |
| 2009-06-18 | ABB-DELISTED | Stock | 15.56 | 15.81 | 15.48 | 15.7 | 5376044.0 |
| 2009-06-18 | ABBC-DELISTED | Stock | 8.51 | 8.75 | 8.37 | 8.74 | 25942.0 |
| 2009-06-18 | ABBNY-DELISTED | Stock | 15.56 | 15.81 | 15.48 | 15.69 | 5480344.0 |
| 2009-06-18 | ABC-DELISTED | Stock | 18.27 | 18.6 | 18.17 | 18.38 | 3090064.0 |
| 2009-06-18 | ABCB | Stock | 6.3416 | 6.6626 | 6.2152 | 6.5848 | 5449.0 |
| 2009-06-18 | ABCO-DELISTED | Stock | 12.783 | 13.017 | 12.733 | 12.937 | 158305.0 |
| 2009-06-18 | ABCW-DELISTED | Stock | 1.1 | 1.1 | 1.05 | 1.06 | 141990.0 |
| 2009-06-18 | ABD-DELISTED | Stock | 3.1401 | 3.1401 | 2.8692 | 3.0899 | 184010.0 |
| 2009-06-18 | ABE-DELISTED | Stock | 14.3 | 14.86 | 14.28 | 14.51 | 40492.0 |
| 2009-06-18 | ABEO | Stock | 2625.0 | 2800.0 | 2625.0 | 2750.0 | 19.0 |
| 2009-06-18 | ABFS-DELISTED | Stock | 29.06 | 31.56 | 27.81 | 30.2 | 1369889.0 |
| 2009-06-18 | ABG | Stock | 10.76 | 10.83 | 10.17 | 10.8 | 285500.0 |
| 2009-06-18 | ABII-DELISTED | Stock | 39.17 | 39.4999 | 37.71 | 38.85 | 37874.0 |
| 2009-06-18 | ABK-DELISTED | Stock | 1.22 | 1.26 | 1.18 | 1.25 | 4866062.0 |
| 2009-06-18 | ABM | Stock | 17.87 | 17.89 | 17.51 | 17.79 | 153300.0 |
| 2009-06-18 | ABMD-DELISTED | Stock | 7.99 | 8.41 | 7.86 | 8.19 | 382098.0 |
| 2009-06-18 | ABR | Stock | 2.05 | 2.09 | 1.97 | 1.97 | 153900.0 |
| 2009-06-18 | ABT | Stock | 22.1044 | 22.992 | 22.1044 | 22.8673 | 31473947.0 |
| 2009-06-18 | ABTL-DELISTED | Stock | 2.3592 | 2.3592 | 2.1495 | 2.15 | 4460.0 |
| 2009-06-18 | ABV-DELISTED | Stock | 64.64 | 65.67 | 64.31 | 65.01 | 656722.0 |
| 2009-06-18 | ABVA-DELISTED | Stock | 2.83 | 3.02 | 2.56 | 3.02 | 1790.0 |
| 2009-06-18 | ABVT-DELISTED | Stock | 75.64 | 76.62 | 75.64 | 76.54 | 32807.0 |
| 2009-06-18 | ABX-DELISTED | Stock | 33.46 | 34.3 | 33.0 | 33.1 | 9993733.0 |
| 2009-06-18 | ACAD | Stock | 2.24 | 2.3 | 2.11 | 2.2 | 117900.0 |
| 2009-06-18 | ACAP-DELISTED | Stock | 38.78 | 39.69 | 38.07 | 39.18 | 30940.0 |
> showing 50 of 5,750 rows — these rows as CSV