PREVIEW / stock_daily / 2012-01-12

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-12.parquet
  size:    196 KB
  rows:    6,138
  symbols: 3,551

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
2012-01-12	AAPL	Stock	15.0814	15.1036	14.9554	15.0496	212587200.0
2012-01-12	MSFT	Stock	27.87	28.02	27.65	28.0	49370800.0
2012-01-12	NVDA	Stock	0.3555	0.3558	0.3448	0.3525	652364000.0
2012-01-12	AMZN	Stock	8.971	8.9745	8.7875	8.7965	107716000.0
2012-01-12	TSLA	Stock	1.8987	1.908	1.854	1.8833	10939500.0
2012-01-12	TLT	Stock	119.95	120.19	119.24	119.69	7205319.0
2012-01-12	ES	Stock	34.34	34.39	34.02	34.26	1054600.0
2012-01-12	CL	Stock	44.375	44.525	44.115	44.275	15039200.0
2012-01-12	A	Stock	27.9971	28.3119	27.4392	28.269	3973396.0
2012-01-12	AABA-DELISTED	Stock	15.58	15.73	15.46	15.67	12012127.0
2012-01-12	AACC-DELISTED	Stock	4.15	4.2	4.07	4.2	5799.0
2012-01-12	AACG	Stock	7.59	7.59	7.57	7.58	3300.0
2012-01-12	AAIC-DELISTED	Stock	21.11	21.6	21.005	21.35	50779.0
2012-01-12	AAME	Stock	2.03	2.04	1.99	2.0	5800.0
2012-01-12	AAMRQ-DELISTED	Stock	0.355	0.44	0.3455	0.4027	22806375.0
2012-01-12	AAON	Stock	5.9259	6.0207	5.8993	6.0059	277763.0
2012-01-12	AAP	Stock	72.3	72.3	70.94	71.65	487100.0
2012-01-12	AAT	Stock	20.8	20.8	20.09	20.43	143000.0
2012-01-12	AAU-DELISTED	Stock	2.9	2.9	2.61	2.69	142034.0
2012-01-12	AAUAF-DELISTED	Stock	2.9	2.9	2.61	2.69	142634.0
2012-01-12	AAV-DELISTED	Stock	4.03	4.05	3.83	3.85	342880.0
2012-01-12	AAWW-DELISTED	Stock	41.81	41.9	40.59	41.1	226133.0
2012-01-12	AAXJ	Stock	51.87	52.07	51.52	52.0	407666.0
2012-01-12	AAXN-DELISTED	Stock	5.16	5.23	5.11	5.22	151019.0
2012-01-12	AB	Stock	14.63	14.71	14.0	14.53	473200.0
2012-01-12	ABAC-DELISTED	Stock	1.6	1.68	1.589	1.66	57554.0
2012-01-12	ABAX-DELISTED	Stock	28.51	28.605	27.6	27.77	171490.0
2012-01-12	ABB-DELISTED	Stock	20.1	20.28	19.96	20.24	2181264.0
2012-01-12	ABBNY-DELISTED	Stock	20.1	20.28	19.96	20.23	2189865.0
2012-01-12	ABC-DELISTED	Stock	38.78	38.925	38.57	38.85	1246025.0
2012-01-12	ABCB	Stock	10.66	10.68	10.45	10.63	20600.0
2012-01-12	ABCD-DELISTED	Stock	3.2	3.24	3.091	3.2	13113.0
2012-01-12	ABCO-DELISTED	Stock	37.35	37.94	37.25	37.37	134770.0
2012-01-12	ABCW-DELISTED	Stock	0.3514	0.3615	0.3213	0.3213	19480.0
2012-01-12	ABD-DELISTED	Stock	9.45	9.54	9.29	9.42	170470.0
2012-01-12	ABE-DELISTED	Stock	18.17	18.17	17.88	18.05	5600.0
2012-01-12	ABEO	Stock	1612.5	1725.0	1612.5	1725.0	6.0
2012-01-12	ABFS-DELISTED	Stock	21.12	21.275	20.82	21.18	129550.0
2012-01-12	ABG	Stock	22.56	22.62	22.13	22.41	153100.0
2012-01-12	ABH-DELISTED	Stock	15.23	15.4	14.9308	15.38	254115.0
2012-01-12	ABM	Stock	20.86	20.99	20.61	20.95	163200.0
2012-01-12	ABMD-DELISTED	Stock	18.31	18.37	18.01	18.32	142232.0
2012-01-12	ABR	Stock	3.93	4.14	3.93	4.12	67400.0
2012-01-12	ABT	Stock	26.7009	26.8112	26.4466	26.4658	15528762.0
2012-01-12	ABTL-DELISTED	Stock	3.8652	3.9099	3.6142	3.8848	5659.0
2012-01-12	ABUS	Stock	1.8	1.95	1.8	1.95	5300.0
2012-01-12	ABV-DELISTED	Stock	35.9	36.22	35.805	35.99	2309369.0
2012-01-12	ABVA-DELISTED	Stock	3.5	3.5	3.48	3.5	1100.0
2012-01-12	ABVT-DELISTED	Stock	65.97	65.97	65.24	65.72	70258.0
2012-01-12	ABX-DELISTED	Stock	48.88	49.51	48.36	48.81	4031924.0

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

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