PREVIEW / stock_daily / 2010-06-30
file: by_date/stock_daily/2010/2010-06-30.parquet size: 190 KB rows: 5,965 symbols: 3,515
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-30 | AAPL | Stock | 9.1682 | 9.2132 | 8.9289 | 8.9832 | 739452000.0 |
| 2010-06-30 | MSFT | Stock | 23.3 | 23.68 | 22.95 | 23.01 | 81050500.0 |
| 2010-06-30 | NVDA | Stock | 0.2625 | 0.2652 | 0.2553 | 0.2553 | 623072000.0 |
| 2010-06-30 | AMZN | Stock | 5.429 | 5.634 | 5.4055 | 5.463 | 194814000.0 |
| 2010-06-30 | TSLA | Stock | 1.7193 | 2.028 | 1.5533 | 1.5887 | 257806500.0 |
| 2010-06-30 | TLT | Stock | 101.41 | 101.79 | 100.8 | 101.75 | 7205937.0 |
| 2010-06-30 | ES | Stock | 25.49 | 25.9 | 25.38 | 25.48 | 1242700.0 |
| 2010-06-30 | CL | Stock | 39.005 | 39.625 | 38.865 | 39.38 | 7761200.0 |
| 2010-06-30 | A | Stock | 20.8584 | 21.0944 | 20.2575 | 20.3362 | 5267804.0 |
| 2010-06-30 | AABA-DELISTED | Stock | 13.97 | 14.22 | 13.79 | 13.84 | 23724933.0 |
| 2010-06-30 | AACC-DELISTED | Stock | 4.34 | 4.37 | 4.12 | 4.16 | 109953.0 |
| 2010-06-30 | AACG | Stock | 2.94 | 3.05 | 2.82 | 3.0 | 7900.0 |
| 2010-06-30 | AAI-DELISTED | Stock | 4.96 | 5.05 | 4.81 | 4.81 | 3519581.0 |
| 2010-06-30 | AAIC-DELISTED | Stock | 18.77 | 18.91 | 18.617 | 18.83 | 89385.0 |
| 2010-06-30 | AAON | Stock | 4.642 | 4.7289 | 4.5807 | 4.6044 | 326531.0 |
| 2010-06-30 | AAP | Stock | 50.29 | 50.96 | 50.0 | 50.18 | 1170300.0 |
| 2010-06-30 | AATI-DELISTED | Stock | 3.2 | 3.21 | 3.15 | 3.19 | 94644.0 |
| 2010-06-30 | AAU-DELISTED | Stock | 0.893 | 0.9295 | 0.8897 | 0.8974 | 46997.0 |
| 2010-06-30 | AAUAF-DELISTED | Stock | 0.893 | 0.93 | 0.89 | 0.8979 | 47273.0 |
| 2010-06-30 | AAV-DELISTED | Stock | 5.93 | 6.07 | 5.78 | 5.8 | 366595.0 |
| 2010-06-30 | AAWW-DELISTED | Stock | 47.88 | 49.29 | 47.15 | 47.59 | 327686.0 |
| 2010-06-30 | AAXJ | Stock | 52.93 | 52.93 | 51.98 | 52.08 | 1119395.0 |
| 2010-06-30 | AAXN-DELISTED | Stock | 3.81 | 4.13 | 3.81 | 3.9 | 1096874.0 |
| 2010-06-30 | AB | Stock | 26.52 | 26.99 | 25.78 | 25.84 | 388600.0 |
| 2010-06-30 | ABAX-DELISTED | Stock | 21.62 | 22.39 | 21.3 | 21.41 | 151793.0 |
| 2010-06-30 | ABB-DELISTED | Stock | 17.44 | 17.65 | 17.2 | 17.27 | 4204589.0 |
| 2010-06-30 | ABBC-DELISTED | Stock | 8.82 | 8.92 | 8.71 | 8.71 | 84455.0 |
| 2010-06-30 | ABBNY-DELISTED | Stock | 17.44 | 17.65 | 17.2 | 17.28 | 4224510.0 |
| 2010-06-30 | ABC-DELISTED | Stock | 31.75 | 32.36 | 31.46 | 31.76 | 7250685.0 |
| 2010-06-30 | ABCB | Stock | 9.63 | 9.79 | 9.54 | 9.66 | 437900.0 |
| 2010-06-30 | ABCD-DELISTED | Stock | 3.53 | 3.66 | 3.42 | 3.6 | 90265.0 |
| 2010-06-30 | ABCO-DELISTED | Stock | 21.38 | 21.63 | 21.31 | 21.5 | 202294.0 |
| 2010-06-30 | ABCW-DELISTED | Stock | 0.52 | 0.55 | 0.45 | 0.45 | 121240.0 |
| 2010-06-30 | ABD-DELISTED | Stock | 5.22 | 5.27 | 4.93 | 4.99 | 880360.0 |
| 2010-06-30 | ABE-DELISTED | Stock | 15.44 | 15.81 | 15.44 | 15.81 | 86075.0 |
| 2010-06-30 | ABEO | Stock | 2500.0 | 2537.5 | 2375.0 | 2450.0 | 28.0 |
| 2010-06-30 | ABFS-DELISTED | Stock | 20.66 | 21.13 | 20.57 | 20.75 | 509772.0 |
| 2010-06-30 | ABG | Stock | 10.72 | 10.99 | 10.43 | 10.54 | 337100.0 |
| 2010-06-30 | ABII-DELISTED | Stock | 73.19 | 74.75 | 73.01 | 74.26 | 1368653.0 |
| 2010-06-30 | ABK-DELISTED | Stock | 0.67 | 0.7 | 0.6311 | 0.67 | 6963567.0 |
| 2010-06-30 | ABM | Stock | 21.25 | 21.53 | 20.89 | 20.95 | 238600.0 |
| 2010-06-30 | ABMD-DELISTED | Stock | 9.58 | 9.92 | 9.58 | 9.69 | 203565.0 |
| 2010-06-30 | ABR | Stock | 4.96 | 5.2 | 4.95 | 5.13 | 141200.0 |
| 2010-06-30 | ABT | Stock | 22.3875 | 22.6658 | 22.1572 | 22.445 | 21387662.0 |
| 2010-06-30 | ABTL-DELISTED | Stock | 5.6486 | 5.9568 | 5.6486 | 5.7 | 25821.0 |
| 2010-06-30 | ABV-DELISTED | Stock | 104.41 | 104.5 | 100.59 | 101.04 | 894720.0 |
| 2010-06-30 | ABVA-DELISTED | Stock | 2.45 | 2.8 | 2.45 | 2.69 | 3857.0 |
| 2010-06-30 | ABVT-DELISTED | Stock | 47.16 | 47.76 | 46.78 | 47.18 | 216546.0 |
| 2010-06-30 | ABX-DELISTED | Stock | 44.91 | 46.0 | 44.84 | 45.44 | 9188579.0 |
| 2010-06-30 | ACAD | Stock | 1.13 | 1.13 | 1.0 | 1.09 | 788800.0 |
> showing 50 of 5,965 rows — these rows as CSV