PREVIEW / stock_daily / 2018-06-29

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-29.parquet
  size:    219 KB
  rows:    6,535
  symbols: 2,801

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-29	AAPL	Stock	46.5725	46.7975	45.7275	46.2775	90950800.0
2018-06-29	MSFT	Stock	98.93	99.91	98.33	98.61	28053200.0
2018-06-29	NVDA	Stock	6.0873	6.1	5.9213	5.9225	392300000.0
2018-06-29	AMZN	Stock	85.85	86.1705	84.716	84.99	90870000.0
2018-06-29	GOOGL	Stock	56.6155	57.068	56.351	56.4595	31562320.0
2018-06-29	META	Stock	197.32	197.6	193.96	194.32	15811600.0
2018-06-29	TSLA	Stock	23.5553	23.5907	22.8273	22.8633	97386000.0
2018-06-29	TLT	Stock	122.17	122.5	121.65	121.72	11164777.0
2018-06-29	ES	Stock	58.09	58.91	57.71	58.61	2556600.0
2018-06-29	CL	Stock	65.0	65.29	64.51	64.81	4223700.0
2018-06-29	A	Stock	61.68	62.47	61.57	61.84	1913800.0
2018-06-29	AA	Stock	46.19	47.32	46.088	46.88	3118900.0
2018-06-29	AABA-DELISTED	Stock	73.34	74.52	72.84	73.24	11349819.0
2018-06-29	AAC-DELISTED	Stock	9.18	9.43	9.09	9.38	139223.0
2018-06-29	AACG	Stock	4.94	5.1	4.02	4.19	12600.0
2018-06-29	AAIC-DELISTED	Stock	10.42	10.4267	10.2899	10.31	537587.0
2018-06-29	AAL	Stock	38.25	38.75	37.82	37.96	6032100.0
2018-06-29	AAM.A-DELISTED	Stock	25.3	25.47	25.254	25.33	19762.0
2018-06-29	AAM.B-DELISTED	Stock	24.87	24.94	24.795	24.85	40170.0
2018-06-29	AAMC-DELISTED	Stock	20.4118	20.8831	20.3382	20.5147	4913.0
2018-06-29	AAME	Stock	2.4	2.7	2.4	2.7	5000.0
2018-06-29	AAMI	Stock	14.42	14.56	14.26	14.26	500300.0
2018-06-29	AAOI	Stock	43.0	45.365	43.0	44.9	1236600.0
2018-06-29	AAON	Stock	22.2	22.4333	22.0333	22.1667	493500.0
2018-06-29	AAP	Stock	135.81	137.87	135.27	135.7	725300.0
2018-06-29	AAT	Stock	38.19	38.63	37.94	38.29	258900.0
2018-06-29	AAU-DELISTED	Stock	0.701	0.73	0.701	0.72	139731.0
2018-06-29	AAUAF-DELISTED	Stock	0.701	0.73	0.701	0.72	141721.0
2018-06-29	AAV-DELISTED	Stock	3.15	3.175	3.1	3.1	52357.0
2018-06-29	AAWW-DELISTED	Stock	71.35	72.25	71.25	71.75	168168.0
2018-06-29	AAXJ	Stock	71.61	71.85	71.49	71.67	939717.0
2018-06-29	AAXN-DELISTED	Stock	64.47	64.9559	62.22	63.18	534317.0
2018-06-29	AB	Stock	28.75	28.9	28.4	28.55	259000.0
2018-06-29	ABAC-DELISTED	Stock	2.88	2.92	2.52	2.74	30625.0
2018-06-29	ABAX-DELISTED	Stock	83.13	83.17	83.0	83.0	76318.0
2018-06-29	ABB-DELISTED	Stock	21.85	21.9662	21.77	21.785	1514572.0
2018-06-29	ABBNY-DELISTED	Stock	21.85	21.9662	21.77	21.77	1565859.0
2018-06-29	ABBV	Stock	92.84	94.46	92.56	92.65	6787900.0
2018-06-29	ABC-DELISTED	Stock	86.16	86.56	84.38	85.28	1237791.0
2018-06-29	ABCB	Stock	54.25	54.5	53.28	53.35	385900.0
2018-06-29	ABCD-DELISTED	Stock	11.08	11.23	10.98	11.16	239481.0
2018-06-29	ABDC-DELISTED	Stock	6.38	6.45	6.23	6.4	62952.0
2018-06-29	ABEO	Stock	413.75	413.75	392.5	400.0	24928.0
2018-06-29	ABEV	Stock	4.71	4.77	4.63	4.63	22946200.0
2018-06-29	ABG	Stock	70.4	70.4	68.45	68.55	192800.0
2018-06-29	ABIL-DELISTED	Stock	7.05	9.05	6.96	7.15	1121048.0
2018-06-29	ABM	Stock	29.28	29.72	29.16	29.18	439300.0
2018-06-29	ABMD-DELISTED	Stock	419.14	422.9565	408.85	409.15	410313.0
2018-06-29	ABR	Stock	10.51	10.57	10.39	10.43	2267000.0
2018-06-29	ABR.A-DELISTED	Stock	25.9502	25.9777	25.7	25.71	22100.0

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

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