PREVIEW / stock_daily / 2018-06-14

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-14.parquet
  size:    218 KB
  rows:    6,501
  symbols: 2,795

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-14	AAPL	Stock	47.8875	47.8925	47.555	47.7	86440400.0
2018-06-14	MSFT	Stock	101.65	102.03	101.0	101.42	25691800.0
2018-06-14	NVDA	Stock	6.6055	6.73	6.5905	6.6728	430016000.0
2018-06-14	AMZN	Stock	85.674	86.24	85.4435	86.193	63488000.0
2018-06-14	GOOGL	Stock	57.6105	58.2995	57.53	58.0055	35422400.0
2018-06-14	META	Stock	193.1	197.28	192.91	196.81	19120900.0
2018-06-14	TSLA	Stock	23.1753	23.9167	23.1067	23.848	164715000.0
2018-06-14	TLT	Stock	119.78	120.3	119.48	120.27	10078771.0
2018-06-14	ES	Stock	53.53	54.08	53.4	53.99	2334100.0
2018-06-14	CL	Stock	63.02	63.59	62.67	63.31	4312500.0
2018-06-14	A	Stock	66.45	66.45	65.71	66.31	3487900.0
2018-06-14	AA	Stock	48.44	48.645	47.64	47.84	2166900.0
2018-06-14	AABA-DELISTED	Stock	81.07	82.45	81.05	82.41	5509207.0
2018-06-14	AAC-DELISTED	Stock	10.16	10.19	9.56	9.87	271393.0
2018-06-14	AACG	Stock	5.11	5.11	5.11	5.11	200.0
2018-06-14	AAIC-DELISTED	Stock	11.3	11.45	11.27	11.32	699536.0
2018-06-14	AAL	Stock	43.06	43.49	42.8	43.08	4019300.0
2018-06-14	AAM.A-DELISTED	Stock	25.4425	25.583	25.44	25.49	51473.0
2018-06-14	AAM.B-DELISTED	Stock	24.77	24.89	24.76	24.77	76660.0
2018-06-14	AAMC-DELISTED	Stock	20.6176	20.6176	19.2941	19.2941	1690.0
2018-06-14	AAME	Stock	2.95	2.95	2.65	2.7	4000.0
2018-06-14	AAMI	Stock	16.03	16.21	15.94	16.19	356800.0
2018-06-14	AAOI	Stock	43.59	44.57	43.3	43.74	791200.0
2018-06-14	AAON	Stock	22.0667	22.3667	21.6533	22.1	370350.0
2018-06-14	AAP	Stock	133.27	133.99	132.57	133.5	816200.0
2018-06-14	AAT	Stock	37.18	37.43	37.02	37.32	177500.0
2018-06-14	AAU-DELISTED	Stock	0.75	0.7595	0.7434	0.7461	52855.0
2018-06-14	AAUAF-DELISTED	Stock	0.75	0.7595	0.7434	0.7461	59383.0
2018-06-14	AAV-DELISTED	Stock	3.1	3.2	3.05	3.1	95782.0
2018-06-14	AAWW-DELISTED	Stock	73.3	73.905	72.5	72.85	102188.0
2018-06-14	AAXJ	Stock	76.62	76.72	76.17	76.3	425455.0
2018-06-14	AAXN-DELISTED	Stock	65.21	65.506	62.89	63.67	927548.0
2018-06-14	AB	Stock	29.45	29.6	29.05	29.15	248100.0
2018-06-14	ABAC-DELISTED	Stock	2.31	2.3101	2.2115	2.2115	8480.0
2018-06-14	ABAX-DELISTED	Stock	83.08	83.37	83.04	83.37	164204.0
2018-06-14	ABB-DELISTED	Stock	23.52	23.585	23.421	23.47	2021275.0
2018-06-14	ABBNY-DELISTED	Stock	23.52	23.585	23.421	23.47	2766379.0
2018-06-14	ABBV	Stock	98.38	98.92	97.75	98.75	4648700.0
2018-06-14	ABC-DELISTED	Stock	90.85	93.82	90.41	93.35	1658116.0
2018-06-14	ABCB	Stock	56.7	56.7	55.75	56.5	191800.0
2018-06-14	ABCD-DELISTED	Stock	10.62	10.739	10.6	10.72	103879.0
2018-06-14	ABDC-DELISTED	Stock	6.77	6.95	6.69	6.84	50637.0
2018-06-14	ABEO	Stock	402.5	408.75	388.75	397.5	34016.0
2018-06-14	ABEV	Stock	5.05	5.17	4.99	5.01	50484300.0
2018-06-14	ABG	Stock	72.95	73.8	72.25	73.15	135000.0
2018-06-14	ABIL-DELISTED	Stock	2.33	2.3795	2.33	2.33	1592.0
2018-06-14	ABM	Stock	31.07	31.15	30.61	31.09	980700.0
2018-06-14	ABMD-DELISTED	Stock	435.19	444.8	434.59	440.57	530737.0
2018-06-14	ABR	Stock	9.95	10.1	9.91	10.0	1554900.0
2018-06-14	ABR.A-DELISTED	Stock	25.8	25.81	25.65	25.79	9601.0

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

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