PREVIEW / stock_daily / 2009-05-15
file: by_date/stock_daily/2009/2009-05-15.parquet size: 178 KB rows: 5,754 symbols: 3,442
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-15 | AAPL | Stock | 4.3686 | 4.4507 | 4.3432 | 4.3721 | 367567200.0 |
| 2009-05-15 | MSFT | Stock | 20.13 | 20.5 | 19.98 | 20.22 | 61289900.0 |
| 2009-05-15 | NVDA | Stock | 0.2145 | 0.226 | 0.212 | 0.2185 | 780308000.0 |
| 2009-05-15 | AMZN | Stock | 3.727 | 3.8105 | 3.671 | 3.68 | 160234000.0 |
| 2009-05-15 | TLT | Stock | 98.0 | 98.05 | 97.46 | 98.04 | 2306504.0 |
| 2009-05-15 | ES | Stock | 20.96 | 20.97 | 20.4 | 20.58 | 1638900.0 |
| 2009-05-15 | CL | Stock | 31.715 | 32.01 | 31.595 | 31.745 | 6349600.0 |
| 2009-05-15 | A | Stock | 12.8898 | 13.0258 | 12.3462 | 12.6252 | 7322864.0 |
| 2009-05-15 | AABA-DELISTED | Stock | 15.0 | 15.1 | 14.86 | 14.91 | 21271121.0 |
| 2009-05-15 | AACC-DELISTED | Stock | 8.72 | 8.72 | 7.77 | 8.0 | 40965.0 |
| 2009-05-15 | AACG | Stock | 4.56 | 5.09 | 4.56 | 5.09 | 57700.0 |
| 2009-05-15 | AAI-DELISTED | Stock | 6.57 | 6.76 | 6.4 | 6.42 | 2177637.0 |
| 2009-05-15 | AAIC-DELISTED | Stock | 9.2 | 9.6 | 7.8 | 9.0 | 1319785.0 |
| 2009-05-15 | AAON | Stock | 3.9328 | 3.9506 | 3.8894 | 3.9407 | 416137.0 |
| 2009-05-15 | AAP | Stock | 39.95 | 40.98 | 39.61 | 40.66 | 1160000.0 |
| 2009-05-15 | AATI-DELISTED | Stock | 4.66 | 4.85 | 4.56 | 4.61 | 345634.0 |
| 2009-05-15 | AAU-DELISTED | Stock | 0.61 | 0.63 | 0.6 | 0.6 | 50080.0 |
| 2009-05-15 | AAUAF-DELISTED | Stock | 0.61 | 0.63 | 0.6 | 0.6 | 53080.0 |
| 2009-05-15 | AAV-DELISTED | Stock | 3.35 | 3.58 | 3.35 | 3.4 | 1559596.0 |
| 2009-05-15 | AAWW-DELISTED | Stock | 23.12 | 24.4 | 23.12 | 23.74 | 582790.0 |
| 2009-05-15 | AAXJ | Stock | 41.27 | 41.37 | 40.5 | 40.82 | 131906.0 |
| 2009-05-15 | AAXN-DELISTED | Stock | 4.28 | 4.28 | 4.11 | 4.17 | 339062.0 |
| 2009-05-15 | AB | Stock | 17.02 | 17.35 | 16.61 | 16.79 | 390100.0 |
| 2009-05-15 | ABAX-DELISTED | Stock | 16.32 | 16.35 | 15.85 | 16.25 | 124416.0 |
| 2009-05-15 | ABB-DELISTED | Stock | 14.92 | 15.27 | 14.77 | 14.87 | 5155364.0 |
| 2009-05-15 | ABBC-DELISTED | Stock | 8.81 | 8.81 | 8.15 | 8.3 | 77678.0 |
| 2009-05-15 | ABBNY-DELISTED | Stock | 14.92 | 15.27 | 14.77 | 14.87 | 5201112.0 |
| 2009-05-15 | ABC-DELISTED | Stock | 17.87 | 17.87 | 17.45 | 17.52 | 3320672.0 |
| 2009-05-15 | ABCB | Stock | 6.1082 | 6.1082 | 5.3592 | 5.6802 | 43284.0 |
| 2009-05-15 | ABCO-DELISTED | Stock | 10.82 | 11.14 | 10.58 | 11.075 | 222648.0 |
| 2009-05-15 | ABCW-DELISTED | Stock | 1.6 | 1.7 | 1.55 | 1.61 | 146030.0 |
| 2009-05-15 | ABD-DELISTED | Stock | 2.82 | 3.02 | 2.5 | 2.58 | 367140.0 |
| 2009-05-15 | ABE-DELISTED | Stock | 14.15 | 14.3499 | 13.97 | 14.1 | 3200.0 |
| 2009-05-15 | ABEO | Stock | 1812.5 | 1825.0 | 1637.5 | 1750.0 | 10.0 |
| 2009-05-15 | ABFS-DELISTED | Stock | 22.71 | 25.47 | 22.02 | 24.4 | 1521456.0 |
| 2009-05-15 | ABG | Stock | 8.85 | 9.2 | 8.44 | 8.55 | 234000.0 |
| 2009-05-15 | ABII-DELISTED | Stock | 50.29 | 52.14 | 49.09 | 50.45 | 18546.0 |
| 2009-05-15 | ABK-DELISTED | Stock | 1.48 | 1.5 | 1.27 | 1.33 | 11748275.0 |
| 2009-05-15 | ABM | Stock | 16.59 | 16.66 | 16.21 | 16.42 | 357500.0 |
| 2009-05-15 | ABMD-DELISTED | Stock | 6.19 | 6.29 | 6.01 | 6.15 | 230032.0 |
| 2009-05-15 | ABR | Stock | 1.94 | 1.94 | 1.7 | 1.73 | 228900.0 |
| 2009-05-15 | ABT | Stock | 21.3751 | 21.4231 | 20.7561 | 20.7849 | 33178825.0 |
| 2009-05-15 | ABTL-DELISTED | Stock | 2.25 | 2.35 | 2.15 | 2.2 | 8112.0 |
| 2009-05-15 | ABV-DELISTED | Stock | 58.6 | 58.75 | 57.43 | 57.73 | 426146.0 |
| 2009-05-15 | ABVA-DELISTED | Stock | 2.4499 | 2.45 | 2.442 | 2.45 | 3100.0 |
| 2009-05-15 | ABVT-DELISTED | Stock | 56.0 | 59.0 | 55.486 | 57.11 | 7950.0 |
| 2009-05-15 | ABX-DELISTED | Stock | 34.2 | 34.59 | 33.15 | 33.51 | 8010301.0 |
| 2009-05-15 | ACAD | Stock | 1.67 | 1.8 | 1.5 | 1.61 | 1108700.0 |
| 2009-05-15 | ACAP-DELISTED | Stock | 38.63 | 38.64 | 37.28 | 37.81 | 99046.0 |
| 2009-05-15 | ACAS-DELISTED | Stock | 3.29 | 3.29 | 3.04 | 3.04 | 3217411.0 |
> showing 50 of 5,754 rows — these rows as CSV