PREVIEW / stock_daily / 2010-05-24
file: by_date/stock_daily/2010/2010-05-24.parquet size: 188 KB rows: 5,906 symbols: 3,470
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-05-24 | AAPL | Stock | 8.8314 | 8.9607 | 8.795 | 8.8129 | 754238800.0 |
| 2010-05-24 | MSFT | Stock | 26.85 | 26.86 | 26.26 | 26.27 | 73711700.0 |
| 2010-05-24 | NVDA | Stock | 0.3173 | 0.321 | 0.308 | 0.309 | 664564000.0 |
| 2010-05-24 | AMZN | Stock | 6.1285 | 6.225 | 6.0325 | 6.106 | 90718000.0 |
| 2010-05-24 | TLT | Stock | 98.74 | 98.87 | 97.9 | 98.09 | 7721043.0 |
| 2010-05-24 | ES | Stock | 25.95 | 26.18 | 25.69 | 25.8 | 1334700.0 |
| 2010-05-24 | CL | Stock | 39.615 | 39.765 | 39.24 | 39.365 | 5781800.0 |
| 2010-05-24 | A | Stock | 22.3462 | 22.618 | 22.1602 | 22.4607 | 5286956.0 |
| 2010-05-24 | AABA-DELISTED | Stock | 15.48 | 15.7875 | 15.36 | 15.54 | 19888145.0 |
| 2010-05-24 | AACC-DELISTED | Stock | 6.17 | 6.27 | 5.82 | 6.01 | 35650.0 |
| 2010-05-24 | AACG | Stock | 3.34 | 3.35 | 3.3 | 3.3 | 4700.0 |
| 2010-05-24 | AAI-DELISTED | Stock | 5.04 | 5.15 | 4.99 | 5.08 | 2459505.0 |
| 2010-05-24 | AAIC-DELISTED | Stock | 18.0 | 18.16 | 17.96 | 18.01 | 25864.0 |
| 2010-05-24 | AAME | Stock | 1.55 | 1.55 | 1.47 | 1.47 | 5900.0 |
| 2010-05-24 | AAON | Stock | 4.7269 | 4.7605 | 4.6064 | 4.6202 | 340706.0 |
| 2010-05-24 | AAP | Stock | 49.08 | 50.26 | 48.3 | 49.55 | 2241500.0 |
| 2010-05-24 | AATI-DELISTED | Stock | 3.42 | 3.51 | 3.41 | 3.41 | 107770.0 |
| 2010-05-24 | AAU-DELISTED | Stock | 0.99 | 1.06 | 0.99 | 1.03 | 52529.0 |
| 2010-05-24 | AAUAF-DELISTED | Stock | 0.99 | 1.06 | 0.99 | 1.03 | 52704.0 |
| 2010-05-24 | AAV-DELISTED | Stock | 5.82 | 5.84 | 5.52 | 5.52 | 290254.0 |
| 2010-05-24 | AAWW-DELISTED | Stock | 50.11 | 51.05 | 47.35 | 47.53 | 336924.0 |
| 2010-05-24 | AAXJ | Stock | 51.09 | 51.92 | 51.09 | 51.2 | 188519.0 |
| 2010-05-24 | AAXN-DELISTED | Stock | 4.53 | 4.62 | 4.34 | 4.34 | 760177.0 |
| 2010-05-24 | AB | Stock | 27.92 | 28.38 | 27.33 | 27.37 | 351700.0 |
| 2010-05-24 | ABAX-DELISTED | Stock | 23.01 | 23.1 | 22.41 | 22.52 | 113045.0 |
| 2010-05-24 | ABB-DELISTED | Stock | 16.75 | 16.98 | 16.55 | 16.56 | 3994241.0 |
| 2010-05-24 | ABBC-DELISTED | Stock | 9.06 | 9.16 | 8.96 | 8.99 | 81686.0 |
| 2010-05-24 | ABBNY-DELISTED | Stock | 16.75 | 16.98 | 16.54 | 16.54 | 4051510.0 |
| 2010-05-24 | ABC-DELISTED | Stock | 30.8 | 31.07 | 30.42 | 30.68 | 5124255.0 |
| 2010-05-24 | ABCB | Stock | 10.5995 | 10.7488 | 10.3507 | 10.4801 | 100878.0 |
| 2010-05-24 | ABCD-DELISTED | Stock | 4.9 | 4.97 | 4.88 | 4.89 | 67440.0 |
| 2010-05-24 | ABCO-DELISTED | Stock | 19.2 | 19.425 | 18.595 | 19.27 | 80008.0 |
| 2010-05-24 | ABCW-DELISTED | Stock | 0.73 | 0.77 | 0.71 | 0.74 | 64210.0 |
| 2010-05-24 | ABD-DELISTED | Stock | 6.5299 | 6.5698 | 6.3302 | 6.3801 | 294250.0 |
| 2010-05-24 | ABE-DELISTED | Stock | 14.86 | 15.2 | 14.79 | 15.13 | 19360.0 |
| 2010-05-24 | ABEO | Stock | 2575.0 | 3000.0 | 2500.0 | 3000.0 | 15.0 |
| 2010-05-24 | ABFS-DELISTED | Stock | 26.0 | 26.53 | 25.6901 | 26.0 | 395085.0 |
| 2010-05-24 | ABG | Stock | 12.41 | 12.54 | 12.22 | 12.26 | 190400.0 |
| 2010-05-24 | ABII-DELISTED | Stock | 42.85 | 49.55 | 42.26 | 47.25 | 96340.0 |
| 2010-05-24 | ABK-DELISTED | Stock | 1.05 | 1.05 | 0.94 | 0.95 | 17468025.0 |
| 2010-05-24 | ABM | Stock | 20.81 | 20.93 | 20.46 | 20.59 | 165000.0 |
| 2010-05-24 | ABMD-DELISTED | Stock | 9.0 | 9.49 | 8.98 | 9.28 | 382617.0 |
| 2010-05-24 | ABR | Stock | 3.22 | 3.39 | 3.15 | 3.29 | 58300.0 |
| 2010-05-24 | ABT | Stock | 22.5698 | 23.0496 | 22.4882 | 22.8193 | 26966028.0 |
| 2010-05-24 | ABTL-DELISTED | Stock | 5.0 | 5.45 | 4.997 | 5.0 | 53088.0 |
| 2010-05-24 | ABV-DELISTED | Stock | 94.36 | 96.42 | 94.05 | 94.49 | 776598.0 |
| 2010-05-24 | ABVA-DELISTED | Stock | 2.8 | 2.8 | 2.8 | 2.8 | 5000.0 |
| 2010-05-24 | ABVT-DELISTED | Stock | 44.8 | 45.53 | 44.08 | 44.31 | 117555.0 |
| 2010-05-24 | ABX-DELISTED | Stock | 41.69 | 42.14 | 41.09 | 41.09 | 6733909.0 |
| 2010-05-24 | ACAD | Stock | 1.33 | 1.43 | 1.27 | 1.37 | 421700.0 |
> showing 50 of 5,906 rows — these rows as CSV