PREVIEW / stock_daily / 2013-11-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-11-20.parquet
  size:    215 KB
  rows:    6,443
  symbols: 3,547

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-20	AAPL	Stock	18.5439	18.5864	18.3689	18.3929	193916800.0
2013-11-20	MSFT	Stock	36.92	37.41	36.86	37.08	32229900.0
2013-11-20	NVDA	Stock	0.3862	0.3873	0.3795	0.3803	204776000.0
2013-11-20	AMZN	Stock	18.378	18.378	18.0225	18.1285	35430000.0
2013-11-20	META	Stock	46.61	47.55	46.31	46.43	53933000.0
2013-11-20	TSLA	Stock	8.4053	8.4967	7.9373	8.074	207744000.0
2013-11-20	TLT	Stock	104.42	104.84	102.648	102.78	14191987.0
2013-11-20	ES	Stock	42.48	42.49	41.8	42.04	2288100.0
2013-11-20	CL	Stock	65.44	65.75	65.04	65.26	2202300.0
2013-11-20	A	Stock	38.505	38.8126	38.2475	38.2904	3245457.0
2013-11-20	AABA-DELISTED	Stock	35.43	36.22	35.22	35.61	31801348.0
2013-11-20	AACG	Stock	4.15	4.15	4.01	4.01	14100.0
2013-11-20	AAIC-DELISTED	Stock	25.59	25.9	25.39	25.43	115583.0
2013-11-20	AAMC-DELISTED	Stock	183.8235	206.4676	183.8235	206.4676	15093.0
2013-11-20	AAME	Stock	4.05	4.05	4.04	4.05	6400.0
2013-11-20	AAMRQ-DELISTED	Stock	12.215	12.36	11.9	12.05	7903474.0
2013-11-20	AAOI	Stock	12.49	12.57	12.31	12.5	22000.0
2013-11-20	AAON	Stock	12.2622	12.5822	12.2622	12.5644	168300.0
2013-11-20	AAP	Stock	97.81	98.38	96.76	97.67	308800.0
2013-11-20	AAT	Stock	31.82	32.15	31.35	31.49	141600.0
2013-11-20	AAU-DELISTED	Stock	1.13	1.14	1.09	1.12	142966.0
2013-11-20	AAUAF-DELISTED	Stock	1.15	1.16	1.11	1.12	142092.0
2013-11-20	AAV-DELISTED	Stock	3.92	3.94	3.88	3.91	82195.0
2013-11-20	AAWW-DELISTED	Stock	37.3	37.82	36.24	36.41	631962.0
2013-11-20	AAXJ	Stock	60.69	60.89	60.11	60.17	688679.0
2013-11-20	AAXN-DELISTED	Stock	16.82	17.2399	16.672	16.8	870505.0
2013-11-20	AB	Stock	21.45	21.76	21.4	21.56	211600.0
2013-11-20	ABAC-DELISTED	Stock	1.68	1.8446	1.67	1.73	98835.0
2013-11-20	ABAX-DELISTED	Stock	35.32	35.98	35.0	35.46	225261.0
2013-11-20	ABB-DELISTED	Stock	25.24	25.31	24.9301	25.04	1026543.0
2013-11-20	ABBNY-DELISTED	Stock	25.24	25.31	24.9301	25.04	1068048.0
2013-11-20	ABBV	Stock	48.42	48.54	47.83	47.95	3120300.0
2013-11-20	ABC-DELISTED	Stock	68.88	69.62	68.8	69.36	1270238.0
2013-11-20	ABCB	Stock	19.17	19.4	17.8	19.17	77200.0
2013-11-20	ABCD-DELISTED	Stock	1.45	1.45	1.3999	1.43	36441.0
2013-11-20	ABCO-DELISTED	Stock	61.22	61.37	60.02	60.46	153578.0
2013-11-20	ABE-DELISTED	Stock	20.0	20.0	19.75	19.75	5500.0
2013-11-20	ABEO	Stock	375.0	375.0	350.0	375.0	28.0
2013-11-20	ABEV	Stock	7.57	7.73	7.53	7.59	5268500.0
2013-11-20	ABFS-DELISTED	Stock	32.52	32.52	31.29	31.73	249661.0
2013-11-20	ABG	Stock	49.33	50.65	49.0	50.16	197300.0
2013-11-20	ABGB-DELISTED	Stock	10.1	10.55	10.04	10.43	394143.0
2013-11-20	ABM	Stock	27.59	27.63	27.39	27.49	95600.0
2013-11-20	ABMD-DELISTED	Stock	27.26	27.5	27.03	27.28	277280.0
2013-11-20	ABR	Stock	6.62	6.66	6.46	6.56	79500.0
2013-11-20	ABR.A-DELISTED	Stock	24.57	24.59	24.5	24.51	3000.0
2013-11-20	ABR.B-DELISTED	Stock	22.56	22.95	22.56	22.95	3305.0
2013-11-20	ABT	Stock	38.75	38.81	37.91	38.18	6413400.0
2013-11-20	ABTL-DELISTED	Stock	10.01	10.25	9.904	9.95	97269.0
2013-11-20	ABUS	Stock	7.81	7.91	7.75	7.83	67400.0

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

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