PREVIEW / stock_daily / 2010-03-18

all stock daily files

  file:    by_date/stock_daily/2010/2010-03-18.parquet
  size:    191 KB
  rows:    5,942
  symbols: 3,507

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-03-18	AAPL	Stock	8.0036	8.0357	7.9504	8.0232	342109600.0
2010-03-18	MSFT	Stock	29.63	29.72	29.5	29.61	43845200.0
2010-03-18	NVDA	Stock	0.4532	0.4532	0.4325	0.4365	740964000.0
2010-03-18	AMZN	Stock	6.551	6.6425	6.522	6.638	100426000.0
2010-03-18	TLT	Stock	91.42	91.48	91.01	91.17	2750298.0
2010-03-18	ES	Stock	27.16	27.27	27.06	27.17	1166600.0
2010-03-18	CL	Stock	42.255	42.435	41.955	42.385	2695800.0
2010-03-18	A	Stock	23.8197	24.02	23.7196	23.9342	4494710.0
2010-03-18	AABA-DELISTED	Stock	16.46	16.57	16.32	16.56	12505743.0
2010-03-18	AACC-DELISTED	Stock	6.35	6.45	6.25	6.27	21535.0
2010-03-18	AACG	Stock	4.14	4.2	4.06	4.06	4000.0
2010-03-18	AAI-DELISTED	Stock	5.3	5.33	5.15	5.19	6383977.0
2010-03-18	AAIC-DELISTED	Stock	18.13	18.52	17.85	17.9	71261.0
2010-03-18	AAME	Stock	1.43	1.43	1.38	1.38	300.0
2010-03-18	AAON	Stock	4.2607	4.2825	4.2351	4.2489	334125.0
2010-03-18	AAP	Stock	42.38	42.55	42.06	42.5	2674100.0
2010-03-18	AATI-DELISTED	Stock	3.53	3.54	3.47	3.48	241734.0
2010-03-18	AAU-DELISTED	Stock	0.94	0.97	0.9274	0.97	124029.0
2010-03-18	AAUAF-DELISTED	Stock	0.94	0.97	0.9274	0.97	124758.0
2010-03-18	AAV-DELISTED	Stock	7.57	7.65	7.38	7.44	1446889.0
2010-03-18	AAWW-DELISTED	Stock	49.54	50.9	49.42	50.35	232037.0
2010-03-18	AAXJ	Stock	56.7	56.7	56.1	56.19	596089.0
2010-03-18	AAXN-DELISTED	Stock	6.75	6.78	6.39	6.4	1848039.0
2010-03-18	AB	Stock	29.95	29.97	29.29	29.49	302800.0
2010-03-18	ABAX-DELISTED	Stock	27.97	28.23	27.83	28.08	144723.0
2010-03-18	ABB-DELISTED	Stock	21.51	21.59	21.3305	21.58	1428489.0
2010-03-18	ABBC-DELISTED	Stock	8.22	8.34	8.22	8.24	22604.0
2010-03-18	ABBNY-DELISTED	Stock	21.51	21.59	21.3305	21.59	1430019.0
2010-03-18	ABC-DELISTED	Stock	28.37	28.62	28.19	28.57	2747944.0
2010-03-18	ABCB	Stock	9.2841	9.5013	9.2841	9.3927	12656.0
2010-03-18	ABCD-DELISTED	Stock	3.93	3.94	3.85	3.9	18919.0
2010-03-18	ABCO-DELISTED	Stock	16.495	16.58	16.245	16.49	69584.0
2010-03-18	ABCW-DELISTED	Stock	1.34	1.37	1.04	1.13	530300.0
2010-03-18	ABD-DELISTED	Stock	7.46	7.59	7.38	7.48	153810.0
2010-03-18	ABE-DELISTED	Stock	16.67	16.7704	16.6436	16.72	15563.0
2010-03-18	ABEO	Stock	3125.0	3187.5	3125.0	3187.5	7.0
2010-03-18	ABFS-DELISTED	Stock	29.3	29.72	28.98	29.66	417256.0
2010-03-18	ABG	Stock	14.08	14.21	13.76	13.86	255300.0
2010-03-18	ABII-DELISTED	Stock	52.25	52.344	51.13	51.75	82261.0
2010-03-18	ABK-DELISTED	Stock	0.7906	0.799	0.7611	0.7651	5065630.0
2010-03-18	ABM	Stock	20.13	20.36	20.13	20.21	234600.0
2010-03-18	ABMD-DELISTED	Stock	10.28	10.4	10.18	10.35	110968.0
2010-03-18	ABR	Stock	3.0	3.13	3.0	3.04	149400.0
2010-03-18	ABT	Stock	26.1203	26.1683	25.7221	25.7988	32043351.0
2010-03-18	ABTL-DELISTED	Stock	5.6	5.6	5.35	5.45	15403.0
2010-03-18	ABV-DELISTED	Stock	96.67	97.0	95.68	95.77	393603.0
2010-03-18	ABVT-DELISTED	Stock	54.91	55.08	54.69	54.86	171083.0
2010-03-18	ABX-DELISTED	Stock	40.11	40.57	39.43	39.76	7557282.0
2010-03-18	ACAD	Stock	1.59	1.63	1.5	1.61	611700.0
2010-03-18	ACAP-DELISTED	Stock	31.76	32.5	31.5	31.81	34900.0

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

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