PREVIEW / stock_daily / 2010-06-15
file: by_date/stock_daily/2010/2010-06-15.parquet size: 191 KB rows: 5,962 symbols: 3,508
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-15 | AAPL | Stock | 9.13 | 9.2804 | 9.125 | 9.2746 | 585074000.0 |
| 2010-06-15 | MSFT | Stock | 25.75 | 26.65 | 25.74 | 26.58 | 81641500.0 |
| 2010-06-15 | NVDA | Stock | 0.2872 | 0.2995 | 0.2868 | 0.298 | 528632000.0 |
| 2010-06-15 | AMZN | Stock | 6.16 | 6.346 | 6.125 | 6.342 | 90820000.0 |
| 2010-06-15 | TLT | Stock | 97.11 | 97.25 | 96.05 | 96.51 | 4920038.0 |
| 2010-06-15 | ES | Stock | 26.15 | 26.48 | 26.15 | 26.48 | 1676400.0 |
| 2010-06-15 | CL | Stock | 39.87 | 40.43 | 39.84 | 40.405 | 4172200.0 |
| 2010-06-15 | A | Stock | 22.7468 | 23.0472 | 22.568 | 23.0329 | 3576503.0 |
| 2010-06-15 | AABA-DELISTED | Stock | 15.29 | 15.69 | 15.23 | 15.65 | 13754720.0 |
| 2010-06-15 | AACC-DELISTED | Stock | 4.63 | 4.7 | 4.52 | 4.6 | 98246.0 |
| 2010-06-15 | AACG | Stock | 3.53 | 3.6 | 3.5 | 3.5 | 11000.0 |
| 2010-06-15 | AAI-DELISTED | Stock | 5.87 | 6.01 | 5.87 | 5.8875 | 4280121.0 |
| 2010-06-15 | AAIC-DELISTED | Stock | 19.9 | 20.21 | 19.71 | 20.21 | 28735.0 |
| 2010-06-15 | AAME | Stock | 1.4 | 1.4 | 1.32 | 1.32 | 2400.0 |
| 2010-06-15 | AAON | Stock | 4.7921 | 4.8454 | 4.7131 | 4.8119 | 479419.0 |
| 2010-06-15 | AAP | Stock | 51.06 | 52.27 | 50.86 | 52.14 | 1056400.0 |
| 2010-06-15 | AATI-DELISTED | Stock | 3.69 | 3.79 | 3.58 | 3.78 | 352953.0 |
| 2010-06-15 | AAU-DELISTED | Stock | 0.93 | 0.95 | 0.9104 | 0.93 | 90588.0 |
| 2010-06-15 | AAUAF-DELISTED | Stock | 0.93 | 0.95 | 0.9104 | 0.93 | 91088.0 |
| 2010-06-15 | AAV-DELISTED | Stock | 6.48 | 6.95 | 6.4 | 6.9 | 1189630.0 |
| 2010-06-15 | AAWW-DELISTED | Stock | 52.43 | 53.99 | 52.34 | 53.73 | 178179.0 |
| 2010-06-15 | AAXJ | Stock | 53.21 | 54.53 | 53.21 | 54.43 | 542912.0 |
| 2010-06-15 | AAXN-DELISTED | Stock | 4.23 | 4.25 | 3.98 | 4.19 | 2336954.0 |
| 2010-06-15 | AB | Stock | 28.93 | 28.99 | 28.44 | 28.59 | 233300.0 |
| 2010-06-15 | ABAX-DELISTED | Stock | 23.29 | 23.56 | 22.85 | 23.41 | 76393.0 |
| 2010-06-15 | ABB-DELISTED | Stock | 18.38 | 18.63 | 18.27 | 18.62 | 3249542.0 |
| 2010-06-15 | ABBC-DELISTED | Stock | 8.89 | 8.91 | 8.8 | 8.88 | 62766.0 |
| 2010-06-15 | ABBNY-DELISTED | Stock | 18.38 | 18.64 | 18.27 | 18.64 | 3328823.0 |
| 2010-06-15 | ABC-DELISTED | Stock | 32.49 | 32.5 | 32.21 | 32.45 | 3007052.0 |
| 2010-06-15 | ABCB | Stock | 10.4403 | 10.5299 | 10.2512 | 10.4104 | 104194.0 |
| 2010-06-15 | ABCD-DELISTED | Stock | 4.36 | 4.42 | 4.33 | 4.35 | 21922.0 |
| 2010-06-15 | ABCO-DELISTED | Stock | 19.91 | 20.4 | 19.75 | 20.36 | 142740.0 |
| 2010-06-15 | ABCW-DELISTED | Stock | 0.7382 | 0.759 | 0.6966 | 0.72 | 86750.0 |
| 2010-06-15 | ABD-DELISTED | Stock | 5.47 | 5.6434 | 5.38 | 5.56 | 779580.0 |
| 2010-06-15 | ABE-DELISTED | Stock | 15.86 | 16.13 | 15.86 | 16.1 | 19290.0 |
| 2010-06-15 | ABEO | Stock | 2937.5 | 3125.0 | 2937.5 | 3062.5 | 28.0 |
| 2010-06-15 | ABFS-DELISTED | Stock | 22.35 | 22.36 | 21.39 | 21.98 | 648074.0 |
| 2010-06-15 | ABG | Stock | 12.96 | 13.69 | 12.74 | 13.69 | 455500.0 |
| 2010-06-15 | ABII-DELISTED | Stock | 61.28 | 62.79 | 60.75 | 62.78 | 45957.0 |
| 2010-06-15 | ABK-DELISTED | Stock | 0.86 | 0.96 | 0.8299 | 0.8611 | 40358345.0 |
| 2010-06-15 | ABM | Stock | 21.4 | 22.22 | 21.37 | 22.18 | 265300.0 |
| 2010-06-15 | ABMD-DELISTED | Stock | 9.52 | 9.82 | 9.35 | 9.74 | 158668.0 |
| 2010-06-15 | ABR | Stock | 4.59 | 5.09 | 4.55 | 4.93 | 617600.0 |
| 2010-06-15 | ABT | Stock | 22.8097 | 23.1312 | 22.7617 | 23.112 | 19942684.0 |
| 2010-06-15 | ABTL-DELISTED | Stock | 5.9244 | 6.7277 | 5.7738 | 6.2256 | 37395.0 |
| 2010-06-15 | ABV-DELISTED | Stock | 101.47 | 104.06 | 100.73 | 103.86 | 560275.0 |
| 2010-06-15 | ABVA-DELISTED | Stock | 2.655 | 2.655 | 2.65 | 2.65 | 500.0 |
| 2010-06-15 | ABVT-DELISTED | Stock | 46.68 | 47.48 | 46.25 | 46.99 | 1194932.0 |
| 2010-06-15 | ABX-DELISTED | Stock | 42.04 | 42.95 | 41.75 | 42.94 | 6559288.0 |
| 2010-06-15 | ACAD | Stock | 1.25 | 1.3 | 1.22 | 1.3 | 155800.0 |
> showing 50 of 5,962 rows — these rows as CSV