PREVIEW / stock_daily / 2015-12-18

all stock daily files

  file:    by_date/stock_daily/2015/2015-12-18.parquet
  size:    224 KB
  rows:    6,692
  symbols: 3,433

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-12-18	AAPL	Stock	27.2275	27.38	26.4525	26.5075	385813200.0
2015-12-18	MSFT	Stock	55.77	56.0	54.03	54.13	84684200.0
2015-12-18	NVDA	Stock	0.811	0.8193	0.8025	0.8035	395896000.0
2015-12-18	AMZN	Stock	33.4325	33.842	33.2065	33.207	136826000.0
2015-12-18	GOOGL	Stock	38.3615	38.707	37.8295	37.8425	67794040.0
2015-12-18	META	Stock	106.08	106.59	103.97	104.04	35994200.0
2015-12-18	TSLA	Stock	15.526	15.7267	15.286	15.364	45213000.0
2015-12-18	TLT	Stock	123.08	123.52	122.82	123.23	10171700.0
2015-12-18	ES	Stock	51.49	51.55	50.4	50.45	2540700.0
2015-12-18	CL	Stock	66.9	66.97	65.57	65.57	5115600.0
2015-12-18	A	Stock	40.56	40.71	40.08	40.1	3364800.0
2015-12-18	AA.B-DELISTED	Stock	31.2	31.93	31.17	31.52	49042.0
2015-12-18	AAAP-DELISTED	Stock	29.44	32.71	29.0	31.95	90354.0
2015-12-18	AABA-DELISTED	Stock	33.14	33.63	32.87	32.96	14748607.0
2015-12-18	AAC-DELISTED	Stock	22.8	23.53	21.95	22.0	186272.0
2015-12-18	AACG	Stock	6.09	6.24	5.95	6.01	133900.0
2015-12-18	AAIC-DELISTED	Stock	14.03	14.83	14.03	14.5	2481595.0
2015-12-18	AAL	Stock	41.61	42.31	40.7	41.09	17810000.0
2015-12-18	AAMC-DELISTED	Stock	3.9588	4.5353	3.9588	4.2912	238085.0
2015-12-18	AAME	Stock	4.69	4.74	4.61	4.74	3400.0
2015-12-18	AAMI	Stock	14.32	14.81	14.27	14.73	206500.0
2015-12-18	AAOI	Stock	16.77	17.06	16.67	16.92	303900.0
2015-12-18	AAON	Stock	15.2933	15.36	15.0933	15.1733	583950.0
2015-12-18	AAP	Stock	151.2	153.27	149.41	149.57	2221600.0
2015-12-18	AAT	Stock	39.11	39.79	38.19	38.26	663900.0
2015-12-18	AAU-DELISTED	Stock	0.5703	0.59	0.558	0.59	67338.0
2015-12-18	AAUAF-DELISTED	Stock	0.5703	0.59	0.558	0.59	69647.0
2015-12-18	AAV-DELISTED	Stock	4.51	4.67	4.47	4.67	50681.0
2015-12-18	AAVL-DELISTED	Stock	8.9	9.49	8.9	9.24	317449.0
2015-12-18	AAWW-DELISTED	Stock	40.62	40.7088	39.47	39.61	493798.0
2015-12-18	AAXJ	Stock	54.24	54.36	54.01	54.07	732506.0
2015-12-18	AAXN-DELISTED	Stock	16.89	17.36	16.78	16.9	1446458.0
2015-12-18	AB	Stock	23.21	23.47	23.09	23.29	224300.0
2015-12-18	ABAC-DELISTED	Stock	0.95	1.0	0.9301	0.9422	16299.0
2015-12-18	ABAX-DELISTED	Stock	52.58	52.9	51.16	51.18	335722.0
2015-12-18	ABB-DELISTED	Stock	17.59	17.64	17.4	17.47	2787847.0
2015-12-18	ABBNY-DELISTED	Stock	17.59	17.64	17.4	17.48	2845422.0
2015-12-18	ABBV	Stock	55.9	56.1	55.36	55.74	13807000.0
2015-12-18	ABC-DELISTED	Stock	102.13	102.61	101.24	101.86	3784499.0
2015-12-18	ABCB	Stock	34.0	34.12	32.78	33.09	1480100.0
2015-12-18	ABCD-DELISTED	Stock	4.95	5.17	4.81	5.17	177364.0
2015-12-18	ABCO-DELISTED	Stock	48.66	49.29	46.67	49.09	466484.0
2015-12-18	ABCW-DELISTED	Stock	45.01	45.44	43.045	45.2	83780.0
2015-12-18	ABDC-DELISTED	Stock	11.33	11.66	11.23	11.23	18310.0
2015-12-18	ABE-DELISTED	Stock	10.99	10.99	10.84	10.84	3752.0
2015-12-18	ABEO	Stock	89.25	92.0	85.0	88.25	2892.0
2015-12-18	ABEV	Stock	4.56	4.6	4.44	4.44	42687600.0
2015-12-18	ABG	Stock	67.47	67.79	65.65	66.76	922100.0
2015-12-18	ABGB-DELISTED	Stock	1.7499	1.75	1.65	1.7	21119.0
2015-12-18	ABIL-DELISTED	Stock	10.05	10.14	10.05	10.1	967608.0

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

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