PREVIEW / stock_daily / 2018-08-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-06.parquet
  size:    219 KB
  rows:    6,520
  symbols: 2,766

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-08-06	AAPL	Stock	52.0	52.3125	51.7675	52.2675	101701600.0
2018-08-06	MSFT	Stock	108.12	108.42	107.56	108.13	20265900.0
2018-08-06	NVDA	Stock	6.2898	6.3543	6.2428	6.3508	207508000.0
2018-08-06	AMZN	Stock	91.2905	92.3885	90.946	92.3875	67836000.0
2018-08-06	GOOGL	Stock	62.0805	62.1231	61.5265	61.8835	22118320.0
2018-08-06	META	Stock	178.97	185.79	178.38	185.69	49716200.0
2018-08-06	TSLA	Stock	23.0307	23.6653	22.788	22.7993	128464500.0
2018-08-06	TLT	Stock	119.54	119.84	119.27	119.29	4200296.0
2018-08-06	ES	Stock	60.84	61.46	60.83	61.09	990300.0
2018-08-06	CL	Stock	67.45	67.61	67.18	67.38	2542400.0
2018-08-06	A	Stock	65.7	66.66	65.33	66.51	2873100.0
2018-08-06	AA	Stock	42.53	42.98	42.21	42.72	3233400.0
2018-08-06	AABA-DELISTED	Stock	71.38	71.51	70.32	70.88	20218046.0
2018-08-06	AAC-DELISTED	Stock	9.41	9.41	8.5	8.75	306829.0
2018-08-06	AACG	Stock	4.6	4.6	4.23	4.23	1200.0
2018-08-06	AAIC-DELISTED	Stock	10.37	10.37	10.2699	10.31	283291.0
2018-08-06	AAL	Stock	38.26	38.49	37.87	38.41	3339900.0
2018-08-06	AAM.A-DELISTED	Stock	25.4239	25.469	25.4	25.4327	17794.0
2018-08-06	AAM.B-DELISTED	Stock	24.97	25.0	24.951	24.99	14193.0
2018-08-06	AAMC-DELISTED	Stock	18.4459	19.2059	18.3991	19.1176	4872.0
2018-08-06	AAMI	Stock	12.17	12.44	11.885	12.38	1750800.0
2018-08-06	AAOI	Stock	39.71	39.85	38.62	38.98	1006900.0
2018-08-06	AAON	Stock	25.5667	25.9667	25.5667	25.7333	255750.0
2018-08-06	AAP	Stock	145.52	145.83	143.49	145.1	679500.0
2018-08-06	AAT	Stock	38.96	39.09	38.63	38.75	139300.0
2018-08-06	AAU-DELISTED	Stock	0.67	0.67	0.6581	0.67	32083.0
2018-08-06	AAUAF-DELISTED	Stock	0.67	0.67	0.6581	0.67	34084.0
2018-08-06	AAV-DELISTED	Stock	3.3	3.35	3.2	3.2	53616.0
2018-08-06	AAWW-DELISTED	Stock	63.25	64.3	62.45	63.65	263112.0
2018-08-06	AAXJ	Stock	71.29	71.43	71.09	71.29	840318.0
2018-08-06	AAXN-DELISTED	Stock	68.1	69.115	65.19	66.86	892341.0
2018-08-06	AB	Stock	28.1	28.8	28.01	28.6	258000.0
2018-08-06	ABAC-DELISTED	Stock	2.15	2.3	2.15	2.24	7981.0
2018-08-06	ABB-DELISTED	Stock	22.93	23.01	22.84	22.94	1521298.0
2018-08-06	ABBNY-DELISTED	Stock	22.93	23.01	22.84	22.95	1569208.0
2018-08-06	ABBV	Stock	96.26	97.55	95.74	97.06	5134200.0
2018-08-06	ABC-DELISTED	Stock	80.25	82.72	80.07	82.13	1695631.0
2018-08-06	ABCB	Stock	48.9	49.17	48.5	48.8	145000.0
2018-08-06	ABCD-DELISTED	Stock	11.91	11.9375	11.57	11.73	98196.0
2018-08-06	ABDC-DELISTED	Stock	6.3	6.31	6.0	6.19	25092.0
2018-08-06	ABEO	Stock	353.75	368.25	350.0	367.5	13224.0
2018-08-06	ABEOW-DELISTED	Stock	9.5	9.5	9.5	9.5	100.0
2018-08-06	ABEV	Stock	5.17	5.18	5.12	5.13	33800300.0
2018-08-06	ABG	Stock	72.8	74.3	72.75	74.05	269400.0
2018-08-06	ABIL-DELISTED	Stock	2.94	2.94	2.7335	2.83	19711.0
2018-08-06	ABM	Stock	31.11	31.55	30.91	31.4	370400.0
2018-08-06	ABMD-DELISTED	Stock	376.16	382.64	374.17	378.56	357520.0
2018-08-06	ABR	Stock	11.75	11.81	11.56	11.57	1625400.0
2018-08-06	ABR.A-DELISTED	Stock	25.9822	26.0	25.9822	26.0	1525.0
2018-08-06	ABR.C-DELISTED	Stock	26.5	26.5	26.5	26.5	100.0

> showing 50 of 6,520 rows — these rows as CSV

> unlock the full archive -- $79 one-time