PREVIEW / stock_daily / 2009-12-10
file: by_date/stock_daily/2009/2009-12-10.parquet size: 187 KB rows: 5,874 symbols: 3,482
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-10 | AAPL | Stock | 7.125 | 7.1321 | 7.0043 | 7.0154 | 489669600.0 |
| 2009-12-10 | MSFT | Stock | 29.71 | 29.96 | 29.66 | 29.87 | 45940200.0 |
| 2009-12-10 | NVDA | Stock | 0.395 | 0.3975 | 0.384 | 0.3853 | 417012000.0 |
| 2009-12-10 | AMZN | Stock | 6.6205 | 6.8095 | 6.62 | 6.769 | 226872000.0 |
| 2009-12-10 | TLT | Stock | 92.69 | 92.8 | 91.95 | 92.1 | 4446283.0 |
| 2009-12-10 | ES | Stock | 24.71 | 24.9 | 24.62 | 24.79 | 2333000.0 |
| 2009-12-10 | CL | Stock | 41.47 | 41.645 | 41.32 | 41.41 | 4766400.0 |
| 2009-12-10 | A | Stock | 21.0658 | 21.4163 | 21.0157 | 21.2375 | 2565889.0 |
| 2009-12-10 | AABA-DELISTED | Stock | 15.3 | 15.57 | 15.24 | 15.49 | 18578665.0 |
| 2009-12-10 | AACC-DELISTED | Stock | 6.04 | 6.2 | 5.88 | 5.96 | 34997.0 |
| 2009-12-10 | AACG | Stock | 4.99 | 5.3 | 4.91 | 5.25 | 45000.0 |
| 2009-12-10 | AAI-DELISTED | Stock | 5.02 | 5.08 | 4.88 | 4.95 | 2624544.0 |
| 2009-12-10 | AAIC-DELISTED | Stock | 14.53 | 14.64 | 14.4 | 14.63 | 242509.0 |
| 2009-12-10 | AAME | Stock | 1.18 | 1.18 | 1.18 | 1.18 | 200.0 |
| 2009-12-10 | AAON | Stock | 3.68 | 3.6879 | 3.6523 | 3.676 | 416137.0 |
| 2009-12-10 | AAP | Stock | 40.2 | 40.3 | 39.74 | 39.82 | 2561000.0 |
| 2009-12-10 | AATI-DELISTED | Stock | 3.59 | 3.61 | 3.4 | 3.53 | 384775.0 |
| 2009-12-10 | AAU-DELISTED | Stock | 1.15 | 1.15 | 1.08 | 1.1 | 312162.0 |
| 2009-12-10 | AAUAF-DELISTED | Stock | 1.15 | 1.15 | 1.08 | 1.1 | 320351.0 |
| 2009-12-10 | AAV-DELISTED | Stock | 5.97 | 6.07 | 5.89 | 6.06 | 732282.0 |
| 2009-12-10 | AAWW-DELISTED | Stock | 35.76 | 35.76 | 33.96 | 34.37 | 502156.0 |
| 2009-12-10 | AAXJ | Stock | 55.64 | 55.79 | 55.33 | 55.79 | 156934.0 |
| 2009-12-10 | AAXN-DELISTED | Stock | 4.34 | 4.39 | 4.24 | 4.33 | 310432.0 |
| 2009-12-10 | AB | Stock | 26.2 | 26.3 | 25.69 | 25.8 | 973200.0 |
| 2009-12-10 | ABAX-DELISTED | Stock | 23.41 | 23.69 | 23.14 | 23.2 | 112596.0 |
| 2009-12-10 | ABB-DELISTED | Stock | 18.05 | 18.11 | 17.79 | 17.82 | 3177078.0 |
| 2009-12-10 | ABBC-DELISTED | Stock | 6.75 | 6.85 | 6.51 | 6.69 | 58656.0 |
| 2009-12-10 | ABBNY-DELISTED | Stock | 18.05 | 18.11 | 17.79 | 17.83 | 3250036.0 |
| 2009-12-10 | ABC-DELISTED | Stock | 24.52 | 25.13 | 24.5 | 25.08 | 5849748.0 |
| 2009-12-10 | ABCB | Stock | 6.5276 | 6.5374 | 6.4493 | 6.508 | 44892.0 |
| 2009-12-10 | ABCD-DELISTED | Stock | 4.0 | 4.28 | 3.695 | 4.09 | 3700.0 |
| 2009-12-10 | ABCO-DELISTED | Stock | 13.155 | 13.3 | 13.065 | 13.17 | 73544.0 |
| 2009-12-10 | ABCW-DELISTED | Stock | 0.7 | 0.71 | 0.65 | 0.65 | 161120.0 |
| 2009-12-10 | ABD-DELISTED | Stock | 7.3 | 7.3 | 6.98 | 7.04 | 187730.0 |
| 2009-12-10 | ABE-DELISTED | Stock | 16.79 | 16.83 | 16.6401 | 16.77 | 11917.0 |
| 2009-12-10 | ABEO | Stock | 3750.0 | 3750.0 | 3362.5 | 3687.5 | 35.0 |
| 2009-12-10 | ABFS-DELISTED | Stock | 28.44 | 28.71 | 27.58 | 28.0 | 342315.0 |
| 2009-12-10 | ABG | Stock | 11.74 | 11.82 | 11.25 | 11.33 | 432300.0 |
| 2009-12-10 | ABII-DELISTED | Stock | 37.5 | 38.21 | 37.25 | 38.0 | 32181.0 |
| 2009-12-10 | ABK-DELISTED | Stock | 0.8295 | 0.8295 | 0.77 | 0.78 | 7621420.0 |
| 2009-12-10 | ABM | Stock | 19.8 | 20.1 | 19.65 | 19.82 | 152100.0 |
| 2009-12-10 | ABMD-DELISTED | Stock | 8.81 | 8.905 | 8.42 | 8.47 | 122953.0 |
| 2009-12-10 | ABR | Stock | 1.95 | 1.95 | 1.81 | 1.84 | 121900.0 |
| 2009-12-10 | ABT | Stock | 25.7029 | 26.0723 | 25.6837 | 25.9428 | 13065444.0 |
| 2009-12-10 | ABTL-DELISTED | Stock | 5.6 | 5.6 | 5.15 | 5.35 | 5425.0 |
| 2009-12-10 | ABV-DELISTED | Stock | 97.05 | 97.99 | 95.15 | 95.8 | 504729.0 |
| 2009-12-10 | ABVA-DELISTED | Stock | 2.69 | 2.7299 | 2.69 | 2.69 | 600.0 |
| 2009-12-10 | ABVT-DELISTED | Stock | 58.37 | 59.36 | 57.81 | 58.7 | 96240.0 |
| 2009-12-10 | ABX-DELISTED | Stock | 41.54 | 41.63 | 40.31 | 41.02 | 13395555.0 |
| 2009-12-10 | ACAD | Stock | 1.2 | 1.2 | 1.16 | 1.18 | 533400.0 |
> showing 50 of 5,874 rows — these rows as CSV