PREVIEW / stock_daily / 2010-12-17
file: by_date/stock_daily/2010/2010-12-17.parquet size: 197 KB rows: 6,065 symbols: 3,558
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-17 | AAPL | Stock | 11.4868 | 11.4925 | 11.4368 | 11.4504 | 386929200.0 |
| 2010-12-17 | MSFT | Stock | 27.92 | 28.09 | 27.75 | 27.9 | 87456500.0 |
| 2010-12-17 | NVDA | Stock | 0.3575 | 0.3612 | 0.3533 | 0.3592 | 593156000.0 |
| 2010-12-17 | AMZN | Stock | 8.9205 | 8.9375 | 8.851 | 8.879 | 90146000.0 |
| 2010-12-17 | TSLA | Stock | 2.0893 | 2.1027 | 2.0473 | 2.0907 | 12195000.0 |
| 2010-12-17 | TLT | Stock | 91.88 | 93.77 | 91.86 | 93.24 | 16850636.0 |
| 2010-12-17 | ES | Stock | 31.81 | 31.91 | 31.67 | 31.88 | 1560700.0 |
| 2010-12-17 | CL | Stock | 40.515 | 40.625 | 40.32 | 40.5 | 7349000.0 |
| 2010-12-17 | A | Stock | 28.4406 | 29.3205 | 28.319 | 28.9986 | 9358631.0 |
| 2010-12-17 | AABA-DELISTED | Stock | 16.52 | 16.655 | 16.32 | 16.33 | 23391966.0 |
| 2010-12-17 | AACC-DELISTED | Stock | 6.02 | 6.02 | 5.75 | 5.75 | 92215.0 |
| 2010-12-17 | AAI-DELISTED | Stock | 7.4 | 7.44 | 7.39 | 7.42 | 3001121.0 |
| 2010-12-17 | AAIC-DELISTED | Stock | 23.77 | 24.13 | 23.2 | 24.11 | 118981.0 |
| 2010-12-17 | AAME | Stock | 1.98 | 1.98 | 1.98 | 1.98 | 300.0 |
| 2010-12-17 | AAON | Stock | 5.7027 | 5.7185 | 5.604 | 5.6198 | 748744.0 |
| 2010-12-17 | AAP | Stock | 67.75 | 67.77 | 66.54 | 66.79 | 1488000.0 |
| 2010-12-17 | AATI-DELISTED | Stock | 3.97 | 4.0 | 3.92 | 3.97 | 286305.0 |
| 2010-12-17 | AAU-DELISTED | Stock | 4.36 | 4.6944 | 4.3257 | 4.68 | 786090.0 |
| 2010-12-17 | AAUAF-DELISTED | Stock | 4.37 | 4.71 | 4.34 | 4.67 | 784076.0 |
| 2010-12-17 | AAV-DELISTED | Stock | 6.44 | 6.44 | 6.25 | 6.26 | 276021.0 |
| 2010-12-17 | AAWW-DELISTED | Stock | 57.0 | 57.21 | 56.4 | 56.8 | 258231.0 |
| 2010-12-17 | AAXJ | Stock | 62.8 | 62.82 | 62.51 | 62.785 | 119604.0 |
| 2010-12-17 | AAXN-DELISTED | Stock | 4.66 | 4.95 | 4.57 | 4.88 | 1315743.0 |
| 2010-12-17 | AB | Stock | 22.8 | 22.9 | 22.5 | 22.62 | 501300.0 |
| 2010-12-17 | ABAC-DELISTED | Stock | 5.27 | 5.75 | 5.27 | 5.75 | 117152.0 |
| 2010-12-17 | ABAX-DELISTED | Stock | 27.21 | 27.9 | 27.09 | 27.8 | 263301.0 |
| 2010-12-17 | ABB-DELISTED | Stock | 21.66 | 21.66 | 21.44 | 21.605 | 1461593.0 |
| 2010-12-17 | ABBC-DELISTED | Stock | 12.0 | 12.0 | 11.61 | 11.67 | 136478.0 |
| 2010-12-17 | ABBNY-DELISTED | Stock | 21.66 | 21.66 | 21.44 | 21.61 | 1499729.0 |
| 2010-12-17 | ABC-DELISTED | Stock | 32.76 | 33.45 | 32.52 | 33.2 | 3864109.0 |
| 2010-12-17 | ABCB | Stock | 10.48 | 10.5 | 10.25 | 10.5 | 108200.0 |
| 2010-12-17 | ABCD-DELISTED | Stock | 3.51 | 3.55 | 3.33 | 3.37 | 71781.0 |
| 2010-12-17 | ABCO-DELISTED | Stock | 24.48 | 24.48 | 24.22 | 24.38 | 156647.0 |
| 2010-12-17 | ABCW-DELISTED | Stock | 1.1405 | 1.1798 | 1.111 | 1.17 | 117190.0 |
| 2010-12-17 | ABD-DELISTED | Stock | 8.5 | 8.5 | 8.25 | 8.32 | 313990.0 |
| 2010-12-17 | ABE-DELISTED | Stock | 18.64 | 18.64 | 18.38 | 18.3975 | 6858.0 |
| 2010-12-17 | ABEO | Stock | 3125.0 | 3162.5 | 3000.0 | 3062.5 | 26.0 |
| 2010-12-17 | ABFS-DELISTED | Stock | 28.0 | 28.0 | 25.72 | 26.09 | 1249006.0 |
| 2010-12-17 | ABG | Stock | 17.04 | 17.04 | 16.58 | 16.87 | 288700.0 |
| 2010-12-17 | ABH-DELISTED | Stock | 0.08 | 0.1 | 0.07 | 0.099 | 110700.0 |
| 2010-12-17 | ABM | Stock | 25.67 | 26.74 | 25.56 | 26.56 | 735300.0 |
| 2010-12-17 | ABMD-DELISTED | Stock | 9.15 | 9.29 | 9.0501 | 9.18 | 663403.0 |
| 2010-12-17 | ABR | Stock | 5.22 | 5.5 | 5.17 | 5.5 | 160700.0 |
| 2010-12-17 | ABT | Stock | 23.3279 | 23.3279 | 23.0112 | 23.2223 | 21597332.0 |
| 2010-12-17 | ABTL-DELISTED | Stock | 4.3 | 4.3505 | 4.158 | 4.3 | 2410.0 |
| 2010-12-17 | ABUS | Stock | 4.66 | 4.66 | 4.6 | 4.66 | 24400.0 |
| 2010-12-17 | ABV-DELISTED | Stock | 145.09 | 145.31 | 143.63 | 145.13 | 537772.0 |
| 2010-12-17 | ABVA-DELISTED | Stock | 3.5 | 3.518 | 3.5 | 3.518 | 4013.0 |
| 2010-12-17 | ABVT-DELISTED | Stock | 56.64 | 56.84 | 56.4 | 56.66 | 159498.0 |
| 2010-12-17 | ABX-DELISTED | Stock | 51.95 | 52.0 | 50.65 | 51.62 | 7493733.0 |
> showing 50 of 6,065 rows — these rows as CSV