PREVIEW / stock_daily / 2018-07-10

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-10.parquet
  size:    218 KB
  rows:    6,517
  symbols: 2,790

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-07-10	AAPL	Stock	47.6775	47.82	47.545	47.5875	63756400.0
2018-07-10	MSFT	Stock	102.0	102.51	101.86	102.12	19293100.0
2018-07-10	NVDA	Stock	6.2438	6.3535	6.203	6.3313	360016000.0
2018-07-10	AMZN	Stock	86.9265	87.5	86.55	87.1535	60058000.0
2018-07-10	GOOGL	Stock	58.4995	58.675	58.128	58.357	21334080.0
2018-07-10	META	Stock	204.5	204.91	202.26	203.54	13190100.0
2018-07-10	TSLA	Stock	21.6373	21.8453	21.28	21.498	142072500.0
2018-07-10	TLT	Stock	121.87	122.13	121.81	121.95	5759682.0
2018-07-10	ES	Stock	58.33	59.08	57.8	58.72	2001900.0
2018-07-10	CL	Stock	65.1	65.77	64.7	65.73	2613800.0
2018-07-10	A	Stock	63.37	63.74	63.07	63.67	1924400.0
2018-07-10	AA	Stock	48.05	48.87	47.518	47.89	2234800.0
2018-07-10	AABA-DELISTED	Stock	76.4	76.92	75.6	76.02	7552804.0
2018-07-10	AAC-DELISTED	Stock	9.53	9.53	9.29	9.36	88181.0
2018-07-10	AACG	Stock	4.09	4.5	4.06	4.3	4200.0
2018-07-10	AAIC-DELISTED	Stock	10.37	10.41	10.33	10.37	347207.0
2018-07-10	AAL	Stock	39.38	39.4	38.5	39.12	4910000.0
2018-07-10	AAM.A-DELISTED	Stock	25.741	25.81	25.741	25.81	12674.0
2018-07-10	AAM.B-DELISTED	Stock	24.98	25.0	24.94	25.0	64734.0
2018-07-10	AAMC-DELISTED	Stock	20.1471	20.1471	19.7356	20.1471	5739.0
2018-07-10	AAME	Stock	2.4	2.45	2.4	2.45	5400.0
2018-07-10	AAMI	Stock	14.66	14.73	14.6	14.67	407000.0
2018-07-10	AAOI	Stock	45.35	47.0	45.01	45.79	934200.0
2018-07-10	AAON	Stock	23.8	23.8333	23.3333	23.5333	279000.0
2018-07-10	AAP	Stock	140.94	141.91	139.4	140.65	963300.0
2018-07-10	AAT	Stock	38.52	38.67	38.07	38.09	280900.0
2018-07-10	AAU-DELISTED	Stock	0.722	0.7499	0.715	0.715	122183.0
2018-07-10	AAUAF-DELISTED	Stock	0.722	0.7499	0.715	0.715	130025.0
2018-07-10	AAV-DELISTED	Stock	3.15	3.25	3.15	3.2	117201.0
2018-07-10	AAWW-DELISTED	Stock	72.95	73.15	71.2	71.5	121915.0
2018-07-10	AAXJ	Stock	72.28	72.28	71.66	72.11	627458.0
2018-07-10	AAXN-DELISTED	Stock	67.28	68.06	66.05	67.35	544488.0
2018-07-10	AB	Stock	29.6	29.65	29.38	29.6	282800.0
2018-07-10	ABAC-DELISTED	Stock	2.454	2.454	2.26	2.36	28368.0
2018-07-10	ABAX-DELISTED	Stock	83.2	83.27	83.2	83.23	218095.0
2018-07-10	ABB-DELISTED	Stock	21.81	21.935	21.78	21.91	1758127.0
2018-07-10	ABBNY-DELISTED	Stock	21.81	21.935	21.78	21.92	2335258.0
2018-07-10	ABBV	Stock	97.11	98.95	96.68	98.84	5119900.0
2018-07-10	ABC-DELISTED	Stock	88.94	89.01	87.88	88.16	625173.0
2018-07-10	ABCB	Stock	53.7	53.95	52.55	53.05	334600.0
2018-07-10	ABCD-DELISTED	Stock	11.87	11.96	11.4	11.43	81518.0
2018-07-10	ABDC-DELISTED	Stock	6.4	6.4	6.28	6.31	32257.0
2018-07-10	ABEO	Stock	397.5	400.0	363.75	365.0	52672.0
2018-07-10	ABEV	Stock	4.71	4.8	4.68	4.8	37593600.0
2018-07-10	ABG	Stock	75.95	75.95	69.5	70.6	239100.0
2018-07-10	ABIL-DELISTED	Stock	6.8	7.0	6.5	6.67	126532.0
2018-07-10	ABM	Stock	30.74	31.03	30.6	30.89	852600.0
2018-07-10	ABMD-DELISTED	Stock	413.09	413.5	399.73	404.98	471566.0
2018-07-10	ABR	Stock	10.85	10.89	10.78	10.8	994700.0
2018-07-10	ABR.B-DELISTED	Stock	25.47	25.5	25.45	25.45	1802.0

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

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