PREVIEW / stock_daily / 2026-07-27
file: by_date/stock_daily/2026/2026-07-27.parquet size: 229 KB rows: 6,599
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 |
|---|---|---|---|---|---|---|---|
| 2026-07-27 | AAPL | Stock | 334.54 | 339.57 | 334.02 | 336.91 | 49604297.0 |
| 2026-07-27 | MSFT | Stock | 390.08 | 394.2 | 387.99 | 389.1 | 27856160.0 |
| 2026-07-27 | NVDA | Stock | 208.2 | 208.75 | 195.44 | 196.51 | 154353698.0 |
| 2026-07-27 | AMZN | Stock | 235.665 | 235.89 | 230.99 | 231.39 | 34999495.0 |
| 2026-07-27 | GOOGL | Stock | 325.04 | 330.42 | 324.45 | 326.56 | 28471593.0 |
| 2026-07-27 | META | Stock | 607.22 | 611.26 | 593.13 | 593.87 | 11195251.0 |
| 2026-07-27 | TSLA | Stock | 313.24 | 317.0 | 304.28 | 309.22 | 44919377.0 |
| 2026-07-27 | ES | Stock | 74.6 | 75.675 | 74.53 | 74.69 | 1909538.0 |
| 2026-07-27 | CL | Stock | 91.25 | 92.81 | 90.84 | 91.98 | 3772143.0 |
| 2026-07-27 | A | Stock | 137.59 | 139.06 | 136.14 | 137.89 | 1830515.0 |
| 2026-07-27 | AA | Stock | 44.24 | 44.66 | 43.5 | 44.08 | 4419965.0 |
| 2026-07-27 | AACB | Stock | 10.51 | 10.51 | 10.5099 | 10.51 | 7241.0 |
| 2026-07-27 | AACBR | Stock | 0.17 | 0.17 | 0.17 | 0.17 | 345.0 |
| 2026-07-27 | AACG | Stock | 0.84 | 0.9761 | 0.84 | 0.92 | 3859.0 |
| 2026-07-27 | AACI | Stock | 9.98 | 9.99 | 9.98 | 9.99 | 89756.0 |
| 2026-07-27 | AACIW | Stock | 0.28 | 0.39 | 0.25 | 0.39 | 21585.0 |
| 2026-07-27 | AAGR | Stock | 0.007 | 0.007 | 0.007 | 0.007 | 100.0 |
| 2026-07-27 | AAL | Stock | 14.89 | 15.13 | 14.52 | 14.95 | 93953943.0 |
| 2026-07-27 | AAME | Stock | 1.55 | 1.6099 | 1.5405 | 1.55 | 3578.0 |
| 2026-07-27 | AAMI | Stock | 82.44 | 84.4 | 81.76 | 82.85 | 346094.0 |
| 2026-07-27 | AAOI | Stock | 100.56 | 102.9477 | 92.22 | 97.82 | 6662393.0 |
| 2026-07-27 | AAON | Stock | 103.8 | 103.88 | 98.3 | 101.02 | 739300.0 |
| 2026-07-27 | AAP | Stock | 56.85 | 58.36 | 55.41 | 57.73 | 1945282.0 |
| 2026-07-27 | AAPG | Stock | 18.32 | 19.0 | 18.32 | 18.89 | 2016.0 |
| 2026-07-27 | AARD | Stock | 6.4 | 6.8 | 6.3635 | 6.69 | 70379.0 |
| 2026-07-27 | AAT | Stock | 24.44 | 24.66 | 24.26 | 24.33 | 375946.0 |
| 2026-07-27 | AATC | Stock | 5.4835 | 5.49 | 5.44 | 5.45 | 1671.0 |
| 2026-07-27 | AAUC | Stock | 21.1 | 21.155 | 20.45 | 20.85 | 241315.0 |
| 2026-07-27 | AB | Stock | 37.37 | 37.9731 | 37.36 | 37.9 | 183748.0 |
| 2026-07-27 | ABAT | Stock | 2.29 | 2.37 | 2.21 | 2.27 | 2825635.0 |
| 2026-07-27 | ABBV | Stock | 259.0 | 262.1 | 256.78 | 256.91 | 5404809.0 |
| 2026-07-27 | ABCB | Stock | 87.78 | 88.345 | 86.01 | 86.04 | 995560.0 |
| 2026-07-27 | ABCL | Stock | 5.405 | 5.5 | 5.24 | 5.25 | 4230205.0 |
| 2026-07-27 | ABEO | Stock | 6.06 | 6.1851 | 6.04 | 6.13 | 779339.0 |
| 2026-07-27 | ABEV | Stock | 3.05 | 3.08 | 3.03 | 3.07 | 9237756.0 |
| 2026-07-27 | ABG | Stock | 228.03 | 231.79 | 225.925 | 226.64 | 252218.0 |
| 2026-07-27 | ABI | Stock | 24.81 | 24.81 | 24.81 | 24.81 | 96.0 |
| 2026-07-27 | ABLV | Stock | 0.92 | 0.92 | 0.87 | 0.8701 | 30408.0 |
| 2026-07-27 | ABLVW | Stock | 0.0167 | 0.0167 | 0.0167 | 0.0167 | 273.0 |
| 2026-07-27 | ABM | Stock | 47.51 | 48.74 | 47.51 | 48.46 | 380247.0 |
| 2026-07-27 | ABNB | Stock | 143.5 | 147.03 | 143.0 | 146.86 | 2902656.0 |
| 2026-07-27 | ABOS | Stock | 2.19 | 2.25 | 2.175 | 2.2 | 244610.0 |
| 2026-07-27 | ABR | Stock | 5.01 | 5.11 | 5.01 | 5.08 | 3522383.0 |
| 2026-07-27 | ABR.D | Stock | 15.85 | 15.9757 | 15.85 | 15.93 | 15106.0 |
| 2026-07-27 | ABR.E | Stock | 15.78 | 15.78 | 15.75 | 15.77 | 3793.0 |
| 2026-07-27 | ABR.F | Stock | 22.25 | 22.32 | 22.15 | 22.3 | 9116.0 |
| 2026-07-27 | ABSI | Stock | 7.805 | 8.09 | 7.55 | 7.56 | 2452721.0 |
| 2026-07-27 | ABT | Stock | 104.09 | 105.855 | 103.375 | 104.49 | 11619834.0 |
| 2026-07-27 | ABTC | Stock | 5.85 | 6.2083 | 5.6 | 5.87 | 1187192.0 |
| 2026-07-27 | ABTS | Stock | 1.15 | 1.1794 | 1.12 | 1.17 | 9430.0 |
> showing 50 of 6,599 rows — these rows as CSV