PREVIEW / stock_daily / 2010-05-28
file: by_date/stock_daily/2010/2010-05-28.parquet size: 190 KB rows: 5,925 symbols: 3,496
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-28 | AAPL | Stock | 9.2639 | 9.2643 | 9.0482 | 9.1743 | 815614800.0 |
| 2010-05-28 | MSFT | Stock | 25.84 | 26.12 | 25.66 | 25.8 | 67496900.0 |
| 2010-05-28 | NVDA | Stock | 0.337 | 0.337 | 0.3235 | 0.3285 | 545116000.0 |
| 2010-05-28 | AMZN | Stock | 6.3035 | 6.38 | 6.2005 | 6.273 | 79096000.0 |
| 2010-05-28 | TLT | Stock | 96.49 | 96.78 | 96.015 | 96.5 | 5805433.0 |
| 2010-05-28 | ES | Stock | 25.85 | 26.2 | 25.77 | 25.95 | 2188900.0 |
| 2010-05-28 | CL | Stock | 39.065 | 39.445 | 39.005 | 39.045 | 5300600.0 |
| 2010-05-28 | A | Stock | 23.4335 | 23.4979 | 23.0043 | 23.1474 | 3430692.0 |
| 2010-05-28 | AABA-DELISTED | Stock | 15.61 | 15.6896 | 15.0 | 15.33 | 17169919.0 |
| 2010-05-28 | AACC-DELISTED | Stock | 6.0 | 6.0 | 5.83 | 5.87 | 13040.0 |
| 2010-05-28 | AACG | Stock | 3.25 | 3.28 | 3.25 | 3.25 | 6500.0 |
| 2010-05-28 | AAI-DELISTED | Stock | 5.67 | 5.74 | 5.57 | 5.63 | 3375127.0 |
| 2010-05-28 | AAIC-DELISTED | Stock | 18.92 | 19.12 | 18.88 | 19.0 | 13466.0 |
| 2010-05-28 | AAME | Stock | 1.45 | 1.45 | 1.45 | 1.45 | 2300.0 |
| 2010-05-28 | AAON | Stock | 4.8751 | 4.9225 | 4.8178 | 4.8751 | 508275.0 |
| 2010-05-28 | AAP | Stock | 50.52 | 52.01 | 47.79 | 51.76 | 1720500.0 |
| 2010-05-28 | AATI-DELISTED | Stock | 3.47 | 3.52 | 3.35 | 3.45 | 189215.0 |
| 2010-05-28 | AAU-DELISTED | Stock | 1.02 | 1.0396 | 0.98 | 0.99 | 68821.0 |
| 2010-05-28 | AAUAF-DELISTED | Stock | 1.02 | 1.0396 | 0.98 | 0.99 | 69121.0 |
| 2010-05-28 | AAV-DELISTED | Stock | 6.08 | 6.21 | 6.01 | 6.08 | 472284.0 |
| 2010-05-28 | AAWW-DELISTED | Stock | 52.37 | 52.9885 | 51.54 | 52.31 | 257217.0 |
| 2010-05-28 | AAXJ | Stock | 53.92 | 53.92 | 51.96 | 52.27 | 316737.0 |
| 2010-05-28 | AAXN-DELISTED | Stock | 4.52 | 4.55 | 4.25 | 4.47 | 1519843.0 |
| 2010-05-28 | AB | Stock | 29.23 | 29.59 | 28.39 | 28.39 | 286700.0 |
| 2010-05-28 | ABAX-DELISTED | Stock | 22.88 | 23.08 | 22.5 | 22.51 | 60703.0 |
| 2010-05-28 | ABB-DELISTED | Stock | 17.27 | 17.3 | 16.86 | 17.01 | 3560232.0 |
| 2010-05-28 | ABBC-DELISTED | Stock | 8.98 | 9.09 | 8.85 | 8.9 | 126538.0 |
| 2010-05-28 | ABBNY-DELISTED | Stock | 17.27 | 17.3 | 16.86 | 17.01 | 3631263.0 |
| 2010-05-28 | ABC-DELISTED | Stock | 31.54 | 31.7 | 30.92 | 31.28 | 4865262.0 |
| 2010-05-28 | ABCB | Stock | 11.3062 | 11.6445 | 11.1569 | 11.2166 | 1163313.0 |
| 2010-05-28 | ABCD-DELISTED | Stock | 4.78 | 4.84 | 4.72 | 4.815 | 237790.0 |
| 2010-05-28 | ABCO-DELISTED | Stock | 19.068 | 19.068 | 18.532 | 18.557 | 111422.0 |
| 2010-05-28 | ABCW-DELISTED | Stock | 0.75 | 0.76 | 0.7 | 0.71 | 77980.0 |
| 2010-05-28 | ABD-DELISTED | Stock | 7.22 | 7.23 | 6.9 | 7.06 | 332270.0 |
| 2010-05-28 | ABE-DELISTED | Stock | 15.74 | 15.74 | 15.38 | 15.52 | 8205.0 |
| 2010-05-28 | ABEO | Stock | 3125.0 | 3125.0 | 2812.5 | 2937.5 | 25.0 |
| 2010-05-28 | ABFS-DELISTED | Stock | 23.09 | 23.54 | 22.63 | 23.38 | 388422.0 |
| 2010-05-28 | ABG | Stock | 13.37 | 13.52 | 13.02 | 13.22 | 264100.0 |
| 2010-05-28 | ABII-DELISTED | Stock | 43.94 | 45.1 | 43.94 | 44.71 | 22454.0 |
| 2010-05-28 | ABK-DELISTED | Stock | 0.979 | 1.29 | 0.95 | 1.21 | 68879030.0 |
| 2010-05-28 | ABM | Stock | 21.75 | 21.85 | 21.36 | 21.47 | 480100.0 |
| 2010-05-28 | ABMD-DELISTED | Stock | 9.79 | 9.93 | 9.65 | 9.75 | 268842.0 |
| 2010-05-28 | ABR | Stock | 3.63 | 3.75 | 3.53 | 3.72 | 96700.0 |
| 2010-05-28 | ABT | Stock | 22.92 | 23.3087 | 22.7905 | 22.8193 | 23084410.0 |
| 2010-05-28 | ABTL-DELISTED | Stock | 6.4251 | 6.5255 | 6.0737 | 6.3749 | 60155.0 |
| 2010-05-28 | ABV-DELISTED | Stock | 96.6 | 97.41 | 95.57 | 96.38 | 755703.0 |
| 2010-05-28 | ABVA-DELISTED | Stock | 2.62 | 2.84 | 2.62 | 2.84 | 1000.0 |
| 2010-05-28 | ABVT-DELISTED | Stock | 46.86 | 46.86 | 45.63 | 45.96 | 110722.0 |
| 2010-05-28 | ABX-DELISTED | Stock | 42.52 | 42.66 | 41.76 | 42.11 | 7240227.0 |
| 2010-05-28 | ACAD | Stock | 1.3 | 1.35 | 1.27 | 1.34 | 275700.0 |
> showing 50 of 5,925 rows — these rows as CSV