PREVIEW / stock_daily / 2018-11-05

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-05.parquet
  size:    221 KB
  rows:    6,568
  symbols: 2,724

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-11-05	AAPL	Stock	51.075	51.0975	49.5425	50.3975	264654800.0
2018-11-05	MSFT	Stock	106.37	107.74	105.9	107.51	27922100.0
2018-11-05	NVDA	Stock	5.3598	5.3832	5.132	5.2943	379332000.0
2018-11-05	AMZN	Stock	82.8785	82.9045	79.818	81.39	112494000.0
2018-11-05	GOOGL	Stock	53.6265	53.6675	51.7	52.7865	45357400.0
2018-11-05	META	Stock	150.1	150.19	147.44	148.68	15971200.0
2018-11-05	TSLA	Stock	22.7	22.9307	22.0093	22.76	117465000.0
2018-11-05	TLT	Stock	112.48	112.71	112.35	112.44	4760223.0
2018-11-05	ES	Stock	62.43	63.24	62.22	62.92	1459300.0
2018-11-05	CL	Stock	60.16	61.11	59.68	60.23	7833700.0
2018-11-05	A	Stock	66.03	66.39	65.23	65.91	2348700.0
2018-11-05	AA	Stock	36.84	37.166	36.381	36.6	1774700.0
2018-11-05	AABA-DELISTED	Stock	61.43	62.21	60.68	60.84	3120282.0
2018-11-05	AAC-DELISTED	Stock	5.75	5.85	5.24	5.31	170976.0
2018-11-05	AACG	Stock	1.16	1.22	1.09	1.13	100500.0
2018-11-05	AAIC-DELISTED	Stock	8.49	8.55	8.43	8.49	368477.0
2018-11-05	AAL	Stock	36.35	36.52	35.13	35.72	11305300.0
2018-11-05	AAM.A-DELISTED	Stock	24.8083	24.8083	24.64	24.73	9939.0
2018-11-05	AAM.B-DELISTED	Stock	24.501	24.5289	24.4	24.4	15010.0
2018-11-05	AAME	Stock	3.1	3.1	3.0	3.1	1300.0
2018-11-05	AAMI	Stock	12.2	12.78	12.2	12.76	551800.0
2018-11-05	AAOI	Stock	20.39	20.46	18.41	19.44	1678400.0
2018-11-05	AAON	Stock	26.0067	27.0933	25.9467	26.9667	558750.0
2018-11-05	AAP	Stock	165.24	166.11	163.29	165.11	1250700.0
2018-11-05	AAT	Stock	37.95	39.02	37.95	38.47	187400.0
2018-11-05	AAU-DELISTED	Stock	0.54	0.5565	0.5391	0.5396	61450.0
2018-11-05	AAUAF-DELISTED	Stock	0.54	0.5565	0.5391	0.5396	71464.0
2018-11-05	AAWW-DELISTED	Stock	55.2	56.02	54.25	54.72	272842.0
2018-11-05	AAXJ	Stock	65.31	65.65	65.15	65.57	1086561.0
2018-11-05	AAXN-DELISTED	Stock	61.2	61.94	59.2	60.44	504181.0
2018-11-05	AB	Stock	28.54	29.18	28.3	28.92	249600.0
2018-11-05	ABAC-DELISTED	Stock	1.7	1.7329	1.69	1.71	2940.0
2018-11-05	ABB-DELISTED	Stock	20.43	20.45	20.205	20.325	2697033.0
2018-11-05	ABBNY-DELISTED	Stock	20.43	20.45	20.205	20.32	2962800.0
2018-11-05	ABBV	Stock	79.45	83.83	79.27	82.58	10315600.0
2018-11-05	ABC-DELISTED	Stock	89.17	89.565	88.25	88.56	956976.0
2018-11-05	ABCB	Stock	43.7	44.07	42.92	43.33	251700.0
2018-11-05	ABCD-DELISTED	Stock	14.45	14.46	14.36	14.435	214497.0
2018-11-05	ABDC-DELISTED	Stock	5.77	5.93	5.77	5.88	41103.0
2018-11-05	ABEO	Stock	232.0	237.5	220.75	231.25	15068.0
2018-11-05	ABEV	Stock	4.4	4.43	4.32	4.38	28190700.0
2018-11-05	ABG	Stock	68.35	68.71	66.73	67.23	238200.0
2018-11-05	ABIL-DELISTED	Stock	3.0	3.2756	2.9137	3.12	35359.0
2018-11-05	ABM	Stock	32.09	32.45	31.56	31.59	614300.0
2018-11-05	ABMD-DELISTED	Stock	385.85	395.24	379.51	392.98	522144.0
2018-11-05	ABR	Stock	12.27	12.31	12.11	12.14	1147100.0
2018-11-05	ABR.A-DELISTED	Stock	25.585	25.65	25.55	25.6003	1850.0
2018-11-05	ABR.B-DELISTED	Stock	25.3993	25.3993	25.3764	25.3764	1400.0
2018-11-05	ABR.C-DELISTED	Stock	25.7882	25.7882	25.63	25.68	3056.0
2018-11-05	ABT	Stock	70.48	71.0	69.99	70.39	8558700.0

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

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