PREVIEW / stock_daily / 2010-01-25
file: by_date/stock_daily/2010/2010-01-25.parquet size: 188 KB rows: 5,924 symbols: 3,508
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-25 | AAPL | Stock | 7.2325 | 7.3107 | 7.1496 | 7.2525 | 1065699600.0 |
| 2010-01-25 | MSFT | Stock | 29.24 | 29.66 | 29.1 | 29.32 | 63373000.0 |
| 2010-01-25 | NVDA | Stock | 0.4182 | 0.4265 | 0.4152 | 0.4185 | 643676000.0 |
| 2010-01-25 | AMZN | Stock | 6.105 | 6.114 | 5.906 | 6.0155 | 240478000.0 |
| 2010-01-25 | TLT | Stock | 91.54 | 91.92 | 91.49 | 91.58 | 2419434.0 |
| 2010-01-25 | ES | Stock | 25.62 | 25.7 | 25.32 | 25.54 | 1227500.0 |
| 2010-01-25 | CL | Stock | 40.565 | 40.725 | 39.915 | 40.235 | 6220000.0 |
| 2010-01-25 | A | Stock | 21.0443 | 21.2089 | 20.9084 | 21.0658 | 3608518.0 |
| 2010-01-25 | AABA-DELISTED | Stock | 16.07 | 16.1101 | 15.74 | 15.86 | 19220081.0 |
| 2010-01-25 | AACC-DELISTED | Stock | 6.24 | 6.24 | 5.91 | 5.97 | 16326.0 |
| 2010-01-25 | AACG | Stock | 3.93 | 4.01 | 3.9 | 3.92 | 11100.0 |
| 2010-01-25 | AAI-DELISTED | Stock | 5.47 | 5.61 | 5.35 | 5.3699 | 4046080.0 |
| 2010-01-25 | AAIC-DELISTED | Stock | 14.98 | 14.98 | 14.18 | 14.96 | 18091.0 |
| 2010-01-25 | AAME | Stock | 1.45 | 1.45 | 1.45 | 1.45 | 500.0 |
| 2010-01-25 | AAON | Stock | 3.8578 | 3.9111 | 3.8123 | 3.8973 | 417150.0 |
| 2010-01-25 | AAP | Stock | 40.01 | 40.6 | 40.0 | 40.5 | 1396900.0 |
| 2010-01-25 | AATI-DELISTED | Stock | 3.81 | 3.85 | 3.57 | 3.62 | 338058.0 |
| 2010-01-25 | AAU-DELISTED | Stock | 1.02 | 1.03 | 0.98 | 0.98 | 146557.0 |
| 2010-01-25 | AAUAF-DELISTED | Stock | 1.02 | 1.03 | 0.98 | 0.98 | 147117.0 |
| 2010-01-25 | AAV-DELISTED | Stock | 6.57 | 6.68 | 6.53 | 6.58 | 346535.0 |
| 2010-01-25 | AAWW-DELISTED | Stock | 37.66 | 37.8999 | 36.76 | 36.91 | 229519.0 |
| 2010-01-25 | AAXJ | Stock | 54.3 | 54.618 | 53.86 | 54.1 | 425580.0 |
| 2010-01-25 | AAXN-DELISTED | Stock | 5.77 | 5.93 | 5.64 | 5.8 | 810505.0 |
| 2010-01-25 | AB | Stock | 27.94 | 28.64 | 27.17 | 27.73 | 537200.0 |
| 2010-01-25 | ABAX-DELISTED | Stock | 23.78 | 23.98 | 23.36 | 23.63 | 96712.0 |
| 2010-01-25 | ABB-DELISTED | Stock | 18.68 | 18.74 | 18.34 | 18.49 | 5456414.0 |
| 2010-01-25 | ABBC-DELISTED | Stock | 7.1 | 7.1 | 7.02 | 7.05 | 19661.0 |
| 2010-01-25 | ABBNY-DELISTED | Stock | 18.68 | 18.74 | 18.34 | 18.47 | 5457783.0 |
| 2010-01-25 | ABC-DELISTED | Stock | 26.79 | 27.34 | 26.68 | 27.11 | 5256522.0 |
| 2010-01-25 | ABCB | Stock | 9.047 | 9.3137 | 9.0273 | 9.0569 | 44043.0 |
| 2010-01-25 | ABCD-DELISTED | Stock | 4.0 | 4.05 | 4.0 | 4.01 | 5422.0 |
| 2010-01-25 | ABCO-DELISTED | Stock | 15.985 | 15.99 | 15.815 | 15.88 | 74223.0 |
| 2010-01-25 | ABCW-DELISTED | Stock | 1.25 | 1.3 | 1.23 | 1.24 | 313170.0 |
| 2010-01-25 | ABD-DELISTED | Stock | 8.3 | 8.35 | 8.13 | 8.16 | 352180.0 |
| 2010-01-25 | ABE-DELISTED | Stock | 16.31 | 16.3899 | 15.9 | 16.2 | 23277.0 |
| 2010-01-25 | ABEO | Stock | 3612.5 | 3612.5 | 3375.0 | 3500.0 | 25.0 |
| 2010-01-25 | ABFS-DELISTED | Stock | 26.49 | 26.75 | 26.07 | 26.3 | 197659.0 |
| 2010-01-25 | ABG | Stock | 11.84 | 12.04 | 11.55 | 12.0 | 479900.0 |
| 2010-01-25 | ABII-DELISTED | Stock | 42.08 | 42.77 | 41.54 | 42.06 | 23061.0 |
| 2010-01-25 | ABK-DELISTED | Stock | 0.725 | 0.74 | 0.7 | 0.72 | 5491455.0 |
| 2010-01-25 | ABM | Stock | 19.6 | 19.66 | 19.42 | 19.52 | 112500.0 |
| 2010-01-25 | ABMD-DELISTED | Stock | 8.54 | 8.54 | 8.22 | 8.25 | 147303.0 |
| 2010-01-25 | ABR | Stock | 2.22 | 2.32 | 2.13 | 2.25 | 88700.0 |
| 2010-01-25 | ABT | Stock | 26.2738 | 26.6337 | 26.1635 | 26.2451 | 10109421.0 |
| 2010-01-25 | ABTL-DELISTED | Stock | 5.2 | 5.45 | 4.95 | 5.25 | 17576.0 |
| 2010-01-25 | ABV-DELISTED | Stock | 100.4 | 100.6468 | 98.11 | 99.81 | 404463.0 |
| 2010-01-25 | ABVT-DELISTED | Stock | 62.97 | 63.67 | 62.0 | 62.8 | 53315.0 |
| 2010-01-25 | ABX-DELISTED | Stock | 37.17 | 37.17 | 36.03 | 36.05 | 11330453.0 |
| 2010-01-25 | ACAD | Stock | 1.33 | 1.33 | 1.27 | 1.3 | 438200.0 |
| 2010-01-25 | ACAP-DELISTED | Stock | 28.14 | 28.74 | 27.91 | 28.31 | 35448.0 |
> showing 50 of 5,924 rows — these rows as CSV