PREVIEW / stock_daily / 2012-12-03
file: by_date/stock_daily/2012/2012-12-03.parquet size: 201 KB rows: 6,234 symbols: 3,527
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-03 | AAPL | Stock | 21.2018 | 21.2354 | 20.9107 | 20.9354 | 364280000.0 |
| 2012-12-03 | MSFT | Stock | 26.78 | 26.82 | 26.4 | 26.43 | 53173800.0 |
| 2012-12-03 | NVDA | Stock | 0.303 | 0.303 | 0.293 | 0.2938 | 391380000.0 |
| 2012-12-03 | AMZN | Stock | 12.627 | 12.708 | 12.5 | 12.5165 | 59812000.0 |
| 2012-12-03 | META | Stock | 28.0 | 28.88 | 26.98 | 27.04 | 123526100.0 |
| 2012-12-03 | TSLA | Stock | 2.2593 | 2.3333 | 2.2333 | 2.308 | 31285500.0 |
| 2012-12-03 | TLT | Stock | 123.72 | 124.79 | 123.62 | 124.66 | 5427904.0 |
| 2012-12-03 | ES | Stock | 38.74 | 38.79 | 38.14 | 38.56 | 1106600.0 |
| 2012-12-03 | CL | Stock | 54.315 | 54.5 | 54.005 | 54.045 | 2029200.0 |
| 2012-12-03 | A | Stock | 27.6109 | 27.8255 | 27.0959 | 27.1245 | 3794871.0 |
| 2012-12-03 | AABA-DELISTED | Stock | 18.55 | 18.84 | 18.34 | 18.56 | 29354290.0 |
| 2012-12-03 | AACC-DELISTED | Stock | 5.68 | 5.75 | 5.21 | 5.32 | 37175.0 |
| 2012-12-03 | AACG | Stock | 4.14 | 4.17 | 4.07 | 4.17 | 4100.0 |
| 2012-12-03 | AAIC-DELISTED | Stock | 21.75 | 21.7883 | 21.38 | 21.42 | 142030.0 |
| 2012-12-03 | AAME | Stock | 2.94 | 2.94 | 2.94 | 2.94 | 100.0 |
| 2012-12-03 | AAMRQ-DELISTED | Stock | 0.4855 | 0.519 | 0.482 | 0.5 | 2213629.0 |
| 2012-12-03 | AAON | Stock | 6.4444 | 6.64 | 6.2667 | 6.3259 | 364838.0 |
| 2012-12-03 | AAP | Stock | 73.51 | 74.22 | 71.94 | 73.17 | 1363200.0 |
| 2012-12-03 | AAT | Stock | 27.39 | 27.47 | 26.96 | 27.04 | 238400.0 |
| 2012-12-03 | AAU-DELISTED | Stock | 2.79 | 3.0 | 2.79 | 2.94 | 422878.0 |
| 2012-12-03 | AAUAF-DELISTED | Stock | 2.79 | 3.0 | 2.79 | 2.93 | 426529.0 |
| 2012-12-03 | AAV-DELISTED | Stock | 3.38 | 3.38 | 3.33 | 3.35 | 288645.0 |
| 2012-12-03 | AAWW-DELISTED | Stock | 43.41 | 43.475 | 42.72 | 42.83 | 203829.0 |
| 2012-12-03 | AAXJ | Stock | 58.16 | 58.31 | 57.91 | 57.93 | 484634.0 |
| 2012-12-03 | AAXN-DELISTED | Stock | 8.29 | 8.3 | 7.71 | 8.12 | 845278.0 |
| 2012-12-03 | AB | Stock | 17.65 | 17.99 | 17.62 | 17.91 | 216200.0 |
| 2012-12-03 | ABAC-DELISTED | Stock | 0.87 | 0.8901 | 0.81 | 0.82 | 15945.0 |
| 2012-12-03 | ABAX-DELISTED | Stock | 37.92 | 37.92 | 37.11 | 37.32 | 70295.0 |
| 2012-12-03 | ABB-DELISTED | Stock | 19.69 | 19.71 | 19.42 | 19.44 | 1438926.0 |
| 2012-12-03 | ABBNY-DELISTED | Stock | 19.69 | 19.71 | 19.42 | 19.43 | 1500794.0 |
| 2012-12-03 | ABC-DELISTED | Stock | 42.26 | 42.585 | 42.19 | 42.42 | 2830131.0 |
| 2012-12-03 | ABCB | Stock | 11.48 | 11.67 | 11.21 | 11.56 | 41200.0 |
| 2012-12-03 | ABCD-DELISTED | Stock | 0.93 | 1.13 | 0.93 | 1.0801 | 67475.0 |
| 2012-12-03 | ABCO-DELISTED | Stock | 45.38 | 45.45 | 44.595 | 45.3 | 134566.0 |
| 2012-12-03 | ABCW-DELISTED | Stock | 0.3811 | 0.4099 | 0.372 | 0.372 | 46814.0 |
| 2012-12-03 | ABE-DELISTED | Stock | 20.49 | 20.57 | 20.38 | 20.45 | 21463.0 |
| 2012-12-03 | ABEO | Stock | 400.0 | 400.0 | 375.0 | 375.0 | 20.0 |
| 2012-12-03 | ABFS-DELISTED | Stock | 8.34 | 8.5 | 8.1115 | 8.32 | 277300.0 |
| 2012-12-03 | ABG | Stock | 30.52 | 30.81 | 30.16 | 30.64 | 198500.0 |
| 2012-12-03 | ABM | Stock | 19.14 | 19.34 | 18.22 | 19.28 | 190100.0 |
| 2012-12-03 | ABMD-DELISTED | Stock | 13.47 | 13.47 | 12.7 | 12.8 | 1822089.0 |
| 2012-12-03 | ABR | Stock | 5.28 | 5.31 | 5.17 | 5.25 | 44400.0 |
| 2012-12-03 | ABT | Stock | 31.2302 | 31.3405 | 30.7936 | 30.8463 | 13778449.0 |
| 2012-12-03 | ABTL-DELISTED | Stock | 3.86 | 3.86 | 3.8 | 3.84 | 4464.0 |
| 2012-12-03 | ABUS | Stock | 4.98 | 4.99 | 4.76 | 4.83 | 28600.0 |
| 2012-12-03 | ABV-DELISTED | Stock | 41.87 | 42.33 | 41.68 | 42.03 | 2404034.0 |
| 2012-12-03 | ABVA-DELISTED | Stock | 4.53 | 4.7 | 4.5 | 4.7 | 13899.0 |
| 2012-12-03 | ABX-DELISTED | Stock | 34.62 | 34.67 | 33.66 | 33.7 | 10007139.0 |
| 2012-12-03 | ACAD | Stock | 5.24 | 5.27 | 5.04 | 5.12 | 2789000.0 |
| 2012-12-03 | ACAS-DELISTED | Stock | 12.0 | 12.0 | 11.86 | 11.89 | 3218395.0 |
> showing 50 of 6,234 rows — these rows as CSV