PREVIEW / stock_daily / 2017-08-03
file: by_date/stock_daily/2017/2017-08-03.parquet size: 214 KB rows: 6,450 symbols: 2,959
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 |
|---|---|---|---|---|---|---|---|
| 2017-08-03 | AAPL | Stock | 39.2625 | 39.3025 | 38.755 | 38.8925 | 108389200.0 |
| 2017-08-03 | MSFT | Stock | 72.19 | 72.44 | 71.85 | 72.15 | 18214400.0 |
| 2017-08-03 | NVDA | Stock | 4.1092 | 4.1658 | 4.092 | 4.162 | 442420000.0 |
| 2017-08-03 | AMZN | Stock | 49.9735 | 49.975 | 49.2295 | 49.346 | 65116000.0 |
| 2017-08-03 | GOOGL | Stock | 47.455 | 47.5 | 46.972 | 47.015 | 22478420.0 |
| 2017-08-03 | META | Stock | 169.3 | 169.7 | 168.25 | 168.59 | 10793800.0 |
| 2017-08-03 | TSLA | Stock | 23.022 | 23.3333 | 22.8767 | 23.1393 | 203025000.0 |
| 2017-08-03 | TLT | Stock | 125.29 | 126.02 | 125.26 | 126.0 | 10324510.0 |
| 2017-08-03 | ES | Stock | 60.95 | 61.88 | 60.95 | 61.88 | 1955000.0 |
| 2017-08-03 | CL | Stock | 71.9 | 72.0 | 71.4 | 71.6 | 2660200.0 |
| 2017-08-03 | A | Stock | 60.15 | 60.44 | 59.97 | 60.37 | 982900.0 |
| 2017-08-03 | AA | Stock | 37.28 | 37.6 | 36.94 | 37.09 | 2884600.0 |
| 2017-08-03 | AAAP-DELISTED | Stock | 47.7 | 49.22 | 47.7 | 49.0 | 117880.0 |
| 2017-08-03 | AABA-DELISTED | Stock | 57.87 | 58.33 | 57.13 | 58.16 | 4207530.0 |
| 2017-08-03 | AAC-DELISTED | Stock | 6.5 | 7.37 | 6.072 | 7.29 | 300664.0 |
| 2017-08-03 | AAIC-DELISTED | Stock | 13.12 | 13.17 | 13.06 | 13.09 | 176395.0 |
| 2017-08-03 | AAL | Stock | 50.56 | 51.2 | 50.36 | 50.55 | 3231400.0 |
| 2017-08-03 | AAM.A-DELISTED | Stock | 26.15 | 26.4 | 26.15 | 26.27 | 35423.0 |
| 2017-08-03 | AAMC-DELISTED | Stock | 25.3088 | 25.9118 | 23.0294 | 25.5882 | 33969.0 |
| 2017-08-03 | AAMI | Stock | 14.56 | 14.89 | 14.25 | 14.5 | 893500.0 |
| 2017-08-03 | AAOI | Stock | 95.47 | 98.13 | 93.0 | 97.99 | 6711100.0 |
| 2017-08-03 | AAON | Stock | 22.2667 | 22.5333 | 19.9667 | 22.4667 | 1032750.0 |
| 2017-08-03 | AAP | Stock | 114.27 | 115.4 | 110.45 | 110.53 | 1812700.0 |
| 2017-08-03 | AAT | Stock | 40.44 | 41.02 | 40.23 | 40.3 | 134300.0 |
| 2017-08-03 | AAU-DELISTED | Stock | 1.16 | 1.161 | 1.1 | 1.12 | 275901.0 |
| 2017-08-03 | AAUAF-DELISTED | Stock | 1.16 | 1.161 | 1.1 | 1.12 | 281675.0 |
| 2017-08-03 | AAV-DELISTED | Stock | 6.8 | 6.825 | 6.5 | 6.525 | 112966.0 |
| 2017-08-03 | AAWW-DELISTED | Stock | 67.2 | 67.625 | 64.4 | 65.25 | 331840.0 |
| 2017-08-03 | AAXJ | Stock | 70.8 | 70.89 | 70.555 | 70.86 | 682130.0 |
| 2017-08-03 | AAXN-DELISTED | Stock | 24.75 | 25.06 | 24.75 | 25.02 | 342953.0 |
| 2017-08-03 | AB | Stock | 24.1 | 24.55 | 24.05 | 24.3 | 341600.0 |
| 2017-08-03 | ABAC-DELISTED | Stock | 2.14 | 2.35 | 2.14 | 2.295 | 3439.0 |
| 2017-08-03 | ABAX-DELISTED | Stock | 45.94 | 46.29 | 45.94 | 46.28 | 66075.0 |
| 2017-08-03 | ABB-DELISTED | Stock | 23.54 | 23.63 | 23.43 | 23.48 | 944219.0 |
| 2017-08-03 | ABBNY-DELISTED | Stock | 23.54 | 23.63 | 23.43 | 23.48 | 1013557.0 |
| 2017-08-03 | ABBV | Stock | 70.61 | 71.01 | 70.36 | 70.99 | 4400400.0 |
| 2017-08-03 | ABC-DELISTED | Stock | 84.11 | 85.33 | 80.51 | 81.71 | 6698813.0 |
| 2017-08-03 | ABCB | Stock | 45.7 | 46.15 | 45.38 | 45.45 | 111100.0 |
| 2017-08-03 | ABCD-DELISTED | Stock | 4.8824 | 4.917 | 4.76 | 4.81 | 35544.0 |
| 2017-08-03 | ABCO-DELISTED | Stock | 54.85 | 55.35 | 54.75 | 55.15 | 438697.0 |
| 2017-08-03 | ABDC-DELISTED | Stock | 11.55 | 11.73 | 11.55 | 11.73 | 41947.0 |
| 2017-08-03 | ABE-DELISTED | Stock | 14.1606 | 14.1606 | 14.1606 | 14.1606 | 200.0 |
| 2017-08-03 | ABEO | Stock | 191.25 | 193.75 | 180.0 | 182.5 | 12600.0 |
| 2017-08-03 | ABEV | Stock | 6.17 | 6.18 | 6.12 | 6.15 | 13485500.0 |
| 2017-08-03 | ABG | Stock | 53.5 | 54.35 | 53.3 | 53.35 | 144700.0 |
| 2017-08-03 | ABIL-DELISTED | Stock | 0.7272 | 0.7272 | 0.64 | 0.655 | 93474.0 |
| 2017-08-03 | ABM | Stock | 44.44 | 44.83 | 44.22 | 44.75 | 194100.0 |
| 2017-08-03 | ABMD-DELISTED | Stock | 146.32 | 147.9 | 144.5146 | 147.87 | 225732.0 |
| 2017-08-03 | ABR | Stock | 8.32 | 8.33 | 8.2 | 8.22 | 272700.0 |
| 2017-08-03 | ABR.A-DELISTED | Stock | 25.6824 | 25.6824 | 25.6824 | 25.6824 | 500.0 |
> showing 50 of 6,450 rows — these rows as CSV