PREVIEW / stock_1hour / 2007-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-25.parquet
  size:    736 KB
  rows:    36,220
  symbols: 2,977

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-05-25 09:00:00	AAPL	Stock	4.0	4.0246	3.9929	4.0054	100982672.0
2007-05-25 10:00:00	AAPL	Stock	4.0046	4.0221	3.9821	4.0043	111228096.0
2007-05-25 11:00:00	AAPL	Stock	4.0046	4.0196	4.0039	4.0182	53594632.0
2007-05-25 12:00:00	AAPL	Stock	4.0186	4.0196	4.0046	4.0107	51999976.0
2007-05-25 13:00:00	AAPL	Stock	4.0107	4.0304	4.01	4.0225	58839760.0
2007-05-25 14:00:00	AAPL	Stock	4.0229	4.0529	4.0225	4.0468	93665320.0
2007-05-25 15:00:00	AAPL	Stock	4.0468	4.0636	4.045	4.0579	128775472.0
2007-05-25 16:00:00	AAPL	Stock	4.0582	4.0582	4.0579	4.0579	7138712.0
2007-05-25 09:00:00	MSFT	Stock	30.28	30.32	30.18	30.27	4722032.0
2007-05-25 10:00:00	MSFT	Stock	30.27	30.49	30.23	30.47	7029671.0
2007-05-25 11:00:00	MSFT	Stock	30.48	30.54	30.392	30.471	6195571.0
2007-05-25 12:00:00	MSFT	Stock	30.475	30.49	30.28	30.392	5391462.0
2007-05-25 13:00:00	MSFT	Stock	30.39	30.62	30.37	30.53	4984694.0
2007-05-25 14:00:00	MSFT	Stock	30.53	30.66	30.52	30.64	5032993.0
2007-05-25 15:00:00	MSFT	Stock	30.64	30.65	30.442	30.48	9361975.0
2007-05-25 16:00:00	MSFT	Stock	30.48	30.48	30.47	30.48	1592605.0
2007-05-25 08:00:00	NVDA	Stock	0.5567	0.5567	0.5567	0.5567	115200.0
2007-05-25 09:00:00	NVDA	Stock	0.558	0.5593	0.5547	0.5577	39939000.0
2007-05-25 10:00:00	NVDA	Stock	0.5573	0.5638	0.5565	0.5625	53565660.0
2007-05-25 11:00:00	NVDA	Stock	0.5625	0.563	0.5602	0.5627	32478720.0
2007-05-25 12:00:00	NVDA	Stock	0.5627	0.5628	0.559	0.561	32953860.0
2007-05-25 13:00:00	NVDA	Stock	0.561	0.5617	0.5593	0.5603	36828240.0
2007-05-25 14:00:00	NVDA	Stock	0.5605	0.5625	0.5587	0.5618	27165960.0
2007-05-25 15:00:00	NVDA	Stock	0.562	0.5628	0.5605	0.5608	54367920.0
2007-05-25 16:00:00	NVDA	Stock	0.5608	0.561	0.5603	0.5603	5211720.0
2007-05-25 17:00:00	NVDA	Stock	0.56	0.56	0.5592	0.5592	143100.0
2007-05-25 08:00:00	AMZN	Stock	3.4875	3.4995	3.4855	3.4975	680840.0
2007-05-25 09:00:00	AMZN	Stock	3.495	3.4955	3.425	3.447	41613880.0
2007-05-25 10:00:00	AMZN	Stock	3.447	3.4595	3.4125	3.4265	50120360.0
2007-05-25 11:00:00	AMZN	Stock	3.426	3.4505	3.4185	3.4365	25965380.0
2007-05-25 12:00:00	AMZN	Stock	3.4365	3.4405	3.4225	3.427	15448700.0
2007-05-25 13:00:00	AMZN	Stock	3.4255	3.447	3.4215	3.4325	15926540.0
2007-05-25 14:00:00	AMZN	Stock	3.432	3.441	3.425	3.434	14605480.0
2007-05-25 15:00:00	AMZN	Stock	3.434	3.444	3.425	3.4255	30839300.0
2007-05-25 16:00:00	AMZN	Stock	3.426	3.43	3.4245	3.43	3066560.0
2007-05-25 17:00:00	AMZN	Stock	3.4305	3.435	3.4305	3.435	26000.0
2007-05-25 19:00:00	AMZN	Stock	3.432	3.432	3.432	3.432	2200.0
2007-05-25 09:00:00	TLT	Stock	86.4	86.44	86.36	86.36	73900.0
2007-05-25 10:00:00	TLT	Stock	86.37	86.61	86.33	86.48	273335.0
2007-05-25 11:00:00	TLT	Stock	86.47	86.5	86.39	86.4	84260.0
2007-05-25 12:00:00	TLT	Stock	86.4	86.53	86.39	86.46	70400.0
2007-05-25 13:00:00	TLT	Stock	86.46	86.49	86.36	86.43	127400.0
2007-05-25 14:00:00	TLT	Stock	86.45	86.48	86.43	86.48	16900.0
2007-05-25 15:00:00	TLT	Stock	86.47	86.49	86.38	86.39	104200.0
2007-05-25 16:00:00	TLT	Stock	86.47	86.47	86.37	86.37	4100.0
2007-05-25 08:00:00	CL	Stock	33.5	33.5	33.5	33.5	400.0
2007-05-25 09:00:00	CL	Stock	33.36	33.41	33.3	33.34	253800.0
2007-05-25 10:00:00	CL	Stock	33.33	33.485	33.31	33.46	671600.0
2007-05-25 11:00:00	CL	Stock	33.465	33.5	33.39	33.42	558200.0
2007-05-25 12:00:00	CL	Stock	33.415	33.43	33.355	33.405	511400.0

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

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