PREVIEW / stock_daily / 2015-07-20

all stock daily files

  file:    by_date/stock_daily/2015/2015-07-20.parquet
  size:    225 KB
  rows:    6,691
  symbols: 3,504

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-20	AAPL	Stock	32.7425	33.2425	32.675	33.0175	235600800.0
2015-07-20	MSFT	Stock	46.65	47.13	46.44	46.92	30631900.0
2015-07-20	NVDA	Stock	0.5018	0.5038	0.4912	0.4925	188412000.0
2015-07-20	AMZN	Stock	24.6285	24.66	24.27	24.405	95050000.0
2015-07-20	GOOGL	Stock	34.449	34.89	34.0885	34.642	102435040.0
2015-07-20	META	Stock	95.85	98.6	95.36	97.91	54860500.0
2015-07-20	TSLA	Stock	18.3333	19.11	18.1693	18.8173	74677500.0
2015-07-20	TLT	Stock	118.29	118.645	117.9	118.22	5940984.0
2015-07-20	ES	Stock	47.85	47.89	47.21	47.58	1259900.0
2015-07-20	CL	Stock	67.37	67.96	67.14	67.8	2214900.0
2015-07-20	A	Stock	40.06	40.13	39.95	40.06	1155200.0
2015-07-20	AA.B-DELISTED	Stock	38.63	38.63	37.59	37.65	30323.0
2015-07-20	AABA-DELISTED	Stock	39.94	39.98	39.26	39.54	12691325.0
2015-07-20	AAC-DELISTED	Stock	42.05	42.57	40.67	41.0	145836.0
2015-07-20	AACG	Stock	4.33	4.46	4.33	4.36	37800.0
2015-07-20	AAIC-DELISTED	Stock	20.0	20.11	19.7404	19.99	531493.0
2015-07-20	AAL	Stock	41.55	41.71	40.44	40.55	7645900.0
2015-07-20	AAMC-DELISTED	Stock	42.0	43.7794	39.9853	40.3676	30879.0
2015-07-20	AAME	Stock	3.65	3.7	3.65	3.7	1100.0
2015-07-20	AAMI	Stock	17.6	17.76	17.44	17.72	192500.0
2015-07-20	AAOI	Stock	19.25	19.59	18.07	18.58	270100.0
2015-07-20	AAON	Stock	15.28	15.4	15.14	15.3467	129150.0
2015-07-20	AAP	Stock	169.7	170.0	168.24	168.69	480600.0
2015-07-20	AAT	Stock	41.15	41.44	40.91	41.33	60000.0
2015-07-20	AAU-DELISTED	Stock	0.775	0.775	0.69	0.69	192974.0
2015-07-20	AAUAF-DELISTED	Stock	0.7301	0.7301	0.65	0.69	205375.0
2015-07-20	AAV-DELISTED	Stock	5.67	5.71	5.53	5.62	95325.0
2015-07-20	AAVL-DELISTED	Stock	16.72	16.9	16.57	16.8	469026.0
2015-07-20	AAWW-DELISTED	Stock	51.26	51.77	50.565	50.83	475736.0
2015-07-20	AAXJ	Stock	61.21	61.43	60.98	61.24	597440.0
2015-07-20	AAXN-DELISTED	Stock	34.1	34.91	32.5	32.55	2247786.0
2015-07-20	AB	Stock	28.67	28.8	28.14	28.37	111900.0
2015-07-20	ABAC-DELISTED	Stock	1.1	1.1194	1.1	1.1001	5923.0
2015-07-20	ABAX-DELISTED	Stock	54.35	54.76	53.48	54.01	161647.0
2015-07-20	ABB-DELISTED	Stock	20.71	20.79	20.66	20.71	1089940.0
2015-07-20	ABBNY-DELISTED	Stock	20.71	20.79	20.66	20.71	1135904.0
2015-07-20	ABBV	Stock	70.0	71.11	69.86	70.8	9633000.0
2015-07-20	ABC-DELISTED	Stock	113.23	115.0	113.18	114.75	1719966.0
2015-07-20	ABCB	Stock	26.1	26.23	25.84	25.98	58700.0
2015-07-20	ABCD-DELISTED	Stock	5.07	5.07	4.93	4.98	87761.0
2015-07-20	ABCO-DELISTED	Stock	58.75	59.0	58.1	58.62	405840.0
2015-07-20	ABCW-DELISTED	Stock	41.33	41.48	40.4001	40.64	10811.0
2015-07-20	ABDC-DELISTED	Stock	13.02	13.22	12.66	13.12	30451.0
2015-07-20	ABE-DELISTED	Stock	13.13	13.17	13.02	13.03	31567.0
2015-07-20	ABEO	Stock	157.5	160.0	142.0	144.75	16784.0
2015-07-20	ABEOW-DELISTED	Stock	2.21	2.34	1.9	1.9723	5157.0
2015-07-20	ABEV	Stock	6.11	6.15	6.05	6.14	13907100.0
2015-07-20	ABG	Stock	95.3	96.58	94.26	95.54	284100.0
2015-07-20	ABGB-DELISTED	Stock	15.19	15.3099	15.16	15.16	15430.0
2015-07-20	ABM	Stock	32.62	32.62	32.47	32.57	122500.0

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

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