PREVIEW / stock_daily / 2018-12-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-12-14.parquet
  size:    220 KB
  rows:    6,549
  symbols: 2,687

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-12-14	AAPL	Stock	42.25	42.27	41.32	41.37	162814800.0
2018-12-14	MSFT	Stock	108.25	109.26	105.5	106.03	47043100.0
2018-12-14	NVDA	Stock	3.6803	3.7648	3.6375	3.6612	471820000.0
2018-12-14	AMZN	Stock	81.9	82.1285	79.25	79.5955	127344000.0
2018-12-14	GOOGL	Stock	53.001	53.586	52.4685	52.5855	36358980.0
2018-12-14	META	Stock	143.34	146.01	142.51	144.06	21785800.0
2018-12-14	TSLA	Stock	25.0	25.1913	24.2887	24.3807	95064000.0
2018-12-14	TLT	Stock	118.55	118.77	118.22	118.48	8169221.0
2018-12-14	ES	Stock	70.27	70.53	69.48	69.77	1784300.0
2018-12-14	CL	Stock	65.11	65.65	64.88	65.17	4976000.0
2018-12-14	A	Stock	70.42	70.61	69.13	69.36	1982700.0
2018-12-14	AA	Stock	28.51	29.59	28.41	28.61	3358900.0
2018-12-14	AABA-DELISTED	Stock	61.56	62.44	60.82	61.97	7379151.0
2018-12-14	AAC-DELISTED	Stock	2.36	2.4	2.13	2.15	279532.0
2018-12-14	AACG	Stock	1.05	1.08	1.05	1.08	41100.0
2018-12-14	AAIC-DELISTED	Stock	8.34	8.41	8.29	8.36	390819.0
2018-12-14	AAL	Stock	32.27	33.27	32.08	32.41	8558600.0
2018-12-14	AAM.A-DELISTED	Stock	22.3699	22.3699	21.81	21.95	42251.0
2018-12-14	AAM.B-DELISTED	Stock	22.09	22.248	21.7	21.91	59905.0
2018-12-14	AAMC-DELISTED	Stock	14.0589	14.0589	13.9588	13.9588	6640.0
2018-12-14	AAME	Stock	2.4	2.4	2.4	2.4	300.0
2018-12-14	AAMI	Stock	11.25	11.415	10.97	11.01	462500.0
2018-12-14	AAOI	Stock	18.92	19.07	17.55	17.6	934000.0
2018-12-14	AAON	Stock	23.7267	24.1133	23.4667	23.5333	140550.0
2018-12-14	AAP	Stock	165.3	168.38	163.4	163.78	968600.0
2018-12-14	AAT	Stock	41.74	41.93	41.5	41.71	151200.0
2018-12-14	AAU-DELISTED	Stock	0.67	0.67	0.63	0.6393	228870.0
2018-12-14	AAUAF-DELISTED	Stock	0.67	0.67	0.63	0.6393	236805.0
2018-12-14	AAWW-DELISTED	Stock	45.69	46.04	45.0068	45.26	278698.0
2018-12-14	AAXJ	Stock	65.03	65.52	64.97	65.12	1601750.0
2018-12-14	AAXN-DELISTED	Stock	44.6	45.86	44.5	44.64	641202.0
2018-12-14	AB	Stock	27.12	27.6	26.15	26.35	696600.0
2018-12-14	ABAC-DELISTED	Stock	1.17	1.28	1.14	1.14	834.0
2018-12-14	ABB-DELISTED	Stock	19.61	19.755	19.35	19.39	2574481.0
2018-12-14	ABBNY-DELISTED	Stock	19.61	19.755	19.35	19.4	2654756.0
2018-12-14	ABBV	Stock	86.8	87.16	85.08	85.61	5461600.0
2018-12-14	ABC-DELISTED	Stock	80.78	81.33	78.765	78.98	1331535.0
2018-12-14	ABCB	Stock	34.55	35.1	33.93	34.02	316500.0
2018-12-14	ABCD-DELISTED	Stock	14.48	14.5	14.48	14.49	265431.0
2018-12-14	ABDC-DELISTED	Stock	6.66	7.0	6.65	6.67	78546.0
2018-12-14	ABEO	Stock	190.0	192.75	182.5	184.25	20676.0
2018-12-14	ABEOW-DELISTED	Stock	3.4	3.4	3.4	3.4	400.0
2018-12-14	ABEV	Stock	4.11	4.19	4.04	4.04	16123600.0
2018-12-14	ABG	Stock	64.68	66.81	64.68	66.31	277400.0
2018-12-14	ABIL-DELISTED	Stock	2.21	2.3	2.11	2.2699	179229.0
2018-12-14	ABM	Stock	26.04	26.42	25.66	25.9	684500.0
2018-12-14	ABMD-DELISTED	Stock	313.63	323.93	312.03	316.18	248352.0
2018-12-14	ABR	Stock	11.51	11.64	11.44	11.46	841200.0
2018-12-14	ABR.A-DELISTED	Stock	25.45	25.45	25.45	25.45	400.0
2018-12-14	ABR.C-DELISTED	Stock	25.78	25.8	25.6865	25.6865	4186.0

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

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