PREVIEW / stock_daily / 2014-05-07

all stock daily files

  file:    by_date/stock_daily/2014/2014-05-07.parquet
  size:    218 KB
  rows:    6,530
  symbols: 3,555

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-07	AAPL	Stock	21.2589	21.3318	20.9904	21.1546	282864400.0
2014-05-07	MSFT	Stock	39.22	39.51	38.51	39.42	41744500.0
2014-05-07	NVDA	Stock	0.4562	0.4605	0.4518	0.4568	293900000.0
2014-05-07	AMZN	Stock	14.778	14.82	14.334	14.6355	140304000.0
2014-05-07	GOOGL	Stock	26.1625	26.2215	25.5545	25.9	61486920.0
2014-05-07	META	Stock	58.77	59.3	56.26	57.39	78587000.0
2014-05-07	TSLA	Stock	13.976	14.0133	13.15	13.4233	152689500.0
2014-05-07	TLT	Stock	112.31	112.57	111.94	112.08	8199164.0
2014-05-07	ES	Stock	46.51	47.07	46.43	47.0	1789500.0
2014-05-07	CL	Stock	66.76	67.4	66.76	67.23	2191000.0
2014-05-07	A	Stock	39.4349	39.4349	38.8197	39.3634	3102442.0
2014-05-07	AABA-DELISTED	Stock	35.97	35.99	33.67	34.06	64253233.0
2014-05-07	AACG	Stock	4.26	4.36	4.25	4.26	3700.0
2014-05-07	AAIC-DELISTED	Stock	25.95	26.37	25.94	26.36	231554.0
2014-05-07	AAL	Stock	36.53	37.31	36.31	37.22	7800000.0
2014-05-07	AAMC-DELISTED	Stock	257.3529	259.1176	245.6794	248.8971	64335.0
2014-05-07	AAME	Stock	3.46	3.49	3.3	3.48	8100.0
2014-05-07	AAOI	Stock	21.05	21.05	19.51	20.0	307500.0
2014-05-07	AAON	Stock	13.7289	13.7289	13.2933	13.6489	303075.0
2014-05-07	AAP	Stock	120.64	121.25	118.51	119.45	555900.0
2014-05-07	AAT	Stock	34.07	34.55	33.82	34.48	171600.0
2014-05-07	AAU-DELISTED	Stock	1.38	1.39	1.3	1.3	52545.0
2014-05-07	AAUAF-DELISTED	Stock	1.36	1.37	1.3	1.32	54540.0
2014-05-07	AAV-DELISTED	Stock	6.37	6.4	6.26	6.32	308086.0
2014-05-07	AAWW-DELISTED	Stock	36.58	36.5999	36.0	36.33	252622.0
2014-05-07	AAXJ	Stock	59.44	59.59	59.18	59.58	240084.0
2014-05-07	AAXN-DELISTED	Stock	13.2	13.39	12.55	13.12	2453664.0
2014-05-07	AB	Stock	24.49	24.7	24.28	24.42	310700.0
2014-05-07	ABAC-DELISTED	Stock	1.9701	2.05	1.9701	2.05	13260.0
2014-05-07	ABAX-DELISTED	Stock	40.25	40.29	39.21	40.25	59133.0
2014-05-07	ABB-DELISTED	Stock	23.4	23.45	23.16	23.3499	3804064.0
2014-05-07	ABBNY-DELISTED	Stock	23.4	23.45	23.16	23.34	3862922.0
2014-05-07	ABBV	Stock	52.38	52.87	51.27	52.79	7022600.0
2014-05-07	ABC-DELISTED	Stock	64.87	64.96	64.26	64.55	1755904.0
2014-05-07	ABCB	Stock	20.15	20.51	19.87	20.22	164800.0
2014-05-07	ABCD-DELISTED	Stock	2.14	2.25	2.13	2.2	33831.0
2014-05-07	ABCO-DELISTED	Stock	55.68	55.98	52.24	52.29	393057.0
2014-05-07	ABE-DELISTED	Stock	13.65	13.65	13.59	13.649	3393.0
2014-05-07	ABEO	Stock	562.5	562.5	537.5	562.5	4.0
2014-05-07	ABEV	Stock	7.35	7.38	7.21	7.28	12376000.0
2014-05-07	ABG	Stock	61.77	62.01	60.17	61.22	264300.0
2014-05-07	ABGB-DELISTED	Stock	22.93	23.0	22.715	22.96	15848.0
2014-05-07	ABIL-DELISTED	Stock	9.7	9.72	9.6905	9.72	1302.0
2014-05-07	ABM	Stock	26.79	27.0	26.38	26.9	187600.0
2014-05-07	ABMD-DELISTED	Stock	21.96	22.15	21.07	21.47	330759.0
2014-05-07	ABR	Stock	7.05	7.08	7.01	7.07	49400.0
2014-05-07	ABR.A-DELISTED	Stock	25.36	25.39	25.14	25.16	7500.0
2014-05-07	ABR.B-DELISTED	Stock	24.1	24.1	23.8499	23.92	27118.0
2014-05-07	ABR.C-DELISTED	Stock	25.35	25.35	25.2499	25.26	21770.0
2014-05-07	ABT	Stock	38.65	38.79	38.29	38.69	4990200.0

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

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