PREVIEW / stock_daily / 2016-01-04

all stock daily files

  file:    by_date/stock_daily/2016/2016-01-04.parquet
  size:    221 KB
  rows:    6,632
  symbols: 3,387

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
2016-01-04	AAPL	Stock	25.6525	26.3425	25.5	26.3375	270597600.0
2016-01-04	MSFT	Stock	54.32	54.8	53.39	54.8	53778000.0
2016-01-04	NVDA	Stock	0.8072	0.8145	0.801	0.8092	358076000.0
2016-01-04	AMZN	Stock	32.8145	32.886	31.3755	31.8495	186290000.0
2016-01-04	GOOGL	Stock	38.11	38.11	37.377	37.972	67381360.0
2016-01-04	META	Stock	101.95	102.24	99.75	102.22	37912400.0
2016-01-04	TSLA	Stock	15.3813	15.4253	14.6	14.894	102406500.0
2016-01-04	TLT	Stock	121.93	122.45	121.32	121.45	10591941.0
2016-01-04	ES	Stock	50.65	50.89	50.23	50.88	1590300.0
2016-01-04	CL	Stock	65.4	65.41	63.98	64.71	5722600.0
2016-01-04	A	Stock	41.06	41.19	40.34	40.69	3287300.0
2016-01-04	AA.B-DELISTED	Stock	32.94	33.07	32.21	33.07	40097.0
2016-01-04	AAAP-DELISTED	Stock	30.75	31.2	29.355	30.67	59453.0
2016-01-04	AABA-DELISTED	Stock	32.12	32.35	31.14	31.395	21603883.0
2016-01-04	AAC-DELISTED	Stock	18.88	18.95	18.07	18.5	106873.0
2016-01-04	AACG	Stock	6.43	6.45	6.35	6.37	39400.0
2016-01-04	AAIC-DELISTED	Stock	12.98	13.28	12.8842	13.24	323413.0
2016-01-04	AAL	Stock	41.29	41.35	40.3	40.91	12037200.0
2016-01-04	AAMC-DELISTED	Stock	4.8353	5.8941	4.8265	5.8853	174675.0
2016-01-04	AAME	Stock	4.99	4.99	4.77	4.84	8300.0
2016-01-04	AAMI	Stock	15.03	15.03	14.61	14.77	120100.0
2016-01-04	AAOI	Stock	16.96	17.1	16.28	16.29	385500.0
2016-01-04	AAON	Stock	15.2133	15.3067	14.74	14.7667	264750.0
2016-01-04	AAP	Stock	149.25	154.48	147.51	152.24	1935300.0
2016-01-04	AAT	Stock	38.31	38.74	37.37	37.6	216700.0
2016-01-04	AAU-DELISTED	Stock	0.71	0.71	0.6417	0.6603	94563.0
2016-01-04	AAUAF-DELISTED	Stock	0.71	0.71	0.6417	0.6603	94953.0
2016-01-04	AAV-DELISTED	Stock	5.0	5.1	4.92	4.94	53357.0
2016-01-04	AAVL-DELISTED	Stock	9.33	9.365	8.53	8.68	248822.0
2016-01-04	AAWW-DELISTED	Stock	40.5	40.7	39.53	40.19	268615.0
2016-01-04	AAXJ	Stock	51.96	51.99	51.5	51.85	1926569.0
2016-01-04	AAXN-DELISTED	Stock	17.0	17.09	16.5	16.82	1307616.0
2016-01-04	AB	Stock	23.76	23.98	23.27	23.64	326400.0
2016-01-04	ABAC-DELISTED	Stock	0.92	0.92	0.86	0.8785	4000.0
2016-01-04	ABAX-DELISTED	Stock	54.66	55.1	53.05	54.38	174536.0
2016-01-04	ABB-DELISTED	Stock	17.43	17.53	17.21	17.53	2255518.0
2016-01-04	ABBNY-DELISTED	Stock	17.43	17.53	17.21	17.52	2313230.0
2016-01-04	ABBV	Stock	58.06	58.32	56.4	57.61	10308400.0
2016-01-04	ABC-DELISTED	Stock	102.31	102.64	101.29	101.89	2104460.0
2016-01-04	ABCB	Stock	33.43	33.81	32.53	32.55	244100.0
2016-01-04	ABCD-DELISTED	Stock	4.88	4.9499	4.76	4.83	62073.0
2016-01-04	ABCO-DELISTED	Stock	48.94	49.165	46.89	47.28	213261.0
2016-01-04	ABCW-DELISTED	Stock	43.43	43.43	42.35	43.0	28631.0
2016-01-04	ABDC-DELISTED	Stock	11.68	11.68	11.15	11.35	57271.0
2016-01-04	ABE-DELISTED	Stock	10.69	10.69	10.68	10.68	1100.0
2016-01-04	ABEO	Stock	82.25	87.0	81.25	85.5	4076.0
2016-01-04	ABEV	Stock	4.29	4.33	4.22	4.27	20496900.0
2016-01-04	ABG	Stock	66.17	67.34	65.74	66.52	218800.0
2016-01-04	ABGB-DELISTED	Stock	1.23	1.28	1.1	1.28	91303.0
2016-01-04	ABIL-DELISTED	Stock	9.7985	10.44	9.78	10.16	90386.0

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

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