PREVIEW / stock_daily / 2024-06-07
file: by_date/stock_daily/2024/2024-06-07.parquet size: 233 KB rows: 7,233 symbols: 964
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-07 | AAPL | Stock | 194.65 | 196.94 | 194.14 | 196.89 | 53103900.0 |
| 2024-06-07 | MSFT | Stock | 426.2 | 426.28 | 423.0 | 423.85 | 13621700.0 |
| 2024-06-07 | NVDA | Stock | 119.77 | 121.692 | 118.022 | 120.888 | 412386000.0 |
| 2024-06-07 | AMZN | Stock | 184.9 | 186.29 | 183.36 | 184.3 | 28021500.0 |
| 2024-06-07 | GOOGL | Stock | 177.05 | 177.87 | 174.3 | 174.46 | 19661399.0 |
| 2024-06-07 | META | Stock | 495.91 | 498.91 | 490.17 | 492.96 | 9380700.0 |
| 2024-06-07 | TSLA | Stock | 176.13 | 179.35 | 175.58 | 177.48 | 56244900.0 |
| 2024-06-07 | TLT | Stock | 91.83 | 91.83 | 91.4 | 91.5 | 35240475.0 |
| 2024-06-07 | ES | Stock | 58.33 | 59.06 | 58.23 | 58.58 | 1944500.0 |
| 2024-06-07 | CL | Stock | 94.09 | 94.57 | 93.79 | 93.89 | 2596200.0 |
| 2024-06-07 | A | Stock | 131.95 | 133.38 | 131.29 | 132.98 | 2365300.0 |
| 2024-06-07 | AA | Stock | 41.6 | 41.869 | 40.42 | 40.91 | 3982800.0 |
| 2024-06-07 | AACG | Stock | 0.86 | 0.86 | 0.82 | 0.86 | 8900.0 |
| 2024-06-07 | AACIW-DELISTED | Stock | 0.111 | 0.1349 | 0.1109 | 0.12 | 158225.0 |
| 2024-06-07 | AACT | Stock | 10.65 | 10.67 | 10.65 | 10.665 | 2400.0 |
| 2024-06-07 | AAGR-DELISTED | Stock | 0.343 | 0.35 | 0.34 | 0.345 | 46557.0 |
| 2024-06-07 | AAGRW-DELISTED | Stock | 0.017 | 0.0174 | 0.012 | 0.0169 | 12384.0 |
| 2024-06-07 | AAL | Stock | 11.36 | 11.57 | 11.35 | 11.5 | 29411400.0 |
| 2024-06-07 | AAMC-DELISTED | Stock | 2.436 | 2.625 | 2.436 | 2.625 | 1100.0 |
| 2024-06-07 | AAME | Stock | 1.78 | 1.82 | 1.76 | 1.78 | 1400.0 |
| 2024-06-07 | AAMI | Stock | 22.33 | 22.55 | 21.95 | 21.96 | 360900.0 |
| 2024-06-07 | AAN-DELISTED | Stock | 8.4 | 8.45 | 8.0 | 8.02 | 645400.0 |
| 2024-06-07 | AAOI | Stock | 10.31 | 10.88 | 10.29 | 10.55 | 1157000.0 |
| 2024-06-07 | AAON | Stock | 71.98 | 72.94 | 71.55 | 71.99 | 533600.0 |
| 2024-06-07 | AAP | Stock | 63.8 | 64.96 | 63.55 | 64.58 | 1071900.0 |
| 2024-06-07 | AAT | Stock | 21.33 | 21.54 | 21.25 | 21.41 | 198700.0 |
| 2024-06-07 | AATC | Stock | 6.19 | 6.195 | 6.1 | 6.107 | 1992.0 |
| 2024-06-07 | AAUAF-DELISTED | Stock | 0.08 | 0.0884 | 0.064 | 0.071 | 46387.0 |
| 2024-06-07 | AAXJ | Stock | 71.42 | 71.53 | 71.01 | 71.15 | 286206.0 |
| 2024-06-07 | AB | Stock | 33.47 | 33.83 | 33.31 | 33.39 | 126800.0 |
| 2024-06-07 | ABAT | Stock | 1.36 | 1.3932 | 1.28 | 1.3 | 412112.0 |
| 2024-06-07 | ABBV | Stock | 169.0 | 170.34 | 167.79 | 169.42 | 3781700.0 |
| 2024-06-07 | ABCB | Stock | 47.04 | 47.69 | 47.04 | 47.58 | 263400.0 |
| 2024-06-07 | ABCL | Stock | 3.74 | 3.76 | 3.61 | 3.62 | 1083400.0 |
| 2024-06-07 | ABEO | Stock | 4.23 | 4.35 | 4.23 | 4.27 | 240400.0 |
| 2024-06-07 | ABEV | Stock | 2.21 | 2.22 | 2.16 | 2.17 | 21049100.0 |
| 2024-06-07 | ABG | Stock | 235.5 | 236.32 | 234.06 | 234.22 | 118400.0 |
| 2024-06-07 | ABLLW | Stock | 0.371 | 0.46 | 0.3422 | 0.38 | 23234.0 |
| 2024-06-07 | ABLV | Stock | 1.05 | 1.27 | 1.05 | 1.26 | 11400.0 |
| 2024-06-07 | ABM | Stock | 48.6 | 51.09 | 48.59 | 50.94 | 1062400.0 |
| 2024-06-07 | ABNB | Stock | 146.2 | 147.03 | 145.38 | 146.66 | 2595600.0 |
| 2024-06-07 | ABOS | Stock | 2.44 | 2.63 | 2.44 | 2.62 | 497900.0 |
| 2024-06-07 | ABR | Stock | 13.86 | 13.93 | 13.32 | 13.52 | 4496400.0 |
| 2024-06-07 | ABR.D | Stock | 18.68 | 18.68 | 18.5 | 18.5353 | 4315.0 |
| 2024-06-07 | ABR.E | Stock | 17.98 | 18.205 | 17.94 | 17.98 | 18568.0 |
| 2024-06-07 | ABR.F | Stock | 19.75 | 20.0 | 19.75 | 19.83 | 11375.0 |
| 2024-06-07 | ABSI | Stock | 4.28 | 4.38 | 4.21 | 4.38 | 593500.0 |
| 2024-06-07 | ABT | Stock | 103.86 | 108.13 | 103.37 | 107.58 | 8666600.0 |
| 2024-06-07 | ABTC | Stock | 108.0 | 108.0 | 93.75 | 95.25 | 6810.666666666667 |
| 2024-06-07 | ABTS | Stock | 9.165 | 9.825 | 9.165 | 9.75 | 847.0 |
> showing 50 of 7,233 rows — these rows as CSV