PREVIEW / stock_daily / 2011-09-22

all stock daily files

  file:    by_date/stock_daily/2011/2011-09-22.parquet
  size:    195 KB
  rows:    6,135
  symbols: 3,560

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-09-22	AAPL	Stock	14.3225	14.6364	14.1679	14.3507	968480800.0
2011-09-22	MSFT	Stock	25.3	25.65	24.6	25.06	96278300.0
2011-09-22	NVDA	Stock	0.3475	0.348	0.3313	0.3378	1314632000.0
2011-09-22	AMZN	Stock	11.236	11.4395	10.95	11.1615	165092000.0
2011-09-22	TSLA	Stock	1.7093	1.7407	1.6587	1.7087	11637000.0
2011-09-22	TLT	Stock	121.41	123.87	121.23	123.12	25043267.0
2011-09-22	ES	Stock	33.49	33.67	33.0	33.48	2840000.0
2011-09-22	CL	Stock	44.415	44.62	42.865	43.705	12041200.0
2011-09-22	A	Stock	22.2389	22.5966	21.9814	22.382	8830607.0
2011-09-22	AABA-DELISTED	Stock	14.2	14.25	13.69	14.0	58578400.0
2011-09-22	AACC-DELISTED	Stock	3.84	3.84	3.36	3.67	18185.0
2011-09-22	AACG	Stock	9.46	9.73	8.69	9.02	47500.0
2011-09-22	AAIC-DELISTED	Stock	24.37	25.06	24.03	24.88	62603.0
2011-09-22	AAME	Stock	1.99	2.0	1.94	2.0	600.0
2011-09-22	AAON	Stock	4.4681	4.72	4.4178	4.4681	323325.0
2011-09-22	AAP	Stock	58.56	59.94	58.02	58.67	1164000.0
2011-09-22	AAT	Stock	18.07	18.49	17.9	18.18	186600.0
2011-09-22	AATI-DELISTED	Stock	4.0	4.11	3.97	4.05	932106.0
2011-09-22	AAU-DELISTED	Stock	3.07	3.22	2.92	2.99	602002.0
2011-09-22	AAUAF-DELISTED	Stock	3.07	3.22	2.92	2.99	607202.0
2011-09-22	AAV-DELISTED	Stock	4.5	4.52	4.12	4.21	815614.0
2011-09-22	AAWW-DELISTED	Stock	36.85	36.85	33.85	36.13	1172850.0
2011-09-22	AAXJ	Stock	48.12	48.17	46.38	46.87	2170326.0
2011-09-22	AAXN-DELISTED	Stock	4.17	4.32	4.15	4.23	576061.0
2011-09-22	AB	Stock	14.52	14.52	13.66	13.89	399400.0
2011-09-22	ABAC-DELISTED	Stock	1.8	1.89	1.6	1.81	42474.0
2011-09-22	ABAX-DELISTED	Stock	23.35	24.43	23.35	24.21	163439.0
2011-09-22	ABB-DELISTED	Stock	17.11	17.17	16.59	16.76	5271688.0
2011-09-22	ABBC-DELISTED	Stock	7.23	7.4	6.98	7.1	66618.0
2011-09-22	ABBNY-DELISTED	Stock	17.11	17.17	16.59	16.77	5299452.0
2011-09-22	ABC-DELISTED	Stock	37.25	38.21	37.2	38.01	3808031.0
2011-09-22	ABCB	Stock	8.5	8.82	8.5	8.55	94300.0
2011-09-22	ABCD-DELISTED	Stock	2.89	3.17	2.89	2.98	89530.0
2011-09-22	ABCO-DELISTED	Stock	29.37	30.33	29.11	29.82	201318.0
2011-09-22	ABCW-DELISTED	Stock	0.52	0.53	0.5199	0.52	40430.0
2011-09-22	ABD-DELISTED	Stock	4.87	5.02	4.62	4.81	351640.0
2011-09-22	ABE-DELISTED	Stock	17.1	17.1	16.59	16.85	7445.0
2011-09-22	ABEO	Stock	2375.0	2500.0	2200.0	2375.0	16.0
2011-09-22	ABFS-DELISTED	Stock	17.7	17.885	16.44	16.96	620024.0
2011-09-22	ABG	Stock	16.12	17.07	15.98	16.22	612900.0
2011-09-22	ABH-DELISTED	Stock	14.99	15.34	14.415	15.0	534249.0
2011-09-22	ABM	Stock	17.77	18.32	17.75	18.08	392900.0
2011-09-22	ABMD-DELISTED	Stock	10.91	11.33	10.56	10.78	241962.0
2011-09-22	ABR	Stock	3.89	3.99	3.77	3.78	165000.0
2011-09-22	ABT	Stock	24.3546	24.465	23.966	24.3211	26280742.0
2011-09-22	ABTL-DELISTED	Stock	4.25	4.3995	4.05	4.15	23754.0
2011-09-22	ABUS	Stock	2.1	2.1	2.1	2.1	400.0
2011-09-22	ABV-DELISTED	Stock	29.85	30.76	29.2	30.15	5488650.0
2011-09-22	ABVA-DELISTED	Stock	4.82	4.82	4.79	4.79	5827.0
2011-09-22	ABVT-DELISTED	Stock	50.25	51.67	49.79	50.83	280011.0

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

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