PREVIEW / stock_daily / 2009-07-06
file: by_date/stock_daily/2009/2009-07-06.parquet size: 180 KB rows: 5,769 symbols: 3,433
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-06 | AAPL | Stock | 4.9536 | 4.9639 | 4.8661 | 4.9504 | 498688400.0 |
| 2009-07-06 | MSFT | Stock | 23.21 | 23.28 | 22.87 | 23.2 | 49207700.0 |
| 2009-07-06 | NVDA | Stock | 0.2723 | 0.2725 | 0.2592 | 0.2638 | 752456000.0 |
| 2009-07-06 | AMZN | Stock | 3.9225 | 3.9445 | 3.827 | 3.905 | 147376000.0 |
| 2009-07-06 | TLT | Stock | 94.05 | 94.29 | 93.39 | 94.12 | 1886697.0 |
| 2009-07-06 | ES | Stock | 22.19 | 22.75 | 22.11 | 22.5 | 1241600.0 |
| 2009-07-06 | CL | Stock | 36.09 | 37.245 | 35.79 | 37.19 | 10624800.0 |
| 2009-07-06 | A | Stock | 14.0773 | 14.0773 | 13.7911 | 13.9843 | 3513593.0 |
| 2009-07-06 | AABA-DELISTED | Stock | 14.82 | 14.93 | 14.55 | 14.89 | 13470967.0 |
| 2009-07-06 | AACC-DELISTED | Stock | 7.45 | 7.75 | 6.96 | 7.73 | 16471.0 |
| 2009-07-06 | AACG | Stock | 8.79 | 8.79 | 7.91 | 8.2 | 21700.0 |
| 2009-07-06 | AAI-DELISTED | Stock | 6.31 | 6.45 | 6.11 | 6.36 | 1785259.0 |
| 2009-07-06 | AAIC-DELISTED | Stock | 7.4 | 7.8 | 7.178 | 7.4 | 408172.0 |
| 2009-07-06 | AAON | Stock | 3.9328 | 3.9862 | 3.8953 | 3.9644 | 184275.0 |
| 2009-07-06 | AAP | Stock | 41.83 | 43.27 | 41.77 | 42.36 | 1015700.0 |
| 2009-07-06 | AATI-DELISTED | Stock | 4.47 | 4.59 | 4.36 | 4.49 | 125932.0 |
| 2009-07-06 | AAU-DELISTED | Stock | 0.69 | 0.69 | 0.62 | 0.62 | 51400.0 |
| 2009-07-06 | AAUAF-DELISTED | Stock | 0.69 | 0.69 | 0.62 | 0.62 | 51500.0 |
| 2009-07-06 | AAV-DELISTED | Stock | 3.81 | 3.95 | 3.67 | 3.95 | 1188360.0 |
| 2009-07-06 | AAWW-DELISTED | Stock | 22.32 | 22.37 | 21.575 | 22.1 | 250955.0 |
| 2009-07-06 | AAXJ | Stock | 43.69 | 44.09 | 43.18 | 44.09 | 152839.0 |
| 2009-07-06 | AAXN-DELISTED | Stock | 4.54 | 4.675 | 4.45 | 4.5 | 494397.0 |
| 2009-07-06 | AB | Stock | 19.87 | 20.0 | 18.92 | 19.18 | 517900.0 |
| 2009-07-06 | ABAX-DELISTED | Stock | 19.39 | 19.75 | 19.14 | 19.43 | 194094.0 |
| 2009-07-06 | ABB-DELISTED | Stock | 15.13 | 15.26 | 15.0 | 15.25 | 3773833.0 |
| 2009-07-06 | ABBC-DELISTED | Stock | 7.92 | 8.07 | 7.83 | 8.01 | 43319.0 |
| 2009-07-06 | ABBNY-DELISTED | Stock | 15.13 | 15.26 | 15.0 | 15.24 | 3894781.0 |
| 2009-07-06 | ABC-DELISTED | Stock | 17.73 | 17.89 | 17.57 | 17.77 | 2078257.0 |
| 2009-07-06 | ABCB | Stock | 6.3319 | 6.4195 | 5.9234 | 6.0498 | 20665.0 |
| 2009-07-06 | ABCO-DELISTED | Stock | 12.607 | 12.702 | 12.358 | 12.448 | 166329.0 |
| 2009-07-06 | ABCW-DELISTED | Stock | 1.2683 | 1.3035 | 1.1503 | 1.17 | 60790.0 |
| 2009-07-06 | ABD-DELISTED | Stock | 2.8 | 3.02 | 2.5698 | 2.67 | 304470.0 |
| 2009-07-06 | ABE-DELISTED | Stock | 15.33 | 15.34 | 14.9 | 15.0 | 20331.0 |
| 2009-07-06 | ABEO | Stock | 2587.5 | 2625.0 | 2212.5 | 2600.0 | 28.0 |
| 2009-07-06 | ABFS-DELISTED | Stock | 26.62 | 27.36 | 25.8 | 26.57 | 418521.0 |
| 2009-07-06 | ABG | Stock | 9.81 | 10.0 | 8.84 | 9.09 | 693600.0 |
| 2009-07-06 | ABII-DELISTED | Stock | 35.58 | 37.63 | 35.33 | 35.52 | 105229.0 |
| 2009-07-06 | ABK-DELISTED | Stock | 0.86 | 0.88 | 0.8 | 0.87 | 4713765.0 |
| 2009-07-06 | ABM | Stock | 17.57 | 17.74 | 17.41 | 17.56 | 106700.0 |
| 2009-07-06 | ABMD-DELISTED | Stock | 8.73 | 8.73 | 8.32 | 8.46 | 321080.0 |
| 2009-07-06 | ABR | Stock | 1.77 | 1.77 | 1.65 | 1.68 | 125300.0 |
| 2009-07-06 | ABT | Stock | 21.8933 | 22.2291 | 21.8933 | 22.0708 | 16522718.0 |
| 2009-07-06 | ABTL-DELISTED | Stock | 2.0547 | 2.1359 | 2.0547 | 2.0953 | 29675.0 |
| 2009-07-06 | ABV-DELISTED | Stock | 63.01 | 64.98 | 62.73 | 64.95 | 535402.0 |
| 2009-07-06 | ABVA-DELISTED | Stock | 2.5999 | 2.5999 | 2.5999 | 2.5999 | 100.0 |
| 2009-07-06 | ABVT-DELISTED | Stock | 78.1 | 78.1 | 73.58 | 75.86 | 45739.0 |
| 2009-07-06 | ABX-DELISTED | Stock | 33.28 | 33.39 | 32.49 | 33.11 | 6287743.0 |
| 2009-07-06 | ACAD | Stock | 2.01 | 2.04 | 1.9 | 1.92 | 161700.0 |
| 2009-07-06 | ACAP-DELISTED | Stock | 39.31 | 40.134 | 39.0 | 39.84 | 44746.0 |
| 2009-07-06 | ACAS-DELISTED | Stock | 3.05 | 3.1001 | 2.9897 | 3.0901 | 2169560.0 |
> showing 50 of 5,769 rows — these rows as CSV