PREVIEW / stock_daily / 2018-10-25

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-25.parquet
  size:    221 KB
  rows:    6,543
  symbols: 2,718

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-10-25	AAPL	Stock	54.4275	55.345	54.1875	54.95	119423200.0
2018-10-25	MSFT	Stock	106.55	109.27	106.15	108.3	61646800.0
2018-10-25	NVDA	Stock	4.8868	5.2438	4.842	5.196	951720000.0
2018-10-25	AMZN	Stock	85.167	89.7405	84.6005	89.1085	205714000.0
2018-10-25	GOOGL	Stock	54.015	55.891	53.7773	55.1795	72956280.0
2018-10-25	META	Stock	147.73	152.21	147.0	150.95	22105700.0
2018-10-25	TSLA	Stock	21.148	21.4	20.0673	20.9907	312610500.0
2018-10-25	TLT	Stock	114.54	114.74	114.23	114.3	12613470.0
2018-10-25	ES	Stock	64.34	64.43	63.33	63.67	1691200.0
2018-10-25	CL	Stock	64.82	65.04	63.61	63.82	6263100.0
2018-10-25	A	Stock	61.49	62.89	61.07	62.61	3318300.0
2018-10-25	AA	Stock	34.56	35.19	33.88	34.56	3200400.0
2018-10-25	AABA-DELISTED	Stock	59.7	60.945	59.58	60.74	4160352.0
2018-10-25	AAC-DELISTED	Stock	6.88	6.94	6.7	6.84	177799.0
2018-10-25	AACG	Stock	1.12	1.18	1.09	1.12	133500.0
2018-10-25	AAIC-DELISTED	Stock	8.26	8.54	8.26	8.48	710536.0
2018-10-25	AAL	Stock	31.19	33.33	31.12	32.37	18375200.0
2018-10-25	AAM.A-DELISTED	Stock	24.45	24.6	24.3312	24.4998	13720.0
2018-10-25	AAM.B-DELISTED	Stock	24.21	24.51	24.21	24.51	20033.0
2018-10-25	AAMC-DELISTED	Stock	14.1088	14.1088	14.1088	14.1088	2060.0
2018-10-25	AAME	Stock	2.98	2.98	2.94	2.97	4100.0
2018-10-25	AAMI	Stock	11.24	11.5	11.19	11.45	406000.0
2018-10-25	AAOI	Stock	20.72	21.82	20.709	21.56	686400.0
2018-10-25	AAON	Stock	21.7533	22.5267	21.72	22.3333	370950.0
2018-10-25	AAP	Stock	159.41	164.41	157.13	163.17	1350400.0
2018-10-25	AAT	Stock	36.63	37.79	36.35	37.69	524700.0
2018-10-25	AAU-DELISTED	Stock	0.52	0.5835	0.52	0.5753	244732.0
2018-10-25	AAUAF-DELISTED	Stock	0.52	0.5835	0.52	0.5753	263933.0
2018-10-25	AAWW-DELISTED	Stock	48.19	50.86	48.19	50.27	248856.0
2018-10-25	AAXJ	Stock	62.42	63.3	62.28	62.94	771188.0
2018-10-25	AAXN-DELISTED	Stock	58.22	59.439	57.83	58.95	371191.0
2018-10-25	AB	Stock	28.78	29.32	28.61	29.12	389500.0
2018-10-25	ABAC-DELISTED	Stock	1.73	1.73	1.6799	1.7	3371.0
2018-10-25	ABB-DELISTED	Stock	19.72	20.05	19.69	19.81	2803030.0
2018-10-25	ABBNY-DELISTED	Stock	19.72	20.05	19.69	19.81	2913756.0
2018-10-25	ABBV	Stock	80.4	83.19	79.66	81.73	9173500.0
2018-10-25	ABC-DELISTED	Stock	84.63	87.3	83.58	85.7	2269282.0
2018-10-25	ABCB	Stock	39.98	42.56	39.98	42.04	389800.0
2018-10-25	ABCD-DELISTED	Stock	14.4	14.4	14.38	14.4	405678.0
2018-10-25	ABDC-DELISTED	Stock	5.73	5.805	5.62	5.74	55936.0
2018-10-25	ABEO	Stock	217.0	229.25	213.75	224.0	36808.0
2018-10-25	ABEOW-DELISTED	Stock	4.35	4.48	4.35	4.35	2383.0
2018-10-25	ABEV	Stock	3.97	4.06	3.86	4.04	76548200.0
2018-10-25	ABG	Stock	66.27	67.69	65.75	67.01	470800.0
2018-10-25	ABIL-DELISTED	Stock	3.14	3.21	3.05	3.0804	100958.0
2018-10-25	ABM	Stock	29.87	30.44	29.73	30.15	514100.0
2018-10-25	ABMD-DELISTED	Stock	352.0	352.0	317.0	333.01	1103072.0
2018-10-25	ABR	Stock	11.76	11.92	11.6	11.87	810100.0
2018-10-25	ABR.A-DELISTED	Stock	25.42	25.4561	25.41	25.44	1423.0
2018-10-25	ABR.B-DELISTED	Stock	25.2525	25.3	25.2525	25.2987	2600.0

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

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