PREVIEW / stock_1hour / 2008-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-16.parquet
  size:    823 KB
  rows:    39,954
  symbols: 3,294

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
2008-04-16 07:00:00	AAPL	Stock	5.3725	5.4143	5.3718	5.4036	989268.0
2008-04-16 08:00:00	AAPL	Stock	5.4	5.4339	5.3864	5.4246	6266344.0
2008-04-16 09:00:00	AAPL	Stock	5.4229	5.4286	5.2993	5.3996	129528224.0
2008-04-16 10:00:00	AAPL	Stock	5.399	5.4639	5.3986	5.4589	153411636.0
2008-04-16 11:00:00	AAPL	Stock	5.4586	5.4729	5.4439	5.4557	99552376.0
2008-04-16 12:00:00	AAPL	Stock	5.4561	5.4896	5.4532	5.4782	78509788.0
2008-04-16 13:00:00	AAPL	Stock	5.4789	5.4854	5.4554	5.4629	63605388.0
2008-04-16 14:00:00	AAPL	Stock	5.4629	5.4911	5.4554	5.4836	85671460.0
2008-04-16 15:00:00	AAPL	Stock	5.4829	5.5036	5.4821	5.4871	134530312.0
2008-04-16 16:00:00	AAPL	Stock	5.4861	5.5779	5.4518	5.56	26469156.0
2008-04-16 17:00:00	AAPL	Stock	5.5557	5.5643	5.4328	5.5357	1848812.0
2008-04-16 18:00:00	AAPL	Stock	5.5393	5.5454	5.5321	5.5411	291732.0
2008-04-16 19:00:00	AAPL	Stock	5.5411	5.5479	5.5364	5.5382	311528.0
2008-04-16 05:00:00	MSFT	Stock	28.6	29.0	27.0	27.0	650.0
2008-04-16 08:00:00	MSFT	Stock	28.4	28.63	28.4	28.63	34594.0
2008-04-16 09:00:00	MSFT	Stock	28.62	28.66	28.38	28.418	4782601.0
2008-04-16 10:00:00	MSFT	Stock	28.41	28.79	28.38	28.75	8838712.0
2008-04-16 11:00:00	MSFT	Stock	28.75	28.81	28.64	28.7	5859723.0
2008-04-16 12:00:00	MSFT	Stock	28.7	28.81	28.685	28.79	7343897.0
2008-04-16 13:00:00	MSFT	Stock	28.79	28.8	28.58	28.69	5563581.0
2008-04-16 14:00:00	MSFT	Stock	28.69	28.82	28.64	28.782	4911659.0
2008-04-16 15:00:00	MSFT	Stock	28.78	29.05	28.78	28.93	12405309.0
2008-04-16 16:00:00	MSFT	Stock	28.93	29.22	28.67	29.1	3366192.0
2008-04-16 17:00:00	MSFT	Stock	28.99	29.24	28.99	29.18	69126.0
2008-04-16 18:00:00	MSFT	Stock	29.18	29.2	29.15	29.15	9941.0
2008-04-16 19:00:00	MSFT	Stock	29.15	29.25	29.15	29.25	31368.0
2008-04-16 08:00:00	NVDA	Stock	0.4675	0.47	0.4668	0.4698	596600.0
2008-04-16 09:00:00	NVDA	Stock	0.4692	0.477	0.4675	0.471	121097280.0
2008-04-16 10:00:00	NVDA	Stock	0.4713	0.4713	0.4645	0.4692	102401400.0
2008-04-16 11:00:00	NVDA	Stock	0.4692	0.471	0.462	0.4658	112514640.0
2008-04-16 12:00:00	NVDA	Stock	0.466	0.469	0.4648	0.4675	48483720.0
2008-04-16 13:00:00	NVDA	Stock	0.4675	0.4705	0.465	0.4692	55872840.0
2008-04-16 14:00:00	NVDA	Stock	0.4695	0.472	0.468	0.471	48464840.0
2008-04-16 15:00:00	NVDA	Stock	0.471	0.474	0.4692	0.4713	123573760.0
2008-04-16 16:00:00	NVDA	Stock	0.4713	0.4775	0.4691	0.475	26211440.0
2008-04-16 17:00:00	NVDA	Stock	0.4755	0.4768	0.471	0.4763	638040.0
2008-04-16 18:00:00	NVDA	Stock	0.4763	0.478	0.4763	0.4768	248040.0
2008-04-16 19:00:00	NVDA	Stock	0.477	0.478	0.477	0.4778	140000.0
2008-04-16 09:00:00	AMZN	Stock	3.6525	3.6895	3.647	3.686	15202300.0
2008-04-16 10:00:00	AMZN	Stock	3.686	3.7305	3.6625	3.728	25299520.0
2008-04-16 11:00:00	AMZN	Stock	3.728	3.75	3.7	3.7215	16865100.0
2008-04-16 12:00:00	AMZN	Stock	3.7215	3.74	3.7115	3.738	10871520.0
2008-04-16 13:00:00	AMZN	Stock	3.738	3.746	3.722	3.729	9562740.0
2008-04-16 14:00:00	AMZN	Stock	3.728	3.7405	3.716	3.7345	16023860.0
2008-04-16 15:00:00	AMZN	Stock	3.7355	3.75	3.7215	3.727	32972900.0
2008-04-16 16:00:00	AMZN	Stock	3.726	3.8	3.717	3.775	1740140.0
2008-04-16 17:00:00	AMZN	Stock	3.7785	3.7785	3.72	3.72	221380.0
2008-04-16 18:00:00	AMZN	Stock	3.725	3.725	3.725	3.725	2000.0
2008-04-16 19:00:00	AMZN	Stock	3.7375	3.7375	3.7375	3.7375	8000.0
2008-04-16 08:00:00	TLT	Stock	93.75	93.93	93.6	93.65	4825.0

> showing 50 of 39,954 rows — these rows as CSV

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