PREVIEW / stock_daily / 2011-05-03

all stock daily files

  file:    by_date/stock_daily/2011/2011-05-03.parquet
  size:    198 KB
  rows:    6,125
  symbols: 3,574

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-05-03	AAPL	Stock	12.4282	12.4961	12.3436	12.4357	313348000.0
2011-05-03	MSFT	Stock	25.6	25.85	25.49	25.81	71892900.0
2011-05-03	NVDA	Stock	0.4875	0.489	0.4638	0.4698	808000000.0
2011-05-03	AMZN	Stock	10.05	10.1295	9.8345	9.9225	122000000.0
2011-05-03	TSLA	Stock	1.8253	1.826	1.7667	1.7913	13708500.0
2011-05-03	TLT	Stock	93.96	94.17	93.58	94.17	6486855.0
2011-05-03	ES	Stock	35.7	35.99	35.58	35.72	987600.0
2011-05-03	CL	Stock	42.1	42.405	42.055	42.35	5027600.0
2011-05-03	A	Stock	36.1087	36.2518	35.8369	36.1946	3154307.0
2011-05-03	AABA-DELISTED	Stock	18.23	18.64	17.88	17.91	30050439.0
2011-05-03	AACC-DELISTED	Stock	5.2	5.89	5.1	5.11	17511.0
2011-05-03	AACG	Stock	8.0	8.05	7.91	8.03	114900.0
2011-05-03	AAIC-DELISTED	Stock	30.02	30.25	29.42	29.47	49014.0
2011-05-03	AAME	Stock	2.1	2.1	2.07	2.07	500.0
2011-05-03	AAON	Stock	6.4296	6.4533	6.2558	6.3407	227812.0
2011-05-03	AAP	Stock	65.09	66.13	65.05	66.06	773400.0
2011-05-03	AAT	Stock	22.12	22.25	21.96	22.02	478100.0
2011-05-03	AATI-DELISTED	Stock	4.15	4.38	3.91	3.96	335704.0
2011-05-03	AAU-DELISTED	Stock	4.28	4.4795	4.14	4.26	900548.0
2011-05-03	AAUAF-DELISTED	Stock	4.29	4.49	4.15	4.25	899708.0
2011-05-03	AAV-DELISTED	Stock	8.35	8.41	8.06	8.14	420341.0
2011-05-03	AAWW-DELISTED	Stock	65.25	65.53	62.3714	63.75	1522240.0
2011-05-03	AAXJ	Stock	64.2	64.29	63.64	63.94	479901.0
2011-05-03	AAXN-DELISTED	Stock	4.41	4.41	4.29	4.4	406158.0
2011-05-03	AB	Stock	21.83	21.83	21.1	21.32	851600.0
2011-05-03	ABAC-DELISTED	Stock	3.23	3.25	3.17	3.18	39284.0
2011-05-03	ABAX-DELISTED	Stock	28.51	28.79	28.15	28.42	114511.0
2011-05-03	ABB-DELISTED	Stock	26.52	26.71	26.38	26.48	3162407.0
2011-05-03	ABBC-DELISTED	Stock	11.9	12.07	11.82	12.02	28557.0
2011-05-03	ABBNY-DELISTED	Stock	26.52	26.71	26.38	26.49	3174079.0
2011-05-03	ABC-DELISTED	Stock	41.17	41.58	40.8	41.16	2310860.0
2011-05-03	ABCB	Stock	9.72	9.74	9.56	9.61	20000.0
2011-05-03	ABCD-DELISTED	Stock	3.31	3.31	3.26	3.28	17217.0
2011-05-03	ABCO-DELISTED	Stock	23.6	24.2	23.6	24.15	151491.0
2011-05-03	ABCW-DELISTED	Stock	0.82	0.82	0.8	0.82	55720.0
2011-05-03	ABD-DELISTED	Stock	9.77	9.88	9.588	9.63	335560.0
2011-05-03	ABE-DELISTED	Stock	19.13	19.22	19.03	19.13	58339.0
2011-05-03	ABEO	Stock	2625.0	2875.0	2625.0	2875.0	10.0
2011-05-03	ABFS-DELISTED	Stock	22.5	22.6	22.0	22.36	255138.0
2011-05-03	ABG	Stock	16.88	17.05	16.55	16.69	452600.0
2011-05-03	ABH-DELISTED	Stock	26.66	26.75	26.335	26.48	262452.0
2011-05-03	ABM	Stock	23.85	24.07	23.74	23.94	156000.0
2011-05-03	ABMD-DELISTED	Stock	17.14	17.39	16.7	16.78	171036.0
2011-05-03	ABR	Stock	5.1	5.14	4.93	5.05	106000.0
2011-05-03	ABT	Stock	25.0935	25.3814	25.0216	25.3574	21484785.0
2011-05-03	ABTL-DELISTED	Stock	7.203	7.304	6.7971	7.0	32662.0
2011-05-03	ABUS	Stock	3.12	3.12	2.92	2.97	11900.0
2011-05-03	ABV-DELISTED	Stock	32.34	32.79	31.91	31.93	2414588.0
2011-05-03	ABVA-DELISTED	Stock	6.9	6.9	6.6	6.6	32589.0
2011-05-03	ABVT-DELISTED	Stock	66.85	67.86	66.41	66.98	124443.0

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

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