PREVIEW / stock_daily / 2009-03-11
file: by_date/stock_daily/2009/2009-03-11.parquet size: 174 KB rows: 5,741 symbols: 3,429
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-03-11 | AAPL | Stock | 3.2075 | 3.3596 | 3.1993 | 3.31 | 846372800.0 |
| 2009-03-11 | MSFT | Stock | 16.63 | 17.2 | 16.43 | 17.11 | 84522200.0 |
| 2009-03-11 | NVDA | Stock | 0.2263 | 0.2962 | 0.2225 | 0.2325 | 864916000.0 |
| 2009-03-11 | AMZN | Stock | 3.312 | 3.4685 | 3.2635 | 3.427 | 277634000.0 |
| 2009-03-11 | TLT | Stock | 101.29 | 102.76 | 100.93 | 102.76 | 3101569.0 |
| 2009-03-11 | ES | Stock | 20.0 | 20.38 | 19.81 | 20.1 | 1853900.0 |
| 2009-03-11 | CL | Stock | 28.05 | 28.5 | 27.93 | 28.19 | 5569200.0 |
| 2009-03-11 | A | Stock | 9.6996 | 9.9857 | 9.578 | 9.6781 | 5358254.0 |
| 2009-03-11 | AABA-DELISTED | Stock | 13.31 | 13.5 | 13.03 | 13.4 | 17357226.0 |
| 2009-03-11 | AACC-DELISTED | Stock | 3.91 | 4.45 | 3.91 | 4.14 | 56018.0 |
| 2009-03-11 | AACG | Stock | 5.03 | 5.03 | 4.81 | 4.81 | 25400.0 |
| 2009-03-11 | AAI-DELISTED | Stock | 3.48 | 3.6 | 3.41 | 3.55 | 2348904.0 |
| 2009-03-11 | AAIC-DELISTED | Stock | 2.8 | 2.8 | 2.2 | 2.4 | 333948.0 |
| 2009-03-11 | AAON | Stock | 3.5556 | 3.84 | 3.4074 | 3.4351 | 974025.0 |
| 2009-03-11 | AAP | Stock | 38.06 | 39.64 | 37.76 | 39.4 | 2855100.0 |
| 2009-03-11 | AATI-DELISTED | Stock | 3.0 | 3.11 | 2.86 | 3.07 | 231336.0 |
| 2009-03-11 | AAU-DELISTED | Stock | 0.68 | 0.68 | 0.63 | 0.66 | 106819.0 |
| 2009-03-11 | AAUAF-DELISTED | Stock | 0.68 | 0.68 | 0.63 | 0.66 | 107819.0 |
| 2009-03-11 | AAV-DELISTED | Stock | 2.11 | 2.2 | 2.01 | 2.03 | 465547.0 |
| 2009-03-11 | AAWW-DELISTED | Stock | 11.38 | 12.3678 | 11.27 | 11.6 | 227156.0 |
| 2009-03-11 | AAXJ | Stock | 29.84 | 29.994 | 29.2 | 29.43 | 37535.0 |
| 2009-03-11 | AAXN-DELISTED | Stock | 4.23 | 4.39 | 4.0201 | 4.16 | 498030.0 |
| 2009-03-11 | AB | Stock | 11.7 | 12.8 | 11.28 | 12.28 | 1259000.0 |
| 2009-03-11 | ABAX-DELISTED | Stock | 17.65 | 18.25 | 17.05 | 17.06 | 154160.0 |
| 2009-03-11 | ABB-DELISTED | Stock | 13.21 | 13.36 | 12.95 | 13.14 | 7329360.0 |
| 2009-03-11 | ABBC-DELISTED | Stock | 7.27 | 7.5496 | 6.92 | 7.37 | 92129.0 |
| 2009-03-11 | ABBNY-DELISTED | Stock | 13.21 | 13.36 | 12.95 | 13.13 | 7436870.0 |
| 2009-03-11 | ABC-DELISTED | Stock | 15.64 | 15.64 | 14.075 | 14.1 | 12970052.0 |
| 2009-03-11 | ABCB | Stock | 4.5131 | 5.2912 | 4.5131 | 4.659 | 29816.0 |
| 2009-03-11 | ABCO-DELISTED | Stock | 7.282 | 7.362 | 7.028 | 7.103 | 93980.0 |
| 2009-03-11 | ABCW-DELISTED | Stock | 0.4898 | 0.4898 | 0.4702 | 0.48 | 80560.0 |
| 2009-03-11 | ABD-DELISTED | Stock | 1.34 | 1.59 | 1.2 | 1.25 | 186070.0 |
| 2009-03-11 | ABE-DELISTED | Stock | 10.9 | 11.35 | 10.75 | 11.15 | 28850.0 |
| 2009-03-11 | ABEO | Stock | 1750.0 | 2025.0 | 1625.0 | 2025.0 | 4.0 |
| 2009-03-11 | ABFS-DELISTED | Stock | 17.81 | 18.86 | 17.65 | 18.05 | 758654.0 |
| 2009-03-11 | ABG | Stock | 2.22 | 2.3 | 2.01 | 2.01 | 257900.0 |
| 2009-03-11 | ABII-DELISTED | Stock | 57.46 | 57.46 | 54.7 | 54.7 | 11576.0 |
| 2009-03-11 | ABK-DELISTED | Stock | 0.51 | 0.56 | 0.47 | 0.4856 | 7904154.0 |
| 2009-03-11 | ABM | Stock | 15.01 | 15.05 | 14.64 | 14.92 | 488300.0 |
| 2009-03-11 | ABMD-DELISTED | Stock | 5.46 | 5.76 | 5.32 | 5.66 | 451455.0 |
| 2009-03-11 | ABR | Stock | 0.7 | 0.87 | 0.65 | 0.84 | 109800.0 |
| 2009-03-11 | ABT | Stock | 22.6945 | 22.6945 | 21.3127 | 21.3367 | 30730096.0 |
| 2009-03-11 | ABTL-DELISTED | Stock | 1.4 | 1.4 | 1.2 | 1.2 | 33640.0 |
| 2009-03-11 | ABV-DELISTED | Stock | 42.53 | 43.06 | 41.83 | 42.21 | 608234.0 |
| 2009-03-11 | ABVA-DELISTED | Stock | 1.75 | 1.75 | 1.72 | 1.75 | 2131.0 |
| 2009-03-11 | ABX-DELISTED | Stock | 26.34 | 27.75 | 25.54 | 27.38 | 17439206.0 |
| 2009-03-11 | ACAD | Stock | 1.0 | 1.0 | 0.9 | 0.91 | 64900.0 |
| 2009-03-11 | ACAP-DELISTED | Stock | 40.37 | 40.93 | 39.3 | 40.05 | 72670.0 |
| 2009-03-11 | ACAS-DELISTED | Stock | 0.94 | 0.94 | 0.7478 | 0.84 | 6402109.0 |
| 2009-03-11 | ACAT-DELISTED | Stock | 3.22 | 3.3 | 3.02 | 3.3 | 29934.0 |
> showing 50 of 5,741 rows — these rows as CSV