PREVIEW / stock_daily / 2017-12-01

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-01.parquet
  size:    217 KB
  rows:    6,502
  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-12-01	AAPL	Stock	42.4875	42.9175	42.125	42.7625	159037200.0
2017-12-01	MSFT	Stock	83.6	84.81	83.22	84.26	29532100.0
2017-12-01	NVDA	Stock	4.9828	5.0033	4.8118	4.942	811548000.0
2017-12-01	AMZN	Stock	58.6025	58.9825	57.6	58.1175	82142000.0
2017-12-01	GOOGL	Stock	51.5205	51.8622	50.845	51.2535	37761620.0
2017-12-01	META	Stock	176.03	177.48	172.34	175.1	20182500.0
2017-12-01	TSLA	Stock	20.3627	20.688	20.3367	20.4353	64393500.0
2017-12-01	TLT	Stock	125.87	127.69	125.1	126.55	24583127.0
2017-12-01	ES	Stock	65.15	66.12	65.05	65.43	3423600.0
2017-12-01	CL	Stock	72.51	73.08	71.93	73.04	4478100.0
2017-12-01	A	Stock	69.19	70.0	67.23	68.69	2516500.0
2017-12-01	AA	Stock	41.82	42.3	40.521	41.64	3750900.0
2017-12-01	AAAP-DELISTED	Stock	81.2	81.36	81.2	81.34	671456.0
2017-12-01	AABA-DELISTED	Stock	69.8	71.25	69.47	70.14	18069751.0
2017-12-01	AAC-DELISTED	Stock	9.24	9.24	8.73	8.97	147348.0
2017-12-01	AACG	Stock	5.0	5.02	5.0	5.02	1600.0
2017-12-01	AAIC-DELISTED	Stock	11.67	11.82	11.45	11.79	475995.0
2017-12-01	AAL	Stock	49.67	50.38	48.69	49.0	6229600.0
2017-12-01	AAM.A-DELISTED	Stock	25.98	26.03	25.91	26.0	24450.0
2017-12-01	AAMC-DELISTED	Stock	20.5882	21.1471	20.5882	21.1471	15269.0
2017-12-01	AAME	Stock	3.66	3.7	3.5	3.7	900.0
2017-12-01	AAMI	Stock	16.41	16.6	16.06	16.47	910600.0
2017-12-01	AAOI	Stock	43.21	43.89	41.83	43.38	1137800.0
2017-12-01	AAON	Stock	24.3	24.3	23.2	24.2333	262050.0
2017-12-01	AAP	Stock	100.74	100.97	97.89	99.28	2252900.0
2017-12-01	AAT	Stock	39.4	39.57	38.72	39.22	191400.0
2017-12-01	AAU-DELISTED	Stock	0.88	0.89	0.869	0.8798	197893.0
2017-12-01	AAUAF-DELISTED	Stock	0.88	0.89	0.869	0.8798	202132.0
2017-12-01	AAV-DELISTED	Stock	4.75	4.9	4.725	4.775	206718.0
2017-12-01	AAWW-DELISTED	Stock	57.95	58.9	57.1	58.9	355531.0
2017-12-01	AAXJ	Stock	75.31	75.5199	74.77	75.13	1541794.0
2017-12-01	AAXN-DELISTED	Stock	24.9	24.91	23.82	24.5	641820.0
2017-12-01	AB	Stock	25.0	25.1	24.35	24.85	239000.0
2017-12-01	ABAC-DELISTED	Stock	3.04	3.04	2.6833	2.8745	19828.0
2017-12-01	ABAX-DELISTED	Stock	48.69	48.69	45.13	48.14	171671.0
2017-12-01	ABB-DELISTED	Stock	25.63	25.69	25.49	25.65	1646782.0
2017-12-01	ABBNY-DELISTED	Stock	25.63	25.69	25.49	25.66	1989879.0
2017-12-01	ABBV	Stock	97.19	98.52	94.3	96.32	4823200.0
2017-12-01	ABC-DELISTED	Stock	83.98	85.25	81.2076	84.94	2860894.0
2017-12-01	ABCB	Stock	49.65	49.9	47.35	49.75	256000.0
2017-12-01	ABCD-DELISTED	Stock	5.96	5.96	5.65	5.83	45400.0
2017-12-01	ABDC-DELISTED	Stock	8.63	8.63	8.35	8.41	76451.0
2017-12-01	ABE-DELISTED	Stock	14.12	14.15	14.0996	14.15	5644.0
2017-12-01	ABEO	Stock	436.25	438.75	406.25	413.75	25524.0
2017-12-01	ABEOW-DELISTED	Stock	11.8	11.9	11.46	11.9	2002.0
2017-12-01	ABEV	Stock	6.21	6.27	6.19	6.22	14311100.0
2017-12-01	ABG	Stock	65.9	66.55	64.6	66.25	120700.0
2017-12-01	ABIL-DELISTED	Stock	0.48	0.5091	0.4301	0.485	191055.0
2017-12-01	ABLX-DELISTED	Stock	23.01	23.76	23.01	23.44	72453.0
2017-12-01	ABM	Stock	42.8	42.96	41.65	42.66	289800.0

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

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