PREVIEW / stock_daily / 2009-06-19

all stock daily files

  file:    by_date/stock_daily/2009/2009-06-19.parquet
  size:    181 KB
  rows:    5,751
  symbols: 3,424

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
2009-06-19	AAPL	Stock	4.9311	4.9821	4.8893	4.9814	721856800.0
2009-06-19	MSFT	Stock	24.04	24.34	23.75	24.07	115459000.0
2009-06-19	NVDA	Stock	0.2792	0.2865	0.2758	0.2795	747564000.0
2009-06-19	AMZN	Stock	4.1075	4.173	4.075	4.148	108764000.0
2009-06-19	TLT	Stock	90.33	91.7	90.21	91.69	4750877.0
2009-06-19	ES	Stock	22.39	22.48	21.94	21.97	2076200.0
2009-06-19	CL	Stock	35.695	35.84	35.1	35.285	8596400.0
2009-06-19	A	Stock	13.598	13.6624	13.3763	13.5122	6732628.0
2009-06-19	AABA-DELISTED	Stock	15.54	15.84	15.4	15.77	19831863.0
2009-06-19	AACC-DELISTED	Stock	8.5	8.55	8.16	8.18	132819.0
2009-06-19	AACG	Stock	7.21	7.92	7.21	7.86	153200.0
2009-06-19	AAI-DELISTED	Stock	5.75	5.89	5.63	5.85	1878743.0
2009-06-19	AAIC-DELISTED	Stock	8.4	8.4	7.8	8.0	744995.0
2009-06-19	AAME	Stock	0.72	0.72	0.72	0.72	2400.0
2009-06-19	AAON	Stock	3.8519	3.8637	3.7393	3.7511	355387.0
2009-06-19	AAP	Stock	42.78	43.11	42.31	42.77	2054400.0
2009-06-19	AATI-DELISTED	Stock	4.64	4.79	4.45	4.75	370785.0
2009-06-19	AAU-DELISTED	Stock	0.69	0.69	0.6506	0.66	121232.0
2009-06-19	AAUAF-DELISTED	Stock	0.69	0.69	0.6506	0.66	121332.0
2009-06-19	AAV-DELISTED	Stock	4.93	5.0	4.77	4.89	529117.0
2009-06-19	AAWW-DELISTED	Stock	23.82	23.86	23.38	23.64	229407.0
2009-06-19	AAXJ	Stock	43.79	43.79	43.07	43.36	132070.0
2009-06-19	AAXN-DELISTED	Stock	4.53	4.54	4.455	4.54	703958.0
2009-06-19	AB	Stock	20.74	20.99	20.13	20.38	296600.0
2009-06-19	ABAX-DELISTED	Stock	18.03	19.25	18.01	18.99	410544.0
2009-06-19	ABB-DELISTED	Stock	15.69	15.83	15.61	15.66	4182567.0
2009-06-19	ABBC-DELISTED	Stock	8.84	8.85	8.5	8.82	101578.0
2009-06-19	ABBNY-DELISTED	Stock	15.69	15.83	15.61	15.66	4269567.0
2009-06-19	ABC-DELISTED	Stock	18.59	18.71	18.29	18.32	4156880.0
2009-06-19	ABCB	Stock	6.7502	6.7502	6.2055	6.2735	44312.0
2009-06-19	ABCO-DELISTED	Stock	13.087	13.237	12.693	12.878	290558.0
2009-06-19	ABCW-DELISTED	Stock	1.08	1.1	1.03	1.07	164820.0
2009-06-19	ABD-DELISTED	Stock	3.139	3.3005	3.1289	3.25	480860.0
2009-06-19	ABE-DELISTED	Stock	14.8	14.95	14.55	14.67	53998.0
2009-06-19	ABEO	Stock	2787.5	2787.5	2750.0	2750.0	13.0
2009-06-19	ABFS-DELISTED	Stock	30.79	30.83	29.8	30.14	598108.0
2009-06-19	ABG	Stock	11.01	11.36	10.25	10.31	394300.0
2009-06-19	ABII-DELISTED	Stock	38.39	38.98	38.068	38.5	47400.0
2009-06-19	ABK-DELISTED	Stock	1.27	1.27	1.0	1.13	15353129.0
2009-06-19	ABM	Stock	17.97	18.46	17.44	17.45	322900.0
2009-06-19	ABMD-DELISTED	Stock	8.34	8.51	8.0603	8.29	429342.0
2009-06-19	ABR	Stock	2.01	2.03	1.97	2.0	125300.0
2009-06-19	ABT	Stock	22.9536	23.1551	22.6753	22.8289	30234056.0
2009-06-19	ABTL-DELISTED	Stock	2.25	2.25	2.1477	2.25	4055.0
2009-06-19	ABV-DELISTED	Stock	66.59	66.66	65.14	65.4	762356.0
2009-06-19	ABVA-DELISTED	Stock	2.57	3.01	2.57	3.01	953.0
2009-06-19	ABVT-DELISTED	Stock	77.0	82.5	76.99	80.87	237216.0
2009-06-19	ABX-DELISTED	Stock	33.48	34.31	33.3	34.08	9071462.0
2009-06-19	ACAD	Stock	2.26	2.29	2.22	2.23	216900.0
2009-06-19	ACAP-DELISTED	Stock	39.78	39.8	39.12	39.73	79429.0

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

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