PREVIEW / stock_daily / 2014-07-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-15.parquet
  size:    222 KB
  rows:    6,610
  symbols: 3,591

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-07-15	AAPL	Stock	24.2	24.2125	23.7575	23.83	181911600.0
2014-07-15	MSFT	Stock	42.33	42.47	42.03	42.45	28748700.0
2014-07-15	NVDA	Stock	0.483	0.4855	0.4798	0.4843	395440000.0
2014-07-15	AMZN	Stock	17.686	17.7795	17.47	17.722	83418000.0
2014-07-15	GOOGL	Stock	29.7575	29.765	29.2655	29.653	33479580.0
2014-07-15	META	Stock	67.96	68.09	66.26	67.17	44213200.0
2014-07-15	TSLA	Stock	15.1153	15.1767	14.54	14.6387	85777500.0
2014-07-15	TLT	Stock	112.83	113.47	112.5034	112.86	7720027.0
2014-07-15	ES	Stock	45.21	45.55	45.16	45.4	1430500.0
2014-07-15	CL	Stock	69.66	69.8	69.35	69.66	2835200.0
2014-07-15	A	Stock	40.5579	40.6867	40.1645	40.5293	2928111.0
2014-07-15	AABA-DELISTED	Stock	35.72	35.94	35.2	35.6	35212210.0
2014-07-15	AACG	Stock	4.22	4.42	4.21	4.42	1100.0
2014-07-15	AAIC-DELISTED	Stock	26.95	27.06	26.7688	27.05	166903.0
2014-07-15	AAL	Stock	43.33	43.73	42.78	43.7	8358400.0
2014-07-15	AAMC-DELISTED	Stock	220.5853	223.5294	217.6471	218.5912	47301.0
2014-07-15	AAME	Stock	3.87	4.0	3.8	3.95	37800.0
2014-07-15	AAOI	Stock	23.05	23.4	22.696	23.36	196500.0
2014-07-15	AAON	Stock	14.5289	14.7111	14.0711	14.2133	185625.0
2014-07-15	AAP	Stock	134.25	134.81	132.39	132.64	524000.0
2014-07-15	AAT	Stock	35.19	35.36	34.91	35.15	126900.0
2014-07-15	AAU-DELISTED	Stock	1.47	1.47	1.39	1.41	111160.0
2014-07-15	AAUAF-DELISTED	Stock	1.47	1.47	1.39	1.41	116122.0
2014-07-15	AAV-DELISTED	Stock	5.9	5.9	5.62	5.71	541870.0
2014-07-15	AAWW-DELISTED	Stock	34.84	35.84	34.66	35.8	232542.0
2014-07-15	AAXJ	Stock	63.92	63.97	63.54	63.825	214995.0
2014-07-15	AAXN-DELISTED	Stock	11.22	11.29	10.81	10.87	1527019.0
2014-07-15	AB	Stock	27.33	27.52	27.1	27.43	341600.0
2014-07-15	ABAC-DELISTED	Stock	2.19	2.19	2.1	2.13	20139.0
2014-07-15	ABAX-DELISTED	Stock	43.12	43.86	42.26	42.3	75609.0
2014-07-15	ABB-DELISTED	Stock	22.79	22.89	22.71	22.77	961374.0
2014-07-15	ABBNY-DELISTED	Stock	22.79	22.89	22.71	22.77	1001103.0
2014-07-15	ABBV	Stock	54.52	54.69	53.39	53.44	16796400.0
2014-07-15	ABC-DELISTED	Stock	72.8	73.09	72.45	72.71	1505945.0
2014-07-15	ABCB	Stock	21.27	21.43	21.09	21.21	46200.0
2014-07-15	ABCD-DELISTED	Stock	2.05	2.05	1.81	1.89	110996.0
2014-07-15	ABCO-DELISTED	Stock	51.46	51.69	50.68	50.83	118185.0
2014-07-15	ABDC-DELISTED	Stock	14.19	14.22	13.89	14.06	76714.0
2014-07-15	ABE-DELISTED	Stock	14.44	14.53	14.44	14.46	10387.0
2014-07-15	ABEO	Stock	325.0	337.5	312.5	325.0	68.0
2014-07-15	ABEV	Stock	7.0	7.02	6.92	7.02	24487600.0
2014-07-15	ABG	Stock	71.63	71.94	70.81	71.29	220500.0
2014-07-15	ABGB-DELISTED	Stock	25.48	25.5	25.3101	25.35	12912.0
2014-07-15	ABIL-DELISTED	Stock	9.76	9.79	9.76	9.78	9800.0
2014-07-15	ABM	Stock	26.11	26.25	25.78	25.8	141500.0
2014-07-15	ABMD-DELISTED	Stock	24.85	25.01	24.64	24.94	214804.0
2014-07-15	ABR	Stock	6.93	6.94	6.88	6.88	30300.0
2014-07-15	ABR.A-DELISTED	Stock	24.87	24.87	24.72	24.8299	6550.0
2014-07-15	ABR.B-DELISTED	Stock	24.63	24.65	24.22	24.48	1472.0
2014-07-15	ABR.C-DELISTED	Stock	25.2	25.24	25.2	25.22	1926.0

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

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