PREVIEW / stock_daily / 2024-09-05
file: by_date/stock_daily/2024/2024-09-05.parquet size: 244 KB rows: 7,132 symbols: 773
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 |
|---|---|---|---|---|---|---|---|
| 2024-09-05 | AAPL | Stock | 221.625 | 225.48 | 221.52 | 222.38 | 34703302.0 |
| 2024-09-05 | MSFT | Stock | 407.62 | 413.1 | 406.13 | 408.39 | 13150475.0 |
| 2024-09-05 | NVDA | Stock | 104.985 | 109.65 | 104.76 | 107.21 | 300402332.0 |
| 2024-09-05 | AMZN | Stock | 175.0 | 179.875 | 174.995 | 177.89 | 39470492.0 |
| 2024-09-05 | GOOGL | Stock | 156.3 | 159.45 | 155.9805 | 157.24 | 18688747.0 |
| 2024-09-05 | META | Stock | 511.72 | 521.6295 | 511.15 | 516.86 | 8472714.0 |
| 2024-09-05 | TSLA | Stock | 223.49 | 235.0 | 222.25 | 230.17 | 118770184.0 |
| 2024-09-05 | TLT | Stock | 99.34 | 99.6787 | 98.775 | 99.57 | 47450878.0 |
| 2024-09-05 | ES | Stock | 69.01 | 69.01 | 67.91 | 68.05 | 1290398.0 |
| 2024-09-05 | CL | Stock | 109.0 | 109.3 | 108.14 | 108.53 | 4390285.0 |
| 2024-09-05 | A | Stock | 138.36 | 139.06 | 136.925 | 138.36 | 1151436.0 |
| 2024-09-05 | AA | Stock | 30.6 | 31.09 | 30.11 | 30.27 | 2989231.0 |
| 2024-09-05 | AACG | Stock | 0.60095 | 0.607 | 0.59 | 0.59 | 5003.0 |
| 2024-09-05 | AACT | Stock | 10.7704 | 10.78 | 10.76 | 10.78 | 327785.0 |
| 2024-09-05 | AAGR-DELISTED | Stock | 0.1397 | 0.1397 | 0.13 | 0.1359 | 101747.0 |
| 2024-09-05 | AAGRW-DELISTED | Stock | 0.01 | 0.011 | 0.01 | 0.011 | 2105.0 |
| 2024-09-05 | AAL | Stock | 10.84 | 11.16 | 10.75 | 10.8 | 38218353.0 |
| 2024-09-05 | AAMC-DELISTED | Stock | 1.12 | 1.99 | 1.12 | 1.85 | 1826462.0 |
| 2024-09-05 | AAME | Stock | 1.6108 | 1.69 | 1.61 | 1.68 | 3422.0 |
| 2024-09-05 | AAMI | Stock | 23.81 | 23.81 | 23.32 | 23.74 | 156076.0 |
| 2024-09-05 | AAN-DELISTED | Stock | 9.98 | 10.0 | 9.95 | 9.99 | 1507814.0 |
| 2024-09-05 | AAOI | Stock | 13.02 | 13.5976 | 12.1395 | 12.24 | 2976353.0 |
| 2024-09-05 | AAON | Stock | 88.82 | 88.82 | 87.15 | 87.49 | 253545.0 |
| 2024-09-05 | AAP | Stock | 42.5 | 42.67 | 40.305 | 40.46 | 3680475.0 |
| 2024-09-05 | AAT | Stock | 26.53 | 26.55 | 25.92 | 25.95 | 230847.0 |
| 2024-09-05 | AATC | Stock | 7.6 | 7.65 | 7.3 | 7.65 | 2978.0 |
| 2024-09-05 | AAUAF-DELISTED | Stock | 0.03997 | 0.0451 | 0.037 | 0.041 | 10598.0 |
| 2024-09-05 | AAXJ | Stock | 71.51 | 71.86 | 71.35 | 71.53 | 270745.0 |
| 2024-09-05 | AB | Stock | 33.77 | 33.8 | 33.3 | 33.58 | 159910.0 |
| 2024-09-05 | ABAT | Stock | 1.08 | 1.0899 | 1.04 | 1.05 | 117523.0 |
| 2024-09-05 | ABBV | Stock | 196.96 | 197.13 | 192.16 | 192.86 | 5438790.0 |
| 2024-09-05 | ABCB | Stock | 61.49 | 61.49 | 59.96 | 60.57 | 201236.0 |
| 2024-09-05 | ABCL | Stock | 2.52 | 2.57 | 2.42 | 2.43 | 2403054.0 |
| 2024-09-05 | ABEO | Stock | 5.6 | 5.68 | 5.46 | 5.63 | 201377.0 |
| 2024-09-05 | ABEV | Stock | 2.32 | 2.34 | 2.31 | 2.32 | 12398714.0 |
| 2024-09-05 | ABG | Stock | 235.99 | 235.99 | 229.89 | 230.77 | 124956.0 |
| 2024-09-05 | ABLLW | Stock | 1.39 | 1.48 | 1.39 | 1.465 | 93346.0 |
| 2024-09-05 | ABLV | Stock | 1.56 | 1.6401 | 1.17 | 1.17 | 21446.0 |
| 2024-09-05 | ABM | Stock | 55.98 | 56.63 | 55.59 | 56.1 | 643736.0 |
| 2024-09-05 | ABNB | Stock | 114.64 | 116.45 | 114.6 | 116.16 | 3555123.0 |
| 2024-09-05 | ABOS | Stock | 2.37 | 2.42 | 2.27 | 2.27 | 287579.0 |
| 2024-09-05 | ABR | Stock | 13.19 | 13.19 | 13.0 | 13.09 | 1856388.0 |
| 2024-09-05 | ABR.D | Stock | 18.1199 | 18.1199 | 17.86 | 17.89 | 18494.0 |
| 2024-09-05 | ABR.E | Stock | 18.1 | 18.25 | 17.73 | 17.75 | 25285.0 |
| 2024-09-05 | ABR.F | Stock | 18.72 | 18.72 | 18.6 | 18.67 | 10062.0 |
| 2024-09-05 | ABSI | Stock | 4.12 | 4.225 | 4.01 | 4.13 | 784264.0 |
| 2024-09-05 | ABT | Stock | 114.26 | 114.48 | 112.52 | 113.1 | 2756299.0 |
| 2024-09-05 | ABTC | Stock | 44.703 | 45.1725 | 41.475 | 43.485 | 2912.6 |
| 2024-09-05 | ABTS | Stock | 7.635 | 7.6455 | 7.011 | 7.4115 | 685.0 |
| 2024-09-05 | ABUS | Stock | 4.18 | 4.52 | 4.17 | 4.51 | 3251174.0 |
> showing 50 of 7,132 rows — these rows as CSV