PREVIEW / stock_daily / 2010-01-11
file: by_date/stock_daily/2010/2010-01-11.parquet size: 189 KB rows: 5,912 symbols: 3,494
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-11 | AAPL | Stock | 7.6 | 7.6071 | 7.4446 | 7.5039 | 462229600.0 |
| 2010-01-11 | MSFT | Stock | 30.71 | 30.76 | 30.12 | 30.27 | 68754700.0 |
| 2010-01-11 | NVDA | Stock | 0.4662 | 0.4683 | 0.4508 | 0.4572 | 556612000.0 |
| 2010-01-11 | AMZN | Stock | 6.631 | 6.64 | 6.4605 | 6.5155 | 175588000.0 |
| 2010-01-11 | TLT | Stock | 88.99 | 89.36 | 88.77 | 88.8 | 2182206.0 |
| 2010-01-11 | ES | Stock | 25.72 | 26.26 | 25.72 | 26.21 | 1441900.0 |
| 2010-01-11 | CL | Stock | 40.32 | 40.665 | 39.755 | 40.575 | 7054200.0 |
| 2010-01-11 | A | Stock | 22.0887 | 22.2103 | 21.9385 | 22.0458 | 4781579.0 |
| 2010-01-11 | AABA-DELISTED | Stock | 16.77 | 16.83 | 16.48 | 16.75 | 15439975.0 |
| 2010-01-11 | AACC-DELISTED | Stock | 6.66 | 6.789 | 6.55 | 6.6 | 12827.0 |
| 2010-01-11 | AACG | Stock | 4.75 | 4.75 | 4.25 | 4.3 | 8800.0 |
| 2010-01-11 | AAI-DELISTED | Stock | 5.13 | 5.15 | 5.04 | 5.11 | 2798457.0 |
| 2010-01-11 | AAIC-DELISTED | Stock | 16.1 | 16.21 | 15.76 | 15.88 | 11217.0 |
| 2010-01-11 | AAME | Stock | 1.45 | 1.45 | 1.45 | 1.45 | 600.0 |
| 2010-01-11 | AAON | Stock | 3.9091 | 3.9763 | 3.8499 | 3.9684 | 402975.0 |
| 2010-01-11 | AAP | Stock | 40.72 | 40.8 | 40.09 | 40.24 | 1038400.0 |
| 2010-01-11 | AATI-DELISTED | Stock | 4.0 | 4.0 | 3.85 | 3.85 | 288869.0 |
| 2010-01-11 | AAU-DELISTED | Stock | 1.32 | 1.39 | 1.2401 | 1.2401 | 749213.0 |
| 2010-01-11 | AAUAF-DELISTED | Stock | 1.32 | 1.39 | 1.2401 | 1.2401 | 752313.0 |
| 2010-01-11 | AAV-DELISTED | Stock | 7.38 | 7.45 | 7.17 | 7.22 | 450437.0 |
| 2010-01-11 | AAWW-DELISTED | Stock | 39.61 | 39.68 | 39.0 | 39.39 | 237051.0 |
| 2010-01-11 | AAXJ | Stock | 58.26 | 58.3 | 57.755 | 57.98 | 268676.0 |
| 2010-01-11 | AAXN-DELISTED | Stock | 5.62 | 6.36 | 5.52 | 6.19 | 4668816.0 |
| 2010-01-11 | AB | Stock | 29.39 | 30.08 | 29.16 | 29.88 | 629900.0 |
| 2010-01-11 | ABAX-DELISTED | Stock | 25.95 | 26.37 | 25.83 | 26.16 | 91871.0 |
| 2010-01-11 | ABB-DELISTED | Stock | 20.67 | 20.71 | 20.45 | 20.48 | 5819898.0 |
| 2010-01-11 | ABBC-DELISTED | Stock | 6.79 | 6.81 | 6.705 | 6.77 | 42273.0 |
| 2010-01-11 | ABBNY-DELISTED | Stock | 20.67 | 20.71 | 20.45 | 20.48 | 6104500.0 |
| 2010-01-11 | ABC-DELISTED | Stock | 26.24 | 26.48 | 26.11 | 26.37 | 1877368.0 |
| 2010-01-11 | ABCB | Stock | 7.7729 | 7.7927 | 7.526 | 7.6643 | 13162.0 |
| 2010-01-11 | ABCD-DELISTED | Stock | 3.975 | 3.99 | 3.95 | 3.95 | 66097.0 |
| 2010-01-11 | ABCO-DELISTED | Stock | 16.143 | 16.143 | 15.912 | 15.987 | 111703.0 |
| 2010-01-11 | ABCW-DELISTED | Stock | 0.7 | 0.78 | 0.7 | 0.76 | 315710.0 |
| 2010-01-11 | ABD-DELISTED | Stock | 8.15 | 8.34 | 8.08 | 8.26 | 341080.0 |
| 2010-01-11 | ABE-DELISTED | Stock | 17.17 | 17.2 | 16.97 | 17.05 | 13884.0 |
| 2010-01-11 | ABEO | Stock | 4112.5 | 4112.5 | 3750.0 | 3887.5 | 17.0 |
| 2010-01-11 | ABFS-DELISTED | Stock | 28.27 | 28.74 | 27.82 | 27.94 | 259690.0 |
| 2010-01-11 | ABG | Stock | 13.23 | 13.26 | 13.03 | 13.2 | 137700.0 |
| 2010-01-11 | ABII-DELISTED | Stock | 41.53 | 41.87 | 39.52 | 41.0 | 18830.0 |
| 2010-01-11 | ABK-DELISTED | Stock | 0.839 | 0.839 | 0.8 | 0.804 | 7465079.0 |
| 2010-01-11 | ABM | Stock | 21.25 | 21.3 | 21.14 | 21.17 | 96900.0 |
| 2010-01-11 | ABMD-DELISTED | Stock | 8.29 | 8.33 | 8.05 | 8.08 | 98113.0 |
| 2010-01-11 | ABR | Stock | 2.3 | 2.38 | 2.25 | 2.35 | 134400.0 |
| 2010-01-11 | ABT | Stock | 26.5329 | 26.6193 | 26.4226 | 26.5473 | 10947270.0 |
| 2010-01-11 | ABTL-DELISTED | Stock | 4.9 | 5.05 | 4.475 | 4.95 | 31381.0 |
| 2010-01-11 | ABV-DELISTED | Stock | 104.26 | 104.68 | 102.75 | 103.61 | 357980.0 |
| 2010-01-11 | ABVT-DELISTED | Stock | 65.93 | 66.32 | 63.73 | 63.9 | 108735.0 |
| 2010-01-11 | ABX-DELISTED | Stock | 42.58 | 42.64 | 41.32 | 41.63 | 13178397.0 |
| 2010-01-11 | ACAD | Stock | 1.47 | 1.47 | 1.41 | 1.47 | 598300.0 |
| 2010-01-11 | ACAP-DELISTED | Stock | 29.98 | 30.425 | 29.81 | 30.03 | 33723.0 |
> showing 50 of 5,912 rows — these rows as CSV