PREVIEW / stock_daily / 2024-06-28
file: by_date/stock_daily/2024/2024-06-28.parquet size: 233 KB rows: 7,216 symbols: 919
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-06-28 | AAPL | Stock | 215.77 | 216.07 | 210.3 | 210.62 | 82542700.0 |
| 2024-06-28 | MSFT | Stock | 453.07 | 455.38 | 446.41 | 446.95 | 28362300.0 |
| 2024-06-28 | NVDA | Stock | 124.58 | 127.71 | 122.75 | 123.54 | 315516700.0 |
| 2024-06-28 | AMZN | Stock | 197.73 | 198.85 | 192.5 | 193.25 | 76930200.0 |
| 2024-06-28 | GOOGL | Stock | 184.32 | 185.13 | 181.96 | 182.15 | 29156644.0 |
| 2024-06-28 | META | Stock | 517.15 | 521.88 | 503.84 | 504.22 | 15855100.0 |
| 2024-06-28 | TSLA | Stock | 199.55 | 203.2 | 195.26 | 197.88 | 95438100.0 |
| 2024-06-28 | TLT | Stock | 93.73 | 93.765 | 91.78 | 91.78 | 55119554.0 |
| 2024-06-28 | ES | Stock | 57.33 | 57.4 | 56.3 | 56.71 | 3215800.0 |
| 2024-06-28 | CL | Stock | 98.2 | 98.47 | 96.78 | 97.04 | 11036200.0 |
| 2024-06-28 | A | Stock | 131.66 | 133.04 | 128.39 | 129.63 | 9817600.0 |
| 2024-06-28 | AA | Stock | 39.84 | 40.12 | 39.1 | 39.78 | 6829100.0 |
| 2024-06-28 | AACG | Stock | 0.79 | 0.82 | 0.78 | 0.82 | 11800.0 |
| 2024-06-28 | AACT | Stock | 10.67 | 10.67 | 10.65 | 10.67 | 265000.0 |
| 2024-06-28 | AAGR-DELISTED | Stock | 0.31 | 0.325 | 0.22 | 0.2697 | 59927022.0 |
| 2024-06-28 | AAGRW-DELISTED | Stock | 0.0149 | 0.0169 | 0.0128 | 0.01358 | 14776.0 |
| 2024-06-28 | AAL | Stock | 11.24 | 11.36 | 11.2 | 11.33 | 28121100.0 |
| 2024-06-28 | AAMC-DELISTED | Stock | 2.09 | 2.1 | 1.76 | 1.92 | 2700.0 |
| 2024-06-28 | AAME | Stock | 1.7 | 1.74 | 1.62 | 1.69 | 6000.0 |
| 2024-06-28 | AAMI | Stock | 22.01 | 22.18 | 21.45 | 22.17 | 1417700.0 |
| 2024-06-28 | AAN-DELISTED | Stock | 9.98 | 9.99 | 9.96 | 9.98 | 634000.0 |
| 2024-06-28 | AAOI | Stock | 8.6 | 8.9 | 8.25 | 8.29 | 7215000.0 |
| 2024-06-28 | AAON | Stock | 87.13 | 88.71 | 86.89 | 87.24 | 8447900.0 |
| 2024-06-28 | AAP | Stock | 62.86 | 63.46 | 61.97 | 63.33 | 1351100.0 |
| 2024-06-28 | AAT | Stock | 21.78 | 22.45 | 21.66 | 22.38 | 873400.0 |
| 2024-06-28 | AATC | Stock | 6.1 | 6.35 | 6.05 | 6.35 | 27305.0 |
| 2024-06-28 | AAUAF-DELISTED | Stock | 0.07 | 0.07 | 0.057 | 0.0582 | 217497.0 |
| 2024-06-28 | AAXJ | Stock | 72.33 | 72.42 | 71.83 | 71.98 | 694617.0 |
| 2024-06-28 | AB | Stock | 33.48 | 33.97 | 33.48 | 33.79 | 119700.0 |
| 2024-06-28 | ABAT | Stock | 1.27 | 1.3 | 1.19 | 1.25 | 1129353.0 |
| 2024-06-28 | ABBV | Stock | 169.99 | 171.82 | 169.05 | 171.52 | 24463400.0 |
| 2024-06-28 | ABCB | Stock | 49.37 | 50.65 | 49.37 | 50.35 | 1058000.0 |
| 2024-06-28 | ABCL | Stock | 2.87 | 3.02 | 2.87 | 2.96 | 1806700.0 |
| 2024-06-28 | ABEO | Stock | 4.17 | 4.24 | 4.07 | 4.24 | 243900.0 |
| 2024-06-28 | ABEV | Stock | 2.07 | 2.09 | 2.01 | 2.05 | 35972900.0 |
| 2024-06-28 | ABG | Stock | 227.82 | 230.64 | 227.05 | 227.87 | 304100.0 |
| 2024-06-28 | ABLLW | Stock | 0.72 | 0.73001 | 0.6993 | 0.715 | 11760.0 |
| 2024-06-28 | ABLV | Stock | 0.94 | 0.94 | 0.925 | 0.93 | 3400.0 |
| 2024-06-28 | ABM | Stock | 50.47 | 50.79 | 50.18 | 50.57 | 1585200.0 |
| 2024-06-28 | ABNB | Stock | 151.54 | 152.93 | 150.68 | 151.63 | 3842500.0 |
| 2024-06-28 | ABOS | Stock | 2.33 | 2.51 | 2.33 | 2.42 | 5515700.0 |
| 2024-06-28 | ABR | Stock | 14.26 | 14.4 | 14.21 | 14.35 | 3006900.0 |
| 2024-06-28 | ABR.D | Stock | 18.71 | 18.81 | 18.48 | 18.49 | 13813.0 |
| 2024-06-28 | ABR.E | Stock | 18.15 | 18.15 | 18.0 | 18.04 | 8730.0 |
| 2024-06-28 | ABR.F | Stock | 19.4001 | 20.32 | 19.0 | 19.53 | 180955.0 |
| 2024-06-28 | ABSI | Stock | 3.04 | 3.17 | 2.96 | 3.08 | 12564200.0 |
| 2024-06-28 | ABT | Stock | 104.7 | 105.16 | 103.53 | 103.91 | 8283600.0 |
| 2024-06-28 | ABTC | Stock | 84.75 | 90.0 | 82.5 | 89.25 | 9533.333333333334 |
| 2024-06-28 | ABTS | Stock | 8.235 | 8.295 | 7.8 | 8.295 | 447.0 |
| 2024-06-28 | ABUS | Stock | 3.12 | 3.2 | 2.99 | 3.09 | 4407800.0 |
> showing 50 of 7,216 rows — these rows as CSV