PREVIEW / stock_daily / 2024-09-12
file: by_date/stock_daily/2024/2024-09-12.parquet size: 243 KB rows: 7,096 symbols: 750
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-12 | AAPL | Stock | 222.5 | 223.55 | 219.82 | 222.77 | 36752187.0 |
| 2024-09-12 | MSFT | Stock | 423.31 | 427.3692 | 419.75 | 427.0 | 16236595.0 |
| 2024-09-12 | NVDA | Stock | 116.84 | 120.79 | 115.38 | 119.14 | 360557389.0 |
| 2024-09-12 | AMZN | Stock | 184.8 | 187.41 | 183.54 | 187.0 | 31518833.0 |
| 2024-09-12 | GOOGL | Stock | 153.8 | 154.82 | 152.65 | 154.69 | 29695048.0 |
| 2024-09-12 | META | Stock | 517.05 | 526.71 | 515.22 | 525.6 | 11901816.0 |
| 2024-09-12 | TSLA | Stock | 224.66 | 231.45 | 223.83 | 229.81 | 71663452.0 |
| 2024-09-12 | TLT | Stock | 100.36 | 100.55 | 99.69 | 100.14 | 41812529.0 |
| 2024-09-12 | ES | Stock | 67.91 | 68.41 | 67.17 | 67.5 | 1637557.0 |
| 2024-09-12 | CL | Stock | 105.9 | 106.44 | 105.25 | 106.34 | 2777948.0 |
| 2024-09-12 | A | Stock | 138.2 | 138.62 | 134.25 | 136.39 | 1563026.0 |
| 2024-09-12 | AA | Stock | 30.99 | 31.76 | 30.6 | 31.35 | 5866944.0 |
| 2024-09-12 | AACG | Stock | 0.5817 | 0.5998 | 0.5013 | 0.5108 | 138358.0 |
| 2024-09-12 | AACT | Stock | 10.7901 | 10.8 | 10.78 | 10.78 | 9920.0 |
| 2024-09-12 | AAGR-DELISTED | Stock | 0.132 | 0.1377 | 0.131 | 0.133 | 158348.0 |
| 2024-09-12 | AAL | Stock | 11.03 | 11.135 | 10.43 | 10.88 | 37771288.0 |
| 2024-09-12 | AAMC-DELISTED | Stock | 1.56 | 1.56 | 1.39 | 1.45 | 56262.0 |
| 2024-09-12 | AAME | Stock | 1.7599 | 1.7599 | 1.7 | 1.74 | 815.0 |
| 2024-09-12 | AAMI | Stock | 23.57 | 23.76 | 23.16 | 23.75 | 111117.0 |
| 2024-09-12 | AAN-DELISTED | Stock | 10.07 | 10.12 | 10.06 | 10.11 | 334349.0 |
| 2024-09-12 | AAOI | Stock | 13.47 | 14.99 | 13.41 | 14.52 | 4592018.0 |
| 2024-09-12 | AAON | Stock | 91.8 | 93.53 | 91.54 | 93.47 | 210663.0 |
| 2024-09-12 | AAP | Stock | 38.79 | 39.52 | 38.31 | 39.48 | 1704341.0 |
| 2024-09-12 | AAT | Stock | 25.94 | 26.545 | 25.86 | 26.34 | 161000.0 |
| 2024-09-12 | AATC | Stock | 7.65 | 7.74 | 7.65 | 7.74 | 940.0 |
| 2024-09-12 | AAUAF-DELISTED | Stock | 0.0432 | 0.05 | 0.0432 | 0.04325 | 40981.0 |
| 2024-09-12 | AAXJ | Stock | 71.55 | 72.0 | 71.42 | 71.98 | 186754.0 |
| 2024-09-12 | AB | Stock | 33.89 | 34.28 | 33.68 | 34.21 | 181929.0 |
| 2024-09-12 | ABAT | Stock | 1.03 | 1.0501 | 1.0 | 1.03 | 233655.0 |
| 2024-09-12 | ABBV | Stock | 194.78 | 195.07 | 191.27 | 194.02 | 3677119.0 |
| 2024-09-12 | ABCB | Stock | 59.4 | 59.46 | 58.3 | 59.27 | 253561.0 |
| 2024-09-12 | ABCL | Stock | 2.72 | 2.74 | 2.6 | 2.68 | 1408026.0 |
| 2024-09-12 | ABEO | Stock | 5.6 | 5.68 | 5.535 | 5.58 | 105517.0 |
| 2024-09-12 | ABEV | Stock | 2.29 | 2.31 | 2.26 | 2.3 | 45251902.0 |
| 2024-09-12 | ABG | Stock | 215.59 | 216.38 | 212.55 | 212.93 | 243632.0 |
| 2024-09-12 | ABLLW | Stock | 1.4 | 1.48 | 1.36 | 1.4 | 80006.0 |
| 2024-09-12 | ABLV | Stock | 1.22 | 1.23 | 1.165 | 1.17 | 7541.0 |
| 2024-09-12 | ABM | Stock | 49.37 | 49.83 | 49.19 | 49.35 | 346540.0 |
| 2024-09-12 | ABNB | Stock | 116.33 | 117.38 | 115.05 | 117.36 | 3068764.0 |
| 2024-09-12 | ABOS | Stock | 2.5 | 2.53 | 2.42 | 2.45 | 67185.0 |
| 2024-09-12 | ABR | Stock | 13.47 | 14.01 | 13.12 | 14.0 | 4453764.0 |
| 2024-09-12 | ABR.D | Stock | 18.53 | 18.8 | 18.46 | 18.69 | 48024.0 |
| 2024-09-12 | ABR.E | Stock | 18.28 | 18.8499 | 18.28 | 18.55 | 10978.0 |
| 2024-09-12 | ABR.F | Stock | 19.05 | 19.19 | 18.8 | 18.9 | 43216.0 |
| 2024-09-12 | ABSI | Stock | 3.67 | 3.78 | 3.59 | 3.69 | 528612.0 |
| 2024-09-12 | ABT | Stock | 116.495 | 117.305 | 115.59 | 116.83 | 4250047.0 |
| 2024-09-12 | ABTC | Stock | 35.1 | 36.330000000000005 | 32.2575 | 33.7875 | 1076.9333333333334 |
| 2024-09-12 | ABTS | Stock | 6.0765 | 7.8 | 6.0765 | 7.4445 | 16716.0 |
| 2024-09-12 | ABUS | Stock | 4.6 | 4.605 | 4.245 | 4.31 | 1606499.0 |
| 2024-09-12 | ABVC | Stock | 0.7 | 0.7145 | 0.6902 | 0.6902 | 12787.0 |
> showing 50 of 7,096 rows — these rows as CSV