PREVIEW / stock_daily / 2014-11-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-04.parquet
  size:    221 KB
  rows:    6,593
  symbols: 3,535

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
2014-11-04	AAPL	Stock	27.34	27.3725	26.93	27.15	166297600.0
2014-11-04	MSFT	Stock	47.3	47.73	47.25	47.57	21530800.0
2014-11-04	NVDA	Stock	0.5	0.505	0.4918	0.5032	360196000.0
2014-11-04	AMZN	Stock	15.1995	15.2125	15.0085	15.1405	68548000.0
2014-11-04	GOOGL	Stock	28.058	28.2395	27.915	28.2095	27730180.0
2014-11-04	META	Stock	74.23	75.77	73.65	75.76	39326000.0
2014-11-04	TSLA	Stock	16.0327	16.1567	15.7687	15.9287	55239000.0
2014-11-04	TLT	Stock	119.42	119.91	119.08	119.33	3664808.0
2014-11-04	ES	Stock	49.49	49.97	49.23	49.51	1226000.0
2014-11-04	CL	Stock	67.17	68.15	67.14	68.05	3836300.0
2014-11-04	A	Stock	40.26	40.83	39.84	40.18	5765200.0
2014-11-04	AA.B-DELISTED	Stock	52.14	52.14	51.42	51.6	43976.0
2014-11-04	AABA-DELISTED	Stock	45.98	47.13	45.74	47.07	23196202.0
2014-11-04	AAC-DELISTED	Stock	22.18	22.39	21.7743	21.86	30871.0
2014-11-04	AACG	Stock	4.0	4.26	4.0	4.04	2600.0
2014-11-04	AAIC-DELISTED	Stock	27.56	27.65	27.32	27.43	245023.0
2014-11-04	AAL	Stock	42.83	43.7	42.5	42.7	17421200.0
2014-11-04	AAMC-DELISTED	Stock	147.0588	150.0	143.5441	150.0	62699.0
2014-11-04	AAME	Stock	3.8	3.84	3.7	3.75	20100.0
2014-11-04	AAMI	Stock	14.78	14.92	14.0	14.7	207100.0
2014-11-04	AAOI	Stock	16.14	16.3	15.82	15.86	162900.0
2014-11-04	AAON	Stock	13.2667	13.5267	13.2667	13.5	373050.0
2014-11-04	AAP	Stock	147.09	148.75	147.09	148.44	1029200.0
2014-11-04	AAT	Stock	38.4	38.66	38.32	38.48	169500.0
2014-11-04	AAU-DELISTED	Stock	1.13	1.16	1.09	1.1	225900.0
2014-11-04	AAUAF-DELISTED	Stock	1.13	1.16	1.09	1.1	230495.0
2014-11-04	AAV-DELISTED	Stock	4.15	4.17	3.97	4.045	473881.0
2014-11-04	AAVL-DELISTED	Stock	36.09	37.3799	35.45	36.4	71922.0
2014-11-04	AAWW-DELISTED	Stock	37.48	38.95	37.08	37.24	300967.0
2014-11-04	AAXJ	Stock	62.5	62.55	62.17	62.53	369163.0
2014-11-04	AAXN-DELISTED	Stock	19.05	19.1699	18.25	18.485	4090059.0
2014-11-04	AB	Stock	25.94	26.23	25.81	26.12	182800.0
2014-11-04	ABAC-DELISTED	Stock	2.38	2.38	2.28	2.3399	46308.0
2014-11-04	ABAX-DELISTED	Stock	52.86	53.88	52.78	53.39	140169.0
2014-11-04	ABB-DELISTED	Stock	21.73	21.78	21.6332	21.69	1010071.0
2014-11-04	ABBNY-DELISTED	Stock	21.72	21.78	21.6332	21.68	1096027.0
2014-11-04	ABBV	Stock	63.21	63.61	62.32	62.66	9741700.0
2014-11-04	ABC-DELISTED	Stock	86.63	88.215	86.495	88.17	2537399.0
2014-11-04	ABCB	Stock	24.62	24.71	24.26	24.59	68300.0
2014-11-04	ABCD-DELISTED	Stock	1.51	1.56	1.5	1.54	67415.0
2014-11-04	ABCO-DELISTED	Stock	53.25	54.4	53.25	53.9	175523.0
2014-11-04	ABCW-DELISTED	Stock	31.49	31.7	29.76	30.2453	1300.0
2014-11-04	ABDC-DELISTED	Stock	12.91	13.06	12.71	13.06	21971.0
2014-11-04	ABE-DELISTED	Stock	13.91	14.07	13.9	14.07	6107.0
2014-11-04	ABEO	Stock	325.0	375.0	275.0	288.75	112.0
2014-11-04	ABEV	Stock	6.43	6.56	6.36	6.55	20368400.0
2014-11-04	ABG	Stock	70.47	71.1	68.7	68.93	401400.0
2014-11-04	ABGB-DELISTED	Stock	20.96	20.96	20.62	20.75	7485.0
2014-11-04	ABM	Stock	27.15	27.46	27.14	27.18	170400.0
2014-11-04	ABMD-DELISTED	Stock	32.34	32.4	31.25	31.84	468943.0

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

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