PREVIEW / stock_daily / 2007-05-03
file: by_date/stock_daily/2007/2007-05-03.parquet size: 167 KB rows: 5,050 symbols: 3,120
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-03 | AAPL | Stock | 3.5975 | 3.6232 | 3.5718 | 3.5857 | 576077600.0 |
| 2007-05-03 | MSFT | Stock | 30.6 | 31.0 | 30.53 | 30.97 | 82036800.0 |
| 2007-05-03 | NVDA | Stock | 0.5527 | 0.5615 | 0.5517 | 0.5578 | 500250000.0 |
| 2007-05-03 | AMZN | Stock | 3.054 | 3.127 | 3.038 | 3.1095 | 269640000.0 |
| 2007-05-03 | TLT | Stock | 88.37 | 88.37 | 88.01 | 88.24 | 427618.0 |
| 2007-05-03 | CL | Stock | 34.015 | 34.06 | 33.565 | 33.73 | 5982000.0 |
| 2007-05-03 | A | Stock | 25.9943 | 26.1588 | 25.8941 | 26.073 | 3612013.0 |
| 2007-05-03 | AABA-DELISTED | Stock | 28.25 | 28.5 | 28.01 | 28.19 | 18837793.0 |
| 2007-05-03 | AACC-DELISTED | Stock | 18.48 | 18.64 | 18.36 | 18.47 | 280811.0 |
| 2007-05-03 | AAI-DELISTED | Stock | 11.55 | 11.77 | 11.45 | 11.53 | 1375082.0 |
| 2007-05-03 | AAIC-DELISTED | Stock | 110.4 | 111.0 | 109.6 | 110.8 | 1681500.0 |
| 2007-05-03 | AAME | Stock | 5.31 | 5.31 | 5.16 | 5.3 | 8200.0 |
| 2007-05-03 | AAON | Stock | 3.441 | 3.4555 | 3.3765 | 3.4265 | 114666.0 |
| 2007-05-03 | AAP | Stock | 41.25 | 41.29 | 40.59 | 40.73 | 518100.0 |
| 2007-05-03 | AATI-DELISTED | Stock | 7.99 | 8.07 | 7.97 | 8.02 | 475414.0 |
| 2007-05-03 | AAU-DELISTED | Stock | 2.54 | 2.55 | 2.46 | 2.46 | 66200.0 |
| 2007-05-03 | AAUAF-DELISTED | Stock | 2.54 | 2.55 | 2.46 | 2.46 | 66200.0 |
| 2007-05-03 | AAV-DELISTED | Stock | 11.39 | 11.53 | 11.39 | 11.5 | 585500.0 |
| 2007-05-03 | AAWW-DELISTED | Stock | 58.79 | 58.79 | 57.5 | 58.19 | 131123.0 |
| 2007-05-03 | AAXN-DELISTED | Stock | 9.38 | 9.65 | 9.32 | 9.43 | 4211082.0 |
| 2007-05-03 | AB | Stock | 91.62 | 92.94 | 91.25 | 92.22 | 197500.0 |
| 2007-05-03 | ABAX-DELISTED | Stock | 23.4 | 23.4 | 22.79 | 22.95 | 315445.0 |
| 2007-05-03 | ABB-DELISTED | Stock | 19.99 | 20.07 | 19.85 | 20.05 | 2488650.0 |
| 2007-05-03 | ABBC-DELISTED | Stock | 18.88 | 18.95 | 18.52 | 18.54 | 19064.0 |
| 2007-05-03 | ABBNY-DELISTED | Stock | 19.99 | 20.07 | 19.85 | 20.04 | 2507650.0 |
| 2007-05-03 | ABC-DELISTED | Stock | 25.56 | 25.8 | 25.38 | 25.72 | 2479000.0 |
| 2007-05-03 | ABCB | Stock | 23.5185 | 24.0826 | 23.5185 | 23.6935 | 30124.0 |
| 2007-05-03 | ABCO-DELISTED | Stock | 23.92 | 23.95 | 23.59 | 23.79 | 269629.0 |
| 2007-05-03 | ABCW-DELISTED | Stock | 28.21 | 28.32 | 28.06 | 28.13 | 53550.0 |
| 2007-05-03 | ABD-DELISTED | Stock | 22.58 | 23.15 | 22.41 | 22.62 | 889620.0 |
| 2007-05-03 | ABE-DELISTED | Stock | 20.74 | 21.3 | 20.74 | 20.92 | 27500.0 |
| 2007-05-03 | ABFS-DELISTED | Stock | 40.01 | 40.55 | 39.52 | 39.59 | 482830.0 |
| 2007-05-03 | ABG | Stock | 28.45 | 28.59 | 28.18 | 28.44 | 812600.0 |
| 2007-05-03 | ABK-DELISTED | Stock | 93.52 | 94.77 | 93.47 | 94.65 | 917900.0 |
| 2007-05-03 | ABM | Stock | 28.8 | 28.9 | 28.45 | 28.8 | 197400.0 |
| 2007-05-03 | ABMD-DELISTED | Stock | 13.18 | 13.27 | 12.78 | 12.87 | 137521.0 |
| 2007-05-03 | ABP-DELISTED | Stock | 3.5 | 3.52 | 3.45 | 3.5 | 91200.0 |
| 2007-05-03 | ABR | Stock | 30.99 | 31.2 | 30.79 | 30.94 | 68300.0 |
| 2007-05-03 | ABT | Stock | 27.5213 | 27.5885 | 27.3966 | 27.5453 | 7475198.0 |
| 2007-05-03 | ABTL-DELISTED | Stock | 18.149 | 18.696 | 18.05 | 18.05 | 18216.0 |
| 2007-05-03 | ABV-DELISTED | Stock | 60.53 | 62.61 | 60.53 | 62.15 | 518800.0 |
| 2007-05-03 | ABVA-DELISTED | Stock | 14.25 | 14.45 | 14.25 | 14.35 | 12785.0 |
| 2007-05-03 | ABX-DELISTED | Stock | 29.75 | 30.55 | 29.39 | 30.34 | 10561450.0 |
| 2007-05-03 | ACAD | Stock | 13.48 | 13.62 | 13.26 | 13.32 | 398200.0 |
| 2007-05-03 | ACAP-DELISTED | Stock | 40.48 | 40.99 | 40.48 | 40.76 | 79244.0 |
| 2007-05-03 | ACAS-DELISTED | Stock | 45.31 | 46.81 | 45.31 | 46.57 | 2109837.0 |
| 2007-05-03 | ACAT-DELISTED | Stock | 18.585 | 18.966 | 18.465 | 18.465 | 77134.0 |
| 2007-05-03 | ACC-DELISTED | Stock | 29.85 | 30.05 | 29.53 | 29.55 | 149517.0 |
| 2007-05-03 | ACCL-DELISTED | Stock | 6.42 | 6.53 | 6.41 | 6.53 | 18136.0 |
| 2007-05-03 | ACCO | Stock | 22.58 | 23.15 | 22.41 | 22.62 | 890200.0 |
> showing 50 of 5,050 rows — these rows as CSV