PREVIEW / stock_daily / 2010-02-23

all stock daily files

  file:    by_date/stock_daily/2010/2010-02-23.parquet
  size:    190 KB
  rows:    5,921
  symbols: 3,497

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-02-23	AAPL	Stock	7.1429	7.1904	6.9896	7.0379	575094800.0
2010-02-23	MSFT	Stock	28.68	28.83	28.09	28.33	52266200.0
2010-02-23	NVDA	Stock	0.4165	0.4182	0.401	0.4053	489764000.0
2010-02-23	AMZN	Stock	5.9005	5.9625	5.8255	5.862	141364000.0
2010-02-23	TLT	Stock	89.34	90.54	89.3	90.47	5476379.0
2010-02-23	ES	Stock	26.63	26.66	26.28	26.33	1257100.0
2010-02-23	CL	Stock	41.065	41.245	40.62	40.945	4416600.0
2010-02-23	A	Stock	22.2389	22.289	21.8383	22.0672	4366373.0
2010-02-23	AABA-DELISTED	Stock	15.43	15.51	15.14	15.38	18178388.0
2010-02-23	AACC-DELISTED	Stock	5.76	5.83	5.65	5.76	22908.0
2010-02-23	AACG	Stock	3.55	3.68	3.48	3.55	14400.0
2010-02-23	AAI-DELISTED	Stock	5.0	5.05	4.93	4.95	2337701.0
2010-02-23	AAIC-DELISTED	Stock	18.25	18.53	18.05	18.37	35373.0
2010-02-23	AAME	Stock	1.43	1.48	1.43	1.48	6100.0
2010-02-23	AAON	Stock	4.316	4.3279	4.2746	4.2884	293625.0
2010-02-23	AAP	Stock	40.18	40.51	40.05	40.22	1653500.0
2010-02-23	AATI-DELISTED	Stock	3.37	3.39	3.12	3.13	1015137.0
2010-02-23	AAU-DELISTED	Stock	0.92	0.9394	0.8942	0.9099	99192.0
2010-02-23	AAUAF-DELISTED	Stock	0.92	0.9394	0.8942	0.9099	98892.0
2010-02-23	AAV-DELISTED	Stock	6.94	7.0	6.89	6.97	512539.0
2010-02-23	AAWW-DELISTED	Stock	39.72	39.95	38.72	39.88	292125.0
2010-02-23	AAXJ	Stock	53.26	53.26	52.18	52.57	184225.0
2010-02-23	AAXN-DELISTED	Stock	7.5	7.7	6.94	6.98	4289077.0
2010-02-23	AB	Stock	26.79	26.86	25.92	25.99	298900.0
2010-02-23	ABAX-DELISTED	Stock	25.84	25.84	25.32	25.43	96401.0
2010-02-23	ABB-DELISTED	Stock	19.95	20.08	19.56	19.67	3799825.0
2010-02-23	ABBC-DELISTED	Stock	7.66	7.67	7.55	7.57	12279.0
2010-02-23	ABBNY-DELISTED	Stock	19.95	20.08	19.56	19.68	3977816.0
2010-02-23	ABC-DELISTED	Stock	27.82	27.97	27.57	27.77	5396218.0
2010-02-23	ABCB	Stock	9.6692	9.6791	9.3828	9.5112	26831.0
2010-02-23	ABCO-DELISTED	Stock	16.245	16.25	15.96	16.19	80404.0
2010-02-23	ABCW-DELISTED	Stock	1.16	1.25	1.16	1.18	61460.0
2010-02-23	ABD-DELISTED	Stock	7.495	7.585	7.245	7.255	468770.0
2010-02-23	ABE-DELISTED	Stock	16.0	16.06	15.9	15.91	5715.0
2010-02-23	ABEO	Stock	3250.0	3375.0	3225.0	3375.0	12.0
2010-02-23	ABFS-DELISTED	Stock	25.3	25.31	24.42	24.54	491266.0
2010-02-23	ABG	Stock	11.56	11.66	11.25	11.47	294100.0
2010-02-23	ABII-DELISTED	Stock	33.35	33.35	32.5	32.68	71723.0
2010-02-23	ABK-DELISTED	Stock	0.7217	0.8	0.705	0.77	26001709.0
2010-02-23	ABM	Stock	20.67	20.8	20.38	20.56	108300.0
2010-02-23	ABMD-DELISTED	Stock	10.01	10.05	9.82	10.04	301650.0
2010-02-23	ABR	Stock	2.51	2.51	2.41	2.41	26100.0
2010-02-23	ABT	Stock	26.0196	26.1347	25.7892	25.8948	13961234.0
2010-02-23	ABTL-DELISTED	Stock	5.3	5.5	5.25	5.25	7500.0
2010-02-23	ABV-DELISTED	Stock	98.48	98.98	96.05	97.09	437902.0
2010-02-23	ABVA-DELISTED	Stock	2.72	2.72	2.49	2.5	8000.0
2010-02-23	ABVT-DELISTED	Stock	61.95	61.99	60.69	61.05	97884.0
2010-02-23	ABX-DELISTED	Stock	38.34	38.53	36.91	37.23	11724572.0
2010-02-23	ACAD	Stock	1.3	1.31	1.27	1.31	254000.0
2010-02-23	ACAP-DELISTED	Stock	28.7	29.45	28.45	28.95	30705.0

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

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