PREVIEW / stock_daily / 2011-01-10
file: by_date/stock_daily/2011/2011-01-10.parquet size: 196 KB rows: 6,065 symbols: 3,540
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 |
|---|---|---|---|---|---|---|---|
| 2011-01-10 | AAPL | Stock | 12.1011 | 12.2582 | 12.0418 | 12.2304 | 448560000.0 |
| 2011-01-10 | MSFT | Stock | 28.26 | 28.4 | 28.04 | 28.22 | 57573600.0 |
| 2011-01-10 | NVDA | Stock | 0.4878 | 0.5168 | 0.484 | 0.5158 | 1750348000.0 |
| 2011-01-10 | AMZN | Stock | 9.252 | 9.2645 | 9.1255 | 9.234 | 67518000.0 |
| 2011-01-10 | TSLA | Stock | 1.878 | 1.912 | 1.87 | 1.8967 | 20140500.0 |
| 2011-01-10 | TLT | Stock | 92.58 | 92.99 | 92.18 | 92.85 | 8295357.0 |
| 2011-01-10 | ES | Stock | 31.49 | 31.63 | 31.19 | 31.56 | 1535300.0 |
| 2011-01-10 | CL | Stock | 38.98 | 39.235 | 38.82 | 38.945 | 6887600.0 |
| 2011-01-10 | A | Stock | 29.6209 | 30.5579 | 29.5422 | 30.2003 | 4397968.0 |
| 2011-01-10 | AABA-DELISTED | Stock | 16.78 | 16.8 | 16.5 | 16.61 | 15789688.0 |
| 2011-01-10 | AACC-DELISTED | Stock | 6.11 | 6.3 | 5.97 | 6.06 | 43315.0 |
| 2011-01-10 | AACG | Stock | 3.83 | 3.83 | 3.83 | 3.83 | 800.0 |
| 2011-01-10 | AAI-DELISTED | Stock | 7.45 | 7.49 | 7.45 | 7.49 | 1235980.0 |
| 2011-01-10 | AAIC-DELISTED | Stock | 24.44 | 24.56 | 24.33 | 24.35 | 25917.0 |
| 2011-01-10 | AAME | Stock | 2.07 | 2.07 | 2.06 | 2.06 | 200.0 |
| 2011-01-10 | AAON | Stock | 5.2405 | 5.3274 | 5.1891 | 5.3274 | 260719.0 |
| 2011-01-10 | AAP | Stock | 61.55 | 62.77 | 61.0 | 62.34 | 1213400.0 |
| 2011-01-10 | AATI-DELISTED | Stock | 3.94 | 4.28 | 3.801 | 4.23 | 469118.0 |
| 2011-01-10 | AAU-DELISTED | Stock | 4.28 | 4.54 | 4.28 | 4.41 | 336387.0 |
| 2011-01-10 | AAUAF-DELISTED | Stock | 4.28 | 4.54 | 4.28 | 4.41 | 337487.0 |
| 2011-01-10 | AAV-DELISTED | Stock | 6.78 | 6.81 | 6.65 | 6.74 | 272652.0 |
| 2011-01-10 | AAWW-DELISTED | Stock | 52.71 | 53.21 | 51.61 | 51.93 | 457619.0 |
| 2011-01-10 | AAXJ | Stock | 63.0 | 63.08 | 62.69 | 62.92 | 398352.0 |
| 2011-01-10 | AAXN-DELISTED | Stock | 4.74 | 4.83 | 4.678 | 4.77 | 905645.0 |
| 2011-01-10 | AB | Stock | 23.22 | 23.34 | 22.85 | 23.15 | 322400.0 |
| 2011-01-10 | ABAC-DELISTED | Stock | 6.2 | 6.2 | 5.91 | 5.95 | 98402.0 |
| 2011-01-10 | ABAX-DELISTED | Stock | 25.07 | 25.58 | 24.73 | 25.05 | 113127.0 |
| 2011-01-10 | ABB-DELISTED | Stock | 21.79 | 21.95 | 21.67 | 21.9 | 2156119.0 |
| 2011-01-10 | ABBC-DELISTED | Stock | 11.72 | 11.96 | 11.61 | 11.88 | 42754.0 |
| 2011-01-10 | ABBNY-DELISTED | Stock | 21.79 | 21.95 | 21.67 | 21.9 | 2157489.0 |
| 2011-01-10 | ABC-DELISTED | Stock | 34.86 | 34.92 | 34.56 | 34.74 | 2089418.0 |
| 2011-01-10 | ABCB | Stock | 10.96 | 11.01 | 10.82 | 10.88 | 32100.0 |
| 2011-01-10 | ABCD-DELISTED | Stock | 3.44 | 3.45 | 3.29 | 3.3 | 29398.0 |
| 2011-01-10 | ABCO-DELISTED | Stock | 23.9 | 23.96 | 23.36 | 23.86 | 98162.0 |
| 2011-01-10 | ABCW-DELISTED | Stock | 1.2718 | 1.3397 | 1.2523 | 1.33 | 144870.0 |
| 2011-01-10 | ABD-DELISTED | Stock | 8.24 | 8.4 | 8.14 | 8.28 | 274540.0 |
| 2011-01-10 | ABE-DELISTED | Stock | 19.03 | 19.17 | 18.69 | 18.96 | 11385.0 |
| 2011-01-10 | ABEO | Stock | 3062.5 | 3062.5 | 3000.0 | 3050.0 | 8.0 |
| 2011-01-10 | ABFS-DELISTED | Stock | 26.53 | 26.91 | 26.05 | 26.38 | 127759.0 |
| 2011-01-10 | ABG | Stock | 18.62 | 18.96 | 18.39 | 18.91 | 322800.0 |
| 2011-01-10 | ABH-DELISTED | Stock | 24.0 | 24.13 | 23.64 | 24.04 | 768400.0 |
| 2011-01-10 | ABM | Stock | 25.65 | 26.04 | 25.28 | 25.84 | 194100.0 |
| 2011-01-10 | ABMD-DELISTED | Stock | 9.81 | 10.05 | 9.81 | 10.0 | 100917.0 |
| 2011-01-10 | ABR | Stock | 5.81 | 5.85 | 5.71 | 5.78 | 26000.0 |
| 2011-01-10 | ABT | Stock | 23.1743 | 23.2415 | 22.9392 | 23.0016 | 29427887.0 |
| 2011-01-10 | ABTL-DELISTED | Stock | 5.35 | 5.75 | 5.0 | 5.45 | 86847.0 |
| 2011-01-10 | ABUS | Stock | 5.37 | 5.58 | 5.24 | 5.37 | 14800.0 |
| 2011-01-10 | ABV-DELISTED | Stock | 29.98 | 30.12 | 29.79 | 29.99 | 3567154.0 |
| 2011-01-10 | ABVA-DELISTED | Stock | 4.66 | 4.81 | 4.66 | 4.67 | 7250.0 |
| 2011-01-10 | ABVT-DELISTED | Stock | 60.42 | 60.5 | 59.87 | 60.0 | 112459.0 |
> showing 50 of 6,065 rows — these rows as CSV