PREVIEW / stock_daily / 2010-11-16
file: by_date/stock_daily/2010/2010-11-16.parquet size: 194 KB rows: 6,029 symbols: 3,541
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-11-16 | AAPL | Stock | 10.9186 | 10.9857 | 10.69 | 10.7711 | 657650000.0 |
| 2010-11-16 | MSFT | Stock | 26.04 | 26.04 | 25.65 | 25.81 | 65339200.0 |
| 2010-11-16 | NVDA | Stock | 0.322 | 0.3265 | 0.3173 | 0.3178 | 739356000.0 |
| 2010-11-16 | AMZN | Stock | 7.937 | 8.0455 | 7.8385 | 7.889 | 131428000.0 |
| 2010-11-16 | TSLA | Stock | 2.0667 | 2.0933 | 1.8947 | 1.978 | 20214000.0 |
| 2010-11-16 | TLT | Stock | 94.91 | 96.25 | 93.99 | 96.138 | 19913474.0 |
| 2010-11-16 | ES | Stock | 31.54 | 31.58 | 31.0 | 31.2 | 2073900.0 |
| 2010-11-16 | CL | Stock | 39.2 | 39.2 | 38.205 | 38.405 | 8066600.0 |
| 2010-11-16 | A | Stock | 25.6152 | 25.6438 | 24.8927 | 25.0644 | 6894796.0 |
| 2010-11-16 | AABA-DELISTED | Stock | 16.48 | 16.49 | 16.1 | 16.23 | 22516365.0 |
| 2010-11-16 | AACC-DELISTED | Stock | 5.19 | 5.19 | 4.77 | 4.94 | 36582.0 |
| 2010-11-16 | AACG | Stock | 3.76 | 3.76 | 3.75 | 3.75 | 600.0 |
| 2010-11-16 | AAI-DELISTED | Stock | 7.42 | 7.44 | 7.4 | 7.4 | 2249701.0 |
| 2010-11-16 | AAIC-DELISTED | Stock | 23.65 | 23.65 | 23.0 | 23.5 | 61497.0 |
| 2010-11-16 | AAME | Stock | 1.86 | 1.89 | 1.8 | 1.84 | 6200.0 |
| 2010-11-16 | AAON | Stock | 4.9165 | 4.9402 | 4.8395 | 4.8632 | 279956.0 |
| 2010-11-16 | AAP | Stock | 64.76 | 65.8 | 64.71 | 65.29 | 1120900.0 |
| 2010-11-16 | AATI-DELISTED | Stock | 3.78 | 3.79 | 3.56 | 3.61 | 248398.0 |
| 2010-11-16 | AAU-DELISTED | Stock | 2.68 | 2.68 | 2.5 | 2.55 | 513342.0 |
| 2010-11-16 | AAUAF-DELISTED | Stock | 2.68 | 2.68 | 2.5 | 2.55 | 513642.0 |
| 2010-11-16 | AAV-DELISTED | Stock | 6.54 | 6.54 | 6.38 | 6.47 | 352724.0 |
| 2010-11-16 | AAWW-DELISTED | Stock | 56.06 | 56.3 | 54.38 | 55.03 | 326961.0 |
| 2010-11-16 | AAXJ | Stock | 62.64 | 62.64 | 61.4 | 61.58 | 742517.0 |
| 2010-11-16 | AAXN-DELISTED | Stock | 4.02 | 4.07 | 3.99 | 4.04 | 540605.0 |
| 2010-11-16 | AB | Stock | 24.31 | 24.43 | 23.95 | 24.05 | 440500.0 |
| 2010-11-16 | ABAC-DELISTED | Stock | 6.52 | 7.09 | 6.05 | 6.38 | 189613.0 |
| 2010-11-16 | ABAX-DELISTED | Stock | 25.5 | 25.66 | 24.51 | 24.61 | 69200.0 |
| 2010-11-16 | ABB-DELISTED | Stock | 20.3 | 20.3 | 19.79 | 19.9199 | 2797945.0 |
| 2010-11-16 | ABBC-DELISTED | Stock | 11.9 | 11.95 | 11.72 | 11.9 | 44696.0 |
| 2010-11-16 | ABBNY-DELISTED | Stock | 20.3 | 20.3 | 19.79 | 19.94 | 3114411.0 |
| 2010-11-16 | ABC-DELISTED | Stock | 31.11 | 31.35 | 30.765 | 31.01 | 2248645.0 |
| 2010-11-16 | ABCB | Stock | 9.8 | 9.88 | 9.59 | 9.7 | 67800.0 |
| 2010-11-16 | ABCD-DELISTED | Stock | 3.06 | 3.1 | 2.96 | 3.02 | 29476.0 |
| 2010-11-16 | ABCO-DELISTED | Stock | 24.15 | 24.34 | 23.92 | 24.13 | 98017.0 |
| 2010-11-16 | ABCW-DELISTED | Stock | 0.732 | 0.7721 | 0.732 | 0.768 | 20330.0 |
| 2010-11-16 | ABD-DELISTED | Stock | 7.025 | 7.085 | 6.7752 | 7.085 | 485780.0 |
| 2010-11-16 | ABE-DELISTED | Stock | 18.6299 | 18.63 | 18.0201 | 18.03 | 10086.0 |
| 2010-11-16 | ABEO | Stock | 3737.5 | 3737.5 | 3500.0 | 3625.0 | 35.0 |
| 2010-11-16 | ABFS-DELISTED | Stock | 24.04 | 24.335 | 23.47 | 23.72 | 146804.0 |
| 2010-11-16 | ABG | Stock | 15.5 | 15.78 | 15.21 | 15.45 | 210600.0 |
| 2010-11-16 | ABM | Stock | 23.56 | 23.75 | 23.28 | 23.43 | 262500.0 |
| 2010-11-16 | ABMD-DELISTED | Stock | 11.7 | 11.74 | 11.43 | 11.55 | 98041.0 |
| 2010-11-16 | ABR | Stock | 5.37 | 5.5 | 5.1 | 5.42 | 83700.0 |
| 2010-11-16 | ABT | Stock | 23.0496 | 23.1408 | 22.8193 | 22.8673 | 21728845.0 |
| 2010-11-16 | ABTL-DELISTED | Stock | 3.95 | 3.952 | 3.75 | 3.95 | 9656.0 |
| 2010-11-16 | ABUS | Stock | 6.91 | 7.2 | 6.85 | 6.99 | 3600.0 |
| 2010-11-16 | ABV-DELISTED | Stock | 137.12 | 138.05 | 133.97 | 134.76 | 667345.0 |
| 2010-11-16 | ABVA-DELISTED | Stock | 3.08 | 3.1 | 3.03 | 3.05 | 38820.0 |
| 2010-11-16 | ABVT-DELISTED | Stock | 61.47 | 61.47 | 59.94 | 60.71 | 166332.0 |
| 2010-11-16 | ABX-DELISTED | Stock | 49.41 | 50.08 | 48.57 | 48.88 | 13674245.0 |
> showing 50 of 6,029 rows — these rows as CSV