PREVIEW / stock_daily / 2018-06-26

all stock daily files

  file:    by_date/stock_daily/2018/2018-06-26.parquet
  size:    219 KB
  rows:    6,487
  symbols: 2,787

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-26	AAPL	Stock	45.7475	46.6325	45.635	46.1075	98276800.0
2018-06-26	MSFT	Stock	98.82	100.08	98.75	99.08	26897200.0
2018-06-26	NVDA	Stock	6.0925	6.1412	5.9978	6.0498	478884000.0
2018-06-26	AMZN	Stock	83.6185	85.0785	83.167	84.5545	87732000.0
2018-06-26	GOOGL	Stock	57.207	57.3435	56.45	56.631	34688280.0
2018-06-26	META	Stock	197.6	199.1	196.23	199.0	17897600.0
2018-06-26	TSLA	Stock	22.4033	22.9033	21.72	22.8	111787500.0
2018-06-26	TLT	Stock	120.77	121.0299	120.66	120.97	5450031.0
2018-06-26	ES	Stock	57.25	57.98	57.1	57.55	2506300.0
2018-06-26	CL	Stock	65.11	65.5	64.48	65.14	3900900.0
2018-06-26	A	Stock	61.23	62.32	61.02	61.98	3655600.0
2018-06-26	AA	Stock	44.51	45.96	44.08	45.8	3918200.0
2018-06-26	AABA-DELISTED	Stock	75.91	76.26	74.45	75.55	8450116.0
2018-06-26	AAC-DELISTED	Stock	9.9	10.07	9.79	9.87	114600.0
2018-06-26	AACG	Stock	4.92	4.92	4.92	4.92	700.0
2018-06-26	AAIC-DELISTED	Stock	11.0	11.0	10.801	10.95	639885.0
2018-06-26	AAL	Stock	39.87	39.96	38.99	39.09	6037400.0
2018-06-26	AAM.A-DELISTED	Stock	25.2	25.29	25.18	25.25	4787.0
2018-06-26	AAM.B-DELISTED	Stock	24.68	24.685	24.58	24.64	44918.0
2018-06-26	AAMC-DELISTED	Stock	20.4412	20.4412	20.4338	20.4338	1289.0
2018-06-26	AAME	Stock	2.63	2.65	2.6	2.6	10500.0
2018-06-26	AAMI	Stock	14.8	14.83	14.57	14.62	399700.0
2018-06-26	AAOI	Stock	40.6	42.75	40.41	42.75	597600.0
2018-06-26	AAON	Stock	21.9667	22.2333	21.6333	22.1	223350.0
2018-06-26	AAP	Stock	137.52	139.17	136.46	137.07	745600.0
2018-06-26	AAT	Stock	38.79	38.84	38.37	38.41	213400.0
2018-06-26	AAU-DELISTED	Stock	0.72	0.7425	0.705	0.7375	140499.0
2018-06-26	AAUAF-DELISTED	Stock	0.72	0.7425	0.705	0.7375	162851.0
2018-06-26	AAV-DELISTED	Stock	3.1	3.15	3.05	3.15	111473.0
2018-06-26	AAWW-DELISTED	Stock	71.35	71.35	68.65	69.85	190865.0
2018-06-26	AAXJ	Stock	72.02	72.23	71.63	71.86	845017.0
2018-06-26	AAXN-DELISTED	Stock	62.28	63.989	62.0238	63.17	587499.0
2018-06-26	AB	Stock	29.0	29.0	28.3	28.6	330800.0
2018-06-26	ABAC-DELISTED	Stock	2.11	2.69	2.11	2.4	122017.0
2018-06-26	ABAX-DELISTED	Stock	83.15	83.24	83.04	83.16	111344.0
2018-06-26	ABB-DELISTED	Stock	21.64	21.83	21.5668	21.73	1646416.0
2018-06-26	ABBNY-DELISTED	Stock	21.64	21.83	21.5668	21.74	1717422.0
2018-06-26	ABBV	Stock	93.36	93.86	92.08	92.12	5117100.0
2018-06-26	ABC-DELISTED	Stock	91.91	92.33	90.23	90.41	776471.0
2018-06-26	ABCB	Stock	55.75	55.75	54.6	55.35	257200.0
2018-06-26	ABCD-DELISTED	Stock	10.93	11.0723	10.79	10.85	114456.0
2018-06-26	ABDC-DELISTED	Stock	6.68	6.73	6.52	6.57	55652.0
2018-06-26	ABEO	Stock	393.75	406.25	391.25	402.5	21464.0
2018-06-26	ABEV	Stock	4.84	4.85	4.72	4.75	31433800.0
2018-06-26	ABG	Stock	72.75	72.9	71.85	72.5	124700.0
2018-06-26	ABIL-DELISTED	Stock	8.86	14.55	8.01	11.95	6797802.0
2018-06-26	ABM	Stock	30.12	30.33	29.63	30.23	549300.0
2018-06-26	ABMD-DELISTED	Stock	419.23	430.77	413.02	428.31	606409.0
2018-06-26	ABR	Stock	10.1	10.17	10.05	10.14	699300.0
2018-06-26	ABR.A-DELISTED	Stock	25.94	25.96	25.94	25.96	500.0

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

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