PREVIEW / stock_daily / 2013-12-19

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-19.parquet
  size:    216 KB
  rows:    6,451
  symbols: 3,536

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-19	AAPL	Stock	19.625	19.6429	19.4189	19.445	320308800.0
2013-12-19	MSFT	Stock	36.51	36.55	36.08	36.25	34160100.0
2013-12-19	NVDA	Stock	0.3825	0.385	0.38	0.3845	258544000.0
2013-12-19	AMZN	Stock	19.7135	19.8645	19.63	19.7595	48544000.0
2013-12-19	META	Stock	54.33	55.19	53.95	55.05	89753200.0
2013-12-19	TSLA	Stock	9.7933	9.8	9.2733	9.3813	191100000.0
2013-12-19	TLT	Stock	102.86	103.01	102.45	102.67	6708383.0
2013-12-19	ES	Stock	41.82	41.93	41.26	41.88	1665800.0
2013-12-19	CL	Stock	64.43	64.56	64.05	64.24	3558000.0
2013-12-19	A	Stock	41.1803	41.3662	40.8226	41.0443	2646694.0
2013-12-19	AABA-DELISTED	Stock	40.04	40.38	39.91	40.2	10065833.0
2013-12-19	AACG	Stock	4.0	4.01	3.98	3.99	9300.0
2013-12-19	AAIC-DELISTED	Stock	25.94	26.2125	25.91	26.11	102393.0
2013-12-19	AAL	Stock	26.09	26.49	25.82	26.12	6908800.0
2013-12-19	AAMC-DELISTED	Stock	293.5294	299.4059	248.8765	270.1559	62951.0
2013-12-19	AAME	Stock	3.98	4.05	3.98	4.01	25100.0
2013-12-19	AAOI	Stock	15.2	15.65	14.75	15.39	80800.0
2013-12-19	AAON	Stock	13.4533	13.6533	13.2444	13.4089	174150.0
2013-12-19	AAP	Stock	109.2	109.48	107.75	108.4	623500.0
2013-12-19	AAT	Stock	32.15	32.21	31.2	31.23	559600.0
2013-12-19	AAU-DELISTED	Stock	1.02	1.1	1.01	1.08	73704.0
2013-12-19	AAUAF-DELISTED	Stock	1.03	1.1	1.02	1.08	76450.0
2013-12-19	AAV-DELISTED	Stock	4.3	4.37	4.27	4.33	103348.0
2013-12-19	AAWW-DELISTED	Stock	37.86	38.74	37.85	38.46	288102.0
2013-12-19	AAXJ	Stock	58.79	58.91	58.32	58.69	1396549.0
2013-12-19	AAXN-DELISTED	Stock	16.68	16.68	16.1	16.14	707180.0
2013-12-19	AB	Stock	21.21	21.58	21.14	21.44	343600.0
2013-12-19	ABAC-DELISTED	Stock	2.23	2.31	2.2244	2.31	15613.0
2013-12-19	ABAX-DELISTED	Stock	37.31	37.96	37.0	37.25	106006.0
2013-12-19	ABB-DELISTED	Stock	25.4	25.68	25.4	25.59	2276248.0
2013-12-19	ABBNY-DELISTED	Stock	25.4	25.68	25.4	25.59	2382498.0
2013-12-19	ABBV	Stock	53.21	53.21	52.02	52.63	8383400.0
2013-12-19	ABC-DELISTED	Stock	69.37	69.75	69.17	69.64	1731381.0
2013-12-19	ABCB	Stock	20.3	20.4	19.96	20.0	43200.0
2013-12-19	ABCD-DELISTED	Stock	1.74	1.745	1.7101	1.745	1900.0
2013-12-19	ABCO-DELISTED	Stock	63.03	63.31	61.34	61.71	128426.0
2013-12-19	ABE-DELISTED	Stock	13.9	14.029	13.77	13.818	40134.0
2013-12-19	ABEO	Stock	312.5	337.5	300.0	337.5	16.0
2013-12-19	ABEV	Stock	7.14	7.23	7.02	7.12	9434100.0
2013-12-19	ABFS-DELISTED	Stock	33.54	34.41	33.51	34.13	325631.0
2013-12-19	ABG	Stock	53.45	54.83	53.25	54.79	278700.0
2013-12-19	ABGB-DELISTED	Stock	14.25	14.3701	14.25	14.3	7212.0
2013-12-19	ABM	Stock	27.59	27.99	27.43	27.5	251100.0
2013-12-19	ABMD-DELISTED	Stock	27.33	27.542	25.91	26.38	368275.0
2013-12-19	ABR	Stock	6.59	6.65	6.55	6.59	58400.0
2013-12-19	ABR.A-DELISTED	Stock	24.3299	24.3299	24.16	24.3	400.0
2013-12-19	ABR.B-DELISTED	Stock	21.82	21.85	21.54	21.85	1960.0
2013-12-19	ABT	Stock	38.08	38.23	37.78	38.03	7756400.0
2013-12-19	ABTL-DELISTED	Stock	14.23	14.78	14.01	14.67	354437.0
2013-12-19	ABUS	Stock	7.6	7.68	7.53	7.67	76200.0

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

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