PREVIEW / stock_daily / 2009-07-08
file: by_date/stock_daily/2009/2009-07-08.parquet size: 179 KB rows: 5,722 symbols: 3,403
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-07-08 | AAPL | Stock | 4.8543 | 4.93 | 4.8007 | 4.9007 | 575929200.0 |
| 2009-07-08 | MSFT | Stock | 22.31 | 22.69 | 22.0 | 22.56 | 73023400.0 |
| 2009-07-08 | NVDA | Stock | 0.2538 | 0.2545 | 0.2428 | 0.2527 | 1205860000.0 |
| 2009-07-08 | AMZN | Stock | 3.823 | 3.8965 | 3.785 | 3.868 | 170814000.0 |
| 2009-07-08 | TLT | Stock | 95.12 | 96.81 | 94.8901 | 96.5 | 7912835.0 |
| 2009-07-08 | ES | Stock | 22.28 | 22.33 | 21.58 | 21.75 | 1467800.0 |
| 2009-07-08 | CL | Stock | 36.46 | 36.815 | 36.35 | 36.67 | 6205400.0 |
| 2009-07-08 | A | Stock | 13.5908 | 13.7053 | 13.2332 | 13.4549 | 4603894.0 |
| 2009-07-08 | AABA-DELISTED | Stock | 14.4 | 14.69 | 14.22 | 14.38 | 14923104.0 |
| 2009-07-08 | AACC-DELISTED | Stock | 7.43 | 7.56 | 7.24 | 7.38 | 45213.0 |
| 2009-07-08 | AACG | Stock | 7.52 | 7.92 | 7.41 | 7.58 | 8100.0 |
| 2009-07-08 | AAI-DELISTED | Stock | 5.99 | 6.085 | 5.74 | 5.85 | 2220251.0 |
| 2009-07-08 | AAIC-DELISTED | Stock | 7.2 | 7.6 | 7.2 | 7.4 | 340687.0 |
| 2009-07-08 | AAON | Stock | 3.9012 | 3.9486 | 3.7946 | 3.8696 | 307294.0 |
| 2009-07-08 | AAP | Stock | 41.91 | 44.28 | 41.67 | 44.15 | 3052400.0 |
| 2009-07-08 | AATI-DELISTED | Stock | 4.31 | 4.34 | 3.9499 | 4.15 | 411925.0 |
| 2009-07-08 | AAU-DELISTED | Stock | 0.6 | 0.64 | 0.551 | 0.56 | 150375.0 |
| 2009-07-08 | AAUAF-DELISTED | Stock | 0.6 | 0.64 | 0.551 | 0.56 | 157575.0 |
| 2009-07-08 | AAV-DELISTED | Stock | 3.58 | 3.85 | 3.46 | 3.6 | 1097692.0 |
| 2009-07-08 | AAWW-DELISTED | Stock | 21.2 | 21.9 | 20.5101 | 20.92 | 189328.0 |
| 2009-07-08 | AAXJ | Stock | 43.3 | 43.3 | 42.0 | 42.45 | 142652.0 |
| 2009-07-08 | AAXN-DELISTED | Stock | 4.47 | 4.49 | 4.22 | 4.28 | 340150.0 |
| 2009-07-08 | AB | Stock | 18.57 | 18.98 | 18.13 | 18.26 | 378300.0 |
| 2009-07-08 | ABAX-DELISTED | Stock | 19.25 | 19.65 | 19.16 | 19.33 | 164212.0 |
| 2009-07-08 | ABB-DELISTED | Stock | 14.8 | 14.91 | 14.44 | 14.7 | 4194795.0 |
| 2009-07-08 | ABBC-DELISTED | Stock | 7.96 | 8.07 | 7.85 | 7.99 | 57338.0 |
| 2009-07-08 | ABBNY-DELISTED | Stock | 14.8 | 14.91 | 14.44 | 14.69 | 4200992.0 |
| 2009-07-08 | ABC-DELISTED | Stock | 18.27 | 18.37 | 17.795 | 17.93 | 3736335.0 |
| 2009-07-08 | ABCB | Stock | 6.1957 | 6.3027 | 5.8164 | 5.9234 | 30330.0 |
| 2009-07-08 | ABCO-DELISTED | Stock | 12.14 | 12.19 | 11.715 | 11.925 | 160510.0 |
| 2009-07-08 | ABCW-DELISTED | Stock | 1.19 | 1.19 | 1.1 | 1.1 | 79410.0 |
| 2009-07-08 | ABD-DELISTED | Stock | 2.77 | 2.83 | 2.4896 | 2.56 | 212230.0 |
| 2009-07-08 | ABE-DELISTED | Stock | 14.36 | 15.2 | 14.36 | 14.65 | 22420.0 |
| 2009-07-08 | ABEO | Stock | 2625.0 | 2625.0 | 2500.0 | 2625.0 | 4.0 |
| 2009-07-08 | ABFS-DELISTED | Stock | 28.13 | 28.14 | 26.71 | 28.0 | 1260207.0 |
| 2009-07-08 | ABG | Stock | 9.07 | 9.46 | 8.95 | 9.35 | 390100.0 |
| 2009-07-08 | ABII-DELISTED | Stock | 35.7 | 36.0001 | 34.26 | 34.36 | 44224.0 |
| 2009-07-08 | ABK-DELISTED | Stock | 0.8 | 0.85 | 0.78 | 0.78 | 3814532.0 |
| 2009-07-08 | ABM | Stock | 17.29 | 17.39 | 16.99 | 17.12 | 199100.0 |
| 2009-07-08 | ABMD-DELISTED | Stock | 8.61 | 8.61 | 8.08 | 8.17 | 464246.0 |
| 2009-07-08 | ABR | Stock | 1.56 | 1.61 | 1.51 | 1.54 | 135100.0 |
| 2009-07-08 | ABT | Stock | 21.8309 | 22.3059 | 21.8309 | 22.2195 | 19459983.0 |
| 2009-07-08 | ABTL-DELISTED | Stock | 2.05 | 2.1245 | 2.025 | 2.1 | 20440.0 |
| 2009-07-08 | ABV-DELISTED | Stock | 63.58 | 64.13 | 62.64 | 63.32 | 1326203.0 |
| 2009-07-08 | ABVT-DELISTED | Stock | 72.46 | 72.46 | 69.2531 | 70.82 | 33460.0 |
| 2009-07-08 | ABX-DELISTED | Stock | 32.46 | 33.05 | 31.06 | 31.4 | 9865864.0 |
| 2009-07-08 | ACAD | Stock | 2.0 | 2.01 | 1.86 | 1.93 | 220700.0 |
| 2009-07-08 | ACAP-DELISTED | Stock | 38.95 | 39.37 | 38.01 | 38.5 | 46870.0 |
| 2009-07-08 | ACAS-DELISTED | Stock | 3.01 | 3.05 | 2.69 | 2.82 | 3231151.0 |
| 2009-07-08 | ACAT-DELISTED | Stock | 3.93 | 3.96 | 3.81 | 3.96 | 15942.0 |
> showing 50 of 5,722 rows — these rows as CSV