PREVIEW / stock_daily / 2018-11-06

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-06.parquet
  size:    221 KB
  rows:    6,550
  symbols: 2,711

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-06	AAPL	Stock	50.48	51.18	50.4225	50.9425	127531600.0
2018-11-06	MSFT	Stock	107.38	108.84	106.28	107.72	24340200.0
2018-11-06	NVDA	Stock	5.2862	5.3712	5.239	5.2765	299012000.0
2018-11-06	AMZN	Stock	80.9175	83.25	80.7275	82.1405	85148000.0
2018-11-06	GOOGL	Stock	52.751	53.991	52.6805	53.4785	28660260.0
2018-11-06	META	Stock	149.31	150.97	148.0	149.94	16667100.0
2018-11-06	TSLA	Stock	22.6047	23.2533	22.406	22.7373	101443500.0
2018-11-06	TLT	Stock	112.6	112.73	112.3333	112.37	3159875.0
2018-11-06	ES	Stock	62.97	63.52	62.86	63.47	733600.0
2018-11-06	CL	Stock	60.27	61.1	60.13	60.51	5171700.0
2018-11-06	A	Stock	66.04	66.42	65.67	65.98	2287300.0
2018-11-06	AA	Stock	36.1	36.58	35.68	36.19	2417800.0
2018-11-06	AABA-DELISTED	Stock	60.93	62.5827	60.93	61.93	4707555.0
2018-11-06	AAC-DELISTED	Stock	3.85	3.94	2.8	2.96	2864762.0
2018-11-06	AACG	Stock	1.13	1.21	1.06	1.19	338700.0
2018-11-06	AAIC-DELISTED	Stock	8.47	8.61	8.44	8.58	196396.0
2018-11-06	AAL	Stock	35.6	35.96	34.84	35.17	11376700.0
2018-11-06	AAM.A-DELISTED	Stock	24.723	24.7499	24.57	24.595	10591.0
2018-11-06	AAM.B-DELISTED	Stock	24.4205	24.4899	24.37	24.399	6996.0
2018-11-06	AAMC-DELISTED	Stock	13.8219	14.7059	13.8219	14.7059	2190.0
2018-11-06	AAME	Stock	3.22	3.6	2.96	3.1	25200.0
2018-11-06	AAMI	Stock	12.78	13.03	12.71	12.96	564800.0
2018-11-06	AAOI	Stock	19.4	20.44	19.01	20.3	828500.0
2018-11-06	AAON	Stock	26.8533	27.9533	26.7467	27.9067	482850.0
2018-11-06	AAP	Stock	166.56	168.79	165.69	168.09	1085900.0
2018-11-06	AAT	Stock	38.47	38.75	38.26	38.33	267200.0
2018-11-06	AAU-DELISTED	Stock	0.5499	0.55	0.5329	0.5437	39757.0
2018-11-06	AAUAF-DELISTED	Stock	0.5499	0.55	0.5329	0.5437	41293.0
2018-11-06	AAWW-DELISTED	Stock	54.51	55.46	53.695	54.98	115205.0
2018-11-06	AAXJ	Stock	65.23	65.56	65.18	65.5	393030.0
2018-11-06	AAXN-DELISTED	Stock	60.24	61.71	59.25	60.06	694132.0
2018-11-06	AB	Stock	28.9	29.19	28.58	29.07	311000.0
2018-11-06	ABAC-DELISTED	Stock	1.71	1.73	1.6624	1.72	8298.0
2018-11-06	ABB-DELISTED	Stock	20.38	20.47	20.295	20.41	1779694.0
2018-11-06	ABBNY-DELISTED	Stock	20.38	20.47	20.295	20.41	1865268.0
2018-11-06	ABBV	Stock	82.73	84.23	82.31	83.66	7945500.0
2018-11-06	ABC-DELISTED	Stock	83.5	85.94	80.2821	84.0	4451318.0
2018-11-06	ABCB	Stock	43.28	43.94	43.1	43.65	189600.0
2018-11-06	ABCD-DELISTED	Stock	14.42	14.46	14.37	14.4	188619.0
2018-11-06	ABDC-DELISTED	Stock	6.0	6.38	5.99	6.37	214208.0
2018-11-06	ABEO	Stock	231.75	235.5	221.25	223.5	13964.0
2018-11-06	ABEV	Stock	4.31	4.45	4.3	4.43	42427200.0
2018-11-06	ABG	Stock	67.01	67.83	66.64	67.26	157500.0
2018-11-06	ABIL-DELISTED	Stock	3.1	3.73	3.02	3.44	321186.0
2018-11-06	ABM	Stock	31.6	31.97	31.4	31.95	369900.0
2018-11-06	ABMD-DELISTED	Stock	392.78	399.5773	381.8371	389.87	310321.0
2018-11-06	ABR	Stock	12.19	12.2	11.95	12.16	1294300.0
2018-11-06	ABR.A-DELISTED	Stock	25.58	25.59	25.55	25.59	2800.0
2018-11-06	ABR.B-DELISTED	Stock	25.3708	25.3708	25.3708	25.3708	500.0
2018-11-06	ABR.C-DELISTED	Stock	25.64	25.6913	25.63	25.69	3800.0

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

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