PREVIEW / stock_daily / 2014-03-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-24.parquet
  size:    219 KB
  rows:    6,520
  symbols: 3,557

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-03-24	AAPL	Stock	19.2293	19.3036	19.1093	19.2568	355700800.0
2014-03-24	MSFT	Stock	40.34	40.64	39.86	40.5	46098400.0
2014-03-24	NVDA	Stock	0.4638	0.4675	0.4545	0.4612	306096000.0
2014-03-24	AMZN	Stock	18.0045	18.075	17.43	17.5925	97470000.0
2014-03-24	META	Stock	67.19	67.36	63.36	64.1	85696000.0
2014-03-24	TSLA	Stock	15.3167	15.3267	14.018	14.678	169932000.0
2014-03-24	TLT	Stock	108.05	109.09	107.95	109.0	7537423.0
2014-03-24	ES	Stock	44.55	44.85	44.29	44.75	2232900.0
2014-03-24	CL	Stock	63.77	64.05	63.26	63.31	2417900.0
2014-03-24	A	Stock	40.1144	40.2217	39.0987	39.5279	2776009.0
2014-03-24	AABA-DELISTED	Stock	38.0	38.04	36.28	36.68	28430790.0
2014-03-24	AACG	Stock	4.15	4.28	4.02	4.04	69500.0
2014-03-24	AAIC-DELISTED	Stock	28.35	28.5	28.04	28.38	251373.0
2014-03-24	AAL	Stock	36.25	36.86	36.03	36.8	6514000.0
2014-03-24	AAMC-DELISTED	Stock	310.9147	317.85	310.8824	317.2941	42354.0
2014-03-24	AAME	Stock	3.71	3.75	3.71	3.73	6000.0
2014-03-24	AAOI	Stock	26.01	26.15	24.84	25.81	213300.0
2014-03-24	AAON	Stock	12.8178	12.8622	12.5778	12.7778	337050.0
2014-03-24	AAP	Stock	126.44	127.15	124.09	124.7	525600.0
2014-03-24	AAT	Stock	34.09	34.4	33.21	33.45	105500.0
2014-03-24	AAU-DELISTED	Stock	1.4	1.4513	1.36	1.36	295809.0
2014-03-24	AAUAF-DELISTED	Stock	1.4	1.43	1.34	1.36	304907.0
2014-03-24	AAV-DELISTED	Stock	4.36	4.41	4.3	4.4	146867.0
2014-03-24	AAWW-DELISTED	Stock	34.16	34.24	33.53	33.79	145526.0
2014-03-24	AAXJ	Stock	57.26	57.485	57.07	57.35	299868.0
2014-03-24	AAXN-DELISTED	Stock	18.15	18.25	17.37	17.85	1012808.0
2014-03-24	AB	Stock	25.85	26.0	24.51	25.33	526100.0
2014-03-24	ABAC-DELISTED	Stock	1.7301	1.82	1.72	1.82	6463.0
2014-03-24	ABAX-DELISTED	Stock	38.68	38.68	37.49	37.84	91329.0
2014-03-24	ABB-DELISTED	Stock	24.95	25.01	24.64	24.91	1215120.0
2014-03-24	ABBNY-DELISTED	Stock	24.95	25.01	24.64	24.91	1277916.0
2014-03-24	ABBV	Stock	53.53	53.62	51.35	51.36	10161400.0
2014-03-24	ABC-DELISTED	Stock	65.29	65.4899	63.5299	64.32	2524692.0
2014-03-24	ABCB	Stock	23.79	23.92	23.5	23.77	68600.0
2014-03-24	ABCD-DELISTED	Stock	2.1476	2.22	2.1	2.18	56213.0
2014-03-24	ABCO-DELISTED	Stock	67.48	67.91	65.05	66.18	111291.0
2014-03-24	ABE-DELISTED	Stock	12.72	12.72	12.64	12.6736	38162.0
2014-03-24	ABEO	Stock	750.0	750.0	650.0	700.0	68.0
2014-03-24	ABEV	Stock	7.17	7.22	7.12	7.16	9331800.0
2014-03-24	ABFS-DELISTED	Stock	37.29	37.43	35.0601	36.0	288132.0
2014-03-24	ABG	Stock	55.33	55.73	54.82	55.42	506900.0
2014-03-24	ABGB-DELISTED	Stock	23.72	23.72	22.298	22.37	7764.0
2014-03-24	ABIL-DELISTED	Stock	9.62	9.62	9.62	9.62	215.0
2014-03-24	ABM	Stock	29.0	29.04	28.38	28.61	324100.0
2014-03-24	ABMD-DELISTED	Stock	27.88	27.88	26.75	27.41	556159.0
2014-03-24	ABR	Stock	6.9	6.9	6.74	6.75	85200.0
2014-03-24	ABR.A-DELISTED	Stock	24.67	24.67	24.4779	24.4779	2437.0
2014-03-24	ABR.B-DELISTED	Stock	22.97	23.0	22.88	22.89	22430.0
2014-03-24	ABR.C-DELISTED	Stock	24.8499	24.85	24.75	24.85	3330.0
2014-03-24	ABT	Stock	38.66	38.66	38.13	38.43	11078000.0

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

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