PREVIEW / stock_daily / 2014-10-30

all stock daily files

  file:    by_date/stock_daily/2014/2014-10-30.parquet
  size:    222 KB
  rows:    6,626
  symbols: 3,560

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-10-30	AAPL	Stock	26.74	26.8375	26.475	26.745	162619200.0
2014-10-30	MSFT	Stock	46.32	46.32	45.77	46.05	30073900.0
2014-10-30	NVDA	Stock	0.469	0.471	0.4612	0.4673	170260000.0
2014-10-30	AMZN	Stock	14.699	14.987	14.618	14.9535	81104000.0
2014-10-30	GOOGL	Stock	27.9125	28.125	27.6065	28.0135	32249380.0
2014-10-30	META	Stock	75.05	75.35	72.9	74.11	83270000.0
2014-10-30	TSLA	Stock	15.876	16.0333	15.6707	15.9107	48426000.0
2014-10-30	TLT	Stock	120.32	120.46	119.51	119.56	7024366.0
2014-10-30	ES	Stock	48.47	49.98	48.34	49.35	1772400.0
2014-10-30	CL	Stock	65.76	66.66	65.52	66.41	2161800.0
2014-10-30	A	Stock	38.5622	38.8984	38.4478	38.8555	2883794.0
2014-10-30	AA.B-DELISTED	Stock	50.2	50.89	49.98	50.805	143611.0
2014-10-30	AABA-DELISTED	Stock	45.22	45.84	45.13	45.63	15353178.0
2014-10-30	AAC-DELISTED	Stock	21.23	21.38	21.14	21.2	61695.0
2014-10-30	AACG	Stock	4.15	4.16	4.13	4.16	3100.0
2014-10-30	AAIC-DELISTED	Stock	27.11	27.38	26.93	27.29	244704.0
2014-10-30	AAL	Stock	39.91	40.69	39.62	40.3	10566600.0
2014-10-30	AAMC-DELISTED	Stock	158.1324	169.1147	157.3441	169.1147	36020.0
2014-10-30	AAME	Stock	3.94	3.95	3.85	3.86	5700.0
2014-10-30	AAMI	Stock	14.7	14.73	14.5	14.63	119200.0
2014-10-30	AAOI	Stock	15.4	15.49	15.11	15.25	189600.0
2014-10-30	AAON	Stock	12.66	13.1267	12.6	12.96	218700.0
2014-10-30	AAP	Stock	145.0	146.0	143.96	145.71	461400.0
2014-10-30	AAT	Stock	37.37	38.1	37.12	38.02	134500.0
2014-10-30	AAU-DELISTED	Stock	1.28	1.3	1.22	1.24	153854.0
2014-10-30	AAUAF-DELISTED	Stock	1.22	1.24	1.16	1.24	184564.0
2014-10-30	AAV-DELISTED	Stock	4.27	4.27	4.12	4.18	526718.0
2014-10-30	AAVL-DELISTED	Stock	34.03	36.75	33.25	35.71	151423.0
2014-10-30	AAWW-DELISTED	Stock	36.39	36.74	35.62	36.37	143742.0
2014-10-30	AAXJ	Stock	62.11	62.715	62.08	62.57	994765.0
2014-10-30	AAXN-DELISTED	Stock	17.55	18.42	16.86	17.69	9539133.0
2014-10-30	AB	Stock	25.99	26.55	25.75	26.14	245100.0
2014-10-30	ABAC-DELISTED	Stock	2.4	2.4	2.35	2.4	24506.0
2014-10-30	ABAX-DELISTED	Stock	49.41	51.77	48.63	51.56	344949.0
2014-10-30	ABB-DELISTED	Stock	21.55	21.74	21.5	21.71	1122541.0
2014-10-30	ABBNY-DELISTED	Stock	21.55	21.78	21.5	21.73	1342766.0
2014-10-30	ABBV	Stock	60.0	61.43	59.91	61.18	11635300.0
2014-10-30	ABC-DELISTED	Stock	81.47	85.1156	81.47	84.617	4350142.0
2014-10-30	ABCB	Stock	24.45	24.92	24.07	24.7	121700.0
2014-10-30	ABCD-DELISTED	Stock	1.49	1.53	1.49	1.51	11920.0
2014-10-30	ABCO-DELISTED	Stock	52.44	53.52	52.28	52.96	192855.0
2014-10-30	ABCW-DELISTED	Stock	34.8	34.8	29.82	29.82	4600.0
2014-10-30	ABDC-DELISTED	Stock	12.47	12.68	12.35	12.66	32147.0
2014-10-30	ABE-DELISTED	Stock	14.0551	14.13	14.01	14.1147	3174.0
2014-10-30	ABEO	Stock	225.0	237.5	225.0	237.5	48.0
2014-10-30	ABEV	Stock	6.46	6.56	6.44	6.53	14671600.0
2014-10-30	ABG	Stock	68.24	69.71	67.94	69.4	405100.0
2014-10-30	ABGB-DELISTED	Stock	19.8	20.3525	19.76	20.34	3787.0
2014-10-30	ABM	Stock	27.17	27.74	27.09	27.44	182600.0
2014-10-30	ABMD-DELISTED	Stock	26.5	31.42	26.5	31.35	1793293.0

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

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