PREVIEW / stock_daily / 2015-07-08

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-08.parquet
  size:    223 KB
  rows:    6,662
  symbols: 3,487

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
2015-07-08	AAPL	Stock	31.12	31.16	30.635	30.6425	243046400.0
2015-07-08	MSFT	Stock	44.44	44.9	44.03	44.24	39785900.0
2015-07-08	NVDA	Stock	0.492	0.495	0.4872	0.4912	332492000.0
2015-07-08	AMZN	Stock	21.7175	21.7995	21.4415	21.485	47662000.0
2015-07-08	GOOGL	Stock	27.28	27.414	27.06	27.085	27661300.0
2015-07-08	META	Stock	86.29	86.75	85.45	85.65	24399300.0
2015-07-08	TSLA	Stock	17.288	17.3867	16.954	16.9973	93316500.0
2015-07-08	TLT	Stock	120.02	120.565	119.5	120.29	9951815.0
2015-07-08	ES	Stock	47.28	47.77	46.89	47.13	3002700.0
2015-07-08	CL	Stock	66.93	67.16	66.45	66.45	2104600.0
2015-07-08	A	Stock	39.48	39.48	38.71	38.75	3391000.0
2015-07-08	AA.B-DELISTED	Stock	38.77	39.6399	38.4	38.76	21784.0
2015-07-08	AABA-DELISTED	Stock	37.2	37.49	36.94	37.24	19580965.0
2015-07-08	AAC-DELISTED	Stock	42.61	43.11	39.5864	40.9	262869.0
2015-07-08	AACG	Stock	4.69	4.85	4.41	4.42	17600.0
2015-07-08	AAIC-DELISTED	Stock	19.86	20.0	19.78	19.94	371522.0
2015-07-08	AAL	Stock	40.3	40.31	39.14	39.31	11193000.0
2015-07-08	AAMC-DELISTED	Stock	41.3235	41.4676	39.3	39.3029	11094.0
2015-07-08	AAME	Stock	3.69	3.7	3.57	3.57	3200.0
2015-07-08	AAMI	Stock	17.16	17.3	16.9	17.01	301400.0
2015-07-08	AAOI	Stock	17.05	17.05	15.8	16.05	250200.0
2015-07-08	AAON	Stock	14.86	15.0933	14.6	14.74	711000.0
2015-07-08	AAP	Stock	162.63	163.82	159.12	159.99	14312400.0
2015-07-08	AAT	Stock	40.49	40.91	40.36	40.43	205100.0
2015-07-08	AAU-DELISTED	Stock	0.787	0.808	0.78	0.7926	84682.0
2015-07-08	AAUAF-DELISTED	Stock	0.785	0.805	0.78	0.79	86003.0
2015-07-08	AAV-DELISTED	Stock	6.25	6.39	6.17	6.18	159504.0
2015-07-08	AAVL-DELISTED	Stock	15.82	16.05	15.32	15.47	370003.0
2015-07-08	AAWW-DELISTED	Stock	53.62	53.89	51.87	52.5	480141.0
2015-07-08	AAXJ	Stock	58.77	58.97	58.08	58.14	4831230.0
2015-07-08	AAXN-DELISTED	Stock	32.18	32.49	31.11	31.385	1720679.0
2015-07-08	AB	Stock	29.02	29.29	28.71	28.71	137300.0
2015-07-08	ABAC-DELISTED	Stock	1.0218	1.05	1.0218	1.0499	11005.0
2015-07-08	ABAX-DELISTED	Stock	50.93	51.005	49.66	50.07	113007.0
2015-07-08	ABB-DELISTED	Stock	20.27	20.33	20.11	20.12	2653919.0
2015-07-08	ABBNY-DELISTED	Stock	20.27	20.33	20.11	20.13	2786072.0
2015-07-08	ABBV	Stock	67.79	68.44	67.58	67.66	5027200.0
2015-07-08	ABC-DELISTED	Stock	107.54	108.56	107.39	107.88	913031.0
2015-07-08	ABCB	Stock	25.24	25.4	25.01	25.33	76100.0
2015-07-08	ABCD-DELISTED	Stock	4.72	4.85	4.66	4.69	297167.0
2015-07-08	ABCO-DELISTED	Stock	54.62	54.79	53.84	54.46	198355.0
2015-07-08	ABCW-DELISTED	Stock	40.7	41.26	39.1001	41.07	12504.0
2015-07-08	ABDC-DELISTED	Stock	12.34	12.84	12.16	12.21	47835.0
2015-07-08	ABE-DELISTED	Stock	12.3873	12.46	12.3873	12.42	8073.0
2015-07-08	ABEO	Stock	117.5	120.5	116.25	118.25	9344.0
2015-07-08	ABEOW-DELISTED	Stock	2.54	2.54	1.5	1.56	31688.0
2015-07-08	ABEV	Stock	5.93	5.97	5.88	5.89	12730000.0
2015-07-08	ABG	Stock	90.99	91.05	88.73	89.47	189100.0
2015-07-08	ABGB-DELISTED	Stock	15.17	15.17	14.8	14.89	27835.0
2015-07-08	ABM	Stock	31.92	32.28	31.85	32.02	240900.0

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

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