PREVIEW / stock_daily / 2014-10-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-29.parquet
  size:    221 KB
  rows:    6,605
  symbols: 3,556

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-10-29	AAPL	Stock	26.6625	26.8425	26.59	26.835	210751600.0
2014-10-29	MSFT	Stock	46.44	46.7	46.34	46.62	30276100.0
2014-10-29	NVDA	Stock	0.4713	0.474	0.466	0.4702	168340000.0
2014-10-29	AMZN	Stock	14.9555	14.9805	14.6535	14.706	97638000.0
2014-10-29	GOOGL	Stock	28.0425	28.2485	27.799	27.9225	41067100.0
2014-10-29	META	Stock	75.45	76.88	74.78	75.86	106120000.0
2014-10-29	TSLA	Stock	16.0753	16.1	15.7093	15.8733	74437500.0
2014-10-29	TLT	Stock	118.96	119.82	118.42	119.46	9106612.0
2014-10-29	ES	Stock	48.78	48.91	47.89	48.35	1245500.0
2014-10-29	CL	Stock	65.79	66.11	65.32	65.85	2384200.0
2014-10-29	A	Stock	39.0486	39.113	38.7196	38.9843	2074213.0
2014-10-29	AA.B-DELISTED	Stock	51.2	51.34	50.42	51.01	137063.0
2014-10-29	AABA-DELISTED	Stock	45.94	45.98	45.13	45.42	23680910.0
2014-10-29	AAC-DELISTED	Stock	21.99	22.0	21.33	21.39	197066.0
2014-10-29	AACG	Stock	4.19	4.19	4.15	4.15	1000.0
2014-10-29	AAIC-DELISTED	Stock	27.32	27.44	27.08	27.14	413115.0
2014-10-29	AAL	Stock	40.07	40.4	39.24	39.94	15782400.0
2014-10-29	AAMC-DELISTED	Stock	168.8235	171.2206	156.9294	160.1471	64719.0
2014-10-29	AAME	Stock	3.86	3.92	3.78	3.92	6200.0
2014-10-29	AAMI	Stock	15.0	15.01	14.62	14.78	107200.0
2014-10-29	AAOI	Stock	15.48	15.52	15.146	15.38	105900.0
2014-10-29	AAON	Stock	12.9267	13.02	12.62	12.76	175350.0
2014-10-29	AAP	Stock	146.33	146.33	143.95	145.03	490800.0
2014-10-29	AAT	Stock	37.68	37.74	37.15	37.51	144300.0
2014-10-29	AAU-DELISTED	Stock	1.27	1.3313	1.2688	1.28	218218.0
2014-10-29	AAUAF-DELISTED	Stock	1.24	1.3	1.239	1.28	227185.0
2014-10-29	AAV-DELISTED	Stock	4.28	4.35	4.17	4.29	294010.0
2014-10-29	AAVL-DELISTED	Stock	33.28	34.89	32.7625	33.495	119810.0
2014-10-29	AAWW-DELISTED	Stock	36.7	37.44	35.91	36.43	162548.0
2014-10-29	AAXJ	Stock	62.55	62.76	62.02	62.26	299296.0
2014-10-29	AAXN-DELISTED	Stock	16.27	16.495	15.83	16.47	2101936.0
2014-10-29	AB	Stock	26.71	26.91	26.2	26.45	300500.0
2014-10-29	ABAC-DELISTED	Stock	2.35	2.3999	2.3001	2.39	69008.0
2014-10-29	ABAX-DELISTED	Stock	50.18	50.59	49.02	49.6	100499.0
2014-10-29	ABB-DELISTED	Stock	21.92	21.95	21.49	21.56	1452335.0
2014-10-29	ABBNY-DELISTED	Stock	21.92	21.95	21.49	21.57	1542585.0
2014-10-29	ABBV	Stock	60.99	60.99	59.36	59.98	16547900.0
2014-10-29	ABC-DELISTED	Stock	79.58	80.19	79.26	79.74	2321029.0
2014-10-29	ABCB	Stock	24.57	24.68	24.24	24.5	136400.0
2014-10-29	ABCD-DELISTED	Stock	1.64	1.64	1.48	1.51	15600.0
2014-10-29	ABCO-DELISTED	Stock	53.62	54.03	52.41	52.61	214533.0
2014-10-29	ABCW-DELISTED	Stock	29.54	30.5	29.54	30.01	4460.0
2014-10-29	ABDC-DELISTED	Stock	12.58	12.88	12.4118	12.49	54538.0
2014-10-29	ABE-DELISTED	Stock	14.08	14.0978	13.9618	14.0537	9945.0
2014-10-29	ABEO	Stock	222.5	222.5	222.5	222.5	40.0
2014-10-29	ABEV	Stock	6.47	6.5	6.29	6.44	15506300.0
2014-10-29	ABG	Stock	69.56	69.7	67.83	68.28	304500.0
2014-10-29	ABGB-DELISTED	Stock	21.45	21.6	20.24	20.41	14028.0
2014-10-29	ABM	Stock	27.16	27.32	26.95	27.23	178900.0
2014-10-29	ABMD-DELISTED	Stock	24.95	25.35	24.77	25.35	189433.0

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

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