PREVIEW / stock_daily / 2019-06-04

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-04.parquet
  size:    220 KB
  rows:    6,555
  symbols: 2,563

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
2019-06-04	AAPL	Stock	43.86	44.9575	43.63	44.91	123872000.0
2019-06-04	MSFT	Stock	121.28	123.28	120.65	123.16	29382600.0
2019-06-04	NVDA	Stock	3.409	3.5803	3.3868	3.575	641836000.0
2019-06-04	AMZN	Stock	84.962	86.541	84.0445	86.478	113582000.0
2019-06-04	GOOGL	Stock	52.2245	52.9218	51.8015	52.7245	60511280.0
2019-06-04	META	Stock	163.71	168.28	160.84	167.5	46044300.0
2019-06-04	TSLA	Stock	12.0733	12.932	11.974	12.9067	207112500.0
2019-06-04	TLT	Stock	131.39	131.76	130.55	130.93	14250018.0
2019-06-04	ES	Stock	74.84	74.84	72.86	74.39	3404000.0
2019-06-04	CL	Stock	71.01	71.27	70.54	70.82	3757600.0
2019-06-04	A	Stock	67.66	68.0	66.41	67.95	4402800.0
2019-06-04	AA	Stock	21.67	22.23	21.48	21.89	3593400.0
2019-06-04	AABA-DELISTED	Stock	59.89	61.41	59.65	61.17	5506260.0
2019-06-04	AAC-DELISTED	Stock	1.02	1.08	0.99	1.065	184415.0
2019-06-04	AACG	Stock	1.81	1.86	1.81	1.83	47300.0
2019-06-04	AAIC-DELISTED	Stock	6.82	6.9	6.77	6.9	289074.0
2019-06-04	AAIC.C-DELISTED	Stock	22.3	22.4094	22.0	22.28	18632.0
2019-06-04	AAL	Stock	27.63	29.31	27.5	29.12	10218500.0
2019-06-04	AAM.A-DELISTED	Stock	25.6201	25.77	25.62	25.72	26837.0
2019-06-04	AAM.B-DELISTED	Stock	25.58	25.68	25.56	25.67	39433.0
2019-06-04	AAMC-DELISTED	Stock	4.1676	4.4118	4.0711	4.1588	29206.0
2019-06-04	AAME	Stock	2.37	2.37	2.37	2.37	100.0
2019-06-04	AAMI	Stock	11.19	11.3	11.03	11.11	647400.0
2019-06-04	AAOI	Stock	8.92	9.2	8.92	9.19	321400.0
2019-06-04	AAON	Stock	30.8933	31.8867	30.8333	31.8667	112800.0
2019-06-04	AAP	Stock	154.56	155.82	153.76	154.61	1008300.0
2019-06-04	AAT	Stock	45.72	45.83	44.78	45.11	364500.0
2019-06-04	AAU-DELISTED	Stock	0.49	0.5143	0.4742	0.4742	217627.0
2019-06-04	AAUAF-DELISTED	Stock	0.49	0.5143	0.4742	0.4742	231931.0
2019-06-04	AAWW-DELISTED	Stock	37.6	39.82	37.6	39.68	242563.0
2019-06-04	AAXJ	Stock	66.08	66.57	66.02	66.5	1124421.0
2019-06-04	AAXN-DELISTED	Stock	67.99	68.39	67.06	67.58	456221.0
2019-06-04	AB	Stock	27.7	28.23	27.67	28.12	131800.0
2019-06-04	ABB-DELISTED	Stock	18.69	18.87	18.645	18.86	1549074.0
2019-06-04	ABBNY-DELISTED	Stock	18.69	18.87	18.645	18.86	1616970.0
2019-06-04	ABBV	Stock	76.14	77.44	75.9	76.75	6447100.0
2019-06-04	ABC-DELISTED	Stock	81.29	82.88	81.0	82.235	1066619.0
2019-06-04	ABCB	Stock	36.49	37.3	36.42	37.25	261200.0
2019-06-04	ABDC-DELISTED	Stock	8.15	8.32	8.09	8.1	27379.0
2019-06-04	ABEO	Stock	132.0	141.5	128.75	140.75	34056.0
2019-06-04	ABEOW-DELISTED	Stock	1.51	1.77	1.51	1.77	1379.0
2019-06-04	ABEV	Stock	4.49	4.52	4.46	4.5	20778900.0
2019-06-04	ABG	Stock	78.06	81.48	77.66	79.67	276800.0
2019-06-04	ABIL-DELISTED	Stock	1.26	1.27	1.18	1.2	206684.0
2019-06-04	ABM	Stock	36.69	37.71	36.45	37.6	415300.0
2019-06-04	ABMD-DELISTED	Stock	264.11	268.95	263.99	267.07	422181.0
2019-06-04	ABR	Stock	12.45	12.61	12.4	12.59	1021200.0
2019-06-04	ABR.A-DELISTED	Stock	26.0086	26.0086	25.86	25.86	880.0
2019-06-04	ABR.B-DELISTED	Stock	25.62	25.756	25.62	25.756	218.0
2019-06-04	ABR.C-DELISTED	Stock	26.06	26.1464	26.06	26.08	1621.0

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

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