PREVIEW / stock_daily / 2009-12-11
file: by_date/stock_daily/2009/2009-12-11.parquet size: 188 KB rows: 5,893 symbols: 3,498
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-12-11 | AAPL | Stock | 7.0636 | 7.0714 | 6.9082 | 6.9525 | 429774800.0 |
| 2009-12-11 | MSFT | Stock | 29.97 | 30.0 | 29.79 | 29.85 | 43744200.0 |
| 2009-12-11 | NVDA | Stock | 0.3885 | 0.389 | 0.3793 | 0.3803 | 416744000.0 |
| 2009-12-11 | AMZN | Stock | 6.8035 | 6.8145 | 6.66 | 6.7075 | 160934000.0 |
| 2009-12-11 | TLT | Stock | 91.84 | 92.26 | 91.31 | 92.09 | 3053364.0 |
| 2009-12-11 | ES | Stock | 24.9 | 25.61 | 24.85 | 25.5 | 2124900.0 |
| 2009-12-11 | CL | Stock | 41.59 | 42.315 | 41.45 | 41.96 | 4226800.0 |
| 2009-12-11 | A | Stock | 21.2804 | 21.3734 | 21.1445 | 21.2017 | 1967825.0 |
| 2009-12-11 | AABA-DELISTED | Stock | 15.85 | 15.9 | 15.62 | 15.75 | 22450837.0 |
| 2009-12-11 | AACC-DELISTED | Stock | 6.07 | 6.07 | 5.99 | 6.02 | 18860.0 |
| 2009-12-11 | AACG | Stock | 5.23 | 5.3 | 5.1 | 5.11 | 9700.0 |
| 2009-12-11 | AAI-DELISTED | Stock | 4.99 | 5.28 | 4.94 | 5.23 | 5169398.0 |
| 2009-12-11 | AAIC-DELISTED | Stock | 14.53 | 14.6 | 13.87 | 14.25 | 70834.0 |
| 2009-12-11 | AAME | Stock | 1.16 | 1.31 | 1.12 | 1.31 | 3100.0 |
| 2009-12-11 | AAON | Stock | 3.6958 | 3.7649 | 3.6543 | 3.757 | 219206.0 |
| 2009-12-11 | AAP | Stock | 40.06 | 40.45 | 39.46 | 40.37 | 1288700.0 |
| 2009-12-11 | AATI-DELISTED | Stock | 3.55 | 3.63 | 3.52 | 3.62 | 162087.0 |
| 2009-12-11 | AAU-DELISTED | Stock | 1.15 | 1.15 | 1.0499 | 1.08 | 316835.0 |
| 2009-12-11 | AAUAF-DELISTED | Stock | 1.15 | 1.15 | 1.0499 | 1.08 | 319293.0 |
| 2009-12-11 | AAV-DELISTED | Stock | 5.96 | 6.0 | 5.87 | 5.97 | 508625.0 |
| 2009-12-11 | AAWW-DELISTED | Stock | 34.76 | 34.9699 | 34.44 | 34.69 | 290688.0 |
| 2009-12-11 | AAXJ | Stock | 55.7 | 56.08 | 55.4894 | 55.57 | 187331.0 |
| 2009-12-11 | AAXN-DELISTED | Stock | 4.35 | 4.37 | 4.25 | 4.3 | 190249.0 |
| 2009-12-11 | AB | Stock | 26.37 | 26.47 | 25.79 | 25.9 | 380400.0 |
| 2009-12-11 | ABAX-DELISTED | Stock | 23.32 | 23.4 | 22.98 | 23.25 | 65172.0 |
| 2009-12-11 | ABB-DELISTED | Stock | 17.99 | 18.06 | 17.9 | 17.94 | 2339161.0 |
| 2009-12-11 | ABBC-DELISTED | Stock | 6.9 | 6.93 | 6.64 | 6.72 | 24379.0 |
| 2009-12-11 | ABBNY-DELISTED | Stock | 17.99 | 18.06 | 17.9 | 17.94 | 2342573.0 |
| 2009-12-11 | ABC-DELISTED | Stock | 25.07 | 25.17 | 24.75 | 24.81 | 2513763.0 |
| 2009-12-11 | ABCB | Stock | 6.5374 | 6.5864 | 6.4591 | 6.5374 | 70195.0 |
| 2009-12-11 | ABCD-DELISTED | Stock | 4.91 | 4.91 | 4.3 | 4.8 | 8265.0 |
| 2009-12-11 | ABCO-DELISTED | Stock | 13.19 | 13.342 | 12.915 | 13.28 | 51644.0 |
| 2009-12-11 | ABCW-DELISTED | Stock | 0.6398 | 0.65 | 0.6054 | 0.63 | 115530.0 |
| 2009-12-11 | ABD-DELISTED | Stock | 7.1 | 7.23 | 6.95 | 7.05 | 145150.0 |
| 2009-12-11 | ABE-DELISTED | Stock | 16.77 | 16.8 | 16.59 | 16.75 | 19259.0 |
| 2009-12-11 | ABEO | Stock | 3675.0 | 3675.0 | 3500.0 | 3625.0 | 27.0 |
| 2009-12-11 | ABFS-DELISTED | Stock | 28.1 | 28.38 | 27.45 | 27.74 | 243029.0 |
| 2009-12-11 | ABG | Stock | 11.48 | 11.57 | 11.26 | 11.44 | 339200.0 |
| 2009-12-11 | ABII-DELISTED | Stock | 37.5 | 38.42 | 37.21 | 38.26 | 32457.0 |
| 2009-12-11 | ABK-DELISTED | Stock | 0.8096 | 0.87 | 0.78 | 0.8499 | 11243846.0 |
| 2009-12-11 | ABM | Stock | 19.97 | 20.04 | 19.55 | 19.88 | 146400.0 |
| 2009-12-11 | ABMD-DELISTED | Stock | 8.54 | 8.74 | 8.31 | 8.44 | 195392.0 |
| 2009-12-11 | ABR | Stock | 1.83 | 1.85 | 1.75 | 1.77 | 119400.0 |
| 2009-12-11 | ABT | Stock | 25.9092 | 26.0771 | 25.7413 | 25.7988 | 11144018.0 |
| 2009-12-11 | ABTL-DELISTED | Stock | 5.5 | 5.5 | 5.0005 | 5.25 | 2781.0 |
| 2009-12-11 | ABV-DELISTED | Stock | 96.15 | 97.25 | 96.15 | 97.1 | 377430.0 |
| 2009-12-11 | ABVA-DELISTED | Stock | 2.455 | 2.47 | 2.38 | 2.38 | 1342.0 |
| 2009-12-11 | ABVT-DELISTED | Stock | 58.94 | 60.44 | 58.94 | 60.44 | 281826.0 |
| 2009-12-11 | ABX-DELISTED | Stock | 41.17 | 41.34 | 39.51 | 39.6 | 14683217.0 |
| 2009-12-11 | ACAD | Stock | 1.21 | 1.21 | 1.16 | 1.18 | 533300.0 |
> showing 50 of 5,893 rows — these rows as CSV