PREVIEW / stock_daily / 2007-12-19

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-19.parquet
  size:    181 KB
  rows:    5,635
  symbols: 3,409

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
2007-12-19	AAPL	Stock	6.535	6.5943	6.4607	6.54	827478400.0
2007-12-19	MSFT	Stock	34.69	35.14	34.38	34.79	58469100.0
2007-12-19	NVDA	Stock	0.8502	0.8692	0.8468	0.8612	253536000.0
2007-12-19	AMZN	Stock	4.347	4.4975	4.3415	4.469	152324000.0
2007-12-19	TLT	Stock	92.4	93.56	91.88	93.23	2252350.0
2007-12-19	CL	Stock	39.095	39.1	38.745	38.98	5624000.0
2007-12-19	A	Stock	25.1144	25.5794	25.1001	25.3934	3035617.0
2007-12-19	AABA-DELISTED	Stock	22.95	23.69	22.92	23.3	26547988.0
2007-12-19	AACC-DELISTED	Stock	10.44	10.6	10.33	10.48	142681.0
2007-12-19	AAI-DELISTED	Stock	7.85	7.93	7.67	7.93	1174800.0
2007-12-19	AAIC-DELISTED	Stock	55.8	60.4	55.6	59.2	1143700.0
2007-12-19	AAME	Stock	1.45	1.45	1.41	1.43	14800.0
2007-12-19	AAON	Stock	3.9506	3.9605	3.8775	3.917	522956.0
2007-12-19	AAP	Stock	37.77	38.29	36.63	38.03	1392000.0
2007-12-19	AATI-DELISTED	Stock	11.01	11.38	10.95	11.38	269903.0
2007-12-19	AAU-DELISTED	Stock	2.31	2.4	2.3	2.3	31800.0
2007-12-19	AAUAF-DELISTED	Stock	2.31	2.4	2.3	2.3	31900.0
2007-12-19	AAV-DELISTED	Stock	9.23	9.3	9.18	9.27	1154195.0
2007-12-19	AAWW-DELISTED	Stock	53.16	53.62	52.93	53.25	103264.0
2007-12-19	AAXN-DELISTED	Stock	14.51	14.85	14.3	14.68	750362.0
2007-12-19	AB	Stock	79.92	79.92	77.34	77.56	269800.0
2007-12-19	ABAX-DELISTED	Stock	35.95	37.2	35.33	36.67	131148.0
2007-12-19	ABB-DELISTED	Stock	27.26	27.35	26.8	27.02	2603544.0
2007-12-19	ABBC-DELISTED	Stock	8.99	9.06	8.99	9.06	70807.0
2007-12-19	ABBNY-DELISTED	Stock	27.26	27.35	26.8	27.04	2603544.0
2007-12-19	ABC-DELISTED	Stock	21.86	21.94	21.54	21.64	2727086.0
2007-12-19	ABCB	Stock	16.1459	17.1477	15.8249	16.4377	138386.0
2007-12-19	ABCO-DELISTED	Stock	31.38	32.21	31.38	31.96	145013.0
2007-12-19	ABCW-DELISTED	Stock	24.3	24.5	23.37	23.71	59480.0
2007-12-19	ABD-DELISTED	Stock	16.325	16.475	16.085	16.365	174410.0
2007-12-19	ABE-DELISTED	Stock	25.09	25.8899	25.09	25.65	10601.0
2007-12-19	ABEO	Stock	2875.0	3375.0	2875.0	3375.0	10.0
2007-12-19	ABFS-DELISTED	Stock	22.28	22.39	21.59	21.78	733558.0
2007-12-19	ABG	Stock	15.23	15.34	14.73	14.86	247300.0
2007-12-19	ABII-DELISTED	Stock	71.0	71.7	69.76	71.0	41245.0
2007-12-19	ABK-DELISTED	Stock	26.68	28.49	24.61	27.47	12357923.0
2007-12-19	ABM	Stock	20.02	20.09	19.48	19.74	413800.0
2007-12-19	ABMD-DELISTED	Stock	15.0	15.4	14.54	15.0	436218.0
2007-12-19	ABP-DELISTED	Stock	3.44	3.45	3.31	3.41	194900.0
2007-12-19	ABR	Stock	17.0	17.0	16.65	16.94	152300.0
2007-12-19	ABT	Stock	27.6269	27.8284	27.3294	27.459	7530221.0
2007-12-19	ABTL-DELISTED	Stock	14.55	15.001	14.55	14.8	12089.0
2007-12-19	ABV-DELISTED	Stock	70.75	71.97	70.32	70.77	666699.0
2007-12-19	ABVA-DELISTED	Stock	6.46	6.6	6.45	6.51	27109.0
2007-12-19	ABVT-DELISTED	Stock	68.0	76.0	68.0	76.0	58596.0
2007-12-19	ABX-DELISTED	Stock	38.24	38.33	37.4	37.63	4614582.0
2007-12-19	ACAD	Stock	11.52	11.82	11.3	11.78	267500.0
2007-12-19	ACAP-DELISTED	Stock	42.42	43.68	42.42	43.2	72029.0
2007-12-19	ACAS-DELISTED	Stock	33.3	34.44	33.3	34.2	2636446.0
2007-12-19	ACAT-DELISTED	Stock	12.54	12.65	12.46	12.58	80831.0

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

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