PREVIEW / stock_daily / 2007-08-27

all stock daily files

  file:    by_date/stock_daily/2007/2007-08-27.parquet
  size:    176 KB
  rows:    5,475
  symbols: 3,296

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-08-27	AAPL	Stock	4.7639	4.8093	4.7179	4.7232	707439600.0
2007-08-27	MSFT	Stock	28.61	28.77	28.4	28.49	32789500.0
2007-08-27	NVDA	Stock	0.8042	0.8308	0.8005	0.8223	635946000.0
2007-08-27	AMZN	Stock	4.028	4.04	3.921	3.9325	139026000.0
2007-08-27	TLT	Stock	88.28	88.48	88.15	88.31	1585400.0
2007-08-27	CL	Stock	33.605	33.695	33.075	33.115	2760400.0
2007-08-27	A	Stock	25.1216	25.279	24.9428	25.1359	2493193.0
2007-08-27	AABA-DELISTED	Stock	23.59	23.76	23.01	23.03	15090869.0
2007-08-27	AACC-DELISTED	Stock	10.88	10.88	10.71	10.8	91351.0
2007-08-27	AAI-DELISTED	Stock	10.24	10.44	10.13	10.36	1723606.0
2007-08-27	AAIC-DELISTED	Stock	93.0	93.6	90.4	90.4	1279800.0
2007-08-27	AAME	Stock	2.9	3.07	2.84	2.9	4400.0
2007-08-27	AAON	Stock	4.0573	4.1877	3.9763	4.1304	263250.0
2007-08-27	AAP	Stock	35.0	35.34	34.88	35.17	1284300.0
2007-08-27	AATI-DELISTED	Stock	8.86	8.96	8.78	8.93	429799.0
2007-08-27	AAU-DELISTED	Stock	2.2	2.2	2.11	2.12	56500.0
2007-08-27	AAUAF-DELISTED	Stock	2.2	2.2	2.11	2.12	56500.0
2007-08-27	AAV-DELISTED	Stock	11.59	11.62	11.37	11.41	663100.0
2007-08-27	AAWW-DELISTED	Stock	51.14	51.35	50.4	50.57	160453.0
2007-08-27	AAXN-DELISTED	Stock	13.87	14.34	13.76	14.1	1786312.0
2007-08-27	AB	Stock	84.79	85.1	83.21	83.47	160100.0
2007-08-27	ABAX-DELISTED	Stock	20.95	21.04	20.49	20.49	133938.0
2007-08-27	ABB-DELISTED	Stock	23.85	24.09	23.72	23.85	1815342.0
2007-08-27	ABBC-DELISTED	Stock	9.59	9.71	9.47	9.68	104247.0
2007-08-27	ABBNY-DELISTED	Stock	23.85	24.09	23.72	23.85	1860842.0
2007-08-27	ABC-DELISTED	Stock	23.91	24.56	23.82	24.26	1998268.0
2007-08-27	ABCB	Stock	20.0948	20.3087	19.6668	19.8322	26423.0
2007-08-27	ABCO-DELISTED	Stock	28.53	28.66	28.23	28.39	310398.0
2007-08-27	ABCW-DELISTED	Stock	27.24	27.6	27.04	27.37	106690.0
2007-08-27	ABD-DELISTED	Stock	23.83	23.94	23.1	23.34	263400.0
2007-08-27	ABE-DELISTED	Stock	22.17	22.17	21.1	21.59	35100.0
2007-08-27	ABEO	Stock	4187.5	4750.0	4062.5	4375.0	11.0
2007-08-27	ABFS-DELISTED	Stock	35.41	36.17	35.23	35.95	371935.0
2007-08-27	ABG	Stock	21.45	21.7	21.25	21.47	379500.0
2007-08-27	ABK-DELISTED	Stock	63.5	64.66	63.34	63.36	1460406.0
2007-08-27	ABM	Stock	23.41	23.78	23.11	23.22	138800.0
2007-08-27	ABMD-DELISTED	Stock	11.3	11.67	11.2	11.67	147466.0
2007-08-27	ABP-DELISTED	Stock	3.75	3.79	3.61	3.7	68100.0
2007-08-27	ABR	Stock	19.5	19.5	19.19	19.48	165300.0
2007-08-27	ABT	Stock	25.1031	25.1319	24.9016	24.9544	7373906.0
2007-08-27	ABTL-DELISTED	Stock	16.1	16.5	16.1	16.35	12988.0
2007-08-27	ABV-DELISTED	Stock	66.56	66.91	65.44	65.92	463000.0
2007-08-27	ABVA-DELISTED	Stock	9.9	10.04	9.9	9.95	36892.0
2007-08-27	ABX-DELISTED	Stock	32.92	32.92	31.88	32.12	4074900.0
2007-08-27	ACAD	Stock	14.78	14.79	14.43	14.5	159100.0
2007-08-27	ACAP-DELISTED	Stock	40.14	40.14	39.5	40.0	315710.0
2007-08-27	ACAS-DELISTED	Stock	40.99	41.1	40.51	40.69	1075855.0
2007-08-27	ACAT-DELISTED	Stock	17.7	17.86	17.37	17.39	48099.0
2007-08-27	ACC-DELISTED	Stock	27.84	28.1	27.48	27.78	103209.0
2007-08-27	ACCL-DELISTED	Stock	6.27	6.34	6.02	6.23	65437.0

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

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