PREVIEW / stock_daily / 2009-03-06

all stock daily files

  file:    by_date/stock_daily/2009/2009-03-06.parquet
  size:    174 KB
  rows:    5,794
  symbols: 3,471

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-03-06	AAPL	Stock	3.155	3.1571	2.9404	3.0464	1011147200.0
2009-03-06	MSFT	Stock	15.35	15.62	14.87	15.28	92821400.0
2009-03-06	NVDA	Stock	0.2065	0.2172	0.2038	0.2098	974756000.0
2009-03-06	AMZN	Stock	3.26	3.275	2.991	3.0845	301876000.0
2009-03-06	TLT	Stock	104.26	105.97	104.09	104.26	3126181.0
2009-03-06	ES	Stock	20.29	20.55	19.56	20.0	4144300.0
2009-03-06	CL	Stock	28.11	28.655	27.4	28.025	9560000.0
2009-03-06	A	Stock	8.9127	9.3634	8.598	9.0486	6800571.0
2009-03-06	AABA-DELISTED	Stock	12.6	13.18	12.52	13.06	30684051.0
2009-03-06	AACC-DELISTED	Stock	3.33	3.41	3.3	3.4	76822.0
2009-03-06	AACG	Stock	5.0	5.25	4.95	5.25	46100.0
2009-03-06	AAI-DELISTED	Stock	2.58	2.91	2.56	2.9	2962577.0
2009-03-06	AAIC-DELISTED	Stock	2.4	2.8	2.4	2.6	298580.0
2009-03-06	AAME	Stock	0.56	0.56	0.51	0.51	21900.0
2009-03-06	AAON	Stock	2.9906	3.0499	2.9057	3.0163	479925.0
2009-03-06	AAP	Stock	37.38	37.62	35.49	36.43	3822700.0
2009-03-06	AATI-DELISTED	Stock	3.16	3.19	2.85	2.93	196042.0
2009-03-06	AAU-DELISTED	Stock	0.7	0.74	0.7	0.74	43279.0
2009-03-06	AAUAF-DELISTED	Stock	0.7	0.74	0.7	0.74	43279.0
2009-03-06	AAV-DELISTED	Stock	2.0	2.09	1.95	2.078	1206304.0
2009-03-06	AAWW-DELISTED	Stock	10.49	10.85	10.12	10.71	216847.0
2009-03-06	AAXJ	Stock	28.3	28.5	27.51	27.94	35041.0
2009-03-06	AAXN-DELISTED	Stock	3.55	3.83	3.5	3.66	899599.0
2009-03-06	AB	Stock	10.52	10.99	10.33	10.75	841800.0
2009-03-06	ABAX-DELISTED	Stock	16.69	16.87	15.6	16.15	306270.0
2009-03-06	ABB-DELISTED	Stock	11.86	12.09	11.45	11.79	5284670.0
2009-03-06	ABBC-DELISTED	Stock	6.39	6.45	6.18	6.39	101687.0
2009-03-06	ABBNY-DELISTED	Stock	11.86	12.09	11.45	11.8	5292770.0
2009-03-06	ABC-DELISTED	Stock	15.48	15.79	15.12	15.35	5916536.0
2009-03-06	ABCB	Stock	3.6183	3.8906	3.4043	3.8613	22927.0
2009-03-06	ABCO-DELISTED	Stock	7.065	7.135	6.95	7.12	147332.0
2009-03-06	ABCW-DELISTED	Stock	0.42	0.4399	0.41	0.42	103800.0
2009-03-06	ABD-DELISTED	Stock	1.21	1.24	1.04	1.1	421210.0
2009-03-06	ABE-DELISTED	Stock	10.7	10.87	10.6	10.83	26399.0
2009-03-06	ABEO	Stock	1500.0	1625.0	1437.5	1625.0	14.0
2009-03-06	ABFS-DELISTED	Stock	17.47	17.96	16.85	17.2	520094.0
2009-03-06	ABG	Stock	2.18	2.58	2.17	2.4	288500.0
2009-03-06	ABII-DELISTED	Stock	60.07	61.0376	58.95	60.2	15823.0
2009-03-06	ABK-DELISTED	Stock	0.39	0.4	0.36	0.3892	5204319.0
2009-03-06	ABM	Stock	13.25	13.71	13.15	13.48	474600.0
2009-03-06	ABMD-DELISTED	Stock	5.43	5.5	4.67	5.01	801444.0
2009-03-06	ABR	Stock	0.67	0.67	0.6	0.65	112100.0
2009-03-06	ABT	Stock	22.2339	22.6706	22.0756	22.4978	21175490.0
2009-03-06	ABTL-DELISTED	Stock	1.5495	1.5505	1.3505	1.4005	7238.0
2009-03-06	ABV-DELISTED	Stock	40.01	41.5	39.96	41.09	956076.0
2009-03-06	ABVA-DELISTED	Stock	1.45	1.852	1.3	1.852	401.0
2009-03-06	ABX-DELISTED	Stock	29.25	30.06	28.34	28.76	17586130.0
2009-03-06	ACAD	Stock	0.8	0.82	0.76	0.8	66500.0
2009-03-06	ACAP-DELISTED	Stock	38.5	40.35	38.0352	39.59	40928.0
2009-03-06	ACAS-DELISTED	Stock	0.6895	0.7472	0.5704	0.59	6669218.0

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

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