PREVIEW / stock_daily / 2024-05-07
file: by_date/stock_daily/2024/2024-05-07.parquet size: 231 KB rows: 7,206 symbols: 980
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-07 | AAPL | Stock | 183.45 | 184.9 | 181.32 | 182.4 | 77305800.0 |
| 2024-05-07 | MSFT | Stock | 414.66 | 414.67 | 409.09 | 409.34 | 20018200.0 |
| 2024-05-07 | NVDA | Stock | 91.098 | 91.781 | 89.011 | 90.554 | 437342000.0 |
| 2024-05-07 | AMZN | Stock | 188.92 | 189.94 | 187.31 | 188.76 | 34048900.0 |
| 2024-05-07 | GOOGL | Stock | 168.5 | 171.76 | 168.39 | 171.25 | 28039696.0 |
| 2024-05-07 | META | Stock | 466.29 | 471.53 | 461.31 | 468.24 | 13406800.0 |
| 2024-05-07 | TSLA | Stock | 182.4 | 183.26 | 177.4 | 177.81 | 75045900.0 |
| 2024-05-07 | TLT | Stock | 90.9 | 91.24 | 90.6141 | 90.74 | 30525831.0 |
| 2024-05-07 | ES | Stock | 60.13 | 61.26 | 60.03 | 61.17 | 2076200.0 |
| 2024-05-07 | CL | Stock | 93.58 | 94.21 | 93.15 | 94.08 | 4008300.0 |
| 2024-05-07 | A | Stock | 141.12 | 142.15 | 139.76 | 141.27 | 1486800.0 |
| 2024-05-07 | AA | Stock | 37.17 | 37.79 | 37.13 | 37.57 | 3073800.0 |
| 2024-05-07 | AACG | Stock | 0.87 | 0.92 | 0.82 | 0.86 | 17900.0 |
| 2024-05-07 | AACIW-DELISTED | Stock | 0.1651 | 0.1651 | 0.1381 | 0.14009 | 174703.0 |
| 2024-05-07 | AACT | Stock | 10.63 | 10.63 | 10.62 | 10.62 | 35000.0 |
| 2024-05-07 | AAGR-DELISTED | Stock | 0.38447 | 0.4 | 0.3803 | 0.382 | 19662.0 |
| 2024-05-07 | AAGRW-DELISTED | Stock | 0.013 | 0.013 | 0.013 | 0.013 | 521.0 |
| 2024-05-07 | AAL | Stock | 14.54 | 14.63 | 14.14 | 14.25 | 25770500.0 |
| 2024-05-07 | AAMC-DELISTED | Stock | 2.77 | 3.35 | 2.77 | 3.1 | 12500.0 |
| 2024-05-07 | AAME | Stock | 1.9 | 1.9 | 1.76 | 1.76 | 17900.0 |
| 2024-05-07 | AAMI | Stock | 22.72 | 22.788 | 22.32 | 22.37 | 206900.0 |
| 2024-05-07 | AAN-DELISTED | Stock | 6.75 | 7.54 | 6.622 | 7.28 | 448400.0 |
| 2024-05-07 | AAOI | Stock | 11.95 | 12.44 | 11.35 | 11.66 | 2720000.0 |
| 2024-05-07 | AAON | Stock | 76.27 | 78.62 | 75.01 | 78.46 | 13640200.0 |
| 2024-05-07 | AAP | Stock | 74.3 | 75.54 | 73.84 | 74.51 | 725100.0 |
| 2024-05-07 | AAT | Stock | 21.82 | 22.25 | 21.82 | 22.03 | 352200.0 |
| 2024-05-07 | AATC | Stock | 6.58 | 6.663 | 6.58 | 6.58 | 5927.0 |
| 2024-05-07 | AAUAF-DELISTED | Stock | 0.119 | 0.1236 | 0.119 | 0.1215 | 53544.0 |
| 2024-05-07 | AAXJ | Stock | 70.43 | 70.515 | 70.275 | 70.33 | 826547.0 |
| 2024-05-07 | AB | Stock | 33.0 | 33.0 | 32.31 | 32.65 | 282000.0 |
| 2024-05-07 | ABAT | Stock | 1.38 | 1.3846 | 1.32 | 1.36 | 132040.0 |
| 2024-05-07 | ABBV | Stock | 163.36 | 163.99 | 161.89 | 162.55 | 5301700.0 |
| 2024-05-07 | ABCB | Stock | 49.8 | 50.28 | 49.44 | 49.5 | 233900.0 |
| 2024-05-07 | ABCL | Stock | 4.12 | 4.28 | 3.99 | 4.04 | 2175500.0 |
| 2024-05-07 | ABEO | Stock | 4.8 | 5.07 | 4.54 | 4.56 | 876000.0 |
| 2024-05-07 | ABEV | Stock | 2.46 | 2.47 | 2.44 | 2.46 | 9782500.0 |
| 2024-05-07 | ABG | Stock | 221.73 | 223.77 | 219.3 | 219.3 | 134200.0 |
| 2024-05-07 | ABLLW | Stock | 0.5731 | 0.6 | 0.55 | 0.55 | 27820.0 |
| 2024-05-07 | ABLV | Stock | 1.461 | 1.65 | 1.461 | 1.6 | 4200.0 |
| 2024-05-07 | ABM | Stock | 44.86 | 44.94 | 44.24 | 44.25 | 420300.0 |
| 2024-05-07 | ABNB | Stock | 161.81 | 162.88 | 159.75 | 159.81 | 2916200.0 |
| 2024-05-07 | ABOS | Stock | 3.59 | 3.608 | 3.36 | 3.36 | 140200.0 |
| 2024-05-07 | ABR | Stock | 13.47 | 13.54 | 13.39 | 13.46 | 3621100.0 |
| 2024-05-07 | ABR.D | Stock | 18.78 | 18.78 | 18.2751 | 18.5436 | 12692.0 |
| 2024-05-07 | ABR.E | Stock | 18.23 | 18.39 | 18.02 | 18.19 | 15163.0 |
| 2024-05-07 | ABR.F | Stock | 19.8 | 19.8 | 19.5653 | 19.75 | 12010.0 |
| 2024-05-07 | ABSI | Stock | 5.24 | 5.24 | 4.95 | 5.0 | 805500.0 |
| 2024-05-07 | ABT | Stock | 106.52 | 106.6 | 105.79 | 106.17 | 6556400.0 |
| 2024-05-07 | ABTC | Stock | 120.0 | 123.75 | 105.75 | 110.25 | 8358.666666666666 |
| 2024-05-07 | ABTS | Stock | 12.0 | 12.15 | 11.715 | 12.15 | 1107.0 |
> showing 50 of 7,206 rows — these rows as CSV