PREVIEW / stock_daily / 2017-10-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-27.parquet
  size:    215 KB
  rows:    6,439
  symbols: 2,901

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-27	AAPL	Stock	39.8225	40.9	39.675	40.7625	177816800.0
2017-10-27	MSFT	Stock	84.37	86.2	83.61	83.81	71066700.0
2017-10-27	NVDA	Stock	4.945	5.0468	4.9188	5.0465	572192000.0
2017-10-27	AMZN	Stock	52.907	55.279	52.5275	55.0475	331300000.0
2017-10-27	GOOGL	Stock	51.5495	53.181	51.3425	51.6835	103682860.0
2017-10-27	META	Stock	174.15	178.21	173.9	177.88	30285300.0
2017-10-27	TSLA	Stock	21.3167	21.6393	21.1107	21.3913	104695500.0
2017-10-27	TLT	Stock	122.94	123.325	122.75	123.24	10480857.0
2017-10-27	ES	Stock	62.14	62.84	62.12	62.79	1266400.0
2017-10-27	CL	Stock	70.4	70.9	69.14	70.4	8704000.0
2017-10-27	A	Stock	67.81	68.01	67.41	67.97	1441000.0
2017-10-27	AA	Stock	47.835	48.25	47.01	47.91	3870200.0
2017-10-27	AAAP-DELISTED	Stock	69.41	73.14	68.24	72.98	289337.0
2017-10-27	AABA-DELISTED	Stock	66.48	67.73	65.87	67.53	7327505.0
2017-10-27	AAC-DELISTED	Stock	8.41	8.61	8.2	8.56	48376.0
2017-10-27	AACG	Stock	4.63	4.7	4.63	4.7	3600.0
2017-10-27	AAIC-DELISTED	Stock	11.3	11.73	11.28	11.61	737301.0
2017-10-27	AAL	Stock	48.41	48.89	47.33	47.56	8591500.0
2017-10-27	AAM.A-DELISTED	Stock	26.06	26.15	26.06	26.14	20666.0
2017-10-27	AAME	Stock	3.25	3.5	3.25	3.5	2700.0
2017-10-27	AAMI	Stock	15.64	15.85	15.48	15.67	486400.0
2017-10-27	AAOI	Stock	38.65	39.39	37.27	39.27	2050900.0
2017-10-27	AAON	Stock	23.2	23.4333	23.0	23.2	152850.0
2017-10-27	AAP	Stock	85.14	85.65	81.81	81.93	2927800.0
2017-10-27	AAT	Stock	38.97	39.59	38.91	39.42	302100.0
2017-10-27	AAU-DELISTED	Stock	1.05	1.06	1.01	1.0112	270714.0
2017-10-27	AAUAF-DELISTED	Stock	1.05	1.06	1.01	1.0112	286542.0
2017-10-27	AAV-DELISTED	Stock	5.2	5.25	5.05	5.2	142408.0
2017-10-27	AAWW-DELISTED	Stock	63.0	63.0	61.65	62.25	150344.0
2017-10-27	AAXJ	Stock	74.42	75.09	74.23	75.05	1030579.0
2017-10-27	AAXN-DELISTED	Stock	22.49	22.93	22.2501	22.92	543816.0
2017-10-27	AB	Stock	26.2	26.6	26.0	26.3	375100.0
2017-10-27	ABAC-DELISTED	Stock	3.45	3.5334	3.26	3.5334	16071.0
2017-10-27	ABAX-DELISTED	Stock	49.24	49.34	48.5701	49.32	60264.0
2017-10-27	ABB-DELISTED	Stock	25.29	25.37	25.23	25.36	964665.0
2017-10-27	ABBNY-DELISTED	Stock	25.29	25.37	25.23	25.36	1020265.0
2017-10-27	ABBV	Stock	92.7	94.97	90.75	91.93	9066300.0
2017-10-27	ABC-DELISTED	Stock	78.59	78.77	75.66	76.39	4350711.0
2017-10-27	ABCB	Stock	49.15	49.4	48.5	48.8	259300.0
2017-10-27	ABCD-DELISTED	Stock	6.14	6.2	5.95	5.96	30481.0
2017-10-27	ABCO-DELISTED	Stock	53.95	54.15	53.8	53.9	521890.0
2017-10-27	ABDC-DELISTED	Stock	9.98	10.03	9.855	9.89	50193.0
2017-10-27	ABE-DELISTED	Stock	14.43	14.4863	14.425	14.43	13091.0
2017-10-27	ABEO	Stock	432.5	438.75	425.0	432.5	37672.0
2017-10-27	ABEOW-DELISTED	Stock	12.3576	12.6	12.22	12.38	529.0
2017-10-27	ABEV	Stock	6.41	6.48	6.37	6.39	21930900.0
2017-10-27	ABG	Stock	61.4	61.85	60.25	60.9	348100.0
2017-10-27	ABIL-DELISTED	Stock	0.66	0.67	0.6052	0.62	126671.0
2017-10-27	ABLX-DELISTED	Stock	20.67	20.98	20.11	20.51	703416.0
2017-10-27	ABM	Stock	42.3	42.71	42.18	42.29	222700.0

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

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