PREVIEW / stock_daily / 2014-11-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-11-07.parquet
  size:    222 KB
  rows:    6,633
  symbols: 3,558

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-11-07	AAPL	Stock	27.1875	27.33	27.1375	27.2525	134766000.0
2014-11-07	MSFT	Stock	48.92	48.92	48.29	48.68	28000600.0
2014-11-07	NVDA	Stock	0.5112	0.5173	0.4898	0.4948	450800000.0
2014-11-07	AMZN	Stock	14.891	14.9995	14.8145	14.993	52948000.0
2014-11-07	GOOGL	Stock	27.78	27.78	27.4675	27.591	31782620.0
2014-11-07	META	Stock	75.39	75.86	75.02	75.6	20774000.0
2014-11-07	TSLA	Stock	16.146	16.1893	15.8133	16.0133	77415000.0
2014-11-07	TLT	Stock	118.72	119.75	118.68	119.75	8550548.0
2014-11-07	ES	Stock	49.69	50.7	49.64	50.7	2397900.0
2014-11-07	CL	Stock	68.08	68.2	67.55	68.05	1892500.0
2014-11-07	A	Stock	41.39	41.48	40.86	40.93	2458700.0
2014-11-07	AA.B-DELISTED	Stock	51.24	51.55	50.97	51.02	36447.0
2014-11-07	AABA-DELISTED	Stock	47.87	48.67	47.86	48.55	22475023.0
2014-11-07	AAC-DELISTED	Stock	23.49	26.5	23.49	25.47	119523.0
2014-11-07	AACG	Stock	4.02	4.13	4.02	4.13	2200.0
2014-11-07	AAIC-DELISTED	Stock	27.4	27.6	27.29	27.55	225001.0
2014-11-07	AAL	Stock	43.14	43.49	42.63	43.2	9022600.0
2014-11-07	AAMC-DELISTED	Stock	150.5883	154.1147	148.5118	154.1147	11720.0
2014-11-07	AAMI	Stock	15.5	15.78	15.36	15.67	265400.0
2014-11-07	AAOI	Stock	15.93	16.28	15.43	15.73	286600.0
2014-11-07	AAON	Stock	13.9533	13.98	13.7067	13.8733	288450.0
2014-11-07	AAP	Stock	145.88	146.57	141.3	141.85	1321000.0
2014-11-07	AAT	Stock	38.4	38.56	38.05	38.38	169500.0
2014-11-07	AAU-DELISTED	Stock	1.02	1.06	0.98	1.05	242598.0
2014-11-07	AAUAF-DELISTED	Stock	1.04	1.08	1.0	1.05	239979.0
2014-11-07	AAV-DELISTED	Stock	4.57	4.8	4.57	4.78	204313.0
2014-11-07	AAVL-DELISTED	Stock	34.6	35.02	33.02	34.97	54771.0
2014-11-07	AAWW-DELISTED	Stock	41.44	42.38	40.035	41.69	484627.0
2014-11-07	AAXJ	Stock	61.87	62.1	61.76	62.07	1004352.0
2014-11-07	AAXN-DELISTED	Stock	18.53	18.53	17.73	18.51	2507367.0
2014-11-07	AB	Stock	25.54	26.25	25.52	26.25	361800.0
2014-11-07	ABAC-DELISTED	Stock	2.25	2.25	2.09	2.1899	83821.0
2014-11-07	ABAX-DELISTED	Stock	53.9	54.0575	51.52	51.58	218169.0
2014-11-07	ABB-DELISTED	Stock	22.12	22.2	22.0698	22.15	1121835.0
2014-11-07	ABBNY-DELISTED	Stock	22.12	22.2	22.0698	22.15	1316831.0
2014-11-07	ABBV	Stock	62.31	62.33	61.31	61.5	7002600.0
2014-11-07	ABC-DELISTED	Stock	87.8	87.8	86.485	86.7	1712520.0
2014-11-07	ABCB	Stock	24.75	25.33	24.67	25.26	108300.0
2014-11-07	ABCD-DELISTED	Stock	1.47	1.64	1.47	1.63	148956.0
2014-11-07	ABCO-DELISTED	Stock	45.97	49.62	45.0	48.46	1115400.0
2014-11-07	ABCW-DELISTED	Stock	31.15	31.25	31.0	31.25	3637.0
2014-11-07	ABDC-DELISTED	Stock	13.04	13.04	12.62	12.75	65857.0
2014-11-07	ABE-DELISTED	Stock	13.96	13.97	13.9	13.91	5530.0
2014-11-07	ABEO	Stock	219.0	241.25	219.0	241.25	12.0
2014-11-07	ABEV	Stock	6.4	6.5	6.36	6.42	12666500.0
2014-11-07	ABG	Stock	72.67	74.0	72.5	73.63	554600.0
2014-11-07	ABGB-DELISTED	Stock	18.42	18.49	18.2	18.49	9210.0
2014-11-07	ABM	Stock	27.33	27.33	27.16	27.24	161500.0
2014-11-07	ABMD-DELISTED	Stock	31.66	32.49	31.38	32.15	202200.0
2014-11-07	ABR	Stock	6.71	6.95	6.62	6.88	79100.0

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

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