PREVIEW / stock_daily / 2010-05-20

all stock daily files

  file:    by_date/stock_daily/2010/2010-05-20.parquet
  size:    192 KB
  rows:    6,000
  symbols: 3,546

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-20	AAPL	Stock	8.6386	8.7089	8.4361	8.4914	1282915200.0
2010-05-20	MSFT	Stock	27.65	27.84	27.04	27.11	87991100.0
2010-05-20	NVDA	Stock	0.3098	0.319	0.3002	0.3115	1129136000.0
2010-05-20	AMZN	Stock	6.132	6.25	5.939	5.9855	171888000.0
2010-05-20	TLT	Stock	97.91	98.57	97.53	98.33	17667742.0
2010-05-20	ES	Stock	26.12	26.49	25.98	25.98	3131700.0
2010-05-20	CL	Stock	40.53	40.825	40.15	40.15	6360200.0
2010-05-20	A	Stock	22.6967	22.8469	22.1745	22.2031	6588634.0
2010-05-20	AABA-DELISTED	Stock	15.45	15.49	15.055	15.09	32781368.0
2010-05-20	AACC-DELISTED	Stock	7.0	7.11	6.56	6.57	94603.0
2010-05-20	AACG	Stock	3.36	3.4	3.31	3.35	6900.0
2010-05-20	AAI-DELISTED	Stock	5.12	5.15	4.94	4.94	5766238.0
2010-05-20	AAIC-DELISTED	Stock	19.39	19.64	18.08	18.27	85829.0
2010-05-20	AAME	Stock	1.6	1.6	1.56	1.56	5200.0
2010-05-20	AAON	Stock	4.7802	4.8573	4.6657	4.6953	544725.0
2010-05-20	AAP	Stock	48.23	50.21	48.16	48.99	4362400.0
2010-05-20	AATI-DELISTED	Stock	3.42	3.53	3.32	3.35	354368.0
2010-05-20	AAU-DELISTED	Stock	1.04	1.04	0.91	0.9412	404406.0
2010-05-20	AAUAF-DELISTED	Stock	1.04	1.04	0.91	0.9412	404806.0
2010-05-20	AAV-DELISTED	Stock	5.59	5.73	5.5	5.55	688959.0
2010-05-20	AAWW-DELISTED	Stock	48.65	49.825	46.55	46.75	525243.0
2010-05-20	AAXJ	Stock	50.51	51.039	49.881	50.12	1158396.0
2010-05-20	AAXN-DELISTED	Stock	4.75	4.8169	4.52	4.52	1675471.0
2010-05-20	AB	Stock	27.81	27.95	26.81	27.44	903400.0
2010-05-20	ABAX-DELISTED	Stock	24.16	24.16	22.97	23.08	141301.0
2010-05-20	ABB-DELISTED	Stock	16.34	16.49	16.06	16.09	10506409.0
2010-05-20	ABBC-DELISTED	Stock	9.09	9.4	8.85	9.04	127424.0
2010-05-20	ABBNY-DELISTED	Stock	16.34	16.49	16.05	16.05	10707005.0
2010-05-20	ABC-DELISTED	Stock	31.03	31.26	30.59	30.67	6320336.0
2010-05-20	ABCB	Stock	10.6991	10.6991	10.1815	10.291	418986.0
2010-05-20	ABCD-DELISTED	Stock	4.9	4.97	4.7999	4.91	37198.0
2010-05-20	ABCO-DELISTED	Stock	19.14	19.2	18.775	18.935	167614.0
2010-05-20	ABCW-DELISTED	Stock	0.71	0.73	0.6	0.64	163120.0
2010-05-20	ABD-DELISTED	Stock	6.49	6.53	6.19	6.23	401780.0
2010-05-20	ABE-DELISTED	Stock	14.78	14.92	14.5	14.68	23115.0
2010-05-20	ABEO	Stock	3100.0	3100.0	2812.5	2812.5	35.0
2010-05-20	ABFS-DELISTED	Stock	27.21	27.21	25.78	25.97	642479.0
2010-05-20	ABG	Stock	12.53	12.93	12.0	12.11	473800.0
2010-05-20	ABII-DELISTED	Stock	46.5	47.81	44.29	44.39	85209.0
2010-05-20	ABK-DELISTED	Stock	0.99	1.0	0.912	0.995	27278370.0
2010-05-20	ABM	Stock	21.5	21.73	20.66	20.69	224600.0
2010-05-20	ABMD-DELISTED	Stock	9.07	9.15	8.78	9.0	295596.0
2010-05-20	ABR	Stock	3.65	3.7	3.37	3.37	321600.0
2010-05-20	ABT	Stock	22.7761	22.7761	22.2963	22.3011	22637557.0
2010-05-20	ABTL-DELISTED	Stock	4.9523	5.0482	4.7483	4.9977	41835.0
2010-05-20	ABV-DELISTED	Stock	93.93	94.38	91.45	92.09	1125041.0
2010-05-20	ABVA-DELISTED	Stock	2.9	2.9	2.8	2.8	1102.0
2010-05-20	ABVT-DELISTED	Stock	46.49	46.64	44.13	44.27	338200.0
2010-05-20	ABX-DELISTED	Stock	41.67	42.37	40.75	40.92	16995525.0
2010-05-20	ACAD	Stock	1.35	1.36	1.26	1.3	522000.0

> showing 50 of 6,000 rows — these rows as CSV

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