PREVIEW / stock_daily / 2011-06-15

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-15.parquet
  size:    198 KB
  rows:    6,135
  symbols: 3,577

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
2011-06-15	AAPL	Stock	11.7768	11.7964	11.6029	11.6696	399196000.0
2011-06-15	MSFT	Stock	24.0	24.01	23.67	23.74	49410200.0
2011-06-15	NVDA	Stock	0.4228	0.4253	0.4105	0.4192	935916000.0
2011-06-15	AMZN	Stock	9.402	9.6225	9.265	9.299	126354000.0
2011-06-15	TSLA	Stock	1.896	1.8967	1.8047	1.8213	20175000.0
2011-06-15	TLT	Stock	95.38	96.94	95.37	96.92	12979052.0
2011-06-15	ES	Stock	33.86	34.08	33.68	33.9	1893300.0
2011-06-15	CL	Stock	43.085	43.37	42.725	42.88	5845800.0
2011-06-15	A	Stock	34.6638	34.6638	33.7911	33.8841	4896495.0
2011-06-15	AABA-DELISTED	Stock	15.02	15.05	14.5	14.82	39850728.0
2011-06-15	AACC-DELISTED	Stock	3.3	3.449	3.16	3.19	132228.0
2011-06-15	AACG	Stock	10.66	10.91	10.51	10.54	10500.0
2011-06-15	AAIC-DELISTED	Stock	28.51	29.08	28.31	28.99	50182.0
2011-06-15	AAME	Stock	1.97	2.04	1.97	2.04	1300.0
2011-06-15	AAON	Stock	6.2252	6.3793	6.2252	6.3259	157275.0
2011-06-15	AAP	Stock	57.02	58.19	56.81	57.44	1867600.0
2011-06-15	AAT	Stock	21.55	21.81	21.39	21.57	201700.0
2011-06-15	AATI-DELISTED	Stock	6.04	6.05	6.04	6.05	509271.0
2011-06-15	AAU-DELISTED	Stock	3.1	3.15	2.98	3.08	267523.0
2011-06-15	AAUAF-DELISTED	Stock	3.1	3.15	2.98	3.08	268873.0
2011-06-15	AAV-DELISTED	Stock	7.97	8.07	7.82	7.91	268259.0
2011-06-15	AAWW-DELISTED	Stock	56.87	57.63	56.28	56.46	207915.0
2011-06-15	AAXJ	Stock	61.01	61.15	60.36	60.56	523432.0
2011-06-15	AAXN-DELISTED	Stock	4.3	4.37	4.23	4.23	364449.0
2011-06-15	AB	Stock	19.31	19.48	19.12	19.13	353200.0
2011-06-15	ABAC-DELISTED	Stock	2.1	2.16	2.07	2.11	28170.0
2011-06-15	ABAX-DELISTED	Stock	27.9	28.3	27.71	28.1	99424.0
2011-06-15	ABB-DELISTED	Stock	25.41	25.68	25.06	25.18	4507050.0
2011-06-15	ABBC-DELISTED	Stock	10.37	10.38	10.17	10.26	34532.0
2011-06-15	ABBNY-DELISTED	Stock	25.41	25.68	25.06	25.19	4611664.0
2011-06-15	ABC-DELISTED	Stock	41.05	41.43	40.91	41.04	2182158.0
2011-06-15	ABCB	Stock	8.55	8.65	8.55	8.58	38500.0
2011-06-15	ABCD-DELISTED	Stock	3.14	3.18	3.08	3.15	17029.0
2011-06-15	ABCO-DELISTED	Stock	24.24	24.77	23.88	24.4	141368.0
2011-06-15	ABCW-DELISTED	Stock	0.67	0.78	0.65	0.78	88850.0
2011-06-15	ABD-DELISTED	Stock	7.49	7.6	7.33	7.37	422020.0
2011-06-15	ABE-DELISTED	Stock	18.5	18.85	18.34	18.4	20721.0
2011-06-15	ABEO	Stock	2250.0	2462.5	2187.5	2237.5	71.0
2011-06-15	ABFS-DELISTED	Stock	22.1	22.35	21.78	21.89	330111.0
2011-06-15	ABG	Stock	15.62	15.77	15.16	15.43	262200.0
2011-06-15	ABH-DELISTED	Stock	22.58	22.64	21.75	21.81	771111.0
2011-06-15	ABM	Stock	22.17	22.25	21.94	22.17	333000.0
2011-06-15	ABMD-DELISTED	Stock	16.31	16.51	15.89	15.97	109794.0
2011-06-15	ABR	Stock	4.2	4.51	4.2	4.46	159700.0
2011-06-15	ABT	Stock	24.5322	24.7865	24.489	24.6185	14045436.0
2011-06-15	ABTL-DELISTED	Stock	5.049	5.251	4.8471	5.15	76210.0
2011-06-15	ABUS	Stock	2.8	2.97	2.75	2.82	6600.0
2011-06-15	ABV-DELISTED	Stock	31.64	31.8	31.31	31.46	1400451.0
2011-06-15	ABVA-DELISTED	Stock	5.02	5.1001	4.85	4.85	4296.0
2011-06-15	ABVT-DELISTED	Stock	73.01	73.19	70.87	71.58	450228.0

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

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