PREVIEW / stock_daily / 2015-03-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-18.parquet
  size:    222 KB
  rows:    6,604
  symbols: 3,496

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-03-18	AAPL	Stock	31.75	32.29	31.5925	32.1175	261083600.0
2015-03-18	MSFT	Stock	41.43	42.83	41.33	42.5	44194800.0
2015-03-18	NVDA	Stock	0.5812	0.5843	0.5665	0.5718	413844000.0
2015-03-18	AMZN	Stock	18.4985	18.7995	18.335	18.757	53082000.0
2015-03-18	GOOGL	Stock	27.8865	28.3255	27.675	28.308	35324420.0
2015-03-18	META	Stock	79.25	81.24	79.17	80.91	36912400.0
2015-03-18	TSLA	Stock	12.9973	13.392	12.874	13.3807	72313500.0
2015-03-18	TLT	Stock	129.91	131.53	128.6101	131.49	13981903.0
2015-03-18	ES	Stock	49.6	51.19	49.3	50.83	2351700.0
2015-03-18	CL	Stock	68.25	68.74	66.88	68.33	5386900.0
2015-03-18	A	Stock	41.45	42.38	41.17	42.12	1295600.0
2015-03-18	AA.B-DELISTED	Stock	44.06	45.02	43.71	44.75	220309.0
2015-03-18	AABA-DELISTED	Stock	43.63	44.71	43.43	44.67	18044161.0
2015-03-18	AAC-DELISTED	Stock	29.45	29.98	29.365	29.77	106162.0
2015-03-18	AACG	Stock	3.98	3.98	3.85	3.97	4500.0
2015-03-18	AAIC-DELISTED	Stock	24.57	24.98	24.57	24.89	369082.0
2015-03-18	AAL	Stock	53.69	54.6	53.34	54.13	21325000.0
2015-03-18	AAMC-DELISTED	Stock	59.25	62.3529	57.3529	62.3529	30229.0
2015-03-18	AAME	Stock	4.02	4.05	4.02	4.04	1000.0
2015-03-18	AAMI	Stock	18.06	18.29	17.16	18.0	371500.0
2015-03-18	AAOI	Stock	12.76	13.4	12.67	13.27	225700.0
2015-03-18	AAON	Stock	14.82	15.0067	14.66	15.0067	117150.0
2015-03-18	AAP	Stock	149.56	149.71	147.01	149.03	715600.0
2015-03-18	AAT	Stock	42.6	43.36	42.33	43.25	265400.0
2015-03-18	AAU-DELISTED	Stock	0.91	0.99	0.9087	0.95	160859.0
2015-03-18	AAUAF-DELISTED	Stock	0.88	0.96	0.88	0.95	167825.0
2015-03-18	AAV-DELISTED	Stock	5.11	5.45	5.095	5.43	176652.0
2015-03-18	AAVL-DELISTED	Stock	42.13	42.13	40.52	41.4	211984.0
2015-03-18	AAWW-DELISTED	Stock	46.2	47.36	46.13	46.94	134401.0
2015-03-18	AAXJ	Stock	62.56	63.89	62.37	63.66	991189.0
2015-03-18	AAXN-DELISTED	Stock	23.36	23.98	23.352	23.96	873607.0
2015-03-18	AB	Stock	29.2	30.42	29.17	30.37	451300.0
2015-03-18	ABAC-DELISTED	Stock	1.4801	1.52	1.47	1.52	10800.0
2015-03-18	ABAX-DELISTED	Stock	64.0	64.282	63.01	63.19	127959.0
2015-03-18	ABB-DELISTED	Stock	20.54	21.125	20.485	21.04	2241330.0
2015-03-18	ABBNY-DELISTED	Stock	20.54	21.125	20.485	21.04	2354086.0
2015-03-18	ABBV	Stock	59.76	60.42	59.25	59.89	11889200.0
2015-03-18	ABC-DELISTED	Stock	110.45	112.28	109.82	111.71	1735204.0
2015-03-18	ABCB	Stock	26.29	26.48	25.92	26.07	74700.0
2015-03-18	ABCD-DELISTED	Stock	2.98	3.11	2.96	3.05	121151.0
2015-03-18	ABCO-DELISTED	Stock	52.55	52.99	52.11	52.29	185755.0
2015-03-18	ABCW-DELISTED	Stock	34.0	35.17	33.72	35.17	10314.0
2015-03-18	ABDC-DELISTED	Stock	13.9	13.98	13.66	13.87	47779.0
2015-03-18	ABE-DELISTED	Stock	12.56	13.73	12.39	12.6	130767.0
2015-03-18	ABEO	Stock	82.5	85.0	82.25	83.25	760.0
2015-03-18	ABEOW-DELISTED	Stock	0.84	0.9401	0.84	0.9401	4223.0
2015-03-18	ABEV	Stock	5.63	5.83	5.58	5.75	12440500.0
2015-03-18	ABG	Stock	77.5	78.69	76.51	78.55	235400.0
2015-03-18	ABGB-DELISTED	Stock	16.0875	16.71	16.005	16.59	42851.0
2015-03-18	ABM	Stock	31.03	31.77	30.8	31.61	326900.0

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

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