PREVIEW / stock_daily / 2024-05-06
file: by_date/stock_daily/2024/2024-05-06.parquet size: 232 KB rows: 7,230 symbols: 983
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-05-06 | AAPL | Stock | 182.35 | 184.2 | 180.42 | 181.71 | 78569700.0 |
| 2024-05-06 | MSFT | Stock | 408.76 | 413.93 | 406.37 | 413.54 | 16996600.0 |
| 2024-05-06 | NVDA | Stock | 89.39 | 92.22 | 89.055 | 92.14 | 376203000.0 |
| 2024-05-06 | AMZN | Stock | 186.28 | 188.75 | 184.8 | 188.7 | 34725300.0 |
| 2024-05-06 | GOOGL | Stock | 167.46 | 168.14 | 166.03 | 168.1 | 21871283.0 |
| 2024-05-06 | META | Stock | 455.58 | 466.16 | 453.34 | 465.68 | 15094600.0 |
| 2024-05-06 | TSLA | Stock | 183.8 | 187.56 | 182.2 | 184.76 | 84390300.0 |
| 2024-05-06 | TLT | Stock | 89.87 | 90.25 | 89.67 | 90.19 | 23868185.0 |
| 2024-05-06 | ES | Stock | 60.22 | 60.43 | 59.56 | 59.71 | 1751100.0 |
| 2024-05-06 | CL | Stock | 93.22 | 93.3 | 92.45 | 93.18 | 3181900.0 |
| 2024-05-06 | A | Stock | 139.54 | 141.47 | 138.34 | 140.61 | 1639400.0 |
| 2024-05-06 | AA | Stock | 37.33 | 37.938 | 37.005 | 37.32 | 3769500.0 |
| 2024-05-06 | AACG | Stock | 0.9 | 0.92 | 0.86 | 0.87 | 52300.0 |
| 2024-05-06 | AACIW-DELISTED | Stock | 0.145 | 0.17 | 0.145 | 0.1525 | 41402.0 |
| 2024-05-06 | AACT | Stock | 10.64 | 10.64 | 10.62 | 10.62 | 29300.0 |
| 2024-05-06 | AAGR-DELISTED | Stock | 0.36 | 0.4023 | 0.343 | 0.4005 | 224998.0 |
| 2024-05-06 | AAGRW-DELISTED | Stock | 0.0112 | 0.0139 | 0.0112 | 0.0125 | 11486.0 |
| 2024-05-06 | AAL | Stock | 13.92 | 14.75 | 13.92 | 14.65 | 46744300.0 |
| 2024-05-06 | AAMC-DELISTED | Stock | 3.1 | 3.1 | 3.1 | 3.1 | 1300.0 |
| 2024-05-06 | AAME | Stock | 1.87 | 1.9 | 1.81 | 1.81 | 3900.0 |
| 2024-05-06 | AAMI | Stock | 22.69 | 22.8 | 22.34 | 22.56 | 201100.0 |
| 2024-05-06 | AAN-DELISTED | Stock | 7.03 | 7.12 | 7.0 | 7.02 | 135200.0 |
| 2024-05-06 | AAOI | Stock | 11.28 | 12.4 | 11.26 | 11.95 | 2963900.0 |
| 2024-05-06 | AAON | Stock | 75.22 | 80.59 | 74.08 | 76.2 | 3259600.0 |
| 2024-05-06 | AAP | Stock | 76.83 | 77.09 | 73.69 | 73.86 | 1361100.0 |
| 2024-05-06 | AAT | Stock | 21.7 | 21.79 | 21.58 | 21.73 | 174700.0 |
| 2024-05-06 | AATC | Stock | 6.6 | 6.6 | 6.55 | 6.57 | 2120.0 |
| 2024-05-06 | AAUAF-DELISTED | Stock | 0.119 | 0.1244 | 0.119 | 0.1217 | 56712.0 |
| 2024-05-06 | AAXJ | Stock | 70.82 | 70.88 | 70.63 | 70.85 | 241355.0 |
| 2024-05-06 | AB | Stock | 33.29 | 33.4 | 32.8 | 33.13 | 269100.0 |
| 2024-05-06 | ABAT | Stock | 1.4 | 1.4 | 1.32 | 1.36 | 256990.0 |
| 2024-05-06 | ABBV | Stock | 164.41 | 164.63 | 161.0 | 162.73 | 5834600.0 |
| 2024-05-06 | ABCB | Stock | 49.99 | 50.32 | 49.69 | 49.75 | 207400.0 |
| 2024-05-06 | ABCL | Stock | 4.14 | 4.175 | 4.03 | 4.11 | 1823900.0 |
| 2024-05-06 | ABEO | Stock | 4.75 | 4.96 | 4.43 | 4.78 | 2437800.0 |
| 2024-05-06 | ABEV | Stock | 2.42 | 2.45 | 2.41 | 2.44 | 9697100.0 |
| 2024-05-06 | ABG | Stock | 216.42 | 221.7 | 216.42 | 221.6 | 150000.0 |
| 2024-05-06 | ABLLW | Stock | 0.58 | 0.58 | 0.57 | 0.57 | 1258.0 |
| 2024-05-06 | ABLV | Stock | 1.45 | 1.47 | 1.44 | 1.44 | 6400.0 |
| 2024-05-06 | ABM | Stock | 45.06 | 45.28 | 44.44 | 44.59 | 337200.0 |
| 2024-05-06 | ABNB | Stock | 161.0 | 162.41 | 160.17 | 162.0 | 2912200.0 |
| 2024-05-06 | ABOS | Stock | 3.53 | 3.65 | 3.47 | 3.56 | 177300.0 |
| 2024-05-06 | ABR | Stock | 13.01 | 13.42 | 13.01 | 13.42 | 4590900.0 |
| 2024-05-06 | ABR.D | Stock | 18.47 | 18.8 | 18.45 | 18.66 | 6703.0 |
| 2024-05-06 | ABR.E | Stock | 18.06 | 18.25 | 18.06 | 18.22 | 14219.0 |
| 2024-05-06 | ABR.F | Stock | 19.5 | 19.57 | 19.44 | 19.55 | 13768.0 |
| 2024-05-06 | ABSI | Stock | 5.17 | 5.265 | 5.08 | 5.21 | 476800.0 |
| 2024-05-06 | ABT | Stock | 106.11 | 106.17 | 105.14 | 105.64 | 3789500.0 |
| 2024-05-06 | ABTC | Stock | 114.75 | 119.25 | 109.5 | 113.25 | 3228.0 |
| 2024-05-06 | ABTS | Stock | 11.625 | 12.27 | 11.4 | 11.94 | 2413.0 |
> showing 50 of 7,230 rows — these rows as CSV