PREVIEW / stock_daily / 2014-07-03

all stock daily files

  file:    by_date/stock_daily/2014/2014-07-03.parquet
  size:    217 KB
  rows:    6,525
  symbols: 3,532

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-03	AAPL	Stock	23.4175	23.525	23.3	23.5075	91567200.0
2014-07-03	MSFT	Stock	41.91	41.99	41.56	41.8	15969300.0
2014-07-03	NVDA	Stock	0.4628	0.4725	0.4628	0.4713	136892000.0
2014-07-03	AMZN	Stock	16.7415	16.915	16.654	16.8745	38886000.0
2014-07-03	GOOGL	Stock	29.585	29.7125	29.45	29.654	17977040.0
2014-07-03	META	Stock	66.86	67.0	65.76	66.29	25203200.0
2014-07-03	TSLA	Stock	15.4193	15.46	14.9333	15.2833	77500500.0
2014-07-03	TLT	Stock	110.38	110.86	110.34	110.68	6173946.0
2014-07-03	ES	Stock	45.9	45.96	45.32	45.68	934300.0
2014-07-03	CL	Stock	68.44	68.82	68.44	68.82	1205500.0
2014-07-03	A	Stock	41.6237	41.8741	41.5021	41.8169	839779.0
2014-07-03	AABA-DELISTED	Stock	36.07	36.15	35.9	36.14	8316806.0
2014-07-03	AACG	Stock	4.36	4.65	4.36	4.65	6700.0
2014-07-03	AAIC-DELISTED	Stock	27.03	27.1	26.68	26.73	224444.0
2014-07-03	AAL	Stock	42.61	42.94	41.4	41.62	8258000.0
2014-07-03	AAMC-DELISTED	Stock	195.6529	200.7291	192.3382	195.0	40820.0
2014-07-03	AAME	Stock	3.96	3.96	3.86	3.96	3200.0
2014-07-03	AAOI	Stock	23.25	23.32	22.96	23.25	37100.0
2014-07-03	AAON	Stock	15.0756	15.3333	15.0756	15.3067	103275.0
2014-07-03	AAP	Stock	135.05	135.2	134.13	134.94	300300.0
2014-07-03	AAT	Stock	34.94	34.94	34.36	34.61	70200.0
2014-07-03	AAU-DELISTED	Stock	1.42	1.43	1.38	1.42	63228.0
2014-07-03	AAUAF-DELISTED	Stock	1.42	1.43	1.38	1.42	64295.0
2014-07-03	AAV-DELISTED	Stock	6.64	6.71	6.55	6.67	86516.0
2014-07-03	AAWW-DELISTED	Stock	37.49	37.71	37.19	37.64	73549.0
2014-07-03	AAXJ	Stock	63.64	64.11	63.62	64.08	532283.0
2014-07-03	AAXN-DELISTED	Stock	13.31	13.36	13.11	13.18	251712.0
2014-07-03	AB	Stock	26.3	26.75	26.14	26.57	212800.0
2014-07-03	ABAC-DELISTED	Stock	2.1	2.2	2.07	2.12	45664.0
2014-07-03	ABAX-DELISTED	Stock	45.44	45.65	45.02	45.11	53569.0
2014-07-03	ABB-DELISTED	Stock	22.94	23.05	22.92	23.005	1967026.0
2014-07-03	ABBNY-DELISTED	Stock	22.94	23.05	22.833	23.02	2097964.0
2014-07-03	ABBV	Stock	57.9	58.27	57.65	58.22	3828900.0
2014-07-03	ABC-DELISTED	Stock	73.33	73.42	73.05	73.19	869172.0
2014-07-03	ABCB	Stock	22.07	22.43	22.07	22.42	32300.0
2014-07-03	ABCD-DELISTED	Stock	2.09	2.15	2.09	2.14	10801.0
2014-07-03	ABCO-DELISTED	Stock	51.98	52.46	51.43	52.24	70760.0
2014-07-03	ABDC-DELISTED	Stock	15.0	15.02	14.7	15.0	36872.0
2014-07-03	ABE-DELISTED	Stock	14.66	14.66	14.503	14.51	7039.0
2014-07-03	ABEO	Stock	350.0	350.0	350.0	350.0	10.0
2014-07-03	ABEV	Stock	7.07	7.2	7.06	7.19	3764900.0
2014-07-03	ABG	Stock	70.56	71.31	70.47	71.05	108800.0
2014-07-03	ABGB-DELISTED	Stock	27.5	28.01	27.5	28.01	2873.0
2014-07-03	ABM	Stock	26.89	27.29	26.84	27.2	94600.0
2014-07-03	ABMD-DELISTED	Stock	25.66	25.86	25.21	25.68	148542.0
2014-07-03	ABR	Stock	7.02	7.02	6.95	6.95	35800.0
2014-07-03	ABR.A-DELISTED	Stock	24.57	24.59	24.47	24.53	12940.0
2014-07-03	ABR.B-DELISTED	Stock	24.45	24.5	24.37	24.5	2820.0
2014-07-03	ABR.C-DELISTED	Stock	25.1	25.14	25.09	25.09	6650.0
2014-07-03	ABRN-DELISTED	Stock	24.94	24.94	24.8	24.82	7581.0

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

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