PREVIEW / stock_1hour / 2014-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-18.parquet
  size:    1.0 MB
  rows:    48,261
  symbols: 3,560

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
2014-07-18 04:00:00	AAPL	Stock	23.285	23.33	23.285	23.285	7032.0
2014-07-18 06:00:00	AAPL	Stock	23.2825	23.3625	23.2825	23.3625	35936.0
2014-07-18 07:00:00	AAPL	Stock	23.3725	23.425	23.35	23.3775	216908.0
2014-07-18 08:00:00	AAPL	Stock	23.375	23.4325	23.27	23.3725	802452.0
2014-07-18 09:00:00	AAPL	Stock	23.3775	23.45	23.275	23.33	36764960.0
2014-07-18 10:00:00	AAPL	Stock	23.33	23.46	23.255	23.4505	25613652.0
2014-07-18 11:00:00	AAPL	Stock	23.45	23.5335	23.415	23.51	21193524.0
2014-07-18 12:00:00	AAPL	Stock	23.5112	23.62	23.485	23.59	16562824.0
2014-07-18 13:00:00	AAPL	Stock	23.59	23.62	23.5125	23.6028	12319804.0
2014-07-18 14:00:00	AAPL	Stock	23.6075	23.685	23.5925	23.6075	15309076.0
2014-07-18 15:00:00	AAPL	Stock	23.61	23.66	23.5062	23.6075	35167192.0
2014-07-18 16:00:00	AAPL	Stock	23.6075	23.6175	23.401	23.5775	22359660.0
2014-07-18 17:00:00	AAPL	Stock	23.5775	23.6075	23.5675	23.58	793684.0
2014-07-18 18:00:00	AAPL	Stock	23.58	23.6075	23.58	23.5875	191216.0
2014-07-18 19:00:00	AAPL	Stock	23.59	23.625	23.5875	23.625	171256.0
2014-07-18 05:00:00	MSFT	Stock	44.5	44.5	44.5	44.5	100.0
2014-07-18 07:00:00	MSFT	Stock	44.45	44.5	44.45	44.5	1000.0
2014-07-18 08:00:00	MSFT	Stock	44.5	44.63	44.45	44.59	7443.0
2014-07-18 09:00:00	MSFT	Stock	44.54	44.84	44.47	44.7	8980014.0
2014-07-18 10:00:00	MSFT	Stock	44.71	44.77	44.25	44.5	8054894.0
2014-07-18 11:00:00	MSFT	Stock	44.505	44.59	44.34	44.41	4399543.0
2014-07-18 12:00:00	MSFT	Stock	44.41	44.43	44.35	44.385	2538024.0
2014-07-18 13:00:00	MSFT	Stock	44.383	44.41	44.28	44.39	2363320.0
2014-07-18 14:00:00	MSFT	Stock	44.38	44.585	44.34	44.52	3604825.0
2014-07-18 15:00:00	MSFT	Stock	44.53	44.72	44.45	44.715	8726026.0
2014-07-18 16:00:00	MSFT	Stock	44.71	44.74	44.516	44.65	3682756.0
2014-07-18 17:00:00	MSFT	Stock	44.72	44.72	44.521	44.68	6909.0
2014-07-18 18:00:00	MSFT	Stock	44.68	44.68	44.58	44.58	4600.0
2014-07-18 19:00:00	MSFT	Stock	44.65	44.67	44.62	44.67	5600.0
2014-07-18 08:00:00	NVDA	Stock	0.48	0.48	0.4755	0.4755	296240.0
2014-07-18 09:00:00	NVDA	Stock	0.4768	0.4768	0.4658	0.4682	119210600.0
2014-07-18 10:00:00	NVDA	Stock	0.468	0.4698	0.4648	0.4683	96794200.0
2014-07-18 11:00:00	NVDA	Stock	0.4685	0.4685	0.463	0.4638	70292240.0
2014-07-18 12:00:00	NVDA	Stock	0.4635	0.4648	0.463	0.4643	34439280.0
2014-07-18 13:00:00	NVDA	Stock	0.4644	0.465	0.4603	0.461	42390280.0
2014-07-18 14:00:00	NVDA	Stock	0.4609	0.4635	0.4603	0.4626	46228840.0
2014-07-18 15:00:00	NVDA	Stock	0.4626	0.4633	0.4603	0.461	122510160.0
2014-07-18 16:00:00	NVDA	Stock	0.461	0.4669	0.4606	0.461	13793400.0
2014-07-18 17:00:00	NVDA	Stock	0.4706	0.4706	0.4618	0.4618	114320.0
2014-07-18 18:00:00	NVDA	Stock	0.4618	0.4618	0.4618	0.4618	4000.0
2014-07-18 19:00:00	NVDA	Stock	0.4618	0.4618	0.4618	0.4618	36000.0
2014-07-18 04:00:00	AMZN	Stock	17.631	17.631	17.6	17.6	7400.0
2014-07-18 07:00:00	AMZN	Stock	17.6095	17.8255	17.6095	17.765	58400.0
2014-07-18 08:00:00	AMZN	Stock	17.775	17.844	17.725	17.795	519620.0
2014-07-18 09:00:00	AMZN	Stock	17.7555	17.773	17.6145	17.6498	13329900.0
2014-07-18 10:00:00	AMZN	Stock	17.6575	17.712	17.604	17.678	8051540.0
2014-07-18 11:00:00	AMZN	Stock	17.6795	17.8815	17.675	17.873	7692160.0
2014-07-18 12:00:00	AMZN	Stock	17.873	17.9575	17.867	17.881	6813980.0
2014-07-18 13:00:00	AMZN	Stock	17.876	17.895	17.8355	17.886	4317460.0
2014-07-18 14:00:00	AMZN	Stock	17.895	17.975	17.8795	17.953	6213200.0

> showing 50 of 48,261 rows — these rows as CSV

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