PREVIEW / stock_daily / 2017-11-29

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-29.parquet
  size:    216 KB
  rows:    6,496
  symbols: 2,905

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-11-29	AAPL	Stock	43.1575	43.23	41.79	42.37	166665600.0
2017-11-29	MSFT	Stock	84.71	84.92	83.18	83.34	27381100.0
2017-11-29	NVDA	Stock	5.2502	5.253	4.7808	4.9105	1396788000.0
2017-11-29	AMZN	Stock	59.74	59.74	57.2595	58.0635	185150000.0
2017-11-29	GOOGL	Stock	52.809	52.9385	51.4827	51.869	55866640.0
2017-11-29	META	Stock	181.89	181.97	174.0	175.13	41933500.0
2017-11-29	TSLA	Stock	21.1533	21.2	20.082	20.5027	131511000.0
2017-11-29	TLT	Stock	125.56	125.68	125.1031	125.54	14547146.0
2017-11-29	ES	Stock	64.48	65.03	64.26	64.61	1599400.0
2017-11-29	CL	Stock	71.42	72.72	71.31	72.01	3646400.0
2017-11-29	A	Stock	70.5	70.84	68.45	68.69	1904000.0
2017-11-29	AA	Stock	42.19	42.32	40.8	41.24	4938500.0
2017-11-29	AAAP-DELISTED	Stock	81.3	81.35	81.29	81.34	609798.0
2017-11-29	AABA-DELISTED	Stock	71.61	71.7	68.51	70.36	14091998.0
2017-11-29	AAC-DELISTED	Stock	8.98	9.36	8.95	9.08	243350.0
2017-11-29	AACG	Stock	5.03	5.08	5.03	5.06	4700.0
2017-11-29	AAIC-DELISTED	Stock	11.88	11.99	11.83	11.91	364993.0
2017-11-29	AAL	Stock	49.38	51.16	48.66	49.25	8154200.0
2017-11-29	AAM.A-DELISTED	Stock	26.44	26.44	26.15	26.2725	25165.0
2017-11-29	AAMC-DELISTED	Stock	21.9559	21.9559	20.75	21.7647	5464.0
2017-11-29	AAME	Stock	3.7	3.7	3.69	3.7	7400.0
2017-11-29	AAMI	Stock	16.15	16.685	16.14	16.45	946100.0
2017-11-29	AAOI	Stock	43.06	43.72	42.32	43.3	1360800.0
2017-11-29	AAON	Stock	23.9	24.5733	23.9	24.5	190800.0
2017-11-29	AAP	Stock	93.96	100.37	93.41	99.95	3895200.0
2017-11-29	AAT	Stock	39.73	39.97	39.45	39.74	197300.0
2017-11-29	AAU-DELISTED	Stock	0.89	0.8984	0.871	0.89	89366.0
2017-11-29	AAUAF-DELISTED	Stock	0.89	0.8984	0.871	0.89	93200.0
2017-11-29	AAV-DELISTED	Stock	4.7	4.775	4.65	4.675	105231.0
2017-11-29	AAWW-DELISTED	Stock	56.2	56.95	56.0	56.4	223946.0
2017-11-29	AAXJ	Stock	77.13	77.13	76.06	76.33	1489260.0
2017-11-29	AAXN-DELISTED	Stock	24.79	25.09	24.54	24.96	461252.0
2017-11-29	AB	Stock	25.45	25.7	24.8	24.9	327500.0
2017-11-29	ABAC-DELISTED	Stock	3.05	3.2	2.97	3.09	54852.0
2017-11-29	ABAX-DELISTED	Stock	50.18	51.71	49.91	51.61	77540.0
2017-11-29	ABB-DELISTED	Stock	25.7	25.7275	25.44	25.49	1532482.0
2017-11-29	ABBNY-DELISTED	Stock	25.7	25.7275	25.44	25.5	1588255.0
2017-11-29	ABBV	Stock	95.76	96.35	95.03	95.82	4081400.0
2017-11-29	ABC-DELISTED	Stock	83.56	85.63	83.045	84.66	2059147.0
2017-11-29	ABCB	Stock	50.2	51.15	49.85	50.9	300300.0
2017-11-29	ABCD-DELISTED	Stock	5.84	5.87	5.75	5.82	21041.0
2017-11-29	ABDC-DELISTED	Stock	8.29	8.55	8.2738	8.45	123438.0
2017-11-29	ABE-DELISTED	Stock	14.3	14.3	14.0625	14.0625	1579.0
2017-11-29	ABEO	Stock	436.25	442.5	413.75	416.25	42736.0
2017-11-29	ABEOW-DELISTED	Stock	12.49	12.5	12.49	12.5	1100.0
2017-11-29	ABEV	Stock	6.39	6.41	6.27	6.3	14912300.0
2017-11-29	ABG	Stock	65.35	68.3	65.35	67.4	270000.0
2017-11-29	ABIL-DELISTED	Stock	0.5378	0.61	0.5101	0.53	1278266.0
2017-11-29	ABLX-DELISTED	Stock	22.35	22.46	22.2	22.4	126338.0
2017-11-29	ABM	Stock	42.16	42.55	41.79	42.2	300300.0

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

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