PREVIEW / stock_daily / 2012-11-07
file: by_date/stock_daily/2012/2012-11-07.parquet size: 200 KB rows: 6,182 symbols: 3,493
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-11-07 | AAPL | Stock | 20.4943 | 20.5193 | 19.8482 | 19.9286 | 793648800.0 |
| 2012-11-07 | MSFT | Stock | 29.53 | 29.83 | 29.05 | 29.08 | 57871800.0 |
| 2012-11-07 | NVDA | Stock | 0.3228 | 0.3248 | 0.3138 | 0.3153 | 324620000.0 |
| 2012-11-07 | AMZN | Stock | 11.7825 | 11.783 | 11.471 | 11.603 | 72484000.0 |
| 2012-11-07 | META | Stock | 20.85 | 20.95 | 20.37 | 20.47 | 33396800.0 |
| 2012-11-07 | TSLA | Stock | 2.0667 | 2.1367 | 2.054 | 2.1027 | 25717500.0 |
| 2012-11-07 | TLT | Stock | 123.95 | 124.531 | 123.76 | 124.0 | 10070915.0 |
| 2012-11-07 | ES | Stock | 39.0 | 39.0 | 38.19 | 38.37 | 1171100.0 |
| 2012-11-07 | CL | Stock | 52.8 | 52.8 | 52.165 | 52.485 | 2817800.0 |
| 2012-11-07 | A | Stock | 27.0243 | 27.1245 | 26.6381 | 26.8813 | 4515260.0 |
| 2012-11-07 | AABA-DELISTED | Stock | 17.27 | 17.56 | 17.18 | 17.39 | 24141153.0 |
| 2012-11-07 | AACC-DELISTED | Stock | 6.19 | 6.36 | 5.28 | 5.41 | 31245.0 |
| 2012-11-07 | AACG | Stock | 5.05 | 5.51 | 4.81 | 4.81 | 900.0 |
| 2012-11-07 | AAIC-DELISTED | Stock | 21.76 | 21.89 | 20.7401 | 21.05 | 293244.0 |
| 2012-11-07 | AAME | Stock | 2.77 | 2.94 | 2.77 | 2.94 | 3600.0 |
| 2012-11-07 | AAMRQ-DELISTED | Stock | 0.3766 | 0.382 | 0.37 | 0.37 | 498924.0 |
| 2012-11-07 | AAON | Stock | 6.0356 | 6.0681 | 5.8607 | 5.9052 | 201825.0 |
| 2012-11-07 | AAP | Stock | 80.06 | 81.09 | 79.61 | 79.76 | 983200.0 |
| 2012-11-07 | AAT | Stock | 27.87 | 27.87 | 27.25 | 27.49 | 97800.0 |
| 2012-11-07 | AAU-DELISTED | Stock | 2.57 | 2.61 | 2.5 | 2.55 | 57779.0 |
| 2012-11-07 | AAUAF-DELISTED | Stock | 2.53 | 2.57 | 2.5 | 2.55 | 59956.0 |
| 2012-11-07 | AAV-DELISTED | Stock | 3.55 | 3.55 | 3.42 | 3.47 | 216631.0 |
| 2012-11-07 | AAWW-DELISTED | Stock | 43.92 | 44.1 | 42.41 | 43.07 | 228428.0 |
| 2012-11-07 | AAXJ | Stock | 57.12 | 57.28 | 56.47 | 56.75 | 298785.0 |
| 2012-11-07 | AAXN-DELISTED | Stock | 8.14 | 8.24 | 7.81 | 8.17 | 649972.0 |
| 2012-11-07 | AB | Stock | 16.46 | 16.53 | 16.2 | 16.26 | 186500.0 |
| 2012-11-07 | ABAC-DELISTED | Stock | 1.13 | 1.25 | 1.07 | 1.07 | 10900.0 |
| 2012-11-07 | ABAX-DELISTED | Stock | 36.74 | 36.74 | 35.05 | 36.04 | 140773.0 |
| 2012-11-07 | ABB-DELISTED | Stock | 18.44 | 18.46 | 18.24 | 18.37 | 1621381.0 |
| 2012-11-07 | ABBNY-DELISTED | Stock | 18.44 | 18.46 | 18.24 | 18.35 | 1647981.0 |
| 2012-11-07 | ABC-DELISTED | Stock | 40.13 | 40.97 | 39.65 | 40.74 | 3205744.0 |
| 2012-11-07 | ABCB | Stock | 11.07 | 11.07 | 10.61 | 10.66 | 55300.0 |
| 2012-11-07 | ABCD-DELISTED | Stock | 0.751 | 0.85 | 0.65 | 0.65 | 31651.0 |
| 2012-11-07 | ABCO-DELISTED | Stock | 48.0 | 48.8 | 47.23 | 47.25 | 170601.0 |
| 2012-11-07 | ABCW-DELISTED | Stock | 0.37 | 0.4 | 0.36 | 0.4 | 6528.0 |
| 2012-11-07 | ABE-DELISTED | Stock | 20.51 | 20.51 | 20.27 | 20.3 | 8935.0 |
| 2012-11-07 | ABEO | Stock | 375.0 | 412.5 | 375.0 | 387.5 | 39.0 |
| 2012-11-07 | ABFS-DELISTED | Stock | 8.55 | 8.62 | 8.11 | 8.13 | 273827.0 |
| 2012-11-07 | ABG | Stock | 31.03 | 31.5 | 30.43 | 30.46 | 272400.0 |
| 2012-11-07 | ABM | Stock | 19.32 | 19.32 | 18.99 | 19.12 | 177800.0 |
| 2012-11-07 | ABMD-DELISTED | Stock | 13.16 | 13.28 | 12.72 | 13.07 | 910119.0 |
| 2012-11-07 | ABR | Stock | 5.39 | 5.4 | 5.26 | 5.28 | 175900.0 |
| 2012-11-07 | ABT | Stock | 30.8847 | 31.1726 | 30.4241 | 30.9567 | 24128595.0 |
| 2012-11-07 | ABTL-DELISTED | Stock | 4.28 | 4.41 | 4.122 | 4.1564 | 5672.0 |
| 2012-11-07 | ABUS | Stock | 4.2 | 4.55 | 4.18 | 4.47 | 66400.0 |
| 2012-11-07 | ABV-DELISTED | Stock | 40.71 | 40.85 | 40.31 | 40.56 | 1916191.0 |
| 2012-11-07 | ABVA-DELISTED | Stock | 4.4 | 4.4 | 4.4 | 4.4 | 300.0 |
| 2012-11-07 | ABX-DELISTED | Stock | 36.08 | 36.4 | 35.07 | 36.25 | 10535921.0 |
| 2012-11-07 | ACAD | Stock | 2.38 | 2.4 | 2.21 | 2.3 | 1898900.0 |
| 2012-11-07 | ACAS-DELISTED | Stock | 11.83 | 11.87 | 11.58 | 11.7 | 4166387.0 |
> showing 50 of 6,182 rows — these rows as CSV