PREVIEW / stock_daily / 2009-11-06
file: by_date/stock_daily/2009/2009-11-06.parquet size: 184 KB rows: 5,817 symbols: 3,445
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-06 | AAPL | Stock | 6.8754 | 6.9711 | 6.8714 | 6.9407 | 295097600.0 |
| 2009-11-06 | MSFT | Stock | 28.38 | 28.63 | 28.2 | 28.52 | 38908500.0 |
| 2009-11-06 | NVDA | Stock | 0.326 | 0.3358 | 0.322 | 0.329 | 1641112000.0 |
| 2009-11-06 | AMZN | Stock | 6.15 | 6.349 | 6.1335 | 6.31 | 264520000.0 |
| 2009-11-06 | TLT | Stock | 93.38 | 93.45 | 92.46 | 93.33 | 3381038.0 |
| 2009-11-06 | ES | Stock | 23.24 | 23.26 | 22.99 | 23.1 | 899300.0 |
| 2009-11-06 | CL | Stock | 39.64 | 40.15 | 39.545 | 39.935 | 4932800.0 |
| 2009-11-06 | A | Stock | 18.9413 | 18.9413 | 18.5551 | 18.7196 | 3416013.0 |
| 2009-11-06 | AABA-DELISTED | Stock | 15.88 | 16.03 | 15.76 | 15.94 | 13324338.0 |
| 2009-11-06 | AACC-DELISTED | Stock | 5.14 | 5.38 | 5.09 | 5.31 | 160329.0 |
| 2009-11-06 | AACG | Stock | 5.0 | 5.0 | 4.85 | 5.0 | 3500.0 |
| 2009-11-06 | AAI-DELISTED | Stock | 4.18 | 4.6701 | 4.12 | 4.62 | 6965411.0 |
| 2009-11-06 | AAIC-DELISTED | Stock | 12.45 | 12.45 | 11.41 | 11.82 | 97990.0 |
| 2009-11-06 | AAME | Stock | 1.23 | 1.23 | 1.23 | 1.23 | 10000.0 |
| 2009-11-06 | AAON | Stock | 3.7491 | 3.8519 | 3.7472 | 3.836 | 452081.0 |
| 2009-11-06 | AAP | Stock | 37.62 | 38.15 | 37.38 | 38.04 | 1862400.0 |
| 2009-11-06 | AATI-DELISTED | Stock | 3.14 | 3.14 | 3.05 | 3.07 | 394875.0 |
| 2009-11-06 | AAU-DELISTED | Stock | 0.71 | 0.73 | 0.6982 | 0.702 | 77769.0 |
| 2009-11-06 | AAUAF-DELISTED | Stock | 0.71 | 0.73 | 0.7002 | 0.704 | 78650.0 |
| 2009-11-06 | AAV-DELISTED | Stock | 6.4 | 6.5 | 6.25 | 6.49 | 760109.0 |
| 2009-11-06 | AAWW-DELISTED | Stock | 26.58 | 27.35 | 26.32 | 27.19 | 522815.0 |
| 2009-11-06 | AAXJ | Stock | 52.99 | 53.46 | 52.82 | 53.25 | 196400.0 |
| 2009-11-06 | AAXN-DELISTED | Stock | 4.24 | 4.53 | 4.22 | 4.41 | 888241.0 |
| 2009-11-06 | AB | Stock | 26.17 | 26.53 | 25.86 | 26.35 | 459300.0 |
| 2009-11-06 | ABAX-DELISTED | Stock | 23.19 | 23.52 | 22.8301 | 23.04 | 55404.0 |
| 2009-11-06 | ABB-DELISTED | Stock | 19.3 | 19.68 | 19.24 | 19.49 | 2431838.0 |
| 2009-11-06 | ABBC-DELISTED | Stock | 6.62 | 6.81 | 6.51 | 6.81 | 194299.0 |
| 2009-11-06 | ABBNY-DELISTED | Stock | 19.3 | 19.68 | 19.24 | 19.52 | 2458838.0 |
| 2009-11-06 | ABC-DELISTED | Stock | 23.36 | 23.62 | 23.11 | 23.61 | 2113949.0 |
| 2009-11-06 | ABCB | Stock | 4.9986 | 5.4397 | 4.9986 | 5.2045 | 50504.0 |
| 2009-11-06 | ABCO-DELISTED | Stock | 12.91 | 12.995 | 12.685 | 12.86 | 90233.0 |
| 2009-11-06 | ABCW-DELISTED | Stock | 0.7171 | 0.7171 | 0.5196 | 0.53 | 362760.0 |
| 2009-11-06 | ABD-DELISTED | Stock | 6.19 | 6.5 | 6.15 | 6.31 | 250630.0 |
| 2009-11-06 | ABE-DELISTED | Stock | 16.27 | 16.63 | 16.27 | 16.43 | 34737.0 |
| 2009-11-06 | ABEO | Stock | 3875.0 | 4062.5 | 3750.0 | 4000.0 | 24.0 |
| 2009-11-06 | ABFS-DELISTED | Stock | 23.64 | 24.16 | 23.64 | 24.06 | 359421.0 |
| 2009-11-06 | ABG | Stock | 10.26 | 10.6 | 10.06 | 10.39 | 308300.0 |
| 2009-11-06 | ABII-DELISTED | Stock | 33.65 | 34.92 | 32.83 | 34.43 | 33204.0 |
| 2009-11-06 | ABK-DELISTED | Stock | 1.15 | 1.2 | 1.12 | 1.17 | 18950230.0 |
| 2009-11-06 | ABM | Stock | 18.65 | 19.0 | 18.65 | 18.91 | 92400.0 |
| 2009-11-06 | ABMD-DELISTED | Stock | 9.57 | 9.63 | 9.16 | 9.37 | 512133.0 |
| 2009-11-06 | ABR | Stock | 2.05 | 2.05 | 1.72 | 1.86 | 331300.0 |
| 2009-11-06 | ABT | Stock | 24.6857 | 24.7529 | 24.5034 | 24.7241 | 8325761.0 |
| 2009-11-06 | ABTL-DELISTED | Stock | 3.9 | 4.05 | 3.798 | 4.05 | 4040.0 |
| 2009-11-06 | ABV-DELISTED | Stock | 95.59 | 96.69 | 94.17 | 96.37 | 673603.0 |
| 2009-11-06 | ABVA-DELISTED | Stock | 2.245 | 2.245 | 2.23 | 2.23 | 700.0 |
| 2009-11-06 | ABVT-DELISTED | Stock | 51.89 | 53.84 | 51.3 | 53.6 | 258983.0 |
| 2009-11-06 | ABX-DELISTED | Stock | 40.57 | 42.26 | 40.46 | 41.66 | 17537742.0 |
| 2009-11-06 | ACAD | Stock | 1.33 | 1.44 | 1.3 | 1.33 | 270400.0 |
| 2009-11-06 | ACAP-DELISTED | Stock | 28.18 | 28.85 | 28.18 | 28.44 | 23182.0 |
> showing 50 of 5,817 rows — these rows as CSV