PREVIEW / stock_daily / 2009-11-04

all stock daily files

  file:    by_date/stock_daily/2009/2009-11-04.parquet
  size:    186 KB
  rows:    5,850
  symbols: 3,472

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-11-04	AAPL	Stock	6.8118	6.9232	6.7939	6.8146	487530400.0
2009-11-04	MSFT	Stock	27.69	28.39	27.62	28.06	63898400.0
2009-11-04	NVDA	Stock	0.3025	0.3058	0.2982	0.2995	916840000.0
2009-11-04	AMZN	Stock	5.95	5.9625	5.838	5.855	152350000.0
2009-11-04	TLT	Stock	93.61	94.07	92.8	93.24	5349708.0
2009-11-04	ES	Stock	22.74	23.06	22.56	22.75	2266400.0
2009-11-04	CL	Stock	38.835	39.51	38.715	39.165	5717600.0
2009-11-04	A	Stock	17.9828	18.2976	17.8827	17.9185	4399226.0
2009-11-04	AABA-DELISTED	Stock	15.84	15.91	15.66	15.7	18590867.0
2009-11-04	AACC-DELISTED	Stock	6.01	6.11	5.31	5.34	153614.0
2009-11-04	AACG	Stock	5.13	5.13	5.1	5.1	10300.0
2009-11-04	AAI-DELISTED	Stock	4.34	4.34	4.12	4.13	4547904.0
2009-11-04	AAIC-DELISTED	Stock	12.12	12.92	11.87	12.47	50150.0
2009-11-04	AAON	Stock	3.7847	3.7847	3.68	3.7175	1261069.0
2009-11-04	AAP	Stock	38.84	38.99	37.41	37.42	3611000.0
2009-11-04	AATI-DELISTED	Stock	3.09	3.1	2.98	2.99	473984.0
2009-11-04	AAU-DELISTED	Stock	0.73	0.75	0.71	0.72	267649.0
2009-11-04	AAUAF-DELISTED	Stock	0.73	0.75	0.71	0.72	268249.0
2009-11-04	AAV-DELISTED	Stock	6.36	6.54	6.17	6.26	857376.0
2009-11-04	AAWW-DELISTED	Stock	26.47	27.55	26.06	26.11	1209814.0
2009-11-04	AAXJ	Stock	52.74	53.08	52.21	52.42	112132.0
2009-11-04	AAXN-DELISTED	Stock	4.09	4.09	3.95	3.96	587438.0
2009-11-04	AB	Stock	26.66	27.5	26.23	27.03	1057300.0
2009-11-04	ABAX-DELISTED	Stock	22.815	23.37	22.8	23.02	123296.0
2009-11-04	ABB-DELISTED	Stock	19.06	19.27	18.91	18.96	3891734.0
2009-11-04	ABBC-DELISTED	Stock	6.63	6.71	6.44	6.47	131376.0
2009-11-04	ABBNY-DELISTED	Stock	19.06	19.27	18.91	18.92	3893884.0
2009-11-04	ABC-DELISTED	Stock	23.38	23.54	23.14	23.15	3635460.0
2009-11-04	ABCB	Stock	5.8514	6.1258	5.1652	5.1652	54687.0
2009-11-04	ABCO-DELISTED	Stock	12.755	12.93	12.505	12.585	90215.0
2009-11-04	ABCW-DELISTED	Stock	0.65	0.69	0.65	0.66	41130.0
2009-11-04	ABD-DELISTED	Stock	6.43	6.47	5.92	5.93	196190.0
2009-11-04	ABE-DELISTED	Stock	16.3	16.36	16.12	16.2	31230.0
2009-11-04	ABEO	Stock	3875.0	4050.0	3750.0	3875.0	8.0
2009-11-04	ABFS-DELISTED	Stock	24.6	24.79	23.32	23.4	564361.0
2009-11-04	ABG	Stock	10.77	11.04	10.06	10.13	336700.0
2009-11-04	ABII-DELISTED	Stock	33.48	35.43	32.94	33.49	71166.0
2009-11-04	ABK-DELISTED	Stock	1.43	1.62	1.36	1.49	91877041.0
2009-11-04	ABM	Stock	18.88	18.97	18.35	18.35	229500.0
2009-11-04	ABMD-DELISTED	Stock	9.16	9.29	8.85	8.87	168682.0
2009-11-04	ABR	Stock	2.12	2.25	1.92	2.0	145600.0
2009-11-04	ABT	Stock	24.2299	24.7097	24.2299	24.4266	11546061.0
2009-11-04	ABTL-DELISTED	Stock	3.7	4.0	3.7	3.9	13024.0
2009-11-04	ABV-DELISTED	Stock	93.12	94.38	91.87	92.36	630132.0
2009-11-04	ABVA-DELISTED	Stock	2.23	2.23	2.23	2.23	500.0
2009-11-04	ABVT-DELISTED	Stock	48.85	49.25	48.16	48.36	87737.0
2009-11-04	ABX-DELISTED	Stock	39.56	40.88	39.36	40.3	25814252.0
2009-11-04	ACAD	Stock	1.29	1.36	1.24	1.28	324200.0
2009-11-04	ACAP-DELISTED	Stock	28.78	28.95	28.17	28.36	35737.0
2009-11-04	ACAS-DELISTED	Stock	3.26	3.3601	2.71	2.78	20251274.0

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

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