PREVIEW / stock_daily / 2010-05-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-18.parquet
  size:    192 KB
  rows:    5,969
  symbols: 3,512

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-05-18	AAPL	Stock	9.1779	9.2339	8.9379	9.0129	782678400.0
2010-05-18	MSFT	Stock	28.87	29.0	28.4	28.6	52690600.0
2010-05-18	NVDA	Stock	0.3275	0.3295	0.3123	0.314	674112000.0
2010-05-18	AMZN	Stock	6.507	6.5625	6.2755	6.314	105138000.0
2010-05-18	TLT	Stock	94.9	96.17	94.77	95.98	9904647.0
2010-05-18	ES	Stock	26.74	26.93	26.45	26.49	1518500.0
2010-05-18	CL	Stock	42.045	42.125	41.49	41.575	4739600.0
2010-05-18	A	Stock	24.3205	24.3562	22.7682	22.9399	16516531.0
2010-05-18	AABA-DELISTED	Stock	16.27	16.44	15.95	16.02	16036540.0
2010-05-18	AACC-DELISTED	Stock	7.59	7.6	7.36	7.5	36213.0
2010-05-18	AACG	Stock	3.53	3.61	3.53	3.53	600.0
2010-05-18	AAI-DELISTED	Stock	5.43	5.44	5.2	5.2	3684007.0
2010-05-18	AAIC-DELISTED	Stock	21.06	21.06	20.3	20.34	30960.0
2010-05-18	AAME	Stock	1.6	1.8	1.6	1.8	6300.0
2010-05-18	AAON	Stock	4.9323	4.956	4.883	4.9007	545737.0
2010-05-18	AAP	Stock	46.16	46.78	45.65	45.75	2224700.0
2010-05-18	AATI-DELISTED	Stock	3.66	3.68	3.55	3.56	422088.0
2010-05-18	AAU-DELISTED	Stock	1.15	1.15	1.09	1.11	118594.0
2010-05-18	AAUAF-DELISTED	Stock	1.15	1.15	1.09	1.11	118994.0
2010-05-18	AAV-DELISTED	Stock	6.24	6.43	5.96	5.98	544818.0
2010-05-18	AAWW-DELISTED	Stock	52.88	53.23	50.11	50.48	244992.0
2010-05-18	AAXJ	Stock	54.06	54.16	52.67	52.8	184106.0
2010-05-18	AAXN-DELISTED	Stock	5.11	5.17	4.93	4.96	801485.0
2010-05-18	AB	Stock	29.85	30.13	28.91	29.11	434700.0
2010-05-18	ABAX-DELISTED	Stock	25.02	25.33	24.62	24.78	107351.0
2010-05-18	ABB-DELISTED	Stock	17.86	17.91	17.19	17.28	4013531.0
2010-05-18	ABBC-DELISTED	Stock	10.02	10.04	9.46	9.52	77401.0
2010-05-18	ABBNY-DELISTED	Stock	17.86	17.91	17.19	17.28	4054191.0
2010-05-18	ABC-DELISTED	Stock	31.72	31.96	31.08	31.29	4473814.0
2010-05-18	ABCB	Stock	10.928	11.0175	10.8085	10.8284	217531.0
2010-05-18	ABCD-DELISTED	Stock	5.09	5.2	5.03	5.05	47750.0
2010-05-18	ABCO-DELISTED	Stock	19.352	19.512	19.143	19.263	130612.0
2010-05-18	ABCW-DELISTED	Stock	0.7998	0.829	0.7705	0.79	187950.0
2010-05-18	ABD-DELISTED	Stock	7.5	7.56	6.85	6.9	448390.0
2010-05-18	ABE-DELISTED	Stock	15.72	15.8584	15.57	15.57	11353.0
2010-05-18	ABEO	Stock	3050.0	3050.0	2812.5	3000.0	13.0
2010-05-18	ABFS-DELISTED	Stock	28.87	29.08	28.13	28.23	440531.0
2010-05-18	ABG	Stock	14.0	14.07	13.45	13.49	315300.0
2010-05-18	ABII-DELISTED	Stock	48.92	49.27	46.4	48.18	26632.0
2010-05-18	ABK-DELISTED	Stock	1.34	1.36	1.06	1.12	70278436.0
2010-05-18	ABM	Stock	22.78	22.9	22.19	22.25	139600.0
2010-05-18	ABMD-DELISTED	Stock	9.71	9.83	9.15	9.23	261705.0
2010-05-18	ABR	Stock	4.13	4.23	3.93	3.95	155100.0
2010-05-18	ABT	Stock	23.3711	23.4766	23.0304	23.0544	14520425.0
2010-05-18	ABTL-DELISTED	Stock	5.5	5.55	5.25	5.3	65005.0
2010-05-18	ABV-DELISTED	Stock	100.47	100.54	96.96	97.53	470430.0
2010-05-18	ABVA-DELISTED	Stock	2.79	2.99	2.74	2.7401	3360.0
2010-05-18	ABVT-DELISTED	Stock	47.19	48.23	46.265	47.13	378883.0
2010-05-18	ABX-DELISTED	Stock	43.97	44.99	43.9	44.47	10478977.0
2010-05-18	ACAD	Stock	1.5	1.5	1.4	1.42	235100.0

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

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