PREVIEW / stock_daily / 2014-12-24

all stock daily files

  file:    by_date/stock_daily/2014/2014-12-24.parquet
  size:    217 KB
  rows:    6,513
  symbols: 3,451

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
2014-12-24	AAPL	Stock	28.145	28.1775	28.0025	28.0025	57918400.0
2014-12-24	MSFT	Stock	48.64	48.64	48.08	48.14	11437800.0
2014-12-24	NVDA	Stock	0.5175	0.5182	0.5138	0.5142	45644000.0
2014-12-24	AMZN	Stock	15.319	15.35	15.144	15.1515	30276000.0
2014-12-24	GOOGL	Stock	26.941	27.0145	26.755	26.8465	14756960.0
2014-12-24	META	Stock	81.03	81.43	80.75	80.77	7685500.0
2014-12-24	TSLA	Stock	14.6513	14.8333	14.6167	14.8173	19983000.0
2014-12-24	TLT	Stock	123.06	124.06	122.93	123.95	4871374.0
2014-12-24	ES	Stock	53.86	55.12	53.76	55.02	1549900.0
2014-12-24	CL	Stock	71.0	71.31	70.43	70.47	1126900.0
2014-12-24	A	Stock	41.42	41.53	40.96	41.13	1426900.0
2014-12-24	AA.B-DELISTED	Stock	50.33	50.59	49.87	50.41	3907.0
2014-12-24	AABA-DELISTED	Stock	50.19	50.915	50.19	50.65	5072547.0
2014-12-24	AAC-DELISTED	Stock	29.39	29.795	29.2	29.25	25617.0
2014-12-24	AACG	Stock	3.58	3.58	3.58	3.58	5000.0
2014-12-24	AAIC-DELISTED	Stock	27.89	27.91	27.5	27.7	159181.0
2014-12-24	AAL	Stock	50.66	51.69	50.35	51.43	5955400.0
2014-12-24	AAMC-DELISTED	Stock	97.3559	100.1912	96.9118	98.8206	46121.0
2014-12-24	AAME	Stock	3.86	3.9	3.86	3.9	1800.0
2014-12-24	AAMI	Stock	16.23	16.29	15.87	16.16	89200.0
2014-12-24	AAOI	Stock	10.89	10.94	10.6	10.75	67000.0
2014-12-24	AAON	Stock	14.8267	14.9933	14.7133	14.94	78900.0
2014-12-24	AAP	Stock	161.44	162.4	160.22	160.23	152400.0
2014-12-24	AAT	Stock	40.25	40.81	40.13	40.21	57600.0
2014-12-24	AAU-DELISTED	Stock	0.92	0.985	0.91	0.93	72417.0
2014-12-24	AAUAF-DELISTED	Stock	0.92	0.985	0.91	0.94	74356.0
2014-12-24	AAV-DELISTED	Stock	4.66	4.77	4.54	4.68	86693.0
2014-12-24	AAVL-DELISTED	Stock	48.42	48.42	46.0	47.3	148613.0
2014-12-24	AAWW-DELISTED	Stock	48.3	48.899	45.26	48.52	101406.0
2014-12-24	AAXJ	Stock	60.29	60.44	60.28	60.37	354693.0
2014-12-24	AAXN-DELISTED	Stock	26.4	26.97	26.12	26.86	2073431.0
2014-12-24	AB	Stock	25.31	25.82	25.15	25.74	193100.0
2014-12-24	ABAC-DELISTED	Stock	1.86	1.8601	1.81	1.81	24818.0
2014-12-24	ABAX-DELISTED	Stock	58.26	59.35	58.04	58.48	69097.0
2014-12-24	ABB-DELISTED	Stock	21.55	21.66	21.55	21.6	368916.0
2014-12-24	ABBNY-DELISTED	Stock	21.55	21.66	21.55	21.6	401200.0
2014-12-24	ABBV	Stock	64.75	66.95	64.75	66.21	4705500.0
2014-12-24	ABC-DELISTED	Stock	91.65	92.26	91.46	91.6	380942.0
2014-12-24	ABCB	Stock	25.73	26.0	25.49	25.94	20100.0
2014-12-24	ABCD-DELISTED	Stock	1.6601	1.6999	1.65	1.689	5796.0
2014-12-24	ABCO-DELISTED	Stock	49.95	50.2	49.2	49.28	132356.0
2014-12-24	ABCW-DELISTED	Stock	34.8	35.0	34.76	35.0	1017.0
2014-12-24	ABDC-DELISTED	Stock	12.95	12.95	12.17	12.95	36543.0
2014-12-24	ABE-DELISTED	Stock	13.03	13.154	12.91	13.154	7069.0
2014-12-24	ABEO	Stock	88.75	91.25	85.5	86.0	236.0
2014-12-24	ABEOW-DELISTED	Stock	0.7	0.72	0.65	0.708	71001.0
2014-12-24	ABEV	Stock	6.11	6.15	6.04	6.09	3231100.0
2014-12-24	ABG	Stock	77.07	77.66	76.85	77.12	257600.0
2014-12-24	ABGB-DELISTED	Stock	12.04	12.11	11.9	11.9	28855.0
2014-12-24	ABM	Stock	29.01	29.2	28.8	29.03	98400.0

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

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