PREVIEW / stock_daily / 2024-06-06
file: by_date/stock_daily/2024/2024-06-06.parquet size: 231 KB rows: 7,207 symbols: 966
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-06 | AAPL | Stock | 195.69 | 196.5 | 194.17 | 194.48 | 41181800.0 |
| 2024-06-06 | MSFT | Stock | 424.01 | 425.31 | 420.58 | 424.52 | 14861300.0 |
| 2024-06-06 | NVDA | Stock | 124.048 | 125.587 | 118.32 | 120.998 | 664696000.0 |
| 2024-06-06 | AMZN | Stock | 181.75 | 185.0 | 181.49 | 185.0 | 31371200.0 |
| 2024-06-06 | GOOGL | Stock | 175.895 | 177.15 | 175.75 | 176.73 | 23251013.0 |
| 2024-06-06 | META | Stock | 492.98 | 502.82 | 490.89 | 493.76 | 10667300.0 |
| 2024-06-06 | TSLA | Stock | 174.6 | 179.73 | 172.73 | 177.94 | 69887000.0 |
| 2024-06-06 | TLT | Stock | 92.92 | 93.43 | 92.86 | 93.21 | 22891863.0 |
| 2024-06-06 | ES | Stock | 59.22 | 60.25 | 58.72 | 58.83 | 1238300.0 |
| 2024-06-06 | CL | Stock | 93.81 | 94.57 | 93.57 | 93.98 | 4217400.0 |
| 2024-06-06 | A | Stock | 132.46 | 134.35 | 132.28 | 132.82 | 2269600.0 |
| 2024-06-06 | AA | Stock | 42.51 | 43.005 | 42.293 | 42.65 | 3154800.0 |
| 2024-06-06 | AACG | Stock | 0.86 | 0.89 | 0.84 | 0.89 | 10600.0 |
| 2024-06-06 | AACIU | Stock | 11.43 | 11.44 | 11.43 | 11.43 | 2300.0 |
| 2024-06-06 | AACIW-DELISTED | Stock | 0.13 | 0.1335 | 0.11 | 0.115 | 58000.0 |
| 2024-06-06 | AACT | Stock | 10.67 | 10.67 | 10.65 | 10.67 | 1355100.0 |
| 2024-06-06 | AAGR-DELISTED | Stock | 0.374 | 0.378 | 0.3445 | 0.3499 | 45039.0 |
| 2024-06-06 | AAGRW-DELISTED | Stock | 0.012 | 0.012 | 0.012 | 0.012 | 649.0 |
| 2024-06-06 | AAL | Stock | 11.58 | 11.73 | 11.32 | 11.43 | 35840600.0 |
| 2024-06-06 | AAMC-DELISTED | Stock | 2.61 | 2.8 | 2.6 | 2.705 | 1900.0 |
| 2024-06-06 | AAME | Stock | 1.82 | 1.82 | 1.76 | 1.81 | 1300.0 |
| 2024-06-06 | AAMI | Stock | 22.49 | 22.62 | 22.34 | 22.54 | 215000.0 |
| 2024-06-06 | AAN-DELISTED | Stock | 8.43 | 8.53 | 8.36 | 8.48 | 285800.0 |
| 2024-06-06 | AAOI | Stock | 10.5 | 10.68 | 10.23 | 10.38 | 1111800.0 |
| 2024-06-06 | AAON | Stock | 73.06 | 73.58 | 71.44 | 72.35 | 660000.0 |
| 2024-06-06 | AAP | Stock | 65.68 | 65.87 | 64.13 | 64.56 | 1031300.0 |
| 2024-06-06 | AAT | Stock | 21.32 | 21.79 | 21.32 | 21.66 | 266300.0 |
| 2024-06-06 | AATC | Stock | 6.22 | 6.22 | 6.13 | 6.175 | 968.0 |
| 2024-06-06 | AAUAF-DELISTED | Stock | 0.05 | 0.09 | 0.05 | 0.079 | 199630.0 |
| 2024-06-06 | AAXJ | Stock | 71.8 | 71.82 | 71.465 | 71.79 | 580852.0 |
| 2024-06-06 | AB | Stock | 33.66 | 34.05 | 33.51 | 33.51 | 96700.0 |
| 2024-06-06 | ABAT | Stock | 1.43 | 1.47 | 1.36 | 1.37 | 322253.0 |
| 2024-06-06 | ABBV | Stock | 165.49 | 168.88 | 164.35 | 168.57 | 5186700.0 |
| 2024-06-06 | ABCB | Stock | 47.45 | 47.8 | 47.13 | 47.61 | 166000.0 |
| 2024-06-06 | ABCL | Stock | 3.78 | 3.88 | 3.715 | 3.78 | 1203800.0 |
| 2024-06-06 | ABEO | Stock | 4.52 | 4.56 | 4.25 | 4.28 | 369300.0 |
| 2024-06-06 | ABEV | Stock | 2.21 | 2.25 | 2.19 | 2.24 | 14828100.0 |
| 2024-06-06 | ABG | Stock | 234.42 | 237.42 | 234.42 | 235.43 | 97000.0 |
| 2024-06-06 | ABLLW | Stock | 0.34 | 0.4375 | 0.34 | 0.395 | 59916.0 |
| 2024-06-06 | ABLV | Stock | 1.13 | 1.28 | 1.13 | 1.28 | 1300.0 |
| 2024-06-06 | ABM | Stock | 49.0 | 49.64 | 47.57 | 48.4 | 857000.0 |
| 2024-06-06 | ABNB | Stock | 145.51 | 148.79 | 145.155 | 147.0 | 3463100.0 |
| 2024-06-06 | ABOS | Stock | 2.6 | 2.67 | 2.46 | 2.49 | 607700.0 |
| 2024-06-06 | ABR | Stock | 14.04 | 14.15 | 13.98 | 14.12 | 2160700.0 |
| 2024-06-06 | ABR.D | Stock | 18.65 | 18.8 | 18.65 | 18.725 | 8322.0 |
| 2024-06-06 | ABR.E | Stock | 18.25 | 18.25 | 18.09 | 18.2 | 4051.0 |
| 2024-06-06 | ABR.F | Stock | 19.71 | 20.1 | 19.71 | 19.78 | 17422.0 |
| 2024-06-06 | ABSI | Stock | 4.62 | 4.65 | 4.24 | 4.37 | 898600.0 |
| 2024-06-06 | ABT | Stock | 103.29 | 105.0 | 102.81 | 104.27 | 9835500.0 |
| 2024-06-06 | ABTC | Stock | 90.75 | 111.75 | 90.0 | 108.0 | 13770.666666666666 |
> showing 50 of 7,207 rows — these rows as CSV