PREVIEW / stock_1hour / 2011-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-30.parquet
  size:    991 KB
  rows:    47,470
  symbols: 3,566

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-11-30 05:00:00	AAPL	Stock	13.2875	13.2875	13.2875	13.2875	5600.0
2011-11-30 06:00:00	AAPL	Stock	13.2993	13.4625	13.2993	13.4625	16800.0
2011-11-30 07:00:00	AAPL	Stock	13.42	13.4379	13.3821	13.3982	238000.0
2011-11-30 08:00:00	AAPL	Stock	13.3961	13.6375	13.3839	13.6075	9522072.0
2011-11-30 09:00:00	AAPL	Stock	13.615	13.635	13.5279	13.5607	68769092.0
2011-11-30 10:00:00	AAPL	Stock	13.5625	13.6161	13.5107	13.6007	71529304.0
2011-11-30 11:00:00	AAPL	Stock	13.6036	13.61	13.5443	13.5643	36926120.0
2011-11-30 12:00:00	AAPL	Stock	13.5643	13.5714	13.5304	13.5579	30391732.0
2011-11-30 13:00:00	AAPL	Stock	13.5571	13.5671	13.5183	13.5229	24411716.0
2011-11-30 14:00:00	AAPL	Stock	13.5236	13.5714	13.5236	13.5629	27426168.0
2011-11-30 15:00:00	AAPL	Stock	13.5625	13.6429	13.5461	13.6414	87742004.0
2011-11-30 16:00:00	AAPL	Stock	13.6414	13.6596	13.564	13.6464	39869452.0
2011-11-30 17:00:00	AAPL	Stock	13.6461	13.65	13.6429	13.6457	1122604.0
2011-11-30 18:00:00	AAPL	Stock	13.6457	13.6518	13.6432	13.6454	240800.0
2011-11-30 19:00:00	AAPL	Stock	13.6432	13.6432	13.6357	13.6375	112168.0
2011-11-30 04:00:00	MSFT	Stock	24.88	24.88	24.88	24.88	400.0
2011-11-30 06:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2011-11-30 07:00:00	MSFT	Stock	25.08	25.08	24.97	25.04	6799.0
2011-11-30 08:00:00	MSFT	Stock	25.0	25.58	25.0	25.5	205408.0
2011-11-30 09:00:00	MSFT	Stock	25.5	25.55	25.14	25.29	9081403.0
2011-11-30 10:00:00	MSFT	Stock	25.29	25.565	25.28	25.52	12257491.0
2011-11-30 11:00:00	MSFT	Stock	25.52	25.54	25.35	25.402	7957368.0
2011-11-30 12:00:00	MSFT	Stock	25.41	25.52	25.39	25.47	4747684.0
2011-11-30 13:00:00	MSFT	Stock	25.47	25.51	25.32	25.37	6122650.0
2011-11-30 14:00:00	MSFT	Stock	25.36	25.47	25.33	25.402	5011597.0
2011-11-30 15:00:00	MSFT	Stock	25.401	25.58	25.36	25.55	18716053.0
2011-11-30 16:00:00	MSFT	Stock	25.55	25.603	25.387	25.51	15593968.0
2011-11-30 17:00:00	MSFT	Stock	25.58	25.58	25.5	25.5	146928.0
2011-11-30 18:00:00	MSFT	Stock	25.48	25.58	25.47	25.48	45370.0
2011-11-30 19:00:00	MSFT	Stock	25.49	25.49	25.46	25.48	2492.0
2011-11-30 07:00:00	NVDA	Stock	0.3788	0.3788	0.3788	0.3788	40000.0
2011-11-30 08:00:00	NVDA	Stock	0.3743	0.3855	0.3743	0.3855	1496160.0
2011-11-30 09:00:00	NVDA	Stock	0.385	0.3885	0.3808	0.3873	106315360.0
2011-11-30 10:00:00	NVDA	Stock	0.3873	0.3888	0.3839	0.3882	130517120.0
2011-11-30 11:00:00	NVDA	Stock	0.3882	0.389	0.3862	0.389	62886520.0
2011-11-30 12:00:00	NVDA	Stock	0.3888	0.3913	0.3882	0.3909	51128160.0
2011-11-30 13:00:00	NVDA	Stock	0.3908	0.3918	0.3873	0.3878	61866920.0
2011-11-30 14:00:00	NVDA	Stock	0.3878	0.39	0.386	0.3868	76952040.0
2011-11-30 15:00:00	NVDA	Stock	0.3868	0.3918	0.3862	0.3908	168716640.0
2011-11-30 16:00:00	NVDA	Stock	0.3908	0.3913	0.3858	0.3908	16646360.0
2011-11-30 17:00:00	NVDA	Stock	0.3908	0.3928	0.3908	0.3928	855040.0
2011-11-30 18:00:00	NVDA	Stock	0.3895	0.393	0.3895	0.3908	182720.0
2011-11-30 19:00:00	NVDA	Stock	0.3908	0.3928	0.3908	0.3928	41040.0
2011-11-30 06:00:00	AMZN	Stock	9.4575	9.4575	9.4575	9.4575	2000.0
2011-11-30 07:00:00	AMZN	Stock	9.521	9.569	9.488	9.51	23800.0
2011-11-30 08:00:00	AMZN	Stock	9.5005	9.75	9.5005	9.745	1472440.0
2011-11-30 09:00:00	AMZN	Stock	9.7375	9.78	9.456	9.472	31809940.0
2011-11-30 10:00:00	AMZN	Stock	9.4725	9.6245	9.4375	9.5755	34250760.0
2011-11-30 11:00:00	AMZN	Stock	9.5815	9.7016	9.526	9.5525	14013540.0
2011-11-30 12:00:00	AMZN	Stock	9.555	9.584	9.5325	9.5405	7461860.0

> showing 50 of 47,470 rows — these rows as CSV

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