PREVIEW / stock_daily / 2017-05-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-18.parquet
  size:    214 KB
  rows:    6,442
  symbols: 3,005

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-05-18	AAPL	Stock	37.8175	38.335	37.7825	38.135	134272800.0
2017-05-18	MSFT	Stock	67.4	68.13	67.14	67.71	25201300.0
2017-05-18	NVDA	Stock	3.2375	3.3358	3.1762	3.3268	1156032000.0
2017-05-18	AMZN	Stock	47.24	48.1375	47.238	47.9245	78786000.0
2017-05-18	GOOGL	Stock	47.16	47.709	47.0635	47.525	36009300.0
2017-05-18	META	Stock	144.72	148.15	144.51	147.66	23031600.0
2017-05-18	TSLA	Stock	20.4667	20.9293	20.354	20.8707	84807000.0
2017-05-18	TLT	Stock	123.75	123.94	123.19	123.42	8350484.0
2017-05-18	ES	Stock	60.41	60.78	59.85	60.24	1495000.0
2017-05-18	CL	Stock	73.97	74.9	73.02	73.93	7494600.0
2017-05-18	A	Stock	55.9	56.27	55.6	55.85	1935000.0
2017-05-18	AA	Stock	31.45	32.17	31.1	31.92	2396800.0
2017-05-18	AAAP-DELISTED	Stock	36.1	36.5	36.1	36.18	21178.0
2017-05-18	AABA-DELISTED	Stock	48.68	50.03	47.74	49.63	12387490.0
2017-05-18	AAC-DELISTED	Stock	6.87	6.87	6.52	6.56	126149.0
2017-05-18	AACG	Stock	3.6	3.6	3.52	3.53	1500.0
2017-05-18	AAIC-DELISTED	Stock	14.0	14.19	14.0	14.1	218531.0
2017-05-18	AAL	Stock	44.4	45.4	44.38	44.65	6626700.0
2017-05-18	AAM.A-DELISTED	Stock	25.68	25.74	25.64	25.64	54294.0
2017-05-18	AAMC-DELISTED	Stock	20.7647	22.0588	20.7647	21.6176	3828.0
2017-05-18	AAME	Stock	3.7	3.7	3.7	3.7	600.0
2017-05-18	AAMI	Stock	14.07	14.47	14.02	14.18	1098400.0
2017-05-18	AAOI	Stock	60.06	65.3	58.96	63.98	3947300.0
2017-05-18	AAON	Stock	23.6667	24.0	23.5333	23.6667	195150.0
2017-05-18	AAP	Stock	144.73	149.16	144.52	148.51	1581100.0
2017-05-18	AAT	Stock	38.78	39.18	38.58	39.03	340800.0
2017-05-18	AAU-DELISTED	Stock	1.34	1.35	1.28	1.3	329151.0
2017-05-18	AAUAF-DELISTED	Stock	1.34	1.35	1.28	1.31	331131.0
2017-05-18	AAV-DELISTED	Stock	6.45	6.525	6.4	6.5	114420.0
2017-05-18	AAWW-DELISTED	Stock	46.1	46.3	45.45	46.05	1080447.0
2017-05-18	AAXJ	Stock	64.94	65.735	64.8	65.5	946560.0
2017-05-18	AAXN-DELISTED	Stock	24.5	24.65	24.08	24.14	705092.0
2017-05-18	AB	Stock	21.0	21.05	20.6	21.0	537400.0
2017-05-18	ABAC-DELISTED	Stock	1.8	1.9	1.8	1.88	22772.0
2017-05-18	ABAX-DELISTED	Stock	46.76	46.85	45.9	46.57	93731.0
2017-05-18	ABB-DELISTED	Stock	24.47	24.74	24.46	24.67	1814389.0
2017-05-18	ABBNY-DELISTED	Stock	24.47	24.74	24.46	24.67	1864606.0
2017-05-18	ABBV	Stock	65.37	66.1	65.2	65.63	6001000.0
2017-05-18	ABC-DELISTED	Stock	86.26	87.66	86.1201	86.69	974298.0
2017-05-18	ABCB	Stock	43.5	44.35	43.05	43.95	152000.0
2017-05-18	ABCD-DELISTED	Stock	4.99	5.06	4.9157	4.97	20442.0
2017-05-18	ABCO-DELISTED	Stock	50.95	52.75	50.775	51.6	499025.0
2017-05-18	ABDC-DELISTED	Stock	13.5	13.69	13.5	13.52	135093.0
2017-05-18	ABE-DELISTED	Stock	13.68	13.76	13.6	13.76	4440.0
2017-05-18	ABEO	Stock	151.25	161.25	147.5	150.0	17720.0
2017-05-18	ABEV	Stock	5.85	6.0	5.49	5.5	79770400.0
2017-05-18	ABG	Stock	52.5	57.15	52.5	56.45	272300.0
2017-05-18	ABIL-DELISTED	Stock	0.7	0.7499	0.65	0.6677	42346.0
2017-05-18	ABM	Stock	41.44	41.75	41.01	41.42	161900.0
2017-05-18	ABMD-DELISTED	Stock	129.96	133.88	129.8	133.21	424274.0

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

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