PREVIEW / stock_daily / 2010-10-14
file: by_date/stock_daily/2010/2010-10-14.parquet size: 193 KB rows: 5,980 symbols: 3,500
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-14 | AAPL | Stock | 10.7746 | 10.8025 | 10.7286 | 10.7968 | 435296400.0 |
| 2010-10-14 | MSFT | Stock | 25.29 | 25.34 | 25.0 | 25.23 | 51949100.0 |
| 2010-10-14 | NVDA | Stock | 0.2838 | 0.2842 | 0.2778 | 0.279 | 599172000.0 |
| 2010-10-14 | AMZN | Stock | 7.758 | 7.8475 | 7.7115 | 7.7765 | 80482000.0 |
| 2010-10-14 | TSLA | Stock | 1.4 | 1.402 | 1.36 | 1.3833 | 4422000.0 |
| 2010-10-14 | TLT | Stock | 103.29 | 103.65 | 101.47 | 101.508 | 10947068.0 |
| 2010-10-14 | ES | Stock | 30.47 | 30.6 | 30.29 | 30.44 | 1040700.0 |
| 2010-10-14 | CL | Stock | 37.855 | 38.23 | 37.775 | 37.92 | 4183200.0 |
| 2010-10-14 | A | Stock | 24.5207 | 24.5708 | 24.3419 | 24.485 | 4072514.0 |
| 2010-10-14 | AABA-DELISTED | Stock | 16.75 | 16.76 | 15.75 | 15.93 | 118979025.0 |
| 2010-10-14 | AACC-DELISTED | Stock | 5.59 | 5.71 | 5.43 | 5.68 | 33227.0 |
| 2010-10-14 | AACG | Stock | 3.13 | 3.13 | 3.12 | 3.13 | 600.0 |
| 2010-10-14 | AAI-DELISTED | Stock | 7.37 | 7.39 | 7.35 | 7.37 | 5523809.0 |
| 2010-10-14 | AAIC-DELISTED | Stock | 23.47 | 23.55 | 23.37 | 23.52 | 38594.0 |
| 2010-10-14 | AAME | Stock | 1.72 | 1.75 | 1.66 | 1.66 | 8300.0 |
| 2010-10-14 | AAON | Stock | 4.9264 | 4.9442 | 4.8711 | 4.9304 | 79987.0 |
| 2010-10-14 | AAP | Stock | 60.08 | 60.39 | 59.55 | 59.79 | 534700.0 |
| 2010-10-14 | AATI-DELISTED | Stock | 3.64 | 3.91 | 3.64 | 3.86 | 164110.0 |
| 2010-10-14 | AAU-DELISTED | Stock | 2.91 | 2.9993 | 2.85 | 2.85 | 452652.0 |
| 2010-10-14 | AAUAF-DELISTED | Stock | 2.91 | 2.9993 | 2.85 | 2.85 | 453152.0 |
| 2010-10-14 | AAV-DELISTED | Stock | 6.55 | 6.64 | 6.45 | 6.5 | 326080.0 |
| 2010-10-14 | AAWW-DELISTED | Stock | 55.17 | 55.37 | 54.27 | 54.76 | 170541.0 |
| 2010-10-14 | AAXJ | Stock | 63.36 | 63.37 | 62.8719 | 63.19 | 592657.0 |
| 2010-10-14 | AAXN-DELISTED | Stock | 4.17 | 4.26 | 4.14 | 4.16 | 383378.0 |
| 2010-10-14 | AB | Stock | 27.07 | 27.23 | 26.07 | 26.8 | 660700.0 |
| 2010-10-14 | ABAC-DELISTED | Stock | 5.28 | 6.07 | 5.28 | 5.86 | 222948.0 |
| 2010-10-14 | ABAX-DELISTED | Stock | 24.07 | 24.42 | 23.94 | 24.2 | 33337.0 |
| 2010-10-14 | ABB-DELISTED | Stock | 22.63 | 22.7 | 22.44 | 22.56 | 2605324.0 |
| 2010-10-14 | ABBC-DELISTED | Stock | 10.97 | 10.99 | 10.69 | 10.8 | 30924.0 |
| 2010-10-14 | ABBNY-DELISTED | Stock | 22.63 | 22.7 | 22.44 | 22.54 | 2647757.0 |
| 2010-10-14 | ABC-DELISTED | Stock | 32.39 | 32.5 | 32.05 | 32.29 | 2330146.0 |
| 2010-10-14 | ABCB | Stock | 9.53 | 9.55 | 9.33 | 9.48 | 44200.0 |
| 2010-10-14 | ABCD-DELISTED | Stock | 3.25 | 3.29 | 3.11 | 3.18 | 81143.0 |
| 2010-10-14 | ABCO-DELISTED | Stock | 23.1 | 23.48 | 23.09 | 23.46 | 39657.0 |
| 2010-10-14 | ABCW-DELISTED | Stock | 0.68 | 0.69 | 0.68 | 0.68 | 36510.0 |
| 2010-10-14 | ABD-DELISTED | Stock | 6.15 | 6.2 | 5.89 | 5.97 | 272190.0 |
| 2010-10-14 | ABE-DELISTED | Stock | 19.65 | 19.65 | 19.511 | 19.59 | 29894.0 |
| 2010-10-14 | ABEO | Stock | 3400.0 | 3500.0 | 3312.5 | 3375.0 | 108.0 |
| 2010-10-14 | ABFS-DELISTED | Stock | 25.04 | 25.19 | 24.73 | 24.99 | 376705.0 |
| 2010-10-14 | ABG | Stock | 14.67 | 14.98 | 14.52 | 14.61 | 253000.0 |
| 2010-10-14 | ABII-DELISTED | Stock | 77.49 | 78.56 | 77.49 | 78.35 | 182871.0 |
| 2010-10-14 | ABK-DELISTED | Stock | 0.84 | 0.97 | 0.81 | 0.9506 | 58387598.0 |
| 2010-10-14 | ABM | Stock | 22.62 | 22.62 | 22.32 | 22.6 | 174800.0 |
| 2010-10-14 | ABMD-DELISTED | Stock | 10.85 | 10.92 | 10.59 | 10.72 | 60048.0 |
| 2010-10-14 | ABR | Stock | 5.54 | 5.56 | 5.41 | 5.51 | 16500.0 |
| 2010-10-14 | ABT | Stock | 25.5302 | 25.5589 | 25.343 | 25.5302 | 12357441.0 |
| 2010-10-14 | ABTL-DELISTED | Stock | 4.1064 | 4.2936 | 4.0439 | 4.2436 | 25518.0 |
| 2010-10-14 | ABV-DELISTED | Stock | 139.28 | 140.53 | 138.74 | 139.99 | 866977.0 |
| 2010-10-14 | ABVA-DELISTED | Stock | 2.75 | 2.76 | 2.74 | 2.74 | 8600.0 |
| 2010-10-14 | ABVT-DELISTED | Stock | 52.65 | 53.64 | 52.64 | 53.29 | 93771.0 |
> showing 50 of 5,980 rows — these rows as CSV