PREVIEW / stock_daily / 2010-10-11
file: by_date/stock_daily/2010/2010-10-11.parquet size: 190 KB rows: 5,943 symbols: 3,478
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-11 | AAPL | Stock | 10.5264 | 10.6157 | 10.5214 | 10.5486 | 427753200.0 |
| 2010-10-11 | MSFT | Stock | 24.74 | 24.74 | 24.5 | 24.59 | 27587800.0 |
| 2010-10-11 | NVDA | Stock | 0.2728 | 0.275 | 0.269 | 0.2703 | 442680000.0 |
| 2010-10-11 | AMZN | Stock | 7.7445 | 7.8315 | 7.617 | 7.6515 | 89728000.0 |
| 2010-10-11 | TSLA | Stock | 1.3627 | 1.38 | 1.338 | 1.3493 | 2568000.0 |
| 2010-10-11 | TLT | Stock | 104.11 | 104.43 | 103.94 | 104.24 | 1474151.0 |
| 2010-10-11 | ES | Stock | 30.33 | 30.57 | 30.26 | 30.47 | 758900.0 |
| 2010-10-11 | CL | Stock | 37.575 | 37.865 | 37.275 | 37.425 | 4662600.0 |
| 2010-10-11 | A | Stock | 24.1559 | 24.299 | 23.9986 | 24.1416 | 2680246.0 |
| 2010-10-11 | AABA-DELISTED | Stock | 14.45 | 14.575 | 14.38 | 14.41 | 8217469.0 |
| 2010-10-11 | AACC-DELISTED | Stock | 5.47 | 5.77 | 5.36 | 5.69 | 35370.0 |
| 2010-10-11 | AACG | Stock | 2.96 | 3.07 | 2.96 | 3.07 | 11600.0 |
| 2010-10-11 | AAI-DELISTED | Stock | 7.35 | 7.36 | 7.34 | 7.35 | 3044546.0 |
| 2010-10-11 | AAIC-DELISTED | Stock | 23.39 | 23.69 | 23.31 | 23.42 | 52892.0 |
| 2010-10-11 | AAME | Stock | 1.72 | 1.72 | 1.68 | 1.68 | 6500.0 |
| 2010-10-11 | AAON | Stock | 4.6973 | 4.7644 | 4.6499 | 4.7407 | 146306.0 |
| 2010-10-11 | AAP | Stock | 58.49 | 59.45 | 58.28 | 59.27 | 523500.0 |
| 2010-10-11 | AATI-DELISTED | Stock | 3.49 | 3.52 | 3.43 | 3.45 | 127741.0 |
| 2010-10-11 | AAU-DELISTED | Stock | 2.93 | 3.15 | 2.91 | 3.1 | 232015.0 |
| 2010-10-11 | AAUAF-DELISTED | Stock | 2.93 | 3.15 | 2.91 | 3.1 | 232215.0 |
| 2010-10-11 | AAV-DELISTED | Stock | 6.27 | 6.33 | 6.26 | 6.3 | 126516.0 |
| 2010-10-11 | AAWW-DELISTED | Stock | 54.03 | 54.63 | 53.38 | 53.56 | 135393.0 |
| 2010-10-11 | AAXJ | Stock | 62.51 | 62.6 | 62.39 | 62.6 | 240454.0 |
| 2010-10-11 | AAXN-DELISTED | Stock | 4.16 | 4.16 | 3.99 | 4.02 | 316412.0 |
| 2010-10-11 | AB | Stock | 26.92 | 27.09 | 25.99 | 26.95 | 306300.0 |
| 2010-10-11 | ABAC-DELISTED | Stock | 4.66 | 5.48 | 4.66 | 5.48 | 221788.0 |
| 2010-10-11 | ABAX-DELISTED | Stock | 23.77 | 24.16 | 23.75 | 23.75 | 32783.0 |
| 2010-10-11 | ABB-DELISTED | Stock | 22.04 | 22.07 | 21.89 | 21.94 | 1273419.0 |
| 2010-10-11 | ABBC-DELISTED | Stock | 10.66 | 10.75 | 10.4309 | 10.68 | 22914.0 |
| 2010-10-11 | ABBNY-DELISTED | Stock | 22.04 | 22.07 | 21.89 | 21.93 | 1294890.0 |
| 2010-10-11 | ABC-DELISTED | Stock | 31.76 | 32.16 | 31.74 | 31.81 | 1929054.0 |
| 2010-10-11 | ABCB | Stock | 9.74 | 9.74 | 9.57 | 9.59 | 20300.0 |
| 2010-10-11 | ABCD-DELISTED | Stock | 3.2501 | 3.26 | 3.14 | 3.14 | 11698.0 |
| 2010-10-11 | ABCO-DELISTED | Stock | 22.55 | 22.95 | 22.44 | 22.79 | 66996.0 |
| 2010-10-11 | ABCW-DELISTED | Stock | 0.6787 | 0.6987 | 0.6787 | 0.6813 | 29490.0 |
| 2010-10-11 | ABD-DELISTED | Stock | 5.87 | 5.97 | 5.83 | 5.84 | 204550.0 |
| 2010-10-11 | ABE-DELISTED | Stock | 19.29 | 19.45 | 19.2 | 19.36 | 10768.0 |
| 2010-10-11 | ABEO | Stock | 3287.5 | 3350.0 | 3187.5 | 3287.5 | 68.0 |
| 2010-10-11 | ABFS-DELISTED | Stock | 23.96 | 24.25 | 23.91 | 24.09 | 259710.0 |
| 2010-10-11 | ABG | Stock | 14.45 | 14.55 | 14.25 | 14.32 | 103400.0 |
| 2010-10-11 | ABII-DELISTED | Stock | 76.44 | 77.09 | 76.44 | 77.0 | 134207.0 |
| 2010-10-11 | ABK-DELISTED | Stock | 0.78 | 0.8079 | 0.7239 | 0.74 | 16079739.0 |
| 2010-10-11 | ABM | Stock | 22.37 | 22.63 | 22.22 | 22.4 | 119600.0 |
| 2010-10-11 | ABMD-DELISTED | Stock | 10.76 | 10.76 | 10.6 | 10.63 | 36656.0 |
| 2010-10-11 | ABR | Stock | 5.47 | 5.55 | 5.28 | 5.31 | 42200.0 |
| 2010-10-11 | ABT | Stock | 25.3814 | 25.391 | 25.2279 | 25.3382 | 10334306.0 |
| 2010-10-11 | ABTL-DELISTED | Stock | 4.2 | 4.25 | 4.0555 | 4.25 | 5601.0 |
| 2010-10-11 | ABV-DELISTED | Stock | 133.96 | 133.96 | 132.53 | 133.33 | 345259.0 |
| 2010-10-11 | ABVA-DELISTED | Stock | 2.79 | 2.79 | 2.79 | 2.79 | 115.0 |
| 2010-10-11 | ABVT-DELISTED | Stock | 53.42 | 53.63 | 52.6 | 52.61 | 71970.0 |
> showing 50 of 5,943 rows — these rows as CSV