PREVIEW / stock_daily / 2017-06-13

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-13.parquet
  size:    216 KB
  rows:    6,465
  symbols: 3,010

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
2017-06-13	AAPL	Stock	36.79	36.8625	36.2875	36.6475	136661600.0
2017-06-13	MSFT	Stock	70.02	70.82	69.96	70.65	25258600.0
2017-06-13	NVDA	Stock	3.86	3.8693	3.6412	3.785	1672504000.0
2017-06-13	AMZN	Stock	48.8995	49.225	48.305	49.0395	91600000.0
2017-06-13	GOOGL	Stock	48.602	48.8955	48.1005	48.525	40107120.0
2017-06-13	META	Stock	150.15	151.18	148.9	150.68	20483400.0
2017-06-13	TSLA	Stock	24.508	25.0667	24.4407	25.0633	177118500.0
2017-06-13	TLT	Stock	124.01	124.52	123.99	124.38	4742571.0
2017-06-13	ES	Stock	62.15	62.26	61.86	62.16	1011800.0
2017-06-13	CL	Stock	75.29	75.81	75.06	75.69	2591000.0
2017-06-13	A	Stock	59.07	59.64	58.93	59.28	1527000.0
2017-06-13	AA	Stock	31.97	32.548	31.55	32.48	2997100.0
2017-06-13	AAAP-DELISTED	Stock	35.81	36.6436	35.66	36.38	20504.0
2017-06-13	AABA-DELISTED	Stock	53.65	54.08	52.0	52.0	139872243.0
2017-06-13	AAC-DELISTED	Stock	6.56	6.72	6.47	6.55	63335.0
2017-06-13	AACG	Stock	5.0	5.0	4.63	4.9	67400.0
2017-06-13	AAIC-DELISTED	Stock	14.67	14.7	14.4	14.65	632347.0
2017-06-13	AAL	Stock	49.56	49.91	48.84	49.45	5153300.0
2017-06-13	AAM.A-DELISTED	Stock	25.35	25.52	25.3262	25.49	81948.0
2017-06-13	AAMC-DELISTED	Stock	25.2941	25.8382	24.7647	25.8382	6538.0
2017-06-13	AAME	Stock	3.75	3.8	3.7	3.8	2000.0
2017-06-13	AAMI	Stock	14.58	14.6	14.44	14.5	1592700.0
2017-06-13	AAOI	Stock	66.71	67.848	63.25	63.85	3186000.0
2017-06-13	AAON	Stock	24.9667	25.3333	24.8333	25.3	214950.0
2017-06-13	AAP	Stock	130.95	131.67	128.63	131.63	896100.0
2017-06-13	AAT	Stock	40.94	41.16	40.52	40.99	325700.0
2017-06-13	AAU-DELISTED	Stock	1.32	1.4	1.32	1.385	110913.0
2017-06-13	AAUAF-DELISTED	Stock	1.32	1.4	1.32	1.385	112096.0
2017-06-13	AAV-DELISTED	Stock	6.15	6.275	6.15	6.2	79577.0
2017-06-13	AAWW-DELISTED	Stock	53.25	53.8	52.9	53.55	160379.0
2017-06-13	AAXJ	Stock	67.79	67.9	67.63	67.82	1393548.0
2017-06-13	AAXN-DELISTED	Stock	24.26	24.5	24.12	24.47	420497.0
2017-06-13	AB	Stock	23.05	23.5	23.0	23.25	525200.0
2017-06-13	ABAC-DELISTED	Stock	2.02	2.15	2.02	2.145	13182.0
2017-06-13	ABAX-DELISTED	Stock	51.4	51.73	50.97	51.68	61470.0
2017-06-13	ABB-DELISTED	Stock	25.26	25.39	25.23	25.35	1714883.0
2017-06-13	ABBNY-DELISTED	Stock	25.26	25.39	25.23	25.34	1756958.0
2017-06-13	ABBV	Stock	69.62	70.03	69.42	69.67	5269000.0
2017-06-13	ABC-DELISTED	Stock	92.51	93.0	92.03	93.0	501525.0
2017-06-13	ABCB	Stock	48.55	48.95	47.9	48.2	186300.0
2017-06-13	ABCD-DELISTED	Stock	5.01	5.01	4.93	4.98	4347.0
2017-06-13	ABCO-DELISTED	Stock	51.0	51.05	50.6	51.0	179768.0
2017-06-13	ABDC-DELISTED	Stock	13.25	13.44	13.16	13.34	31312.0
2017-06-13	ABE-DELISTED	Stock	13.87	13.9	13.84	13.9	7140.0
2017-06-13	ABEO	Stock	120.0	125.0	117.5	125.0	7744.0
2017-06-13	ABEV	Stock	5.45	5.53	5.42	5.52	20779600.0
2017-06-13	ABG	Stock	58.0	58.0	56.45	57.45	123500.0
2017-06-13	ABIL-DELISTED	Stock	1.42	1.66	1.3	1.39	5262805.0
2017-06-13	ABM	Stock	40.77	41.43	40.52	41.4	448500.0
2017-06-13	ABMD-DELISTED	Stock	140.43	141.79	139.62	140.62	303078.0

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

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