PREVIEW / stock_daily / 2022-11-11
file: by_date/stock_daily/2022/2022-11-11.parquet size: 251 KB rows: 7,789 symbols: 2,066
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-11 | AAPL | Stock | 145.82 | 150.01 | 144.37 | 149.7 | 93979700.0 |
| 2022-11-11 | MSFT | Stock | 242.99 | 247.99 | 241.93 | 247.11 | 34620200.0 |
| 2022-11-11 | NVDA | Stock | 15.807 | 16.389 | 15.482 | 16.327 | 655487000.0 |
| 2022-11-11 | AMZN | Stock | 97.88 | 101.19 | 96.66 | 100.79 | 111590500.0 |
| 2022-11-11 | GOOGL | Stock | 94.69 | 96.93 | 93.92 | 96.41 | 33090482.0 |
| 2022-11-11 | META | Stock | 109.23 | 114.9 | 108.81 | 113.02 | 59961700.0 |
| 2022-11-11 | TSLA | Stock | 186.0 | 196.52 | 182.59 | 195.97 | 114403600.0 |
| 2022-11-11 | TLT | Stock | 97.57 | 98.37 | 97.54 | 97.89 | 15943114.0 |
| 2022-11-11 | ES | Stock | 78.97 | 79.02 | 77.32 | 78.09 | 1569900.0 |
| 2022-11-11 | CL | Stock | 74.87 | 75.38 | 73.64 | 74.57 | 3160000.0 |
| 2022-11-11 | A | Stock | 147.12 | 149.74 | 146.35 | 148.31 | 1227500.0 |
| 2022-11-11 | AA | Stock | 45.26 | 50.76 | 45.04 | 47.66 | 18068200.0 |
| 2022-11-11 | AAC-DELISTED | Stock | 9.99 | 10.0 | 9.985 | 9.995 | 26888.0 |
| 2022-11-11 | AACG | Stock | 1.83 | 1.84 | 1.66 | 1.79 | 24500.0 |
| 2022-11-11 | AACIW-DELISTED | Stock | 0.1452 | 0.1452 | 0.055 | 0.055 | 7982.0 |
| 2022-11-11 | AAIC-DELISTED | Stock | 3.1 | 3.191 | 3.1 | 3.16 | 154697.0 |
| 2022-11-11 | AAIC.C-DELISTED | Stock | 20.95 | 20.95 | 20.95 | 20.95 | 250.0 |
| 2022-11-11 | AAL | Stock | 15.0 | 15.08 | 14.72 | 14.88 | 24134000.0 |
| 2022-11-11 | AAM.A-DELISTED | Stock | 22.89 | 23.9088 | 22.89 | 23.75 | 17496.0 |
| 2022-11-11 | AAM.B-DELISTED | Stock | 23.05 | 24.2034 | 23.05 | 23.94 | 10381.0 |
| 2022-11-11 | AAMC-DELISTED | Stock | 5.5324 | 6.0 | 5.4471 | 5.4471 | 30029.0 |
| 2022-11-11 | AAME | Stock | 2.92 | 3.06 | 2.92 | 3.06 | 3000.0 |
| 2022-11-11 | AAMI | Stock | 20.81 | 21.08 | 19.93 | 19.99 | 300900.0 |
| 2022-11-11 | AAN-DELISTED | Stock | 10.97 | 11.595 | 10.97 | 11.44 | 385900.0 |
| 2022-11-11 | AAOI | Stock | 2.24 | 2.33 | 2.17 | 2.33 | 201600.0 |
| 2022-11-11 | AAON | Stock | 52.1267 | 53.3667 | 51.9467 | 52.0133 | 375300.0 |
| 2022-11-11 | AAP | Stock | 183.29 | 187.58 | 180.4 | 186.39 | 765200.0 |
| 2022-11-11 | AAQC-DELISTED | Stock | 9.91 | 9.92 | 9.9 | 9.9 | 362861.0 |
| 2022-11-11 | AAT | Stock | 28.9 | 29.08 | 28.35 | 28.58 | 243500.0 |
| 2022-11-11 | AATC | Stock | 4.12 | 4.2 | 4.0401 | 4.155 | 11235.0 |
| 2022-11-11 | AAU-DELISTED | Stock | 0.2594 | 0.2694 | 0.2508 | 0.2635 | 264811.0 |
| 2022-11-11 | AAUAF-DELISTED | Stock | 0.2594 | 0.2694 | 0.2508 | 0.2589 | 267434.0 |
| 2022-11-11 | AAWW-DELISTED | Stock | 100.61 | 100.67 | 100.1 | 100.2 | 202642.0 |
| 2022-11-11 | AAXJ | Stock | 62.59 | 63.49 | 62.59 | 63.45 | 6564944.0 |
| 2022-11-11 | AB | Stock | 37.1 | 39.26 | 36.97 | 39.24 | 781100.0 |
| 2022-11-11 | ABB-DELISTED | Stock | 30.84 | 31.6675 | 30.8 | 31.58 | 1242413.0 |
| 2022-11-11 | ABBNY-DELISTED | Stock | 30.84 | 31.6675 | 30.8 | 31.58 | 1423411.0 |
| 2022-11-11 | ABBV | Stock | 149.54 | 150.52 | 145.75 | 150.16 | 6786400.0 |
| 2022-11-11 | ABC-DELISTED | Stock | 155.52 | 155.85 | 147.1 | 153.04 | 1779939.0 |
| 2022-11-11 | ABCB | Stock | 53.76 | 54.24 | 53.49 | 53.52 | 352500.0 |
| 2022-11-11 | ABCL | Stock | 12.85 | 13.83 | 12.78 | 13.58 | 3200800.0 |
| 2022-11-11 | ABCM-DELISTED | Stock | 16.61 | 16.96 | 16.54 | 16.83 | 101769.0 |
| 2022-11-11 | ABEO | Stock | 4.22 | 4.59 | 4.19 | 4.39 | 476200.0 |
| 2022-11-11 | ABEV | Stock | 2.96 | 3.01 | 2.93 | 2.99 | 26890400.0 |
| 2022-11-11 | ABG | Stock | 176.33 | 181.88 | 175.6 | 181.05 | 184900.0 |
| 2022-11-11 | ABGI-DELISTED | Stock | 9.98 | 10.01 | 9.98 | 10.01 | 100100.0 |
| 2022-11-11 | ABM | Stock | 45.77 | 46.26 | 44.74 | 44.8 | 220500.0 |
| 2022-11-11 | ABMD-DELISTED | Stock | 373.7 | 374.87 | 373.09 | 374.0 | 1134327.0 |
| 2022-11-11 | ABNB | Stock | 103.45 | 109.77 | 102.16 | 109.57 | 6864400.0 |
| 2022-11-11 | ABOS | Stock | 6.54 | 6.915 | 6.395 | 6.8 | 97600.0 |
> showing 50 of 7,789 rows — these rows as CSV