PREVIEW / stock_daily / 2007-06-21

all stock daily files

  file:    by_date/stock_daily/2007/2007-06-21.parquet
  size:    176 KB
  rows:    5,417
  symbols: 3,256

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-06-21	AAPL	Stock	4.3464	4.4389	4.3114	4.425	867045200.0
2007-06-21	MSFT	Stock	29.98	30.3	29.91	30.22	56564800.0
2007-06-21	NVDA	Stock	0.6772	0.7222	0.672	0.7163	1297326000.0
2007-06-21	AMZN	Stock	3.458	3.4885	3.433	3.4835	152194000.0
2007-06-21	TLT	Stock	83.54	83.7001	83.21	83.22	850400.0
2007-06-21	CL	Stock	33.15	33.3	32.91	33.14	5888600.0
2007-06-21	A	Stock	27.711	28.0186	27.4249	27.9971	2449436.0
2007-06-21	AABA-DELISTED	Stock	27.69	27.94	27.55	27.65	17087719.0
2007-06-21	AACC-DELISTED	Stock	16.89	16.95	16.538	16.69	162513.0
2007-06-21	AAI-DELISTED	Stock	11.51	11.6	11.3	11.41	1354753.0
2007-06-21	AAIC-DELISTED	Stock	121.0	121.6	115.0	120.4	1751632.0
2007-06-21	AAME	Stock	4.11	4.15	4.08	4.15	12200.0
2007-06-21	AAON	Stock	3.9967	4.0836	3.9243	4.0836	359184.0
2007-06-21	AAP	Stock	40.89	40.91	40.16	40.4	948800.0
2007-06-21	AATI-DELISTED	Stock	9.11	9.65	9.11	9.63	474034.0
2007-06-21	AAU-DELISTED	Stock	2.37	2.38	2.28	2.38	22900.0
2007-06-21	AAUAF-DELISTED	Stock	2.37	2.38	2.28	2.38	22800.0
2007-06-21	AAV-DELISTED	Stock	14.7	15.11	14.58	14.82	1322800.0
2007-06-21	AAWW-DELISTED	Stock	58.07	58.955	57.67	58.6	112511.0
2007-06-21	AAXN-DELISTED	Stock	12.38	12.7	12.22	12.63	2078916.0
2007-06-21	AB	Stock	86.98	88.04	86.46	87.1	334000.0
2007-06-21	ABAX-DELISTED	Stock	21.92	22.11	21.1	21.16	395830.0
2007-06-21	ABB-DELISTED	Stock	22.29	24.31	22.06	22.4	2661800.0
2007-06-21	ABBC-DELISTED	Stock	16.89	16.91	16.67	16.71	23159.0
2007-06-21	ABBNY-DELISTED	Stock	22.29	22.42	22.06	22.4	2662300.0
2007-06-21	ABC-DELISTED	Stock	24.92	25.13	24.76	24.98	1478400.0
2007-06-21	ABCB	Stock	21.544	22.5459	21.544	22.3416	36807.0
2007-06-21	ABCO-DELISTED	Stock	26.66	26.95	26.56	26.89	223044.0
2007-06-21	ABCW-DELISTED	Stock	27.12	27.5	27.12	27.38	224160.0
2007-06-21	ABD-DELISTED	Stock	24.7	24.88	24.25	24.73	199700.0
2007-06-21	ABE-DELISTED	Stock	21.9	21.9899	20.08	21.7	61600.0
2007-06-21	ABEO	Stock	6375.0	6487.5	6375.0	6375.0	4.0
2007-06-21	ABFS-DELISTED	Stock	38.88	39.55	38.79	39.25	346869.0
2007-06-21	ABG	Stock	25.84	26.41	25.75	26.09	340300.0
2007-06-21	ABK-DELISTED	Stock	85.96	86.56	85.41	86.55	1114500.0
2007-06-21	ABM	Stock	25.9	26.15	25.86	26.06	268000.0
2007-06-21	ABMD-DELISTED	Stock	11.68	11.73	11.18	11.18	174520.0
2007-06-21	ABP-DELISTED	Stock	4.24	4.37	4.24	4.28	304700.0
2007-06-21	ABR	Stock	26.6	26.89	25.41	25.99	371600.0
2007-06-21	ABT	Stock	25.9956	26.0387	25.6117	25.8132	9994373.0
2007-06-21	ABTL-DELISTED	Stock	21.0	21.25	20.7	20.9	19638.0
2007-06-21	ABV-DELISTED	Stock	72.01	72.02	69.77	70.29	1533400.0
2007-06-21	ABVA-DELISTED	Stock	13.4	13.51	13.36	13.45	45600.0
2007-06-21	ABX-DELISTED	Stock	29.34	29.58	29.02	29.57	5783961.0
2007-06-21	ACAD	Stock	14.75	14.77	14.2	14.51	723600.0
2007-06-21	ACAP-DELISTED	Stock	40.21	40.56	39.559	40.17	54098.0
2007-06-21	ACAS-DELISTED	Stock	43.92	44.18	43.49	44.15	2851764.0
2007-06-21	ACAT-DELISTED	Stock	20.13	20.24	19.4	19.56	59638.0
2007-06-21	ACC-DELISTED	Stock	28.31	28.31	27.77	28.08	204300.0
2007-06-21	ACCL-DELISTED	Stock	5.85	5.88	5.8	5.85	46729.0

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

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