PREVIEW / stock_daily / 2011-03-11

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-11.parquet
  size:    196 KB
  rows:    6,025
  symbols: 3,502

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-03-11	AAPL	Stock	12.3332	12.5829	12.3214	12.5711	471080400.0
2011-03-11	MSFT	Stock	25.41	25.85	25.36	25.68	49905800.0
2011-03-11	NVDA	Stock	0.4518	0.4638	0.4415	0.4512	1486832000.0
2011-03-11	AMZN	Stock	8.275	8.46	8.206	8.4035	92198000.0
2011-03-11	TSLA	Stock	1.59	1.6167	1.5687	1.6047	13962000.0
2011-03-11	TLT	Stock	92.04	92.08	91.33	91.55	8421153.0
2011-03-11	ES	Stock	34.48	34.72	34.07	34.55	1556100.0
2011-03-11	CL	Stock	39.295	39.705	39.2	39.59	3771200.0
2011-03-11	A	Stock	32.2389	32.5465	31.402	32.432	6208798.0
2011-03-11	AABA-DELISTED	Stock	17.0	17.54	17.0	17.42	19342366.0
2011-03-11	AACC-DELISTED	Stock	5.65	5.73	5.65	5.65	25312.0
2011-03-11	AACG	Stock	7.51	7.98	7.5	7.95	41700.0
2011-03-11	AAI-DELISTED	Stock	7.4	7.46	7.4	7.45	1022957.0
2011-03-11	AAIC-DELISTED	Stock	27.91	28.74	27.78	28.55	38584.0
2011-03-11	AAME	Stock	2.01	2.12	2.01	2.12	2200.0
2011-03-11	AAON	Stock	5.8351	5.8825	5.5447	5.6652	457144.0
2011-03-11	AAP	Stock	64.51	65.67	64.2	65.6	1065500.0
2011-03-11	AAT	Stock	20.54	21.02	20.45	20.7	52600.0
2011-03-11	AATI-DELISTED	Stock	3.85	3.89	3.76	3.82	134718.0
2011-03-11	AAU-DELISTED	Stock	3.58	3.87	3.57	3.81	254096.0
2011-03-11	AAUAF-DELISTED	Stock	3.58	3.87	3.57	3.81	254496.0
2011-03-11	AAV-DELISTED	Stock	7.84	8.15	7.83	8.05	613153.0
2011-03-11	AAWW-DELISTED	Stock	65.4	65.95	64.11	65.05	191970.0
2011-03-11	AAXJ	Stock	60.33	61.05	60.29	60.91	204677.0
2011-03-11	AAXN-DELISTED	Stock	4.06	4.2	4.03	4.15	400965.0
2011-03-11	AB	Stock	22.08	22.31	21.8	21.82	449500.0
2011-03-11	ABAC-DELISTED	Stock	4.88	4.99	4.83	4.9	48530.0
2011-03-11	ABAX-DELISTED	Stock	28.03	28.39	27.64	28.19	101439.0
2011-03-11	ABB-DELISTED	Stock	23.05	23.33	23.05	23.27	1604690.0
2011-03-11	ABBC-DELISTED	Stock	12.1	12.19	11.83	11.96	47976.0
2011-03-11	ABBNY-DELISTED	Stock	23.05	23.33	23.05	23.27	1612490.0
2011-03-11	ABC-DELISTED	Stock	37.26	37.74	36.8712	37.0	2095239.0
2011-03-11	ABCB	Stock	9.67	9.82	9.57	9.72	37600.0
2011-03-11	ABCD-DELISTED	Stock	3.39	3.47	3.3601	3.39	23886.0
2011-03-11	ABCO-DELISTED	Stock	24.13	24.37	24.03	24.2	148548.0
2011-03-11	ABCW-DELISTED	Stock	1.02	1.06	1.0	1.01	61820.0
2011-03-11	ABD-DELISTED	Stock	8.93	9.18	8.85	9.06	175520.0
2011-03-11	ABE-DELISTED	Stock	17.65	17.8515	17.6355	17.8515	17595.0
2011-03-11	ABEO	Stock	2437.5	2550.0	2425.0	2500.0	7.0
2011-03-11	ABFS-DELISTED	Stock	24.49	24.8387	24.25	24.25	135225.0
2011-03-11	ABG	Stock	18.77	19.32	18.6	19.16	207400.0
2011-03-11	ABH-DELISTED	Stock	26.82	27.39	26.53	27.09	709020.0
2011-03-11	ABM	Stock	24.64	24.85	24.43	24.54	431000.0
2011-03-11	ABMD-DELISTED	Stock	13.95	14.1	13.918	14.03	200950.0
2011-03-11	ABR	Stock	5.67	5.98	5.67	5.9	71200.0
2011-03-11	ABT	Stock	23.1887	23.3903	23.0448	23.2511	14923927.0
2011-03-11	ABTL-DELISTED	Stock	6.0	6.25	5.6	6.2	120834.0
2011-03-11	ABUS	Stock	5.0	5.0	4.87	4.87	1400.0
2011-03-11	ABV-DELISTED	Stock	27.38	27.79	27.36	27.75	1768990.0
2011-03-11	ABVA-DELISTED	Stock	4.65	4.76	4.65	4.76	5100.0

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

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