PREVIEW / stock_daily / 2017-09-27

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-27.parquet
  size:    215 KB
  rows:    6,450
  symbols: 2,942

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-09-27	AAPL	Stock	38.45	38.68	38.385	38.5575	102016800.0
2017-09-27	MSFT	Stock	73.55	74.17	73.17	73.85	19565100.0
2017-09-27	NVDA	Stock	4.3905	4.4068	4.3188	4.3932	713720000.0
2017-09-27	AMZN	Stock	47.4	47.765	47.165	47.5435	62978000.0
2017-09-27	GOOGL	Stock	47.137	48.2715	47.0975	47.995	46692700.0
2017-09-27	META	Stock	165.9	168.34	165.57	167.68	19242500.0
2017-09-27	TSLA	Stock	23.3267	23.4327	22.7	22.7313	90904500.0
2017-09-27	TLT	Stock	124.87	125.3	124.61	124.85	12145700.0
2017-09-27	ES	Stock	61.04	61.19	60.25	60.43	1153200.0
2017-09-27	CL	Stock	73.18	73.43	72.33	73.08	4255400.0
2017-09-27	A	Stock	64.27	64.66	64.05	64.39	1272500.0
2017-09-27	AA	Stock	45.28	45.56	44.48	45.07	2391100.0
2017-09-27	AAAP-DELISTED	Stock	57.74	62.125	57.51	59.93	1464055.0
2017-09-27	AABA-DELISTED	Stock	65.13	66.27	65.01	65.83	9770798.0
2017-09-27	AAC-DELISTED	Stock	10.15	10.4	10.115	10.24	83441.0
2017-09-27	AACG	Stock	4.75	4.75	4.66	4.66	7800.0
2017-09-27	AAIC-DELISTED	Stock	13.29	13.335	13.05	13.24	817304.0
2017-09-27	AAL	Stock	47.1	48.1	46.63	46.85	6183200.0
2017-09-27	AAM.A-DELISTED	Stock	26.16	26.1698	26.02	26.06	7820.0
2017-09-27	AAMC-DELISTED	Stock	25.1985	25.1985	25.1985	25.1985	2383.0
2017-09-27	AAME	Stock	3.2	3.2	3.15	3.2	2600.0
2017-09-27	AAMI	Stock	14.39	14.56	14.27	14.46	451000.0
2017-09-27	AAOI	Stock	63.96	65.68	63.873	64.73	1906000.0
2017-09-27	AAON	Stock	22.6	23.4667	22.5333	23.3	315900.0
2017-09-27	AAP	Stock	98.2	99.45	97.41	99.33	1254000.0
2017-09-27	AAT	Stock	40.3	40.3	39.24	39.74	243300.0
2017-09-27	AAU-DELISTED	Stock	1.1	1.22	1.08	1.22	426811.0
2017-09-27	AAUAF-DELISTED	Stock	1.1	1.22	1.08	1.22	451876.0
2017-09-27	AAV-DELISTED	Stock	6.575	6.6	6.4	6.5	84887.0
2017-09-27	AAWW-DELISTED	Stock	65.5	66.55	65.1	66.1	162430.0
2017-09-27	AAXJ	Stock	71.38	71.65	71.165	71.52	1050327.0
2017-09-27	AAXN-DELISTED	Stock	22.72	23.07	22.67	23.05	483081.0
2017-09-27	AB	Stock	24.35	24.6	24.3	24.45	384500.0
2017-09-27	ABAC-DELISTED	Stock	2.1999	2.201	2.1999	2.201	3150.0
2017-09-27	ABAX-DELISTED	Stock	44.08	45.464	43.75	44.74	107716.0
2017-09-27	ABB-DELISTED	Stock	24.44	24.62	24.43	24.59	1075103.0
2017-09-27	ABBNY-DELISTED	Stock	24.44	24.62	24.43	24.59	1114636.0
2017-09-27	ABBV	Stock	85.35	85.39	83.19	84.75	6581200.0
2017-09-27	ABC-DELISTED	Stock	82.17	82.8	81.02	82.44	786493.0
2017-09-27	ABCB	Stock	45.9	47.65	45.8	47.15	274500.0
2017-09-27	ABCD-DELISTED	Stock	6.66	6.6902	6.1859	6.59	66209.0
2017-09-27	ABCO-DELISTED	Stock	53.55	53.7	53.5	53.675	649350.0
2017-09-27	ABDC-DELISTED	Stock	11.22	11.2399	11.0751	11.15	102653.0
2017-09-27	ABE-DELISTED	Stock	14.02	14.11	14.01	14.03	1815.0
2017-09-27	ABEO	Stock	358.75	390.0	356.25	378.75	33832.0
2017-09-27	ABEOW-DELISTED	Stock	10.29	10.29	10.18	10.18	200.0
2017-09-27	ABEV	Stock	6.59	6.62	6.49	6.59	18954400.0
2017-09-27	ABG	Stock	61.95	62.1	60.55	61.5	174800.0
2017-09-27	ABIL-DELISTED	Stock	0.8628	0.8758	0.75	0.7698	501708.0
2017-09-27	ABM	Stock	40.43	41.41	40.37	41.15	408200.0

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

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