PREVIEW / stock_daily / 2010-01-19
file: by_date/stock_daily/2010/2010-01-19.parquet size: 191 KB rows: 5,955 symbols: 3,530
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-01-19 | AAPL | Stock | 7.4404 | 7.6854 | 7.4014 | 7.68 | 730007600.0 |
| 2010-01-19 | MSFT | Stock | 30.75 | 31.24 | 30.68 | 31.1 | 46575700.0 |
| 2010-01-19 | NVDA | Stock | 0.4245 | 0.4385 | 0.4232 | 0.4358 | 545328000.0 |
| 2010-01-19 | AMZN | Stock | 6.3155 | 6.4 | 6.2165 | 6.3805 | 177852000.0 |
| 2010-01-19 | TLT | Stock | 90.72 | 91.122 | 90.42 | 90.82 | 2496039.0 |
| 2010-01-19 | ES | Stock | 25.93 | 26.44 | 25.93 | 26.41 | 1204800.0 |
| 2010-01-19 | CL | Stock | 40.015 | 40.365 | 39.895 | 40.295 | 4460400.0 |
| 2010-01-19 | A | Stock | 21.7167 | 22.0529 | 21.7096 | 22.0315 | 3563642.0 |
| 2010-01-19 | AABA-DELISTED | Stock | 16.81 | 16.96 | 16.64 | 16.75 | 15087604.0 |
| 2010-01-19 | AACC-DELISTED | Stock | 6.06 | 6.46 | 5.7675 | 6.21 | 23093.0 |
| 2010-01-19 | AACG | Stock | 4.48 | 4.49 | 4.45 | 4.45 | 2000.0 |
| 2010-01-19 | AAI-DELISTED | Stock | 5.42 | 5.595 | 5.36 | 5.4 | 3246897.0 |
| 2010-01-19 | AAIC-DELISTED | Stock | 16.47 | 16.47 | 15.88 | 16.02 | 26378.0 |
| 2010-01-19 | AAME | Stock | 1.24 | 1.39 | 1.15 | 1.39 | 15400.0 |
| 2010-01-19 | AAON | Stock | 3.7788 | 3.8874 | 3.7393 | 3.8084 | 639394.0 |
| 2010-01-19 | AAP | Stock | 39.3 | 39.52 | 39.05 | 39.5 | 1295000.0 |
| 2010-01-19 | AATI-DELISTED | Stock | 3.94 | 4.0 | 3.88 | 3.99 | 519481.0 |
| 2010-01-19 | AAU-DELISTED | Stock | 1.06 | 1.16 | 1.029 | 1.09 | 585197.0 |
| 2010-01-19 | AAUAF-DELISTED | Stock | 1.06 | 1.16 | 1.029 | 1.09 | 597445.0 |
| 2010-01-19 | AAV-DELISTED | Stock | 7.0 | 7.07 | 6.91 | 6.93 | 723494.0 |
| 2010-01-19 | AAWW-DELISTED | Stock | 39.34 | 40.22 | 39.03 | 39.6 | 475363.0 |
| 2010-01-19 | AAXJ | Stock | 57.24 | 57.94 | 57.18 | 57.94 | 296048.0 |
| 2010-01-19 | AAXN-DELISTED | Stock | 6.32 | 6.687 | 6.29 | 6.3 | 1667710.0 |
| 2010-01-19 | AB | Stock | 29.13 | 29.95 | 28.9 | 29.58 | 537000.0 |
| 2010-01-19 | ABAX-DELISTED | Stock | 25.63 | 26.085 | 25.37 | 25.9 | 100114.0 |
| 2010-01-19 | ABB-DELISTED | Stock | 19.45 | 19.85 | 19.43 | 19.84 | 4015063.0 |
| 2010-01-19 | ABBC-DELISTED | Stock | 7.08 | 7.2 | 7.05 | 7.16 | 24510.0 |
| 2010-01-19 | ABBNY-DELISTED | Stock | 19.46 | 19.85 | 19.43 | 19.83 | 4019376.0 |
| 2010-01-19 | ABC-DELISTED | Stock | 26.96 | 27.61 | 26.92 | 27.39 | 2711335.0 |
| 2010-01-19 | ABCB | Stock | 7.9902 | 8.5432 | 7.9902 | 8.5235 | 84948.0 |
| 2010-01-19 | ABCD-DELISTED | Stock | 4.06 | 4.09 | 3.9 | 4.06 | 49283.0 |
| 2010-01-19 | ABCO-DELISTED | Stock | 15.977 | 16.268 | 15.932 | 16.258 | 65179.0 |
| 2010-01-19 | ABCW-DELISTED | Stock | 1.02 | 1.19 | 0.98 | 1.13 | 506840.0 |
| 2010-01-19 | ABD-DELISTED | Stock | 8.195 | 8.465 | 8.195 | 8.435 | 283170.0 |
| 2010-01-19 | ABE-DELISTED | Stock | 16.72 | 17.12 | 16.72 | 17.12 | 11549.0 |
| 2010-01-19 | ABEO | Stock | 4087.5 | 4087.5 | 3812.5 | 3875.0 | 31.0 |
| 2010-01-19 | ABFS-DELISTED | Stock | 27.9 | 28.12 | 27.32 | 27.42 | 312451.0 |
| 2010-01-19 | ABG | Stock | 13.29 | 13.49 | 13.07 | 13.16 | 339100.0 |
| 2010-01-19 | ABII-DELISTED | Stock | 41.01 | 41.4999 | 40.47 | 41.44 | 55749.0 |
| 2010-01-19 | ABK-DELISTED | Stock | 0.76 | 0.765 | 0.71 | 0.74 | 10934409.0 |
| 2010-01-19 | ABM | Stock | 20.44 | 20.71 | 20.31 | 20.71 | 148300.0 |
| 2010-01-19 | ABMD-DELISTED | Stock | 8.09 | 8.36 | 8.09 | 8.35 | 176044.0 |
| 2010-01-19 | ABR | Stock | 2.41 | 2.44 | 2.36 | 2.42 | 113500.0 |
| 2010-01-19 | ABT | Stock | 26.6529 | 27.1087 | 26.6337 | 26.9648 | 16663610.0 |
| 2010-01-19 | ABTL-DELISTED | Stock | 4.7475 | 5.1973 | 4.7475 | 4.9025 | 9665.0 |
| 2010-01-19 | ABV-DELISTED | Stock | 103.14 | 105.97 | 103.06 | 105.03 | 352712.0 |
| 2010-01-19 | ABVA-DELISTED | Stock | 2.94 | 2.94 | 2.94 | 2.94 | 250.0 |
| 2010-01-19 | ABVT-DELISTED | Stock | 61.29 | 63.32 | 61.19 | 62.78 | 62351.0 |
| 2010-01-19 | ABX-DELISTED | Stock | 39.28 | 39.72 | 38.99 | 39.68 | 8742269.0 |
| 2010-01-19 | ACAD | Stock | 1.43 | 1.46 | 1.36 | 1.39 | 585300.0 |
> showing 50 of 5,955 rows — these rows as CSV