PREVIEW / stock_daily / 2015-09-28

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-28.parquet
  size:    221 KB
  rows:    6,654
  symbols: 3,452

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-09-28	AAPL	Stock	28.4625	28.6425	28.11	28.11	208436000.0
2015-09-28	MSFT	Stock	43.83	44.09	43.21	43.29	27613800.0
2015-09-28	NVDA	Stock	0.5903	0.594	0.5788	0.5825	395584000.0
2015-09-28	AMZN	Stock	26.001	26.014	24.7165	25.203	108690000.0
2015-09-28	GOOGL	Stock	31.9525	32.1425	30.892	31.2125	47646000.0
2015-09-28	META	Stock	92.08	92.29	88.18	89.21	41199900.0
2015-09-28	TSLA	Stock	17.1567	17.3193	16.4407	16.562	73516500.0
2015-09-28	TLT	Stock	122.2	123.77	122.199	123.62	9833354.0
2015-09-28	ES	Stock	48.83	49.2	48.67	49.09	2001500.0
2015-09-28	CL	Stock	62.97	63.28	62.16	62.16	4581800.0
2015-09-28	A	Stock	34.13	34.27	33.32	33.37	2615400.0
2015-09-28	AA.B-DELISTED	Stock	33.51	33.89	32.7277	33.46	661832.0
2015-09-28	AABA-DELISTED	Stock	29.03	29.22	27.2	27.67	45015722.0
2015-09-28	AAC-DELISTED	Stock	25.21	25.5	22.13	23.35	932328.0
2015-09-28	AACG	Stock	2.5	2.8	2.5	2.62	6500.0
2015-09-28	AAIC-DELISTED	Stock	15.03	15.084	14.1	14.35	740642.0
2015-09-28	AAL	Stock	39.87	40.18	38.64	39.08	9635900.0
2015-09-28	AAMC-DELISTED	Stock	7.0706	7.1824	6.8588	7.0735	23392.0
2015-09-28	AAME	Stock	3.97	4.0	3.56	4.0	7100.0
2015-09-28	AAMI	Stock	14.76	14.78	14.535	14.71	104800.0
2015-09-28	AAOI	Stock	17.49	17.74	17.2	17.62	308200.0
2015-09-28	AAON	Stock	13.06	13.2133	12.9667	13.1667	322350.0
2015-09-28	AAP	Stock	176.53	177.77	171.28	171.4	1023300.0
2015-09-28	AAT	Stock	40.46	40.67	39.93	40.6	305900.0
2015-09-28	AAU-DELISTED	Stock	0.523	0.5558	0.51	0.54	109125.0
2015-09-28	AAUAF-DELISTED	Stock	0.523	0.5558	0.51	0.54	110114.0
2015-09-28	AAV-DELISTED	Stock	5.29	5.35	5.23	5.25	55509.0
2015-09-28	AAVL-DELISTED	Stock	9.05	9.2099	8.38	8.68	361844.0
2015-09-28	AAWW-DELISTED	Stock	35.22	35.85	34.2	34.22	390587.0
2015-09-28	AAXJ	Stock	51.66	51.75	51.03	51.19	955591.0
2015-09-28	AAXN-DELISTED	Stock	23.48	23.54	21.77	21.95	1625679.0
2015-09-28	AB	Stock	26.26	26.3	25.5	25.66	282200.0
2015-09-28	ABAC-DELISTED	Stock	0.6498	0.6498	0.55	0.55	3426.0
2015-09-28	ABAX-DELISTED	Stock	46.38	46.38	43.5501	43.76	100951.0
2015-09-28	ABB-DELISTED	Stock	17.36	17.39	17.13	17.15	2874475.0
2015-09-28	ABBNY-DELISTED	Stock	17.36	17.39	17.13	17.14	3004741.0
2015-09-28	ABBV	Stock	55.39	55.43	52.34	52.5	15123000.0
2015-09-28	ABC-DELISTED	Stock	99.34	99.65	96.12	96.2	2928254.0
2015-09-28	ABCB	Stock	28.17	28.45	28.0	28.11	147100.0
2015-09-28	ABCD-DELISTED	Stock	4.8	4.85	4.66	4.68	46854.0
2015-09-28	ABCO-DELISTED	Stock	45.27	46.69	43.585	44.99	323238.0
2015-09-28	ABCW-DELISTED	Stock	40.97	41.23	40.76	40.97	9782.0
2015-09-28	ABDC-DELISTED	Stock	12.42	12.75	11.772	12.08	158572.0
2015-09-28	ABE-DELISTED	Stock	10.7	10.7	10.5	10.62	4884.0
2015-09-28	ABEO	Stock	114.75	114.75	102.5	105.5	7392.0
2015-09-28	ABEOW-DELISTED	Stock	1.73	1.76	1.69	1.69	6597.0
2015-09-28	ABEV	Stock	4.83	4.84	4.69	4.71	21392300.0
2015-09-28	ABG	Stock	82.25	82.71	78.14	78.31	317000.0
2015-09-28	ABGB-DELISTED	Stock	4.54	4.7	4.442	4.62	52407.0
2015-09-28	ABIL-DELISTED	Stock	9.95	9.95	9.95	9.95	226.0

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

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