PREVIEW / stock_daily / 2012-05-22
file: by_date/stock_daily/2012/2012-05-22.parquet size: 198 KB rows: 6,190 symbols: 3,548
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-05-22 | AAPL | Stock | 20.3411 | 20.4957 | 19.735 | 19.8918 | 694870400.0 |
| 2012-05-22 | MSFT | Stock | 29.69 | 29.88 | 29.5 | 29.76 | 39504900.0 |
| 2012-05-22 | NVDA | Stock | 0.307 | 0.3075 | 0.299 | 0.3035 | 410140000.0 |
| 2012-05-22 | AMZN | Stock | 10.9155 | 10.9435 | 10.698 | 10.7665 | 74662000.0 |
| 2012-05-22 | META | Stock | 32.61 | 33.59 | 30.94 | 31.0 | 101786600.0 |
| 2012-05-22 | TSLA | Stock | 2.0067 | 2.0893 | 2.0 | 2.0533 | 35493000.0 |
| 2012-05-22 | TLT | Stock | 122.75 | 122.88 | 122.06 | 122.56 | 12476766.0 |
| 2012-05-22 | ES | Stock | 35.79 | 36.32 | 35.79 | 36.25 | 2154200.0 |
| 2012-05-22 | CL | Stock | 49.565 | 50.055 | 49.48 | 49.595 | 4480600.0 |
| 2012-05-22 | A | Stock | 28.6552 | 29.4707 | 28.3405 | 28.9628 | 6180139.0 |
| 2012-05-22 | AABA-DELISTED | Stock | 15.55 | 15.61 | 15.19 | 15.31 | 27536545.0 |
| 2012-05-22 | AACC-DELISTED | Stock | 5.62 | 5.92 | 5.62 | 5.76 | 52142.0 |
| 2012-05-22 | AAIC-DELISTED | Stock | 22.76 | 22.84 | 22.5 | 22.59 | 60283.0 |
| 2012-05-22 | AAME | Stock | 2.8 | 2.85 | 2.75 | 2.75 | 7600.0 |
| 2012-05-22 | AAMRQ-DELISTED | Stock | 0.4625 | 0.466 | 0.455 | 0.46 | 1163874.0 |
| 2012-05-22 | AAON | Stock | 5.7422 | 5.7689 | 5.5763 | 5.6296 | 351000.0 |
| 2012-05-22 | AAP | Stock | 68.98 | 70.12 | 68.66 | 68.97 | 2575200.0 |
| 2012-05-22 | AAT | Stock | 22.87 | 23.25 | 22.87 | 23.03 | 96500.0 |
| 2012-05-22 | AAU-DELISTED | Stock | 2.07 | 2.1 | 1.98 | 1.98 | 148044.0 |
| 2012-05-22 | AAUAF-DELISTED | Stock | 2.07 | 2.1 | 1.98 | 1.98 | 148844.0 |
| 2012-05-22 | AAV-DELISTED | Stock | 2.97 | 3.0 | 2.88 | 2.89 | 214133.0 |
| 2012-05-22 | AAWW-DELISTED | Stock | 47.3 | 47.43 | 45.06 | 45.79 | 291976.0 |
| 2012-05-22 | AAXJ | Stock | 51.26 | 51.59 | 50.8 | 51.11 | 735776.0 |
| 2012-05-22 | AAXN-DELISTED | Stock | 5.34 | 5.4 | 5.26 | 5.27 | 542786.0 |
| 2012-05-22 | AB | Stock | 13.75 | 13.82 | 13.47 | 13.49 | 145000.0 |
| 2012-05-22 | ABAC-DELISTED | Stock | 1.26 | 1.36 | 1.26 | 1.31 | 2990.0 |
| 2012-05-22 | ABAX-DELISTED | Stock | 33.16 | 33.36 | 32.46 | 32.82 | 95524.0 |
| 2012-05-22 | ABB-DELISTED | Stock | 16.64 | 16.74 | 16.33 | 16.431 | 4023752.0 |
| 2012-05-22 | ABBNY-DELISTED | Stock | 16.64 | 16.74 | 16.33 | 16.43 | 4224249.0 |
| 2012-05-22 | ABC-DELISTED | Stock | 36.69 | 36.73 | 36.09 | 36.25 | 2022224.0 |
| 2012-05-22 | ABCB | Stock | 11.71 | 11.75 | 11.18 | 11.29 | 65000.0 |
| 2012-05-22 | ABCD-DELISTED | Stock | 1.32 | 1.47 | 1.21 | 1.26 | 61741.0 |
| 2012-05-22 | ABCO-DELISTED | Stock | 48.01 | 48.2 | 47.25 | 47.89 | 248142.0 |
| 2012-05-22 | ABCW-DELISTED | Stock | 0.5522 | 0.5522 | 0.5121 | 0.5121 | 7130.0 |
| 2012-05-22 | ABE-DELISTED | Stock | 18.35 | 18.35 | 17.95 | 18.07 | 3760.0 |
| 2012-05-22 | ABEO | Stock | 625.0 | 700.0 | 625.0 | 700.0 | 58.0 |
| 2012-05-22 | ABFS-DELISTED | Stock | 12.92 | 13.4599 | 12.58 | 12.68 | 321959.0 |
| 2012-05-22 | ABG | Stock | 26.39 | 27.0 | 26.13 | 26.45 | 342400.0 |
| 2012-05-22 | ABH-DELISTED | Stock | 10.495 | 10.666 | 10.355 | 10.565 | 361750.0 |
| 2012-05-22 | ABM | Stock | 21.66 | 21.83 | 21.48 | 21.59 | 421800.0 |
| 2012-05-22 | ABMD-DELISTED | Stock | 23.38 | 23.61 | 22.15 | 22.44 | 2243111.0 |
| 2012-05-22 | ABR | Stock | 6.05 | 6.27 | 6.0 | 6.13 | 40800.0 |
| 2012-05-22 | ABT | Stock | 29.6516 | 29.9155 | 29.6085 | 29.7428 | 16218216.0 |
| 2012-05-22 | ABTL-DELISTED | Stock | 3.79 | 3.8892 | 3.7351 | 3.76 | 8836.0 |
| 2012-05-22 | ABUS | Stock | 2.05 | 2.13 | 1.92 | 2.12 | 3200.0 |
| 2012-05-22 | ABV-DELISTED | Stock | 37.18 | 38.135 | 36.88 | 37.56 | 3957187.0 |
| 2012-05-22 | ABVA-DELISTED | Stock | 4.06 | 4.3 | 4.06 | 4.3 | 10712.0 |
| 2012-05-22 | ABVT-DELISTED | Stock | 83.2 | 83.26 | 83.04 | 83.26 | 159162.0 |
| 2012-05-22 | ABX-DELISTED | Stock | 38.02 | 38.64 | 37.31 | 37.63 | 9786896.0 |
| 2012-05-22 | ACAD | Stock | 1.39 | 1.46 | 1.36 | 1.39 | 383000.0 |
> showing 50 of 6,190 rows — these rows as CSV