PREVIEW / stock_daily / 2013-11-05

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-05.parquet
  size:    215 KB
  rows:    6,444
  symbols: 3,553

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-11-05	AAPL	Stock	18.735	18.8889	18.6786	18.7661	265213200.0
2013-11-05	MSFT	Stock	35.79	36.71	35.77	36.64	51681900.0
2013-11-05	NVDA	Stock	0.3682	0.3718	0.3642	0.37	422368000.0
2013-11-05	AMZN	Stock	17.839	18.0085	17.742	17.9445	40142000.0
2013-11-05	META	Stock	47.79	50.18	47.51	50.11	76835000.0
2013-11-05	TSLA	Stock	12.0	12.0953	11.424	11.7873	337006500.0
2013-11-05	TLT	Stock	105.79	105.83	104.99	105.02	8754722.0
2013-11-05	ES	Stock	42.63	43.02	42.43	42.46	1353800.0
2013-11-05	CL	Stock	65.55	65.76	65.05	65.36	3571100.0
2013-11-05	A	Stock	36.6094	36.7382	36.3734	36.6309	2206184.0
2013-11-05	AABA-DELISTED	Stock	33.06	33.08	32.545	32.97	13100420.0
2013-11-05	AACG	Stock	4.15	4.17	4.1	4.1	8000.0
2013-11-05	AAIC-DELISTED	Stock	24.54	24.715	24.32	24.61	94350.0
2013-11-05	AAMC-DELISTED	Stock	187.2965	187.2965	187.2965	187.2965	343.0
2013-11-05	AAME	Stock	4.05	4.06	4.05	4.05	5100.0
2013-11-05	AAMRQ-DELISTED	Stock	9.82	9.84	9.51	9.68	15685188.0
2013-11-05	AAOI	Stock	12.85	13.0	12.75	13.0	29200.0
2013-11-05	AAON	Stock	12.1067	12.8178	12.0267	12.72	210375.0
2013-11-05	AAP	Stock	99.27	100.28	98.52	99.26	618500.0
2013-11-05	AAT	Stock	33.36	33.45	32.98	33.23	112000.0
2013-11-05	AAU-DELISTED	Stock	1.28	1.3	1.275	1.28	71390.0
2013-11-05	AAUAF-DELISTED	Stock	1.29	1.3	1.28	1.28	71412.0
2013-11-05	AAV-DELISTED	Stock	3.86	3.92	3.86	3.91	177378.0
2013-11-05	AAWW-DELISTED	Stock	38.65	38.91	37.76	38.44	573639.0
2013-11-05	AAXJ	Stock	59.98	59.98	59.575	59.77	1851101.0
2013-11-05	AAXN-DELISTED	Stock	17.36	17.81	17.26	17.6	1313329.0
2013-11-05	AB	Stock	22.4	22.5	21.82	22.08	306900.0
2013-11-05	ABAC-DELISTED	Stock	1.6	1.6692	1.6	1.6	61578.0
2013-11-05	ABAX-DELISTED	Stock	36.01	36.01	34.89	35.24	92581.0
2013-11-05	ABB-DELISTED	Stock	25.04	25.16	24.95	25.1	1130484.0
2013-11-05	ABBNY-DELISTED	Stock	25.05	25.16	24.95	25.09	1159586.0
2013-11-05	ABBV	Stock	48.59	48.76	48.03	48.17	4095400.0
2013-11-05	ABC-DELISTED	Stock	67.09	67.79	66.795	66.86	1806277.0
2013-11-05	ABCB	Stock	17.79	18.49	17.67	18.3	97100.0
2013-11-05	ABCD-DELISTED	Stock	1.35	1.36	1.32	1.32	14686.0
2013-11-05	ABCO-DELISTED	Stock	69.0	69.0	64.71	65.83	578618.0
2013-11-05	ABE-DELISTED	Stock	20.03	20.13	19.69	20.1001	42076.0
2013-11-05	ABEO	Stock	400.0	425.0	400.0	425.0	51.0
2013-11-05	ABFS-DELISTED	Stock	28.15	28.2475	27.36	28.03	439489.0
2013-11-05	ABG	Stock	49.63	49.96	48.88	49.67	303300.0
2013-11-05	ABGB-DELISTED	Stock	11.49	11.82	11.36	11.6713	62063.0
2013-11-05	ABM	Stock	27.59	27.94	27.5	27.69	240000.0
2013-11-05	ABMD-DELISTED	Stock	24.86	24.97	24.11	24.45	450069.0
2013-11-05	ABR	Stock	6.6	6.65	6.57	6.58	95300.0
2013-11-05	ABR.A-DELISTED	Stock	25.179	25.179	25.049	25.05	1370.0
2013-11-05	ABR.B-DELISTED	Stock	23.5	23.5	23.49	23.49	5670.0
2013-11-05	ABT	Stock	36.85	37.43	36.67	37.36	9035800.0
2013-11-05	ABTL-DELISTED	Stock	8.64	8.889	8.301	8.38	90440.0
2013-11-05	ABUS	Stock	8.94	9.03	8.6	8.79	51100.0
2013-11-05	ABV-DELISTED	Stock	36.33	36.38	35.72	35.96	3085089.0

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

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