PREVIEW / stock_daily / 2018-12-07

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-07.parquet
  size:    220 KB
  rows:    6,548
  symbols: 2,685

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
2018-12-07	AAPL	Stock	43.3725	43.6225	42.075	42.1225	169126400.0
2018-12-07	MSFT	Stock	108.38	109.45	104.3	104.82	45044900.0
2018-12-07	NVDA	Stock	3.9615	3.9718	3.6405	3.6903	681676000.0
2018-12-07	AMZN	Stock	85.2535	85.9465	81.273	81.4565	151522000.0
2018-12-07	GOOGL	Stock	53.6115	54.2515	51.9685	52.329	42682220.0
2018-12-07	META	Stock	139.25	140.87	136.66	137.42	21195500.0
2018-12-07	TSLA	Stock	24.6	25.2993	23.8433	23.8647	172668000.0
2018-12-07	TLT	Stock	117.81	118.53	117.52	118.41	8608467.0
2018-12-07	ES	Stock	69.18	69.72	68.63	69.46	1287600.0
2018-12-07	CL	Stock	63.29	64.29	62.66	62.71	4072700.0
2018-12-07	A	Stock	71.71	72.09	69.65	70.25	2184500.0
2018-12-07	AA	Stock	30.15	30.21	28.68	28.82	3383900.0
2018-12-07	AABA-DELISTED	Stock	63.55	64.65	62.47	62.99	5711344.0
2018-12-07	AAC-DELISTED	Stock	2.03	2.23	2.0	2.15	352643.0
2018-12-07	AACG	Stock	1.05	1.12	1.05	1.06	52900.0
2018-12-07	AAIC-DELISTED	Stock	8.37	8.51	8.3343	8.4	291981.0
2018-12-07	AAL	Stock	36.58	36.6	33.38	33.57	14380100.0
2018-12-07	AAM.A-DELISTED	Stock	22.56	22.6702	22.45	22.5	53615.0
2018-12-07	AAM.B-DELISTED	Stock	22.69	22.7804	22.4759	22.49	40922.0
2018-12-07	AAME	Stock	2.52	2.52	2.42	2.42	1800.0
2018-12-07	AAMI	Stock	11.95	12.11	11.66	11.77	640400.0
2018-12-07	AAOI	Stock	19.93	20.39	19.05	19.14	834900.0
2018-12-07	AAON	Stock	23.8267	24.3	23.2267	23.42	304350.0
2018-12-07	AAP	Stock	174.62	177.26	167.38	167.59	761800.0
2018-12-07	AAT	Stock	42.82	42.85	42.14	42.2	149800.0
2018-12-07	AAU-DELISTED	Stock	0.6301	0.67	0.61	0.6642	239355.0
2018-12-07	AAUAF-DELISTED	Stock	0.6301	0.67	0.61	0.6642	247085.0
2018-12-07	AAWW-DELISTED	Stock	51.84	52.7775	49.85	50.03	193923.0
2018-12-07	AAXJ	Stock	65.79	66.21	64.65	64.83	2650550.0
2018-12-07	AAXN-DELISTED	Stock	44.37	45.08	42.895	43.5397	561547.0
2018-12-07	AB	Stock	27.75	28.5	27.75	28.17	497600.0
2018-12-07	ABAC-DELISTED	Stock	1.3239	1.375	1.26	1.375	7197.0
2018-12-07	ABB-DELISTED	Stock	19.12	19.22	18.77	18.86	3193755.0
2018-12-07	ABBNY-DELISTED	Stock	19.12	19.22	18.77	18.85	3285017.0
2018-12-07	ABBV	Stock	89.93	90.0	86.37	86.96	6737700.0
2018-12-07	ABC-DELISTED	Stock	85.54	86.26	84.0	84.32	770438.0
2018-12-07	ABCB	Stock	38.34	39.89	37.04	37.44	356300.0
2018-12-07	ABCD-DELISTED	Stock	14.47	14.5	14.46	14.48	337631.0
2018-12-07	ABDC-DELISTED	Stock	6.4	6.45	6.36	6.445	28854.0
2018-12-07	ABEO	Stock	202.0	222.5	193.25	213.5	44768.0
2018-12-07	ABEV	Stock	4.13	4.19	4.06	4.08	19312300.0
2018-12-07	ABG	Stock	65.53	66.24	63.96	64.35	192200.0
2018-12-07	ABIL-DELISTED	Stock	2.49	2.57	2.36	2.36	129676.0
2018-12-07	ABM	Stock	29.18	29.56	28.09	28.2	345500.0
2018-12-07	ABMD-DELISTED	Stock	331.56	333.0	315.045	317.53	329941.0
2018-12-07	ABR	Stock	11.85	11.92	11.8	11.8	1734200.0
2018-12-07	ABR.A-DELISTED	Stock	25.57	25.57	25.2365	25.3	1245.0
2018-12-07	ABR.B-DELISTED	Stock	25.7	25.74	25.21	25.6	1623.0
2018-12-07	ABR.C-DELISTED	Stock	25.75	25.75	25.696	25.7045	1900.0
2018-12-07	ABT	Stock	71.75	71.83	69.19	69.95	7945500.0

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

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