PREVIEW / stock_daily / 2024-06-26
file: by_date/stock_daily/2024/2024-06-26.parquet size: 230 KB rows: 7,209 symbols: 927
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-26 | AAPL | Stock | 211.5 | 214.86 | 210.64 | 213.25 | 66213200.0 |
| 2024-06-26 | MSFT | Stock | 449.0 | 453.6 | 448.19 | 452.16 | 16507000.0 |
| 2024-06-26 | NVDA | Stock | 126.13 | 128.12 | 122.6 | 126.4 | 362975900.0 |
| 2024-06-26 | AMZN | Stock | 186.92 | 194.8 | 186.26 | 193.61 | 65103900.0 |
| 2024-06-26 | GOOGL | Stock | 182.63 | 184.51 | 182.48 | 183.88 | 19838972.0 |
| 2024-06-26 | META | Stock | 506.65 | 513.81 | 504.68 | 513.12 | 8882300.0 |
| 2024-06-26 | TSLA | Stock | 186.54 | 197.76 | 186.36 | 196.37 | 95737100.0 |
| 2024-06-26 | TLT | Stock | 93.28 | 93.465 | 93.11 | 93.15 | 38489135.0 |
| 2024-06-26 | ES | Stock | 56.84 | 57.14 | 56.35 | 56.97 | 1407800.0 |
| 2024-06-26 | CL | Stock | 98.07 | 98.49 | 97.87 | 98.23 | 3443900.0 |
| 2024-06-26 | A | Stock | 133.99 | 135.21 | 132.76 | 133.09 | 1836800.0 |
| 2024-06-26 | AA | Stock | 39.82 | 39.97 | 38.91 | 39.43 | 3018100.0 |
| 2024-06-26 | AACG | Stock | 0.86 | 0.86 | 0.79 | 0.84 | 25100.0 |
| 2024-06-26 | AACT | Stock | 10.66 | 10.66 | 10.655 | 10.66 | 161000.0 |
| 2024-06-26 | AAGR-DELISTED | Stock | 0.25 | 0.25 | 0.2354 | 0.249 | 297199.0 |
| 2024-06-26 | AAGRW-DELISTED | Stock | 0.0124 | 0.0124 | 0.0112 | 0.0112 | 295.0 |
| 2024-06-26 | AAL | Stock | 11.05 | 11.33 | 10.96 | 11.12 | 39848700.0 |
| 2024-06-26 | AAMC-DELISTED | Stock | 1.865 | 1.865 | 1.865 | 1.865 | 1000.0 |
| 2024-06-26 | AAME | Stock | 1.72 | 1.73 | 1.66 | 1.66 | 4100.0 |
| 2024-06-26 | AAMI | Stock | 22.04 | 22.25 | 21.88 | 21.93 | 160800.0 |
| 2024-06-26 | AAN-DELISTED | Stock | 9.95 | 9.97 | 9.93 | 9.95 | 596100.0 |
| 2024-06-26 | AAOI | Stock | 8.57 | 8.7 | 8.295 | 8.51 | 1386500.0 |
| 2024-06-26 | AAON | Stock | 84.32 | 85.48 | 84.07 | 84.9 | 1267400.0 |
| 2024-06-26 | AAP | Stock | 63.08 | 63.5 | 61.72 | 61.79 | 977200.0 |
| 2024-06-26 | AAT | Stock | 21.27 | 21.52 | 21.27 | 21.37 | 226800.0 |
| 2024-06-26 | AATC | Stock | 6.08 | 6.08 | 6.045 | 6.059 | 5244.0 |
| 2024-06-26 | AAUAF-DELISTED | Stock | 0.057 | 0.0729 | 0.057 | 0.065 | 4859.0 |
| 2024-06-26 | AAXJ | Stock | 71.93 | 71.99 | 71.71 | 71.87 | 258733.0 |
| 2024-06-26 | AB | Stock | 33.51 | 33.75 | 33.1 | 33.22 | 295900.0 |
| 2024-06-26 | ABAT | Stock | 1.08 | 1.16 | 1.07 | 1.115 | 1062132.0 |
| 2024-06-26 | ABBV | Stock | 170.29 | 172.35 | 170.15 | 171.15 | 5576100.0 |
| 2024-06-26 | ABCB | Stock | 47.75 | 48.75 | 47.67 | 48.53 | 200600.0 |
| 2024-06-26 | ABCL | Stock | 2.75 | 2.865 | 2.74 | 2.79 | 2201100.0 |
| 2024-06-26 | ABEO | Stock | 4.2 | 4.2 | 4.06 | 4.09 | 221300.0 |
| 2024-06-26 | ABEV | Stock | 2.06 | 2.11 | 2.05 | 2.1 | 24165300.0 |
| 2024-06-26 | ABG | Stock | 222.29 | 225.86 | 221.56 | 222.09 | 221100.0 |
| 2024-06-26 | ABLLW | Stock | 0.7475 | 0.777 | 0.66 | 0.66 | 362736.0 |
| 2024-06-26 | ABLV | Stock | 0.97 | 0.986 | 0.95 | 0.96 | 3700.0 |
| 2024-06-26 | ABM | Stock | 50.52 | 50.74 | 50.23 | 50.62 | 976000.0 |
| 2024-06-26 | ABNB | Stock | 149.73 | 150.385 | 149.37 | 150.0 | 3797900.0 |
| 2024-06-26 | ABOS | Stock | 2.13 | 2.265 | 2.08 | 2.16 | 724000.0 |
| 2024-06-26 | ABR | Stock | 14.1 | 14.27 | 14.07 | 14.24 | 1783500.0 |
| 2024-06-26 | ABR.D | Stock | 18.4785 | 18.9 | 18.4785 | 18.6922 | 6167.0 |
| 2024-06-26 | ABR.E | Stock | 18.0 | 18.06 | 18.0 | 18.05 | 15513.0 |
| 2024-06-26 | ABR.F | Stock | 20.3 | 20.3 | 19.75 | 19.76 | 19315.0 |
| 2024-06-26 | ABSI | Stock | 2.92 | 3.11 | 2.9 | 3.07 | 1313900.0 |
| 2024-06-26 | ABT | Stock | 105.09 | 105.65 | 104.32 | 104.88 | 5406600.0 |
| 2024-06-26 | ABTC | Stock | 85.5 | 90.0 | 81.75 | 85.5 | 7504.0 |
| 2024-06-26 | ABTS | Stock | 7.2 | 7.725 | 6.495 | 7.485 | 587.0 |
| 2024-06-26 | ABUS | Stock | 3.02 | 3.03 | 2.95 | 3.01 | 645300.0 |
> showing 50 of 7,209 rows — these rows as CSV