PREVIEW / stock_daily / 2022-11-10
file: by_date/stock_daily/2022/2022-11-10.parquet size: 254 KB rows: 7,903 symbols: 2,147
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-11-10 | AAPL | Stock | 141.24 | 146.87 | 139.5 | 146.87 | 118854000.0 |
| 2022-11-10 | MSFT | Stock | 235.43 | 243.33 | 235.0 | 242.98 | 46268000.0 |
| 2022-11-10 | NVDA | Stock | 14.8 | 15.773 | 14.547 | 15.75 | 700819000.0 |
| 2022-11-10 | AMZN | Stock | 92.94 | 98.69 | 91.65 | 96.63 | 173414900.0 |
| 2022-11-10 | GOOGL | Stock | 92.25 | 94.39 | 91.61 | 93.94 | 51620136.0 |
| 2022-11-10 | META | Stock | 107.12 | 112.75 | 104.61 | 111.87 | 80671000.0 |
| 2022-11-10 | TSLA | Stock | 189.9 | 191.0 | 180.03 | 190.72 | 132703000.0 |
| 2022-11-10 | TLT | Stock | 96.725 | 98.43 | 96.64 | 98.25 | 45380877.0 |
| 2022-11-10 | ES | Stock | 77.14 | 79.26 | 76.15 | 79.12 | 1819000.0 |
| 2022-11-10 | CL | Stock | 74.78 | 75.11 | 73.79 | 74.97 | 3828200.0 |
| 2022-11-10 | A | Stock | 142.87 | 146.72 | 142.53 | 146.3 | 1591900.0 |
| 2022-11-10 | AA | Stock | 42.81 | 45.49 | 42.81 | 43.83 | 8201900.0 |
| 2022-11-10 | AAC-DELISTED | Stock | 10.0 | 10.0 | 9.99 | 9.99 | 8899.0 |
| 2022-11-10 | AACG | Stock | 1.72 | 1.87 | 1.72 | 1.83 | 5100.0 |
| 2022-11-10 | AACIW-DELISTED | Stock | 0.03 | 0.0361 | 0.03 | 0.0305 | 18700.0 |
| 2022-11-10 | AAIC-DELISTED | Stock | 3.1098 | 3.2 | 3.1098 | 3.14 | 110456.0 |
| 2022-11-10 | AAIC.C-DELISTED | Stock | 21.25 | 21.25 | 21.015 | 21.1275 | 775.0 |
| 2022-11-10 | AAL | Stock | 14.46 | 14.99 | 14.36 | 14.93 | 35599100.0 |
| 2022-11-10 | AAM.A-DELISTED | Stock | 22.3 | 23.16 | 22.3 | 23.13 | 16642.0 |
| 2022-11-10 | AAM.B-DELISTED | Stock | 22.18 | 23.24 | 22.0101 | 23.24 | 8112.0 |
| 2022-11-10 | AAMC-DELISTED | Stock | 5.0882 | 5.6 | 4.9176 | 5.6 | 8014.0 |
| 2022-11-10 | AAME | Stock | 2.86 | 3.03 | 2.86 | 3.02 | 1800.0 |
| 2022-11-10 | AAMI | Stock | 19.28 | 20.83 | 19.28 | 20.78 | 341400.0 |
| 2022-11-10 | AAN-DELISTED | Stock | 10.59 | 11.16 | 10.55 | 11.05 | 368200.0 |
| 2022-11-10 | AAOI | Stock | 2.23 | 2.24 | 2.07 | 2.205 | 248800.0 |
| 2022-11-10 | AAON | Stock | 51.8067 | 52.7333 | 50.5733 | 52.34 | 530850.0 |
| 2022-11-10 | AAP | Stock | 180.8 | 185.27 | 180.8 | 183.53 | 1009500.0 |
| 2022-11-10 | AAQC-DELISTED | Stock | 9.92 | 9.93 | 9.905 | 9.91 | 312042.0 |
| 2022-11-10 | AAT | Stock | 28.2 | 28.93 | 28.2 | 28.91 | 420700.0 |
| 2022-11-10 | AATC | Stock | 4.21 | 4.2799 | 4.13 | 4.19 | 5527.0 |
| 2022-11-10 | AAU-DELISTED | Stock | 0.2488 | 0.2638 | 0.2437 | 0.263 | 598880.0 |
| 2022-11-10 | AAUAF-DELISTED | Stock | 0.2488 | 0.2638 | 0.2437 | 0.2602 | 610610.0 |
| 2022-11-10 | AAWW-DELISTED | Stock | 100.22 | 100.4 | 100.02 | 100.16 | 321127.0 |
| 2022-11-10 | AAXJ | Stock | 60.72 | 61.56 | 60.62 | 61.56 | 4618754.0 |
| 2022-11-10 | AB | Stock | 36.78 | 37.5 | 36.78 | 37.4 | 583800.0 |
| 2022-11-10 | ABB-DELISTED | Stock | 30.3 | 30.58 | 30.08 | 30.565 | 1444970.0 |
| 2022-11-10 | ABBNY-DELISTED | Stock | 30.3 | 30.58 | 30.08 | 30.56 | 1621707.0 |
| 2022-11-10 | ABBV | Stock | 150.66 | 150.66 | 147.75 | 149.72 | 5607700.0 |
| 2022-11-10 | ABC-DELISTED | Stock | 161.2 | 161.34 | 153.78 | 155.14 | 2974149.0 |
| 2022-11-10 | ABCB | Stock | 52.71 | 53.93 | 52.47 | 53.76 | 521200.0 |
| 2022-11-10 | ABCL | Stock | 12.41 | 12.93 | 11.89 | 12.91 | 2506600.0 |
| 2022-11-10 | ABCM-DELISTED | Stock | 15.89 | 16.48 | 15.8 | 16.33 | 552577.0 |
| 2022-11-10 | ABEO | Stock | 4.18 | 4.37 | 3.92 | 4.19 | 682800.0 |
| 2022-11-10 | ABEV | Stock | 3.01 | 3.03 | 2.91 | 2.93 | 53025200.0 |
| 2022-11-10 | ABG | Stock | 166.83 | 178.64 | 166.41 | 175.8 | 222000.0 |
| 2022-11-10 | ABGI-DELISTED | Stock | 9.99 | 9.99 | 9.99 | 9.99 | 3400.0 |
| 2022-11-10 | ABM | Stock | 44.81 | 45.94 | 44.45 | 45.9 | 221500.0 |
| 2022-11-10 | ABMD-DELISTED | Stock | 374.72 | 377.31 | 372.51 | 372.63 | 2268859.0 |
| 2022-11-10 | ABNB | Stock | 100.91 | 102.5 | 99.04 | 102.4 | 7343000.0 |
| 2022-11-10 | ABOS | Stock | 6.44 | 6.59 | 6.31 | 6.48 | 123600.0 |
> showing 50 of 7,903 rows — these rows as CSV