PREVIEW / stock_daily / 2015-06-09

all stock daily files

  file:    by_date/stock_daily/2015/2015-06-09.parquet
  size:    223 KB
  rows:    6,651
  symbols: 3,492

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-06-09	AAPL	Stock	31.675	32.02	31.405	31.855	224301600.0
2015-06-09	MSFT	Stock	45.76	45.94	45.46	45.65	24406100.0
2015-06-09	NVDA	Stock	0.5442	0.5505	0.5432	0.5465	256888000.0
2015-06-09	AMZN	Stock	21.148	21.3745	20.957	21.274	45774000.0
2015-06-09	GOOGL	Stock	27.171	27.242	26.9425	27.108	30016920.0
2015-06-09	META	Stock	80.6	81.19	79.32	80.67	16497500.0
2015-06-09	TSLA	Stock	17.0267	17.1827	16.9427	17.0667	39166500.0
2015-06-09	TLT	Stock	117.06	117.13	116.11	116.54	12393893.0
2015-06-09	ES	Stock	46.28	46.6	46.05	46.33	873800.0
2015-06-09	CL	Stock	65.43	66.52	65.16	66.03	5780600.0
2015-06-09	A	Stock	39.93	40.33	39.83	40.12	1439000.0
2015-06-09	AA.B-DELISTED	Stock	44.5	44.5	43.71	43.71	25431.0
2015-06-09	AABA-DELISTED	Stock	41.92	41.95	41.02	41.62	10625787.0
2015-06-09	AAC-DELISTED	Stock	42.24	42.24	37.54	39.18	241584.0
2015-06-09	AACG	Stock	4.9	5.04	4.9	4.93	5100.0
2015-06-09	AAIC-DELISTED	Stock	20.65	20.788	20.44	20.5	343613.0
2015-06-09	AAL	Stock	38.8	40.72	38.45	40.33	27024800.0
2015-06-09	AAMC-DELISTED	Stock	47.6794	48.6382	46.9588	47.3529	40331.0
2015-06-09	AAME	Stock	3.88	3.88	3.74	3.77	3000.0
2015-06-09	AAMI	Stock	18.81	18.81	17.87	18.25	211900.0
2015-06-09	AAOI	Stock	17.77	17.89	17.1	17.54	165800.0
2015-06-09	AAON	Stock	15.9133	15.9867	15.6733	15.8	121650.0
2015-06-09	AAP	Stock	156.4	158.54	156.25	157.42	1012200.0
2015-06-09	AAT	Stock	39.47	39.52	38.94	39.2	182000.0
2015-06-09	AAU-DELISTED	Stock	0.8794	0.9298	0.8794	0.9	74399.0
2015-06-09	AAUAF-DELISTED	Stock	0.851	0.8997	0.851	0.8975	77395.0
2015-06-09	AAV-DELISTED	Stock	6.18	6.25	6.13	6.19	98262.0
2015-06-09	AAVL-DELISTED	Stock	37.63	37.8919	34.96	37.05	324725.0
2015-06-09	AAWW-DELISTED	Stock	53.21	54.1	52.15	53.37	538358.0
2015-06-09	AAXJ	Stock	64.17	64.24	63.94	64.03	743311.0
2015-06-09	AAXN-DELISTED	Stock	32.93	33.9	32.93	33.59	2858487.0
2015-06-09	AB	Stock	30.46	30.65	29.6	29.66	359900.0
2015-06-09	ABAC-DELISTED	Stock	1.45	1.5699	1.45	1.49	8153.0
2015-06-09	ABAX-DELISTED	Stock	52.41	52.41	51.46	51.58	83537.0
2015-06-09	ABB-DELISTED	Stock	22.71	22.76	22.61	22.62	1142831.0
2015-06-09	ABBNY-DELISTED	Stock	22.71	22.76	22.61	22.61	1183624.0
2015-06-09	ABBV	Stock	67.52	68.08	67.51	67.67	8132800.0
2015-06-09	ABC-DELISTED	Stock	110.74	110.74	108.61	109.1	1677648.0
2015-06-09	ABCB	Stock	25.95	26.07	25.82	25.98	82100.0
2015-06-09	ABCD-DELISTED	Stock	4.27	4.28	4.25	4.26	40892.0
2015-06-09	ABCO-DELISTED	Stock	52.6	52.6	51.75	52.22	196144.0
2015-06-09	ABCW-DELISTED	Stock	37.0	37.09	36.95	37.0	46642.0
2015-06-09	ABDC-DELISTED	Stock	13.7	13.75	13.21	13.69	59992.0
2015-06-09	ABE-DELISTED	Stock	12.79	12.8	12.7	12.76	26337.0
2015-06-09	ABEO	Stock	186.5	188.5	178.0	181.75	39040.0
2015-06-09	ABEOW-DELISTED	Stock	3.0	3.41	2.9	3.2	6908.0
2015-06-09	ABEV	Stock	5.95	5.98	5.92	5.95	16111100.0
2015-06-09	ABG	Stock	89.11	89.94	88.1	88.59	152400.0
2015-06-09	ABGB-DELISTED	Stock	16.75	17.05	16.75	16.86	18917.0
2015-06-09	ABIL-DELISTED	Stock	9.9	10.2	9.9	10.08	68318.0

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

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