PREVIEW / stock_daily / 2019-04-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-16.parquet
  size:    220 KB
  rows:    6,537
  symbols: 2,586

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-04-16	AAPL	Stock	49.865	50.3425	49.64	49.8125	102785600.0
2019-04-16	MSFT	Stock	121.64	121.65	120.1	120.77	14071800.0
2019-04-16	NVDA	Stock	4.657	4.7243	4.624	4.7053	394964000.0
2019-04-16	AMZN	Stock	92.5675	93.4885	92.4	93.152	60892000.0
2019-04-16	GOOGL	Stock	61.5	61.799	61.252	61.5955	22621980.0
2019-04-16	META	Stock	179.0	180.17	178.3	178.87	11215200.0
2019-04-16	TSLA	Stock	17.7167	18.3333	17.648	18.224	109093500.0
2019-04-16	TLT	Stock	122.51	122.63	122.14	122.21	8927558.0
2019-04-16	ES	Stock	70.68	71.09	69.98	70.15	1429800.0
2019-04-16	CL	Stock	68.72	69.27	68.72	69.04	3183400.0
2019-04-16	A	Stock	80.82	80.96	77.19	77.55	3441500.0
2019-04-16	AA	Stock	27.8	27.96	27.4	27.72	4094300.0
2019-04-16	AABA-DELISTED	Stock	74.88	75.3	74.47	75.16	3608344.0
2019-04-16	AAC-DELISTED	Stock	1.98	2.0	1.705	1.74	544979.0
2019-04-16	AACG	Stock	2.99	3.08	2.69	2.72	1544100.0
2019-04-16	AAIC-DELISTED	Stock	7.52	7.63	7.52	7.6	295395.0
2019-04-16	AAIC.C-DELISTED	Stock	23.41	23.5	23.3735	23.5	15256.0
2019-04-16	AAL	Stock	33.96	34.09	33.59	34.03	4498400.0
2019-04-16	AAM.A-DELISTED	Stock	24.98	25.03	24.9	24.98	118848.0
2019-04-16	AAM.B-DELISTED	Stock	24.91	25.0	24.85	24.96	92781.0
2019-04-16	AAMC-DELISTED	Stock	8.8235	8.8235	8.8235	8.8235	853.0
2019-04-16	AAME	Stock	2.45	2.45	2.44	2.44	3100.0
2019-04-16	AAMI	Stock	14.45	14.525	14.37	14.5	616800.0
2019-04-16	AAOI	Stock	12.36	12.88	12.36	12.64	613400.0
2019-04-16	AAON	Stock	31.9	32.6467	31.9	32.2667	200250.0
2019-04-16	AAP	Stock	182.56	182.56	179.51	179.95	676900.0
2019-04-16	AAT	Stock	45.87	45.87	44.21	44.32	195900.0
2019-04-16	AAU-DELISTED	Stock	0.6	0.6	0.5587	0.5793	123744.0
2019-04-16	AAUAF-DELISTED	Stock	0.6	0.6	0.5587	0.5793	140337.0
2019-04-16	AAWW-DELISTED	Stock	49.69	50.29	48.72	50.06	216217.0
2019-04-16	AAXJ	Stock	73.06	73.19	72.99	73.1	446635.0
2019-04-16	AAXN-DELISTED	Stock	61.21	61.61	60.9228	61.51	317356.0
2019-04-16	AB	Stock	29.6	29.85	29.43	29.77	260000.0
2019-04-16	ABB-DELISTED	Stock	19.99	20.005	19.915	19.95	1318230.0
2019-04-16	ABBNY-DELISTED	Stock	19.99	20.005	19.915	19.95	1398319.0
2019-04-16	ABBV	Stock	81.11	81.3	80.02	80.21	3624700.0
2019-04-16	ABC-DELISTED	Stock	76.29	76.9	74.43	75.35	1293538.0
2019-04-16	ABCB	Stock	35.2	36.0	35.03	35.92	185300.0
2019-04-16	ABDC-DELISTED	Stock	8.03	8.11	7.85	7.85	52324.0
2019-04-16	ABEO	Stock	193.5	205.25	193.5	203.0	32488.0
2019-04-16	ABEV	Stock	4.46	4.54	4.44	4.46	13796900.0
2019-04-16	ABG	Stock	75.56	76.77	75.45	76.4	181500.0
2019-04-16	ABIL-DELISTED	Stock	1.72	1.73	1.6695	1.6883	34985.0
2019-04-16	ABM	Stock	37.72	37.77	37.04	37.16	397200.0
2019-04-16	ABMD-DELISTED	Stock	273.95	275.515	264.54	265.96	418504.0
2019-04-16	ABR	Stock	13.71	13.76	13.64	13.74	659500.0
2019-04-16	ABR.A-DELISTED	Stock	25.89	25.9499	25.8123	25.89	2126.0
2019-04-16	ABR.B-DELISTED	Stock	25.55	25.55	25.55	25.55	150.0
2019-04-16	ABR.C-DELISTED	Stock	26.1038	26.2199	26.1038	26.2199	1600.0
2019-04-16	ABT	Stock	77.94	78.7	76.06	76.38	6227800.0

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

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