PREVIEW / stock_daily / 2009-11-17
file: by_date/stock_daily/2009/2009-11-17.parquet size: 188 KB rows: 5,892 symbols: 3,496
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-17 | AAPL | Stock | 7.36 | 7.4086 | 7.3214 | 7.3929 | 396513600.0 |
| 2009-11-17 | MSFT | Stock | 29.5 | 30.0 | 29.47 | 30.0 | 75648900.0 |
| 2009-11-17 | NVDA | Stock | 0.344 | 0.344 | 0.3368 | 0.3433 | 350124000.0 |
| 2009-11-17 | AMZN | Stock | 6.57 | 6.5925 | 6.466 | 6.5625 | 154960000.0 |
| 2009-11-17 | TLT | Stock | 94.99 | 95.8 | 94.81 | 95.53 | 3174312.0 |
| 2009-11-17 | ES | Stock | 23.84 | 24.1 | 23.71 | 23.98 | 1307600.0 |
| 2009-11-17 | CL | Stock | 41.18 | 41.445 | 41.025 | 41.42 | 4297400.0 |
| 2009-11-17 | A | Stock | 20.7797 | 21.2518 | 20.7797 | 21.1946 | 4435435.0 |
| 2009-11-17 | AABA-DELISTED | Stock | 15.92 | 16.11 | 15.73 | 16.05 | 22044873.0 |
| 2009-11-17 | AACC-DELISTED | Stock | 5.27 | 5.39 | 5.18 | 5.3 | 11490.0 |
| 2009-11-17 | AACG | Stock | 4.4 | 4.89 | 4.4 | 4.89 | 12900.0 |
| 2009-11-17 | AAI-DELISTED | Stock | 4.56 | 4.58 | 4.47 | 4.51 | 1824728.0 |
| 2009-11-17 | AAIC-DELISTED | Stock | 12.75 | 12.95 | 12.75 | 12.82 | 13554.0 |
| 2009-11-17 | AAME | Stock | 1.34 | 1.34 | 1.25 | 1.26 | 5800.0 |
| 2009-11-17 | AAON | Stock | 4.0237 | 4.0751 | 3.9328 | 4.0257 | 381712.0 |
| 2009-11-17 | AAP | Stock | 39.6 | 40.2 | 39.44 | 39.86 | 2160100.0 |
| 2009-11-17 | AATI-DELISTED | Stock | 3.09 | 3.11 | 3.01 | 3.04 | 287283.0 |
| 2009-11-17 | AAU-DELISTED | Stock | 0.77 | 0.77 | 0.7205 | 0.76 | 123414.0 |
| 2009-11-17 | AAUAF-DELISTED | Stock | 0.77 | 0.77 | 0.7205 | 0.76 | 123914.0 |
| 2009-11-17 | AAV-DELISTED | Stock | 6.27 | 6.27 | 6.02 | 6.17 | 724527.0 |
| 2009-11-17 | AAWW-DELISTED | Stock | 29.6 | 29.98 | 29.5 | 29.59 | 251011.0 |
| 2009-11-17 | AAXJ | Stock | 55.77 | 56.6 | 55.76 | 56.6 | 583797.0 |
| 2009-11-17 | AAXN-DELISTED | Stock | 4.21 | 4.28 | 4.19 | 4.23 | 269830.0 |
| 2009-11-17 | AB | Stock | 27.27 | 27.27 | 26.84 | 27.0 | 473400.0 |
| 2009-11-17 | ABAX-DELISTED | Stock | 23.8 | 23.96 | 23.392 | 23.69 | 60505.0 |
| 2009-11-17 | ABB-DELISTED | Stock | 19.12 | 19.22 | 18.93 | 19.19 | 4163743.0 |
| 2009-11-17 | ABBC-DELISTED | Stock | 7.1 | 7.13 | 6.86 | 7.13 | 31166.0 |
| 2009-11-17 | ABBNY-DELISTED | Stock | 19.12 | 19.22 | 18.93 | 19.21 | 4317666.0 |
| 2009-11-17 | ABC-DELISTED | Stock | 24.51 | 24.52 | 24.21 | 24.27 | 2242955.0 |
| 2009-11-17 | ABCB | Stock | 5.9396 | 6.2042 | 5.6945 | 6.1944 | 64176.0 |
| 2009-11-17 | ABCO-DELISTED | Stock | 13.253 | 13.253 | 13.067 | 13.067 | 138402.0 |
| 2009-11-17 | ABCW-DELISTED | Stock | 0.62 | 1.32 | 0.62 | 0.9 | 3061430.0 |
| 2009-11-17 | ABD-DELISTED | Stock | 6.69 | 7.02 | 6.53 | 6.93 | 260580.0 |
| 2009-11-17 | ABE-DELISTED | Stock | 16.95 | 17.01 | 16.837 | 16.91 | 6319.0 |
| 2009-11-17 | ABEO | Stock | 3687.5 | 3925.0 | 3625.0 | 3925.0 | 12.0 |
| 2009-11-17 | ABFS-DELISTED | Stock | 25.76 | 25.94 | 25.14 | 25.46 | 482139.0 |
| 2009-11-17 | ABG | Stock | 10.66 | 10.77 | 10.35 | 10.57 | 219300.0 |
| 2009-11-17 | ABII-DELISTED | Stock | 33.92 | 35.515 | 33.6 | 34.21 | 29560.0 |
| 2009-11-17 | ABK-DELISTED | Stock | 0.7525 | 0.7794 | 0.7 | 0.7003 | 15595856.0 |
| 2009-11-17 | ABM | Stock | 19.5 | 19.9 | 19.44 | 19.78 | 101300.0 |
| 2009-11-17 | ABMD-DELISTED | Stock | 8.95 | 9.16 | 8.95 | 9.13 | 155454.0 |
| 2009-11-17 | ABR | Stock | 1.88 | 1.89 | 1.75 | 1.76 | 234500.0 |
| 2009-11-17 | ABT | Stock | 25.7269 | 25.7269 | 25.4678 | 25.5781 | 11656107.0 |
| 2009-11-17 | ABTL-DELISTED | Stock | 3.75 | 4.15 | 3.75 | 4.15 | 7334.0 |
| 2009-11-17 | ABV-DELISTED | Stock | 101.15 | 102.54 | 100.01 | 102.22 | 956638.0 |
| 2009-11-17 | ABVT-DELISTED | Stock | 56.55 | 56.77 | 55.95 | 56.27 | 340662.0 |
| 2009-11-17 | ABX-DELISTED | Stock | 43.3 | 45.13 | 43.09 | 45.11 | 12398625.0 |
| 2009-11-17 | ACAD | Stock | 1.45 | 1.45 | 1.4 | 1.4 | 213100.0 |
| 2009-11-17 | ACAP-DELISTED | Stock | 28.51 | 28.66 | 27.99 | 28.33 | 28748.0 |
| 2009-11-17 | ACAS-DELISTED | Stock | 2.89 | 2.9 | 2.87 | 2.89 | 3172159.0 |
> showing 50 of 5,892 rows — these rows as CSV