PREVIEW / stock_daily / 2018-06-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-25.parquet
  size:    218 KB
  rows:    6,504
  symbols: 2,781

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-25	AAPL	Stock	45.85	46.23	45.1825	45.5425	126652400.0
2018-06-25	MSFT	Stock	100.0	100.11	97.3	98.39	35433300.0
2018-06-25	NVDA	Stock	6.1663	6.17	5.8885	5.978	665816000.0
2018-06-25	AMZN	Stock	85.1255	85.25	82.3155	83.1575	150224000.0
2018-06-25	GOOGL	Stock	57.75	57.7995	55.995	56.964	57682620.0
2018-06-25	META	Stock	200.0	200.0	193.11	196.35	25275100.0
2018-06-25	TSLA	Stock	22.008	22.5647	21.8333	22.2007	103969500.0
2018-06-25	TLT	Stock	120.66	121.11	120.64	120.8	8363674.0
2018-06-25	ES	Stock	56.33	57.36	56.28	57.33	2908300.0
2018-06-25	CL	Stock	64.32	65.25	64.2	65.11	4432500.0
2018-06-25	A	Stock	62.46	62.69	60.8	61.2	2426800.0
2018-06-25	AA	Stock	45.13	45.13	43.59	44.26	2281900.0
2018-06-25	AABA-DELISTED	Stock	78.23	78.25	74.41	75.47	10301867.0
2018-06-25	AAC-DELISTED	Stock	10.1	10.1	9.84	9.95	126743.0
2018-06-25	AACG	Stock	4.95	5.11	4.95	5.11	10600.0
2018-06-25	AAIC-DELISTED	Stock	10.94	10.97	10.79	10.9	734700.0
2018-06-25	AAL	Stock	41.09	41.27	39.29	39.68	7126400.0
2018-06-25	AAM.A-DELISTED	Stock	25.18	25.31	25.15	25.19	12091.0
2018-06-25	AAM.B-DELISTED	Stock	24.7	24.7	24.6	24.62	61474.0
2018-06-25	AAMC-DELISTED	Stock	19.1985	20.6618	18.9515	20.4706	19570.0
2018-06-25	AAME	Stock	2.65	2.65	2.5	2.5	1500.0
2018-06-25	AAMI	Stock	15.13	15.13	14.61	14.81	714800.0
2018-06-25	AAOI	Stock	43.27	43.319	40.018	40.25	945700.0
2018-06-25	AAON	Stock	22.0333	22.0667	21.6	21.9	240300.0
2018-06-25	AAP	Stock	137.94	137.99	135.21	137.27	915900.0
2018-06-25	AAT	Stock	38.38	38.87	38.18	38.79	209500.0
2018-06-25	AAU-DELISTED	Stock	0.72	0.7423	0.72	0.735	81436.0
2018-06-25	AAUAF-DELISTED	Stock	0.72	0.7423	0.72	0.735	92446.0
2018-06-25	AAV-DELISTED	Stock	3.15	3.15	3.05	3.1	69195.0
2018-06-25	AAWW-DELISTED	Stock	73.45	75.0	69.3	70.9	460013.0
2018-06-25	AAXJ	Stock	72.4	72.42	71.39	72.02	1201156.0
2018-06-25	AAXN-DELISTED	Stock	67.21	67.6	61.8	61.97	1155849.0
2018-06-25	AB	Stock	29.1	29.1	28.55	28.85	216400.0
2018-06-25	ABAC-DELISTED	Stock	2.1	2.25	2.1	2.235	1927.0
2018-06-25	ABAX-DELISTED	Stock	83.02	83.17	82.91	83.12	223631.0
2018-06-25	ABB-DELISTED	Stock	21.93	21.97	21.61	21.7	2114191.0
2018-06-25	ABBNY-DELISTED	Stock	21.93	21.97	21.61	21.7	2201220.0
2018-06-25	ABBV	Stock	93.47	94.38	92.1	93.05	5573100.0
2018-06-25	ABC-DELISTED	Stock	93.15	93.81	91.35	92.22	541951.0
2018-06-25	ABCB	Stock	56.4	56.45	55.5	56.05	132300.0
2018-06-25	ABCD-DELISTED	Stock	11.02	11.13	10.77	10.94	123690.0
2018-06-25	ABDC-DELISTED	Stock	6.62	6.7	6.61	6.64	14515.0
2018-06-25	ABEO	Stock	406.25	406.25	388.75	390.0	53164.0
2018-06-25	ABEOW-DELISTED	Stock	10.78	10.78	10.75	10.75	700.0
2018-06-25	ABEV	Stock	4.88	4.88	4.81	4.84	24596400.0
2018-06-25	ABG	Stock	74.1	74.15	71.85	72.55	218500.0
2018-06-25	ABIL-DELISTED	Stock	5.1	10.6	5.1	10.05	9949484.0
2018-06-25	ABM	Stock	30.32	30.35	29.84	30.13	592900.0
2018-06-25	ABMD-DELISTED	Stock	420.74	421.9914	402.18	416.19	790788.0
2018-06-25	ABR	Stock	10.02	10.18	10.02	10.1	786100.0

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

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