PREVIEW / stock_daily / 2017-10-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-26.parquet
  size:    215 KB
  rows:    6,451
  symbols: 2,909

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-10-26	AAPL	Stock	39.3075	39.4575	39.195	39.3525	68002000.0
2017-10-26	MSFT	Stock	79.2	79.42	78.75	78.76	32120700.0
2017-10-26	NVDA	Stock	4.8695	4.904	4.8452	4.8923	322744000.0
2017-10-26	AMZN	Stock	49.0165	49.145	48.4275	48.6215	112374000.0
2017-10-26	GOOGL	Stock	49.9235	50.3255	49.5235	49.571	47396760.0
2017-10-26	META	Stock	171.38	172.29	170.39	170.63	11833100.0
2017-10-26	TSLA	Stock	21.852	22.0153	21.5467	21.7447	75352500.0
2017-10-26	TLT	Stock	123.06	123.06	122.43	122.43	8179440.0
2017-10-26	ES	Stock	62.52	62.84	62.15	62.24	1615900.0
2017-10-26	CL	Stock	71.77	72.17	71.1	71.21	4020700.0
2017-10-26	A	Stock	67.53	67.83	67.2	67.71	1417900.0
2017-10-26	AA	Stock	49.52	49.73	48.52	49.15	3468500.0
2017-10-26	AAAP-DELISTED	Stock	73.04	74.28	68.4	68.97	782729.0
2017-10-26	AABA-DELISTED	Stock	65.5	66.01	65.07	65.62	4607535.0
2017-10-26	AAC-DELISTED	Stock	8.32	8.45	8.13	8.31	64617.0
2017-10-26	AACG	Stock	4.54	4.54	4.54	4.54	400.0
2017-10-26	AAIC-DELISTED	Stock	11.83	11.84	11.5	11.5	843614.0
2017-10-26	AAL	Stock	52.0	53.19	48.32	48.61	12079000.0
2017-10-26	AAM.A-DELISTED	Stock	26.14	26.18	26.05	26.18	11272.0
2017-10-26	AAMC-DELISTED	Stock	24.6471	24.6471	24.5588	24.6029	3811.0
2017-10-26	AAME	Stock	3.2	3.25	3.2	3.25	700.0
2017-10-26	AAMI	Stock	15.43	15.71	15.35	15.66	251700.0
2017-10-26	AAOI	Stock	40.35	40.8	38.5	38.68	1825500.0
2017-10-26	AAON	Stock	23.3333	23.42	23.1667	23.1667	109800.0
2017-10-26	AAP	Stock	82.89	87.64	81.31	85.65	3229400.0
2017-10-26	AAT	Stock	39.3	39.78	38.97	39.0	291200.0
2017-10-26	AAU-DELISTED	Stock	1.06	1.08	1.04	1.05	446431.0
2017-10-26	AAUAF-DELISTED	Stock	1.06	1.08	1.04	1.05	449108.0
2017-10-26	AAV-DELISTED	Stock	5.35	5.35	5.16	5.2	139725.0
2017-10-26	AAWW-DELISTED	Stock	63.35	63.85	62.75	62.8	97169.0
2017-10-26	AAXJ	Stock	74.48	74.61	74.08	74.08	811051.0
2017-10-26	AAXN-DELISTED	Stock	22.1	22.47	22.0824	22.43	476949.0
2017-10-26	AB	Stock	26.2	26.2	25.7	25.95	332900.0
2017-10-26	ABAC-DELISTED	Stock	3.44	3.48	3.32	3.4	5161.0
2017-10-26	ABAX-DELISTED	Stock	49.49	50.02	48.01	49.15	90569.0
2017-10-26	ABB-DELISTED	Stock	25.58	25.59	25.405	25.43	1864353.0
2017-10-26	ABBNY-DELISTED	Stock	25.58	25.59	25.405	25.43	1925468.0
2017-10-26	ABBV	Stock	91.86	91.86	85.24	89.56	10307500.0
2017-10-26	ABC-DELISTED	Stock	83.97	85.8	77.47	78.77	4426103.0
2017-10-26	ABCB	Stock	48.65	49.25	48.55	49.05	149700.0
2017-10-26	ABCD-DELISTED	Stock	6.01	6.27	5.93	6.15	33263.0
2017-10-26	ABCO-DELISTED	Stock	53.9	53.975	52.35	53.9	320382.0
2017-10-26	ABDC-DELISTED	Stock	10.1	10.1	9.86	9.97	38672.0
2017-10-26	ABE-DELISTED	Stock	14.48	14.48	14.4552	14.46	13384.0
2017-10-26	ABEO	Stock	443.75	457.5	426.25	435.0	58152.0
2017-10-26	ABEOW-DELISTED	Stock	12.5	12.5	12.27	12.27	1400.0
2017-10-26	ABEV	Stock	6.41	6.48	6.32	6.32	15849500.0
2017-10-26	ABG	Stock	58.8	62.15	58.8	61.6	280000.0
2017-10-26	ABIL-DELISTED	Stock	0.68	0.68	0.65	0.66	10220.0
2017-10-26	ABLX-DELISTED	Stock	20.89	21.94	20.48	21.17	1101987.0

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

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