PREVIEW / stock_daily / 2010-05-10
file: by_date/stock_daily/2010/2010-05-10.parquet size: 192 KB rows: 5,978 symbols: 3,528
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-10 | AAPL | Stock | 8.9375 | 9.0946 | 8.8761 | 9.0711 | 984306400.0 |
| 2010-05-10 | MSFT | Stock | 29.01 | 29.48 | 28.71 | 28.94 | 86653300.0 |
| 2010-05-10 | NVDA | Stock | 0.37 | 0.3745 | 0.36 | 0.364 | 979156000.0 |
| 2010-05-10 | AMZN | Stock | 6.4865 | 6.6105 | 6.463 | 6.5645 | 136122000.0 |
| 2010-05-10 | TLT | Stock | 93.16 | 93.94 | 93.085 | 93.6 | 10240306.0 |
| 2010-05-10 | ES | Stock | 26.37 | 26.42 | 25.99 | 26.33 | 1331100.0 |
| 2010-05-10 | CL | Stock | 40.9 | 41.67 | 40.765 | 41.59 | 5709200.0 |
| 2010-05-10 | A | Stock | 23.7339 | 24.4778 | 23.598 | 24.4564 | 5671826.0 |
| 2010-05-10 | AABA-DELISTED | Stock | 16.04 | 16.83 | 16.0 | 16.34 | 27825015.0 |
| 2010-05-10 | AACC-DELISTED | Stock | 6.81 | 7.37 | 6.67 | 7.29 | 63300.0 |
| 2010-05-10 | AACG | Stock | 3.55 | 3.55 | 3.39 | 3.4 | 2400.0 |
| 2010-05-10 | AAI-DELISTED | Stock | 5.22 | 5.29 | 5.11 | 5.21 | 2716689.0 |
| 2010-05-10 | AAIC-DELISTED | Stock | 19.55 | 19.98 | 18.58 | 18.82 | 32870.0 |
| 2010-05-10 | AAME | Stock | 1.95 | 1.99 | 1.78 | 1.8 | 7100.0 |
| 2010-05-10 | AAON | Stock | 4.4681 | 4.5511 | 4.3477 | 4.5412 | 421706.0 |
| 2010-05-10 | AAP | Stock | 45.11 | 45.16 | 44.43 | 45.11 | 818800.0 |
| 2010-05-10 | AATI-DELISTED | Stock | 3.66 | 3.78 | 3.61 | 3.73 | 331074.0 |
| 2010-05-10 | AAU-DELISTED | Stock | 1.07 | 1.12 | 1.06 | 1.0999 | 80906.0 |
| 2010-05-10 | AAUAF-DELISTED | Stock | 1.07 | 1.12 | 1.06 | 1.09 | 81606.0 |
| 2010-05-10 | AAV-DELISTED | Stock | 6.37 | 6.5 | 6.27 | 6.34 | 464474.0 |
| 2010-05-10 | AAWW-DELISTED | Stock | 51.92 | 53.74 | 51.92 | 53.14 | 359793.0 |
| 2010-05-10 | AAXJ | Stock | 55.59 | 55.9 | 55.17 | 55.84 | 401668.0 |
| 2010-05-10 | AAXN-DELISTED | Stock | 4.63 | 4.67 | 4.52 | 4.67 | 1010188.0 |
| 2010-05-10 | AB | Stock | 30.96 | 31.06 | 30.3 | 30.66 | 715000.0 |
| 2010-05-10 | ABAX-DELISTED | Stock | 24.72 | 24.72 | 24.07 | 24.61 | 178221.0 |
| 2010-05-10 | ABB-DELISTED | Stock | 18.66 | 18.75 | 18.34 | 18.53 | 4994075.0 |
| 2010-05-10 | ABBC-DELISTED | Stock | 9.36 | 9.77 | 9.14 | 9.73 | 120918.0 |
| 2010-05-10 | ABBNY-DELISTED | Stock | 18.65 | 18.75 | 18.34 | 18.56 | 5039300.0 |
| 2010-05-10 | ABC-DELISTED | Stock | 30.92 | 31.32 | 30.57 | 31.08 | 3918748.0 |
| 2010-05-10 | ABCB | Stock | 10.6891 | 10.9479 | 10.6891 | 10.9379 | 52850.0 |
| 2010-05-10 | ABCD-DELISTED | Stock | 5.1 | 5.22 | 5.07 | 5.16 | 27304.0 |
| 2010-05-10 | ABCO-DELISTED | Stock | 19.13 | 19.685 | 19.125 | 19.475 | 282658.0 |
| 2010-05-10 | ABCW-DELISTED | Stock | 0.9799 | 0.9997 | 0.9601 | 0.97 | 84290.0 |
| 2010-05-10 | ABD-DELISTED | Stock | 7.535 | 7.785 | 7.345 | 7.545 | 1201100.0 |
| 2010-05-10 | ABE-DELISTED | Stock | 16.08 | 16.52 | 16.08 | 16.48 | 24464.0 |
| 2010-05-10 | ABEO | Stock | 2875.0 | 3137.5 | 2825.0 | 3137.5 | 19.0 |
| 2010-05-10 | ABFS-DELISTED | Stock | 28.75 | 28.75 | 27.78 | 28.43 | 415176.0 |
| 2010-05-10 | ABG | Stock | 14.31 | 14.59 | 14.0 | 14.48 | 451000.0 |
| 2010-05-10 | ABII-DELISTED | Stock | 48.1 | 49.3599 | 47.14 | 47.77 | 39069.0 |
| 2010-05-10 | ABK-DELISTED | Stock | 1.58 | 1.58 | 1.425 | 1.49 | 21992492.0 |
| 2010-05-10 | ABM | Stock | 21.19 | 21.67 | 20.89 | 21.57 | 240400.0 |
| 2010-05-10 | ABMD-DELISTED | Stock | 8.79 | 8.9 | 8.62 | 8.85 | 232833.0 |
| 2010-05-10 | ABR | Stock | 4.0 | 4.19 | 4.0 | 4.08 | 200800.0 |
| 2010-05-10 | ABT | Stock | 23.894 | 24.1004 | 23.6254 | 23.8413 | 21408087.0 |
| 2010-05-10 | ABTL-DELISTED | Stock | 5.35 | 5.4509 | 5.1481 | 5.35 | 483256.0 |
| 2010-05-10 | ABV-DELISTED | Stock | 97.71 | 99.03 | 96.91 | 98.75 | 712424.0 |
| 2010-05-10 | ABVA-DELISTED | Stock | 2.85 | 3.0 | 2.85 | 3.0 | 5100.0 |
| 2010-05-10 | ABVT-DELISTED | Stock | 50.64 | 51.0 | 46.1 | 47.23 | 606139.0 |
| 2010-05-10 | ABX-DELISTED | Stock | 43.06 | 43.99 | 42.3 | 43.89 | 13935077.0 |
| 2010-05-10 | ACAD | Stock | 1.5 | 1.57 | 1.41 | 1.57 | 398700.0 |
> showing 50 of 5,978 rows — these rows as CSV