PREVIEW / stock_daily / 2014-06-06

all stock daily files

  file:    by_date/stock_daily/2014/2014-06-06.parquet
  size:    219 KB
  rows:    6,536
  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-06-06	AAPL	Stock	23.2107	23.2593	23.0168	23.0561	349938400.0
2014-06-06	MSFT	Stock	41.48	41.66	41.24	41.48	24060500.0
2014-06-06	NVDA	Stock	0.4763	0.48	0.4745	0.4758	161052000.0
2014-06-06	AMZN	Stock	16.25	16.544	16.2465	16.4835	104880000.0
2014-06-06	GOOGL	Stock	28.408	28.44	27.979	28.3015	34818680.0
2014-06-06	META	Stock	63.37	63.48	62.15	62.5	42442000.0
2014-06-06	TSLA	Stock	13.9833	14.054	13.812	13.878	46107000.0
2014-06-06	TLT	Stock	112.13	112.41	111.49	111.59	7832984.0
2014-06-06	ES	Stock	45.77	45.9	45.44	45.48	975600.0
2014-06-06	CL	Stock	68.05	68.2	67.86	68.02	2941800.0
2014-06-06	A	Stock	41.9027	42.4034	41.7525	42.2103	1797548.0
2014-06-06	AABA-DELISTED	Stock	35.06	36.08	35.05	35.93	16989611.0
2014-06-06	AACG	Stock	4.96	4.98	4.83	4.91	2000.0
2014-06-06	AAIC-DELISTED	Stock	27.96	28.21	27.8	27.83	416339.0
2014-06-06	AAL	Stock	42.45	43.92	42.42	43.88	13615400.0
2014-06-06	AAMC-DELISTED	Stock	312.9324	327.5235	311.3118	323.0618	49307.0
2014-06-06	AAME	Stock	3.61	3.65	3.6	3.65	4600.0
2014-06-06	AAOI	Stock	20.93	21.17	20.76	21.12	115000.0
2014-06-06	AAON	Stock	14.4311	14.7911	14.4222	14.72	283050.0
2014-06-06	AAP	Stock	127.65	128.65	127.13	128.41	493000.0
2014-06-06	AAT	Stock	35.22	35.22	34.81	34.85	142900.0
2014-06-06	AAU-DELISTED	Stock	1.32	1.33	1.3	1.31	75495.0
2014-06-06	AAUAF-DELISTED	Stock	1.32	1.33	1.3	1.31	76673.0
2014-06-06	AAV-DELISTED	Stock	6.81	6.85	6.66	6.74	440632.0
2014-06-06	AAWW-DELISTED	Stock	37.81	38.21	37.18	37.91	192183.0
2014-06-06	AAXJ	Stock	62.75	62.87	62.67	62.74	215720.0
2014-06-06	AAXN-DELISTED	Stock	13.42	13.64	13.29	13.34	439563.0
2014-06-06	AB	Stock	25.64	26.04	25.44	26.0	585500.0
2014-06-06	ABAC-DELISTED	Stock	2.13	2.15	2.1	2.15	18789.0
2014-06-06	ABAX-DELISTED	Stock	42.46	43.84	42.46	43.51	410309.0
2014-06-06	ABB-DELISTED	Stock	23.56	23.78	23.56	23.78	971331.0
2014-06-06	ABBNY-DELISTED	Stock	23.56	23.78	23.56	23.77	1007279.0
2014-06-06	ABBV	Stock	55.32	55.4	54.89	55.1	3449800.0
2014-06-06	ABC-DELISTED	Stock	72.96	72.96	72.05	72.49	2145115.0
2014-06-06	ABCB	Stock	21.68	22.0	21.33	21.88	42900.0
2014-06-06	ABCD-DELISTED	Stock	2.0941	2.181	2.08	2.08	8060.0
2014-06-06	ABCO-DELISTED	Stock	51.52	52.23	50.88	51.03	126391.0
2014-06-06	ABDC-DELISTED	Stock	14.8386	14.98	14.66	14.71	18154.0
2014-06-06	ABE-DELISTED	Stock	14.3	14.4	14.25	14.38	17461.0
2014-06-06	ABEO	Stock	425.0	437.5	412.5	437.5	38.0
2014-06-06	ABEV	Stock	7.19	7.24	7.16	7.18	7368900.0
2014-06-06	ABG	Stock	65.98	66.46	65.43	65.51	236500.0
2014-06-06	ABGB-DELISTED	Stock	26.66	27.26	26.66	27.116	15555.0
2014-06-06	ABIL-DELISTED	Stock	9.77	9.77	9.7	9.7	1555.0
2014-06-06	ABM	Stock	27.19	27.44	26.98	27.3	294300.0
2014-06-06	ABMD-DELISTED	Stock	23.51	23.51	23.04	23.38	192597.0
2014-06-06	ABR	Stock	7.22	7.28	7.22	7.25	49400.0
2014-06-06	ABR.A-DELISTED	Stock	24.24	24.25	24.2	24.21	6025.0
2014-06-06	ABR.B-DELISTED	Stock	23.73	23.74	23.65	23.65	2062.0
2014-06-06	ABR.C-DELISTED	Stock	24.96	24.96	24.95	24.95	3125.0

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

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