PREVIEW / stock_daily / 2014-01-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-24.parquet
  size:    217 KB
  rows:    6,470
  symbols: 3,542

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-01-24	AAPL	Stock	19.7857	19.8436	19.4554	19.5025	429354800.0
2014-01-24	MSFT	Stock	37.45	37.55	36.53	36.81	76395500.0
2014-01-24	NVDA	Stock	0.396	0.3975	0.389	0.389	246696000.0
2014-01-24	AMZN	Stock	19.908	20.01	19.3635	19.38	89168000.0
2014-01-24	META	Stock	56.15	56.42	54.4	54.45	55200700.0
2014-01-24	TSLA	Stock	11.8567	12.032	11.5687	11.64	114964500.0
2014-01-24	TLT	Stock	107.19	107.49	106.9897	107.48	11514538.0
2014-01-24	ES	Stock	43.01	43.16	42.43	42.43	2365000.0
2014-01-24	CL	Stock	63.39	63.95	62.39	62.39	5429400.0
2014-01-24	A	Stock	42.3605	42.5322	41.2804	41.3948	3713507.0
2014-01-24	AABA-DELISTED	Stock	38.67	38.98	37.6201	37.91	25251204.0
2014-01-24	AACG	Stock	3.92	4.0	3.9	4.0	5200.0
2014-01-24	AAIC-DELISTED	Stock	26.4	26.56	26.12	26.17	158493.0
2014-01-24	AAL	Stock	31.02	31.18	29.91	30.4	13686200.0
2014-01-24	AAMC-DELISTED	Stock	311.1265	312.3471	295.8235	309.7059	113557.0
2014-01-24	AAME	Stock	3.99	4.02	3.99	4.0	2700.0
2014-01-24	AAOI	Stock	13.46	13.59	13.0	13.39	117200.0
2014-01-24	AAON	Stock	14.7067	14.8044	14.2222	14.3556	345600.0
2014-01-24	AAP	Stock	116.0	117.01	115.47	115.98	782100.0
2014-01-24	AAT	Stock	32.16	32.35	31.57	31.76	106800.0
2014-01-24	AAU-DELISTED	Stock	1.63	1.63	1.44	1.53	207656.0
2014-01-24	AAUAF-DELISTED	Stock	1.63	1.63	1.44	1.5	211883.0
2014-01-24	AAV-DELISTED	Stock	4.25	4.32	4.1946	4.31	75618.0
2014-01-24	AAWW-DELISTED	Stock	38.13	38.45	37.185	37.25	676056.0
2014-01-24	AAXJ	Stock	56.69	56.83	55.97	56.0	463183.0
2014-01-24	AAXN-DELISTED	Stock	17.35	17.52	16.6	16.75	1527121.0
2014-01-24	AB	Stock	22.5	22.53	22.1	22.13	221800.0
2014-01-24	ABAC-DELISTED	Stock	1.98	2.05	1.95	1.98	19850.0
2014-01-24	ABAX-DELISTED	Stock	43.13	43.7696	42.16	42.51	173898.0
2014-01-24	ABB-DELISTED	Stock	25.51	25.54	25.21	25.21	2433317.0
2014-01-24	ABBNY-DELISTED	Stock	25.51	25.54	25.2	25.2	2606402.0
2014-01-24	ABBV	Stock	48.42	49.1	47.77	47.79	9197900.0
2014-01-24	ABC-DELISTED	Stock	69.27	69.83	67.26	67.27	3154446.0
2014-01-24	ABCB	Stock	20.64	20.69	20.1	20.38	371900.0
2014-01-24	ABCD-DELISTED	Stock	2.07	2.07	2.01	2.06	4300.0
2014-01-24	ABCO-DELISTED	Stock	63.03	64.6599	62.29	63.9	203364.0
2014-01-24	ABE-DELISTED	Stock	13.0	13.0	12.59	12.662	11589.0
2014-01-24	ABEO	Stock	475.0	512.5	475.0	475.0	89.0
2014-01-24	ABEV	Stock	6.77	6.88	6.62	6.72	30268600.0
2014-01-24	ABFS-DELISTED	Stock	34.54	34.54	32.29	32.47	430865.0
2014-01-24	ABG	Stock	49.0	49.63	47.85	47.95	273400.0
2014-01-24	ABGB-DELISTED	Stock	16.61	16.7096	16.57	16.7096	3035.0
2014-01-24	ABM	Stock	27.89	27.95	27.29	27.4	151000.0
2014-01-24	ABMD-DELISTED	Stock	26.93	27.53	26.02	26.41	324816.0
2014-01-24	ABR	Stock	7.05	7.05	6.89	6.92	107600.0
2014-01-24	ABR.A-DELISTED	Stock	24.99	24.99	24.6945	24.9	1416.0
2014-01-24	ABR.B-DELISTED	Stock	22.8719	22.9903	22.87	22.978	9235.0
2014-01-24	ABT	Stock	37.2	37.2	36.57	36.58	9167400.0
2014-01-24	ABTL-DELISTED	Stock	17.67	17.68	16.1	16.38	314938.0
2014-01-24	ABUS	Stock	12.22	12.3	12.03	12.15	112400.0

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

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