PREVIEW / stock_daily / 2009-11-13
file: by_date/stock_daily/2009/2009-11-13.parquet size: 186 KB rows: 5,858 symbols: 3,479
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-11-13 | AAPL | Stock | 7.2454 | 7.3154 | 7.2168 | 7.3018 | 343240800.0 |
| 2009-11-13 | MSFT | Stock | 29.47 | 29.79 | 29.37 | 29.63 | 53037600.0 |
| 2009-11-13 | NVDA | Stock | 0.3362 | 0.3408 | 0.3348 | 0.339 | 388524000.0 |
| 2009-11-13 | AMZN | Stock | 6.558 | 6.6495 | 6.4875 | 6.6485 | 147536000.0 |
| 2009-11-13 | TLT | Stock | 93.83 | 94.06 | 93.45 | 93.92 | 1594173.0 |
| 2009-11-13 | ES | Stock | 23.4 | 23.73 | 23.31 | 23.71 | 1979800.0 |
| 2009-11-13 | CL | Stock | 40.355 | 40.835 | 40.355 | 40.745 | 5465800.0 |
| 2009-11-13 | A | Stock | 20.0072 | 20.6652 | 19.8498 | 20.4649 | 8756233.0 |
| 2009-11-13 | AABA-DELISTED | Stock | 16.05 | 16.1 | 15.92 | 15.93 | 26299879.0 |
| 2009-11-13 | AACC-DELISTED | Stock | 5.12 | 5.25 | 5.061 | 5.18 | 34276.0 |
| 2009-11-13 | AACG | Stock | 4.27 | 4.71 | 4.25 | 4.53 | 29600.0 |
| 2009-11-13 | AAI-DELISTED | Stock | 4.51 | 4.59 | 4.45 | 4.46 | 2912850.0 |
| 2009-11-13 | AAIC-DELISTED | Stock | 12.95 | 13.2205 | 12.65 | 12.96 | 25213.0 |
| 2009-11-13 | AAME | Stock | 1.26 | 1.32 | 1.09 | 1.3 | 2300.0 |
| 2009-11-13 | AAON | Stock | 3.923 | 3.923 | 3.8617 | 3.917 | 398925.0 |
| 2009-11-13 | AAP | Stock | 38.32 | 39.38 | 37.92 | 39.25 | 4468400.0 |
| 2009-11-13 | AATI-DELISTED | Stock | 3.09 | 3.2 | 3.05 | 3.19 | 156928.0 |
| 2009-11-13 | AAU-DELISTED | Stock | 0.68 | 0.72 | 0.68 | 0.72 | 121722.0 |
| 2009-11-13 | AAUAF-DELISTED | Stock | 0.68 | 0.72 | 0.68 | 0.72 | 123022.0 |
| 2009-11-13 | AAV-DELISTED | Stock | 6.02 | 6.26 | 6.02 | 6.12 | 839821.0 |
| 2009-11-13 | AAWW-DELISTED | Stock | 28.7 | 29.0 | 28.354 | 28.54 | 303903.0 |
| 2009-11-13 | AAXJ | Stock | 54.74 | 55.47 | 54.73 | 55.28 | 142379.0 |
| 2009-11-13 | AAXN-DELISTED | Stock | 4.15 | 4.2 | 4.03 | 4.16 | 437644.0 |
| 2009-11-13 | AB | Stock | 27.1 | 27.34 | 26.82 | 27.12 | 510900.0 |
| 2009-11-13 | ABAX-DELISTED | Stock | 22.72 | 23.09 | 22.51 | 22.94 | 65369.0 |
| 2009-11-13 | ABB-DELISTED | Stock | 19.36 | 19.72 | 19.29 | 19.65 | 5345270.0 |
| 2009-11-13 | ABBC-DELISTED | Stock | 6.59 | 6.86 | 6.55 | 6.86 | 177205.0 |
| 2009-11-13 | ABBNY-DELISTED | Stock | 19.36 | 19.72 | 19.29 | 19.67 | 5348623.0 |
| 2009-11-13 | ABC-DELISTED | Stock | 24.09 | 24.68 | 24.09 | 24.6 | 3392943.0 |
| 2009-11-13 | ABCB | Stock | 5.8906 | 5.9298 | 5.5867 | 5.7435 | 26730.0 |
| 2009-11-13 | ABCO-DELISTED | Stock | 12.865 | 13.235 | 12.665 | 13.005 | 113164.0 |
| 2009-11-13 | ABCW-DELISTED | Stock | 0.45 | 0.5 | 0.45 | 0.46 | 206650.0 |
| 2009-11-13 | ABD-DELISTED | Stock | 6.49 | 6.56 | 6.17 | 6.44 | 229920.0 |
| 2009-11-13 | ABE-DELISTED | Stock | 16.77 | 16.83 | 16.73 | 16.83 | 8952.0 |
| 2009-11-13 | ABEO | Stock | 3937.5 | 3937.5 | 3775.0 | 3925.0 | 12.0 |
| 2009-11-13 | ABFS-DELISTED | Stock | 24.7 | 25.36 | 24.29 | 25.21 | 450402.0 |
| 2009-11-13 | ABG | Stock | 10.09 | 10.38 | 10.09 | 10.35 | 376200.0 |
| 2009-11-13 | ABII-DELISTED | Stock | 35.31 | 35.31 | 34.18 | 34.94 | 59776.0 |
| 2009-11-13 | ABK-DELISTED | Stock | 0.76 | 0.84 | 0.72 | 0.77 | 22136893.0 |
| 2009-11-13 | ABM | Stock | 19.12 | 19.5 | 18.82 | 19.38 | 134800.0 |
| 2009-11-13 | ABMD-DELISTED | Stock | 8.83 | 8.99 | 8.76 | 8.9 | 125705.0 |
| 2009-11-13 | ABR | Stock | 1.92 | 2.09 | 1.92 | 1.94 | 67800.0 |
| 2009-11-13 | ABT | Stock | 25.6213 | 25.6693 | 25.3238 | 25.4054 | 12412255.0 |
| 2009-11-13 | ABTL-DELISTED | Stock | 4.1 | 4.15 | 4.05 | 4.15 | 4531.0 |
| 2009-11-13 | ABV-DELISTED | Stock | 96.0 | 98.22 | 95.79 | 97.67 | 568850.0 |
| 2009-11-13 | ABVA-DELISTED | Stock | 2.71 | 2.71 | 2.22 | 2.22 | 200.0 |
| 2009-11-13 | ABVT-DELISTED | Stock | 53.39 | 54.325 | 53.39 | 54.14 | 122762.0 |
| 2009-11-13 | ABX-DELISTED | Stock | 41.87 | 43.19 | 41.75 | 42.98 | 10436073.0 |
| 2009-11-13 | ACAD | Stock | 1.45 | 1.45 | 1.3 | 1.45 | 376200.0 |
| 2009-11-13 | ACAP-DELISTED | Stock | 28.22 | 28.7 | 27.74 | 28.17 | 43865.0 |
> showing 50 of 5,858 rows — these rows as CSV