PREVIEW / stock_daily / 2017-03-24

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-24.parquet
  size:    214 KB
  rows:    6,440
  symbols: 3,027

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-03-24	AAPL	Stock	35.375	35.435	35.0875	35.16	89582400.0
2017-03-24	MSFT	Stock	65.36	65.45	64.76	64.98	22617100.0
2017-03-24	NVDA	Stock	2.7242	2.7323	2.6605	2.6868	439500000.0
2017-03-24	AMZN	Stock	42.584	42.59	42.1765	42.2805	42766000.0
2017-03-24	GOOGL	Stock	42.1	42.2	41.455	41.757	42113640.0
2017-03-24	META	Stock	140.08	141.02	139.76	140.34	16664700.0
2017-03-24	TSLA	Stock	17.0467	17.5927	17.0007	17.544	84709500.0
2017-03-24	TLT	Stock	120.53	121.1	120.4	120.88	5819630.0
2017-03-24	ES	Stock	59.58	60.16	59.51	60.01	1310600.0
2017-03-24	CL	Stock	73.92	74.0	73.35	73.67	2621900.0
2017-03-24	A	Stock	54.05	54.05	52.84	53.08	2015300.0
2017-03-24	AA	Stock	33.61	33.86	32.365	32.56	4111000.0
2017-03-24	AAAP-DELISTED	Stock	39.5	39.92	38.86	38.98	114930.0
2017-03-24	AABA-DELISTED	Stock	46.65	46.865	46.14	46.405	4988311.0
2017-03-24	AAC-DELISTED	Stock	7.74	8.08	7.58	8.0	102067.0
2017-03-24	AACG	Stock	3.98	4.08	3.95	3.95	20600.0
2017-03-24	AAIC-DELISTED	Stock	14.35	14.62	14.31	14.44	708356.0
2017-03-24	AAL	Stock	41.69	42.07	41.42	41.73	6596600.0
2017-03-24	AAM.A-DELISTED	Stock	25.04	25.14	25.0	25.06	212203.0
2017-03-24	AAMC-DELISTED	Stock	15.8824	17.4265	15.8824	16.9853	46777.0
2017-03-24	AAME	Stock	3.66	3.9	3.66	3.9	2900.0
2017-03-24	AAMI	Stock	14.47	14.66	14.45	14.56	699900.0
2017-03-24	AAOI	Stock	51.78	55.719	51.78	55.02	2127600.0
2017-03-24	AAON	Stock	24.3333	24.5	23.9333	24.1667	284400.0
2017-03-24	AAP	Stock	150.78	151.0	149.35	149.73	615600.0
2017-03-24	AAT	Stock	42.05	42.45	41.86	41.92	291300.0
2017-03-24	AAU-DELISTED	Stock	1.15	1.15	1.11	1.12	94744.0
2017-03-24	AAUAF-DELISTED	Stock	1.15	1.15	1.11	1.12	96766.0
2017-03-24	AAV-DELISTED	Stock	6.05	6.225	6.05	6.2	116397.0
2017-03-24	AAWW-DELISTED	Stock	51.95	52.25	51.2	51.5	122518.0
2017-03-24	AAXJ	Stock	63.26	63.44	63.17	63.31	512608.0
2017-03-24	AAXN-DELISTED	Stock	22.67	22.89	22.36	22.49	437468.0
2017-03-24	AB	Stock	21.65	21.8	21.6	21.7	194700.0
2017-03-24	ABAC-DELISTED	Stock	2.23	2.39	2.23	2.335	7626.0
2017-03-24	ABAX-DELISTED	Stock	48.19	48.82	47.66	48.08	112916.0
2017-03-24	ABB-DELISTED	Stock	23.25	23.41	23.24	23.28	1259303.0
2017-03-24	ABBNY-DELISTED	Stock	23.25	23.41	23.23	23.28	1347188.0
2017-03-24	ABBV	Stock	65.51	66.11	65.32	65.62	4056300.0
2017-03-24	ABC-DELISTED	Stock	85.99	86.83	85.72	86.57	1018005.0
2017-03-24	ABCB	Stock	43.55	44.65	43.15	44.5	305700.0
2017-03-24	ABCD-DELISTED	Stock	5.2	5.2	5.0501	5.0601	17440.0
2017-03-24	ABCO-DELISTED	Stock	44.75	49.25	44.4	44.7	852953.0
2017-03-24	ABDC-DELISTED	Stock	13.56	13.75	13.48	13.75	62072.0
2017-03-24	ABE-DELISTED	Stock	12.6383	12.7	12.6383	12.645	2500.0
2017-03-24	ABEO	Stock	118.75	123.75	116.25	120.0	7244.0
2017-03-24	ABEOW-DELISTED	Stock	2.0	2.6	2.0	2.524	1850.0
2017-03-24	ABEV	Stock	5.56	5.62	5.53	5.61	16710800.0
2017-03-24	ABG	Stock	60.45	61.0	60.25	60.65	352500.0
2017-03-24	ABIL-DELISTED	Stock	2.3253	2.3253	2.3253	2.3253	200.0
2017-03-24	ABM	Stock	43.45	43.74	43.23	43.26	289100.0

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

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