PREVIEW / stock_daily / 2016-02-05

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-05.parquet
  size:    217 KB
  rows:    6,564
  symbols: 3,335

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-02-05	AAPL	Stock	24.13	24.23	23.4225	23.505	185672400.0
2016-02-05	MSFT	Stock	51.94	52.0	49.56	50.16	62009000.0
2016-02-05	NVDA	Stock	0.7005	0.7083	0.6588	0.6608	600428000.0
2016-02-05	AMZN	Stock	26.464	26.4725	24.9595	25.1065	194178000.0
2016-02-05	GOOGL	Stock	36.275	36.336	35.007	35.188	109556420.0
2016-02-05	META	Stock	109.51	109.58	103.18	104.07	76894700.0
2016-02-05	TSLA	Stock	11.42	11.5333	10.516	10.84	141564000.0
2016-02-05	TLT	Stock	127.89	129.0	127.59	128.72	9200847.0
2016-02-05	ES	Stock	54.41	54.86	53.39	54.66	3111400.0
2016-02-05	CL	Stock	65.99	66.32	65.41	66.19	3899900.0
2016-02-05	A	Stock	37.26	37.31	35.83	36.04	4424600.0
2016-02-05	AA.B-DELISTED	Stock	28.85	29.5099	28.0	28.33	25680.0
2016-02-05	AAAP-DELISTED	Stock	26.53	28.0	25.0	25.25	11582.0
2016-02-05	AABA-DELISTED	Stock	29.06	29.14	27.725	27.97	15438419.0
2016-02-05	AAC-DELISTED	Stock	19.47	19.97	19.0456	19.37	129881.0
2016-02-05	AACG	Stock	5.55	5.59	5.22	5.55	25300.0
2016-02-05	AAIC-DELISTED	Stock	12.11	12.28	11.82	11.83	272452.0
2016-02-05	AAL	Stock	37.71	38.49	36.53	36.75	10072700.0
2016-02-05	AAMC-DELISTED	Stock	5.1353	5.2676	4.6912	4.7147	60115.0
2016-02-05	AAME	Stock	4.5	4.5	4.5	4.5	1000.0
2016-02-05	AAMI	Stock	11.13	11.26	10.83	11.11	294300.0
2016-02-05	AAOI	Stock	16.07	16.14	15.43	15.45	184600.0
2016-02-05	AAON	Stock	13.9	13.9933	13.44	13.4733	202950.0
2016-02-05	AAP	Stock	147.54	147.96	143.44	143.94	1284200.0
2016-02-05	AAT	Stock	37.0	37.03	36.54	36.73	235900.0
2016-02-05	AAU-DELISTED	Stock	0.65	0.65	0.62	0.6497	53093.0
2016-02-05	AAUAF-DELISTED	Stock	0.65	0.65	0.62	0.6497	53423.0
2016-02-05	AAV-DELISTED	Stock	5.57	5.68	5.47	5.54	116782.0
2016-02-05	AAVL-DELISTED	Stock	4.67	4.85	4.42	4.44	543552.0
2016-02-05	AAWW-DELISTED	Stock	35.3	36.64	35.3	35.62	285362.0
2016-02-05	AAXJ	Stock	49.09	49.23	48.46	48.65	922888.0
2016-02-05	AAXN-DELISTED	Stock	15.64	15.95	15.18	15.53	1114357.0
2016-02-05	AB	Stock	18.04	18.4	17.92	18.05	192500.0
2016-02-05	ABAC-DELISTED	Stock	0.597	0.7182	0.597	0.64	8699.0
2016-02-05	ABAX-DELISTED	Stock	41.06	42.0958	40.9643	41.58	310937.0
2016-02-05	ABB-DELISTED	Stock	17.7	17.82	17.56	17.59	3452077.0
2016-02-05	ABBNY-DELISTED	Stock	17.7	17.82	17.56	17.6	5023078.0
2016-02-05	ABBV	Stock	56.25	56.34	52.62	53.12	13263200.0
2016-02-05	ABC-DELISTED	Stock	84.0	86.13	82.66	84.7	4465298.0
2016-02-05	ABCB	Stock	27.48	27.58	26.58	26.58	191600.0
2016-02-05	ABCD-DELISTED	Stock	4.33	4.49	4.15	4.16	34944.0
2016-02-05	ABCO-DELISTED	Stock	43.16	43.65	42.84	42.93	263403.0
2016-02-05	ABCW-DELISTED	Stock	41.44	41.65	40.91	40.92	110201.0
2016-02-05	ABDC-DELISTED	Stock	10.2	10.34	9.71	9.91	37855.0
2016-02-05	ABE-DELISTED	Stock	10.4144	10.452	10.38	10.41	5209.0
2016-02-05	ABEO	Stock	61.25	66.0	58.75	60.0	1352.0
2016-02-05	ABEV	Stock	4.73	4.74	4.58	4.6	15349500.0
2016-02-05	ABG	Stock	47.82	47.97	45.8	46.7	1073700.0
2016-02-05	ABGB-DELISTED	Stock	1.0	1.0	0.96	0.988	3860.0
2016-02-05	ABIL-DELISTED	Stock	7.2611	7.4	7.13	7.22	17000.0

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

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