PREVIEW / stock_daily / 2013-12-18

all stock daily files

  file:    by_date/stock_daily/2013/2013-12-18.parquet
  size:    217 KB
  rows:    6,464
  symbols: 3,546

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-18	AAPL	Stock	19.6321	19.6946	19.2429	19.6704	565863200.0
2013-12-18	MSFT	Stock	36.36	36.6	35.53	36.58	63192100.0
2013-12-18	NVDA	Stock	0.3785	0.3838	0.3738	0.383	426232000.0
2013-12-18	AMZN	Stock	19.4615	19.815	19.155	19.798	69782000.0
2013-12-18	META	Stock	54.86	55.89	53.75	55.57	76003000.0
2013-12-18	TSLA	Stock	10.1493	10.3267	9.73	9.8653	173728500.0
2013-12-18	TLT	Stock	102.83	103.72	102.46	102.77	12974216.0
2013-12-18	ES	Stock	41.46	42.03	40.93	42.01	1844400.0
2013-12-18	CL	Stock	63.78	64.68	62.8	64.64	3940300.0
2013-12-18	A	Stock	40.4149	41.4449	40.3219	41.4092	5782547.0
2013-12-18	AABA-DELISTED	Stock	39.53	40.04	38.82	40.03	15727384.0
2013-12-18	AACG	Stock	4.05	4.07	3.87	4.0	12300.0
2013-12-18	AAIC-DELISTED	Stock	25.95	26.24	25.83	25.86	186422.0
2013-12-18	AAL	Stock	25.99	26.23	25.55	26.23	9993900.0
2013-12-18	AAMC-DELISTED	Stock	288.8382	299.5235	283.8235	292.7941	57484.0
2013-12-18	AAME	Stock	4.01	4.05	4.0	4.0	9900.0
2013-12-18	AAOI	Stock	15.15	15.43	14.85	15.2	77200.0
2013-12-18	AAON	Stock	13.2	13.5156	13.04	13.5111	178425.0
2013-12-18	AAP	Stock	108.85	109.56	106.88	109.27	1104500.0
2013-12-18	AAT	Stock	31.32	32.29	31.13	32.24	160800.0
2013-12-18	AAU-DELISTED	Stock	1.06	1.08	1.04	1.07	81784.0
2013-12-18	AAUAF-DELISTED	Stock	1.08	1.1	1.06	1.07	80778.0
2013-12-18	AAV-DELISTED	Stock	4.24	4.38	4.24	4.34	119431.0
2013-12-18	AAWW-DELISTED	Stock	37.71	37.94	36.87	37.88	198313.0
2013-12-18	AAXJ	Stock	59.11	60.19	58.47	59.83	526793.0
2013-12-18	AAXN-DELISTED	Stock	16.29	16.81	16.05	16.77	1185862.0
2013-12-18	AB	Stock	21.18	21.6	20.91	21.4	462800.0
2013-12-18	ABAC-DELISTED	Stock	2.23	2.27	2.1601	2.23	56968.0
2013-12-18	ABAX-DELISTED	Stock	37.0	37.24	35.3725	37.24	67263.0
2013-12-18	ABB-DELISTED	Stock	25.23	25.42	24.92	25.31	1664103.0
2013-12-18	ABBNY-DELISTED	Stock	25.23	25.42	24.92	25.33	1804181.0
2013-12-18	ABBV	Stock	52.78	54.43	52.22	54.32	9635600.0
2013-12-18	ABC-DELISTED	Stock	68.6	69.67	68.16	69.62	1517625.0
2013-12-18	ABCB	Stock	20.08	20.39	19.71	20.35	47600.0
2013-12-18	ABCD-DELISTED	Stock	1.71	1.77	1.61	1.71	2940.0
2013-12-18	ABCO-DELISTED	Stock	63.25	63.25	61.97	62.85	164583.0
2013-12-18	ABE-DELISTED	Stock	13.69	13.97	13.47	13.9	88476.0
2013-12-18	ABEO	Stock	312.5	337.5	312.5	337.5	21.0
2013-12-18	ABEV	Stock	7.09	7.39	6.75	7.24	9636100.0
2013-12-18	ABFS-DELISTED	Stock	33.27	33.79	32.8	33.68	301234.0
2013-12-18	ABG	Stock	53.43	53.67	51.6	53.62	350200.0
2013-12-18	ABGB-DELISTED	Stock	13.75	14.03	13.6801	14.03	33370.0
2013-12-18	ABM	Stock	27.46	27.65	27.12	27.6	250400.0
2013-12-18	ABMD-DELISTED	Stock	26.51	27.34	26.2	27.34	379407.0
2013-12-18	ABR	Stock	6.56	6.62	6.48	6.6	118900.0
2013-12-18	ABR.A-DELISTED	Stock	23.96	24.23	23.7762	24.159	1825.0
2013-12-18	ABR.B-DELISTED	Stock	22.0	22.25	21.95	22.24	43052.0
2013-12-18	ABT	Stock	36.66	38.18	36.65	38.12	11548800.0
2013-12-18	ABTL-DELISTED	Stock	12.47	14.4	12.42	14.12	1063967.0
2013-12-18	ABUS	Stock	7.64	7.64	7.5	7.59	96600.0

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

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