PREVIEW / stock_daily / 2009-06-15
file: by_date/stock_daily/2009/2009-06-15.parquet size: 181 KB rows: 5,777 symbols: 3,439
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-15 | AAPL | Stock | 4.8575 | 4.8904 | 4.8175 | 4.8604 | 539750400.0 |
| 2009-06-15 | MSFT | Stock | 23.23 | 23.54 | 23.02 | 23.42 | 69089600.0 |
| 2009-06-15 | NVDA | Stock | 0.2825 | 0.2862 | 0.278 | 0.283 | 445164000.0 |
| 2009-06-15 | AMZN | Stock | 4.1415 | 4.165 | 4.05 | 4.159 | 108036000.0 |
| 2009-06-15 | TLT | Stock | 90.54 | 91.15 | 90.48 | 90.78 | 4518630.0 |
| 2009-06-15 | ES | Stock | 21.94 | 22.13 | 21.65 | 21.94 | 1743200.0 |
| 2009-06-15 | CL | Stock | 35.41 | 35.41 | 34.88 | 34.98 | 5656000.0 |
| 2009-06-15 | A | Stock | 13.6838 | 13.7053 | 13.2332 | 13.5122 | 3293408.0 |
| 2009-06-15 | AABA-DELISTED | Stock | 16.57 | 16.6801 | 16.13 | 16.4 | 22862765.0 |
| 2009-06-15 | AACC-DELISTED | Stock | 8.83 | 8.92 | 8.61 | 8.91 | 23623.0 |
| 2009-06-15 | AACG | Stock | 7.02 | 7.25 | 7.0 | 7.25 | 39000.0 |
| 2009-06-15 | AAI-DELISTED | Stock | 5.3 | 5.41 | 5.125 | 5.36 | 2124151.0 |
| 2009-06-15 | AAIC-DELISTED | Stock | 8.8 | 8.8 | 8.0 | 8.2 | 546191.0 |
| 2009-06-15 | AAME | Stock | 0.74 | 0.74 | 0.73 | 0.73 | 1500.0 |
| 2009-06-15 | AAON | Stock | 4.1225 | 4.1481 | 3.8242 | 3.8835 | 444487.0 |
| 2009-06-15 | AAP | Stock | 40.75 | 41.55 | 40.5 | 41.49 | 1808400.0 |
| 2009-06-15 | AATI-DELISTED | Stock | 4.76 | 4.83 | 4.68 | 4.78 | 110498.0 |
| 2009-06-15 | AAU-DELISTED | Stock | 0.75 | 0.75 | 0.67 | 0.67 | 102900.0 |
| 2009-06-15 | AAUAF-DELISTED | Stock | 0.75 | 0.75 | 0.67 | 0.67 | 103100.0 |
| 2009-06-15 | AAV-DELISTED | Stock | 5.28 | 5.38 | 4.91 | 5.27 | 2693236.0 |
| 2009-06-15 | AAWW-DELISTED | Stock | 24.17 | 24.35 | 23.52 | 24.09 | 323964.0 |
| 2009-06-15 | AAXJ | Stock | 44.76 | 44.76 | 43.793 | 43.96 | 667869.0 |
| 2009-06-15 | AAXN-DELISTED | Stock | 4.36 | 4.36 | 4.1 | 4.2 | 370335.0 |
| 2009-06-15 | AB | Stock | 22.28 | 22.28 | 20.63 | 21.2 | 904600.0 |
| 2009-06-15 | ABAX-DELISTED | Stock | 17.39 | 17.39 | 16.86 | 17.03 | 157012.0 |
| 2009-06-15 | ABB-DELISTED | Stock | 16.22 | 16.23 | 15.8 | 15.95 | 3642009.0 |
| 2009-06-15 | ABBC-DELISTED | Stock | 8.43 | 8.47 | 8.2 | 8.35 | 47397.0 |
| 2009-06-15 | ABBNY-DELISTED | Stock | 16.22 | 16.23 | 15.8 | 15.94 | 3745809.0 |
| 2009-06-15 | ABC-DELISTED | Stock | 18.16 | 18.23 | 17.76 | 17.92 | 2776430.0 |
| 2009-06-15 | ABCB | Stock | 6.1957 | 6.4 | 5.9428 | 5.9623 | 32386.0 |
| 2009-06-15 | ABCO-DELISTED | Stock | 12.605 | 12.855 | 12.375 | 12.495 | 352624.0 |
| 2009-06-15 | ABCW-DELISTED | Stock | 1.36 | 1.36 | 1.2258 | 1.26 | 153220.0 |
| 2009-06-15 | ABD-DELISTED | Stock | 3.45 | 3.46 | 3.05 | 3.16 | 382370.0 |
| 2009-06-15 | ABE-DELISTED | Stock | 15.65 | 15.65 | 14.95 | 14.9697 | 20692.0 |
| 2009-06-15 | ABEO | Stock | 2750.0 | 2812.5 | 2687.5 | 2812.5 | 21.0 |
| 2009-06-15 | ABFS-DELISTED | Stock | 28.84 | 29.45 | 28.11 | 28.64 | 729111.0 |
| 2009-06-15 | ABG | Stock | 11.34 | 11.39 | 10.67 | 11.1 | 289800.0 |
| 2009-06-15 | ABII-DELISTED | Stock | 42.88 | 42.88 | 39.5127 | 39.6 | 28369.0 |
| 2009-06-15 | ABK-DELISTED | Stock | 1.24 | 1.24 | 1.15 | 1.16 | 4518442.0 |
| 2009-06-15 | ABM | Stock | 18.33 | 18.38 | 17.79 | 18.15 | 173000.0 |
| 2009-06-15 | ABMD-DELISTED | Stock | 7.3 | 7.78 | 7.14 | 7.7 | 676969.0 |
| 2009-06-15 | ABR | Stock | 2.15 | 2.19 | 1.81 | 2.01 | 438900.0 |
| 2009-06-15 | ABT | Stock | 21.9029 | 21.9029 | 21.3895 | 21.4615 | 19175698.0 |
| 2009-06-15 | ABTL-DELISTED | Stock | 2.0741 | 2.15 | 2.0741 | 2.15 | 7436.0 |
| 2009-06-15 | ABV-DELISTED | Stock | 65.95 | 65.95 | 64.3 | 64.93 | 708921.0 |
| 2009-06-15 | ABVA-DELISTED | Stock | 2.7 | 2.71 | 2.65 | 2.65 | 2492.0 |
| 2009-06-15 | ABVT-DELISTED | Stock | 80.75 | 80.75 | 76.8 | 78.5 | 17258.0 |
| 2009-06-15 | ABX-DELISTED | Stock | 33.6 | 33.75 | 32.6 | 32.91 | 8416377.0 |
| 2009-06-15 | ACAD | Stock | 2.12 | 2.3 | 2.11 | 2.23 | 180600.0 |
| 2009-06-15 | ACAP-DELISTED | Stock | 40.37 | 40.37 | 38.03 | 38.74 | 78063.0 |
> showing 50 of 5,777 rows — these rows as CSV