PREVIEW / stock_daily / 2018-05-30
file: by_date/stock_daily/2018/2018-05-30.parquet size: 218 KB rows: 6,505 symbols: 2,792
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 |
|---|---|---|---|---|---|---|---|
| 2018-05-30 | AAPL | Stock | 46.93 | 47.0 | 46.695 | 46.875 | 74762000.0 |
| 2018-05-30 | MSFT | Stock | 98.31 | 99.25 | 97.91 | 98.95 | 22158500.0 |
| 2018-05-30 | NVDA | Stock | 6.2488 | 6.3335 | 6.2238 | 6.3248 | 390996000.0 |
| 2018-05-30 | AMZN | Stock | 80.905 | 81.3 | 80.6465 | 81.2445 | 58148000.0 |
| 2018-05-30 | GOOGL | Stock | 53.674 | 53.9495 | 53.3275 | 53.8735 | 28685640.0 |
| 2018-05-30 | META | Stock | 186.54 | 188.0 | 185.25 | 187.67 | 13736900.0 |
| 2018-05-30 | TSLA | Stock | 18.886 | 19.6673 | 18.7733 | 19.448 | 112345500.0 |
| 2018-05-30 | TLT | Stock | 121.0 | 121.4799 | 120.74 | 121.42 | 11616340.0 |
| 2018-05-30 | ES | Stock | 56.68 | 57.34 | 56.4 | 57.14 | 2262900.0 |
| 2018-05-30 | CL | Stock | 63.74 | 64.63 | 63.47 | 64.39 | 4403700.0 |
| 2018-05-30 | A | Stock | 62.24 | 63.06 | 62.0 | 62.69 | 1731500.0 |
| 2018-05-30 | AA | Stock | 48.11 | 48.66 | 47.5 | 48.54 | 1681200.0 |
| 2018-05-30 | AABA-DELISTED | Stock | 77.18 | 77.54 | 76.6 | 77.0 | 1419043.0 |
| 2018-05-30 | AAC-DELISTED | Stock | 11.06 | 11.23 | 10.75 | 10.92 | 100246.0 |
| 2018-05-30 | AACG | Stock | 5.22 | 5.24 | 5.1 | 5.1 | 4800.0 |
| 2018-05-30 | AAIC-DELISTED | Stock | 11.32 | 11.53 | 11.285 | 11.51 | 601554.0 |
| 2018-05-30 | AAL | Stock | 43.68 | 43.83 | 42.66 | 43.3 | 5457900.0 |
| 2018-05-30 | AAM.A-DELISTED | Stock | 25.5 | 25.5 | 25.34 | 25.36 | 56850.0 |
| 2018-05-30 | AAM.B-DELISTED | Stock | 25.0 | 25.04 | 24.83 | 24.83 | 256575.0 |
| 2018-05-30 | AAMC-DELISTED | Stock | 19.5735 | 20.0294 | 19.5735 | 20.0294 | 3094.0 |
| 2018-05-30 | AAME | Stock | 2.85 | 2.95 | 2.83 | 2.85 | 2200.0 |
| 2018-05-30 | AAMI | Stock | 15.32 | 15.56 | 15.32 | 15.49 | 361300.0 |
| 2018-05-30 | AAOI | Stock | 36.0 | 40.67 | 35.84 | 40.62 | 3521200.0 |
| 2018-05-30 | AAON | Stock | 20.2667 | 20.6667 | 20.1 | 20.4 | 2643600.0 |
| 2018-05-30 | AAP | Stock | 124.0 | 128.66 | 123.52 | 128.53 | 1223900.0 |
| 2018-05-30 | AAT | Stock | 35.87 | 36.37 | 35.5 | 36.28 | 304100.0 |
| 2018-05-30 | AAU-DELISTED | Stock | 0.72 | 0.73 | 0.705 | 0.7141 | 100379.0 |
| 2018-05-30 | AAUAF-DELISTED | Stock | 0.72 | 0.73 | 0.705 | 0.7141 | 107075.0 |
| 2018-05-30 | AAV-DELISTED | Stock | 2.85 | 2.95 | 2.85 | 2.925 | 111316.0 |
| 2018-05-30 | AAWW-DELISTED | Stock | 69.05 | 69.95 | 68.6 | 68.8 | 165566.0 |
| 2018-05-30 | AAXJ | Stock | 75.21 | 75.88 | 75.044 | 75.78 | 1936862.0 |
| 2018-05-30 | AAXN-DELISTED | Stock | 64.35 | 64.779 | 62.66 | 63.73 | 832390.0 |
| 2018-05-30 | AB | Stock | 28.1 | 28.55 | 28.06 | 28.4 | 220500.0 |
| 2018-05-30 | ABAC-DELISTED | Stock | 2.18 | 2.22 | 2.18 | 2.22 | 1833.0 |
| 2018-05-30 | ABAX-DELISTED | Stock | 82.73 | 83.553 | 82.55 | 83.4 | 467492.0 |
| 2018-05-30 | ABB-DELISTED | Stock | 22.8 | 23.185 | 22.79 | 23.11 | 2702396.0 |
| 2018-05-30 | ABBNY-DELISTED | Stock | 22.8 | 23.185 | 22.79 | 23.11 | 2791879.0 |
| 2018-05-30 | ABBV | Stock | 101.86 | 103.16 | 100.83 | 103.01 | 31273400.0 |
| 2018-05-30 | ABC-DELISTED | Stock | 82.82 | 84.58 | 82.49 | 84.13 | 780630.0 |
| 2018-05-30 | ABCB | Stock | 55.0 | 56.0 | 55.0 | 55.9 | 204400.0 |
| 2018-05-30 | ABCD-DELISTED | Stock | 10.13 | 10.29 | 10.0 | 10.03 | 102258.0 |
| 2018-05-30 | ABDC-DELISTED | Stock | 6.6 | 6.89 | 6.6 | 6.87 | 61015.0 |
| 2018-05-30 | ABEO | Stock | 450.0 | 472.5 | 449.5 | 468.75 | 32512.0 |
| 2018-05-30 | ABEOW-DELISTED | Stock | 13.2 | 13.2 | 13.2 | 13.2 | 400.0 |
| 2018-05-30 | ABEV | Stock | 5.21 | 5.32 | 5.18 | 5.26 | 29155700.0 |
| 2018-05-30 | ABG | Stock | 69.95 | 70.7 | 69.45 | 70.2 | 171200.0 |
| 2018-05-30 | ABIL-DELISTED | Stock | 2.36 | 2.44 | 2.3 | 2.32 | 16016.0 |
| 2018-05-30 | ABLX-DELISTED | Stock | 52.14 | 52.73 | 52.14 | 52.73 | 2869.0 |
| 2018-05-30 | ABM | Stock | 28.96 | 29.61 | 28.96 | 29.15 | 1436200.0 |
| 2018-05-30 | ABMD-DELISTED | Stock | 389.04 | 397.389 | 385.87 | 388.57 | 8719887.0 |
> showing 50 of 6,505 rows — these rows as CSV