PREVIEW / stock_daily / 2010-04-22

all stock daily files

  file:    by_date/stock_daily/2010/2010-04-22.parquet
  size:    192 KB
  rows:    5,948
  symbols: 3,509

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-04-22	AAPL	Stock	9.2229	9.5268	9.15	9.5168	793424800.0
2010-04-22	MSFT	Stock	31.04	31.53	30.9	31.39	84847600.0
2010-04-22	NVDA	Stock	0.4082	0.418	0.4025	0.4168	656932000.0
2010-04-22	AMZN	Stock	7.3505	7.5545	7.294	7.5045	303316000.0
2010-04-22	TLT	Stock	90.9	91.0882	90.33	90.43	4606513.0
2010-04-22	ES	Stock	27.53	27.81	27.45	27.77	1020100.0
2010-04-22	CL	Stock	41.92	42.15	41.825	41.99	3404000.0
2010-04-22	A	Stock	25.608	26.0944	25.2289	26.0658	4662050.0
2010-04-22	AABA-DELISTED	Stock	17.37	17.78	17.15	17.72	35996506.0
2010-04-22	AACC-DELISTED	Stock	6.83	6.97	6.83	6.97	20210.0
2010-04-22	AACG	Stock	3.45	3.49	3.44	3.44	2100.0
2010-04-22	AAI-DELISTED	Stock	5.33	5.42	5.2	5.35	6033097.0
2010-04-22	AAIC-DELISTED	Stock	20.07	20.46	19.83	20.25	55650.0
2010-04-22	AAON	Stock	4.4741	4.7131	4.3872	4.6795	402469.0
2010-04-22	AAP	Stock	44.59	45.6	44.41	45.49	1215100.0
2010-04-22	AATI-DELISTED	Stock	3.93	4.02	3.92	4.02	125804.0
2010-04-22	AAU-DELISTED	Stock	1.07	1.11	1.06	1.06	59226.0
2010-04-22	AAUAF-DELISTED	Stock	1.07	1.11	1.06	1.06	60326.0
2010-04-22	AAV-DELISTED	Stock	7.18	7.33	7.11	7.3	396363.0
2010-04-22	AAWW-DELISTED	Stock	57.01	59.01	56.86	57.9	307176.0
2010-04-22	AAXJ	Stock	57.64	58.24	57.15	58.12	671375.0
2010-04-22	AAXN-DELISTED	Stock	5.34	5.63	5.32	5.63	1262331.0
2010-04-22	AB	Stock	33.61	33.61	32.9	33.08	240000.0
2010-04-22	ABAX-DELISTED	Stock	25.93	26.66	25.64	26.64	160287.0
2010-04-22	ABB-DELISTED	Stock	20.25	20.69	19.865	20.64	14316290.0
2010-04-22	ABBC-DELISTED	Stock	8.35	8.8	8.29	8.78	26459.0
2010-04-22	ABBNY-DELISTED	Stock	20.25	20.69	19.865	20.67	15661381.0
2010-04-22	ABC-DELISTED	Stock	31.36	31.791	30.76	31.42	8394943.0
2010-04-22	ABCB	Stock	10.6493	11.0773	10.6493	10.9479	169905.0
2010-04-22	ABCD-DELISTED	Stock	5.08	5.33	5.0	5.15	90150.0
2010-04-22	ABCO-DELISTED	Stock	17.197	17.913	17.012	17.908	127198.0
2010-04-22	ABCW-DELISTED	Stock	1.05	1.05	0.8895	0.91	489010.0
2010-04-22	ABD-DELISTED	Stock	7.975	8.335	7.96	8.265	186630.0
2010-04-22	ABE-DELISTED	Stock	16.71	16.966	16.62	16.94	26910.0
2010-04-22	ABEO	Stock	3375.0	3375.0	3287.5	3312.5	13.0
2010-04-22	ABFS-DELISTED	Stock	31.55	32.12	30.92	31.48	983238.0
2010-04-22	ABG	Stock	13.81	15.07	13.76	14.95	377300.0
2010-04-22	ABII-DELISTED	Stock	50.93	51.06	50.57	51.03	25899.0
2010-04-22	ABK-DELISTED	Stock	1.95	2.01	1.86	1.99	38474729.0
2010-04-22	ABM	Stock	21.48	21.87	21.42	21.76	155600.0
2010-04-22	ABMD-DELISTED	Stock	9.6	9.86	9.5175	9.82	156102.0
2010-04-22	ABR	Stock	4.19	4.63	4.09	4.44	701300.0
2010-04-22	ABT	Stock	24.7529	24.7625	24.393	24.5274	16797832.0
2010-04-22	ABTL-DELISTED	Stock	4.8899	4.9848	4.6055	4.7	24905.0
2010-04-22	ABV-DELISTED	Stock	96.86	98.29	95.37	98.22	478244.0
2010-04-22	ABVA-DELISTED	Stock	2.9	2.9	2.868	2.892	6150.0
2010-04-22	ABVT-DELISTED	Stock	50.72	51.1181	50.59	51.03	127055.0
2010-04-22	ABX-DELISTED	Stock	39.11	40.23	38.8	40.17	9188760.0
2010-04-22	ACAD	Stock	1.7	1.76	1.65	1.76	298000.0
2010-04-22	ACAP-DELISTED	Stock	32.24	32.42	32.12	32.36	20071.0

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

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