PREVIEW / stock_daily / 2010-05-19

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-19.parquet
  size:    191 KB
  rows:    5,953
  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-05-19	AAPL	Stock	8.9107	9.0329	8.7446	8.8693	1025726800.0
2010-05-19	MSFT	Stock	28.52	28.69	27.79	28.24	61746700.0
2010-05-19	NVDA	Stock	0.3125	0.3195	0.3103	0.319	826520000.0
2010-05-19	AMZN	Stock	6.2755	6.3965	6.19	6.2295	129266000.0
2010-05-19	TLT	Stock	95.94	96.95	95.93	96.3	14121236.0
2010-05-19	ES	Stock	26.36	26.83	26.23	26.61	3189400.0
2010-05-19	CL	Stock	41.425	41.62	40.855	41.075	6132000.0
2010-05-19	A	Stock	22.897	23.4263	22.8898	23.3119	7204174.0
2010-05-19	AABA-DELISTED	Stock	15.87	16.0	15.51	15.77	20285405.0
2010-05-19	AACC-DELISTED	Stock	7.48	7.52	7.15	7.21	31326.0
2010-05-19	AACG	Stock	3.42	3.42	3.31	3.36	3800.0
2010-05-19	AAI-DELISTED	Stock	5.2	5.29	5.07	5.21	3088056.0
2010-05-19	AAIC-DELISTED	Stock	20.0	20.39	19.54	19.75	81207.0
2010-05-19	AAME	Stock	1.79	1.79	1.6	1.6	4300.0
2010-05-19	AAON	Stock	4.8928	4.9284	4.8257	4.8731	332100.0
2010-05-19	AAP	Stock	45.76	46.48	45.13	46.09	2131800.0
2010-05-19	AATI-DELISTED	Stock	3.56	3.59	3.49	3.51	191457.0
2010-05-19	AAU-DELISTED	Stock	1.11	1.12	1.03	1.08	193405.0
2010-05-19	AAUAF-DELISTED	Stock	1.11	1.12	1.03	1.08	195426.0
2010-05-19	AAV-DELISTED	Stock	5.91	5.95	5.65	5.85	707966.0
2010-05-19	AAWW-DELISTED	Stock	50.03	50.5575	48.33	50.11	300235.0
2010-05-19	AAXJ	Stock	52.41	52.76	51.78	52.65	1002288.0
2010-05-19	AAXN-DELISTED	Stock	4.95	4.98	4.83	4.87	775706.0
2010-05-19	AB	Stock	28.76	29.15	28.08	28.43	481200.0
2010-05-19	ABAX-DELISTED	Stock	24.65	24.92	24.44	24.66	84119.0
2010-05-19	ABB-DELISTED	Stock	17.09	17.237	16.68	17.05	5806105.0
2010-05-19	ABBC-DELISTED	Stock	9.47	9.61	9.22	9.25	97075.0
2010-05-19	ABBNY-DELISTED	Stock	17.1	17.237	16.68	17.01	5853201.0
2010-05-19	ABC-DELISTED	Stock	31.14	31.58	31.0	31.42	3972649.0
2010-05-19	ABCB	Stock	10.7488	10.9081	10.6294	10.709	78271.0
2010-05-19	ABCD-DELISTED	Stock	5.04	5.09	4.91	4.97	105683.0
2010-05-19	ABCO-DELISTED	Stock	19.157	19.718	19.012	19.438	177853.0
2010-05-19	ABCW-DELISTED	Stock	0.78	0.79	0.7	0.71	197010.0
2010-05-19	ABD-DELISTED	Stock	6.9	7.07	6.3899	6.8	490160.0
2010-05-19	ABE-DELISTED	Stock	15.4	15.48	15.11	15.2	23330.0
2010-05-19	ABEO	Stock	2762.5	3125.0	2762.5	3062.5	44.0
2010-05-19	ABFS-DELISTED	Stock	28.22	28.61	27.26	27.8	619961.0
2010-05-19	ABG	Stock	13.38	13.55	12.88	13.0	241100.0
2010-05-19	ABII-DELISTED	Stock	48.97	48.97	45.59	47.32	67546.0
2010-05-19	ABK-DELISTED	Stock	1.03	1.11	0.99	1.05	41336135.0
2010-05-19	ABM	Stock	22.2	22.6	21.82	21.94	148100.0
2010-05-19	ABMD-DELISTED	Stock	9.21	9.3199	8.911	9.11	238619.0
2010-05-19	ABR	Stock	3.89	3.97	3.63	3.81	179900.0
2010-05-19	ABT	Stock	22.968	23.1983	22.9392	23.0016	19149854.0
2010-05-19	ABTL-DELISTED	Stock	5.25	5.35	4.9	5.15	15153.0
2010-05-19	ABV-DELISTED	Stock	95.49	97.19	94.37	96.62	1098051.0
2010-05-19	ABVA-DELISTED	Stock	2.79	3.12	2.79	2.89	938.0
2010-05-19	ABVT-DELISTED	Stock	46.91	47.325	45.77	46.97	238799.0
2010-05-19	ABX-DELISTED	Stock	43.87	44.09	41.51	42.7	16711770.0
2010-05-19	ACAD	Stock	1.42	1.43	1.34	1.38	292400.0

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

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