PREVIEW / stock_daily / 2024-11-12
file: by_date/stock_daily/2024/2024-11-12.parquet size: 246 KB rows: 7,116 symbols: 663
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-11-12 | AAPL | Stock | 224.55 | 225.59 | 223.355 | 224.23 | 37561675.0 |
| 2024-11-12 | MSFT | Stock | 418.25 | 424.44 | 417.2 | 423.03 | 18176010.0 |
| 2024-11-12 | NVDA | Stock | 146.78 | 149.65 | 146.01 | 148.29 | 192910267.0 |
| 2024-11-12 | AMZN | Stock | 208.37 | 209.54 | 206.01 | 208.91 | 35850828.0 |
| 2024-11-12 | GOOGL | Stock | 179.82 | 182.49 | 179.39 | 181.62 | 25134905.0 |
| 2024-11-12 | META | Stock | 588.545 | 599.66 | 580.38 | 584.82 | 15958016.0 |
| 2024-11-12 | TSLA | Stock | 342.74 | 345.84 | 323.31 | 328.49 | 152886042.0 |
| 2024-11-12 | TLT | Stock | 91.37 | 91.85 | 90.51 | 90.66 | 57908367.0 |
| 2024-11-12 | ES | Stock | 60.81 | 61.0 | 60.18 | 60.57 | 1604126.0 |
| 2024-11-12 | CL | Stock | 93.3 | 93.3 | 91.43 | 91.5 | 4670077.0 |
| 2024-11-12 | A | Stock | 133.86 | 136.04 | 133.64 | 133.67 | 1371165.0 |
| 2024-11-12 | AA | Stock | 42.73 | 42.73 | 40.11 | 40.95 | 6259578.0 |
| 2024-11-12 | AACG | Stock | 1.03 | 1.04 | 0.9867 | 1.03 | 27318.0 |
| 2024-11-12 | AACT | Stock | 10.875 | 10.89 | 10.87 | 10.87 | 83428.0 |
| 2024-11-12 | AAL | Stock | 13.975 | 14.08 | 13.73 | 13.91 | 20172950.0 |
| 2024-11-12 | AAM | Stock | 10.06 | 10.06 | 10.0598 | 10.0598 | 52089.0 |
| 2024-11-12 | AAME | Stock | 1.67 | 1.69 | 1.6106 | 1.69 | 2751.0 |
| 2024-11-12 | AAMI | Stock | 30.18 | 30.4895 | 29.76 | 30.16 | 198596.0 |
| 2024-11-12 | AAOI | Stock | 27.72 | 28.94 | 27.2 | 28.54 | 3585161.0 |
| 2024-11-12 | AAON | Stock | 139.53 | 141.493 | 135.5516 | 137.73 | 526329.0 |
| 2024-11-12 | AAP | Stock | 40.0 | 40.5495 | 39.5375 | 39.91 | 2148710.0 |
| 2024-11-12 | AAT | Stock | 27.99 | 28.24 | 27.39 | 27.42 | 201291.0 |
| 2024-11-12 | AATC | Stock | 7.83 | 8.0475 | 7.83 | 8.0475 | 2085.0 |
| 2024-11-12 | AAUAF-DELISTED | Stock | 0.0416 | 0.055 | 0.0416 | 0.044 | 31859.0 |
| 2024-11-12 | AAXJ | Stock | 74.72 | 74.8 | 74.1 | 74.34 | 631149.0 |
| 2024-11-12 | AB | Stock | 36.52 | 36.6713 | 35.55 | 36.18 | 280854.0 |
| 2024-11-12 | ABAT | Stock | 0.9689 | 0.9799 | 0.9311 | 0.9663 | 306504.0 |
| 2024-11-12 | ABBV | Stock | 176.01 | 176.63 | 171.03 | 171.09 | 10487437.0 |
| 2024-11-12 | ABCB | Stock | 71.07 | 72.23 | 70.41 | 70.51 | 366414.0 |
| 2024-11-12 | ABCL | Stock | 3.09 | 3.09 | 2.93 | 2.96 | 3997347.0 |
| 2024-11-12 | ABEO | Stock | 6.78 | 6.78 | 6.07 | 6.105 | 924149.0 |
| 2024-11-12 | ABEV | Stock | 2.16 | 2.22 | 2.15 | 2.22 | 29920198.0 |
| 2024-11-12 | ABG | Stock | 262.38 | 263.11 | 256.01 | 258.66 | 162274.0 |
| 2024-11-12 | ABLLW | Stock | 1.32 | 1.49 | 1.18 | 1.23 | 19642.0 |
| 2024-11-12 | ABLV | Stock | 0.9 | 0.94 | 0.87 | 0.87 | 24985.0 |
| 2024-11-12 | ABLVW | Stock | 0.01724 | 0.0189 | 0.01724 | 0.0189 | 1100.0 |
| 2024-11-12 | ABM | Stock | 58.5 | 59.15 | 57.275 | 57.39 | 391990.0 |
| 2024-11-12 | ABNB | Stock | 135.65 | 136.12 | 133.13 | 133.2 | 6367320.0 |
| 2024-11-12 | ABOS | Stock | 3.2 | 3.2 | 2.55 | 2.675 | 431046.0 |
| 2024-11-12 | ABR | Stock | 15.61 | 15.73 | 15.435 | 15.5 | 2106006.0 |
| 2024-11-12 | ABR.D | Stock | 19.08 | 19.23 | 18.8 | 18.99 | 15138.0 |
| 2024-11-12 | ABR.E | Stock | 19.5576 | 19.5576 | 19.15 | 19.55 | 1958.0 |
| 2024-11-12 | ABR.F | Stock | 20.6 | 20.8 | 20.135 | 20.4 | 24866.0 |
| 2024-11-12 | ABSI | Stock | 4.1 | 4.1 | 3.615 | 3.64 | 2210156.0 |
| 2024-11-12 | ABT | Stock | 116.68 | 117.3 | 116.42 | 116.44 | 3819515.0 |
| 2024-11-12 | ABTC | Stock | 64.1625 | 65.25 | 53.7525 | 62.25000000000001 | 24699.666666666668 |
| 2024-11-12 | ABTS | Stock | 9.1695 | 10.95 | 8.865 | 10.8015 | 37449.0 |
| 2024-11-12 | ABUS | Stock | 3.73 | 3.75 | 3.61 | 3.64 | 746571.0 |
| 2024-11-12 | ABVC | Stock | 0.5177 | 0.5313 | 0.51 | 0.52 | 75264.0 |
| 2024-11-12 | ABVE | Stock | 0.474 | 0.53 | 0.47 | 0.52 | 156979.0 |
> showing 50 of 7,116 rows — these rows as CSV