PREVIEW / stock_daily / 2011-06-17

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-17.parquet
  size:    200 KB
  rows:    6,171
  symbols: 3,594

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-17	AAPL	Stock	11.7496	11.7589	11.4057	11.4379	615020000.0
2011-06-17	MSFT	Stock	24.22	24.3	23.98	24.26	83320400.0
2011-06-17	NVDA	Stock	0.4095	0.4098	0.3828	0.3953	1467884000.0
2011-06-17	AMZN	Stock	9.3255	9.3695	9.232	9.3185	126444000.0
2011-06-17	TSLA	Stock	1.7913	1.8467	1.7427	1.7667	25710000.0
2011-06-17	TLT	Stock	96.86	97.15	96.64	96.9	9622850.0
2011-06-17	ES	Stock	34.55	34.83	34.44	34.73	2238200.0
2011-06-17	CL	Stock	43.45	44.01	43.325	43.94	8481600.0
2011-06-17	A	Stock	34.1059	34.3777	33.834	33.927	5989591.0
2011-06-17	AABA-DELISTED	Stock	14.98	14.98	14.56	14.69	22647379.0
2011-06-17	AACC-DELISTED	Stock	3.38	3.479	3.35	3.37	76464.0
2011-06-17	AACG	Stock	10.39	10.51	10.25	10.34	33800.0
2011-06-17	AAIC-DELISTED	Stock	29.01	29.2	28.87	28.91	70685.0
2011-06-17	AAME	Stock	1.99	2.05	1.95	2.05	5800.0
2011-06-17	AAON	Stock	6.5333	6.9452	6.2963	6.5422	707738.0
2011-06-17	AAP	Stock	58.67	59.5	58.05	58.12	2851100.0
2011-06-17	AAT	Stock	21.64	21.76	21.38	21.68	225200.0
2011-06-17	AATI-DELISTED	Stock	6.05	6.05	6.02	6.03	1506425.0
2011-06-17	AAU-DELISTED	Stock	2.96	3.07	2.96	3.0	219135.0
2011-06-17	AAUAF-DELISTED	Stock	2.96	3.07	2.96	3.0	221835.0
2011-06-17	AAV-DELISTED	Stock	7.78	7.84	7.55	7.59	294753.0
2011-06-17	AAWW-DELISTED	Stock	56.86	57.35	55.65	56.31	331205.0
2011-06-17	AAXJ	Stock	60.41	60.48	59.89	59.98	637139.0
2011-06-17	AAXN-DELISTED	Stock	4.29	4.33	4.17	4.24	447855.0
2011-06-17	AB	Stock	18.87	19.27	18.87	19.02	236000.0
2011-06-17	ABAC-DELISTED	Stock	2.19	2.25	2.05	2.07	22422.0
2011-06-17	ABAX-DELISTED	Stock	28.17	28.36	27.48	27.5	192163.0
2011-06-17	ABB-DELISTED	Stock	25.22	25.24	24.87	24.96	2343629.0
2011-06-17	ABBC-DELISTED	Stock	10.7	11.12	10.7	10.82	110582.0
2011-06-17	ABBNY-DELISTED	Stock	25.22	25.24	24.87	24.96	2343629.0
2011-06-17	ABC-DELISTED	Stock	41.27	41.46	40.95	41.01	2003930.0
2011-06-17	ABCB	Stock	9.2	9.27	8.92	9.09	134500.0
2011-06-17	ABCD-DELISTED	Stock	3.19	3.25	3.15	3.18	61184.0
2011-06-17	ABCO-DELISTED	Stock	25.25	26.31	25.25	25.88	230941.0
2011-06-17	ABCW-DELISTED	Stock	0.71	0.75	0.66	0.72	4670.0
2011-06-17	ABD-DELISTED	Stock	7.67	7.75	7.47	7.63	327210.0
2011-06-17	ABE-DELISTED	Stock	18.3	18.3235	18.22	18.23	8894.0
2011-06-17	ABEO	Stock	2350.0	2375.0	2150.0	2237.5	37.0
2011-06-17	ABFS-DELISTED	Stock	22.36	22.36	21.79	21.99	392329.0
2011-06-17	ABG	Stock	15.89	16.39	15.77	16.25	1645100.0
2011-06-17	ABH-DELISTED	Stock	21.72	21.97	21.25	21.45	868147.0
2011-06-17	ABM	Stock	22.3	22.71	22.22	22.62	630900.0
2011-06-17	ABMD-DELISTED	Stock	16.35	16.5	16.17	16.43	247427.0
2011-06-17	ABR	Stock	4.39	4.44	4.26	4.36	75700.0
2011-06-17	ABT	Stock	24.8536	25.0552	24.7769	24.7961	18297207.0
2011-06-17	ABTL-DELISTED	Stock	4.8598	5.2486	4.8598	5.2	16745.0
2011-06-17	ABUS	Stock	2.65	2.73	2.6	2.62	22500.0
2011-06-17	ABV-DELISTED	Stock	31.32	31.54	30.9	31.1	1968610.0
2011-06-17	ABVA-DELISTED	Stock	5.04	5.05	4.81	4.81	16781.0
2011-06-17	ABVT-DELISTED	Stock	71.74	71.93	70.01	70.41	164848.0

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

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