PREVIEW / stock_daily / 2011-06-09

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-09.parquet
  size:    197 KB
  rows:    6,115
  symbols: 3,566

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-09	AAPL	Stock	11.9018	11.9168	11.8125	11.8389	275088800.0
2011-06-09	MSFT	Stock	24.01	24.04	23.82	23.96	42878700.0
2011-06-09	NVDA	Stock	0.439	0.44	0.4185	0.4342	741632000.0
2011-06-09	AMZN	Stock	9.487	9.588	9.2855	9.484	83746000.0
2011-06-09	TSLA	Stock	1.8287	1.8733	1.8067	1.8413	24048000.0
2011-06-09	TLT	Stock	97.1	97.33	95.93	96.4	9962913.0
2011-06-09	ES	Stock	34.28	34.32	34.04	34.08	1051400.0
2011-06-09	CL	Stock	42.22	42.69	42.175	42.55	4473600.0
2011-06-09	A	Stock	34.2203	35.1431	34.1273	34.8426	4587118.0
2011-06-09	AABA-DELISTED	Stock	15.18	15.33	14.94	15.22	18388213.0
2011-06-09	AACC-DELISTED	Stock	3.25	3.81	3.25	3.31	46761.0
2011-06-09	AACG	Stock	11.0	11.09	10.46	10.8	73300.0
2011-06-09	AAIC-DELISTED	Stock	28.08	29.2	27.95	28.41	104269.0
2011-06-09	AAME	Stock	2.0	2.05	1.97	2.05	9700.0
2011-06-09	AAON	Stock	6.317	6.3447	6.2479	6.2479	98719.0
2011-06-09	AAP	Stock	58.22	58.55	57.76	58.16	1171700.0
2011-06-09	AAT	Stock	21.7	21.78	21.5	21.61	142800.0
2011-06-09	AATI-DELISTED	Stock	6.05	6.06	6.04	6.05	812816.0
2011-06-09	AAU-DELISTED	Stock	3.17	3.38	3.11	3.3099	332277.0
2011-06-09	AAUAF-DELISTED	Stock	3.17	3.38	3.11	3.29	332877.0
2011-06-09	AAV-DELISTED	Stock	7.94	8.17	7.94	8.09	274932.0
2011-06-09	AAWW-DELISTED	Stock	58.67	58.86	57.75	57.83	117007.0
2011-06-09	AAXJ	Stock	61.82	62.5	61.82	62.39	482210.0
2011-06-09	AAXN-DELISTED	Stock	4.29	4.34	4.28	4.3	363250.0
2011-06-09	AB	Stock	19.2	19.61	19.19	19.45	240500.0
2011-06-09	ABAC-DELISTED	Stock	2.34	2.4	2.34	2.34	16114.0
2011-06-09	ABAX-DELISTED	Stock	28.38	29.32	28.27	28.97	61120.0
2011-06-09	ABB-DELISTED	Stock	25.73	26.07	25.71	26.01	3925687.0
2011-06-09	ABBC-DELISTED	Stock	10.56	10.67	10.48	10.49	25589.0
2011-06-09	ABBNY-DELISTED	Stock	25.73	26.07	25.71	26.02	3926387.0
2011-06-09	ABC-DELISTED	Stock	40.97	41.69	40.78	41.54	2495528.0
2011-06-09	ABCB	Stock	8.79	8.79	8.63	8.65	37400.0
2011-06-09	ABCD-DELISTED	Stock	3.2	3.2	3.08	3.16	14563.0
2011-06-09	ABCO-DELISTED	Stock	24.51	24.6	23.73	24.49	106436.0
2011-06-09	ABCW-DELISTED	Stock	0.73	0.74	0.72	0.72	6930.0
2011-06-09	ABD-DELISTED	Stock	7.23	7.41	7.23	7.3	164360.0
2011-06-09	ABE-DELISTED	Stock	18.7	18.8	18.7	18.7	2469.0
2011-06-09	ABEO	Stock	2625.0	2737.5	2587.5	2712.5	9.0
2011-06-09	ABFS-DELISTED	Stock	21.61	21.96	21.43	21.76	157595.0
2011-06-09	ABG	Stock	15.38	15.91	15.38	15.65	278200.0
2011-06-09	ABH-DELISTED	Stock	23.4	23.67	23.25	23.39	441229.0
2011-06-09	ABM	Stock	22.16	22.48	22.1	22.32	294700.0
2011-06-09	ABMD-DELISTED	Stock	17.05	17.15	16.93	17.01	83831.0
2011-06-09	ABR	Stock	5.0	5.18	4.98	5.09	60400.0
2011-06-09	ABT	Stock	24.7385	25.0024	24.6473	24.7241	14454356.0
2011-06-09	ABTL-DELISTED	Stock	5.55	5.975	5.5	5.75	62476.0
2011-06-09	ABUS	Stock	2.85	2.9	2.79	2.84	3100.0
2011-06-09	ABV-DELISTED	Stock	32.31	32.56	32.07	32.36	1447895.0
2011-06-09	ABVA-DELISTED	Stock	4.9	5.07	4.9	5.06	7332.0
2011-06-09	ABVT-DELISTED	Stock	74.0	75.22	73.03	73.11	400973.0

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

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