PREVIEW / stock_daily / 2010-10-19
file: by_date/stock_daily/2010/2010-10-19.parquet size: 193 KB rows: 5,990 symbols: 3,516
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-19 | AAPL | Stock | 10.8357 | 11.2061 | 10.715 | 11.0532 | 1232784000.0 |
| 2010-10-19 | MSFT | Stock | 25.27 | 25.37 | 24.95 | 25.1 | 66150900.0 |
| 2010-10-19 | NVDA | Stock | 0.2778 | 0.2842 | 0.2755 | 0.2822 | 866136000.0 |
| 2010-10-19 | AMZN | Stock | 8.034 | 8.14 | 7.85 | 7.9335 | 150500000.0 |
| 2010-10-19 | TSLA | Stock | 1.3467 | 1.3607 | 1.3333 | 1.3367 | 3678000.0 |
| 2010-10-19 | TLT | Stock | 100.58 | 102.0899 | 100.55 | 101.69 | 8017617.0 |
| 2010-10-19 | ES | Stock | 30.18 | 30.93 | 30.11 | 30.79 | 4345200.0 |
| 2010-10-19 | CL | Stock | 38.15 | 38.445 | 37.975 | 38.125 | 4975000.0 |
| 2010-10-19 | A | Stock | 24.4134 | 24.6495 | 24.0057 | 24.3348 | 5580676.0 |
| 2010-10-19 | AABA-DELISTED | Stock | 15.74 | 15.8 | 15.3701 | 15.471 | 32247032.0 |
| 2010-10-19 | AACC-DELISTED | Stock | 5.67 | 5.8 | 5.49 | 5.59 | 18824.0 |
| 2010-10-19 | AAI-DELISTED | Stock | 7.37 | 7.38 | 7.35 | 7.38 | 2742528.0 |
| 2010-10-19 | AAIC-DELISTED | Stock | 23.31 | 23.63 | 23.01 | 23.12 | 47520.0 |
| 2010-10-19 | AAME | Stock | 1.69 | 1.71 | 1.6 | 1.7 | 5600.0 |
| 2010-10-19 | AAON | Stock | 4.802 | 4.883 | 4.7881 | 4.8533 | 274387.0 |
| 2010-10-19 | AAP | Stock | 59.81 | 60.97 | 59.8 | 60.39 | 869500.0 |
| 2010-10-19 | AATI-DELISTED | Stock | 3.9 | 3.93 | 3.75 | 3.78 | 156967.0 |
| 2010-10-19 | AAU-DELISTED | Stock | 2.66 | 2.7 | 2.54 | 2.55 | 357530.0 |
| 2010-10-19 | AAUAF-DELISTED | Stock | 2.66 | 2.7 | 2.54 | 2.55 | 358230.0 |
| 2010-10-19 | AAV-DELISTED | Stock | 6.33 | 6.33 | 6.1 | 6.15 | 373920.0 |
| 2010-10-19 | AAWW-DELISTED | Stock | 55.26 | 55.33 | 52.3256 | 52.695 | 320062.0 |
| 2010-10-19 | AAXJ | Stock | 62.35 | 62.35 | 61.52 | 61.77 | 1463776.0 |
| 2010-10-19 | AAXN-DELISTED | Stock | 4.42 | 4.57 | 4.24 | 4.27 | 850507.0 |
| 2010-10-19 | AB | Stock | 26.5 | 26.71 | 26.05 | 26.21 | 224500.0 |
| 2010-10-19 | ABAC-DELISTED | Stock | 5.97 | 6.08 | 5.299 | 5.32 | 116922.0 |
| 2010-10-19 | ABAX-DELISTED | Stock | 24.3 | 24.4 | 23.34 | 23.52 | 125469.0 |
| 2010-10-19 | ABB-DELISTED | Stock | 22.08 | 22.22 | 21.91 | 22.04 | 2525188.0 |
| 2010-10-19 | ABBC-DELISTED | Stock | 10.71 | 10.85 | 10.51 | 10.6 | 28094.0 |
| 2010-10-19 | ABBNY-DELISTED | Stock | 22.08 | 22.22 | 21.91 | 22.07 | 2533005.0 |
| 2010-10-19 | ABC-DELISTED | Stock | 32.03 | 32.03 | 31.38 | 31.55 | 2350169.0 |
| 2010-10-19 | ABCB | Stock | 9.39 | 9.52 | 9.07 | 9.17 | 42100.0 |
| 2010-10-19 | ABCD-DELISTED | Stock | 3.36 | 3.36 | 3.24 | 3.28 | 21833.0 |
| 2010-10-19 | ABCO-DELISTED | Stock | 23.46 | 23.59 | 23.04 | 23.33 | 78285.0 |
| 2010-10-19 | ABCW-DELISTED | Stock | 0.6786 | 0.6884 | 0.6785 | 0.6814 | 14800.0 |
| 2010-10-19 | ABD-DELISTED | Stock | 6.0395 | 6.0495 | 5.6901 | 5.77 | 210490.0 |
| 2010-10-19 | ABE-DELISTED | Stock | 19.18 | 19.2436 | 19.02 | 19.1 | 14461.0 |
| 2010-10-19 | ABEO | Stock | 3687.5 | 3750.0 | 3500.0 | 3562.5 | 56.0 |
| 2010-10-19 | ABFS-DELISTED | Stock | 25.09 | 25.41 | 24.66 | 24.78 | 370469.0 |
| 2010-10-19 | ABG | Stock | 14.78 | 14.99 | 14.34 | 14.46 | 157400.0 |
| 2010-10-19 | ABK-DELISTED | Stock | 0.8681 | 1.15 | 0.86 | 1.14 | 54990504.0 |
| 2010-10-19 | ABM | Stock | 22.22 | 22.78 | 22.13 | 22.24 | 200100.0 |
| 2010-10-19 | ABMD-DELISTED | Stock | 10.71 | 10.87 | 10.5 | 10.63 | 87822.0 |
| 2010-10-19 | ABR | Stock | 5.4 | 5.45 | 5.31 | 5.37 | 38200.0 |
| 2010-10-19 | ABT | Stock | 25.535 | 25.6453 | 25.1895 | 25.367 | 15452063.0 |
| 2010-10-19 | ABTL-DELISTED | Stock | 4.3054 | 4.3054 | 4.0721 | 4.0946 | 25824.0 |
| 2010-10-19 | ABV-DELISTED | Stock | 138.79 | 139.75 | 137.15 | 137.57 | 854801.0 |
| 2010-10-19 | ABVA-DELISTED | Stock | 2.76 | 2.76 | 2.72 | 2.75 | 8700.0 |
| 2010-10-19 | ABVT-DELISTED | Stock | 54.0 | 54.7299 | 53.75 | 54.3 | 128915.0 |
| 2010-10-19 | ABX-DELISTED | Stock | 45.75 | 46.1 | 45.12 | 45.57 | 15466149.0 |
| 2010-10-19 | ACAD | Stock | 0.87 | 0.91 | 0.87 | 0.88 | 340000.0 |
> showing 50 of 5,990 rows — these rows as CSV