PREVIEW / stock_daily / 2018-09-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-09-13.parquet
  size:    218 KB
  rows:    6,522
  symbols: 2,750

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-09-13	AAPL	Stock	55.88	57.0875	55.6425	56.6025	166825600.0
2018-09-13	MSFT	Stock	112.12	113.73	112.12	112.91	26055600.0
2018-09-13	NVDA	Stock	6.7715	6.875	6.754	6.7835	305536000.0
2018-09-13	AMZN	Stock	100.0	100.438	99.1015	99.4935	72430000.0
2018-09-13	GOOGL	Stock	58.985	59.393	58.461	59.107	40068360.0
2018-09-13	META	Stock	162.0	163.32	160.86	161.36	25453800.0
2018-09-13	TSLA	Stock	19.2013	19.6667	19.012	19.2973	95104500.0
2018-09-13	TLT	Stock	119.34	119.57	118.98	119.12	4833033.0
2018-09-13	ES	Stock	63.19	63.62	62.9	63.61	868600.0
2018-09-13	CL	Stock	68.07	68.19	67.5	68.16	3093200.0
2018-09-13	A	Stock	68.1	69.66	67.99	69.33	2495000.0
2018-09-13	AA	Stock	42.51	42.88	41.56	41.77	2609000.0
2018-09-13	AABA-DELISTED	Stock	67.74	68.53	67.44	67.95	6963696.0
2018-09-13	AAC-DELISTED	Stock	7.63	7.66	7.44	7.51	173395.0
2018-09-13	AACG	Stock	1.43	1.43	1.33	1.33	111800.0
2018-09-13	AAIC-DELISTED	Stock	10.1	10.15	10.05	10.06	206448.0
2018-09-13	AAL	Stock	39.49	40.06	39.42	39.48	4268900.0
2018-09-13	AAM.A-DELISTED	Stock	25.3561	25.4151	25.35	25.37	16272.0
2018-09-13	AAM.B-DELISTED	Stock	24.91	24.95	24.79	24.82	69579.0
2018-09-13	AAME	Stock	2.95	3.0	2.6	3.0	2700.0
2018-09-13	AAMI	Stock	12.48	12.55	12.46	12.53	314000.0
2018-09-13	AAOI	Stock	33.63	34.59	33.4	33.79	807500.0
2018-09-13	AAON	Stock	26.8	26.8333	26.5	26.6	155100.0
2018-09-13	AAP	Stock	167.1	167.99	165.28	166.73	835800.0
2018-09-13	AAT	Stock	38.9	39.08	38.68	39.06	137300.0
2018-09-13	AAU-DELISTED	Stock	0.64	0.64	0.6212	0.6287	102941.0
2018-09-13	AAUAF-DELISTED	Stock	0.64	0.64	0.6212	0.6287	103503.0
2018-09-13	AAV-DELISTED	Stock	2.5	2.525	2.3663	2.525	336885.0
2018-09-13	AAWW-DELISTED	Stock	64.7	64.7	62.85	63.6	185704.0
2018-09-13	AAXJ	Stock	69.67	69.91	69.26	69.66	1775012.0
2018-09-13	AAXN-DELISTED	Stock	70.58	72.13	70.48	71.43	302102.0
2018-09-13	AB	Stock	30.5	30.55	30.4	30.45	186400.0
2018-09-13	ABAC-DELISTED	Stock	1.92	2.82	1.92	2.2399	672371.0
2018-09-13	ABB-DELISTED	Stock	24.09	24.093	23.835	24.03	3108735.0
2018-09-13	ABBNY-DELISTED	Stock	24.09	24.093	23.835	24.03	3472034.0
2018-09-13	ABBV	Stock	93.42	96.37	93.41	96.33	4850700.0
2018-09-13	ABC-DELISTED	Stock	85.72	86.27	85.15	85.93	916135.0
2018-09-13	ABCB	Stock	47.55	47.66	46.9	47.4	228700.0
2018-09-13	ABCD-DELISTED	Stock	12.72	12.86	12.49	12.62	36648.0
2018-09-13	ABDC-DELISTED	Stock	6.2	6.42	6.2	6.4053	41316.0
2018-09-13	ABEO	Stock	361.25	367.5	352.5	358.75	14100.0
2018-09-13	ABEV	Stock	4.4	4.45	4.36	4.38	28723800.0
2018-09-13	ABG	Stock	71.9	72.5	71.75	71.8	108700.0
2018-09-13	ABIL-DELISTED	Stock	3.48	3.48	3.25	3.344	44973.0
2018-09-13	ABM	Stock	34.79	34.95	34.37	34.41	379900.0
2018-09-13	ABMD-DELISTED	Stock	396.18	397.475	388.69	390.96	263553.0
2018-09-13	ABR	Stock	12.09	12.15	12.0	12.07	669500.0
2018-09-13	ABR.A-DELISTED	Stock	25.97	25.98	25.946	25.9468	1303.0
2018-09-13	ABR.B-DELISTED	Stock	25.7	25.739	25.69	25.69	1835.0
2018-09-13	ABT	Stock	67.23	68.54	67.15	68.5	6052400.0

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

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