PREVIEW / stock_daily / 2012-12-12
file: by_date/stock_daily/2012/2012-12-12.parquet size: 202 KB rows: 6,250 symbols: 3,522
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-12-12 | AAPL | Stock | 19.5632 | 19.5714 | 19.1525 | 19.25 | 487144000.0 |
| 2012-12-12 | MSFT | Stock | 27.53 | 27.62 | 27.08 | 27.24 | 43966300.0 |
| 2012-12-12 | NVDA | Stock | 0.3173 | 0.319 | 0.3118 | 0.313 | 399404000.0 |
| 2012-12-12 | AMZN | Stock | 12.5535 | 12.718 | 12.503 | 12.588 | 52562000.0 |
| 2012-12-12 | META | Stock | 28.0 | 28.14 | 27.37 | 27.58 | 46704200.0 |
| 2012-12-12 | TSLA | Stock | 2.3473 | 2.3867 | 2.33 | 2.3507 | 30957000.0 |
| 2012-12-12 | TLT | Stock | 123.83 | 124.34 | 122.57 | 122.59 | 7119692.0 |
| 2012-12-12 | ES | Stock | 39.53 | 40.06 | 39.5 | 39.71 | 1836900.0 |
| 2012-12-12 | CL | Stock | 54.0 | 54.095 | 53.34 | 53.495 | 2731200.0 |
| 2012-12-12 | A | Stock | 28.4692 | 29.2132 | 28.3977 | 28.9771 | 8645931.0 |
| 2012-12-12 | AABA-DELISTED | Stock | 19.56 | 19.6 | 19.34 | 19.39 | 20762413.0 |
| 2012-12-12 | AACC-DELISTED | Stock | 4.59 | 4.78 | 4.52 | 4.52 | 15906.0 |
| 2012-12-12 | AACG | Stock | 3.93 | 4.14 | 3.93 | 4.1 | 26600.0 |
| 2012-12-12 | AAIC-DELISTED | Stock | 22.56 | 22.56 | 22.06 | 22.22 | 212271.0 |
| 2012-12-12 | AAME | Stock | 2.88 | 2.94 | 2.88 | 2.92 | 1300.0 |
| 2012-12-12 | AAMRQ-DELISTED | Stock | 0.596 | 0.652 | 0.592 | 0.652 | 6685187.0 |
| 2012-12-12 | AAON | Stock | 6.1719 | 6.2104 | 6.0267 | 6.0681 | 279788.0 |
| 2012-12-12 | AAP | Stock | 73.29 | 75.44 | 72.63 | 72.79 | 1011200.0 |
| 2012-12-12 | AAT | Stock | 27.11 | 27.31 | 26.72 | 26.81 | 54400.0 |
| 2012-12-12 | AAU-DELISTED | Stock | 3.26 | 3.285 | 3.22 | 3.245 | 148834.0 |
| 2012-12-12 | AAUAF-DELISTED | Stock | 3.25 | 3.28 | 3.22 | 3.25 | 149793.0 |
| 2012-12-12 | AAV-DELISTED | Stock | 3.31 | 3.38 | 3.31 | 3.35 | 362808.0 |
| 2012-12-12 | AAWW-DELISTED | Stock | 43.25 | 43.69 | 42.4 | 42.44 | 122410.0 |
| 2012-12-12 | AAXJ | Stock | 59.92 | 60.112 | 59.67 | 59.78 | 273005.0 |
| 2012-12-12 | AAXN-DELISTED | Stock | 8.26 | 8.2899 | 7.94 | 7.94 | 866437.0 |
| 2012-12-12 | AB | Stock | 17.23 | 17.23 | 16.67 | 16.97 | 678000.0 |
| 2012-12-12 | ABAC-DELISTED | Stock | 0.97 | 0.98 | 0.86 | 0.86 | 1900.0 |
| 2012-12-12 | ABAX-DELISTED | Stock | 38.94 | 39.01 | 38.13 | 38.15 | 80196.0 |
| 2012-12-12 | ABB-DELISTED | Stock | 20.07 | 20.25 | 20.07 | 20.08 | 1133424.0 |
| 2012-12-12 | ABBNY-DELISTED | Stock | 20.07 | 20.25 | 20.07 | 20.09 | 1269668.0 |
| 2012-12-12 | ABC-DELISTED | Stock | 43.59 | 43.59 | 42.32 | 42.7 | 5258275.0 |
| 2012-12-12 | ABCB | Stock | 12.22 | 12.25 | 12.11 | 12.13 | 42300.0 |
| 2012-12-12 | ABCD-DELISTED | Stock | 1.05 | 1.14 | 1.03 | 1.03 | 6990.0 |
| 2012-12-12 | ABCO-DELISTED | Stock | 49.38 | 49.38 | 48.3901 | 48.91 | 132344.0 |
| 2012-12-12 | ABCW-DELISTED | Stock | 0.3898 | 0.3898 | 0.35 | 0.35 | 40712.0 |
| 2012-12-12 | ABE-DELISTED | Stock | 20.51 | 20.55 | 20.43 | 20.55 | 2838.0 |
| 2012-12-12 | ABEO | Stock | 287.5 | 312.5 | 287.5 | 312.5 | 162.0 |
| 2012-12-12 | ABFS-DELISTED | Stock | 9.17 | 9.18 | 8.8 | 8.88 | 403355.0 |
| 2012-12-12 | ABG | Stock | 31.0 | 31.19 | 30.1 | 30.28 | 220900.0 |
| 2012-12-12 | ABM | Stock | 20.78 | 20.87 | 20.24 | 20.32 | 556400.0 |
| 2012-12-12 | ABMD-DELISTED | Stock | 13.84 | 14.055 | 12.7805 | 13.04 | 913097.0 |
| 2012-12-12 | ABR | Stock | 5.3 | 5.66 | 5.29 | 5.59 | 911100.0 |
| 2012-12-12 | ABT | Stock | 31.7676 | 32.0746 | 31.6044 | 31.6716 | 19106294.0 |
| 2012-12-12 | ABTL-DELISTED | Stock | 3.9 | 3.9 | 3.79 | 3.86 | 99645.0 |
| 2012-12-12 | ABUS | Stock | 4.99 | 5.0 | 4.83 | 4.86 | 27500.0 |
| 2012-12-12 | ABV-DELISTED | Stock | 42.5 | 42.52 | 42.08 | 42.26 | 3043227.0 |
| 2012-12-12 | ABVA-DELISTED | Stock | 4.7 | 4.76 | 4.6 | 4.736 | 8086.0 |
| 2012-12-12 | ABX-DELISTED | Stock | 34.43 | 35.53 | 34.33 | 35.13 | 8309694.0 |
| 2012-12-12 | ACAD | Stock | 4.96 | 5.18 | 4.83 | 5.01 | 9503500.0 |
| 2012-12-12 | ACAS-DELISTED | Stock | 12.12 | 12.19 | 12.04 | 12.09 | 2901938.0 |
> showing 50 of 6,250 rows — these rows as CSV