PREVIEW / stock_daily / 2018-04-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-12.parquet
  size:    214 KB
  rows:    6,446
  symbols: 2,816

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-04-12	AAPL	Stock	43.3525	43.75	43.26	43.535	91557200.0
2018-04-12	MSFT	Stock	92.43	94.16	92.43	93.58	26758900.0
2018-04-12	NVDA	Stock	5.75	5.883	5.7053	5.865	593920000.0
2018-04-12	AMZN	Stock	71.975	72.606	71.753	72.425	62700000.0
2018-04-12	GOOGL	Stock	51.5735	52.2325	51.3025	51.8645	32895880.0
2018-04-12	META	Stock	166.98	167.45	163.1	163.87	38263000.0
2018-04-12	TSLA	Stock	20.1547	20.2633	19.5787	19.6053	114132000.0
2018-04-12	TLT	Stock	121.04	121.07	120.41	120.62	6622829.0
2018-04-12	ES	Stock	59.42	59.73	58.61	58.64	1719800.0
2018-04-12	CL	Stock	71.51	71.85	70.85	70.94	2681900.0
2018-04-12	A	Stock	66.56	67.64	66.45	67.2	2180900.0
2018-04-12	AA	Stock	53.7	55.332	53.17	54.47	5726300.0
2018-04-12	AABA-DELISTED	Stock	70.75	71.39	70.23	70.55	3607426.0
2018-04-12	AAC-DELISTED	Stock	11.13	11.46	11.05	11.12	54245.0
2018-04-12	AACG	Stock	5.2	5.2	5.2	5.2	700.0
2018-04-12	AAIC-DELISTED	Stock	11.35	11.365	11.14	11.21	482836.0
2018-04-12	AAL	Stock	46.03	46.8	45.51	46.57	7040400.0
2018-04-12	AAM.A-DELISTED	Stock	24.82	24.9022	24.77	24.7915	20256.0
2018-04-12	AAM.B-DELISTED	Stock	24.7404	24.77	24.7	24.73	150358.0
2018-04-12	AAME	Stock	3.24	3.24	3.2	3.2	500.0
2018-04-12	AAMI	Stock	14.77	15.04	14.765	14.89	817000.0
2018-04-12	AAOI	Stock	29.19	30.98	28.26	29.59	2556000.0
2018-04-12	AAON	Stock	23.0333	23.1	22.5333	23.0	210900.0
2018-04-12	AAP	Stock	111.46	112.59	110.36	110.57	850700.0
2018-04-12	AAT	Stock	34.24	34.24	33.42	33.57	162000.0
2018-04-12	AAU-DELISTED	Stock	0.83	0.83	0.7936	0.8151	253827.0
2018-04-12	AAUAF-DELISTED	Stock	0.83	0.83	0.7936	0.8151	262581.0
2018-04-12	AAV-DELISTED	Stock	3.5	3.5	3.2698	3.35	190617.0
2018-04-12	AAWW-DELISTED	Stock	62.25	63.65	61.55	62.9	155325.0
2018-04-12	AAXJ	Stock	77.56	78.0	77.42	77.84	369327.0
2018-04-12	AAXN-DELISTED	Stock	43.1	44.06	43.0	43.1	1425727.0
2018-04-12	AB	Stock	26.5	26.95	26.5	26.8	211400.0
2018-04-12	ABAC-DELISTED	Stock	2.44	2.6744	2.44	2.49	16900.0
2018-04-12	ABAX-DELISTED	Stock	72.28	72.7199	71.35	72.12	34353.0
2018-04-12	ABB-DELISTED	Stock	22.77	22.9	22.74	22.84	2689564.0
2018-04-12	ABBNY-DELISTED	Stock	22.77	22.9	22.74	22.84	5262049.0
2018-04-12	ABBV	Stock	93.71	93.71	92.07	92.12	6402500.0
2018-04-12	ABC-DELISTED	Stock	89.55	89.84	87.89	88.17	526184.0
2018-04-12	ABCB	Stock	52.4	53.8	51.8	53.6	430100.0
2018-04-12	ABCD-DELISTED	Stock	11.69	11.99	11.66	11.91	280267.0
2018-04-12	ABDC-DELISTED	Stock	7.03	7.1249	7.01	7.01	20278.0
2018-04-12	ABE-DELISTED	Stock	14.89	14.9438	14.89	14.9001	4972.0
2018-04-12	ABEO	Stock	456.25	478.75	452.5	475.0	42840.0
2018-04-12	ABEOW-DELISTED	Stock	13.56	14.06	13.35	14.0	2660.0
2018-04-12	ABEV	Stock	6.97	7.0	6.76	6.77	28653000.0
2018-04-12	ABG	Stock	66.1	67.8	66.1	67.25	113800.0
2018-04-12	ABIL-DELISTED	Stock	2.901	3.85	2.901	3.19	89040.0
2018-04-12	ABLX-DELISTED	Stock	54.71	54.83	54.71	54.72	45120.0
2018-04-12	ABM	Stock	32.72	32.88	32.28	32.3	448900.0
2018-04-12	ABMD-DELISTED	Stock	297.53	299.58	295.59	296.88	228721.0

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

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