PREVIEW / stock_daily / 2009-07-15
file: by_date/stock_daily/2009/2009-07-15.parquet size: 182 KB rows: 5,790 symbols: 3,452
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-15 | AAPL | Stock | 5.18 | 5.25 | 5.1543 | 5.2457 | 485587200.0 |
| 2009-07-15 | MSFT | Stock | 23.75 | 24.12 | 23.56 | 24.12 | 67238700.0 |
| 2009-07-15 | NVDA | Stock | 0.2775 | 0.2842 | 0.275 | 0.2788 | 1022808000.0 |
| 2009-07-15 | AMZN | Stock | 4.15 | 4.232 | 4.139 | 4.2275 | 126780000.0 |
| 2009-07-15 | TLT | Stock | 92.66 | 93.0 | 91.67 | 91.68 | 4669206.0 |
| 2009-07-15 | ES | Stock | 21.72 | 22.08 | 21.63 | 22.07 | 1343100.0 |
| 2009-07-15 | CL | Stock | 37.0 | 37.0 | 36.45 | 36.55 | 6244200.0 |
| 2009-07-15 | A | Stock | 14.0773 | 14.7997 | 13.97 | 14.7067 | 4383988.0 |
| 2009-07-15 | AABA-DELISTED | Stock | 15.23 | 15.74 | 15.15 | 15.71 | 18392712.0 |
| 2009-07-15 | AACC-DELISTED | Stock | 7.83 | 8.05 | 7.6201 | 7.98 | 44007.0 |
| 2009-07-15 | AACG | Stock | 7.93 | 8.02 | 7.8 | 7.9 | 11400.0 |
| 2009-07-15 | AAI-DELISTED | Stock | 6.53 | 6.65 | 6.46 | 6.61 | 1618731.0 |
| 2009-07-15 | AAIC-DELISTED | Stock | 9.004 | 9.004 | 7.8 | 7.998 | 684896.0 |
| 2009-07-15 | AAME | Stock | 0.73 | 0.83 | 0.73 | 0.83 | 3100.0 |
| 2009-07-15 | AAON | Stock | 4.0494 | 4.0573 | 3.8262 | 4.0079 | 644962.0 |
| 2009-07-15 | AAP | Stock | 44.45 | 45.04 | 44.22 | 44.92 | 1793200.0 |
| 2009-07-15 | AATI-DELISTED | Stock | 4.46 | 4.57 | 4.4 | 4.45 | 419737.0 |
| 2009-07-15 | AAU-DELISTED | Stock | 0.62 | 0.68 | 0.62 | 0.67 | 103890.0 |
| 2009-07-15 | AAUAF-DELISTED | Stock | 0.62 | 0.68 | 0.62 | 0.67 | 105390.0 |
| 2009-07-15 | AAV-DELISTED | Stock | 4.86 | 4.96 | 4.75 | 4.92 | 1420180.0 |
| 2009-07-15 | AAWW-DELISTED | Stock | 21.86 | 22.92 | 21.4 | 22.6 | 324095.0 |
| 2009-07-15 | AAXJ | Stock | 45.21 | 46.02 | 44.9623 | 46.02 | 141177.0 |
| 2009-07-15 | AAXN-DELISTED | Stock | 4.79 | 5.11 | 4.72 | 5.11 | 1228678.0 |
| 2009-07-15 | AB | Stock | 20.0 | 21.11 | 19.64 | 20.69 | 593200.0 |
| 2009-07-15 | ABAX-DELISTED | Stock | 19.41 | 20.0997 | 19.41 | 19.87 | 214925.0 |
| 2009-07-15 | ABB-DELISTED | Stock | 16.0 | 16.33 | 15.99 | 16.28 | 3034978.0 |
| 2009-07-15 | ABBC-DELISTED | Stock | 8.25 | 8.34 | 8.01 | 8.28 | 67601.0 |
| 2009-07-15 | ABBNY-DELISTED | Stock | 16.0 | 16.33 | 15.99 | 16.31 | 3055191.0 |
| 2009-07-15 | ABC-DELISTED | Stock | 18.29 | 18.38 | 18.05 | 18.28 | 3047262.0 |
| 2009-07-15 | ABCB | Stock | 6.2249 | 6.5556 | 6.0791 | 6.5556 | 23441.0 |
| 2009-07-15 | ABCO-DELISTED | Stock | 11.747 | 12.423 | 11.742 | 12.393 | 141293.0 |
| 2009-07-15 | ABCW-DELISTED | Stock | 1.2049 | 1.2357 | 1.1329 | 1.21 | 78740.0 |
| 2009-07-15 | ABD-DELISTED | Stock | 2.5 | 2.8801 | 2.45 | 2.77 | 435180.0 |
| 2009-07-15 | ABE-DELISTED | Stock | 15.28 | 15.3 | 15.01 | 15.14 | 33507.0 |
| 2009-07-15 | ABEO | Stock | 2250.0 | 2375.0 | 2200.0 | 2375.0 | 15.0 |
| 2009-07-15 | ABFS-DELISTED | Stock | 27.28 | 27.505 | 26.0 | 26.28 | 1421622.0 |
| 2009-07-15 | ABG | Stock | 10.53 | 11.42 | 10.21 | 11.16 | 462000.0 |
| 2009-07-15 | ABII-DELISTED | Stock | 30.87 | 31.43 | 30.145 | 31.28 | 11931.0 |
| 2009-07-15 | ABK-DELISTED | Stock | 0.9887 | 1.04 | 0.96 | 1.0 | 6930156.0 |
| 2009-07-15 | ABM | Stock | 17.81 | 18.45 | 17.8 | 18.43 | 158400.0 |
| 2009-07-15 | ABMD-DELISTED | Stock | 7.94 | 8.17 | 7.84 | 8.15 | 216742.0 |
| 2009-07-15 | ABR | Stock | 1.56 | 1.64 | 1.52 | 1.57 | 326000.0 |
| 2009-07-15 | ABT | Stock | 21.9269 | 21.9748 | 21.2216 | 21.7253 | 54042935.0 |
| 2009-07-15 | ABTL-DELISTED | Stock | 2.2993 | 2.2993 | 2.1507 | 2.2507 | 6900.0 |
| 2009-07-15 | ABV-DELISTED | Stock | 65.32 | 68.18 | 64.95 | 68.16 | 693259.0 |
| 2009-07-15 | ABVA-DELISTED | Stock | 2.55 | 2.55 | 2.55 | 2.55 | 150.0 |
| 2009-07-15 | ABVT-DELISTED | Stock | 74.65 | 76.19 | 73.42 | 74.0 | 66627.0 |
| 2009-07-15 | ABX-DELISTED | Stock | 34.14 | 34.31 | 33.86 | 33.97 | 6885900.0 |
| 2009-07-15 | ACAD | Stock | 2.15 | 2.15 | 2.09 | 2.1 | 148900.0 |
| 2009-07-15 | ACAP-DELISTED | Stock | 38.91 | 40.47 | 38.46 | 39.79 | 51914.0 |
> showing 50 of 5,790 rows — these rows as CSV