PREVIEW / stock_daily / 2009-06-25
file: by_date/stock_daily/2009/2009-06-25.parquet size: 180 KB rows: 5,775 symbols: 3,445
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-25 | AAPL | Stock | 4.8482 | 5.0071 | 4.8289 | 4.995 | 589447600.0 |
| 2009-06-25 | MSFT | Stock | 23.43 | 23.92 | 23.2 | 23.79 | 57724300.0 |
| 2009-06-25 | NVDA | Stock | 0.2688 | 0.286 | 0.266 | 0.2855 | 870444000.0 |
| 2009-06-25 | AMZN | Stock | 3.955 | 4.1115 | 3.9515 | 4.11 | 147208000.0 |
| 2009-06-25 | TLT | Stock | 93.22 | 94.5 | 92.67 | 94.43 | 7140032.0 |
| 2009-06-25 | ES | Stock | 21.8 | 22.35 | 21.5 | 22.15 | 1542000.0 |
| 2009-06-25 | CL | Stock | 35.035 | 35.87 | 34.825 | 35.72 | 6864600.0 |
| 2009-06-25 | A | Stock | 13.5622 | 14.3562 | 13.4979 | 14.2775 | 7063675.0 |
| 2009-06-25 | AABA-DELISTED | Stock | 15.43 | 15.67 | 15.245 | 15.54 | 19213987.0 |
| 2009-06-25 | AACC-DELISTED | Stock | 8.39 | 8.55 | 8.27 | 8.5 | 46641.0 |
| 2009-06-25 | AACG | Stock | 9.3 | 9.97 | 9.2 | 9.72 | 28700.0 |
| 2009-06-25 | AAI-DELISTED | Stock | 5.38 | 5.93 | 5.29 | 5.88 | 2585759.0 |
| 2009-06-25 | AAIC-DELISTED | Stock | 7.8 | 8.4 | 7.8 | 8.2 | 841089.0 |
| 2009-06-25 | AAON | Stock | 3.7728 | 3.9842 | 3.7728 | 3.9605 | 280969.0 |
| 2009-06-25 | AAP | Stock | 40.89 | 42.32 | 40.86 | 42.05 | 1168500.0 |
| 2009-06-25 | AATI-DELISTED | Stock | 4.47 | 4.75 | 4.37 | 4.6 | 456040.0 |
| 2009-06-25 | AAU-DELISTED | Stock | 0.64 | 0.7 | 0.625 | 0.69 | 76141.0 |
| 2009-06-25 | AAUAF-DELISTED | Stock | 0.64 | 0.7 | 0.625 | 0.69 | 76241.0 |
| 2009-06-25 | AAV-DELISTED | Stock | 4.45 | 4.58 | 4.33 | 4.55 | 809105.0 |
| 2009-06-25 | AAWW-DELISTED | Stock | 21.2 | 22.51 | 21.04 | 22.51 | 322933.0 |
| 2009-06-25 | AAXJ | Stock | 43.32 | 44.32 | 43.15 | 44.27 | 197388.0 |
| 2009-06-25 | AAXN-DELISTED | Stock | 4.4 | 4.56 | 4.4 | 4.55 | 414517.0 |
| 2009-06-25 | AB | Stock | 19.5 | 19.59 | 18.92 | 18.92 | 442700.0 |
| 2009-06-25 | ABAX-DELISTED | Stock | 19.0 | 20.63 | 19.0 | 20.35 | 411824.0 |
| 2009-06-25 | ABB-DELISTED | Stock | 15.11 | 15.63 | 15.07 | 15.57 | 3699419.0 |
| 2009-06-25 | ABBC-DELISTED | Stock | 8.01 | 8.31 | 8.0 | 8.29 | 92232.0 |
| 2009-06-25 | ABBNY-DELISTED | Stock | 15.11 | 15.63 | 15.07 | 15.58 | 3819919.0 |
| 2009-06-25 | ABC-DELISTED | Stock | 17.5 | 18.44 | 17.39 | 18.27 | 3838025.0 |
| 2009-06-25 | ABCB | Stock | 5.8164 | 6.0498 | 5.8164 | 6.0498 | 62510.0 |
| 2009-06-25 | ABCO-DELISTED | Stock | 12.827 | 13.178 | 12.737 | 13.023 | 133209.0 |
| 2009-06-25 | ABCW-DELISTED | Stock | 1.43 | 1.6 | 1.38 | 1.6 | 272980.0 |
| 2009-06-25 | ABD-DELISTED | Stock | 2.7249 | 2.8652 | 2.7049 | 2.8351 | 455790.0 |
| 2009-06-25 | ABE-DELISTED | Stock | 14.21 | 15.18 | 14.21 | 15.18 | 6413.0 |
| 2009-06-25 | ABEO | Stock | 2600.0 | 2775.0 | 2600.0 | 2712.5 | 6.0 |
| 2009-06-25 | ABFS-DELISTED | Stock | 26.97 | 28.19 | 26.62 | 28.1 | 489886.0 |
| 2009-06-25 | ABG | Stock | 10.2 | 11.05 | 10.05 | 11.02 | 324300.0 |
| 2009-06-25 | ABII-DELISTED | Stock | 38.29 | 38.7 | 36.22 | 36.85 | 32603.0 |
| 2009-06-25 | ABK-DELISTED | Stock | 0.95 | 1.01 | 0.91 | 0.98 | 11330085.0 |
| 2009-06-25 | ABM | Stock | 17.12 | 17.52 | 17.0 | 17.49 | 211500.0 |
| 2009-06-25 | ABMD-DELISTED | Stock | 8.36 | 8.51 | 8.03 | 8.39 | 233798.0 |
| 2009-06-25 | ABR | Stock | 1.8 | 2.03 | 1.78 | 2.02 | 178000.0 |
| 2009-06-25 | ABT | Stock | 22.4402 | 23.2079 | 22.3683 | 23.04 | 16172363.0 |
| 2009-06-25 | ABTL-DELISTED | Stock | 2.1575 | 2.1575 | 2.1058 | 2.1425 | 35836.0 |
| 2009-06-25 | ABV-DELISTED | Stock | 63.73 | 66.49 | 63.73 | 66.32 | 649145.0 |
| 2009-06-25 | ABVA-DELISTED | Stock | 2.56 | 2.56 | 2.5 | 2.51 | 745.0 |
| 2009-06-25 | ABVT-DELISTED | Stock | 79.84 | 82.89 | 78.411 | 81.72 | 146175.0 |
| 2009-06-25 | ABX-DELISTED | Stock | 33.64 | 35.32 | 33.6 | 35.3 | 8615285.0 |
| 2009-06-25 | ACAD | Stock | 1.9 | 2.25 | 1.9 | 2.19 | 297900.0 |
| 2009-06-25 | ACAP-DELISTED | Stock | 38.8 | 39.98 | 38.66 | 39.98 | 31732.0 |
| 2009-06-25 | ACAS-DELISTED | Stock | 2.6391 | 2.7302 | 2.6 | 2.72 | 2859459.0 |
> showing 50 of 5,775 rows — these rows as CSV