PREVIEW / stock_daily / 2014-05-14

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-14.parquet
  size:    219 KB
  rows:    6,540
  symbols: 3,543

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-05-14	AAPL	Stock	21.1582	21.3357	21.1336	21.2096	166404000.0
2014-05-14	MSFT	Stock	40.3	40.45	40.05	40.24	18818700.0
2014-05-14	NVDA	Stock	0.4572	0.459	0.4522	0.4525	214320000.0
2014-05-14	AMZN	Stock	15.125	15.232	14.833	14.881	66466000.0
2014-05-14	GOOGL	Stock	27.091	27.091	26.6555	26.7205	25622960.0
2014-05-14	META	Stock	59.53	60.45	58.95	59.23	47429000.0
2014-05-14	TSLA	Stock	12.5967	12.8987	12.4733	12.708	81100500.0
2014-05-14	TLT	Stock	112.63	113.23	112.56	112.96	8853212.0
2014-05-14	ES	Stock	45.46	45.95	45.33	45.64	1660100.0
2014-05-14	CL	Stock	67.22	67.58	66.9	66.96	1604000.0
2014-05-14	A	Stock	40.6152	40.6223	39.8426	39.9499	3622078.0
2014-05-14	AABA-DELISTED	Stock	34.48	34.65	33.98	34.17	16440470.0
2014-05-14	AACG	Stock	4.37	4.39	4.35	4.36	5700.0
2014-05-14	AAIC-DELISTED	Stock	26.9	27.0	26.74	26.77	178731.0
2014-05-14	AAL	Stock	39.08	39.24	38.56	38.84	7987700.0
2014-05-14	AAMC-DELISTED	Stock	241.1735	247.5824	234.1206	240.9559	32310.0
2014-05-14	AAME	Stock	3.32	3.58	3.27	3.46	3900.0
2014-05-14	AAOI	Stock	17.17	17.5	16.93	17.22	179800.0
2014-05-14	AAON	Stock	13.7822	13.7822	13.3022	13.3822	230850.0
2014-05-14	AAP	Stock	123.64	124.02	122.16	123.14	1559900.0
2014-05-14	AAT	Stock	34.27	34.61	34.03	34.08	239800.0
2014-05-14	AAU-DELISTED	Stock	1.33	1.36	1.3	1.34	41591.0
2014-05-14	AAUAF-DELISTED	Stock	1.33	1.36	1.3	1.34	43855.0
2014-05-14	AAV-DELISTED	Stock	5.99	6.15	5.815	5.83	648792.0
2014-05-14	AAWW-DELISTED	Stock	37.37	37.37	36.31	36.52	218995.0
2014-05-14	AAXJ	Stock	60.83	61.22	60.83	61.01	218956.0
2014-05-14	AAXN-DELISTED	Stock	13.58	13.61	12.97	13.02	1334276.0
2014-05-14	AB	Stock	24.08	24.24	23.75	23.91	159300.0
2014-05-14	ABAC-DELISTED	Stock	2.1101	2.15	2.1001	2.1002	14523.0
2014-05-14	ABAX-DELISTED	Stock	44.34	44.68	42.72	43.69	110368.0
2014-05-14	ABB-DELISTED	Stock	23.74	23.83	23.71	23.74	1491243.0
2014-05-14	ABBNY-DELISTED	Stock	23.74	23.83	23.71	23.73	1799516.0
2014-05-14	ABBV	Stock	52.23	53.0	52.08	52.87	4878400.0
2014-05-14	ABC-DELISTED	Stock	66.86	67.42	66.7	67.31	1824039.0
2014-05-14	ABCB	Stock	20.76	20.76	20.3	20.34	148300.0
2014-05-14	ABCD-DELISTED	Stock	2.251	2.35	2.25	2.31	15481.0
2014-05-14	ABCO-DELISTED	Stock	50.08	50.48	49.09	49.3	298235.0
2014-05-14	ABDC-DELISTED	Stock	14.85	15.0	14.85	15.0	38700.0
2014-05-14	ABE-DELISTED	Stock	13.9102	13.959	13.91	13.91	5119.0
2014-05-14	ABEO	Stock	612.5	637.5	587.5	637.5	140.0
2014-05-14	ABEV	Stock	7.49	7.53	7.44	7.48	7856400.0
2014-05-14	ABG	Stock	63.41	63.75	62.8	62.94	303600.0
2014-05-14	ABGB-DELISTED	Stock	23.2	23.5	23.176	23.37	9309.0
2014-05-14	ABIL-DELISTED	Stock	9.75	9.79	9.75	9.79	11000.0
2014-05-14	ABM	Stock	27.05	27.1	26.42	26.49	167400.0
2014-05-14	ABMD-DELISTED	Stock	21.55	21.66	21.241	21.56	236912.0
2014-05-14	ABR	Stock	7.14	7.17	7.04	7.11	160600.0
2014-05-14	ABR.B-DELISTED	Stock	23.69	23.77	23.52	23.5463	9095.0
2014-05-14	ABR.C-DELISTED	Stock	24.841	24.8518	24.8	24.84	5002.0
2014-05-14	ABT	Stock	39.86	40.12	39.77	39.93	7183100.0

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

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