PREVIEW / stock_daily / 2013-12-23

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-23.parquet
  size:    218 KB
  rows:    6,491
  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-23	AAPL	Stock	20.2857	20.3829	20.0986	20.3604	501306400.0
2013-12-23	MSFT	Stock	36.81	36.89	36.55	36.62	25128700.0
2013-12-23	NVDA	Stock	0.3945	0.3978	0.3913	0.3945	168568000.0
2013-12-23	AMZN	Stock	20.1845	20.25	19.96	20.146	53190000.0
2013-12-23	META	Stock	55.5	58.32	55.45	57.77	98297000.0
2013-12-23	TSLA	Stock	9.6567	9.7493	9.5067	9.57	80782500.0
2013-12-23	TLT	Stock	104.05	104.41	103.66	103.66	6378597.0
2013-12-23	ES	Stock	42.32	42.53	42.11	42.16	1093300.0
2013-12-23	CL	Stock	64.92	64.92	64.35	64.63	2525900.0
2013-12-23	A	Stock	41.0944	41.2446	40.8584	41.1588	2206743.0
2013-12-23	AABA-DELISTED	Stock	40.27	40.8	40.13	40.77	7126849.0
2013-12-23	AACG	Stock	4.0	4.0	3.83	3.83	17600.0
2013-12-23	AAIC-DELISTED	Stock	27.11	27.52	27.089	27.44	237393.0
2013-12-23	AAL	Stock	26.29	26.49	26.05	26.18	5401100.0
2013-12-23	AAMC-DELISTED	Stock	251.1794	256.4706	241.4588	256.4706	61125.0
2013-12-23	AAME	Stock	3.96	3.97	3.64	3.92	29700.0
2013-12-23	AAOI	Stock	14.72	15.03	14.72	14.93	32400.0
2013-12-23	AAON	Stock	14.2089	14.6267	14.1511	14.5422	266175.0
2013-12-23	AAP	Stock	109.78	110.34	109.19	109.84	620000.0
2013-12-23	AAT	Stock	31.74	31.74	31.33	31.39	184000.0
2013-12-23	AAU-DELISTED	Stock	1.05	1.1	1.04	1.06	104076.0
2013-12-23	AAUAF-DELISTED	Stock	1.07	1.1	1.06	1.06	103045.0
2013-12-23	AAV-DELISTED	Stock	4.42	4.42	4.33	4.33	84477.0
2013-12-23	AAWW-DELISTED	Stock	40.02	40.64	39.71	40.39	335254.0
2013-12-23	AAXJ	Stock	58.86	59.12	58.8	58.93	777343.0
2013-12-23	AAXN-DELISTED	Stock	16.27	16.33	15.8507	15.94	879413.0
2013-12-23	AB	Stock	21.5	21.64	21.45	21.5	405400.0
2013-12-23	ABAC-DELISTED	Stock	2.3	2.3165	2.16	2.19	52204.0
2013-12-23	ABAX-DELISTED	Stock	38.21	38.59	37.8	38.35	100721.0
2013-12-23	ABB-DELISTED	Stock	25.9194	26.18	25.9194	26.1	1337001.0
2013-12-23	ABBNY-DELISTED	Stock	25.9194	26.18	25.9194	26.1	2289511.0
2013-12-23	ABBV	Stock	52.73	52.94	52.24	52.58	4957700.0
2013-12-23	ABC-DELISTED	Stock	70.13	70.27	69.7674	70.03	1033713.0
2013-12-23	ABCB	Stock	20.91	22.48	20.91	21.07	86000.0
2013-12-23	ABCD-DELISTED	Stock	1.7	1.8	1.6	1.63	21721.0
2013-12-23	ABCO-DELISTED	Stock	63.2	63.42	62.6201	62.815	150620.0
2013-12-23	ABE-DELISTED	Stock	13.72	13.82	13.66	13.67	43792.0
2013-12-23	ABEO	Stock	312.5	325.0	287.5	325.0	63.0
2013-12-23	ABEV	Stock	7.14	7.22	7.11	7.14	5968100.0
2013-12-23	ABFS-DELISTED	Stock	34.17	34.33	33.36	33.98	311510.0
2013-12-23	ABG	Stock	53.14	53.78	52.97	53.66	181500.0
2013-12-23	ABGB-DELISTED	Stock	14.999	15.0	14.8575	14.9	4900.0
2013-12-23	ABM	Stock	28.17	28.38	28.12	28.29	197300.0
2013-12-23	ABMD-DELISTED	Stock	27.09	27.51	26.85	27.47	248422.0
2013-12-23	ABR	Stock	6.68	6.81	6.68	6.74	115300.0
2013-12-23	ABR.A-DELISTED	Stock	23.91	23.989	23.76	23.96	2815.0
2013-12-23	ABR.B-DELISTED	Stock	21.57	21.57	21.4	21.51	15310.0
2013-12-23	ABT	Stock	37.97	38.55	37.95	38.44	6313200.0
2013-12-23	ABTL-DELISTED	Stock	14.27	14.97	14.04	14.96	223154.0
2013-12-23	ABUS	Stock	7.75	8.38	7.75	8.35	171900.0

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

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