PREVIEW / stock_daily / 2009-12-24
file: by_date/stock_daily/2009/2009-12-24.parquet size: 182 KB rows: 5,770 symbols: 3,414
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-24 | AAPL | Stock | 7.2696 | 7.4768 | 7.2625 | 7.4657 | 500889200.0 |
| 2009-12-24 | MSFT | Stock | 30.88 | 31.0 | 30.76 | 31.0 | 11083900.0 |
| 2009-12-24 | NVDA | Stock | 0.4545 | 0.4552 | 0.4505 | 0.4522 | 136812000.0 |
| 2009-12-24 | AMZN | Stock | 6.96 | 6.985 | 6.877 | 6.9235 | 102576000.0 |
| 2009-12-24 | TLT | Stock | 90.33 | 90.36 | 89.67 | 89.71 | 1698812.0 |
| 2009-12-24 | ES | Stock | 26.02 | 26.23 | 26.02 | 26.23 | 208700.0 |
| 2009-12-24 | CL | Stock | 41.685 | 41.83 | 41.45 | 41.575 | 1893000.0 |
| 2009-12-24 | A | Stock | 21.6524 | 21.7382 | 21.6023 | 21.6953 | 1058006.0 |
| 2009-12-24 | AABA-DELISTED | Stock | 16.7 | 16.75 | 16.65 | 16.72 | 4715442.0 |
| 2009-12-24 | AACC-DELISTED | Stock | 6.2 | 6.29 | 6.03 | 6.27 | 17752.0 |
| 2009-12-24 | AACG | Stock | 4.46 | 4.65 | 4.28 | 4.57 | 7800.0 |
| 2009-12-24 | AAI-DELISTED | Stock | 5.33 | 5.44 | 5.3 | 5.39 | 1106457.0 |
| 2009-12-24 | AAIC-DELISTED | Stock | 15.69 | 15.87 | 15.69 | 15.79 | 1940.0 |
| 2009-12-24 | AAME | Stock | 1.36 | 1.36 | 1.35 | 1.35 | 200.0 |
| 2009-12-24 | AAON | Stock | 3.8874 | 3.9289 | 3.8874 | 3.9269 | 37969.0 |
| 2009-12-24 | AAP | Stock | 41.45 | 41.59 | 41.11 | 41.38 | 362900.0 |
| 2009-12-24 | AATI-DELISTED | Stock | 3.71 | 3.72 | 3.66 | 3.68 | 37832.0 |
| 2009-12-24 | AAU-DELISTED | Stock | 1.1 | 1.1 | 1.06 | 1.09 | 28819.0 |
| 2009-12-24 | AAUAF-DELISTED | Stock | 1.1 | 1.1 | 1.06 | 1.09 | 29919.0 |
| 2009-12-24 | AAV-DELISTED | Stock | 6.65 | 6.78 | 6.65 | 6.72 | 187687.0 |
| 2009-12-24 | AAWW-DELISTED | Stock | 38.21 | 38.25 | 37.3 | 37.79 | 86068.0 |
| 2009-12-24 | AAXJ | Stock | 55.32 | 55.41 | 53.56 | 55.37 | 62468.0 |
| 2009-12-24 | AAXN-DELISTED | Stock | 4.5 | 4.5 | 4.4 | 4.41 | 116923.0 |
| 2009-12-24 | AB | Stock | 26.88 | 27.05 | 26.74 | 27.05 | 155100.0 |
| 2009-12-24 | ABAX-DELISTED | Stock | 24.18 | 24.61 | 24.14 | 24.49 | 49305.0 |
| 2009-12-24 | ABB-DELISTED | Stock | 19.09 | 19.1 | 18.92 | 19.06 | 898878.0 |
| 2009-12-24 | ABBC-DELISTED | Stock | 6.72 | 6.75 | 6.61 | 6.63 | 8730.0 |
| 2009-12-24 | ABBNY-DELISTED | Stock | 19.09 | 19.1 | 18.92 | 19.05 | 899737.0 |
| 2009-12-24 | ABC-DELISTED | Stock | 26.39 | 26.4552 | 26.32 | 26.35 | 479987.0 |
| 2009-12-24 | ABCB | Stock | 6.6746 | 6.8217 | 6.6256 | 6.655 | 14080.0 |
| 2009-12-24 | ABCD-DELISTED | Stock | 4.4 | 4.4 | 3.81 | 4.07 | 38233.0 |
| 2009-12-24 | ABCO-DELISTED | Stock | 14.837 | 14.923 | 14.748 | 14.868 | 36189.0 |
| 2009-12-24 | ABCW-DELISTED | Stock | 0.62 | 0.6582 | 0.6066 | 0.62 | 42550.0 |
| 2009-12-24 | ABD-DELISTED | Stock | 7.65 | 7.65 | 7.55 | 7.65 | 41800.0 |
| 2009-12-24 | ABE-DELISTED | Stock | 16.54 | 16.65 | 16.54 | 16.65 | 1604.0 |
| 2009-12-24 | ABEO | Stock | 3875.0 | 4000.0 | 3875.0 | 3975.0 | 10.0 |
| 2009-12-24 | ABFS-DELISTED | Stock | 32.15 | 32.32 | 30.83 | 31.49 | 424947.0 |
| 2009-12-24 | ABG | Stock | 11.9 | 12.05 | 11.79 | 12.04 | 81400.0 |
| 2009-12-24 | ABII-DELISTED | Stock | 39.49 | 39.98 | 39.49 | 39.5 | 13786.0 |
| 2009-12-24 | ABK-DELISTED | Stock | 0.86 | 0.86 | 0.81 | 0.8303 | 3896797.0 |
| 2009-12-24 | ABM | Stock | 21.0 | 21.16 | 20.96 | 21.14 | 39300.0 |
| 2009-12-24 | ABMD-DELISTED | Stock | 8.89 | 8.9 | 8.74 | 8.87 | 37221.0 |
| 2009-12-24 | ABR | Stock | 1.9 | 1.97 | 1.83 | 1.97 | 115800.0 |
| 2009-12-24 | ABT | Stock | 25.9428 | 26.1107 | 25.9284 | 25.9812 | 3166736.0 |
| 2009-12-24 | ABTL-DELISTED | Stock | 4.7568 | 4.9636 | 4.4983 | 4.55 | 85988.0 |
| 2009-12-24 | ABV-DELISTED | Stock | 96.67 | 97.54 | 96.66 | 97.43 | 47530.0 |
| 2009-12-24 | ABVT-DELISTED | Stock | 65.45 | 65.49 | 64.68 | 65.1 | 17581.0 |
| 2009-12-24 | ABX-DELISTED | Stock | 40.74 | 40.75 | 40.15 | 40.36 | 3850575.0 |
| 2009-12-24 | ACAD | Stock | 1.32 | 1.38 | 1.32 | 1.35 | 135400.0 |
| 2009-12-24 | ACAP-DELISTED | Stock | 29.86 | 30.59 | 29.86 | 30.43 | 15263.0 |
> showing 50 of 5,770 rows — these rows as CSV