PREVIEW / stock_1hour / 2013-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-27.parquet
  size:    1014 KB
  rows:    47,254
  symbols: 3,522

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
2013-08-27 04:00:00	AAPL	Stock	17.9632	17.9643	17.8511	17.8511	112056.0
2013-08-27 05:00:00	AAPL	Stock	17.85	17.8568	17.8214	17.8214	13972.0
2013-08-27 06:00:00	AAPL	Stock	17.8229	17.8229	17.6811	17.7464	220920.0
2013-08-27 07:00:00	AAPL	Stock	17.7411	17.8218	17.7411	17.7946	1144332.0
2013-08-27 08:00:00	AAPL	Stock	17.8	17.8571	17.7411	17.8071	2742908.0
2013-08-27 09:00:00	AAPL	Stock	17.81	17.9393	17.7582	17.9143	62041560.0
2013-08-27 10:00:00	AAPL	Stock	17.9121	17.9468	17.7975	17.8336	47349372.0
2013-08-27 11:00:00	AAPL	Stock	17.8364	17.8821	17.8157	17.8425	21323400.0
2013-08-27 12:00:00	AAPL	Stock	17.8425	17.8425	17.615	17.644	55816236.0
2013-08-27 13:00:00	AAPL	Stock	17.6439	17.6446	17.4384	17.5357	97086388.0
2013-08-27 14:00:00	AAPL	Stock	17.5361	17.5361	17.4029	17.4893	51618252.0
2013-08-27 15:00:00	AAPL	Stock	17.4961	17.5318	17.3679	17.4346	69149444.0
2013-08-27 16:00:00	AAPL	Stock	17.4329	17.8416	17.4	17.4286	11681236.0
2013-08-27 17:00:00	AAPL	Stock	17.4371	17.4395	17.4036	17.4107	381164.0
2013-08-27 18:00:00	AAPL	Stock	17.4168	17.4171	17.4046	17.4082	119000.0
2013-08-27 19:00:00	AAPL	Stock	17.4071	17.4157	17.3982	17.4036	333088.0
2013-08-27 04:00:00	MSFT	Stock	33.8	33.8	33.8	33.8	100.0
2013-08-27 06:00:00	MSFT	Stock	33.87	33.87	33.75	33.75	3900.0
2013-08-27 07:00:00	MSFT	Stock	33.7	33.76	33.68	33.72	15851.0
2013-08-27 08:00:00	MSFT	Stock	33.76	34.25	33.57	33.7	77423.0
2013-08-27 09:00:00	MSFT	Stock	33.7	34.1	33.36	33.893	13542468.0
2013-08-27 10:00:00	MSFT	Stock	33.89	33.916	33.55	33.68	8584271.0
2013-08-27 11:00:00	MSFT	Stock	33.68	33.79	33.575	33.615	6175083.0
2013-08-27 12:00:00	MSFT	Stock	33.61	33.62	33.44	33.55	5446194.0
2013-08-27 13:00:00	MSFT	Stock	33.555	33.58	33.38	33.42	3933062.0
2013-08-27 14:00:00	MSFT	Stock	33.42	33.44	33.24	33.373	5735121.0
2013-08-27 15:00:00	MSFT	Stock	33.375	33.47	33.15	33.23	11064879.0
2013-08-27 16:00:00	MSFT	Stock	33.24	33.578	33.24	33.31	2467907.0
2013-08-27 17:00:00	MSFT	Stock	33.31	33.62	33.25	33.33	3349.0
2013-08-27 18:00:00	MSFT	Stock	33.32	33.34	33.31	33.34	1500.0
2013-08-27 19:00:00	MSFT	Stock	33.34	33.34	33.33	33.33	2265.0
2013-08-27 06:00:00	NVDA	Stock	0.369	0.369	0.369	0.369	12000.0
2013-08-27 08:00:00	NVDA	Stock	0.3688	0.3713	0.3688	0.3713	124000.0
2013-08-27 09:00:00	NVDA	Stock	0.37	0.3736	0.37	0.3728	33895280.0
2013-08-27 10:00:00	NVDA	Stock	0.3728	0.373	0.37	0.372	43238920.0
2013-08-27 11:00:00	NVDA	Stock	0.372	0.3738	0.371	0.372	29578200.0
2013-08-27 12:00:00	NVDA	Stock	0.3718	0.3718	0.37	0.3705	23720480.0
2013-08-27 13:00:00	NVDA	Stock	0.3708	0.3713	0.37	0.3708	29203400.0
2013-08-27 14:00:00	NVDA	Stock	0.3708	0.371	0.3695	0.3708	42089480.0
2013-08-27 15:00:00	NVDA	Stock	0.3709	0.3713	0.3688	0.3698	65025880.0
2013-08-27 16:00:00	NVDA	Stock	0.3698	0.3703	0.3692	0.3698	10249080.0
2013-08-27 17:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	24000.0
2013-08-27 04:00:00	AMZN	Stock	14.2705	14.2705	14.2625	14.2625	14000.0
2013-08-27 05:00:00	AMZN	Stock	14.2625	14.2625	14.2625	14.2625	20000.0
2013-08-27 06:00:00	AMZN	Stock	14.275	14.275	14.225	14.225	100000.0
2013-08-27 07:00:00	AMZN	Stock	14.2325	14.25	14.2325	14.25	26000.0
2013-08-27 08:00:00	AMZN	Stock	14.225	14.3065	14.1745	14.192	475760.0
2013-08-27 09:00:00	AMZN	Stock	14.192	14.264	14.152	14.1745	6525160.0
2013-08-27 10:00:00	AMZN	Stock	14.172	14.2145	14.0562	14.104	8634800.0
2013-08-27 11:00:00	AMZN	Stock	14.1015	14.1475	14.057	14.1282	8665980.0

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

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