PREVIEW / stock_daily / 2013-07-12

all stock daily files

  file:    by_date/stock_daily/2013/2013-07-12.parquet
  size:    211 KB
  rows:    6,356
  symbols: 3,522

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
2013-07-12	AAPL	Stock	15.2732	15.3496	15.1218	15.2325	279563200.0
2013-07-12	MSFT	Stock	35.58	35.73	35.28	35.67	35501200.0
2013-07-12	NVDA	Stock	0.365	0.3695	0.3638	0.366	216360000.0
2013-07-12	AMZN	Stock	14.9345	15.3775	14.925	15.3775	90786000.0
2013-07-12	META	Stock	25.74	25.93	25.55	25.91	16537900.0
2013-07-12	TSLA	Stock	8.3667	8.6627	8.3007	8.66	170160000.0
2013-07-12	TLT	Stock	108.34	108.47	107.34	107.72	4730803.0
2013-07-12	ES	Stock	43.16	43.36	42.8	43.28	1016600.0
2013-07-12	CL	Stock	58.98	59.23	58.67	59.14	2651200.0
2013-07-12	A	Stock	32.7468	32.8684	32.6037	32.7253	2766223.0
2013-07-12	AABA-DELISTED	Stock	27.08	27.44	27.01	27.23	17038410.0
2013-07-12	AACG	Stock	4.51	4.58	4.49	4.54	3400.0
2013-07-12	AAIC-DELISTED	Stock	25.2	25.5144	25.14	25.27	153246.0
2013-07-12	AAMC-DELISTED	Stock	80.8824	80.8824	80.7353	80.7353	13219.0
2013-07-12	AAME	Stock	3.77	3.77	3.77	3.77	500.0
2013-07-12	AAMRQ-DELISTED	Stock	4.88	5.01	4.86	4.98	3709754.0
2013-07-12	AAON	Stock	10.9289	11.4844	10.8978	11.3956	216675.0
2013-07-12	AAP	Stock	82.93	83.32	82.33	82.67	505600.0
2013-07-12	AAT	Stock	33.48	33.85	33.28	33.62	92000.0
2013-07-12	AAU-DELISTED	Stock	1.46	1.5	1.44	1.46	73888.0
2013-07-12	AAUAF-DELISTED	Stock	1.46	1.5	1.441	1.46	74188.0
2013-07-12	AAV-DELISTED	Stock	4.19	4.21	4.14	4.17	69543.0
2013-07-12	AAWW-DELISTED	Stock	43.73	43.9699	43.39	43.71	240990.0
2013-07-12	AAXJ	Stock	56.12	56.12	55.76	55.94	370479.0
2013-07-12	AAXN-DELISTED	Stock	9.2	9.3	9.13	9.2	300105.0
2013-07-12	AB	Stock	20.0	20.39	19.87	20.2	483500.0
2013-07-12	ABAC-DELISTED	Stock	0.577	0.59	0.5699	0.588	9200.0
2013-07-12	ABAX-DELISTED	Stock	51.01	51.84	50.55	50.55	73321.0
2013-07-12	ABB-DELISTED	Stock	22.44	22.53	22.35	22.53	799019.0
2013-07-12	ABBNY-DELISTED	Stock	22.45	22.53	22.35	22.53	819905.0
2013-07-12	ABBV	Stock	43.93	45.11	43.8	45.05	5693900.0
2013-07-12	ABC-DELISTED	Stock	58.02	58.42	57.68	58.39	1357701.0
2013-07-12	ABCB	Stock	17.91	18.19	17.85	17.99	71200.0
2013-07-12	ABCD-DELISTED	Stock	1.22	1.31	1.22	1.3	11560.0
2013-07-12	ABCO-DELISTED	Stock	57.08	57.35	56.21	56.3	130679.0
2013-07-12	ABCW-DELISTED	Stock	0.35	0.37	0.35	0.37	64011.0
2013-07-12	ABE-DELISTED	Stock	19.6217	19.7599	19.57	19.6845	16831.0
2013-07-12	ABEO	Stock	525.0	562.5	525.0	562.5	10.0
2013-07-12	ABFS-DELISTED	Stock	22.78	23.1699	22.58	22.87	514019.0
2013-07-12	ABG	Stock	43.94	44.46	43.6	43.71	184300.0
2013-07-12	ABM	Stock	25.1	25.48	25.1	25.45	148200.0
2013-07-12	ABMD-DELISTED	Stock	22.73	23.17	22.67	23.14	160517.0
2013-07-12	ABR	Stock	6.33	6.44	6.31	6.4	51300.0
2013-07-12	ABR.A-DELISTED	Stock	25.35	25.35	25.3	25.3	900.0
2013-07-12	ABR.B-DELISTED	Stock	24.07	24.07	24.05	24.05	400.0
2013-07-12	ABT	Stock	35.45	35.57	35.11	35.32	6218100.0
2013-07-12	ABTL-DELISTED	Stock	4.98	5.05	4.87	5.04	22087.0
2013-07-12	ABUS	Stock	4.89	4.98	4.87	4.94	121500.0
2013-07-12	ABV-DELISTED	Stock	36.34	36.67	36.12	36.38	2395959.0
2013-07-12	ABX-DELISTED	Stock	15.09	15.15	14.79	14.95	14066132.0

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

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