PREVIEW / stock_daily / 2018-11-15

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-15.parquet
  size:    221 KB
  rows:    6,574
  symbols: 2,719

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-15	AAPL	Stock	47.0975	47.9925	46.725	47.8525	185915200.0
2018-11-15	MSFT	Stock	104.99	107.8	103.91	107.28	38505200.0
2018-11-15	NVDA	Stock	4.9238	5.1325	4.8875	5.0598	840708000.0
2018-11-15	AMZN	Stock	79.0505	81.241	77.3255	80.972	168546000.0
2018-11-15	GOOGL	Stock	52.573	53.9435	52.0646	53.5525	41583080.0
2018-11-15	META	Stock	142.33	144.84	140.83	143.85	30320300.0
2018-11-15	TSLA	Stock	22.822	23.2387	22.6027	23.2293	69385500.0
2018-11-15	TLT	Stock	114.44	114.54	113.68	114.04	7879799.0
2018-11-15	ES	Stock	65.26	66.21	64.48	66.2	2197100.0
2018-11-15	CL	Stock	62.18	62.66	61.73	62.4	4688600.0
2018-11-15	A	Stock	63.32	64.95	62.54	64.72	3846100.0
2018-11-15	AA	Stock	35.09	36.16	34.8	35.94	2535100.0
2018-11-15	AABA-DELISTED	Stock	62.97	64.79	62.54	64.4	8650123.0
2018-11-15	AAC-DELISTED	Stock	2.31	2.41	2.31	2.35	338018.0
2018-11-15	AACG	Stock	1.06	1.06	1.02	1.04	47900.0
2018-11-15	AAIC-DELISTED	Stock	8.39	8.445	8.18	8.42	516677.0
2018-11-15	AAL	Stock	37.87	38.16	36.31	37.82	8296700.0
2018-11-15	AAM.A-DELISTED	Stock	24.6421	24.6421	24.1	24.1	54533.0
2018-11-15	AAM.B-DELISTED	Stock	24.48	24.49	24.25	24.32	30497.0
2018-11-15	AAMC-DELISTED	Stock	13.7206	14.1179	13.5147	13.5147	5583.0
2018-11-15	AAME	Stock	2.98	2.98	2.98	2.98	400.0
2018-11-15	AAMI	Stock	12.64	12.83	12.41	12.8	415300.0
2018-11-15	AAOI	Stock	20.11	21.49	20.06	21.34	640500.0
2018-11-15	AAON	Stock	27.5067	27.7333	26.8933	27.3067	615750.0
2018-11-15	AAP	Stock	176.88	180.44	174.8	179.05	1026600.0
2018-11-15	AAT	Stock	39.2	39.2	38.4	38.76	227100.0
2018-11-15	AAU-DELISTED	Stock	0.5	0.5177	0.49	0.5041	193730.0
2018-11-15	AAUAF-DELISTED	Stock	0.5	0.5177	0.49	0.5041	206910.0
2018-11-15	AAWW-DELISTED	Stock	54.09	55.36	53.17	55.23	590067.0
2018-11-15	AAXJ	Stock	65.02	66.43	64.85	66.15	4019479.0
2018-11-15	AAXN-DELISTED	Stock	49.36	50.07	47.8	49.49	673685.0
2018-11-15	AB	Stock	29.94	30.06	29.43	29.75	464800.0
2018-11-15	ABAC-DELISTED	Stock	1.62	1.62	1.57	1.58	19575.0
2018-11-15	ABB-DELISTED	Stock	19.65	20.015	19.55	19.95	3001738.0
2018-11-15	ABBNY-DELISTED	Stock	19.65	20.015	19.55	19.95	3075518.0
2018-11-15	ABBV	Stock	87.63	90.29	85.96	90.14	10365700.0
2018-11-15	ABC-DELISTED	Stock	88.66	89.18	86.08	89.15	964510.0
2018-11-15	ABCB	Stock	43.3	44.58	42.9	44.52	227900.0
2018-11-15	ABCD-DELISTED	Stock	14.41	14.44	14.39	14.435	173560.0
2018-11-15	ABDC-DELISTED	Stock	6.28	6.3999	6.26	6.29	49511.0
2018-11-15	ABEO	Stock	183.0	203.5	183.0	201.25	26852.0
2018-11-15	ABEOW-DELISTED	Stock	3.8152	3.8152	3.8152	3.8152	400.0
2018-11-15	ABEV	Stock	4.22	4.27	4.19	4.23	17454000.0
2018-11-15	ABG	Stock	68.36	69.55	66.68	69.46	232100.0
2018-11-15	ABIL-DELISTED	Stock	3.05	3.05	2.9	2.92	22413.0
2018-11-15	ABM	Stock	29.98	31.18	29.75	30.96	332100.0
2018-11-15	ABMD-DELISTED	Stock	310.58	324.275	301.12	320.89	686347.0
2018-11-15	ABR	Stock	12.12	12.12	11.86	12.0	1945300.0
2018-11-15	ABR.A-DELISTED	Stock	25.31	25.31	25.234	25.2605	1554.0
2018-11-15	ABR.B-DELISTED	Stock	25.01	25.4307	25.01	25.15	3790.0

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

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