PREVIEW / stock_1hour / 2011-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-12.parquet
  size:    928 KB
  rows:    44,797
  symbols: 3,529

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
2011-12-12 04:00:00	AAPL	Stock	14.0268	14.0268	13.9643	13.9643	58240.0
2011-12-12 05:00:00	AAPL	Stock	13.9643	13.9714	13.9643	13.9714	22400.0
2011-12-12 06:00:00	AAPL	Stock	13.9679	13.9714	13.9643	13.9714	17360.0
2011-12-12 07:00:00	AAPL	Stock	13.9682	14.0714	13.9682	14.0071	535220.0
2011-12-12 08:00:00	AAPL	Stock	14.0071	14.0393	13.9929	14.0179	1356852.0
2011-12-12 09:00:00	AAPL	Stock	14.0179	14.0679	13.9821	14.0118	46924304.0
2011-12-12 10:00:00	AAPL	Stock	14.0114	14.0357	13.9643	13.9905	49743484.0
2011-12-12 11:00:00	AAPL	Stock	13.9904	14.0071	13.9368	13.9542	37221240.0
2011-12-12 12:00:00	AAPL	Stock	13.9518	13.9975	13.9329	13.9821	31313996.0
2011-12-12 13:00:00	AAPL	Stock	13.9825	13.9883	13.9418	13.9682	23419004.0
2011-12-12 14:00:00	AAPL	Stock	13.9664	13.9722	13.9368	13.9493	25126780.0
2011-12-12 15:00:00	AAPL	Stock	13.9489	14.0136	13.9089	13.995	69815564.0
2011-12-12 16:00:00	AAPL	Stock	13.9986	14.0111	13.9524	14.0096	11646068.0
2011-12-12 17:00:00	AAPL	Stock	14.0114	14.0214	14.0096	14.0182	203868.0
2011-12-12 18:00:00	AAPL	Stock	14.0243	14.0375	13.9943	14.02	522676.0
2011-12-12 19:00:00	AAPL	Stock	14.0232	14.0446	13.9811	13.9857	1390116.0
2011-12-12 04:00:00	MSFT	Stock	25.71	25.71	25.71	25.71	400.0
2011-12-12 07:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	100.0
2011-12-12 08:00:00	MSFT	Stock	25.62	25.7	25.58	25.6	77960.0
2011-12-12 09:00:00	MSFT	Stock	25.6	25.63	25.25	25.35	5143840.0
2011-12-12 10:00:00	MSFT	Stock	25.34	25.44	25.3	25.381	5713189.0
2011-12-12 11:00:00	MSFT	Stock	25.39	25.57	25.34	25.4	6168918.0
2011-12-12 12:00:00	MSFT	Stock	25.4	25.5	25.38	25.4	3386111.0
2011-12-12 13:00:00	MSFT	Stock	25.402	25.47	25.37	25.42	2883631.0
2011-12-12 14:00:00	MSFT	Stock	25.43	25.44	25.36	25.402	3719245.0
2011-12-12 15:00:00	MSFT	Stock	25.4	25.57	25.36	25.55	8413322.0
2011-12-12 16:00:00	MSFT	Stock	25.55	25.57	25.348	25.55	2913036.0
2011-12-12 17:00:00	MSFT	Stock	25.53	25.54	25.5	25.5	3159.0
2011-12-12 18:00:00	MSFT	Stock	25.53	25.55	25.5	25.55	110188.0
2011-12-12 19:00:00	MSFT	Stock	25.6	25.6	25.54	25.55	12100.0
2011-12-12 08:00:00	NVDA	Stock	0.3735	0.3735	0.3735	0.3735	19600.0
2011-12-12 09:00:00	NVDA	Stock	0.3675	0.3675	0.359	0.3605	67440360.0
2011-12-12 10:00:00	NVDA	Stock	0.3603	0.3615	0.3575	0.3584	58422800.0
2011-12-12 11:00:00	NVDA	Stock	0.3585	0.3595	0.3565	0.358	98446280.0
2011-12-12 12:00:00	NVDA	Stock	0.3578	0.3612	0.357	0.3609	93940040.0
2011-12-12 13:00:00	NVDA	Stock	0.361	0.3622	0.3588	0.3616	37117040.0
2011-12-12 14:00:00	NVDA	Stock	0.3616	0.363	0.36	0.3615	64312040.0
2011-12-12 15:00:00	NVDA	Stock	0.3615	0.364	0.3602	0.3632	125610440.0
2011-12-12 16:00:00	NVDA	Stock	0.3635	0.3648	0.3602	0.3648	6319000.0
2011-12-12 17:00:00	NVDA	Stock	0.3725	0.3725	0.3635	0.3635	24000.0
2011-12-12 18:00:00	NVDA	Stock	0.3635	0.365	0.3635	0.365	168000.0
2011-12-12 04:00:00	AMZN	Stock	9.6015	9.6015	9.6015	9.6015	2000.0
2011-12-12 05:00:00	AMZN	Stock	9.5775	9.6	9.545	9.545	21000.0
2011-12-12 06:00:00	AMZN	Stock	9.5325	9.5725	9.5325	9.5725	8000.0
2011-12-12 07:00:00	AMZN	Stock	9.5925	9.595	9.5925	9.5945	14000.0
2011-12-12 08:00:00	AMZN	Stock	9.5975	9.628	9.562	9.5745	356760.0
2011-12-12 09:00:00	AMZN	Stock	9.5745	9.5745	9.4555	9.4965	13585900.0
2011-12-12 10:00:00	AMZN	Stock	9.4915	9.5055	9.42	9.4965	14514360.0
2011-12-12 11:00:00	AMZN	Stock	9.4905	9.4975	9.43	9.4585	9809540.0
2011-12-12 12:00:00	AMZN	Stock	9.461	9.4735	9.4215	9.4335	11397020.0

> showing 50 of 44,797 rows — these rows as CSV

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