PREVIEW / stock_daily / 2012-10-10
file: by_date/stock_daily/2012/2012-10-10.parquet size: 200 KB rows: 6,170 symbols: 3,492
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-10 | AAPL | Stock | 22.8479 | 23.035 | 22.75 | 22.8896 | 510356000.0 |
| 2012-10-10 | MSFT | Stock | 29.15 | 29.31 | 28.95 | 28.98 | 47227100.0 |
| 2012-10-10 | NVDA | Stock | 0.3208 | 0.3223 | 0.3155 | 0.3168 | 326568000.0 |
| 2012-10-10 | AMZN | Stock | 12.6 | 12.623 | 12.2005 | 12.2495 | 78966000.0 |
| 2012-10-10 | META | Stock | 19.93 | 19.94 | 19.45 | 19.64 | 39321800.0 |
| 2012-10-10 | TSLA | Stock | 1.8927 | 1.9147 | 1.8673 | 1.8933 | 7554000.0 |
| 2012-10-10 | TLT | Stock | 121.46 | 122.96 | 121.26 | 122.81 | 5430204.0 |
| 2012-10-10 | ES | Stock | 39.46 | 39.48 | 38.94 | 39.04 | 1279500.0 |
| 2012-10-10 | CL | Stock | 53.73 | 54.025 | 53.565 | 53.845 | 3013000.0 |
| 2012-10-10 | A | Stock | 27.3104 | 27.3534 | 26.6237 | 26.7597 | 4210357.0 |
| 2012-10-10 | AABA-DELISTED | Stock | 15.85 | 15.99 | 15.8 | 15.84 | 14332331.0 |
| 2012-10-10 | AACC-DELISTED | Stock | 7.36 | 7.56 | 7.19 | 7.35 | 6606.0 |
| 2012-10-10 | AACG | Stock | 4.61 | 4.74 | 4.6 | 4.68 | 14400.0 |
| 2012-10-10 | AAIC-DELISTED | Stock | 23.24 | 23.26 | 22.5 | 22.65 | 304332.0 |
| 2012-10-10 | AAME | Stock | 3.0 | 3.0 | 2.64 | 2.88 | 20500.0 |
| 2012-10-10 | AAMRQ-DELISTED | Stock | 0.385 | 0.393 | 0.381 | 0.386 | 457418.0 |
| 2012-10-10 | AAON | Stock | 5.6296 | 5.7096 | 5.6178 | 5.6652 | 78300.0 |
| 2012-10-10 | AAP | Stock | 69.78 | 70.32 | 68.96 | 69.11 | 762000.0 |
| 2012-10-10 | AAT | Stock | 27.36 | 27.67 | 27.3 | 27.6 | 84700.0 |
| 2012-10-10 | AAU-DELISTED | Stock | 2.42 | 2.52 | 2.41 | 2.45 | 101360.0 |
| 2012-10-10 | AAUAF-DELISTED | Stock | 2.46 | 2.52 | 2.45 | 2.45 | 101660.0 |
| 2012-10-10 | AAV-DELISTED | Stock | 4.04 | 4.0799 | 3.85 | 3.87 | 160352.0 |
| 2012-10-10 | AAWW-DELISTED | Stock | 52.47 | 52.78 | 49.73 | 52.45 | 128431.0 |
| 2012-10-10 | AAXJ | Stock | 56.21 | 56.21 | 55.7 | 55.81 | 203796.0 |
| 2012-10-10 | AAXN-DELISTED | Stock | 5.84 | 6.01 | 5.75 | 5.95 | 449599.0 |
| 2012-10-10 | AB | Stock | 15.66 | 15.74 | 15.55 | 15.6 | 185800.0 |
| 2012-10-10 | ABAC-DELISTED | Stock | 1.38 | 1.38 | 1.38 | 1.38 | 212.0 |
| 2012-10-10 | ABAX-DELISTED | Stock | 36.37 | 36.77 | 36.08 | 36.6 | 47436.0 |
| 2012-10-10 | ABB-DELISTED | Stock | 18.66 | 18.6817 | 18.46 | 18.56 | 1376608.0 |
| 2012-10-10 | ABBNY-DELISTED | Stock | 18.66 | 18.6817 | 18.46 | 18.56 | 1441957.0 |
| 2012-10-10 | ABC-DELISTED | Stock | 39.56 | 39.61 | 39.155 | 39.4 | 1740166.0 |
| 2012-10-10 | ABCB | Stock | 12.4 | 12.73 | 12.39 | 12.67 | 16100.0 |
| 2012-10-10 | ABCD-DELISTED | Stock | 0.99 | 0.9968 | 0.97 | 0.97 | 11900.0 |
| 2012-10-10 | ABCO-DELISTED | Stock | 47.68 | 48.45 | 47.43 | 47.68 | 177933.0 |
| 2012-10-10 | ABCW-DELISTED | Stock | 0.38 | 0.39 | 0.38 | 0.39 | 17342.0 |
| 2012-10-10 | ABE-DELISTED | Stock | 20.53 | 20.59 | 20.52 | 20.59 | 3205.0 |
| 2012-10-10 | ABEO | Stock | 512.5 | 512.5 | 475.0 | 500.0 | 7.0 |
| 2012-10-10 | ABFS-DELISTED | Stock | 8.14 | 8.35 | 8.015 | 8.15 | 393137.0 |
| 2012-10-10 | ABG | Stock | 30.48 | 30.48 | 29.7 | 29.97 | 188400.0 |
| 2012-10-10 | ABM | Stock | 18.32 | 18.4 | 18.27 | 18.34 | 343500.0 |
| 2012-10-10 | ABMD-DELISTED | Stock | 19.93 | 20.46 | 19.88 | 20.46 | 330742.0 |
| 2012-10-10 | ABR | Stock | 5.7 | 5.72 | 5.55 | 5.69 | 309500.0 |
| 2012-10-10 | ABT | Stock | 34.0754 | 34.0754 | 33.5908 | 33.7635 | 8959358.0 |
| 2012-10-10 | ABTL-DELISTED | Stock | 3.9 | 3.9 | 3.9 | 3.9 | 100.0 |
| 2012-10-10 | ABUS | Stock | 3.63 | 3.77 | 3.56 | 3.74 | 10900.0 |
| 2012-10-10 | ABV-DELISTED | Stock | 40.31 | 40.31 | 39.71 | 39.95 | 1901959.0 |
| 2012-10-10 | ABVA-DELISTED | Stock | 4.68 | 4.68 | 4.68 | 4.68 | 300.0 |
| 2012-10-10 | ABX-DELISTED | Stock | 40.03 | 40.99 | 40.03 | 40.18 | 6401247.0 |
| 2012-10-10 | ACAD | Stock | 2.49 | 2.55 | 2.31 | 2.38 | 1901200.0 |
| 2012-10-10 | ACAS-DELISTED | Stock | 11.68 | 11.74 | 11.49 | 11.69 | 2799550.0 |
> showing 50 of 6,170 rows — these rows as CSV