PREVIEW / stock_daily / 2018-06-13

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-13.parquet
  size:    220 KB
  rows:    6,536
  symbols: 2,805

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-06-13	AAPL	Stock	48.105	48.22	47.61	47.675	86553600.0
2018-06-13	MSFT	Stock	101.72	102.01	100.56	100.85	29492900.0
2018-06-13	NVDA	Stock	6.566	6.6418	6.5508	6.56	338208000.0
2018-06-13	AMZN	Stock	85.1405	85.6875	85.006	85.243	66550000.0
2018-06-13	GOOGL	Stock	57.614	57.782	57.169	57.2115	34301480.0
2018-06-13	META	Stock	192.74	194.5	191.91	192.41	15853800.0
2018-06-13	TSLA	Stock	23.114	23.1467	22.6533	22.9853	142047000.0
2018-06-13	TLT	Stock	119.45	119.64	118.63	119.28	8834656.0
2018-06-13	ES	Stock	53.83	54.06	53.29	53.43	2293200.0
2018-06-13	CL	Stock	63.78	63.93	62.97	63.06	4252400.0
2018-06-13	A	Stock	66.6	66.68	65.97	66.26	4357700.0
2018-06-13	AA	Stock	49.34	49.49	48.28	48.35	2589400.0
2018-06-13	AABA-DELISTED	Stock	81.77	81.99	80.63	80.81	8038819.0
2018-06-13	AAC-DELISTED	Stock	10.32	10.39	10.07	10.11	59017.0
2018-06-13	AAIC-DELISTED	Stock	11.2	11.3	11.14	11.28	717014.0
2018-06-13	AAL	Stock	43.39	43.69	42.83	42.92	5989000.0
2018-06-13	AAM.A-DELISTED	Stock	25.42	25.55	25.42	25.5	26477.0
2018-06-13	AAM.B-DELISTED	Stock	24.73	24.78	24.71	24.71	46664.0
2018-06-13	AAMC-DELISTED	Stock	20.6176	20.6176	20.6176	20.6176	1758.0
2018-06-13	AAME	Stock	2.61	2.88	2.6	2.75	15100.0
2018-06-13	AAMI	Stock	16.06	16.15	15.93	16.04	534200.0
2018-06-13	AAOI	Stock	43.18	44.65	42.5	43.58	902600.0
2018-06-13	AAON	Stock	22.4	22.4	21.7667	21.8333	262950.0
2018-06-13	AAP	Stock	133.37	133.58	131.49	132.68	771100.0
2018-06-13	AAT	Stock	37.42	37.6	36.81	36.93	246100.0
2018-06-13	AAU-DELISTED	Stock	0.75	0.7641	0.75	0.7558	33738.0
2018-06-13	AAUAF-DELISTED	Stock	0.75	0.7641	0.75	0.7558	35447.0
2018-06-13	AAV-DELISTED	Stock	3.05	3.15	3.05	3.15	119078.0
2018-06-13	AAWW-DELISTED	Stock	73.85	73.85	72.5	72.85	115460.0
2018-06-13	AAXJ	Stock	77.46	77.46	76.47	76.8	502422.0
2018-06-13	AAXN-DELISTED	Stock	65.53	65.59	64.35	64.87	685806.0
2018-06-13	AB	Stock	29.3	29.8	28.65	29.3	674000.0
2018-06-13	ABAC-DELISTED	Stock	2.35	2.38	2.2601	2.35	10837.0
2018-06-13	ABAX-DELISTED	Stock	83.02	83.18	82.98	82.98	156023.0
2018-06-13	ABB-DELISTED	Stock	23.36	23.39	23.18	23.24	1296019.0
2018-06-13	ABBNY-DELISTED	Stock	23.36	23.39	23.18	23.24	1352727.0
2018-06-13	ABBV	Stock	98.92	99.23	97.51	97.58	7816200.0
2018-06-13	ABC-DELISTED	Stock	88.61	91.89	88.545	90.66	2033880.0
2018-06-13	ABCB	Stock	56.6	57.45	55.0	56.7	247400.0
2018-06-13	ABCD-DELISTED	Stock	10.66	10.73	10.61	10.62	122905.0
2018-06-13	ABDC-DELISTED	Stock	6.72	6.82	6.72	6.76	13523.0
2018-06-13	ABEO	Stock	412.5	415.0	397.5	402.5	25512.0
2018-06-13	ABEV	Stock	5.08	5.12	4.96	5.0	31093300.0
2018-06-13	ABG	Stock	74.55	74.72	72.7	72.75	108500.0
2018-06-13	ABIL-DELISTED	Stock	2.41	2.41	2.3881	2.4	1216.0
2018-06-13	ABM	Stock	31.06	31.44	30.94	31.11	2089200.0
2018-06-13	ABMD-DELISTED	Stock	431.05	438.24	427.01	433.07	637187.0
2018-06-13	ABR	Stock	9.94	10.05	9.9	9.94	2087300.0
2018-06-13	ABR.A-DELISTED	Stock	25.78	25.8	25.78	25.8	3136.0
2018-06-13	ABR.B-DELISTED	Stock	25.3056	25.3056	25.27	25.27	679.0

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

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