PREVIEW / stock_daily / 2015-09-29

all stock daily files

  file:    by_date/stock_daily/2015/2015-09-29.parquet
  size:    221 KB
  rows:    6,641
  symbols: 3,453

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-29	AAPL	Stock	28.2075	28.3775	26.965	27.265	293461600.0
2015-09-29	MSFT	Stock	43.37	43.57	43.05	43.44	32763600.0
2015-09-29	NVDA	Stock	0.5888	0.5938	0.5805	0.5928	380736000.0
2015-09-29	AMZN	Stock	25.3	25.574	24.525	24.8035	89150000.0
2015-09-29	GOOGL	Stock	31.275	31.734	30.9015	31.1305	42129320.0
2015-09-29	META	Stock	89.1	90.06	85.72	86.67	42281800.0
2015-09-29	TSLA	Stock	16.6973	16.982	16.364	16.4433	55548000.0
2015-09-29	TLT	Stock	123.54	124.29	123.25	123.97	9006123.0
2015-09-29	ES	Stock	49.21	49.77	49.11	49.3	2501800.0
2015-09-29	CL	Stock	62.16	63.19	62.1	63.07	3884500.0
2015-09-29	A	Stock	33.36	34.06	33.24	33.74	2252400.0
2015-09-29	AA.B-DELISTED	Stock	33.57	33.98	32.79	33.06	104509.0
2015-09-29	AABA-DELISTED	Stock	28.59	29.23	27.85	28.27	38130002.0
2015-09-29	AAC-DELISTED	Stock	23.4	23.79	22.6	23.46	316210.0
2015-09-29	AACG	Stock	2.66	2.82	2.51	2.51	25800.0
2015-09-29	AAIC-DELISTED	Stock	14.39	14.39	13.901	13.99	501827.0
2015-09-29	AAL	Stock	39.05	39.77	38.79	39.18	7478800.0
2015-09-29	AAMC-DELISTED	Stock	7.25	7.25	6.8821	6.9265	22651.0
2015-09-29	AAME	Stock	4.0	4.05	3.98	4.05	8200.0
2015-09-29	AAMI	Stock	14.76	15.09	14.69	14.94	127300.0
2015-09-29	AAOI	Stock	17.69	18.2	16.67	16.89	365500.0
2015-09-29	AAON	Stock	13.1933	13.1933	12.6667	12.7467	337950.0
2015-09-29	AAP	Stock	171.27	172.31	169.4	170.53	904300.0
2015-09-29	AAT	Stock	40.71	40.95	40.38	40.84	245900.0
2015-09-29	AAU-DELISTED	Stock	0.52	0.5695	0.52	0.5634	54713.0
2015-09-29	AAUAF-DELISTED	Stock	0.52	0.5695	0.52	0.5634	56400.0
2015-09-29	AAV-DELISTED	Stock	5.31	5.31	5.06	5.08	140843.0
2015-09-29	AAVL-DELISTED	Stock	8.63	8.71	7.89	8.02	459672.0
2015-09-29	AAWW-DELISTED	Stock	34.19	34.56	33.73	34.3	163095.0
2015-09-29	AAXJ	Stock	51.17	51.59	50.99	51.34	1658542.0
2015-09-29	AAXN-DELISTED	Stock	21.99	22.05	21.3	21.57	1200394.0
2015-09-29	AB	Stock	25.7	26.34	25.58	25.97	186800.0
2015-09-29	ABAC-DELISTED	Stock	0.551	0.551	0.51	0.51	3073.0
2015-09-29	ABAX-DELISTED	Stock	43.72	44.34	42.55	42.76	185323.0
2015-09-29	ABB-DELISTED	Stock	17.43	17.46	17.28	17.365	2558514.0
2015-09-29	ABBNY-DELISTED	Stock	17.43	17.46	17.28	17.37	2700301.0
2015-09-29	ABBV	Stock	53.1	54.19	51.88	52.79	12842800.0
2015-09-29	ABC-DELISTED	Stock	96.19	96.81	94.41	95.01	2478221.0
2015-09-29	ABCB	Stock	28.23	28.6	28.07	28.47	149900.0
2015-09-29	ABCD-DELISTED	Stock	4.72	4.72	4.5	4.6	94245.0
2015-09-29	ABCO-DELISTED	Stock	45.0	45.43	44.51	45.09	299029.0
2015-09-29	ABCW-DELISTED	Stock	40.98	42.41	40.98	41.98	35181.0
2015-09-29	ABDC-DELISTED	Stock	12.06	12.35	11.55	11.66	46121.0
2015-09-29	ABE-DELISTED	Stock	10.68	10.68	10.5	10.51	6636.0
2015-09-29	ABEO	Stock	104.0	109.5	93.25	99.5	8772.0
2015-09-29	ABEOW-DELISTED	Stock	1.62	1.62	1.5	1.5	5500.0
2015-09-29	ABEV	Stock	4.67	4.83	4.62	4.78	14221800.0
2015-09-29	ABG	Stock	78.56	79.78	78.22	79.55	319400.0
2015-09-29	ABGB-DELISTED	Stock	4.57	4.72	4.53	4.7	107331.0
2015-09-29	ABIL-DELISTED	Stock	9.95	10.0	9.95	10.0	4959.0

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

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