PREVIEW / stock_daily / 2010-08-25
file: by_date/stock_daily/2010/2010-08-25.parquet size: 189 KB rows: 5,957 symbols: 3,493
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-25 | AAPL | Stock | 8.5014 | 8.7139 | 8.4714 | 8.6746 | 596867600.0 |
| 2010-08-25 | MSFT | Stock | 24.0 | 24.22 | 23.87 | 24.1 | 47404800.0 |
| 2010-08-25 | NVDA | Stock | 0.2402 | 0.25 | 0.239 | 0.248 | 757532000.0 |
| 2010-08-25 | AMZN | Stock | 6.1925 | 6.3685 | 6.1915 | 6.3425 | 106890000.0 |
| 2010-08-25 | TSLA | Stock | 1.2773 | 1.332 | 1.2373 | 1.3267 | 7549500.0 |
| 2010-08-25 | TLT | Stock | 108.8 | 109.34 | 107.07 | 107.41 | 13305263.0 |
| 2010-08-25 | ES | Stock | 28.67 | 28.98 | 28.53 | 28.9 | 1377100.0 |
| 2010-08-25 | CL | Stock | 37.515 | 37.785 | 37.46 | 37.64 | 4848600.0 |
| 2010-08-25 | A | Stock | 19.4134 | 19.907 | 19.0844 | 19.8069 | 6108701.0 |
| 2010-08-25 | AABA-DELISTED | Stock | 13.29 | 13.37 | 13.14 | 13.25 | 15450459.0 |
| 2010-08-25 | AACC-DELISTED | Stock | 3.8 | 4.12 | 3.78 | 4.06 | 25846.0 |
| 2010-08-25 | AACG | Stock | 2.95 | 2.95 | 2.85 | 2.85 | 104800.0 |
| 2010-08-25 | AAI-DELISTED | Stock | 4.4 | 4.52 | 4.34 | 4.52 | 1646747.0 |
| 2010-08-25 | AAIC-DELISTED | Stock | 19.44 | 19.52 | 19.28 | 19.44 | 64731.0 |
| 2010-08-25 | AAME | Stock | 1.16 | 1.26 | 1.16 | 1.26 | 23400.0 |
| 2010-08-25 | AAON | Stock | 4.0514 | 4.1679 | 3.9921 | 4.162 | 182756.0 |
| 2010-08-25 | AAP | Stock | 53.88 | 55.15 | 53.88 | 54.86 | 1099600.0 |
| 2010-08-25 | AATI-DELISTED | Stock | 3.35 | 3.45 | 3.31 | 3.44 | 51905.0 |
| 2010-08-25 | AAU-DELISTED | Stock | 2.1 | 2.26 | 2.09 | 2.12 | 634525.0 |
| 2010-08-25 | AAUAF-DELISTED | Stock | 2.1 | 2.26 | 2.09 | 2.12 | 635025.0 |
| 2010-08-25 | AAV-DELISTED | Stock | 5.7 | 5.86 | 5.65 | 5.83 | 365092.0 |
| 2010-08-25 | AAWW-DELISTED | Stock | 42.72 | 44.28 | 41.61 | 43.94 | 585309.0 |
| 2010-08-25 | AAXJ | Stock | 54.16 | 54.68 | 53.8 | 54.51 | 429662.0 |
| 2010-08-25 | AAXN-DELISTED | Stock | 3.6 | 3.65 | 3.52 | 3.62 | 642237.0 |
| 2010-08-25 | AB | Stock | 24.35 | 24.42 | 23.9 | 24.28 | 483500.0 |
| 2010-08-25 | ABAC-DELISTED | Stock | 3.75 | 3.76 | 3.65 | 3.7 | 22550.0 |
| 2010-08-25 | ABAX-DELISTED | Stock | 18.63 | 18.81 | 18.45 | 18.74 | 73387.0 |
| 2010-08-25 | ABB-DELISTED | Stock | 18.59 | 18.88 | 18.53 | 18.83 | 1899433.0 |
| 2010-08-25 | ABBC-DELISTED | Stock | 9.86 | 10.02 | 9.85 | 9.99 | 44298.0 |
| 2010-08-25 | ABBNY-DELISTED | Stock | 18.59 | 18.88 | 18.53 | 18.84 | 1914550.0 |
| 2010-08-25 | ABC-DELISTED | Stock | 27.7 | 28.07 | 27.5 | 27.92 | 2870656.0 |
| 2010-08-25 | ABCB | Stock | 7.88 | 8.08 | 7.86 | 8.05 | 89100.0 |
| 2010-08-25 | ABCD-DELISTED | Stock | 2.89 | 3.1 | 2.86 | 3.1 | 23645.0 |
| 2010-08-25 | ABCO-DELISTED | Stock | 20.04 | 20.33 | 20.0 | 20.32 | 249434.0 |
| 2010-08-25 | ABCW-DELISTED | Stock | 0.65 | 0.65 | 0.62 | 0.63 | 134070.0 |
| 2010-08-25 | ABD-DELISTED | Stock | 5.37 | 5.6509 | 5.26 | 5.62 | 395540.0 |
| 2010-08-25 | ABE-DELISTED | Stock | 16.88 | 16.99 | 16.77 | 16.92 | 12025.0 |
| 2010-08-25 | ABEO | Stock | 2600.0 | 2625.0 | 2250.0 | 2625.0 | 20.0 |
| 2010-08-25 | ABFS-DELISTED | Stock | 19.54 | 20.47 | 19.41 | 20.32 | 313524.0 |
| 2010-08-25 | ABG | Stock | 11.91 | 12.17 | 11.59 | 12.11 | 280500.0 |
| 2010-08-25 | ABII-DELISTED | Stock | 73.9 | 74.29 | 73.9 | 74.24 | 41760.0 |
| 2010-08-25 | ABK-DELISTED | Stock | 0.4795 | 0.55 | 0.4581 | 0.54 | 10496365.0 |
| 2010-08-25 | ABM | Stock | 18.72 | 19.43 | 18.56 | 19.38 | 238600.0 |
| 2010-08-25 | ABMD-DELISTED | Stock | 8.77 | 9.04 | 8.72 | 9.01 | 173342.0 |
| 2010-08-25 | ABR | Stock | 4.74 | 4.74 | 4.53 | 4.62 | 47900.0 |
| 2010-08-25 | ABT | Stock | 23.5966 | 24.014 | 23.5822 | 23.9036 | 15743018.0 |
| 2010-08-25 | ABTL-DELISTED | Stock | 4.3544 | 4.5511 | 3.8482 | 4.45 | 29231.0 |
| 2010-08-25 | ABV-DELISTED | Stock | 107.73 | 107.74 | 105.1 | 107.27 | 662659.0 |
| 2010-08-25 | ABVA-DELISTED | Stock | 3.0 | 3.0001 | 2.95 | 3.0 | 4460.0 |
| 2010-08-25 | ABVT-DELISTED | Stock | 49.33 | 49.55 | 48.19 | 49.39 | 55078.0 |
> showing 50 of 5,957 rows — these rows as CSV