PREVIEW / stock_daily / 2010-06-01
file: by_date/stock_daily/2010/2010-06-01.parquet size: 189 KB rows: 5,914 symbols: 3,478
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-06-01 | AAPL | Stock | 9.2746 | 9.4979 | 9.2486 | 9.3154 | 876472800.0 |
| 2010-06-01 | MSFT | Stock | 25.53 | 26.31 | 25.52 | 25.89 | 76152400.0 |
| 2010-06-01 | NVDA | Stock | 0.324 | 0.3278 | 0.3143 | 0.3145 | 527492000.0 |
| 2010-06-01 | AMZN | Stock | 6.2485 | 6.3285 | 6.151 | 6.162 | 73190000.0 |
| 2010-06-01 | TLT | Stock | 97.23 | 97.29 | 96.25 | 96.85 | 5536329.0 |
| 2010-06-01 | ES | Stock | 25.83 | 26.07 | 25.28 | 25.3 | 1424900.0 |
| 2010-06-01 | CL | Stock | 38.885 | 39.115 | 38.425 | 38.465 | 6696000.0 |
| 2010-06-01 | A | Stock | 22.9542 | 23.1545 | 22.475 | 22.5179 | 3883085.0 |
| 2010-06-01 | AABA-DELISTED | Stock | 15.31 | 15.55 | 14.98 | 15.02 | 30284088.0 |
| 2010-06-01 | AACC-DELISTED | Stock | 5.85 | 5.85 | 5.28 | 5.31 | 52048.0 |
| 2010-06-01 | AACG | Stock | 3.26 | 3.38 | 3.21 | 3.29 | 3300.0 |
| 2010-06-01 | AAI-DELISTED | Stock | 5.6 | 5.75 | 5.55 | 5.59 | 3342303.0 |
| 2010-06-01 | AAIC-DELISTED | Stock | 18.93 | 19.73 | 18.66 | 18.7 | 32961.0 |
| 2010-06-01 | AAME | Stock | 1.45 | 1.5 | 1.31 | 1.35 | 12100.0 |
| 2010-06-01 | AAON | Stock | 4.8731 | 4.8731 | 4.5748 | 4.5768 | 585225.0 |
| 2010-06-01 | AAP | Stock | 51.74 | 51.74 | 50.2 | 50.37 | 2359500.0 |
| 2010-06-01 | AATI-DELISTED | Stock | 3.44 | 3.58 | 3.41 | 3.46 | 262028.0 |
| 2010-06-01 | AAU-DELISTED | Stock | 1.0 | 1.04 | 0.95 | 0.96 | 166718.0 |
| 2010-06-01 | AAUAF-DELISTED | Stock | 1.0 | 1.04 | 0.95 | 0.96 | 167418.0 |
| 2010-06-01 | AAV-DELISTED | Stock | 6.0 | 6.24 | 5.89 | 5.92 | 613538.0 |
| 2010-06-01 | AAWW-DELISTED | Stock | 51.75 | 53.06 | 49.85 | 49.87 | 241108.0 |
| 2010-06-01 | AAXJ | Stock | 51.0 | 52.17 | 50.83 | 50.87 | 6750126.0 |
| 2010-06-01 | AAXN-DELISTED | Stock | 4.41 | 4.47 | 4.13 | 4.13 | 1063409.0 |
| 2010-06-01 | AB | Stock | 28.3 | 28.75 | 28.08 | 28.37 | 365800.0 |
| 2010-06-01 | ABAX-DELISTED | Stock | 22.28 | 22.85 | 22.04 | 22.05 | 91012.0 |
| 2010-06-01 | ABB-DELISTED | Stock | 16.83 | 17.34 | 16.68 | 16.7 | 3520744.0 |
| 2010-06-01 | ABBC-DELISTED | Stock | 8.85 | 9.2 | 8.85 | 9.03 | 127494.0 |
| 2010-06-01 | ABBNY-DELISTED | Stock | 16.83 | 17.34 | 16.68 | 16.69 | 3629480.0 |
| 2010-06-01 | ABC-DELISTED | Stock | 31.03 | 31.4365 | 30.73 | 30.81 | 4088171.0 |
| 2010-06-01 | ABCB | Stock | 11.2066 | 11.3161 | 10.4502 | 10.6493 | 176034.0 |
| 2010-06-01 | ABCD-DELISTED | Stock | 4.75 | 4.79 | 4.66 | 4.7 | 17900.0 |
| 2010-06-01 | ABCO-DELISTED | Stock | 18.497 | 18.867 | 18.328 | 18.398 | 101640.0 |
| 2010-06-01 | ABCW-DELISTED | Stock | 0.7579 | 0.8065 | 0.6996 | 0.72 | 74310.0 |
| 2010-06-01 | ABD-DELISTED | Stock | 6.96 | 6.99 | 6.6257 | 6.67 | 421940.0 |
| 2010-06-01 | ABE-DELISTED | Stock | 15.41 | 15.55 | 15.24 | 15.24 | 14654.0 |
| 2010-06-01 | ABEO | Stock | 3000.0 | 3062.5 | 2875.0 | 2875.0 | 22.0 |
| 2010-06-01 | ABFS-DELISTED | Stock | 23.32 | 23.5 | 22.65 | 22.65 | 1296895.0 |
| 2010-06-01 | ABG | Stock | 13.01 | 13.19 | 12.44 | 12.44 | 346800.0 |
| 2010-06-01 | ABII-DELISTED | Stock | 45.01 | 51.89 | 44.96 | 50.75 | 202937.0 |
| 2010-06-01 | ABK-DELISTED | Stock | 1.14 | 1.34 | 1.12 | 1.18 | 49036955.0 |
| 2010-06-01 | ABM | Stock | 21.21 | 21.63 | 21.03 | 21.06 | 301700.0 |
| 2010-06-01 | ABMD-DELISTED | Stock | 9.6 | 9.61 | 9.4 | 9.42 | 257398.0 |
| 2010-06-01 | ABR | Stock | 3.7 | 3.78 | 3.49 | 3.49 | 77800.0 |
| 2010-06-01 | ABT | Stock | 22.7617 | 22.8961 | 22.5026 | 22.5218 | 18251355.0 |
| 2010-06-01 | ABTL-DELISTED | Stock | 6.4 | 6.4 | 5.8 | 5.9 | 31952.0 |
| 2010-06-01 | ABV-DELISTED | Stock | 95.19 | 97.06 | 94.5 | 94.59 | 735427.0 |
| 2010-06-01 | ABVA-DELISTED | Stock | 2.75 | 2.75 | 2.75 | 2.75 | 200.0 |
| 2010-06-01 | ABVT-DELISTED | Stock | 45.49 | 45.58 | 44.0 | 44.01 | 153960.0 |
| 2010-06-01 | ABX-DELISTED | Stock | 42.53 | 43.66 | 42.44 | 42.57 | 13736377.0 |
| 2010-06-01 | ACAD | Stock | 1.3 | 1.36 | 1.29 | 1.33 | 142900.0 |
> showing 50 of 5,914 rows — these rows as CSV