PREVIEW / stock_daily / 2018-06-21

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-21.parquet
  size:    218 KB
  rows:    6,497
  symbols: 2,784

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-06-21	AAPL	Stock	46.8125	47.0875	46.235	46.365	102847600.0
2018-06-21	MSFT	Stock	102.08	102.46	100.88	101.14	23198200.0
2018-06-21	NVDA	Stock	6.59	6.6085	6.42	6.4278	359516000.0
2018-06-21	AMZN	Stock	88.0	88.155	85.878	86.511	98822000.0
2018-06-21	GOOGL	Stock	59.2755	59.5166	58.174	58.472	44965540.0
2018-06-21	META	Stock	202.76	203.39	200.09	201.5	19045700.0
2018-06-21	TSLA	Stock	24.1333	24.414	23.0847	23.1673	119506500.0
2018-06-21	TLT	Stock	120.36	120.75	120.22	120.54	7235850.0
2018-06-21	ES	Stock	55.61	55.98	55.46	55.7	1219100.0
2018-06-21	CL	Stock	63.68	63.9	63.26	63.49	3646000.0
2018-06-21	A	Stock	62.81	63.22	62.27	63.04	4319400.0
2018-06-21	AA	Stock	45.01	45.429	44.57	44.81	2251200.0
2018-06-21	AABA-DELISTED	Stock	80.64	80.93	79.14	79.59	9773346.0
2018-06-21	AAC-DELISTED	Stock	10.21	10.42	10.08	10.26	127101.0
2018-06-21	AACG	Stock	5.2	5.2	4.66	4.85	17900.0
2018-06-21	AAIC-DELISTED	Stock	10.88	10.97	10.8144	10.95	602838.0
2018-06-21	AAL	Stock	42.03	42.5	41.37	41.49	5025300.0
2018-06-21	AAM.A-DELISTED	Stock	25.35	25.35	25.15	25.15	15024.0
2018-06-21	AAM.B-DELISTED	Stock	24.72	24.73	24.53	24.6	101251.0
2018-06-21	AAMC-DELISTED	Stock	20.5	20.5	20.5	20.5	425.0
2018-06-21	AAME	Stock	2.55	2.7	2.46	2.46	2200.0
2018-06-21	AAMI	Stock	15.4	15.4	15.01	15.07	556500.0
2018-06-21	AAOI	Stock	42.44	45.4	42.44	43.13	1302500.0
2018-06-21	AAON	Stock	22.3667	22.5667	22.1333	22.3	274650.0
2018-06-21	AAP	Stock	139.1	140.1	137.79	139.5	783800.0
2018-06-21	AAT	Stock	37.65	38.07	37.61	38.04	136200.0
2018-06-21	AAU-DELISTED	Stock	0.73	0.7399	0.72	0.7325	84266.0
2018-06-21	AAUAF-DELISTED	Stock	0.73	0.7399	0.72	0.7325	85627.0
2018-06-21	AAV-DELISTED	Stock	3.05	3.15	3.025	3.1	70148.0
2018-06-21	AAWW-DELISTED	Stock	74.5	74.75	73.15	73.95	161188.0
2018-06-21	AAXJ	Stock	73.19	73.19	72.425	72.45	1075264.0
2018-06-21	AAXN-DELISTED	Stock	68.79	71.0	65.729	67.06	998233.0
2018-06-21	AB	Stock	29.25	29.25	28.76	28.95	308400.0
2018-06-21	ABAC-DELISTED	Stock	2.5	2.5	2.23	2.25	5835.0
2018-06-21	ABAX-DELISTED	Stock	83.02	83.1	82.81	82.97	388636.0
2018-06-21	ABB-DELISTED	Stock	22.28	22.2899	22.039	22.09	1423842.0
2018-06-21	ABBNY-DELISTED	Stock	22.28	22.2899	22.039	22.09	1478753.0
2018-06-21	ABBV	Stock	97.71	97.99	95.26	95.55	7225000.0
2018-06-21	ABC-DELISTED	Stock	93.67	93.96	92.86	93.21	827157.0
2018-06-21	ABCB	Stock	57.7	58.0	56.8	57.15	288800.0
2018-06-21	ABCD-DELISTED	Stock	10.9	11.1	10.8	10.92	149979.0
2018-06-21	ABDC-DELISTED	Stock	6.789	6.91	6.77	6.83	45948.0
2018-06-21	ABEO	Stock	410.0	416.25	388.75	395.0	34148.0
2018-06-21	ABEV	Stock	4.89	4.93	4.81	4.82	23483700.0
2018-06-21	ABG	Stock	75.9	75.9	74.97	75.2	150200.0
2018-06-21	ABIL-DELISTED	Stock	2.2367	4.68	2.21	4.5372	8844907.0
2018-06-21	ABM	Stock	30.34	30.68	30.25	30.46	631500.0
2018-06-21	ABMD-DELISTED	Stock	450.06	450.65	433.51	438.27	381472.0
2018-06-21	ABR	Stock	10.14	10.2	10.07	10.08	811700.0
2018-06-21	ABR.B-DELISTED	Stock	25.3	25.33	25.3	25.33	1160.0

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

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