PREVIEW / stock_daily / 2018-11-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-14.parquet
  size:    221 KB
  rows:    6,556
  symbols: 2,708

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-14	AAPL	Stock	48.475	48.62	46.4825	46.7	243204000.0
2018-11-14	MSFT	Stock	108.1	108.26	104.47	104.97	39495100.0
2018-11-14	NVDA	Stock	5.1575	5.172	4.8208	4.9298	526580000.0
2018-11-14	AMZN	Stock	82.816	83.65	79.8535	79.9505	129738000.0
2018-11-14	GOOGL	Stock	53.0	53.2895	52.0555	52.729	34666040.0
2018-11-14	META	Stock	143.7	145.58	141.55	144.22	22068400.0
2018-11-14	TSLA	Stock	22.8467	23.1407	22.4767	22.9333	75604500.0
2018-11-14	TLT	Stock	113.48	114.52	113.3	114.09	8690822.0
2018-11-14	ES	Stock	64.67	65.82	64.67	65.43	1609100.0
2018-11-14	CL	Stock	62.3	62.95	61.97	62.47	6798800.0
2018-11-14	A	Stock	64.64	64.84	63.28	63.47	4852600.0
2018-11-14	AA	Stock	34.91	35.6	34.25	35.15	2872900.0
2018-11-14	AABA-DELISTED	Stock	62.34	63.23	61.71	62.31	7180377.0
2018-11-14	AAC-DELISTED	Stock	2.45	2.49	2.31	2.33	267372.0
2018-11-14	AACG	Stock	1.09	1.09	1.05	1.07	27800.0
2018-11-14	AAIC-DELISTED	Stock	8.47	8.55	8.37	8.44	313768.0
2018-11-14	AAL	Stock	38.0	38.59	37.45	38.11	7288400.0
2018-11-14	AAM.A-DELISTED	Stock	24.6299	24.65	24.55	24.61	13767.0
2018-11-14	AAM.B-DELISTED	Stock	24.49	24.49	24.37	24.4268	24222.0
2018-11-14	AAMC-DELISTED	Stock	13.8235	13.8235	13.8205	13.8206	4039.0
2018-11-14	AAME	Stock	3.17	3.17	2.84	2.84	7000.0
2018-11-14	AAMI	Stock	13.0	13.0	12.655	12.8	339400.0
2018-11-14	AAOI	Stock	20.5	21.41	20.18	20.19	999500.0
2018-11-14	AAON	Stock	28.9067	28.94	27.6267	27.68	489300.0
2018-11-14	AAP	Stock	185.99	186.15	177.61	177.68	1806900.0
2018-11-14	AAT	Stock	39.53	39.59	38.98	39.29	184500.0
2018-11-14	AAU-DELISTED	Stock	0.52	0.52	0.48	0.4906	294233.0
2018-11-14	AAUAF-DELISTED	Stock	0.52	0.52	0.48	0.5	299727.0
2018-11-14	AAWW-DELISTED	Stock	55.34	56.23	53.75	54.32	88397.0
2018-11-14	AAXJ	Stock	64.88	65.09	64.16	64.68	916523.0
2018-11-14	AAXN-DELISTED	Stock	50.29	50.6832	48.92	49.62	594987.0
2018-11-14	AB	Stock	30.25	30.39	29.7	30.05	204400.0
2018-11-14	ABAC-DELISTED	Stock	1.68	1.69	1.61	1.61	2991.0
2018-11-14	ABB-DELISTED	Stock	19.79	19.87	19.65	19.7	1905084.0
2018-11-14	ABBNY-DELISTED	Stock	19.79	19.87	19.65	19.7	1958273.0
2018-11-14	ABBV	Stock	89.05	89.4	86.45	88.31	7268200.0
2018-11-14	ABC-DELISTED	Stock	91.52	92.44	89.21	89.58	984408.0
2018-11-14	ABCB	Stock	44.72	44.84	43.41	43.57	324000.0
2018-11-14	ABCD-DELISTED	Stock	14.43	14.46	14.41	14.41	173131.0
2018-11-14	ABDC-DELISTED	Stock	6.41	6.44	6.27	6.29	62122.0
2018-11-14	ABEO	Stock	195.0	200.75	173.5	187.5	34948.0
2018-11-14	ABEOW-DELISTED	Stock	3.1799	3.25	3.1799	3.25	550.0
2018-11-14	ABEV	Stock	4.16	4.22	4.13	4.2	26568700.0
2018-11-14	ABG	Stock	69.59	70.66	68.12	68.66	188800.0
2018-11-14	ABIL-DELISTED	Stock	2.99	3.0662	2.91	2.95	20367.0
2018-11-14	ABM	Stock	30.37	30.57	29.72	30.18	465500.0
2018-11-14	ABMD-DELISTED	Stock	333.3	335.16	309.825	312.57	867640.0
2018-11-14	ABR	Stock	12.46	12.47	12.12	12.18	1649500.0
2018-11-14	ABR.A-DELISTED	Stock	25.38	25.38	25.2939	25.32	5991.0
2018-11-14	ABR.B-DELISTED	Stock	25.49	25.49	25.4	25.43	2053.0

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

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