PREVIEW / stock_daily / 2015-10-27

all stock daily files

  file:    by_date/stock_daily/2015/2015-10-27.parquet
  size:    222 KB
  rows:    6,624
  symbols: 3,419

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-10-27	AAPL	Stock	28.85	29.135	28.4975	28.6375	279537600.0
2015-10-27	MSFT	Stock	53.99	54.37	53.58	53.69	50999900.0
2015-10-27	NVDA	Stock	0.708	0.7155	0.7075	0.711	208268000.0
2015-10-27	AMZN	Stock	30.43	30.7355	30.2765	30.5505	75742000.0
2015-10-27	GOOGL	Stock	36.3285	36.7982	36.2068	36.641	38778320.0
2015-10-27	META	Stock	102.94	104.1	102.4	103.7	23795500.0
2015-10-27	TSLA	Stock	14.3227	14.4733	13.834	14.0233	52791000.0
2015-10-27	TLT	Stock	124.51	124.9001	124.16	124.33	7156769.0
2015-10-27	ES	Stock	52.04	52.25	51.64	51.93	783700.0
2015-10-27	CL	Stock	68.39	69.0	68.31	68.95	3307500.0
2015-10-27	A	Stock	36.67	37.06	36.47	37.05	2557200.0
2015-10-27	AA.B-DELISTED	Stock	32.06	32.4899	31.42	31.7	42644.0
2015-10-27	AABA-DELISTED	Stock	34.96	35.47	33.88	34.3	25655646.0
2015-10-27	AAC-DELISTED	Stock	26.02	27.24	25.52	25.61	240603.0
2015-10-27	AACG	Stock	3.79	3.86	3.7	3.71	15500.0
2015-10-27	AAIC-DELISTED	Stock	14.53	14.55	13.41	13.63	719598.0
2015-10-27	AAL	Stock	46.41	46.69	45.65	46.46	6824100.0
2015-10-27	AAMC-DELISTED	Stock	7.4412	7.6265	7.0588	7.4147	50272.0
2015-10-27	AAME	Stock	4.25	4.36	4.23	4.3	4400.0
2015-10-27	AAMI	Stock	15.0	15.08	14.9	15.07	163500.0
2015-10-27	AAOI	Stock	19.73	20.67	19.47	20.45	512200.0
2015-10-27	AAON	Stock	14.0667	14.0667	13.72	13.86	145500.0
2015-10-27	AAP	Stock	192.25	193.89	191.38	193.27	416600.0
2015-10-27	AAT	Stock	43.23	43.54	43.0	43.1	225000.0
2015-10-27	AAU-DELISTED	Stock	0.581	0.6	0.58	0.58	43166.0
2015-10-27	AAUAF-DELISTED	Stock	0.581	0.6	0.58	0.58	43860.0
2015-10-27	AAV-DELISTED	Stock	5.44	5.46	5.31	5.37	78612.0
2015-10-27	AAVL-DELISTED	Stock	7.47	8.05	7.4	8.05	482683.0
2015-10-27	AAWW-DELISTED	Stock	40.61	40.63	39.16	40.01	291016.0
2015-10-27	AAXJ	Stock	57.64	57.79	57.48	57.61	743737.0
2015-10-27	AAXN-DELISTED	Stock	23.98	23.99	22.56	22.91	1610194.0
2015-10-27	AB	Stock	27.12	27.15	26.69	26.74	346100.0
2015-10-27	ABAC-DELISTED	Stock	0.62	0.64	0.62	0.62	2170.0
2015-10-27	ABAX-DELISTED	Stock	43.19	45.79	43.015	43.37	331367.0
2015-10-27	ABB-DELISTED	Stock	18.52	18.57	18.32	18.3399	3006553.0
2015-10-27	ABBNY-DELISTED	Stock	18.52	18.57	18.32	18.33	3663294.0
2015-10-27	ABBV	Stock	52.01	53.49	52.01	52.58	11710800.0
2015-10-27	ABC-DELISTED	Stock	93.93	102.64	92.99	97.55	7518401.0
2015-10-27	ABCB	Stock	30.34	30.97	30.28	30.83	314700.0
2015-10-27	ABCD-DELISTED	Stock	4.77	4.894	4.66	4.68	34446.0
2015-10-27	ABCO-DELISTED	Stock	43.79	44.328	42.17	42.57	299232.0
2015-10-27	ABCW-DELISTED	Stock	41.69	41.945	41.09	41.41	18262.0
2015-10-27	ABDC-DELISTED	Stock	12.12	12.25	11.805	11.96	24965.0
2015-10-27	ABE-DELISTED	Stock	11.4212	11.4212	11.35	11.3756	2651.0
2015-10-27	ABEO	Stock	102.0	102.0	96.25	98.25	3468.0
2015-10-27	ABEOW-DELISTED	Stock	1.54	1.72	1.54	1.72	2300.0
2015-10-27	ABEV	Stock	5.0	5.08	4.93	5.03	29555100.0
2015-10-27	ABG	Stock	80.0	80.0	77.37	77.54	367100.0
2015-10-27	ABGB-DELISTED	Stock	4.75	4.8	4.65	4.65	37004.0
2015-10-27	ABIL-DELISTED	Stock	10.1	10.1	10.0001	10.0001	37796.0

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

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