PREVIEW / stock_daily / 2018-11-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-12.parquet
  size:    220 KB
  rows:    6,546
  symbols: 2,695

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-11-12	AAPL	Stock	49.75	49.9625	48.4475	48.5425	204542000.0
2018-11-12	MSFT	Stock	109.42	109.96	106.1	106.87	33621800.0
2018-11-12	NVDA	Stock	5.0495	5.0718	4.7165	4.7385	617116000.0
2018-11-12	AMZN	Stock	84.912	85.4275	81.5005	81.8425	136124000.0
2018-11-12	GOOGL	Stock	53.6565	53.705	52.0175	52.468	34001820.0
2018-11-12	META	Stock	144.48	145.04	140.49	141.55	18542100.0
2018-11-12	TSLA	Stock	23.2247	23.3187	22.0227	22.0853	104122500.0
2018-11-12	TLT	Stock	113.95	114.31	113.91	114.09	6840265.0
2018-11-12	ES	Stock	64.74	66.26	64.57	65.48	1042200.0
2018-11-12	CL	Stock	62.98	63.38	61.25	61.35	8800800.0
2018-11-12	A	Stock	66.16	66.25	64.45	64.5	3000000.0
2018-11-12	AA	Stock	34.22	34.57	33.48	33.73	2422900.0
2018-11-12	AABA-DELISTED	Stock	61.0	61.38	59.11	59.93	3149465.0
2018-11-12	AAC-DELISTED	Stock	3.0	3.0	2.67	2.75	458739.0
2018-11-12	AACG	Stock	1.09	1.12	1.02	1.04	78000.0
2018-11-12	AAIC-DELISTED	Stock	8.64	8.64	8.41	8.44	362604.0
2018-11-12	AAL	Stock	36.31	37.3	35.78	36.86	9360800.0
2018-11-12	AAM.A-DELISTED	Stock	24.5	24.63	24.5	24.6121	7735.0
2018-11-12	AAM.B-DELISTED	Stock	24.455	24.5	24.35	24.4	11029.0
2018-11-12	AAMC-DELISTED	Stock	14.5088	14.5088	13.5325	13.8235	12087.0
2018-11-12	AAME	Stock	3.29	3.42	3.1	3.42	5600.0
2018-11-12	AAMI	Stock	12.93	13.0	12.81	12.83	269400.0
2018-11-12	AAOI	Stock	21.13	21.269	19.23	19.625	1586300.0
2018-11-12	AAON	Stock	28.8333	29.2067	28.4333	28.6267	231600.0
2018-11-12	AAP	Stock	170.33	170.9	166.19	167.06	1522400.0
2018-11-12	AAT	Stock	39.38	39.84	39.19	39.23	177100.0
2018-11-12	AAU-DELISTED	Stock	0.51	0.51	0.5	0.5	214684.0
2018-11-12	AAUAF-DELISTED	Stock	0.51	0.51	0.5	0.5	244985.0
2018-11-12	AAWW-DELISTED	Stock	54.05	54.19	53.145	53.23	116579.0
2018-11-12	AAXJ	Stock	63.9	63.97	63.13	63.23	2963742.0
2018-11-12	AAXN-DELISTED	Stock	52.16	52.665	49.22	50.0	679262.0
2018-11-12	AB	Stock	29.84	29.93	29.39	29.58	335200.0
2018-11-12	ABAC-DELISTED	Stock	1.71	1.71	1.66	1.68	1098.0
2018-11-12	ABB-DELISTED	Stock	19.82	19.86	19.56	19.57	3114705.0
2018-11-12	ABBNY-DELISTED	Stock	19.82	19.86	19.56	19.58	4076084.0
2018-11-12	ABBV	Stock	88.75	89.89	88.5	89.69	9344700.0
2018-11-12	ABC-DELISTED	Stock	88.35	90.33	87.98	89.91	747417.0
2018-11-12	ABCB	Stock	44.37	45.12	41.5	44.39	265400.0
2018-11-12	ABCD-DELISTED	Stock	14.4	14.43	14.38	14.42	226398.0
2018-11-12	ABDC-DELISTED	Stock	6.5	6.51	6.35	6.4	52574.0
2018-11-12	ABEO	Stock	223.75	226.75	192.5	192.75	50168.0
2018-11-12	ABEOW-DELISTED	Stock	4.62	4.62	3.67	3.67	2750.0
2018-11-12	ABEV	Stock	4.22	4.25	4.15	4.19	13287300.0
2018-11-12	ABG	Stock	67.96	68.73	67.64	67.93	224500.0
2018-11-12	ABIL-DELISTED	Stock	3.04	3.1829	2.99	2.99	29834.0
2018-11-12	ABM	Stock	31.9	31.91	30.55	30.62	511600.0
2018-11-12	ABMD-DELISTED	Stock	388.99	388.99	330.01	337.87	1337518.0
2018-11-12	ABR	Stock	12.41	12.79	12.41	12.47	2140100.0
2018-11-12	ABR.A-DELISTED	Stock	25.67	25.7899	25.6316	25.74	2715.0
2018-11-12	ABR.B-DELISTED	Stock	25.75	25.75	25.69	25.75	4370.0

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

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