PREVIEW / stock_daily / 2010-06-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-06-18.parquet
  size:    191 KB
  rows:    5,933
  symbols: 3,502

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
2010-06-18	AAPL	Stock	9.7232	9.8214	9.6936	9.7882	784621600.0
2010-06-18	MSFT	Stock	26.37	26.53	26.17	26.44	52075600.0
2010-06-18	NVDA	Stock	0.3073	0.3113	0.305	0.3075	932832000.0
2010-06-18	AMZN	Stock	6.324	6.374	6.2535	6.2915	76720000.0
2010-06-18	TLT	Stock	97.89	98.11	97.57	97.69	4171631.0
2010-06-18	ES	Stock	27.02	27.06	26.84	26.87	1171900.0
2010-06-18	CL	Stock	40.48	40.61	40.26	40.295	5187800.0
2010-06-18	A	Stock	23.2833	23.5622	23.176	23.3262	3728326.0
2010-06-18	AABA-DELISTED	Stock	15.64	15.67	15.47	15.54	12490214.0
2010-06-18	AACC-DELISTED	Stock	4.64	4.73	4.62	4.67	108421.0
2010-06-18	AACG	Stock	3.52	3.52	3.15	3.25	1500.0
2010-06-18	AAI-DELISTED	Stock	5.47	5.5	5.35	5.39	3061156.0
2010-06-18	AAIC-DELISTED	Stock	20.32	20.37	20.03	20.23	39028.0
2010-06-18	AAME	Stock	1.5	1.58	1.48	1.58	900.0
2010-06-18	AAON	Stock	4.8711	4.9383	4.7565	4.8948	899606.0
2010-06-18	AAP	Stock	51.99	52.33	51.47	51.59	1463800.0
2010-06-18	AATI-DELISTED	Stock	3.63	3.73	3.59	3.73	368095.0
2010-06-18	AAU-DELISTED	Stock	1.01	1.03	0.98	1.0	166973.0
2010-06-18	AAUAF-DELISTED	Stock	1.01	1.03	0.98	1.0	167373.0
2010-06-18	AAV-DELISTED	Stock	7.04	7.1	6.98	7.08	311996.0
2010-06-18	AAWW-DELISTED	Stock	53.72	54.06	52.14	53.03	148492.0
2010-06-18	AAXJ	Stock	54.35	54.719	54.32	54.58	55660.0
2010-06-18	AAXN-DELISTED	Stock	4.21	4.2201	4.13	4.15	698316.0
2010-06-18	AB	Stock	29.39	29.6	29.15	29.4	234200.0
2010-06-18	ABAX-DELISTED	Stock	23.13	23.13	22.37	22.48	107113.0
2010-06-18	ABB-DELISTED	Stock	18.63	18.74	18.5	18.61	2906445.0
2010-06-18	ABBC-DELISTED	Stock	8.95	9.15	8.86	8.99	116286.0
2010-06-18	ABBNY-DELISTED	Stock	18.63	18.74	18.5	18.61	2920652.0
2010-06-18	ABC-DELISTED	Stock	32.87	33.03	32.5	32.55	2584563.0
2010-06-18	ABCB	Stock	10.4303	10.4602	10.2014	10.4403	171513.0
2010-06-18	ABCD-DELISTED	Stock	4.38	4.52	4.35	4.4	81909.0
2010-06-18	ABCO-DELISTED	Stock	21.52	21.72	21.21	21.47	234563.0
2010-06-18	ABCW-DELISTED	Stock	0.74	0.75	0.67	0.68	62080.0
2010-06-18	ABD-DELISTED	Stock	5.2	5.4097	5.2	5.34	711830.0
2010-06-18	ABE-DELISTED	Stock	16.01	16.2	16.01	16.16	20765.0
2010-06-18	ABEO	Stock	2937.5	2937.5	2875.0	2937.5	10.0
2010-06-18	ABFS-DELISTED	Stock	21.5	21.84	21.29	21.67	362878.0
2010-06-18	ABG	Stock	12.96	12.96	12.15	12.24	417500.0
2010-06-18	ABII-DELISTED	Stock	62.5	62.5	59.2	62.355	34356.0
2010-06-18	ABK-DELISTED	Stock	0.81	0.87	0.79	0.8001	15400442.0
2010-06-18	ABM	Stock	22.6	22.81	22.4	22.71	394600.0
2010-06-18	ABMD-DELISTED	Stock	9.9	9.99	9.73	9.73	275721.0
2010-06-18	ABR	Stock	5.24	5.3	5.1	5.26	258100.0
2010-06-18	ABT	Stock	23.443	23.5102	23.2223	23.3998	18738433.0
2010-06-18	ABTL-DELISTED	Stock	6.2	6.25	6.1	6.25	18994.0
2010-06-18	ABV-DELISTED	Stock	105.0	105.78	104.528	104.85	511993.0
2010-06-18	ABVA-DELISTED	Stock	2.62	2.62	2.62	2.62	300.0
2010-06-18	ABVT-DELISTED	Stock	47.5	47.77	47.0	47.55	226384.0
2010-06-18	ABX-DELISTED	Stock	45.57	46.46	45.3	46.38	15500447.0
2010-06-18	ACAD	Stock	1.3	1.3	1.21	1.27	559200.0

> showing 50 of 5,933 rows — these rows as CSV

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