PREVIEW / stock_daily / 2014-12-04

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-04.parquet
  size:    222 KB
  rows:    6,629
  symbols: 3,539

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-04	AAPL	Stock	28.9425	29.3	28.8225	28.8725	168178000.0
2014-12-04	MSFT	Stock	48.39	49.06	48.2	48.84	30320400.0
2014-12-04	NVDA	Stock	0.5278	0.5298	0.5202	0.5238	185332000.0
2014-12-04	AMZN	Stock	15.7765	15.9295	15.6735	15.8465	65806000.0
2014-12-04	GOOGL	Stock	26.882	27.1345	26.7445	27.129	32673760.0
2014-12-04	META	Stock	74.83	75.55	74.66	75.24	14362800.0
2014-12-04	TSLA	Stock	15.24	15.3933	15.1873	15.2187	57834000.0
2014-12-04	TLT	Stock	120.75	121.8	120.62	121.8	4250485.0
2014-12-04	ES	Stock	51.29	51.72	51.13	51.56	1766200.0
2014-12-04	CL	Stock	69.06	69.57	68.83	69.45	3071000.0
2014-12-04	A	Stock	42.15	42.68	42.02	42.27	1345000.0
2014-12-04	AA.B-DELISTED	Stock	53.58	53.7	53.02	53.28	22144.0
2014-12-04	AABA-DELISTED	Stock	50.19	50.665	49.8968	50.4	11130757.0
2014-12-04	AAC-DELISTED	Stock	30.83	32.1999	30.1	30.46	67585.0
2014-12-04	AACG	Stock	3.51	3.61	3.26	3.3	22100.0
2014-12-04	AAIC-DELISTED	Stock	28.04	28.12	27.82	28.0	246815.0
2014-12-04	AAL	Stock	49.6	50.27	49.32	49.65	15219000.0
2014-12-04	AAMC-DELISTED	Stock	144.1471	147.0559	142.9412	147.0559	13311.0
2014-12-04	AAME	Stock	3.84	3.88	3.75	3.88	6600.0
2014-12-04	AAMI	Stock	15.515	15.753	15.28	15.5	104000.0
2014-12-04	AAOI	Stock	10.15	10.15	9.93	9.99	316300.0
2014-12-04	AAON	Stock	13.8467	13.8467	13.7133	13.82	297150.0
2014-12-04	AAP	Stock	152.42	153.53	150.66	153.25	800500.0
2014-12-04	AAT	Stock	39.38	39.44	38.93	39.3	156400.0
2014-12-04	AAU-DELISTED	Stock	1.05	1.0601	1.0197	1.05	57142.0
2014-12-04	AAUAF-DELISTED	Stock	1.04	1.05	1.01	1.05	58498.0
2014-12-04	AAV-DELISTED	Stock	4.43	4.44	3.95	4.34	335339.0
2014-12-04	AAVL-DELISTED	Stock	41.29	42.702	40.0101	42.2	104281.0
2014-12-04	AAWW-DELISTED	Stock	46.83	47.82	46.36	47.34	251208.0
2014-12-04	AAXJ	Stock	62.71	62.84	62.56	62.68	381927.0
2014-12-04	AAXN-DELISTED	Stock	23.63	24.45	23.27	24.145	9023296.0
2014-12-04	AB	Stock	26.71	26.71	26.0	26.13	186000.0
2014-12-04	ABAC-DELISTED	Stock	2.05	2.05	2.0301	2.0468	10486.0
2014-12-04	ABAX-DELISTED	Stock	57.9	58.61	56.89	57.27	167087.0
2014-12-04	ABB-DELISTED	Stock	21.96	22.15	21.92	22.04	1498335.0
2014-12-04	ABBNY-DELISTED	Stock	21.96	22.15	21.92	22.03	1650362.0
2014-12-04	ABBV	Stock	68.35	69.86	68.29	69.57	7665300.0
2014-12-04	ABC-DELISTED	Stock	91.87	92.645	91.68	91.93	1261254.0
2014-12-04	ABCB	Stock	24.83	25.06	24.7	24.89	94400.0
2014-12-04	ABCD-DELISTED	Stock	1.67	1.6999	1.61	1.62	26298.0
2014-12-04	ABCO-DELISTED	Stock	40.96	41.14	39.66	39.66	295335.0
2014-12-04	ABCW-DELISTED	Stock	30.82	31.77	30.38	30.73	2300.0
2014-12-04	ABDC-DELISTED	Stock	12.72	12.78	12.5	12.6	49217.0
2014-12-04	ABE-DELISTED	Stock	14.04	14.14	13.855	14.0	8268.0
2014-12-04	ABEV	Stock	6.08	6.1	5.99	6.05	15453400.0
2014-12-04	ABG	Stock	76.76	77.8	76.25	77.2	258300.0
2014-12-04	ABGB-DELISTED	Stock	12.68	12.939	12.6	12.78	292809.0
2014-12-04	ABM	Stock	27.31	27.44	27.05	27.19	251100.0
2014-12-04	ABMD-DELISTED	Stock	35.5	35.84	35.25	35.65	446728.0
2014-12-04	ABR	Stock	6.85	6.89	6.8	6.83	99700.0

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

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