PREVIEW / stock_daily / 2011-05-26
file: by_date/stock_daily/2011/2011-05-26.parquet size: 198 KB rows: 6,101 symbols: 3,548
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-26 | AAPL | Stock | 11.9989 | 12.0318 | 11.9439 | 11.9643 | 222560800.0 |
| 2011-05-26 | MSFT | Stock | 24.35 | 25.03 | 24.32 | 24.67 | 78016600.0 |
| 2011-05-26 | NVDA | Stock | 0.459 | 0.4745 | 0.4578 | 0.4705 | 706436000.0 |
| 2011-05-26 | AMZN | Stock | 9.562 | 9.8225 | 9.544 | 9.75 | 81504000.0 |
| 2011-05-26 | TSLA | Stock | 1.9213 | 1.984 | 1.8733 | 1.9653 | 50053500.0 |
| 2011-05-26 | TLT | Stock | 95.97 | 96.55 | 95.89 | 96.51 | 8311586.0 |
| 2011-05-26 | ES | Stock | 35.22 | 35.45 | 35.04 | 35.36 | 1211300.0 |
| 2011-05-26 | CL | Stock | 42.43 | 42.79 | 42.29 | 42.66 | 3827600.0 |
| 2011-05-26 | A | Stock | 34.8498 | 35.4793 | 34.7783 | 35.329 | 4569363.0 |
| 2011-05-26 | AABA-DELISTED | Stock | 16.19 | 16.22 | 15.88 | 15.99 | 22471110.0 |
| 2011-05-26 | AACC-DELISTED | Stock | 3.94 | 4.21 | 3.94 | 4.08 | 16182.0 |
| 2011-05-26 | AACG | Stock | 10.53 | 11.33 | 10.53 | 11.25 | 20900.0 |
| 2011-05-26 | AAIC-DELISTED | Stock | 27.4 | 27.75 | 27.15 | 27.69 | 73044.0 |
| 2011-05-26 | AAME | Stock | 2.03 | 2.05 | 2.03 | 2.05 | 200.0 |
| 2011-05-26 | AAON | Stock | 6.2914 | 6.5225 | 6.2637 | 6.5185 | 160481.0 |
| 2011-05-26 | AAP | Stock | 61.35 | 62.75 | 61.35 | 62.66 | 1705100.0 |
| 2011-05-26 | AAT | Stock | 21.64 | 21.87 | 21.52 | 21.76 | 128400.0 |
| 2011-05-26 | AATI-DELISTED | Stock | 3.82 | 3.91 | 3.78 | 3.89 | 242399.0 |
| 2011-05-26 | AAU-DELISTED | Stock | 3.84 | 3.92 | 3.64 | 3.78 | 251435.0 |
| 2011-05-26 | AAUAF-DELISTED | Stock | 3.84 | 3.92 | 3.64 | 3.78 | 252335.0 |
| 2011-05-26 | AAV-DELISTED | Stock | 8.0 | 8.1 | 7.88 | 8.08 | 259265.0 |
| 2011-05-26 | AAWW-DELISTED | Stock | 60.21 | 61.27 | 59.24 | 60.92 | 108187.0 |
| 2011-05-26 | AAXJ | Stock | 61.61 | 62.16 | 61.6 | 62.14 | 205494.0 |
| 2011-05-26 | AAXN-DELISTED | Stock | 4.49 | 4.6 | 4.41 | 4.6 | 501228.0 |
| 2011-05-26 | AB | Stock | 20.69 | 20.89 | 20.5 | 20.63 | 432700.0 |
| 2011-05-26 | ABAC-DELISTED | Stock | 2.8199 | 2.8199 | 2.75 | 2.76 | 9448.0 |
| 2011-05-26 | ABAX-DELISTED | Stock | 30.12 | 30.7 | 30.09 | 30.35 | 72322.0 |
| 2011-05-26 | ABB-DELISTED | Stock | 26.03 | 26.22 | 25.82 | 26.09 | 1940496.0 |
| 2011-05-26 | ABBC-DELISTED | Stock | 11.25 | 11.25 | 11.06 | 11.12 | 61097.0 |
| 2011-05-26 | ABBNY-DELISTED | Stock | 26.0 | 26.22 | 25.82 | 26.08 | 1943879.0 |
| 2011-05-26 | ABC-DELISTED | Stock | 41.51 | 41.58 | 41.04 | 41.45 | 1353025.0 |
| 2011-05-26 | ABCB | Stock | 8.69 | 8.85 | 8.63 | 8.85 | 44700.0 |
| 2011-05-26 | ABCD-DELISTED | Stock | 3.14 | 3.29 | 3.14 | 3.25 | 60855.0 |
| 2011-05-26 | ABCO-DELISTED | Stock | 25.34 | 25.63 | 25.29 | 25.6 | 46646.0 |
| 2011-05-26 | ABCW-DELISTED | Stock | 0.81 | 0.81 | 0.75 | 0.75 | 10940.0 |
| 2011-05-26 | ABD-DELISTED | Stock | 8.06 | 8.06 | 7.86 | 7.97 | 424940.0 |
| 2011-05-26 | ABE-DELISTED | Stock | 18.54 | 18.732 | 18.54 | 18.67 | 10511.0 |
| 2011-05-26 | ABEO | Stock | 2812.5 | 2837.5 | 2787.5 | 2837.5 | 4.0 |
| 2011-05-26 | ABFS-DELISTED | Stock | 24.62 | 24.87 | 23.8 | 24.71 | 500276.0 |
| 2011-05-26 | ABG | Stock | 16.59 | 16.88 | 16.38 | 16.6 | 368800.0 |
| 2011-05-26 | ABH-DELISTED | Stock | 23.48 | 23.97 | 23.35 | 23.89 | 506269.0 |
| 2011-05-26 | ABM | Stock | 22.44 | 22.78 | 22.41 | 22.6 | 283200.0 |
| 2011-05-26 | ABMD-DELISTED | Stock | 18.65 | 19.19 | 18.65 | 18.92 | 626301.0 |
| 2011-05-26 | ABR | Stock | 4.87 | 4.9 | 4.82 | 4.85 | 36200.0 |
| 2011-05-26 | ABT | Stock | 25.391 | 25.4726 | 24.7385 | 25.0168 | 37938933.0 |
| 2011-05-26 | ABTL-DELISTED | Stock | 6.05 | 6.2375 | 6.0 | 6.05 | 25136.0 |
| 2011-05-26 | ABUS | Stock | 2.88 | 2.89 | 2.8 | 2.84 | 5500.0 |
| 2011-05-26 | ABV-DELISTED | Stock | 30.93 | 31.16 | 30.7 | 30.96 | 1640940.0 |
| 2011-05-26 | ABVA-DELISTED | Stock | 5.7 | 5.79 | 5.7 | 5.79 | 830.0 |
| 2011-05-26 | ABVT-DELISTED | Stock | 70.11 | 74.1 | 70.07 | 73.97 | 351887.0 |
> showing 50 of 6,101 rows — these rows as CSV