PREVIEW / stock_daily / 2009-06-03
file: by_date/stock_daily/2009/2009-06-03.parquet size: 180 KB rows: 5,772 symbols: 3,443
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-03 | AAPL | Stock | 5.0 | 5.0396 | 4.9668 | 5.0339 | 565199600.0 |
| 2009-06-03 | MSFT | Stock | 21.31 | 21.76 | 21.29 | 21.73 | 56039600.0 |
| 2009-06-03 | NVDA | Stock | 0.2678 | 0.2688 | 0.2563 | 0.2628 | 735688000.0 |
| 2009-06-03 | AMZN | Stock | 4.1655 | 4.2855 | 4.1565 | 4.284 | 152068000.0 |
| 2009-06-03 | TLT | Stock | 91.96 | 92.61 | 91.33 | 92.44 | 6727244.0 |
| 2009-06-03 | ES | Stock | 21.48 | 21.55 | 20.91 | 21.07 | 948500.0 |
| 2009-06-03 | CL | Stock | 34.91 | 35.445 | 34.77 | 35.42 | 13098200.0 |
| 2009-06-03 | A | Stock | 13.9413 | 14.02 | 13.7053 | 13.8269 | 5618143.0 |
| 2009-06-03 | AABA-DELISTED | Stock | 16.44 | 16.5 | 15.67 | 16.29 | 26252022.0 |
| 2009-06-03 | AACC-DELISTED | Stock | 8.74 | 9.09 | 8.73 | 9.09 | 16455.0 |
| 2009-06-03 | AACG | Stock | 5.9 | 5.95 | 5.41 | 5.6 | 52900.0 |
| 2009-06-03 | AAI-DELISTED | Stock | 6.08 | 6.43 | 5.8 | 6.305 | 6392638.0 |
| 2009-06-03 | AAIC-DELISTED | Stock | 8.4 | 8.6 | 8.0 | 8.2 | 327405.0 |
| 2009-06-03 | AAME | Stock | 0.75 | 0.98 | 0.75 | 0.84 | 8000.0 |
| 2009-06-03 | AAON | Stock | 4.1422 | 4.318 | 4.1007 | 4.318 | 776587.0 |
| 2009-06-03 | AAP | Stock | 44.75 | 45.2 | 44.34 | 45.15 | 1651100.0 |
| 2009-06-03 | AATI-DELISTED | Stock | 4.76 | 4.8 | 4.67 | 4.8 | 221502.0 |
| 2009-06-03 | AAU-DELISTED | Stock | 0.91 | 0.94 | 0.8 | 0.8 | 135743.0 |
| 2009-06-03 | AAUAF-DELISTED | Stock | 0.91 | 0.94 | 0.8 | 0.8 | 136503.0 |
| 2009-06-03 | AAV-DELISTED | Stock | 4.52 | 4.52 | 4.25 | 4.3187 | 1015821.0 |
| 2009-06-03 | AAWW-DELISTED | Stock | 25.75 | 25.93 | 25.3 | 25.79 | 227964.0 |
| 2009-06-03 | AAXJ | Stock | 45.61 | 45.61 | 44.42 | 45.02 | 262789.0 |
| 2009-06-03 | AAXN-DELISTED | Stock | 4.54 | 4.72 | 4.46 | 4.72 | 420738.0 |
| 2009-06-03 | AB | Stock | 20.18 | 20.18 | 19.42 | 19.95 | 379500.0 |
| 2009-06-03 | ABAX-DELISTED | Stock | 18.4 | 18.84 | 18.27 | 18.5 | 132820.0 |
| 2009-06-03 | ABB-DELISTED | Stock | 16.82 | 16.91 | 16.46 | 16.71 | 4321994.0 |
| 2009-06-03 | ABBC-DELISTED | Stock | 8.97 | 9.07 | 8.8 | 9.01 | 32206.0 |
| 2009-06-03 | ABBNY-DELISTED | Stock | 16.82 | 16.91 | 16.46 | 16.7 | 4410444.0 |
| 2009-06-03 | ABC-DELISTED | Stock | 18.86 | 18.86 | 18.37 | 18.58 | 5957046.0 |
| 2009-06-03 | ABCB | Stock | 6.7404 | 6.8863 | 6.6139 | 6.7988 | 22413.0 |
| 2009-06-03 | ABCO-DELISTED | Stock | 12.587 | 12.758 | 12.412 | 12.758 | 190038.0 |
| 2009-06-03 | ABCW-DELISTED | Stock | 1.53 | 1.53 | 1.5 | 1.52 | 52110.0 |
| 2009-06-03 | ABD-DELISTED | Stock | 3.37 | 3.38 | 3.1199 | 3.21 | 167790.0 |
| 2009-06-03 | ABE-DELISTED | Stock | 15.98 | 15.98 | 15.13 | 15.25 | 19746.0 |
| 2009-06-03 | ABEO | Stock | 2800.0 | 2812.5 | 2575.0 | 2750.0 | 18.0 |
| 2009-06-03 | ABFS-DELISTED | Stock | 29.6 | 29.8499 | 29.0601 | 29.58 | 325431.0 |
| 2009-06-03 | ABG | Stock | 10.91 | 11.06 | 10.57 | 10.81 | 244100.0 |
| 2009-06-03 | ABII-DELISTED | Stock | 41.58 | 41.58 | 40.44 | 41.02 | 29475.0 |
| 2009-06-03 | ABK-DELISTED | Stock | 1.3 | 1.32 | 1.24 | 1.27 | 5856255.0 |
| 2009-06-03 | ABM | Stock | 17.19 | 17.35 | 17.02 | 17.29 | 177700.0 |
| 2009-06-03 | ABMD-DELISTED | Stock | 6.27 | 6.61 | 6.14 | 6.61 | 394816.0 |
| 2009-06-03 | ABR | Stock | 1.7 | 1.7 | 1.62 | 1.63 | 94200.0 |
| 2009-06-03 | ABT | Stock | 21.5814 | 21.8117 | 21.4375 | 21.6486 | 16699875.0 |
| 2009-06-03 | ABTL-DELISTED | Stock | 1.9 | 2.25 | 1.9 | 2.2 | 34171.0 |
| 2009-06-03 | ABV-DELISTED | Stock | 65.99 | 66.12 | 64.13 | 64.62 | 754983.0 |
| 2009-06-03 | ABVA-DELISTED | Stock | 3.005 | 3.02 | 2.97 | 2.97 | 550.0 |
| 2009-06-03 | ABVT-DELISTED | Stock | 71.5 | 72.5 | 71.0 | 71.0 | 42684.0 |
| 2009-06-03 | ABX-DELISTED | Stock | 37.21 | 37.45 | 35.92 | 36.44 | 11105631.0 |
| 2009-06-03 | ACAD | Stock | 1.96 | 1.99 | 1.9 | 1.97 | 146600.0 |
| 2009-06-03 | ACAP-DELISTED | Stock | 41.25 | 41.7 | 41.03 | 41.52 | 25676.0 |
> showing 50 of 5,772 rows — these rows as CSV