PREVIEW / stock_1hour / 2015-02-09

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-09.parquet
  size:    1.0 MB
  rows:    48,859
  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
2015-02-09 04:00:00	AAPL	Stock	29.6875	29.6875	29.5475	29.5575	26024.0
2015-02-09 05:00:00	AAPL	Stock	29.5375	29.58	29.5	29.5	53972.0
2015-02-09 06:00:00	AAPL	Stock	29.525	29.56	29.5	29.55	36196.0
2015-02-09 07:00:00	AAPL	Stock	29.5375	29.6075	29.5375	29.5925	61512.0
2015-02-09 08:00:00	AAPL	Stock	29.6075	29.6875	29.5025	29.6675	594064.0
2015-02-09 09:00:00	AAPL	Stock	29.6625	29.81	29.6075	29.7	21008452.0
2015-02-09 10:00:00	AAPL	Stock	29.6975	29.845	29.695	29.7225	24753916.0
2015-02-09 11:00:00	AAPL	Stock	29.7225	29.8925	29.7125	29.8388	17557112.0
2015-02-09 12:00:00	AAPL	Stock	29.8388	29.9	29.8125	29.8875	11015660.0
2015-02-09 13:00:00	AAPL	Stock	29.885	29.9375	29.84	29.8962	14598736.0
2015-02-09 14:00:00	AAPL	Stock	29.8978	29.96	29.8475	29.86	16266012.0
2015-02-09 15:00:00	AAPL	Stock	29.8575	29.9575	29.7775	29.93	29988460.0
2015-02-09 16:00:00	AAPL	Stock	29.926	29.9475	29.718	29.8368	5098880.0
2015-02-09 17:00:00	AAPL	Stock	29.9425	29.9725	29.93	29.9725	2082016.0
2015-02-09 18:00:00	AAPL	Stock	29.9725	29.9775	29.93	29.9775	178832.0
2015-02-09 19:00:00	AAPL	Stock	29.9775	29.985	29.965	29.975	108124.0
2015-02-09 07:00:00	MSFT	Stock	42.2	42.2	42.2	42.2	200.0
2015-02-09 08:00:00	MSFT	Stock	42.25	42.29	42.15	42.28	8565.0
2015-02-09 09:00:00	MSFT	Stock	42.19	42.55	42.19	42.34	3163034.0
2015-02-09 10:00:00	MSFT	Stock	42.34	42.53	42.28	42.311	3904036.0
2015-02-09 11:00:00	MSFT	Stock	42.31	42.74	42.31	42.6	4278663.0
2015-02-09 12:00:00	MSFT	Stock	42.6	42.69	42.58	42.605	2354543.0
2015-02-09 13:00:00	MSFT	Stock	42.605	42.64	42.41	42.43	3044771.0
2015-02-09 14:00:00	MSFT	Stock	42.43	42.48	42.37	42.4	2441900.0
2015-02-09 15:00:00	MSFT	Stock	42.39	42.54	42.33	42.35	5415761.0
2015-02-09 16:00:00	MSFT	Stock	42.36	42.472	42.34	42.44	1861102.0
2015-02-09 17:00:00	MSFT	Stock	42.44	42.44	42.36	42.36	2874592.0
2015-02-09 19:00:00	MSFT	Stock	42.44	42.49	42.44	42.47	3179.0
2015-02-09 04:00:00	NVDA	Stock	0.51	0.51	0.51	0.51	4000.0
2015-02-09 09:00:00	NVDA	Stock	0.507	0.5102	0.5038	0.5062	44034600.0
2015-02-09 10:00:00	NVDA	Stock	0.5062	0.5072	0.5048	0.5065	36217720.0
2015-02-09 11:00:00	NVDA	Stock	0.5065	0.509	0.5062	0.5081	32085640.0
2015-02-09 12:00:00	NVDA	Stock	0.5081	0.51	0.5068	0.51	15649840.0
2015-02-09 13:00:00	NVDA	Stock	0.5098	0.511	0.508	0.5082	19322440.0
2015-02-09 14:00:00	NVDA	Stock	0.5082	0.5093	0.5075	0.509	17908680.0
2015-02-09 15:00:00	NVDA	Stock	0.5089	0.511	0.5085	0.5098	91882960.0
2015-02-09 16:00:00	NVDA	Stock	0.5095	0.51	0.5084	0.5095	12218360.0
2015-02-09 17:00:00	NVDA	Stock	0.5095	0.5095	0.5095	0.5095	22760.0
2015-02-09 07:00:00	AMZN	Stock	18.576	18.615	18.576	18.615	30000.0
2015-02-09 08:00:00	AMZN	Stock	18.614	18.614	18.555	18.5705	108020.0
2015-02-09 09:00:00	AMZN	Stock	18.58	18.7205	18.4855	18.6795	8351900.0
2015-02-09 10:00:00	AMZN	Stock	18.675	18.6945	18.36	18.379	13725840.0
2015-02-09 11:00:00	AMZN	Stock	18.3804	18.565	18.3625	18.4554	7021920.0
2015-02-09 12:00:00	AMZN	Stock	18.4625	18.5715	18.435	18.53	3553920.0
2015-02-09 13:00:00	AMZN	Stock	18.523	18.5395	18.465	18.5355	3093920.0
2015-02-09 14:00:00	AMZN	Stock	18.5355	18.608	18.505	18.532	4214080.0
2015-02-09 15:00:00	AMZN	Stock	18.531	18.5971	18.5075	18.5295	7380640.0
2015-02-09 16:00:00	AMZN	Stock	18.528	18.5465	18.4905	18.528	2023840.0
2015-02-09 17:00:00	AMZN	Stock	18.528	18.544	18.528	18.528	954260.0
2015-02-09 18:00:00	AMZN	Stock	18.528	18.5475	18.528	18.5475	21360.0

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

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