PREVIEW / stock_daily / 2009-12-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-12-04.parquet
  size:    188 KB
  rows:    5,903
  symbols: 3,500

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-12-04	AAPL	Stock	7.1321	7.1386	6.7957	6.9043	826884800.0
2009-12-04	MSFT	Stock	30.05	30.37	29.83	29.98	58810700.0
2009-12-04	NVDA	Stock	0.3522	0.358	0.3468	0.3565	824564000.0
2009-12-04	AMZN	Stock	7.171	7.1725	6.7555	6.879	296548000.0
2009-12-04	TLT	Stock	93.29	93.65	92.91	93.34	6108059.0
2009-12-04	ES	Stock	24.78	24.85	24.27	24.6	2103400.0
2009-12-04	CL	Stock	43.01	43.365	42.375	42.605	4195400.0
2009-12-04	A	Stock	21.4592	21.8026	21.0658	21.3591	4944726.0
2009-12-04	AABA-DELISTED	Stock	15.32	15.38	15.0	15.2	16704665.0
2009-12-04	AACC-DELISTED	Stock	5.88	6.04	5.815	6.03	43048.0
2009-12-04	AACG	Stock	4.94	4.94	4.94	4.94	100.0
2009-12-04	AAI-DELISTED	Stock	5.0	5.23	4.92	5.16	7619190.0
2009-12-04	AAIC-DELISTED	Stock	13.83	14.02	13.62	13.9	73262.0
2009-12-04	AAON	Stock	3.9032	3.9447	3.7847	3.8044	596362.0
2009-12-04	AAP	Stock	40.7	41.28	40.61	40.92	1466200.0
2009-12-04	AATI-DELISTED	Stock	3.4	3.59	3.3	3.59	350578.0
2009-12-04	AAU-DELISTED	Stock	1.11	1.12	1.03	1.08	963800.0
2009-12-04	AAUAF-DELISTED	Stock	1.11	1.12	1.03	1.08	982587.0
2009-12-04	AAV-DELISTED	Stock	5.82	5.85	5.57	5.62	573415.0
2009-12-04	AAWW-DELISTED	Stock	32.67	34.1	31.94	33.93	599550.0
2009-12-04	AAXJ	Stock	57.03	57.06	55.94	56.52	155296.0
2009-12-04	AAXN-DELISTED	Stock	4.28	4.34	4.24	4.32	380387.0
2009-12-04	AB	Stock	26.43	27.06	26.24	27.02	419300.0
2009-12-04	ABAX-DELISTED	Stock	23.21	23.69	23.11	23.6	94726.0
2009-12-04	ABB-DELISTED	Stock	18.76	18.87	18.33	18.53	4130257.0
2009-12-04	ABBC-DELISTED	Stock	6.87	6.97	6.64	6.97	60622.0
2009-12-04	ABBNY-DELISTED	Stock	18.76	18.87	18.33	18.54	4131332.0
2009-12-04	ABC-DELISTED	Stock	24.73	24.94	24.43	24.68	3853598.0
2009-12-04	ABCB	Stock	6.7433	6.8609	6.6746	6.8511	45709.0
2009-12-04	ABCO-DELISTED	Stock	13.25	13.55	13.05	13.295	171284.0
2009-12-04	ABCW-DELISTED	Stock	0.6995	0.7006	0.6353	0.6905	234190.0
2009-12-04	ABD-DELISTED	Stock	6.88	7.04	6.61	6.89	238190.0
2009-12-04	ABE-DELISTED	Stock	16.9	17.11	16.82	16.89	40579.0
2009-12-04	ABEO	Stock	3800.0	3800.0	3450.0	3712.5	37.0
2009-12-04	ABFS-DELISTED	Stock	26.92	27.9	26.25	27.39	351380.0
2009-12-04	ABG	Stock	11.52	11.63	11.0	11.48	305900.0
2009-12-04	ABII-DELISTED	Stock	36.71	36.715	36.22	36.44	13047.0
2009-12-04	ABK-DELISTED	Stock	0.91	0.92	0.84	0.8524	10976161.0
2009-12-04	ABM	Stock	19.48	19.99	19.28	19.72	208100.0
2009-12-04	ABMD-DELISTED	Stock	8.95	9.1	8.81	8.97	254873.0
2009-12-04	ABR	Stock	1.73	1.77	1.69	1.7	30900.0
2009-12-04	ABT	Stock	26.1827	26.2211	25.6213	25.8036	13122759.0
2009-12-04	ABTL-DELISTED	Stock	4.7	4.85	4.505	4.85	8694.0
2009-12-04	ABV-DELISTED	Stock	99.52	99.77	97.03	98.74	677382.0
2009-12-04	ABVT-DELISTED	Stock	54.75	55.259	53.12	55.12	211436.0
2009-12-04	ABX-DELISTED	Stock	45.32	45.44	41.85	42.63	39537634.0
2009-12-04	ACAD	Stock	1.2	1.25	1.16	1.21	567300.0
2009-12-04	ACAP-DELISTED	Stock	28.49	29.44	28.0499	28.43	66670.0
2009-12-04	ACAS-DELISTED	Stock	2.92	2.99	2.91	2.98	4464535.0
2009-12-04	ACAT-DELISTED	Stock	7.11	7.14	7.05	7.13	11740.0

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

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