PREVIEW / stock_daily / 2015-11-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-11-09.parquet
  size:    222 KB
  rows:    6,620
  symbols: 3,409

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
2015-11-09	AAPL	Stock	30.24	30.4525	30.0125	30.1425	135485600.0
2015-11-09	MSFT	Stock	54.55	54.87	53.56	54.16	32513100.0
2015-11-09	NVDA	Stock	0.781	0.7875	0.7742	0.7852	492568000.0
2015-11-09	AMZN	Stock	32.9325	33.098	32.3925	32.7745	80976000.0
2015-11-09	GOOGL	Stock	37.926	38.165	37.4555	37.7385	35537220.0
2015-11-09	META	Stock	107.0	108.25	105.86	106.49	26383500.0
2015-11-09	TSLA	Stock	15.5327	15.5327	14.954	15.022	57763500.0
2015-11-09	TLT	Stock	118.1	118.9	118.0	118.33	9159480.0
2015-11-09	ES	Stock	48.82	49.43	48.66	49.35	1304700.0
2015-11-09	CL	Stock	65.48	65.97	65.28	65.77	3623800.0
2015-11-09	A	Stock	38.04	38.08	37.48	37.92	3109600.0
2015-11-09	AA.B-DELISTED	Stock	32.11	32.11	30.72	30.73	108643.0
2015-11-09	AABA-DELISTED	Stock	34.05	34.08	33.075	33.685	13065626.0
2015-11-09	AAC-DELISTED	Stock	24.5	24.84	23.44	23.54	126795.0
2015-11-09	AACG	Stock	4.25	4.35	4.05	4.2	12400.0
2015-11-09	AAIC-DELISTED	Stock	14.0	14.1	13.67	13.68	202913.0
2015-11-09	AAL	Stock	45.17	45.21	44.56	44.65	7214600.0
2015-11-09	AAMC-DELISTED	Stock	7.8735	8.0794	6.7853	7.0147	170853.0
2015-11-09	AAME	Stock	4.73	5.0	4.73	5.0	8100.0
2015-11-09	AAMI	Stock	16.74	16.91	16.46	16.5	131100.0
2015-11-09	AAOI	Stock	17.43	17.58	16.6	16.76	549800.0
2015-11-09	AAON	Stock	16.14	16.3733	15.9733	16.2333	265350.0
2015-11-09	AAP	Stock	198.71	198.88	193.76	194.9	865200.0
2015-11-09	AAT	Stock	39.61	39.83	38.94	39.17	173200.0
2015-11-09	AAU-DELISTED	Stock	0.5596	0.5596	0.5319	0.5423	60599.0
2015-11-09	AAUAF-DELISTED	Stock	0.5596	0.5596	0.5319	0.5423	63581.0
2015-11-09	AAV-DELISTED	Stock	5.86	5.9	5.75	5.8	79294.0
2015-11-09	AAVL-DELISTED	Stock	9.32	9.5	9.22	9.365	283288.0
2015-11-09	AAWW-DELISTED	Stock	41.23	41.23	39.32	39.71	231642.0
2015-11-09	AAXJ	Stock	56.55	56.55	55.76	55.91	1257202.0
2015-11-09	AAXN-DELISTED	Stock	20.18	20.198	18.96	19.24	1943596.0
2015-11-09	AB	Stock	25.16	25.3	24.78	25.14	182200.0
2015-11-09	ABAC-DELISTED	Stock	0.6645	0.67	0.65	0.67	11706.0
2015-11-09	ABAX-DELISTED	Stock	52.8	52.8	51.49	52.26	61277.0
2015-11-09	ABB-DELISTED	Stock	19.17	19.21	18.86	18.91	2457587.0
2015-11-09	ABBNY-DELISTED	Stock	19.17	19.21	18.86	18.92	2534476.0
2015-11-09	ABBV	Stock	63.62	64.13	63.11	63.23	8239400.0
2015-11-09	ABC-DELISTED	Stock	97.33	97.905	96.38	97.4	1462878.0
2015-11-09	ABCB	Stock	33.42	33.58	33.13	33.46	206200.0
2015-11-09	ABCD-DELISTED	Stock	5.44	5.44	5.01	5.06	39786.0
2015-11-09	ABCO-DELISTED	Stock	53.09	53.74	50.71	52.47	262178.0
2015-11-09	ABCW-DELISTED	Stock	42.09	42.51	41.37	42.0	10354.0
2015-11-09	ABDC-DELISTED	Stock	12.0	12.6	11.94	12.21	33785.0
2015-11-09	ABE-DELISTED	Stock	11.35	11.64	11.3111	11.35	37846.0
2015-11-09	ABEO	Stock	111.5	116.25	109.5	111.5	4212.0
2015-11-09	ABEOW-DELISTED	Stock	1.55	1.55	1.55	1.55	6000.0
2015-11-09	ABEV	Stock	4.97	4.98	4.83	4.83	9542400.0
2015-11-09	ABG	Stock	77.92	77.92	74.81	76.08	438300.0
2015-11-09	ABGB-DELISTED	Stock	5.83	5.94	5.73	5.8	23523.0
2015-11-09	ABIL-DELISTED	Stock	10.06	10.0601	10.06	10.06	1101.0

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

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