PREVIEW / stock_daily / 2018-04-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-04-16.parquet
  size:    216 KB
  rows:    6,497
  symbols: 2,836

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-16	AAPL	Stock	43.7575	44.0475	43.7075	43.955	86313600.0
2018-04-16	MSFT	Stock	94.07	94.66	93.42	94.17	20288100.0
2018-04-16	NVDA	Stock	5.7943	5.821	5.692	5.7872	350792000.0
2018-04-16	AMZN	Stock	72.25	72.35	71.374	72.075	56172000.0
2018-04-16	GOOGL	Stock	52.2775	52.5715	51.696	52.305	29776440.0
2018-04-16	META	Stock	165.72	165.78	163.39	164.83	18119400.0
2018-04-16	TSLA	Stock	19.9333	19.9773	19.2673	19.414	95077500.0
2018-04-16	TLT	Stock	120.23	120.97	120.18	120.94	4491254.0
2018-04-16	ES	Stock	59.3	59.83	59.12	59.68	1620100.0
2018-04-16	CL	Stock	71.95	72.53	71.71	72.44	4089800.0
2018-04-16	A	Stock	67.83	68.37	67.49	68.17	2887800.0
2018-04-16	AA	Stock	55.55	56.5	54.405	55.03	5573000.0
2018-04-16	AABA-DELISTED	Stock	69.52	69.985	69.01	69.915	2861410.0
2018-04-16	AAC-DELISTED	Stock	10.89	11.17	10.89	11.08	32154.0
2018-04-16	AACG	Stock	5.28	5.3	5.28	5.3	20200.0
2018-04-16	AAIC-DELISTED	Stock	11.17	11.2	11.11	11.18	308491.0
2018-04-16	AAL	Stock	46.13	46.94	45.81	46.4	4516300.0
2018-04-16	AAM.A-DELISTED	Stock	24.75	24.8	24.61	24.7	26802.0
2018-04-16	AAM.B-DELISTED	Stock	24.59	24.7	24.59	24.7	69872.0
2018-04-16	AAME	Stock	3.15	3.15	3.15	3.15	1000.0
2018-04-16	AAMI	Stock	14.65	14.79	14.58	14.68	1073200.0
2018-04-16	AAOI	Stock	29.93	30.42	28.44	29.97	1795200.0
2018-04-16	AAON	Stock	23.0667	23.6	22.8333	23.5333	230100.0
2018-04-16	AAP	Stock	106.93	108.03	105.02	106.45	971500.0
2018-04-16	AAT	Stock	33.82	34.06	33.63	34.0	341200.0
2018-04-16	AAU-DELISTED	Stock	0.8	0.83	0.79	0.825	231540.0
2018-04-16	AAUAF-DELISTED	Stock	0.8	0.83	0.79	0.825	243720.0
2018-04-16	AAV-DELISTED	Stock	3.25	3.25	3.1	3.1245	236246.0
2018-04-16	AAWW-DELISTED	Stock	63.25	65.45	63.2	64.5	239805.0
2018-04-16	AAXJ	Stock	76.76	77.06	76.56	77.01	257035.0
2018-04-16	AAXN-DELISTED	Stock	43.33	43.71	42.8	42.96	484078.0
2018-04-16	AB	Stock	26.75	27.0	26.75	26.9	211500.0
2018-04-16	ABAC-DELISTED	Stock	2.53	2.6	2.51	2.57	4322.0
2018-04-16	ABAX-DELISTED	Stock	72.85	73.87	72.31	73.78	80310.0
2018-04-16	ABB-DELISTED	Stock	23.1	23.1	22.9163	23.01	2237333.0
2018-04-16	ABBNY-DELISTED	Stock	23.1	23.1	22.9163	23.01	2309758.0
2018-04-16	ABBV	Stock	92.89	93.49	92.31	92.6	3922500.0
2018-04-16	ABC-DELISTED	Stock	86.82	89.67	84.19	88.77	4686203.0
2018-04-16	ABCB	Stock	52.35	52.85	52.05	52.5	177800.0
2018-04-16	ABCD-DELISTED	Stock	11.61	12.39	11.57	12.24	338033.0
2018-04-16	ABDC-DELISTED	Stock	6.73	6.91	6.71	6.72	49247.0
2018-04-16	ABE-DELISTED	Stock	14.9	14.91	14.86	14.91	5432.0
2018-04-16	ABEO	Stock	503.75	506.25	479.0	502.5	36708.0
2018-04-16	ABEOW-DELISTED	Stock	14.7	15.0	14.35	14.998	4930.0
2018-04-16	ABEV	Stock	6.78	6.8	6.64	6.67	24099600.0
2018-04-16	ABG	Stock	67.2	68.85	66.7	68.1	172600.0
2018-04-16	ABIL-DELISTED	Stock	3.21	3.48	3.0701	3.35	4000.0
2018-04-16	ABLX-DELISTED	Stock	55.06	55.16	54.96	55.03	6426.0
2018-04-16	ABM	Stock	32.42	32.53	32.25	32.46	397300.0
2018-04-16	ABMD-DELISTED	Stock	298.0	299.99	294.68	296.31	208618.0

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

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