PREVIEW / stock_daily / 2009-07-01
file: by_date/stock_daily/2009/2009-07-01.parquet size: 180 KB rows: 5,709 symbols: 3,393
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-07-01 | AAPL | Stock | 5.125 | 5.1664 | 5.09 | 5.1011 | 414178800.0 |
| 2009-07-01 | MSFT | Stock | 24.05 | 24.3 | 23.96 | 24.04 | 54908400.0 |
| 2009-07-01 | NVDA | Stock | 0.284 | 0.2872 | 0.2788 | 0.2835 | 696420000.0 |
| 2009-07-01 | AMZN | Stock | 4.221 | 4.225 | 4.0685 | 4.08 | 139624000.0 |
| 2009-07-01 | TLT | Stock | 93.42 | 94.09 | 93.24 | 94.08 | 3379993.0 |
| 2009-07-01 | ES | Stock | 22.41 | 23.0 | 22.41 | 22.98 | 1513600.0 |
| 2009-07-01 | CL | Stock | 35.465 | 36.19 | 35.465 | 36.07 | 5827400.0 |
| 2009-07-01 | A | Stock | 14.5708 | 14.9857 | 14.4707 | 14.7496 | 4742715.0 |
| 2009-07-01 | AABA-DELISTED | Stock | 15.49 | 15.69 | 15.35 | 15.41 | 12531223.0 |
| 2009-07-01 | AACC-DELISTED | Stock | 7.78 | 7.89 | 7.43 | 7.45 | 75511.0 |
| 2009-07-01 | AACG | Stock | 8.52 | 9.65 | 8.07 | 9.48 | 14200.0 |
| 2009-07-01 | AAI-DELISTED | Stock | 6.24 | 6.54 | 6.18 | 6.48 | 2026998.0 |
| 2009-07-01 | AAIC-DELISTED | Stock | 8.216 | 8.216 | 7.4 | 8.0 | 443365.0 |
| 2009-07-01 | AAME | Stock | 0.75 | 0.75 | 0.75 | 0.75 | 200.0 |
| 2009-07-01 | AAON | Stock | 3.9763 | 4.1165 | 3.9427 | 4.0988 | 286537.0 |
| 2009-07-01 | AAP | Stock | 41.71 | 42.29 | 41.49 | 42.09 | 1521800.0 |
| 2009-07-01 | AATI-DELISTED | Stock | 4.6 | 4.6 | 4.56 | 4.6 | 273825.0 |
| 2009-07-01 | AAU-DELISTED | Stock | 0.62 | 0.67 | 0.62 | 0.658 | 37971.0 |
| 2009-07-01 | AAUAF-DELISTED | Stock | 0.62 | 0.67 | 0.62 | 0.658 | 40071.0 |
| 2009-07-01 | AAV-DELISTED | Stock | 4.26 | 4.28 | 4.05 | 4.11 | 544572.0 |
| 2009-07-01 | AAWW-DELISTED | Stock | 23.21 | 24.85 | 23.21 | 23.89 | 273181.0 |
| 2009-07-01 | AAXJ | Stock | 44.57 | 45.25 | 44.57 | 44.97 | 112321.0 |
| 2009-07-01 | AAXN-DELISTED | Stock | 4.62 | 4.79 | 4.62 | 4.66 | 438656.0 |
| 2009-07-01 | AB | Stock | 20.08 | 20.49 | 19.99 | 20.44 | 203200.0 |
| 2009-07-01 | ABAX-DELISTED | Stock | 20.52 | 20.73 | 20.0 | 20.1 | 290199.0 |
| 2009-07-01 | ABB-DELISTED | Stock | 16.13 | 16.37 | 16.12 | 16.18 | 4584188.0 |
| 2009-07-01 | ABBC-DELISTED | Stock | 7.99 | 8.19 | 7.987 | 8.14 | 44766.0 |
| 2009-07-01 | ABBNY-DELISTED | Stock | 16.12 | 16.37 | 16.12 | 16.16 | 5503988.0 |
| 2009-07-01 | ABC-DELISTED | Stock | 17.85 | 18.41 | 17.67 | 18.25 | 3177759.0 |
| 2009-07-01 | ABCB | Stock | 6.2735 | 6.507 | 6.2152 | 6.3709 | 27451.0 |
| 2009-07-01 | ABCO-DELISTED | Stock | 12.912 | 13.032 | 12.748 | 12.778 | 145458.0 |
| 2009-07-01 | ABCW-DELISTED | Stock | 1.3 | 1.3 | 1.1997 | 1.25 | 182520.0 |
| 2009-07-01 | ABD-DELISTED | Stock | 2.86 | 3.0615 | 2.86 | 3.02 | 258770.0 |
| 2009-07-01 | ABE-DELISTED | Stock | 15.17 | 15.44 | 15.17 | 15.3 | 5600.0 |
| 2009-07-01 | ABEO | Stock | 2762.5 | 2812.5 | 2750.0 | 2812.5 | 12.0 |
| 2009-07-01 | ABFS-DELISTED | Stock | 26.63 | 28.19 | 26.55 | 27.83 | 610023.0 |
| 2009-07-01 | ABG | Stock | 10.24 | 10.49 | 9.93 | 10.17 | 443900.0 |
| 2009-07-01 | ABII-DELISTED | Stock | 37.04 | 39.9 | 36.0 | 37.59 | 126749.0 |
| 2009-07-01 | ABK-DELISTED | Stock | 0.94 | 0.95 | 0.92 | 0.92 | 2337340.0 |
| 2009-07-01 | ABM | Stock | 18.39 | 18.66 | 17.98 | 18.6 | 239400.0 |
| 2009-07-01 | ABMD-DELISTED | Stock | 8.87 | 9.025 | 8.76 | 8.82 | 330635.0 |
| 2009-07-01 | ABR | Stock | 1.8 | 2.02 | 1.76 | 1.91 | 605000.0 |
| 2009-07-01 | ABT | Stock | 22.5506 | 22.5938 | 22.3251 | 22.3779 | 17754273.0 |
| 2009-07-01 | ABTL-DELISTED | Stock | 2.15 | 2.175 | 2.05 | 2.1 | 14754.0 |
| 2009-07-01 | ABV-DELISTED | Stock | 65.91 | 65.99 | 64.58 | 65.04 | 702846.0 |
| 2009-07-01 | ABVT-DELISTED | Stock | 82.25 | 82.25 | 80.64 | 82.0 | 36914.0 |
| 2009-07-01 | ABX-DELISTED | Stock | 34.22 | 35.54 | 34.22 | 35.0 | 6302268.0 |
| 2009-07-01 | ACAD | Stock | 2.19 | 2.19 | 2.1 | 2.14 | 84300.0 |
| 2009-07-01 | ACAP-DELISTED | Stock | 39.54 | 40.8 | 39.38 | 40.27 | 55548.0 |
| 2009-07-01 | ACAS-DELISTED | Stock | 3.24 | 3.25 | 3.1 | 3.19 | 2881734.0 |
> showing 50 of 5,709 rows — these rows as CSV