PREVIEW / stock_1hour / 2010-01-29

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-29.parquet
  size:    907 KB
  rows:    42,711
  symbols: 3,431

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
2010-01-29 04:00:00	AAPL	Stock	7.1279	7.1279	7.1279	7.1279	3500.0
2010-01-29 05:00:00	AAPL	Stock	7.125	7.125	7.125	7.125	5600.0
2010-01-29 06:00:00	AAPL	Stock	7.1425	7.1425	7.1425	7.1425	33600.0
2010-01-29 07:00:00	AAPL	Stock	7.15	7.1621	7.1389	7.1621	406196.0
2010-01-29 08:00:00	AAPL	Stock	7.1554	7.2411	7.1389	7.1929	8703072.0
2010-01-29 09:00:00	AAPL	Stock	7.1921	7.2214	7.1389	7.1696	134432620.0
2010-01-29 10:00:00	AAPL	Stock	7.1711	7.1825	7.0754	7.08	173658660.0
2010-01-29 11:00:00	AAPL	Stock	7.0799	7.0854	6.9321	6.9647	242544764.0
2010-01-29 12:00:00	AAPL	Stock	6.9646	6.9989	6.9516	6.9718	92434272.0
2010-01-29 13:00:00	AAPL	Stock	6.9718	6.9854	6.8614	6.8836	136892672.0
2010-01-29 14:00:00	AAPL	Stock	6.8839	6.8943	6.7946	6.8154	188732684.0
2010-01-29 15:00:00	AAPL	Stock	6.815	6.9014	6.8018	6.8614	236252744.0
2010-01-29 16:00:00	AAPL	Stock	6.8564	7.1525	6.8361	6.8375	19911052.0
2010-01-29 17:00:00	AAPL	Stock	7.1175	7.1275	6.8371	6.8386	825216.0
2010-01-29 18:00:00	AAPL	Stock	6.8393	6.8593	6.8214	6.8321	1037708.0
2010-01-29 19:00:00	AAPL	Stock	6.8282	6.8371	6.8239	6.8357	462868.0
2010-01-29 05:00:00	MSFT	Stock	29.44	29.44	29.44	29.44	100.0
2010-01-29 06:00:00	MSFT	Stock	29.56	29.75	29.45	29.7	8705.0
2010-01-29 07:00:00	MSFT	Stock	29.62	29.8	29.38	29.7	220989.0
2010-01-29 08:00:00	MSFT	Stock	29.7	30.14	29.55	29.95	2996765.0
2010-01-29 09:00:00	MSFT	Stock	29.95	29.96	28.88	28.9	30199284.0
2010-01-29 10:00:00	MSFT	Stock	28.9	29.23	28.55	28.87	36412121.0
2010-01-29 11:00:00	MSFT	Stock	28.87	28.88	28.26	28.57	27831832.0
2010-01-29 12:00:00	MSFT	Stock	28.57	28.72	28.42	28.661	13399414.0
2010-01-29 13:00:00	MSFT	Stock	28.67	28.75	28.18	28.23	13713420.0
2010-01-29 14:00:00	MSFT	Stock	28.23	28.32	27.66	27.82	29065456.0
2010-01-29 15:00:00	MSFT	Stock	27.81	28.25	27.72	28.14	30795745.0
2010-01-29 16:00:00	MSFT	Stock	28.09	28.96	27.946	28.08	6047213.0
2010-01-29 17:00:00	MSFT	Stock	28.839	28.839	28.05	28.05	51197.0
2010-01-29 18:00:00	MSFT	Stock	28.08	28.13	28.07	28.13	12029.0
2010-01-29 19:00:00	MSFT	Stock	28.09	28.15	28.06	28.12	10683.0
2010-01-29 08:00:00	NVDA	Stock	0.4062	0.407	0.4062	0.407	85760.0
2010-01-29 09:00:00	NVDA	Stock	0.4075	0.4112	0.405	0.409	48846400.0
2010-01-29 10:00:00	NVDA	Stock	0.409	0.4095	0.4008	0.4035	85732760.0
2010-01-29 11:00:00	NVDA	Stock	0.4035	0.4043	0.3915	0.3922	149011800.0
2010-01-29 12:00:00	NVDA	Stock	0.3922	0.3933	0.3889	0.392	83919040.0
2010-01-29 13:00:00	NVDA	Stock	0.3918	0.393	0.388	0.3882	52714120.0
2010-01-29 14:00:00	NVDA	Stock	0.3885	0.3885	0.3788	0.3808	152299000.0
2010-01-29 15:00:00	NVDA	Stock	0.3805	0.3862	0.3803	0.3848	167559240.0
2010-01-29 16:00:00	NVDA	Stock	0.3845	0.3938	0.3813	0.3848	14381640.0
2010-01-29 17:00:00	NVDA	Stock	0.3845	0.3845	0.3845	0.3845	14320.0
2010-01-29 18:00:00	NVDA	Stock	0.3848	0.3848	0.3848	0.3848	2913640.0
2010-01-29 19:00:00	NVDA	Stock	0.3845	0.3845	0.3845	0.3845	8000.0
2010-01-29 06:00:00	AMZN	Stock	6.439	6.439	6.425	6.4305	12200.0
2010-01-29 07:00:00	AMZN	Stock	6.45	6.519	6.45	6.463	1117880.0
2010-01-29 08:00:00	AMZN	Stock	6.4835	6.515	6.4265	6.506	9798060.0
2010-01-29 09:00:00	AMZN	Stock	6.506	6.5925	6.4075	6.531	120131060.0
2010-01-29 10:00:00	AMZN	Stock	6.5315	6.534	6.3625	6.488	128101960.0
2010-01-29 11:00:00	AMZN	Stock	6.489	6.55	6.415	6.437	78771220.0
2010-01-29 12:00:00	AMZN	Stock	6.437	6.4876	6.428	6.4515	38912820.0

> showing 50 of 42,711 rows — these rows as CSV

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