PREVIEW / stock_daily / 2010-09-13
file: by_date/stock_daily/2010/2010-09-13.parquet size: 191 KB rows: 5,994 symbols: 3,514
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-09-13 | AAPL | Stock | 9.4936 | 9.5814 | 9.4914 | 9.5371 | 388780000.0 |
| 2010-09-13 | MSFT | Stock | 24.2 | 25.29 | 24.09 | 25.11 | 114680400.0 |
| 2010-09-13 | NVDA | Stock | 0.2563 | 0.2692 | 0.2563 | 0.266 | 1015792000.0 |
| 2010-09-13 | AMZN | Stock | 7.2035 | 7.287 | 7.188 | 7.2535 | 101548000.0 |
| 2010-09-13 | TSLA | Stock | 1.3927 | 1.3933 | 1.3667 | 1.3813 | 5412000.0 |
| 2010-09-13 | TLT | Stock | 101.8 | 103.05 | 101.77 | 102.825 | 7055086.0 |
| 2010-09-13 | ES | Stock | 29.68 | 29.9 | 29.42 | 29.84 | 1370500.0 |
| 2010-09-13 | CL | Stock | 37.75 | 37.795 | 37.45 | 37.525 | 4388000.0 |
| 2010-09-13 | A | Stock | 20.9084 | 21.073 | 20.7082 | 20.8369 | 4135424.0 |
| 2010-09-13 | AABA-DELISTED | Stock | 13.86 | 13.88 | 13.61 | 13.75 | 24002458.0 |
| 2010-09-13 | AACC-DELISTED | Stock | 3.75 | 3.88 | 3.69 | 3.83 | 23969.0 |
| 2010-09-13 | AACG | Stock | 2.9 | 3.09 | 2.85 | 2.85 | 63300.0 |
| 2010-09-13 | AAI-DELISTED | Stock | 4.3 | 4.35 | 4.27 | 4.29 | 1276816.0 |
| 2010-09-13 | AAIC-DELISTED | Stock | 21.97 | 22.53 | 21.82 | 22.5 | 54245.0 |
| 2010-09-13 | AAME | Stock | 1.5 | 1.51 | 1.48 | 1.51 | 5800.0 |
| 2010-09-13 | AAON | Stock | 4.4919 | 4.6005 | 4.4879 | 4.5906 | 194400.0 |
| 2010-09-13 | AAP | Stock | 56.7 | 57.02 | 56.37 | 56.56 | 827300.0 |
| 2010-09-13 | AATI-DELISTED | Stock | 3.38 | 3.48 | 3.2519 | 3.43 | 155933.0 |
| 2010-09-13 | AAU-DELISTED | Stock | 2.58 | 2.7 | 2.471 | 2.54 | 423908.0 |
| 2010-09-13 | AAUAF-DELISTED | Stock | 2.61 | 2.73 | 2.5 | 2.54 | 421371.0 |
| 2010-09-13 | AAV-DELISTED | Stock | 6.26 | 6.41 | 6.25 | 6.41 | 320162.0 |
| 2010-09-13 | AAWW-DELISTED | Stock | 46.67 | 48.12 | 45.61 | 47.97 | 220261.0 |
| 2010-09-13 | AAXJ | Stock | 58.0 | 58.39 | 58.0 | 58.34 | 643180.0 |
| 2010-09-13 | AAXN-DELISTED | Stock | 3.96 | 4.06 | 3.93 | 4.05 | 300711.0 |
| 2010-09-13 | AB | Stock | 25.72 | 26.25 | 25.69 | 26.09 | 369100.0 |
| 2010-09-13 | ABAC-DELISTED | Stock | 3.95 | 4.11 | 3.88 | 4.06 | 47342.0 |
| 2010-09-13 | ABAX-DELISTED | Stock | 19.45 | 20.0 | 19.2 | 19.92 | 80982.0 |
| 2010-09-13 | ABB-DELISTED | Stock | 20.41 | 20.53 | 20.36 | 20.48 | 2007034.0 |
| 2010-09-13 | ABBC-DELISTED | Stock | 10.45 | 10.5 | 10.4 | 10.49 | 71671.0 |
| 2010-09-13 | ABBNY-DELISTED | Stock | 20.41 | 20.53 | 20.36 | 20.46 | 2059348.0 |
| 2010-09-13 | ABC-DELISTED | Stock | 28.7 | 28.79 | 28.38 | 28.52 | 1713673.0 |
| 2010-09-13 | ABCB | Stock | 8.46 | 8.7 | 8.29 | 8.57 | 175500.0 |
| 2010-09-13 | ABCD-DELISTED | Stock | 3.04 | 3.15 | 3.0 | 3.1 | 27355.0 |
| 2010-09-13 | ABCO-DELISTED | Stock | 21.52 | 21.95 | 21.52 | 21.87 | 109269.0 |
| 2010-09-13 | ABCW-DELISTED | Stock | 0.7 | 0.73 | 0.68 | 0.68 | 57830.0 |
| 2010-09-13 | ABD-DELISTED | Stock | 6.19 | 6.4679 | 6.09 | 6.43 | 305270.0 |
| 2010-09-13 | ABE-DELISTED | Stock | 17.69 | 17.8299 | 17.61 | 17.8 | 14385.0 |
| 2010-09-13 | ABEO | Stock | 2437.5 | 2437.5 | 2387.5 | 2437.5 | 12.0 |
| 2010-09-13 | ABFS-DELISTED | Stock | 22.54 | 23.47 | 22.54 | 23.35 | 405359.0 |
| 2010-09-13 | ABG | Stock | 12.98 | 13.08 | 12.73 | 12.82 | 250700.0 |
| 2010-09-13 | ABII-DELISTED | Stock | 74.64 | 75.18 | 74.64 | 74.9 | 30019.0 |
| 2010-09-13 | ABK-DELISTED | Stock | 0.53 | 0.54 | 0.5123 | 0.5226 | 6127014.0 |
| 2010-09-13 | ABM | Stock | 21.75 | 22.01 | 21.69 | 21.95 | 187100.0 |
| 2010-09-13 | ABMD-DELISTED | Stock | 9.96 | 10.01 | 9.78 | 9.96 | 108637.0 |
| 2010-09-13 | ABR | Stock | 4.62 | 4.71 | 4.59 | 4.63 | 29500.0 |
| 2010-09-13 | ABT | Stock | 24.8488 | 24.8488 | 24.5802 | 24.6857 | 10166945.0 |
| 2010-09-13 | ABTL-DELISTED | Stock | 4.2 | 4.2 | 3.85 | 4.0 | 18345.0 |
| 2010-09-13 | ABV-DELISTED | Stock | 115.84 | 116.76 | 115.51 | 115.95 | 669143.0 |
| 2010-09-13 | ABVT-DELISTED | Stock | 52.08 | 52.74 | 51.85 | 52.4 | 183157.0 |
| 2010-09-13 | ABX-DELISTED | Stock | 44.65 | 44.95 | 44.09 | 44.24 | 5661098.0 |
> showing 50 of 5,994 rows — these rows as CSV