PREVIEW / stock_daily / 2017-12-12

all stock daily files

  file:    by_date/stock_daily/2017/2017-12-12.parquet
  size:    218 KB
  rows:    6,509
  symbols: 2,914

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-12-12	AAPL	Stock	43.0375	43.0975	42.865	42.925	77636800.0
2017-12-12	MSFT	Stock	85.31	86.05	85.08	85.58	23924100.0
2017-12-12	NVDA	Stock	4.8225	4.846	4.7472	4.771	455016000.0
2017-12-12	AMZN	Stock	58.3255	58.68	58.0805	58.254	44718000.0
2017-12-12	GOOGL	Stock	52.5	53.125	52.2435	52.4385	33881220.0
2017-12-12	META	Stock	178.6	179.18	176.6	176.96	16854100.0
2017-12-12	TSLA	Stock	22.03	22.7627	22.002	22.7353	130998000.0
2017-12-12	TLT	Stock	126.17	126.41	125.67	126.38	7502439.0
2017-12-12	ES	Stock	65.46	65.61	64.13	64.21	1701900.0
2017-12-12	CL	Stock	73.16	73.16	72.41	72.49	3296600.0
2017-12-12	A	Stock	67.0	67.16	66.5	67.06	2181000.0
2017-12-12	AA	Stock	42.39	42.88	42.185	42.4	3421500.0
2017-12-12	AAAP-DELISTED	Stock	81.6	81.67	81.58	81.63	365823.0
2017-12-12	AABA-DELISTED	Stock	71.07	71.15	69.55	69.77	9670485.0
2017-12-12	AAC-DELISTED	Stock	8.87	9.17	8.82	9.1	159252.0
2017-12-12	AACG	Stock	5.78	5.78	5.33	5.5	20600.0
2017-12-12	AAIC-DELISTED	Stock	12.15	12.229	12.13	12.15	288744.0
2017-12-12	AAL	Stock	51.27	51.53	50.38	50.47	2798200.0
2017-12-12	AAM.A-DELISTED	Stock	26.25	26.3079	26.0837	26.1	9426.0
2017-12-12	AAME	Stock	3.2	3.35	3.1	3.1	20500.0
2017-12-12	AAMI	Stock	16.13	16.35	16.09	16.19	393000.0
2017-12-12	AAOI	Stock	40.0	40.996	39.5	40.15	885200.0
2017-12-12	AAON	Stock	23.4	23.6333	23.1667	23.2333	310800.0
2017-12-12	AAP	Stock	101.71	105.56	101.71	103.03	2442400.0
2017-12-12	AAT	Stock	38.87	39.22	38.84	39.06	157700.0
2017-12-12	AAU-DELISTED	Stock	0.8705	0.93	0.8705	0.8999	355423.0
2017-12-12	AAUAF-DELISTED	Stock	0.8705	0.93	0.8705	0.8999	373908.0
2017-12-12	AAV-DELISTED	Stock	4.05	4.1	3.95	4.0	772530.0
2017-12-12	AAWW-DELISTED	Stock	56.7	57.65	56.65	57.05	203172.0
2017-12-12	AAXJ	Stock	75.21	75.28	75.025	75.15	1067398.0
2017-12-12	AAXN-DELISTED	Stock	24.69	25.2	24.528	25.16	438135.0
2017-12-12	AB	Stock	24.9	25.25	24.85	24.95	410800.0
2017-12-12	ABAC-DELISTED	Stock	2.97	3.1131	2.95	3.09	21431.0
2017-12-12	ABAX-DELISTED	Stock	47.42	47.9	47.27	47.32	91841.0
2017-12-12	ABB-DELISTED	Stock	25.88	26.06	25.87	26.04	926599.0
2017-12-12	ABBNY-DELISTED	Stock	25.88	26.06	25.87	26.03	991862.0
2017-12-12	ABBV	Stock	95.72	96.69	94.76	96.3	4195200.0
2017-12-12	ABC-DELISTED	Stock	87.37	87.87	86.79	87.82	1194909.0
2017-12-12	ABCB	Stock	46.6	47.35	46.6	47.0	214200.0
2017-12-12	ABCD-DELISTED	Stock	5.51	5.6	5.38	5.47	55425.0
2017-12-12	ABDC-DELISTED	Stock	8.28	8.549	8.25	8.45	164162.0
2017-12-12	ABE-DELISTED	Stock	14.22	14.22	14.13	14.1699	14270.0
2017-12-12	ABEO	Stock	387.5	401.25	383.75	386.25	18396.0
2017-12-12	ABEV	Stock	6.29	6.52	6.27	6.47	28909400.0
2017-12-12	ABG	Stock	67.1	68.1	66.05	66.45	332500.0
2017-12-12	ABIL-DELISTED	Stock	0.4	0.419	0.4	0.4173	72972.0
2017-12-12	ABLX-DELISTED	Stock	23.73	24.1	23.67	23.97	92584.0
2017-12-12	ABM	Stock	43.88	44.7	43.39	43.83	362200.0
2017-12-12	ABMD-DELISTED	Stock	194.06	195.13	192.44	192.96	144395.0
2017-12-12	ABR	Stock	8.69	8.73	8.64	8.66	732600.0

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

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