PREVIEW / stock_daily / 2009-06-08
file: by_date/stock_daily/2009/2009-06-08.parquet size: 181 KB rows: 5,797 symbols: 3,471
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-08 | AAPL | Stock | 5.1364 | 5.1511 | 4.9796 | 5.1375 | 931652400.0 |
| 2009-06-08 | MSFT | Stock | 21.98 | 22.32 | 21.63 | 22.05 | 49000600.0 |
| 2009-06-08 | NVDA | Stock | 0.2688 | 0.273 | 0.2625 | 0.2692 | 473948000.0 |
| 2009-06-08 | AMZN | Stock | 4.3375 | 4.359 | 4.2555 | 4.318 | 112042000.0 |
| 2009-06-08 | TLT | Stock | 90.41 | 90.73 | 89.48 | 89.61 | 4084816.0 |
| 2009-06-08 | ES | Stock | 21.31 | 21.31 | 20.87 | 21.12 | 1329500.0 |
| 2009-06-08 | CL | Stock | 35.12 | 35.665 | 34.965 | 35.44 | 6432600.0 |
| 2009-06-08 | A | Stock | 14.1202 | 14.2561 | 13.7053 | 14.0486 | 3000527.0 |
| 2009-06-08 | AABA-DELISTED | Stock | 16.46 | 16.49 | 16.04 | 16.21 | 13419011.0 |
| 2009-06-08 | AACC-DELISTED | Stock | 8.65 | 9.32 | 8.65 | 8.99 | 32100.0 |
| 2009-06-08 | AACG | Stock | 6.42 | 6.8 | 6.25 | 6.66 | 10100.0 |
| 2009-06-08 | AAI-DELISTED | Stock | 6.12 | 6.14 | 5.7 | 5.86 | 3131017.0 |
| 2009-06-08 | AAIC-DELISTED | Stock | 9.932 | 9.932 | 9.0 | 9.0 | 646567.0 |
| 2009-06-08 | AAME | Stock | 0.73 | 0.73 | 0.73 | 0.73 | 500.0 |
| 2009-06-08 | AAON | Stock | 4.2805 | 4.3259 | 4.162 | 4.2311 | 211612.0 |
| 2009-06-08 | AAP | Stock | 43.59 | 44.26 | 42.91 | 43.96 | 1432000.0 |
| 2009-06-08 | AATI-DELISTED | Stock | 4.65 | 4.65 | 4.37 | 4.41 | 215076.0 |
| 2009-06-08 | AAU-DELISTED | Stock | 0.78 | 0.781 | 0.72 | 0.76 | 166553.0 |
| 2009-06-08 | AAUAF-DELISTED | Stock | 0.78 | 0.781 | 0.72 | 0.76 | 165053.0 |
| 2009-06-08 | AAV-DELISTED | Stock | 4.59 | 4.86 | 4.47 | 4.85 | 1074513.0 |
| 2009-06-08 | AAWW-DELISTED | Stock | 25.35 | 25.71 | 23.54 | 24.42 | 461579.0 |
| 2009-06-08 | AAXJ | Stock | 44.87 | 45.37 | 44.25 | 44.9 | 463530.0 |
| 2009-06-08 | AAXN-DELISTED | Stock | 4.63 | 4.66 | 4.49 | 4.49 | 276449.0 |
| 2009-06-08 | AB | Stock | 20.75 | 21.24 | 20.24 | 21.09 | 461200.0 |
| 2009-06-08 | ABAX-DELISTED | Stock | 17.5 | 17.88 | 17.36 | 17.55 | 126375.0 |
| 2009-06-08 | ABB-DELISTED | Stock | 15.88 | 16.26 | 15.67 | 16.15 | 3752679.0 |
| 2009-06-08 | ABBC-DELISTED | Stock | 9.15 | 9.17 | 9.05 | 9.06 | 37537.0 |
| 2009-06-08 | ABBNY-DELISTED | Stock | 15.88 | 16.26 | 15.67 | 16.12 | 3757655.0 |
| 2009-06-08 | ABC-DELISTED | Stock | 18.09 | 18.36 | 17.85 | 18.19 | 2366866.0 |
| 2009-06-08 | ABCB | Stock | 6.9738 | 7.4991 | 6.5459 | 7.2364 | 51099.0 |
| 2009-06-08 | ABCO-DELISTED | Stock | 12.725 | 12.895 | 12.485 | 12.68 | 80112.0 |
| 2009-06-08 | ABCW-DELISTED | Stock | 1.6 | 1.6078 | 1.49 | 1.54 | 56130.0 |
| 2009-06-08 | ABD-DELISTED | Stock | 3.45 | 3.46 | 3.1 | 3.23 | 375220.0 |
| 2009-06-08 | ABE-DELISTED | Stock | 15.45 | 15.55 | 15.22 | 15.47 | 20666.0 |
| 2009-06-08 | ABEO | Stock | 2812.5 | 2812.5 | 2625.0 | 2812.5 | 28.0 |
| 2009-06-08 | ABFS-DELISTED | Stock | 29.0 | 29.0 | 28.05 | 28.72 | 568543.0 |
| 2009-06-08 | ABG | Stock | 10.8 | 11.44 | 10.47 | 11.22 | 499400.0 |
| 2009-06-08 | ABII-DELISTED | Stock | 43.57 | 43.57 | 40.81 | 43.43 | 27701.0 |
| 2009-06-08 | ABK-DELISTED | Stock | 1.28 | 1.3 | 1.25 | 1.28 | 3236666.0 |
| 2009-06-08 | ABM | Stock | 18.88 | 19.4 | 18.72 | 19.12 | 343500.0 |
| 2009-06-08 | ABMD-DELISTED | Stock | 7.3 | 7.55 | 7.25 | 7.43 | 355751.0 |
| 2009-06-08 | ABR | Stock | 1.74 | 1.78 | 1.65 | 1.7 | 195800.0 |
| 2009-06-08 | ABT | Stock | 21.4183 | 21.6198 | 21.2407 | 21.4615 | 12509170.0 |
| 2009-06-08 | ABTL-DELISTED | Stock | 2.15 | 2.15 | 2.1 | 2.15 | 7485.0 |
| 2009-06-08 | ABV-DELISTED | Stock | 64.33 | 65.18 | 64.03 | 64.58 | 520623.0 |
| 2009-06-08 | ABVA-DELISTED | Stock | 3.01 | 3.01 | 2.66 | 2.66 | 5846.0 |
| 2009-06-08 | ABVT-DELISTED | Stock | 75.95 | 80.0 | 75.935 | 79.5 | 98761.0 |
| 2009-06-08 | ABX-DELISTED | Stock | 35.45 | 36.64 | 35.09 | 36.56 | 7662809.0 |
| 2009-06-08 | ACAD | Stock | 2.48 | 2.48 | 2.25 | 2.34 | 298700.0 |
| 2009-06-08 | ACAP-DELISTED | Stock | 41.48 | 42.71 | 41.48 | 42.04 | 53100.0 |
> showing 50 of 5,797 rows — these rows as CSV