PREVIEW / stock_daily / 2010-10-08
file: by_date/stock_daily/2010/2010-10-08.parquet size: 191 KB rows: 5,961 symbols: 3,502
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-08 | AAPL | Stock | 10.4182 | 10.5179 | 10.3571 | 10.5025 | 658403200.0 |
| 2010-10-08 | MSFT | Stock | 24.62 | 24.65 | 24.37 | 24.57 | 41327800.0 |
| 2010-10-08 | NVDA | Stock | 0.2665 | 0.2738 | 0.2628 | 0.2715 | 706932000.0 |
| 2010-10-08 | AMZN | Stock | 7.759 | 7.814 | 7.639 | 7.7775 | 138368000.0 |
| 2010-10-08 | TSLA | Stock | 1.362 | 1.386 | 1.3593 | 1.362 | 4017000.0 |
| 2010-10-08 | TLT | Stock | 104.87 | 105.4599 | 104.22 | 104.22 | 6128648.0 |
| 2010-10-08 | ES | Stock | 30.31 | 30.41 | 30.07 | 30.31 | 990900.0 |
| 2010-10-08 | CL | Stock | 36.885 | 37.52 | 36.81 | 37.45 | 6490400.0 |
| 2010-10-08 | A | Stock | 23.7554 | 24.2632 | 23.598 | 24.1774 | 4003033.0 |
| 2010-10-08 | AABA-DELISTED | Stock | 14.21 | 14.5595 | 14.18 | 14.48 | 15993423.0 |
| 2010-10-08 | AACC-DELISTED | Stock | 5.2 | 5.49 | 5.17 | 5.47 | 37267.0 |
| 2010-10-08 | AACG | Stock | 3.0 | 3.0 | 2.95 | 2.96 | 4000.0 |
| 2010-10-08 | AAI-DELISTED | Stock | 7.34 | 7.36 | 7.34 | 7.35 | 10639088.0 |
| 2010-10-08 | AAIC-DELISTED | Stock | 23.3 | 23.5 | 22.7 | 23.49 | 47155.0 |
| 2010-10-08 | AAME | Stock | 1.75 | 1.75 | 1.75 | 1.75 | 800.0 |
| 2010-10-08 | AAON | Stock | 4.6538 | 4.7664 | 4.6222 | 4.7111 | 206550.0 |
| 2010-10-08 | AAP | Stock | 58.92 | 59.45 | 58.32 | 58.55 | 772600.0 |
| 2010-10-08 | AATI-DELISTED | Stock | 3.5 | 3.51 | 3.43 | 3.5 | 164240.0 |
| 2010-10-08 | AAU-DELISTED | Stock | 2.88 | 2.971 | 2.88 | 2.91 | 266232.0 |
| 2010-10-08 | AAUAF-DELISTED | Stock | 2.89 | 2.981 | 2.89 | 2.9 | 266630.0 |
| 2010-10-08 | AAV-DELISTED | Stock | 6.23 | 6.37 | 6.15 | 6.34 | 318670.0 |
| 2010-10-08 | AAWW-DELISTED | Stock | 51.88 | 54.37 | 51.88 | 53.65 | 253668.0 |
| 2010-10-08 | AAXJ | Stock | 62.08 | 62.72 | 61.99 | 62.52 | 221195.0 |
| 2010-10-08 | AAXN-DELISTED | Stock | 4.11 | 4.1315 | 4.05 | 4.05 | 328068.0 |
| 2010-10-08 | AB | Stock | 26.92 | 26.93 | 26.28 | 26.76 | 276900.0 |
| 2010-10-08 | ABAC-DELISTED | Stock | 4.35 | 4.88 | 4.35 | 4.78 | 82003.0 |
| 2010-10-08 | ABAX-DELISTED | Stock | 23.33 | 24.0 | 23.19 | 23.87 | 57653.0 |
| 2010-10-08 | ABB-DELISTED | Stock | 21.66 | 21.83 | 21.59 | 21.79 | 1606412.0 |
| 2010-10-08 | ABBC-DELISTED | Stock | 10.52 | 10.7 | 10.48 | 10.67 | 68736.0 |
| 2010-10-08 | ABBNY-DELISTED | Stock | 21.66 | 21.83 | 21.59 | 21.79 | 1862623.0 |
| 2010-10-08 | ABC-DELISTED | Stock | 31.65 | 31.84 | 31.49 | 31.67 | 2107473.0 |
| 2010-10-08 | ABCB | Stock | 9.77 | 9.85 | 9.59 | 9.78 | 80800.0 |
| 2010-10-08 | ABCD-DELISTED | Stock | 3.19 | 3.27 | 3.17 | 3.23 | 21498.0 |
| 2010-10-08 | ABCO-DELISTED | Stock | 22.85 | 22.94 | 22.48 | 22.62 | 163682.0 |
| 2010-10-08 | ABCW-DELISTED | Stock | 0.68 | 0.69 | 0.68 | 0.68 | 12570.0 |
| 2010-10-08 | ABD-DELISTED | Stock | 5.73 | 5.9082 | 5.65 | 5.86 | 386690.0 |
| 2010-10-08 | ABE-DELISTED | Stock | 19.07 | 19.24 | 18.86 | 19.23 | 14404.0 |
| 2010-10-08 | ABEO | Stock | 3125.0 | 3312.5 | 3125.0 | 3287.5 | 58.0 |
| 2010-10-08 | ABFS-DELISTED | Stock | 24.09 | 24.3 | 23.69 | 24.05 | 247588.0 |
| 2010-10-08 | ABG | Stock | 14.34 | 14.49 | 14.02 | 14.45 | 149100.0 |
| 2010-10-08 | ABII-DELISTED | Stock | 76.52 | 77.14 | 76.52 | 77.0599 | 70129.0 |
| 2010-10-08 | ABK-DELISTED | Stock | 0.7854 | 0.8376 | 0.71 | 0.7188 | 30904550.0 |
| 2010-10-08 | ABM | Stock | 22.09 | 22.5 | 21.87 | 22.4 | 182900.0 |
| 2010-10-08 | ABMD-DELISTED | Stock | 10.67 | 10.87 | 10.64 | 10.79 | 95291.0 |
| 2010-10-08 | ABR | Stock | 5.14 | 5.44 | 5.08 | 5.42 | 115000.0 |
| 2010-10-08 | ABT | Stock | 25.2135 | 25.3958 | 25.1463 | 25.3382 | 31929137.0 |
| 2010-10-08 | ABTL-DELISTED | Stock | 4.25 | 4.25 | 4.2 | 4.2 | 8130.0 |
| 2010-10-08 | ABV-DELISTED | Stock | 130.61 | 132.99 | 130.51 | 132.75 | 577712.0 |
| 2010-10-08 | ABVA-DELISTED | Stock | 2.81 | 2.81 | 2.8 | 2.8 | 3600.0 |
| 2010-10-08 | ABVT-DELISTED | Stock | 53.05 | 53.7 | 52.85 | 53.42 | 202047.0 |
> showing 50 of 5,961 rows — these rows as CSV