PREVIEW / stock_daily / 2009-12-30
file: by_date/stock_daily/2009/2009-12-30.parquet size: 189 KB rows: 5,936 symbols: 3,516
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-30 | AAPL | Stock | 7.4582 | 7.5714 | 7.4396 | 7.5586 | 412084400.0 |
| 2009-12-30 | MSFT | Stock | 31.15 | 31.29 | 30.8 | 30.96 | 42006200.0 |
| 2009-12-30 | NVDA | Stock | 0.4548 | 0.4695 | 0.4515 | 0.4668 | 704008000.0 |
| 2009-12-30 | AMZN | Stock | 6.92 | 6.92 | 6.764 | 6.8245 | 138264000.0 |
| 2009-12-30 | TLT | Stock | 89.92 | 90.48 | 89.865 | 90.32 | 1919066.0 |
| 2009-12-30 | ES | Stock | 26.22 | 26.37 | 26.14 | 26.32 | 517000.0 |
| 2009-12-30 | CL | Stock | 41.335 | 41.615 | 41.25 | 41.425 | 3206000.0 |
| 2009-12-30 | A | Stock | 21.5379 | 22.3462 | 21.402 | 22.2461 | 5585010.0 |
| 2009-12-30 | AABA-DELISTED | Stock | 16.83 | 16.99 | 16.81 | 16.98 | 7531691.0 |
| 2009-12-30 | AACC-DELISTED | Stock | 6.66 | 6.75 | 6.63 | 6.75 | 22173.0 |
| 2009-12-30 | AACG | Stock | 4.41 | 4.45 | 4.4 | 4.4 | 16600.0 |
| 2009-12-30 | AAI-DELISTED | Stock | 5.2 | 5.2 | 5.07 | 5.19 | 2006863.0 |
| 2009-12-30 | AAIC-DELISTED | Stock | 15.19 | 15.5 | 15.05 | 15.18 | 45136.0 |
| 2009-12-30 | AAON | Stock | 3.921 | 3.9407 | 3.8677 | 3.921 | 203006.0 |
| 2009-12-30 | AAP | Stock | 40.55 | 41.03 | 40.55 | 41.01 | 1249400.0 |
| 2009-12-30 | AATI-DELISTED | Stock | 3.73 | 3.83 | 3.66 | 3.83 | 399994.0 |
| 2009-12-30 | AAU-DELISTED | Stock | 1.06 | 1.07 | 1.03 | 1.04 | 125383.0 |
| 2009-12-30 | AAUAF-DELISTED | Stock | 1.06 | 1.07 | 1.03 | 1.04 | 126483.0 |
| 2009-12-30 | AAV-DELISTED | Stock | 6.63 | 6.72 | 6.58 | 6.61 | 426241.0 |
| 2009-12-30 | AAWW-DELISTED | Stock | 37.8 | 38.08 | 37.3 | 37.59 | 120423.0 |
| 2009-12-30 | AAXJ | Stock | 55.27 | 55.75 | 55.27 | 55.75 | 81081.0 |
| 2009-12-30 | AAXN-DELISTED | Stock | 4.35 | 4.45 | 4.32 | 4.35 | 394219.0 |
| 2009-12-30 | AB | Stock | 27.5 | 28.1 | 27.5 | 28.07 | 322100.0 |
| 2009-12-30 | ABAX-DELISTED | Stock | 25.13 | 25.61 | 24.84 | 25.6 | 122514.0 |
| 2009-12-30 | ABB-DELISTED | Stock | 19.09 | 19.25 | 19.03 | 19.23 | 2539110.0 |
| 2009-12-30 | ABBC-DELISTED | Stock | 6.76 | 6.89 | 6.68 | 6.89 | 32992.0 |
| 2009-12-30 | ABBNY-DELISTED | Stock | 19.09 | 19.25 | 19.03 | 19.22 | 2540410.0 |
| 2009-12-30 | ABC-DELISTED | Stock | 26.3 | 26.38 | 26.115 | 26.29 | 1611834.0 |
| 2009-12-30 | ABCB | Stock | 6.9235 | 7.0519 | 6.6668 | 7.0421 | 38880.0 |
| 2009-12-30 | ABCD-DELISTED | Stock | 3.97 | 3.97 | 3.62 | 3.8 | 76154.0 |
| 2009-12-30 | ABCO-DELISTED | Stock | 14.99 | 15.285 | 14.88 | 15.28 | 102000.0 |
| 2009-12-30 | ABCW-DELISTED | Stock | 0.63 | 0.66 | 0.63 | 0.64 | 53890.0 |
| 2009-12-30 | ABD-DELISTED | Stock | 7.505 | 7.575 | 7.295 | 7.545 | 192900.0 |
| 2009-12-30 | ABE-DELISTED | Stock | 16.61 | 16.6799 | 16.45 | 16.65 | 8908.0 |
| 2009-12-30 | ABEO | Stock | 3950.0 | 4187.5 | 3812.5 | 4062.5 | 15.0 |
| 2009-12-30 | ABFS-DELISTED | Stock | 33.0 | 33.31 | 32.09 | 32.81 | 581791.0 |
| 2009-12-30 | ABG | Stock | 11.67 | 11.91 | 11.53 | 11.81 | 123200.0 |
| 2009-12-30 | ABII-DELISTED | Stock | 37.98 | 40.68 | 37.08 | 40.68 | 166391.0 |
| 2009-12-30 | ABK-DELISTED | Stock | 0.84 | 0.84 | 0.82 | 0.82 | 4034362.0 |
| 2009-12-30 | ABM | Stock | 20.98 | 21.35 | 20.86 | 21.0 | 137100.0 |
| 2009-12-30 | ABMD-DELISTED | Stock | 8.78 | 8.93 | 8.76 | 8.9 | 184502.0 |
| 2009-12-30 | ABR | Stock | 1.92 | 1.96 | 1.89 | 1.95 | 85200.0 |
| 2009-12-30 | ABT | Stock | 25.866 | 26.1731 | 25.8612 | 26.1683 | 7483118.0 |
| 2009-12-30 | ABTL-DELISTED | Stock | 4.5428 | 4.5477 | 4.1622 | 4.35 | 14554.0 |
| 2009-12-30 | ABV-DELISTED | Stock | 101.12 | 102.26 | 100.93 | 101.67 | 219083.0 |
| 2009-12-30 | ABVA-DELISTED | Stock | 3.62 | 3.62 | 2.75 | 2.76 | 6837.0 |
| 2009-12-30 | ABVT-DELISTED | Stock | 65.18 | 65.35 | 64.52 | 64.92 | 77817.0 |
| 2009-12-30 | ABX-DELISTED | Stock | 39.25 | 39.75 | 39.12 | 39.5 | 5478057.0 |
| 2009-12-30 | ACAD | Stock | 1.32 | 1.33 | 1.26 | 1.29 | 531200.0 |
| 2009-12-30 | ACAP-DELISTED | Stock | 30.4 | 30.59 | 30.23 | 30.53 | 38105.0 |
> showing 50 of 5,936 rows — these rows as CSV