PREVIEW / stock_daily / 2018-09-11

all stock daily files

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

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-11	AAPL	Stock	54.5025	56.075	54.14	55.9625	142996000.0
2018-09-11	MSFT	Stock	108.9	111.59	108.89	111.24	24301800.0
2018-09-11	NVDA	Stock	6.8215	6.91	6.8005	6.82	243112000.0
2018-09-11	AMZN	Stock	96.4135	99.444	95.85	99.3575	100672000.0
2018-09-11	GOOGL	Stock	58.555	59.547	58.2975	59.4995	29253760.0
2018-09-11	META	Stock	163.94	167.19	163.72	165.94	20457100.0
2018-09-11	TSLA	Stock	18.6313	18.8	18.2367	18.6293	137550000.0
2018-09-11	TLT	Stock	119.08	119.17	118.6	118.66	5440021.0
2018-09-11	ES	Stock	63.46	63.68	63.07	63.27	1048200.0
2018-09-11	CL	Stock	66.8	67.3	66.6	67.18	2985000.0
2018-09-11	A	Stock	67.7	68.06	67.49	67.62	1676700.0
2018-09-11	AA	Stock	41.19	41.385	40.566	40.87	3701700.0
2018-09-11	AABA-DELISTED	Stock	62.88	64.91	62.802	64.4	8677195.0
2018-09-11	AAC-DELISTED	Stock	7.11	7.41	7.07	7.35	149560.0
2018-09-11	AACG	Stock	1.44	1.48	1.29	1.44	134000.0
2018-09-11	AAIC-DELISTED	Stock	10.22	10.25	10.21	10.22	266998.0
2018-09-11	AAL	Stock	39.33	40.31	39.07	40.18	5863600.0
2018-09-11	AAM.A-DELISTED	Stock	25.4028	25.43	25.3117	25.3718	30451.0
2018-09-11	AAM.B-DELISTED	Stock	25.0	25.01	24.91	24.95	107556.0
2018-09-11	AAMC-DELISTED	Stock	18.3824	18.3824	18.1471	18.1471	2213.0
2018-09-11	AAME	Stock	2.95	3.03	2.85	2.85	4100.0
2018-09-11	AAMI	Stock	12.57	12.61	12.39	12.49	495700.0
2018-09-11	AAOI	Stock	32.89	33.2	32.42	33.05	472600.0
2018-09-11	AAON	Stock	26.1333	26.5667	25.6333	26.4	193950.0
2018-09-11	AAP	Stock	166.93	168.42	166.65	167.24	738500.0
2018-09-11	AAT	Stock	38.72	39.1	38.7	38.91	199100.0
2018-09-11	AAU-DELISTED	Stock	0.63	0.6626	0.61	0.6172	253340.0
2018-09-11	AAUAF-DELISTED	Stock	0.63	0.6626	0.61	0.6172	258370.0
2018-09-11	AAV-DELISTED	Stock	2.45	2.55	2.4	2.55	187010.0
2018-09-11	AAWW-DELISTED	Stock	63.45	64.1	62.3	63.95	223841.0
2018-09-11	AAXJ	Stock	67.36	68.24	67.22	68.24	5548830.0
2018-09-11	AAXN-DELISTED	Stock	71.94	73.64	71.6	72.93	408501.0
2018-09-11	AB	Stock	30.35	30.55	30.25	30.35	174900.0
2018-09-11	ABAC-DELISTED	Stock	1.77	1.77	1.5301	1.6192	59781.0
2018-09-11	ABB-DELISTED	Stock	23.17	23.34	23.1125	23.28	791687.0
2018-09-11	ABBNY-DELISTED	Stock	23.17	23.34	23.1125	23.28	1037149.0
2018-09-11	ABBV	Stock	93.72	93.73	92.88	93.18	2638500.0
2018-09-11	ABC-DELISTED	Stock	87.25	87.81	83.96	84.09	2148439.0
2018-09-11	ABCB	Stock	48.4	49.1	48.25	48.6	229000.0
2018-09-11	ABCD-DELISTED	Stock	12.33	12.74	12.32	12.71	83910.0
2018-09-11	ABDC-DELISTED	Stock	6.18	6.2	6.14	6.18	30647.0
2018-09-11	ABEO	Stock	335.0	357.5	335.0	356.25	22176.0
2018-09-11	ABEOW-DELISTED	Stock	9.25	9.25	9.25	9.25	1000.0
2018-09-11	ABEV	Stock	4.35	4.39	4.28	4.38	23809700.0
2018-09-11	ABG	Stock	72.75	73.35	72.2	72.75	151100.0
2018-09-11	ABIL-DELISTED	Stock	3.3	3.6673	3.23	3.5	156445.0
2018-09-11	ABM	Stock	33.8	33.96	33.11	33.94	689300.0
2018-09-11	ABMD-DELISTED	Stock	388.1	397.64	383.28	397.41	327431.0
2018-09-11	ABR	Stock	12.09	12.21	12.08	12.18	676200.0
2018-09-11	ABR.B-DELISTED	Stock	25.41	25.41	25.41	25.41	200.0

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

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