PREVIEW / stock_daily / 2009-11-20
file: by_date/stock_daily/2009/2009-11-20.parquet size: 186 KB rows: 5,859 symbols: 3,484
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-20 | AAPL | Stock | 7.1125 | 7.1568 | 7.0629 | 7.14 | 406666400.0 |
| 2009-11-20 | MSFT | Stock | 29.66 | 29.77 | 29.43 | 29.62 | 42647100.0 |
| 2009-11-20 | NVDA | Stock | 0.317 | 0.324 | 0.3163 | 0.3225 | 426748000.0 |
| 2009-11-20 | AMZN | Stock | 6.388 | 6.4995 | 6.3705 | 6.483 | 133052000.0 |
| 2009-11-20 | TLT | Stock | 95.0 | 95.37 | 94.59 | 95.12 | 4136249.0 |
| 2009-11-20 | ES | Stock | 23.61 | 23.97 | 23.61 | 23.95 | 1183700.0 |
| 2009-11-20 | CL | Stock | 42.06 | 42.51 | 41.94 | 41.985 | 8190400.0 |
| 2009-11-20 | A | Stock | 20.701 | 20.7797 | 20.5079 | 20.6795 | 2765244.0 |
| 2009-11-20 | AABA-DELISTED | Stock | 15.6 | 15.74 | 15.36 | 15.39 | 15271874.0 |
| 2009-11-20 | AACC-DELISTED | Stock | 5.32 | 5.59 | 5.32 | 5.5 | 37899.0 |
| 2009-11-20 | AACG | Stock | 4.83 | 5.11 | 4.65 | 5.0 | 19900.0 |
| 2009-11-20 | AAI-DELISTED | Stock | 4.14 | 4.19 | 4.06 | 4.11 | 7750904.0 |
| 2009-11-20 | AAIC-DELISTED | Stock | 13.03 | 13.35 | 12.98 | 13.35 | 10076.0 |
| 2009-11-20 | AAON | Stock | 3.8716 | 3.9309 | 3.7886 | 3.8696 | 299194.0 |
| 2009-11-20 | AAP | Stock | 39.87 | 40.11 | 39.5 | 39.74 | 2005500.0 |
| 2009-11-20 | AATI-DELISTED | Stock | 3.21 | 3.34 | 3.11 | 3.16 | 319237.0 |
| 2009-11-20 | AAU-DELISTED | Stock | 0.75 | 0.76 | 0.73 | 0.75 | 207150.0 |
| 2009-11-20 | AAUAF-DELISTED | Stock | 0.75 | 0.76 | 0.73 | 0.75 | 207250.0 |
| 2009-11-20 | AAV-DELISTED | Stock | 5.56 | 5.73 | 5.51 | 5.68 | 840863.0 |
| 2009-11-20 | AAWW-DELISTED | Stock | 29.54 | 30.03 | 29.5 | 29.84 | 341262.0 |
| 2009-11-20 | AAXJ | Stock | 54.51 | 55.3 | 54.51 | 55.2 | 215663.0 |
| 2009-11-20 | AAXN-DELISTED | Stock | 4.04 | 4.09 | 4.03 | 4.08 | 236626.0 |
| 2009-11-20 | AB | Stock | 26.82 | 26.99 | 26.16 | 26.3 | 302100.0 |
| 2009-11-20 | ABAX-DELISTED | Stock | 22.39 | 22.76 | 22.35 | 22.56 | 136869.0 |
| 2009-11-20 | ABB-DELISTED | Stock | 18.48 | 18.76 | 18.46 | 18.71 | 3323888.0 |
| 2009-11-20 | ABBC-DELISTED | Stock | 6.85 | 7.0 | 6.78 | 6.79 | 40302.0 |
| 2009-11-20 | ABBNY-DELISTED | Stock | 18.48 | 18.76 | 18.46 | 18.7 | 3334154.0 |
| 2009-11-20 | ABC-DELISTED | Stock | 24.19 | 24.7 | 24.17 | 24.51 | 4893008.0 |
| 2009-11-20 | ABCB | Stock | 5.9787 | 6.1552 | 5.8808 | 6.1258 | 59380.0 |
| 2009-11-20 | ABCO-DELISTED | Stock | 12.513 | 12.668 | 12.257 | 12.382 | 156237.0 |
| 2009-11-20 | ABCW-DELISTED | Stock | 0.78 | 0.78 | 0.6 | 0.62 | 601310.0 |
| 2009-11-20 | ABD-DELISTED | Stock | 6.31 | 6.31 | 5.97 | 6.11 | 290040.0 |
| 2009-11-20 | ABE-DELISTED | Stock | 16.6 | 16.72 | 16.6 | 16.685 | 15438.0 |
| 2009-11-20 | ABEO | Stock | 3750.0 | 3875.0 | 3687.5 | 3875.0 | 5.0 |
| 2009-11-20 | ABFS-DELISTED | Stock | 24.42 | 24.97 | 24.315 | 24.87 | 342330.0 |
| 2009-11-20 | ABG | Stock | 9.56 | 9.8 | 9.48 | 9.75 | 281500.0 |
| 2009-11-20 | ABII-DELISTED | Stock | 33.48 | 33.9 | 33.42 | 33.9 | 20737.0 |
| 2009-11-20 | ABK-DELISTED | Stock | 0.97 | 1.02 | 0.9 | 0.9 | 17924239.0 |
| 2009-11-20 | ABM | Stock | 18.92 | 18.96 | 18.7 | 18.8 | 95400.0 |
| 2009-11-20 | ABMD-DELISTED | Stock | 8.51 | 8.69 | 8.11 | 8.14 | 220960.0 |
| 2009-11-20 | ABR | Stock | 1.81 | 1.84 | 1.76 | 1.84 | 48800.0 |
| 2009-11-20 | ABT | Stock | 25.5494 | 25.7845 | 25.3526 | 25.7365 | 13334306.0 |
| 2009-11-20 | ABTL-DELISTED | Stock | 4.25 | 4.6 | 4.25 | 4.5 | 23095.0 |
| 2009-11-20 | ABV-DELISTED | Stock | 97.35 | 98.43 | 96.6 | 98.25 | 390211.0 |
| 2009-11-20 | ABVT-DELISTED | Stock | 55.03 | 55.61 | 52.9 | 53.58 | 215074.0 |
| 2009-11-20 | ABX-DELISTED | Stock | 43.33 | 44.2 | 43.25 | 43.95 | 8705948.0 |
| 2009-11-20 | ACAD | Stock | 1.37 | 1.45 | 1.33 | 1.33 | 250400.0 |
| 2009-11-20 | ACAP-DELISTED | Stock | 27.47 | 27.64 | 27.32 | 27.51 | 42547.0 |
| 2009-11-20 | ACAS-DELISTED | Stock | 2.94 | 3.07 | 2.94 | 3.06 | 3463272.0 |
| 2009-11-20 | ACAT-DELISTED | Stock | 7.04 | 7.04 | 6.75 | 6.75 | 12117.0 |
> showing 50 of 5,859 rows — these rows as CSV