PREVIEW / stock_daily / 2011-04-27

all stock daily files

  file:    by_date/stock_daily/2011/2011-04-27.parquet
  size:    199 KB
  rows:    6,114
  symbols: 3,568

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-04-27	AAPL	Stock	12.58	12.5839	12.3964	12.5054	356213200.0
2011-04-27	MSFT	Stock	26.3	26.39	26.13	26.38	52689000.0
2011-04-27	NVDA	Stock	0.485	0.485	0.4725	0.4825	450004000.0
2011-04-27	AMZN	Stock	9.16	9.89	9.1375	9.8315	472460000.0
2011-04-27	TSLA	Stock	1.7953	1.824	1.7753	1.8053	14953500.0
2011-04-27	TLT	Stock	93.44	93.57	92.75	92.89	8869597.0
2011-04-27	ES	Stock	34.91	35.21	34.81	35.14	1134100.0
2011-04-27	CL	Stock	40.48	40.665	40.295	40.53	4868400.0
2011-04-27	A	Stock	35.3791	35.8441	35.2074	35.7868	3805076.0
2011-04-27	AABA-DELISTED	Stock	17.3	17.43	17.18	17.26	15726727.0
2011-04-27	AACC-DELISTED	Stock	5.87	5.97	5.781	5.92	18462.0
2011-04-27	AACG	Stock	7.89	7.89	7.8	7.8	7600.0
2011-04-27	AAI-DELISTED	Stock	7.46	7.53	7.45	7.51	5028372.0
2011-04-27	AAIC-DELISTED	Stock	30.89	30.945	30.007	30.74	38300.0
2011-04-27	AAME	Stock	2.0	2.06	2.0	2.06	900.0
2011-04-27	AAON	Stock	6.5185	6.5679	6.4632	6.5462	212625.0
2011-04-27	AAP	Stock	65.92	66.81	65.88	66.35	746300.0
2011-04-27	AAT	Stock	21.9	22.28	21.87	22.03	249800.0
2011-04-27	AATI-DELISTED	Stock	4.28	4.35	4.24	4.31	114161.0
2011-04-27	AAU-DELISTED	Stock	4.72	5.22	4.55	5.12	1968611.0
2011-04-27	AAUAF-DELISTED	Stock	4.72	5.22	4.55	5.12	1969411.0
2011-04-27	AAV-DELISTED	Stock	8.49	8.5299	8.4	8.52	271407.0
2011-04-27	AAWW-DELISTED	Stock	67.27	68.1	65.46	67.19	134574.0
2011-04-27	AAXJ	Stock	64.95	64.99	64.19	64.92	411271.0
2011-04-27	AAXN-DELISTED	Stock	4.4	4.47	4.32	4.46	579062.0
2011-04-27	AB	Stock	22.11	22.18	21.9	22.15	205100.0
2011-04-27	ABAC-DELISTED	Stock	3.55	3.55	3.36	3.42	28692.0
2011-04-27	ABAX-DELISTED	Stock	28.83	29.06	28.83	29.01	68276.0
2011-04-27	ABB-DELISTED	Stock	26.41	26.58	26.01	26.57	3970014.0
2011-04-27	ABBC-DELISTED	Stock	12.32	12.64	12.32	12.38	35927.0
2011-04-27	ABBNY-DELISTED	Stock	26.41	26.58	26.01	26.58	4313702.0
2011-04-27	ABC-DELISTED	Stock	41.09	42.12	41.09	42.01	3158335.0
2011-04-27	ABCB	Stock	9.88	10.05	9.84	10.0	39000.0
2011-04-27	ABCD-DELISTED	Stock	3.43	3.44	3.35	3.42	8700.0
2011-04-27	ABCO-DELISTED	Stock	23.1	23.25	22.88	23.23	84522.0
2011-04-27	ABCW-DELISTED	Stock	0.84	0.8411	0.81	0.83	36890.0
2011-04-27	ABD-DELISTED	Stock	9.62	9.92	9.3	9.89	455010.0
2011-04-27	ABE-DELISTED	Stock	19.1	19.202	19.01	19.202	7556.0
2011-04-27	ABEO	Stock	2737.5	2750.0	2537.5	2725.0	6.0
2011-04-27	ABFS-DELISTED	Stock	22.83	23.0101	22.5	22.71	883718.0
2011-04-27	ABG	Stock	16.82	17.17	16.39	16.63	808300.0
2011-04-27	ABH-DELISTED	Stock	25.55	26.42	25.51	26.25	392708.0
2011-04-27	ABM	Stock	24.0	24.17	23.94	24.14	222100.0
2011-04-27	ABMD-DELISTED	Stock	16.71	16.85	16.37	16.54	151825.0
2011-04-27	ABR	Stock	5.32	5.37	5.31	5.33	13700.0
2011-04-27	ABT	Stock	24.8344	25.0696	24.7577	25.036	14614423.0
2011-04-27	ABTL-DELISTED	Stock	6.95	7.25	6.8	7.25	58270.0
2011-04-27	ABUS	Stock	3.13	3.14	3.1	3.13	4100.0
2011-04-27	ABV-DELISTED	Stock	32.45	32.47	31.86	32.31	2496698.0
2011-04-27	ABVA-DELISTED	Stock	6.45	6.52	6.45	6.52	1946.0

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

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