PREVIEW / stock_1hour / 2007-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-07.parquet
  size:    757 KB
  rows:    36,906
  symbols: 3,019

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2007-06-07 09:00:00	AAPL	Stock	4.4639	4.5411	4.4157	4.5339	282585072.0
2007-06-07 10:00:00	AAPL	Stock	4.5339	4.5575	4.515	4.5514	320962348.0
2007-06-07 11:00:00	AAPL	Stock	4.5514	4.5536	4.4993	4.5086	260811936.0
2007-06-07 12:00:00	AAPL	Stock	4.5082	4.5229	4.4804	4.4975	176706040.0
2007-06-07 13:00:00	AAPL	Stock	4.4979	4.5318	4.42	4.4732	275832536.0
2007-06-07 14:00:00	AAPL	Stock	4.4732	4.48	4.3996	4.4643	265882764.0
2007-06-07 15:00:00	AAPL	Stock	4.4636	4.4882	4.3929	4.4293	270674628.0
2007-06-07 16:00:00	AAPL	Stock	4.4293	4.4311	4.4293	4.431	10100300.0
2007-06-07 09:00:00	MSFT	Stock	30.02	30.29	30.0	30.21	7452192.0
2007-06-07 10:00:00	MSFT	Stock	30.2	30.22	30.04	30.13	8951629.0
2007-06-07 11:00:00	MSFT	Stock	30.13	30.17	30.05	30.13	5857759.0
2007-06-07 12:00:00	MSFT	Stock	30.13	30.18	29.94	30.03	7038683.0
2007-06-07 13:00:00	MSFT	Stock	30.03	30.07	29.66	29.767	11451845.0
2007-06-07 14:00:00	MSFT	Stock	29.77	29.86	29.72	29.78	8276267.0
2007-06-07 15:00:00	MSFT	Stock	29.78	29.91	29.59	29.6	15820585.0
2007-06-07 16:00:00	MSFT	Stock	29.6	29.62	29.6	29.62	1239338.0
2007-06-07 08:00:00	NVDA	Stock	0.613	0.613	0.6018	0.6018	108000.0
2007-06-07 09:00:00	NVDA	Stock	0.6025	0.6122	0.602	0.6083	69158340.0
2007-06-07 10:00:00	NVDA	Stock	0.6085	0.6125	0.6048	0.6083	122137320.0
2007-06-07 11:00:00	NVDA	Stock	0.6083	0.6085	0.6048	0.606	120193440.0
2007-06-07 12:00:00	NVDA	Stock	0.606	0.607	0.6048	0.6063	92958480.0
2007-06-07 13:00:00	NVDA	Stock	0.6063	0.6067	0.6022	0.6055	141595200.0
2007-06-07 14:00:00	NVDA	Stock	0.6053	0.6055	0.6003	0.6033	106809180.0
2007-06-07 15:00:00	NVDA	Stock	0.6034	0.607	0.5997	0.5998	121800240.0
2007-06-07 16:00:00	NVDA	Stock	0.6003	0.602	0.5998	0.6	3283500.0
2007-06-07 17:00:00	NVDA	Stock	0.5998	0.5998	0.5998	0.5998	149340.0
2007-06-07 19:00:00	NVDA	Stock	0.6002	0.6002	0.5998	0.5998	241140.0
2007-06-07 06:00:00	AMZN	Stock	3.62	3.62	3.62	3.62	7060.0
2007-06-07 07:00:00	AMZN	Stock	3.625	3.635	3.625	3.635	20500.0
2007-06-07 08:00:00	AMZN	Stock	3.6425	3.6425	3.62	3.6265	283480.0
2007-06-07 09:00:00	AMZN	Stock	3.625	3.731	3.5575	3.7165	74124560.0
2007-06-07 10:00:00	AMZN	Stock	3.716	3.736	3.69	3.7095	85300820.0
2007-06-07 11:00:00	AMZN	Stock	3.709	3.7095	3.658	3.6664	68338680.0
2007-06-07 12:00:00	AMZN	Stock	3.6655	3.684	3.6305	3.6505	45721600.0
2007-06-07 13:00:00	AMZN	Stock	3.6505	3.6555	3.5845	3.606	62902980.0
2007-06-07 14:00:00	AMZN	Stock	3.605	3.6065	3.544	3.5955	67194440.0
2007-06-07 15:00:00	AMZN	Stock	3.5945	3.635	3.5865	3.6025	69792240.0
2007-06-07 16:00:00	AMZN	Stock	3.6025	3.603	3.5955	3.602	4273560.0
2007-06-07 17:00:00	AMZN	Stock	3.602	3.6065	3.6	3.605	135540.0
2007-06-07 18:00:00	AMZN	Stock	3.604	3.6065	3.599	3.599	200400.0
2007-06-07 19:00:00	AMZN	Stock	3.6	3.602	3.5955	3.5955	170500.0
2007-06-07 09:00:00	TLT	Stock	84.63	84.71	84.57	84.6	450700.0
2007-06-07 10:00:00	TLT	Stock	84.6	84.69	84.08	84.2	1121100.0
2007-06-07 11:00:00	TLT	Stock	84.19	84.37	84.16	84.22	507700.0
2007-06-07 12:00:00	TLT	Stock	84.23	84.25	83.73	83.92	720484.0
2007-06-07 13:00:00	TLT	Stock	83.92	84.13	83.82	84.06	522490.0
2007-06-07 14:00:00	TLT	Stock	84.06	84.25	84.0	84.05	845800.0
2007-06-07 15:00:00	TLT	Stock	84.07	84.1	83.9	83.96	633800.0
2007-06-07 16:00:00	TLT	Stock	83.96	83.96	83.87	83.87	44600.0
2007-06-07 09:00:00	CL	Stock	33.125	33.17	33.03	33.085	269400.0

> showing 50 of 36,906 rows — these rows as CSV

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