PREVIEW / stock_daily / 2013-12-20

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-20.parquet
  size:    219 KB
  rows:    6,486
  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-12-20	AAPL	Stock	19.4796	19.7004	19.4579	19.6079	436413600.0
2013-12-20	MSFT	Stock	36.2	36.93	36.19	36.8	62649100.0
2013-12-20	NVDA	Stock	0.3853	0.3925	0.3842	0.3922	382080000.0
2013-12-20	AMZN	Stock	19.8275	20.236	19.789	20.11	100678000.0
2013-12-20	META	Stock	54.93	55.15	54.23	55.12	239824000.0
2013-12-20	TSLA	Stock	9.4387	9.6233	9.4387	9.5493	111189000.0
2013-12-20	TLT	Stock	103.72	104.29	103.3	104.25	12425975.0
2013-12-20	ES	Stock	41.98	42.35	41.91	42.11	2711400.0
2013-12-20	CL	Stock	64.27	65.05	64.17	64.74	4667700.0
2013-12-20	A	Stock	41.1087	41.2518	40.7082	40.7439	4129692.0
2013-12-20	AABA-DELISTED	Stock	40.39	40.6	40.11	40.15	23538421.0
2013-12-20	AACG	Stock	4.0	4.02	3.98	3.98	11900.0
2013-12-20	AAIC-DELISTED	Stock	26.3	27.0	26.29	26.9	347468.0
2013-12-20	AAL	Stock	26.16	26.49	26.14	26.33	8527700.0
2013-12-20	AAMC-DELISTED	Stock	264.7059	269.9971	253.1912	253.1912	148495.0
2013-12-20	AAME	Stock	4.04	4.08	3.84	3.84	65900.0
2013-12-20	AAOI	Stock	15.06	15.32	14.5	14.8	693700.0
2013-12-20	AAON	Stock	13.4222	14.2178	13.3556	14.0933	986625.0
2013-12-20	AAP	Stock	108.51	109.96	108.51	109.36	1013900.0
2013-12-20	AAT	Stock	31.2	31.65	31.2	31.53	294300.0
2013-12-20	AAU-DELISTED	Stock	1.06	1.1	1.0506	1.1	58414.0
2013-12-20	AAUAF-DELISTED	Stock	1.08	1.1	1.0701	1.08	57482.0
2013-12-20	AAV-DELISTED	Stock	4.34	4.47	4.31	4.4	190037.0
2013-12-20	AAWW-DELISTED	Stock	38.69	40.1	38.23	39.91	557818.0
2013-12-20	AAXJ	Stock	58.96	58.979	58.65	58.7	625492.0
2013-12-20	AAXN-DELISTED	Stock	16.22	16.43	16.09	16.21	1199586.0
2013-12-20	AB	Stock	21.41	21.64	21.24	21.5	418500.0
2013-12-20	ABAC-DELISTED	Stock	2.25	2.29	2.25	2.2701	17843.0
2013-12-20	ABAX-DELISTED	Stock	37.41	38.08	35.88	37.95	182748.0
2013-12-20	ABB-DELISTED	Stock	25.55	25.83	25.53	25.74	1648543.0
2013-12-20	ABBNY-DELISTED	Stock	25.56	25.83	25.53	25.76	3149427.0
2013-12-20	ABBV	Stock	52.77	53.01	52.29	52.59	12471800.0
2013-12-20	ABC-DELISTED	Stock	69.61	70.2399	69.5601	69.83	2039822.0
2013-12-20	ABCB	Stock	20.1	21.02	19.77	20.83	192500.0
2013-12-20	ABCD-DELISTED	Stock	1.77	1.78	1.71	1.75	6432.0
2013-12-20	ABCO-DELISTED	Stock	61.88	63.07	60.95	62.96	280972.0
2013-12-20	ABE-DELISTED	Stock	13.82	13.92	13.51	13.74	19805.0
2013-12-20	ABEO	Stock	325.0	325.0	300.0	312.5	18.0
2013-12-20	ABEV	Stock	7.11	7.14	7.03	7.12	9739800.0
2013-12-20	ABFS-DELISTED	Stock	34.3	34.49	33.73	33.82	839464.0
2013-12-20	ABG	Stock	54.69	54.85	52.93	53.02	601600.0
2013-12-20	ABGB-DELISTED	Stock	14.58	14.93	14.58	14.8	6260.0
2013-12-20	ABM	Stock	27.61	28.36	27.55	28.06	865200.0
2013-12-20	ABMD-DELISTED	Stock	26.41	27.13	26.1	27.02	687892.0
2013-12-20	ABR	Stock	6.64	6.69	6.55	6.67	194100.0
2013-12-20	ABR.A-DELISTED	Stock	24.2635	24.289	24.24	24.289	1100.0
2013-12-20	ABR.B-DELISTED	Stock	21.8	21.8	21.54	21.54	7388.0
2013-12-20	ABT	Stock	38.14	38.24	37.81	37.84	8140800.0
2013-12-20	ABTL-DELISTED	Stock	14.73	15.0	14.24	14.35	231162.0
2013-12-20	ABUS	Stock	7.74	7.8	7.56	7.75	45800.0

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

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