PREVIEW / stock_daily / 2017-04-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-25.parquet
  size:    215 KB
  rows:    6,479
  symbols: 3,047

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-04-25	AAPL	Stock	35.9775	36.225	35.9675	36.1325	75486000.0
2017-04-25	MSFT	Stock	67.9	68.04	67.6	67.92	30242700.0
2017-04-25	NVDA	Stock	2.5885	2.6333	2.5668	2.6185	388440000.0
2017-04-25	AMZN	Stock	45.352	45.474	45.15	45.381	67612000.0
2017-04-25	GOOGL	Stock	44.113	44.6125	43.964	44.442	40760640.0
2017-04-25	META	Stock	145.79	147.15	145.79	146.49	17767500.0
2017-04-25	TSLA	Stock	20.5333	20.932	20.3907	20.9193	101065500.0
2017-04-25	TLT	Stock	122.21	122.46	121.38	121.45	8122253.0
2017-04-25	ES	Stock	59.81	60.16	59.65	60.0	1340300.0
2017-04-25	CL	Stock	73.91	74.37	73.73	74.22	3623100.0
2017-04-25	A	Stock	54.75	55.19	54.51	54.81	2181900.0
2017-04-25	AA	Stock	34.23	36.55	34.23	36.49	11203200.0
2017-04-25	AAAP-DELISTED	Stock	37.4	38.28	37.03	37.18	95086.0
2017-04-25	AABA-DELISTED	Stock	48.29	48.46	48.155	48.41	9987778.0
2017-04-25	AAC-DELISTED	Stock	7.21	7.39	7.03	7.05	58636.0
2017-04-25	AACG	Stock	3.93	3.93	3.72	3.78	19600.0
2017-04-25	AAIC-DELISTED	Stock	14.5	14.63	14.37	14.49	450375.0
2017-04-25	AAL	Stock	46.8	47.39	46.38	46.61	5960600.0
2017-04-25	AAM.A-DELISTED	Stock	25.28	25.33	25.23	25.25	230931.0
2017-04-25	AAMC-DELISTED	Stock	21.9118	22.0588	21.9118	22.0147	8476.0
2017-04-25	AAMI	Stock	15.58	15.69	15.43	15.53	405100.0
2017-04-25	AAOI	Stock	48.21	49.85	47.74	49.4	3409800.0
2017-04-25	AAON	Stock	24.6667	25.1667	24.6333	24.6667	178050.0
2017-04-25	AAP	Stock	147.0	147.0	144.2	145.67	1030400.0
2017-04-25	AAT	Stock	43.12	43.56	43.12	43.48	266700.0
2017-04-25	AAU-DELISTED	Stock	1.56	1.56	1.47	1.5001	350417.0
2017-04-25	AAUAF-DELISTED	Stock	1.56	1.56	1.45	1.45	352811.0
2017-04-25	AAV-DELISTED	Stock	6.5	6.5	6.3083	6.4	52578.0
2017-04-25	AAWW-DELISTED	Stock	58.6	59.2	58.4	58.45	106221.0
2017-04-25	AAXJ	Stock	64.08	64.28	64.08	64.16	1706778.0
2017-04-25	AAXN-DELISTED	Stock	24.21	24.3	24.0801	24.17	540831.0
2017-04-25	AB	Stock	22.95	23.0	22.65	22.8	566300.0
2017-04-25	ABAC-DELISTED	Stock	1.77	1.9	1.6	1.8799	102479.0
2017-04-25	ABAX-DELISTED	Stock	49.73	49.84	48.86	48.96	64184.0
2017-04-25	ABB-DELISTED	Stock	23.98	24.31	23.97	24.24	2891188.0
2017-04-25	ABBNY-DELISTED	Stock	23.98	24.31	23.97	24.24	3210024.0
2017-04-25	ABBV	Stock	64.94	65.63	64.82	65.1	5352900.0
2017-04-25	ABC-DELISTED	Stock	80.82	81.57	79.4	81.51	1719659.0
2017-04-25	ABCB	Stock	47.9	48.45	47.25	47.5	174000.0
2017-04-25	ABCD-DELISTED	Stock	4.98	5.0	4.91	4.96	19642.0
2017-04-25	ABCO-DELISTED	Stock	47.15	47.5	46.95	47.0	229268.0
2017-04-25	ABDC-DELISTED	Stock	14.08	14.38	13.58	14.2	96058.0
2017-04-25	ABE-DELISTED	Stock	13.51	13.5903	13.5	13.5702	2655.0
2017-04-25	ABEO	Stock	131.25	140.0	131.0	136.25	11632.0
2017-04-25	ABEOW-DELISTED	Stock	3.0	3.0	2.9	2.9999	954.0
2017-04-25	ABEV	Stock	5.66	5.81	5.65	5.78	28765800.0
2017-04-25	ABG	Stock	63.6	64.0	62.2	62.65	153800.0
2017-04-25	ABIL-DELISTED	Stock	0.9	0.91	0.9	0.9001	11746.0
2017-04-25	ABM	Stock	43.82	44.16	43.6	43.63	216200.0
2017-04-25	ABMD-DELISTED	Stock	129.66	130.26	128.51	129.15	204207.0

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

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