PREVIEW / stock_daily / 2007-12-05

all stock daily files

  file:    by_date/stock_daily/2007/2007-12-05.parquet
  size:    180 KB
  rows:    5,602
  symbols: 3,396

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-05	AAPL	Stock	6.5318	6.6429	6.5146	6.625	892402000.0
2007-12-05	MSFT	Stock	33.14	34.52	33.03	34.15	84894700.0
2007-12-05	NVDA	Stock	0.8298	0.8562	0.8195	0.8408	666704000.0
2007-12-05	AMZN	Stock	4.7495	4.7495	4.599	4.6595	132172000.0
2007-12-05	TLT	Stock	94.22	94.47	93.56	93.61	1865912.0
2007-12-05	CL	Stock	39.91	39.995	39.5	39.61	6228400.0
2007-12-05	A	Stock	27.1245	27.3176	26.8383	27.0672	2817669.0
2007-12-05	AABA-DELISTED	Stock	26.62	26.73	25.73	25.94	21170962.0
2007-12-05	AACC-DELISTED	Stock	11.66	11.85	11.45	11.82	233125.0
2007-12-05	AAI-DELISTED	Stock	8.15	8.21	7.99	8.05	1457000.0
2007-12-05	AAIC-DELISTED	Stock	54.8	57.0	53.4	55.0	1399200.0
2007-12-05	AAME	Stock	1.98	2.17	1.74	1.8	39200.0
2007-12-05	AAON	Stock	3.6642	3.7748	3.6444	3.7353	508781.0
2007-12-05	AAP	Stock	37.94	38.32	37.61	37.94	2103900.0
2007-12-05	AATI-DELISTED	Stock	10.47	10.62	10.27	10.35	296907.0
2007-12-05	AAU-DELISTED	Stock	2.41	2.54	2.4	2.45	41100.0
2007-12-05	AAUAF-DELISTED	Stock	2.41	2.54	2.4	2.45	41300.0
2007-12-05	AAV-DELISTED	Stock	10.23	10.3	10.13	10.16	602300.0
2007-12-05	AAWW-DELISTED	Stock	53.04	53.33	52.7	53.08	136295.0
2007-12-05	AAXN-DELISTED	Stock	15.02	15.25	14.93	15.2	1688185.0
2007-12-05	AB	Stock	80.33	81.31	78.3	78.75	327400.0
2007-12-05	ABAX-DELISTED	Stock	32.52	33.5	32.02	33.0399	193323.0
2007-12-05	ABB-DELISTED	Stock	29.0	29.5	28.98	29.27	3783795.0
2007-12-05	ABBC-DELISTED	Stock	8.8	8.8	8.73	8.79	95196.0
2007-12-05	ABBNY-DELISTED	Stock	29.0	29.5	28.98	29.24	3783795.0
2007-12-05	ABC-DELISTED	Stock	22.24	22.67	22.04	22.26	5562946.0
2007-12-05	ABCB	Stock	16.3599	16.7197	16.0778	16.4766	54080.0
2007-12-05	ABCO-DELISTED	Stock	32.0	32.0	31.55	31.96	202423.0
2007-12-05	ABCW-DELISTED	Stock	24.9	25.26	24.3	25.24	58010.0
2007-12-05	ABD-DELISTED	Stock	16.575	16.845	16.355	16.565	487280.0
2007-12-05	ABE-DELISTED	Stock	25.9	27.84	25.9	27.25	24980.0
2007-12-05	ABEO	Stock	3325.0	3375.0	3325.0	3375.0	5.0
2007-12-05	ABFS-DELISTED	Stock	22.48	23.04	22.2	22.58	549157.0
2007-12-05	ABG	Stock	16.59	16.75	16.14	16.35	270000.0
2007-12-05	ABII-DELISTED	Stock	60.23	65.24	59.32	62.85	95902.0
2007-12-05	ABK-DELISTED	Stock	26.76	28.7	22.48	23.5	19408500.0
2007-12-05	ABM	Stock	20.41	20.56	20.03	20.31	335000.0
2007-12-05	ABMD-DELISTED	Stock	12.91	13.13	12.5	12.88	165118.0
2007-12-05	ABP-DELISTED	Stock	3.44	3.6	3.43	3.59	115285.0
2007-12-05	ABR	Stock	17.12	17.5	16.92	17.28	211700.0
2007-12-05	ABT	Stock	27.8044	27.9052	27.5789	27.9052	10698624.0
2007-12-05	ABTL-DELISTED	Stock	15.0	15.2	14.9	15.0	19793.0
2007-12-05	ABV-DELISTED	Stock	76.15	76.41	74.66	74.99	731300.0
2007-12-05	ABVA-DELISTED	Stock	7.37	7.37	7.37	7.37	1800.0
2007-12-05	ABVT-DELISTED	Stock	76.25	77.25	76.25	77.0	14750.0
2007-12-05	ABX-DELISTED	Stock	40.08	40.68	39.35	39.67	6540282.0
2007-12-05	ACAD	Stock	11.63	11.95	11.36	11.77	296200.0
2007-12-05	ACAP-DELISTED	Stock	41.77	43.29	41.73	42.44	70430.0
2007-12-05	ACAS-DELISTED	Stock	36.52	36.76	35.86	36.54	2131678.0
2007-12-05	ACAT-DELISTED	Stock	10.86	11.37	10.86	11.34	137602.0

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

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