PREVIEW / stock_daily / 2018-05-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-25.parquet
  size:    217 KB
  rows:    6,493
  symbols: 2,793

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-05-25	AAPL	Stock	47.0575	47.4125	46.9125	47.145	69844000.0
2018-05-25	MSFT	Stock	98.3	98.98	97.86	98.36	18363900.0
2018-05-25	NVDA	Stock	6.205	6.2485	6.169	6.232	292112000.0
2018-05-25	AMZN	Stock	80.15	80.706	80.0225	80.5075	53968000.0
2018-05-25	GOOGL	Stock	54.3275	54.4785	54.13	54.204	22223220.0
2018-05-25	META	Stock	186.02	186.33	184.45	184.92	10965100.0
2018-05-25	TSLA	Stock	18.5087	18.6427	18.374	18.59	58126500.0
2018-05-25	TLT	Stock	119.56	119.84	119.465	119.62	8482823.0
2018-05-25	ES	Stock	56.75	56.8	56.23	56.26	2806600.0
2018-05-25	CL	Stock	63.24	64.04	63.06	63.75	5197700.0
2018-05-25	A	Stock	63.94	64.11	62.84	63.15	1742000.0
2018-05-25	AA	Stock	48.74	48.825	47.66	47.93	3553500.0
2018-05-25	AABA-DELISTED	Stock	77.05	78.2483	76.89	77.43	1126181.0
2018-05-25	AAC-DELISTED	Stock	11.5	11.56	11.23	11.39	127235.0
2018-05-25	AACG	Stock	5.26	5.26	5.26	5.26	200.0
2018-05-25	AAIC-DELISTED	Stock	11.25	11.28	11.18	11.25	312791.0
2018-05-25	AAL	Stock	43.82	45.82	43.8	44.91	6517300.0
2018-05-25	AAM.A-DELISTED	Stock	25.49	25.5	25.4001	25.5	24996.0
2018-05-25	AAM.B-DELISTED	Stock	25.0	25.05	25.0	25.035	117851.0
2018-05-25	AAMC-DELISTED	Stock	19.5588	19.5588	19.4118	19.4118	2254.0
2018-05-25	AAME	Stock	2.7	2.7	2.7	2.7	1200.0
2018-05-25	AAMI	Stock	15.36	15.6	15.33	15.55	248000.0
2018-05-25	AAOI	Stock	34.08	35.26	34.08	34.49	693100.0
2018-05-25	AAON	Stock	20.2333	20.3	19.8667	20.1	436800.0
2018-05-25	AAP	Stock	124.69	126.24	124.41	124.91	1173100.0
2018-05-25	AAT	Stock	35.26	35.51	35.22	35.47	181700.0
2018-05-25	AAU-DELISTED	Stock	0.71	0.7299	0.702	0.7299	98099.0
2018-05-25	AAUAF-DELISTED	Stock	0.71	0.7299	0.702	0.7299	109083.0
2018-05-25	AAV-DELISTED	Stock	2.9	3.0	2.8	2.975	335080.0
2018-05-25	AAWW-DELISTED	Stock	68.15	69.2	66.975	68.7	171112.0
2018-05-25	AAXJ	Stock	76.445	76.93	76.43	76.89	770241.0
2018-05-25	AAXN-DELISTED	Stock	61.99	63.5	61.5	63.01	1205225.0
2018-05-25	AB	Stock	28.25	28.55	28.25	28.4	389500.0
2018-05-25	ABAC-DELISTED	Stock	2.14	2.28	2.14	2.28	264.0
2018-05-25	ABAX-DELISTED	Stock	83.04	83.18	82.95	82.96	230327.0
2018-05-25	ABB-DELISTED	Stock	23.56	23.625	23.48	23.53	1028592.0
2018-05-25	ABBNY-DELISTED	Stock	23.56	23.625	23.48	23.53	1661541.0
2018-05-25	ABBV	Stock	102.29	103.14	99.55	101.08	25301700.0
2018-05-25	ABC-DELISTED	Stock	84.46	86.13	83.985	85.5	631883.0
2018-05-25	ABCB	Stock	55.9	56.35	55.6	56.15	541600.0
2018-05-25	ABCD-DELISTED	Stock	10.01	10.15	9.95	10.1	98527.0
2018-05-25	ABDC-DELISTED	Stock	6.52	6.74	6.49	6.63	119147.0
2018-05-25	ABEO	Stock	405.0	425.0	403.75	415.0	43960.0
2018-05-25	ABEOW-DELISTED	Stock	11.877	11.9	11.877	11.9	600.0
2018-05-25	ABEV	Stock	5.52	5.53	5.41	5.45	17542800.0
2018-05-25	ABG	Stock	69.95	70.75	68.0	69.95	111300.0
2018-05-25	ABIL-DELISTED	Stock	2.48	2.6	2.4	2.4	17223.0
2018-05-25	ABLX-DELISTED	Stock	52.64	52.67	52.635	52.635	411.0
2018-05-25	ABM	Stock	29.12	29.47	29.12	29.23	661800.0
2018-05-25	ABMD-DELISTED	Stock	396.88	398.05	392.5	394.07	281121.0

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

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