PREVIEW / stock_daily / 2014-12-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-16.parquet
  size:    222 KB
  rows:    6,631
  symbols: 3,541

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-12-16	AAPL	Stock	26.5925	27.54	26.565	26.6875	243162800.0
2014-12-16	MSFT	Stock	45.9	46.34	45.13	45.16	47801400.0
2014-12-16	NVDA	Stock	0.4888	0.4965	0.4835	0.4838	185308000.0
2014-12-16	AMZN	Stock	15.2175	15.2245	14.7505	14.753	130026000.0
2014-12-16	GOOGL	Stock	25.68	25.779	24.8595	24.908	86997640.0
2014-12-16	META	Stock	76.19	77.39	74.59	74.69	31554600.0
2014-12-16	TSLA	Stock	13.3927	13.5787	13.0247	13.1873	126391500.0
2014-12-16	TLT	Stock	127.36	127.72	126.36	127.6	7426434.0
2014-12-16	ES	Stock	50.67	51.44	50.18	50.97	2239200.0
2014-12-16	CL	Stock	67.76	68.51	67.25	67.51	4427400.0
2014-12-16	A	Stock	38.3	39.48	38.1	38.47	3842600.0
2014-12-16	AA.B-DELISTED	Stock	48.03	48.6	46.88	46.94	68872.0
2014-12-16	AABA-DELISTED	Stock	49.4	50.08	48.81	48.855	20106208.0
2014-12-16	AAC-DELISTED	Stock	29.77	30.57	29.06	29.38	77051.0
2014-12-16	AACG	Stock	2.99	3.3	2.79	3.25	35400.0
2014-12-16	AAIC-DELISTED	Stock	26.78	26.89	26.42	26.42	240543.0
2014-12-16	AAL	Stock	51.01	51.15	47.68	47.96	22053700.0
2014-12-16	AAMC-DELISTED	Stock	126.7647	132.3529	126.7647	128.4265	25347.0
2014-12-16	AAME	Stock	3.82	3.83	3.82	3.83	3500.0
2014-12-16	AAMI	Stock	15.93	16.28	15.75	15.77	377600.0
2014-12-16	AAOI	Stock	9.47	9.98	9.29	9.78	282600.0
2014-12-16	AAON	Stock	13.8867	14.2933	13.8867	13.98	223650.0
2014-12-16	AAP	Stock	161.0	161.26	156.98	157.01	1159200.0
2014-12-16	AAT	Stock	38.45	38.75	38.03	38.28	141400.0
2014-12-16	AAU-DELISTED	Stock	0.94	0.98	0.8713	0.872	180260.0
2014-12-16	AAUAF-DELISTED	Stock	0.94	0.98	0.8731	0.8738	181536.0
2014-12-16	AAV-DELISTED	Stock	4.58	5.03	4.56	4.8	505111.0
2014-12-16	AAVL-DELISTED	Stock	50.9	52.35	50.54	50.78	191045.0
2014-12-16	AAWW-DELISTED	Stock	45.69	46.21	44.822	45.06	215117.0
2014-12-16	AAXJ	Stock	59.11	60.02	58.97	59.26	1988013.0
2014-12-16	AAXN-DELISTED	Stock	22.76	23.31	22.55	22.85	2449124.0
2014-12-16	AB	Stock	24.0	24.41	23.8	23.83	228200.0
2014-12-16	ABAC-DELISTED	Stock	1.86	2.0	1.86	1.871	3500.0
2014-12-16	ABAX-DELISTED	Stock	56.03	57.89	55.68	56.69	156414.0
2014-12-16	ABB-DELISTED	Stock	20.57	21.04	20.551	20.73	2029286.0
2014-12-16	ABBNY-DELISTED	Stock	20.57	21.04	20.551	20.73	2138271.0
2014-12-16	ABBV	Stock	65.11	66.94	64.8	65.25	8545100.0
2014-12-16	ABC-DELISTED	Stock	90.19	91.15	89.255	89.43	2020939.0
2014-12-16	ABCB	Stock	25.61	26.25	25.61	25.76	87500.0
2014-12-16	ABCD-DELISTED	Stock	1.59	1.6	1.51	1.54	22528.0
2014-12-16	ABCO-DELISTED	Stock	48.0	48.78	47.36	48.28	297240.0
2014-12-16	ABCW-DELISTED	Stock	32.0	32.0	30.78	31.74	29793.0
2014-12-16	ABDC-DELISTED	Stock	11.6	11.64	11.2	11.54	117689.0
2014-12-16	ABE-DELISTED	Stock	12.95	12.95	12.397	12.78	16534.0
2014-12-16	ABEO	Stock	143.75	153.75	143.75	153.75	16.0
2014-12-16	ABEV	Stock	5.59	5.85	5.56	5.68	17731700.0
2014-12-16	ABG	Stock	74.78	75.67	73.13	73.17	465100.0
2014-12-16	ABGB-DELISTED	Stock	11.93	12.25	11.6999	11.96	36001.0
2014-12-16	ABIL-DELISTED	Stock	9.85	9.85	9.85	9.85	400.0
2014-12-16	ABM	Stock	27.62	28.0	27.52	27.87	280200.0

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

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