PREVIEW / stock_daily / 2022-10-12
file: by_date/stock_daily/2022/2022-10-12.parquet size: 250 KB rows: 7,853 symbols: 2,146
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 |
|---|---|---|---|---|---|---|---|
| 2022-10-12 | AAPL | Stock | 139.13 | 140.36 | 138.16 | 138.34 | 70433700.0 |
| 2022-10-12 | MSFT | Stock | 225.4 | 227.86 | 223.96 | 225.75 | 21903900.0 |
| 2022-10-12 | NVDA | Stock | 11.579 | 11.735 | 11.345 | 11.5 | 492590000.0 |
| 2022-10-12 | AMZN | Stock | 112.49 | 113.83 | 111.4 | 112.9 | 45728700.0 |
| 2022-10-12 | GOOGL | Stock | 97.3 | 98.75 | 96.735 | 97.56 | 21876362.0 |
| 2022-10-12 | META | Stock | 128.32 | 129.67 | 126.25 | 127.5 | 34605200.0 |
| 2022-10-12 | TSLA | Stock | 215.33 | 219.3 | 211.51 | 217.24 | 66860700.0 |
| 2022-10-12 | TLT | Stock | 99.275 | 100.535 | 99.19 | 100.35 | 21447565.0 |
| 2022-10-12 | ES | Stock | 74.24 | 74.3 | 71.72 | 71.77 | 1964300.0 |
| 2022-10-12 | CL | Stock | 69.23 | 69.81 | 69.07 | 69.11 | 2819400.0 |
| 2022-10-12 | A | Stock | 126.2 | 127.1 | 125.27 | 125.69 | 1069600.0 |
| 2022-10-12 | AA | Stock | 37.78 | 41.11 | 36.58 | 39.86 | 17974200.0 |
| 2022-10-12 | AAC-DELISTED | Stock | 9.94 | 9.96 | 9.94 | 9.96 | 12411.0 |
| 2022-10-12 | AACG | Stock | 1.89 | 1.89 | 1.86 | 1.87 | 9100.0 |
| 2022-10-12 | AAIC-DELISTED | Stock | 2.79 | 2.8499 | 2.78 | 2.82 | 16891.0 |
| 2022-10-12 | AAIC.C-DELISTED | Stock | 20.34 | 20.34 | 19.3517 | 19.3517 | 3342.0 |
| 2022-10-12 | AAL | Stock | 12.21 | 12.83 | 11.98 | 12.7 | 40359200.0 |
| 2022-10-12 | AAM.A-DELISTED | Stock | 23.07 | 23.15 | 22.69 | 22.69 | 14993.0 |
| 2022-10-12 | AAM.B-DELISTED | Stock | 22.85 | 23.35 | 22.5 | 22.67 | 27060.0 |
| 2022-10-12 | AAME | Stock | 2.75 | 2.8 | 2.75 | 2.75 | 3300.0 |
| 2022-10-12 | AAMI | Stock | 17.32 | 17.51 | 16.96 | 17.43 | 237500.0 |
| 2022-10-12 | AAN-DELISTED | Stock | 8.96 | 9.14 | 8.8 | 9.11 | 421700.0 |
| 2022-10-12 | AAOI | Stock | 2.62 | 2.7 | 2.59 | 2.63 | 154800.0 |
| 2022-10-12 | AAON | Stock | 36.7467 | 36.8267 | 35.6 | 35.82 | 202800.0 |
| 2022-10-12 | AAP | Stock | 169.28 | 170.79 | 167.52 | 169.32 | 662900.0 |
| 2022-10-12 | AAQC-DELISTED | Stock | 9.84 | 9.87 | 9.83 | 9.86 | 221354.0 |
| 2022-10-12 | AAT | Stock | 25.28 | 25.42 | 24.95 | 25.15 | 283700.0 |
| 2022-10-12 | AATC | Stock | 4.4 | 4.445 | 4.33 | 4.33 | 6777.0 |
| 2022-10-12 | AAU-DELISTED | Stock | 0.23 | 0.2398 | 0.2251 | 0.237 | 165630.0 |
| 2022-10-12 | AAUAF-DELISTED | Stock | 0.23 | 0.2398 | 0.2251 | 0.237 | 168494.0 |
| 2022-10-12 | AAWW-DELISTED | Stock | 98.66 | 99.25 | 98.61 | 99.01 | 230963.0 |
| 2022-10-12 | AAXJ | Stock | 57.47 | 57.88 | 57.33 | 57.58 | 1016142.0 |
| 2022-10-12 | AB | Stock | 33.11 | 33.23 | 31.49 | 32.31 | 783100.0 |
| 2022-10-12 | ABB-DELISTED | Stock | 24.97 | 25.06 | 24.83 | 24.87 | 1884652.0 |
| 2022-10-12 | ABBNY-DELISTED | Stock | 24.97 | 25.06 | 24.83 | 24.86 | 2028577.0 |
| 2022-10-12 | ABBV | Stock | 141.64 | 143.06 | 139.93 | 139.98 | 4528000.0 |
| 2022-10-12 | ABC-DELISTED | Stock | 142.74 | 143.29 | 138.84 | 138.9 | 981262.0 |
| 2022-10-12 | ABCB | Stock | 47.97 | 48.56 | 47.4 | 47.89 | 304500.0 |
| 2022-10-12 | ABCL | Stock | 10.98 | 10.99 | 10.35 | 10.64 | 1141400.0 |
| 2022-10-12 | ABCM-DELISTED | Stock | 14.57 | 14.81 | 14.53 | 14.81 | 106523.0 |
| 2022-10-12 | ABEO | Stock | 5.63 | 5.74 | 4.68 | 5.6 | 870600.0 |
| 2022-10-12 | ABEV | Stock | 2.8 | 2.81 | 2.75 | 2.79 | 12448500.0 |
| 2022-10-12 | ABG | Stock | 157.9 | 159.6 | 154.92 | 156.1 | 112100.0 |
| 2022-10-12 | ABM | Stock | 41.37 | 41.37 | 40.12 | 40.14 | 268400.0 |
| 2022-10-12 | ABMD-DELISTED | Stock | 244.6 | 244.6 | 237.44 | 242.85 | 172121.0 |
| 2022-10-12 | ABNB | Stock | 107.47 | 112.98 | 106.11 | 112.35 | 5547500.0 |
| 2022-10-12 | ABOS | Stock | 9.05 | 9.29 | 8.03 | 8.1 | 473100.0 |
| 2022-10-12 | ABR | Stock | 12.29 | 12.4 | 11.88 | 12.24 | 2562500.0 |
| 2022-10-12 | ABR.D | Stock | 18.92 | 18.9499 | 18.66 | 18.67 | 22575.0 |
| 2022-10-12 | ABR.E | Stock | 18.85 | 18.85 | 18.26 | 18.4 | 1938.0 |
> showing 50 of 7,853 rows — these rows as CSV