PREVIEW / stock_daily / 2010-06-07
file: by_date/stock_daily/2010/2010-06-07.parquet size: 189 KB rows: 5,943 symbols: 3,499
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-06-07 | AAPL | Stock | 9.2246 | 9.2554 | 8.9482 | 8.9621 | 886942000.0 |
| 2010-06-07 | MSFT | Stock | 25.82 | 25.83 | 25.24 | 25.29 | 80456200.0 |
| 2010-06-07 | NVDA | Stock | 0.3038 | 0.3058 | 0.2862 | 0.2875 | 577248000.0 |
| 2010-06-07 | AMZN | Stock | 6.292 | 6.3305 | 6.0835 | 6.1005 | 131328000.0 |
| 2010-06-07 | TLT | Stock | 97.52 | 98.59 | 97.33 | 98.54 | 5288171.0 |
| 2010-06-07 | ES | Stock | 25.36 | 25.7 | 25.27 | 25.3 | 1236300.0 |
| 2010-06-07 | CL | Stock | 38.605 | 39.25 | 38.605 | 38.82 | 5416600.0 |
| 2010-06-07 | A | Stock | 21.8383 | 21.9528 | 21.5093 | 21.5308 | 5700625.0 |
| 2010-06-07 | AABA-DELISTED | Stock | 15.19 | 15.355 | 14.94 | 14.94 | 18946106.0 |
| 2010-06-07 | AACC-DELISTED | Stock | 5.14 | 5.15 | 4.75 | 4.81 | 228375.0 |
| 2010-06-07 | AACG | Stock | 3.25 | 3.36 | 3.22 | 3.36 | 4100.0 |
| 2010-06-07 | AAI-DELISTED | Stock | 5.66 | 5.79 | 5.57 | 5.6 | 4271645.0 |
| 2010-06-07 | AAIC-DELISTED | Stock | 18.75 | 18.9 | 18.66 | 18.7225 | 43915.0 |
| 2010-06-07 | AAME | Stock | 1.32 | 1.32 | 1.32 | 1.32 | 1700.0 |
| 2010-06-07 | AAON | Stock | 4.5531 | 4.6617 | 4.5156 | 4.5294 | 390825.0 |
| 2010-06-07 | AAP | Stock | 50.42 | 50.44 | 48.52 | 48.6 | 2760200.0 |
| 2010-06-07 | AATI-DELISTED | Stock | 3.62 | 3.63 | 3.4 | 3.4 | 272872.0 |
| 2010-06-07 | AAU-DELISTED | Stock | 0.93 | 0.9687 | 0.9035 | 0.9685 | 148390.0 |
| 2010-06-07 | AAUAF-DELISTED | Stock | 0.93 | 0.9671 | 0.902 | 0.9669 | 149729.0 |
| 2010-06-07 | AAV-DELISTED | Stock | 6.24 | 6.43 | 6.15 | 6.18 | 429099.0 |
| 2010-06-07 | AAWW-DELISTED | Stock | 49.53 | 50.1 | 47.3 | 47.42 | 328781.0 |
| 2010-06-07 | AAXJ | Stock | 51.75 | 51.75 | 50.53 | 50.53 | 365617.0 |
| 2010-06-07 | AAXN-DELISTED | Stock | 4.29 | 4.35 | 4.12 | 4.12 | 818396.0 |
| 2010-06-07 | AB | Stock | 28.25 | 28.25 | 27.33 | 27.6 | 573300.0 |
| 2010-06-07 | ABAX-DELISTED | Stock | 21.76 | 21.97 | 21.19 | 21.25 | 116850.0 |
| 2010-06-07 | ABB-DELISTED | Stock | 16.63 | 16.73 | 16.26 | 16.3 | 2731097.0 |
| 2010-06-07 | ABBC-DELISTED | Stock | 8.75 | 8.85 | 8.66 | 8.67 | 69245.0 |
| 2010-06-07 | ABBNY-DELISTED | Stock | 16.63 | 16.73 | 16.26 | 16.27 | 3050600.0 |
| 2010-06-07 | ABC-DELISTED | Stock | 30.87 | 31.27 | 30.5 | 30.75 | 5406437.0 |
| 2010-06-07 | ABCB | Stock | 10.4005 | 10.6095 | 10.3507 | 10.3507 | 85003.0 |
| 2010-06-07 | ABCD-DELISTED | Stock | 4.61 | 4.69 | 4.26 | 4.63 | 16306.0 |
| 2010-06-07 | ABCO-DELISTED | Stock | 18.918 | 19.058 | 18.817 | 18.827 | 170167.0 |
| 2010-06-07 | ABCW-DELISTED | Stock | 0.78 | 0.81 | 0.75 | 0.81 | 35070.0 |
| 2010-06-07 | ABD-DELISTED | Stock | 6.105 | 6.2051 | 5.9449 | 6.105 | 556150.0 |
| 2010-06-07 | ABE-DELISTED | Stock | 15.12 | 15.19 | 15.01 | 15.01 | 13780.0 |
| 2010-06-07 | ABEO | Stock | 2900.0 | 2987.5 | 2862.5 | 2987.5 | 15.0 |
| 2010-06-07 | ABFS-DELISTED | Stock | 22.11 | 22.44 | 20.89 | 20.9 | 626728.0 |
| 2010-06-07 | ABG | Stock | 12.65 | 12.68 | 11.67 | 11.7 | 286800.0 |
| 2010-06-07 | ABII-DELISTED | Stock | 55.73 | 56.9999 | 53.26 | 53.7 | 182646.0 |
| 2010-06-07 | ABK-DELISTED | Stock | 1.16 | 1.17 | 1.01 | 1.03 | 21521894.0 |
| 2010-06-07 | ABM | Stock | 20.52 | 20.72 | 20.1 | 20.3 | 914800.0 |
| 2010-06-07 | ABMD-DELISTED | Stock | 9.62 | 9.68 | 9.38 | 9.5725 | 331033.0 |
| 2010-06-07 | ABR | Stock | 4.11 | 4.36 | 4.04 | 4.3 | 553900.0 |
| 2010-06-07 | ABT | Stock | 22.2339 | 22.3683 | 22.162 | 22.1812 | 19413506.0 |
| 2010-06-07 | ABTL-DELISTED | Stock | 5.75 | 6.05 | 5.6 | 5.85 | 51412.0 |
| 2010-06-07 | ABV-DELISTED | Stock | 95.64 | 96.72 | 95.28 | 95.63 | 824574.0 |
| 2010-06-07 | ABVT-DELISTED | Stock | 45.09 | 45.09 | 43.57 | 43.66 | 88076.0 |
| 2010-06-07 | ABX-DELISTED | Stock | 41.49 | 43.57 | 41.13 | 43.14 | 12255459.0 |
| 2010-06-07 | ACAD | Stock | 1.29 | 1.34 | 1.23 | 1.28 | 368300.0 |
| 2010-06-07 | ACAP-DELISTED | Stock | 29.72 | 29.96 | 29.35 | 29.38 | 27879.0 |
> showing 50 of 5,943 rows — these rows as CSV