PREVIEW / stock_daily / 2010-11-12
file: by_date/stock_daily/2010/2010-11-12.parquet size: 194 KB rows: 5,986 symbols: 3,506
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-11-12 | AAPL | Stock | 11.2857 | 11.3036 | 10.8439 | 11.0011 | 795846800.0 |
| 2010-11-12 | MSFT | Stock | 26.47 | 26.52 | 26.1 | 26.27 | 64962200.0 |
| 2010-11-12 | NVDA | Stock | 0.3273 | 0.342 | 0.3258 | 0.3315 | 2142560000.0 |
| 2010-11-12 | AMZN | Stock | 8.506 | 8.563 | 8.2525 | 8.284 | 143212000.0 |
| 2010-11-12 | TSLA | Stock | 1.8833 | 2.0333 | 1.8713 | 1.9893 | 40936500.0 |
| 2010-11-12 | TLT | Stock | 96.21 | 96.74 | 95.81 | 95.81 | 11739584.0 |
| 2010-11-12 | ES | Stock | 31.29 | 31.36 | 31.07 | 31.29 | 1451200.0 |
| 2010-11-12 | CL | Stock | 38.15 | 38.41 | 38.13 | 38.29 | 4214200.0 |
| 2010-11-12 | A | Stock | 25.6795 | 26.8598 | 25.4006 | 26.0086 | 9890570.0 |
| 2010-11-12 | AABA-DELISTED | Stock | 16.7 | 16.75 | 16.4 | 16.55 | 17082376.0 |
| 2010-11-12 | AACC-DELISTED | Stock | 5.34 | 5.36 | 5.19 | 5.27 | 15610.0 |
| 2010-11-12 | AACG | Stock | 4.01 | 4.01 | 3.95 | 4.0 | 4800.0 |
| 2010-11-12 | AAI-DELISTED | Stock | 7.41 | 7.46 | 7.4 | 7.42 | 2363351.0 |
| 2010-11-12 | AAIC-DELISTED | Stock | 24.4 | 24.4 | 23.57 | 23.7 | 41328.0 |
| 2010-11-12 | AAME | Stock | 1.95 | 1.95 | 1.85 | 1.89 | 5000.0 |
| 2010-11-12 | AAON | Stock | 4.9165 | 5.041 | 4.9165 | 4.9422 | 168581.0 |
| 2010-11-12 | AAP | Stock | 66.09 | 66.31 | 64.38 | 64.53 | 1218100.0 |
| 2010-11-12 | AATI-DELISTED | Stock | 3.61 | 3.72 | 3.49 | 3.52 | 174614.0 |
| 2010-11-12 | AAU-DELISTED | Stock | 2.8 | 2.82 | 2.59 | 2.72 | 428815.0 |
| 2010-11-12 | AAUAF-DELISTED | Stock | 2.8 | 2.82 | 2.59 | 2.7 | 429115.0 |
| 2010-11-12 | AAV-DELISTED | Stock | 6.52 | 6.68 | 6.48 | 6.62 | 373693.0 |
| 2010-11-12 | AAWW-DELISTED | Stock | 59.3 | 59.32 | 57.37 | 57.49 | 130783.0 |
| 2010-11-12 | AAXJ | Stock | 63.76 | 63.91 | 62.82 | 63.28 | 505366.0 |
| 2010-11-12 | AAXN-DELISTED | Stock | 4.0 | 4.07 | 3.91 | 3.92 | 276925.0 |
| 2010-11-12 | AB | Stock | 24.18 | 24.63 | 23.8 | 24.52 | 633000.0 |
| 2010-11-12 | ABAC-DELISTED | Stock | 7.99 | 8.15 | 7.03 | 7.1001 | 257588.0 |
| 2010-11-12 | ABAX-DELISTED | Stock | 25.7 | 26.22 | 25.5101 | 25.59 | 75750.0 |
| 2010-11-12 | ABB-DELISTED | Stock | 20.79 | 20.89 | 20.47 | 20.59 | 2161491.0 |
| 2010-11-12 | ABBC-DELISTED | Stock | 11.97 | 12.0 | 11.92 | 11.93 | 37068.0 |
| 2010-11-12 | ABBNY-DELISTED | Stock | 20.79 | 20.89 | 20.47 | 20.59 | 2180268.0 |
| 2010-11-12 | ABC-DELISTED | Stock | 31.51 | 31.57 | 31.19 | 31.32 | 1713267.0 |
| 2010-11-12 | ABCB | Stock | 9.4 | 9.55 | 9.3 | 9.35 | 34600.0 |
| 2010-11-12 | ABCD-DELISTED | Stock | 3.08 | 3.08 | 3.01 | 3.02 | 14506.0 |
| 2010-11-12 | ABCO-DELISTED | Stock | 23.87 | 24.25 | 23.64 | 24.06 | 61646.0 |
| 2010-11-12 | ABCW-DELISTED | Stock | 0.7399 | 0.7584 | 0.6905 | 0.73 | 137650.0 |
| 2010-11-12 | ABD-DELISTED | Stock | 7.29 | 7.36 | 7.07 | 7.13 | 449350.0 |
| 2010-11-12 | ABE-DELISTED | Stock | 18.91 | 18.92 | 18.36 | 18.63 | 14301.0 |
| 2010-11-12 | ABEO | Stock | 3875.0 | 3875.0 | 3737.5 | 3812.5 | 11.0 |
| 2010-11-12 | ABFS-DELISTED | Stock | 24.39 | 24.5 | 24.04 | 24.22 | 161697.0 |
| 2010-11-12 | ABG | Stock | 15.71 | 15.92 | 15.47 | 15.62 | 224300.0 |
| 2010-11-12 | ABM | Stock | 23.76 | 24.16 | 23.51 | 23.74 | 108900.0 |
| 2010-11-12 | ABMD-DELISTED | Stock | 11.81 | 11.95 | 11.77 | 11.84 | 61654.0 |
| 2010-11-12 | ABR | Stock | 5.5 | 5.55 | 5.25 | 5.41 | 56600.0 |
| 2010-11-12 | ABT | Stock | 23.7789 | 23.7981 | 23.2607 | 23.3087 | 27260317.0 |
| 2010-11-12 | ABTL-DELISTED | Stock | 4.2 | 4.3 | 4.0 | 4.0 | 135681.0 |
| 2010-11-12 | ABV-DELISTED | Stock | 137.09 | 139.66 | 136.08 | 137.03 | 737131.0 |
| 2010-11-12 | ABVT-DELISTED | Stock | 62.91 | 63.15 | 61.28 | 62.07 | 276807.0 |
| 2010-11-12 | ABX-DELISTED | Stock | 50.91 | 51.8 | 50.22 | 50.73 | 9802161.0 |
| 2010-11-12 | ACAD | Stock | 0.68 | 0.69 | 0.65 | 0.66 | 879400.0 |
| 2010-11-12 | ACAS-DELISTED | Stock | 7.27 | 7.35 | 6.94 | 7.11 | 4950796.0 |
> showing 50 of 5,986 rows — these rows as CSV