PREVIEW / stock_daily / 2010-09-22
file: by_date/stock_daily/2010/2010-09-22.parquet size: 190 KB rows: 5,952 symbols: 3,498
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-22 | AAPL | Stock | 10.0968 | 10.285 | 10.0861 | 10.2768 | 585289600.0 |
| 2010-09-22 | MSFT | Stock | 24.89 | 24.97 | 24.36 | 24.61 | 94299400.0 |
| 2010-09-22 | NVDA | Stock | 0.2812 | 0.2872 | 0.2795 | 0.2848 | 999996000.0 |
| 2010-09-22 | AMZN | Stock | 7.492 | 7.635 | 7.455 | 7.5915 | 132248000.0 |
| 2010-09-22 | TSLA | Stock | 1.3913 | 1.3967 | 1.32 | 1.3247 | 14443500.0 |
| 2010-09-22 | TLT | Stock | 104.55 | 105.07 | 103.85 | 104.61 | 8229358.0 |
| 2010-09-22 | ES | Stock | 29.17 | 29.46 | 29.17 | 29.24 | 1633100.0 |
| 2010-09-22 | CL | Stock | 39.25 | 39.43 | 39.18 | 39.225 | 5327400.0 |
| 2010-09-22 | A | Stock | 22.1602 | 22.4177 | 21.9957 | 22.0029 | 5396560.0 |
| 2010-09-22 | AABA-DELISTED | Stock | 14.19 | 14.25 | 13.965 | 14.05 | 18338759.0 |
| 2010-09-22 | AACC-DELISTED | Stock | 4.43 | 4.56 | 4.3 | 4.56 | 29763.0 |
| 2010-09-22 | AACG | Stock | 2.91 | 2.95 | 2.9 | 2.9 | 14000.0 |
| 2010-09-22 | AAI-DELISTED | Stock | 4.45 | 4.48 | 4.33 | 4.4 | 1316285.0 |
| 2010-09-22 | AAIC-DELISTED | Stock | 23.9 | 23.92 | 23.3834 | 23.66 | 55530.0 |
| 2010-09-22 | AAME | Stock | 1.81 | 1.89 | 1.8 | 1.86 | 8800.0 |
| 2010-09-22 | AAON | Stock | 4.557 | 4.6262 | 4.4602 | 4.5314 | 254644.0 |
| 2010-09-22 | AAP | Stock | 58.24 | 59.89 | 58.04 | 59.81 | 1327200.0 |
| 2010-09-22 | AATI-DELISTED | Stock | 3.44 | 3.47 | 3.35 | 3.39 | 75413.0 |
| 2010-09-22 | AAU-DELISTED | Stock | 2.59 | 2.78 | 2.59 | 2.78 | 472392.0 |
| 2010-09-22 | AAUAF-DELISTED | Stock | 2.59 | 2.78 | 2.59 | 2.78 | 482492.0 |
| 2010-09-22 | AAV-DELISTED | Stock | 6.2 | 6.3 | 6.05 | 6.12 | 331415.0 |
| 2010-09-22 | AAWW-DELISTED | Stock | 53.47 | 55.55 | 53.37 | 55.43 | 622220.0 |
| 2010-09-22 | AAXJ | Stock | 59.17 | 59.47 | 59.0 | 59.17 | 189340.0 |
| 2010-09-22 | AAXN-DELISTED | Stock | 3.92 | 3.98 | 3.87 | 3.95 | 240556.0 |
| 2010-09-22 | AB | Stock | 26.14 | 26.26 | 25.62 | 25.8 | 146700.0 |
| 2010-09-22 | ABAC-DELISTED | Stock | 3.97 | 3.97 | 3.79 | 3.9 | 4823.0 |
| 2010-09-22 | ABAX-DELISTED | Stock | 22.03 | 22.17 | 21.51 | 21.68 | 64789.0 |
| 2010-09-22 | ABB-DELISTED | Stock | 21.16 | 21.21 | 20.86 | 20.89 | 1858222.0 |
| 2010-09-22 | ABBC-DELISTED | Stock | 10.41 | 10.47 | 10.36 | 10.38 | 40457.0 |
| 2010-09-22 | ABBNY-DELISTED | Stock | 21.16 | 21.21 | 20.86 | 20.91 | 1891807.0 |
| 2010-09-22 | ABC-DELISTED | Stock | 30.7 | 30.73 | 30.34 | 30.44 | 3845824.0 |
| 2010-09-22 | ABCB | Stock | 9.04 | 9.09 | 8.61 | 8.78 | 29200.0 |
| 2010-09-22 | ABCD-DELISTED | Stock | 3.23 | 3.31 | 3.17 | 3.2 | 13592.0 |
| 2010-09-22 | ABCO-DELISTED | Stock | 21.65 | 21.98 | 21.28 | 21.39 | 54000.0 |
| 2010-09-22 | ABCW-DELISTED | Stock | 0.6726 | 0.6924 | 0.633 | 0.68 | 120070.0 |
| 2010-09-22 | ABD-DELISTED | Stock | 6.06 | 6.06 | 5.74 | 5.83 | 328530.0 |
| 2010-09-22 | ABE-DELISTED | Stock | 17.89 | 18.1 | 17.89 | 17.98 | 3277.0 |
| 2010-09-22 | ABEO | Stock | 2687.5 | 2812.5 | 2637.5 | 2650.0 | 21.0 |
| 2010-09-22 | ABFS-DELISTED | Stock | 23.85 | 24.48 | 23.42 | 23.62 | 243886.0 |
| 2010-09-22 | ABG | Stock | 12.82 | 13.04 | 12.47 | 12.61 | 87200.0 |
| 2010-09-22 | ABII-DELISTED | Stock | 75.51 | 76.64 | 75.5 | 76.14 | 32501.0 |
| 2010-09-22 | ABK-DELISTED | Stock | 0.564 | 0.57 | 0.54 | 0.55 | 2695722.0 |
| 2010-09-22 | ABM | Stock | 21.71 | 21.95 | 21.68 | 21.79 | 254300.0 |
| 2010-09-22 | ABMD-DELISTED | Stock | 10.63 | 10.8 | 10.22 | 10.42 | 77419.0 |
| 2010-09-22 | ABR | Stock | 5.0 | 5.05 | 4.82 | 4.92 | 37600.0 |
| 2010-09-22 | ABT | Stock | 25.0504 | 25.1559 | 24.8824 | 24.9448 | 10671530.0 |
| 2010-09-22 | ABTL-DELISTED | Stock | 4.1965 | 4.1965 | 3.8636 | 4.1 | 13501.0 |
| 2010-09-22 | ABV-DELISTED | Stock | 120.27 | 121.62 | 120.22 | 120.7 | 678078.0 |
| 2010-09-22 | ABVA-DELISTED | Stock | 2.85 | 2.85 | 2.85 | 2.85 | 150.0 |
| 2010-09-22 | ABVT-DELISTED | Stock | 51.71 | 52.5599 | 51.71 | 52.21 | 141157.0 |
> showing 50 of 5,952 rows — these rows as CSV