PREVIEW / stock_daily / 2018-10-12

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-12.parquet
  size:    221 KB
  rows:    6,524
  symbols: 2,713

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-10-12	AAPL	Stock	55.105	55.72	54.21	55.5275	161351600.0
2018-10-12	MSFT	Stock	109.01	111.24	107.12	109.57	47742100.0
2018-10-12	NVDA	Stock	6.1378	6.2385	5.9913	6.1635	608236000.0
2018-10-12	AMZN	Stock	90.4	90.4475	87.1265	89.4305	188892000.0
2018-10-12	GOOGL	Stock	55.982	56.2915	54.7513	56.027	49378400.0
2018-10-12	META	Stock	156.73	156.89	151.3	153.74	25293500.0
2018-10-12	TSLA	Stock	17.4	17.466	16.8007	17.252	108021000.0
2018-10-12	TLT	Stock	114.39	115.01	114.28	114.47	6794138.0
2018-10-12	ES	Stock	61.62	61.74	60.98	61.52	1660600.0
2018-10-12	CL	Stock	62.64	62.9	61.91	62.54	4297100.0
2018-10-12	A	Stock	66.1	67.03	65.3	66.24	3669500.0
2018-10-12	AA	Stock	36.39	36.55	35.59	35.67	2848500.0
2018-10-12	AABA-DELISTED	Stock	62.02	62.22	60.9	61.99	5395706.0
2018-10-12	AAC-DELISTED	Stock	7.01	7.07	6.86	6.93	154648.0
2018-10-12	AACG	Stock	1.09	1.11	1.01	1.05	28200.0
2018-10-12	AAIC-DELISTED	Stock	8.51	8.58	8.38	8.41	453216.0
2018-10-12	AAL	Stock	31.97	32.13	30.81	30.91	12905200.0
2018-10-12	AAM.A-DELISTED	Stock	24.32	24.32	24.1006	24.21	20675.0
2018-10-12	AAM.B-DELISTED	Stock	24.11	24.2	24.0	24.05	21151.0
2018-10-12	AAMC-DELISTED	Stock	14.1674	15.3971	13.8235	15.2059	9571.0
2018-10-12	AAME	Stock	2.74	2.98	2.55	2.75	18000.0
2018-10-12	AAMI	Stock	12.24	12.3	11.98	12.15	682400.0
2018-10-12	AAOI	Stock	22.54	23.22	22.29	22.92	971600.0
2018-10-12	AAON	Stock	21.54	21.54	21.06	21.26	317400.0
2018-10-12	AAP	Stock	163.58	165.95	162.62	165.12	1096700.0
2018-10-12	AAT	Stock	36.21	36.21	35.37	35.46	264300.0
2018-10-12	AAU-DELISTED	Stock	0.55	0.59	0.49	0.5	373129.0
2018-10-12	AAUAF-DELISTED	Stock	0.55	0.59	0.49	0.5	378833.0
2018-10-12	AAWW-DELISTED	Stock	53.43	53.9099	51.85	53.16	343166.0
2018-10-12	AAXJ	Stock	64.78	65.18	64.16	64.98	2205171.0
2018-10-12	AAXN-DELISTED	Stock	57.85	59.12	57.29	58.87	556784.0
2018-10-12	AB	Stock	28.72	29.33	28.66	29.2	489300.0
2018-10-12	ABAC-DELISTED	Stock	1.7721	1.9	1.75	1.9	9100.0
2018-10-12	ABB-DELISTED	Stock	21.45	21.5	21.01	21.27	1515583.0
2018-10-12	ABBNY-DELISTED	Stock	21.45	21.5	21.01	21.26	1587514.0
2018-10-12	ABBV	Stock	90.71	91.08	88.9	90.69	5709600.0
2018-10-12	ABC-DELISTED	Stock	88.25	88.78	86.76	88.44	950677.0
2018-10-12	ABCB	Stock	44.55	44.55	41.86	43.22	639500.0
2018-10-12	ABCD-DELISTED	Stock	11.89	12.18	11.78	12.08	80996.0
2018-10-12	ABDC-DELISTED	Stock	5.96	6.0063	5.96	6.0	25058.0
2018-10-12	ABEO	Stock	270.0	272.0	257.5	260.0	25200.0
2018-10-12	ABEOW-DELISTED	Stock	5.85	5.85	5.85	5.85	100.0
2018-10-12	ABEV	Stock	4.51	4.62	4.51	4.59	17532600.0
2018-10-12	ABG	Stock	60.96	61.2	58.75	59.94	370700.0
2018-10-12	ABIL-DELISTED	Stock	3.11	3.126	2.8	2.99	41829.0
2018-10-12	ABM	Stock	31.57	31.68	30.2	30.52	594000.0
2018-10-12	ABMD-DELISTED	Stock	381.57	396.19	374.26	384.84	724753.0
2018-10-12	ABR	Stock	11.63	11.71	11.55	11.64	744400.0
2018-10-12	ABR.A-DELISTED	Stock	25.3713	25.5	25.3713	25.5	1200.0
2018-10-12	ABR.C-DELISTED	Stock	25.8218	26.0577	25.72	26.0577	600.0

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

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