PREVIEW / stock_1hour / 2007-06-19

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-06-19.parquet
  size:    756 KB
  rows:    37,172
  symbols: 3,042

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-19 09:00:00	AAPL	Stock	4.4532	4.4646	4.3975	4.4164	155806728.0
2007-06-19 10:00:00	AAPL	Stock	4.4154	4.4239	4.3896	4.4	170461592.0
2007-06-19 11:00:00	AAPL	Stock	4.4	4.4329	4.3921	4.4318	118349420.0
2007-06-19 12:00:00	AAPL	Stock	4.4318	4.4479	4.4214	4.4311	102407396.0
2007-06-19 13:00:00	AAPL	Stock	4.4304	4.4461	4.4093	4.4279	106456756.0
2007-06-19 14:00:00	AAPL	Stock	4.4275	4.4293	4.3957	4.4132	109200196.0
2007-06-19 15:00:00	AAPL	Stock	4.4132	4.4386	4.4079	4.4164	138341168.0
2007-06-19 16:00:00	AAPL	Stock	4.4182	4.4182	4.4164	4.4164	2359644.0
2007-06-19 09:00:00	MSFT	Stock	30.48	30.54	30.41	30.48	3426110.0
2007-06-19 10:00:00	MSFT	Stock	30.47	30.52	30.38	30.45	6566147.0
2007-06-19 11:00:00	MSFT	Stock	30.45	30.49	30.399	30.47	4678025.0
2007-06-19 12:00:00	MSFT	Stock	30.47	30.59	30.44	30.56	5042023.0
2007-06-19 13:00:00	MSFT	Stock	30.562	30.66	30.49	30.527	4241287.0
2007-06-19 14:00:00	MSFT	Stock	30.52	30.55	30.42	30.47	5468281.0
2007-06-19 15:00:00	MSFT	Stock	30.48	30.51	30.42	30.46	9381348.0
2007-06-19 16:00:00	MSFT	Stock	30.46	30.46	30.46	30.46	4392682.0
2007-06-19 08:00:00	NVDA	Stock	0.6595	0.6615	0.6527	0.6567	189240.0
2007-06-19 09:00:00	NVDA	Stock	0.6533	0.6592	0.6508	0.6527	77903760.0
2007-06-19 10:00:00	NVDA	Stock	0.6527	0.6577	0.652	0.6552	76492080.0
2007-06-19 11:00:00	NVDA	Stock	0.655	0.6565	0.6537	0.6555	54335520.0
2007-06-19 12:00:00	NVDA	Stock	0.6555	0.6608	0.6555	0.6597	59093160.0
2007-06-19 13:00:00	NVDA	Stock	0.6598	0.6637	0.6587	0.6592	51678900.0
2007-06-19 14:00:00	NVDA	Stock	0.6592	0.6608	0.658	0.6603	63320700.0
2007-06-19 15:00:00	NVDA	Stock	0.6603	0.6652	0.66	0.6637	86811900.0
2007-06-19 16:00:00	NVDA	Stock	0.6637	0.6642	0.6637	0.6642	2968980.0
2007-06-19 17:00:00	NVDA	Stock	0.6637	0.6658	0.6637	0.6658	1148760.0
2007-06-19 18:00:00	NVDA	Stock	0.6658	0.6658	0.6658	0.6658	6420.0
2007-06-19 19:00:00	NVDA	Stock	0.664	0.6658	0.664	0.6658	53400.0
2007-06-19 08:00:00	AMZN	Stock	3.575	3.585	3.572	3.575	121460.0
2007-06-19 09:00:00	AMZN	Stock	3.5725	3.5845	3.56	3.579	12933580.0
2007-06-19 10:00:00	AMZN	Stock	3.578	3.583	3.56	3.5695	28600600.0
2007-06-19 11:00:00	AMZN	Stock	3.57	3.572	3.5415	3.5425	19098640.0
2007-06-19 12:00:00	AMZN	Stock	3.541	3.575	3.54	3.56	22698680.0
2007-06-19 13:00:00	AMZN	Stock	3.56	3.5604	3.5285	3.5305	18892200.0
2007-06-19 14:00:00	AMZN	Stock	3.5305	3.531	3.509	3.5195	24359920.0
2007-06-19 15:00:00	AMZN	Stock	3.519	3.5265	3.484	3.4905	46323400.0
2007-06-19 16:00:00	AMZN	Stock	3.4875	3.4935	3.486	3.49	2036400.0
2007-06-19 17:00:00	AMZN	Stock	3.4905	3.494	3.49	3.494	274700.0
2007-06-19 18:00:00	AMZN	Stock	3.4915	3.494	3.4915	3.4935	94000.0
2007-06-19 19:00:00	AMZN	Stock	3.4925	3.4925	3.492	3.492	40000.0
2007-06-19 09:00:00	TLT	Stock	83.82	83.93	83.72	83.93	618900.0
2007-06-19 10:00:00	TLT	Stock	83.93	83.96	83.8	83.82	1153100.0
2007-06-19 11:00:00	TLT	Stock	83.82	83.99	83.81	83.93	546500.0
2007-06-19 12:00:00	TLT	Stock	83.93	84.13	83.88	84.13	493600.0
2007-06-19 13:00:00	TLT	Stock	84.14	84.22	84.07	84.17	308000.0
2007-06-19 14:00:00	TLT	Stock	84.15	84.25	84.13	84.22	266900.0
2007-06-19 15:00:00	TLT	Stock	84.24	84.45	84.24	84.32	1007165.0
2007-06-19 16:00:00	TLT	Stock	84.32	84.32	84.28	84.3	16800.0
2007-06-19 09:00:00	CL	Stock	33.09	33.09	32.888	32.89	439800.0
2007-06-19 10:00:00	CL	Stock	32.89	32.985	32.865	32.95	592200.0

> showing 50 of 37,172 rows — these rows as CSV

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