PREVIEW / stock_daily / 2013-05-22

all stock daily files

  file:    by_date/stock_daily/2013/2013-05-22.parquet
  size:    211 KB
  rows:    6,339
  symbols: 3,534

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
2013-05-22	AAPL	Stock	15.8589	16.0125	15.6507	15.7625	443038400.0
2013-05-22	MSFT	Stock	34.79	34.84	34.36	34.61	66047500.0
2013-05-22	NVDA	Stock	0.3745	0.3745	0.3585	0.36	480404000.0
2013-05-22	AMZN	Stock	13.3695	13.3795	13.04	13.148	66640000.0
2013-05-22	META	Stock	25.65	25.85	24.92	25.16	45314500.0
2013-05-22	TSLA	Stock	5.758	6.064	5.7	5.816	128520000.0
2013-05-22	TLT	Stock	118.02	118.55	115.8	116.09	18361834.0
2013-05-22	ES	Stock	44.53	45.09	43.75	43.94	1275400.0
2013-05-22	CL	Stock	61.5	62.13	61.22	61.41	3059500.0
2013-05-22	A	Stock	33.4192	33.9557	32.9542	33.0758	7579117.0
2013-05-22	AABA-DELISTED	Stock	27.07	27.19	26.44	26.54	15594613.0
2013-05-22	AACC-DELISTED	Stock	6.65	6.71	6.61	6.635	227524.0
2013-05-22	AACG	Stock	4.01	4.05	4.01	4.05	200.0
2013-05-22	AAIC-DELISTED	Stock	29.22	29.65	28.31	28.53	261296.0
2013-05-22	AAMC-DELISTED	Stock	97.0559	97.0559	94.7059	95.8824	106406.0
2013-05-22	AAME	Stock	3.59	3.75	3.57	3.62	32200.0
2013-05-22	AAMRQ-DELISTED	Stock	5.24	5.93	5.18	5.55	9579296.0
2013-05-22	AAON	Stock	9.6711	9.9585	9.6711	9.843	216000.0
2013-05-22	AAP	Stock	87.25	87.33	85.55	85.8	516900.0
2013-05-22	AAT	Stock	35.36	35.36	34.04	34.19	188100.0
2013-05-22	AAU-DELISTED	Stock	1.62	1.65	1.54	1.58	112030.0
2013-05-22	AAUAF-DELISTED	Stock	1.62	1.65	1.54	1.59	113516.0
2013-05-22	AAV-DELISTED	Stock	4.26	4.38	4.19	4.26	1016098.0
2013-05-22	AAWW-DELISTED	Stock	46.52	47.24	45.05	45.47	265740.0
2013-05-22	AAXJ	Stock	60.9	61.47	60.23	60.41	408199.0
2013-05-22	AAXN-DELISTED	Stock	8.94	9.09	8.51	8.54	775690.0
2013-05-22	AB	Stock	27.08	27.38	26.11	26.25	502300.0
2013-05-22	ABAC-DELISTED	Stock	0.71	0.7287	0.681	0.69	25393.0
2013-05-22	ABAX-DELISTED	Stock	44.18	44.75	42.94	43.51	167990.0
2013-05-22	ABB-DELISTED	Stock	22.55	22.73	22.09	22.23	3405656.0
2013-05-22	ABBNY-DELISTED	Stock	22.56	22.73	22.09	22.22	3533057.0
2013-05-22	ABBV	Stock	46.46	48.0	45.85	46.76	5203500.0
2013-05-22	ABC-DELISTED	Stock	54.72	55.11	54.37	54.48	2183716.0
2013-05-22	ABCB	Stock	16.42	16.79	15.75	16.06	51100.0
2013-05-22	ABCD-DELISTED	Stock	1.17	1.23	1.17	1.22	22830.0
2013-05-22	ABCO-DELISTED	Stock	51.05	51.48	49.96	50.72	300370.0
2013-05-22	ABCW-DELISTED	Stock	0.64	0.68	0.63	0.632	15616.0
2013-05-22	ABE-DELISTED	Stock	22.05	22.05	21.76	21.76	14944.0
2013-05-22	ABEO	Stock	575.0	625.0	537.5	625.0	144.0
2013-05-22	ABFS-DELISTED	Stock	18.75	18.89	17.46	17.76	585592.0
2013-05-22	ABG	Stock	41.76	42.47	40.5	41.0	245900.0
2013-05-22	ABM	Stock	23.22	23.74	23.13	23.26	219300.0
2013-05-22	ABMD-DELISTED	Stock	23.04	23.15	21.75	21.83	447994.0
2013-05-22	ABR	Stock	7.21	7.24	6.95	7.03	262100.0
2013-05-22	ABR.A-DELISTED	Stock	25.63	25.66	25.63	25.64	3150.0
2013-05-22	ABR.B-DELISTED	Stock	25.28	25.28	25.11	25.2599	4700.0
2013-05-22	ABT	Stock	37.76	38.77	37.6	37.72	9982400.0
2013-05-22	ABTL-DELISTED	Stock	4.71	5.07	4.55	4.78	204890.0
2013-05-22	ABUS	Stock	4.82	4.82	4.67	4.73	92100.0
2013-05-22	ABV-DELISTED	Stock	42.34	42.45	41.38	41.51	2075979.0

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

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