PREVIEW / stock_daily / 2018-08-28

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-28.parquet
  size:    218 KB
  rows:    6,528
  symbols: 2,760

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-28	AAPL	Stock	54.7525	55.135	54.73	54.925	91107200.0
2018-08-28	MSFT	Stock	109.94	110.5	109.79	110.26	19151500.0
2018-08-28	NVDA	Stock	6.8915	6.9145	6.7382	6.8595	475384000.0
2018-08-28	AMZN	Stock	96.8865	97.089	96.441	96.641	62014000.0
2018-08-28	GOOGL	Stock	62.795	62.828	62.1485	62.293	27330320.0
2018-08-28	META	Stock	178.1	178.24	175.83	176.26	15910700.0
2018-08-28	TSLA	Stock	21.2273	21.2587	20.746	20.7907	114736500.0
2018-08-28	TLT	Stock	121.0	121.09	120.6812	120.86	4929337.0
2018-08-28	ES	Stock	62.14	62.24	61.69	61.84	1302400.0
2018-08-28	CL	Stock	67.28	67.4	66.68	66.78	2012100.0
2018-08-28	A	Stock	66.41	67.3	66.35	66.69	2284300.0
2018-08-28	AA	Stock	44.49	45.65	44.0	44.25	3837200.0
2018-08-28	AABA-DELISTED	Stock	71.28	71.45	69.95	70.3	2596123.0
2018-08-28	AAC-DELISTED	Stock	9.36	9.59	9.29	9.31	90158.0
2018-08-28	AACG	Stock	1.96	3.37	1.7	2.59	14152300.0
2018-08-28	AAIC-DELISTED	Stock	10.15	10.2081	10.09	10.18	418141.0
2018-08-28	AAL	Stock	39.67	40.7	39.6	40.69	7373500.0
2018-08-28	AAM.A-DELISTED	Stock	25.99	25.99	25.8906	25.91	18070.0
2018-08-28	AAM.B-DELISTED	Stock	25.41	25.44	25.3693	25.43	43378.0
2018-08-28	AAME	Stock	2.5	2.5	2.5	2.5	1000.0
2018-08-28	AAMI	Stock	12.76	12.99	12.7	12.71	455300.0
2018-08-28	AAOI	Stock	42.2	42.77	41.68	42.74	374100.0
2018-08-28	AAON	Stock	27.0667	27.7667	26.9	27.1	247050.0
2018-08-28	AAP	Stock	162.21	162.91	160.0	162.1	1096700.0
2018-08-28	AAT	Stock	39.21	39.53	38.93	39.46	190600.0
2018-08-28	AAU-DELISTED	Stock	0.6575	0.6575	0.6305	0.6513	131118.0
2018-08-28	AAUAF-DELISTED	Stock	0.6575	0.6575	0.6305	0.6513	179471.0
2018-08-28	AAV-DELISTED	Stock	3.15	3.15	3.05	3.1	107380.0
2018-08-28	AAWW-DELISTED	Stock	62.6	62.95	61.75	62.075	56689.0
2018-08-28	AAXJ	Stock	72.69	72.73	72.14	72.24	1128539.0
2018-08-28	AAXN-DELISTED	Stock	66.97	67.92	66.45	67.3	401219.0
2018-08-28	AB	Stock	30.55	30.55	29.9	30.15	345300.0
2018-08-28	ABAC-DELISTED	Stock	1.83	1.83	1.75	1.7853	4449.0
2018-08-28	ABB-DELISTED	Stock	23.89	23.94	23.71	23.72	1804360.0
2018-08-28	ABBNY-DELISTED	Stock	23.89	23.94	23.71	23.72	1883500.0
2018-08-28	ABBV	Stock	97.79	98.7	97.1	97.26	3515400.0
2018-08-28	ABC-DELISTED	Stock	88.81	88.97	87.9	88.87	482640.0
2018-08-28	ABCB	Stock	50.0	50.05	49.55	49.65	238600.0
2018-08-28	ABCD-DELISTED	Stock	13.79	13.86	13.655	13.74	49940.0
2018-08-28	ABDC-DELISTED	Stock	6.19	6.19	6.1	6.12	44255.0
2018-08-28	ABEO	Stock	352.5	375.0	346.75	375.0	17788.0
2018-08-28	ABEOW-DELISTED	Stock	9.9	9.9	9.9	9.9	400.0
2018-08-28	ABEV	Stock	4.66	4.68	4.6	4.61	25296600.0
2018-08-28	ABG	Stock	75.8	76.2	75.5	76.0	70700.0
2018-08-28	ABIL-DELISTED	Stock	4.0	4.55	3.8672	4.115	1053368.0
2018-08-28	ABM	Stock	30.71	31.2	30.71	31.01	570600.0
2018-08-28	ABMD-DELISTED	Stock	381.26	386.88	378.34	386.0	243013.0
2018-08-28	ABR	Stock	12.1	12.13	11.97	12.07	905800.0
2018-08-28	ABR.A-DELISTED	Stock	26.0	26.0	25.88	25.88	1272.0
2018-08-28	ABR.B-DELISTED	Stock	25.445	25.445	25.445	25.445	782.0

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

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