PREVIEW / stock_1hour / 2016-10-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-10-05.parquet
  size:    1.0 MB
  rows:    47,727
  symbols: 3,194

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
2016-10-05 04:00:00	AAPL	Stock	28.5725	28.5725	28.2875	28.2875	904.0
2016-10-05 05:00:00	AAPL	Stock	28.3075	28.3425	28.3075	28.3425	3688.0
2016-10-05 07:00:00	AAPL	Stock	28.2775	28.335	28.2725	28.3325	29124.0
2016-10-05 08:00:00	AAPL	Stock	28.325	28.35	28.1875	28.35	124824.0
2016-10-05 09:00:00	AAPL	Stock	28.35	28.415	28.2125	28.3225	13349312.0
2016-10-05 10:00:00	AAPL	Stock	28.325	28.3675	28.1725	28.2325	15510224.0
2016-10-05 11:00:00	AAPL	Stock	28.23	28.2775	28.22	28.26	7346208.0
2016-10-05 12:00:00	AAPL	Stock	28.26	28.29	28.25	28.2735	5226576.0
2016-10-05 13:00:00	AAPL	Stock	28.2725	28.3125	28.22	28.2875	9510392.0
2016-10-05 14:00:00	AAPL	Stock	28.2892	28.3175	28.2575	28.2975	9885692.0
2016-10-05 15:00:00	AAPL	Stock	28.2975	28.3125	28.2288	28.26	11270600.0
2016-10-05 16:00:00	AAPL	Stock	28.26	28.4775	28.2425	28.3575	8319188.0
2016-10-05 17:00:00	AAPL	Stock	28.3625	28.375	28.32	28.3675	182912.0
2016-10-05 18:00:00	AAPL	Stock	28.3675	28.37	28.35	28.355	60372.0
2016-10-05 19:00:00	AAPL	Stock	28.37	28.37	28.345	28.365	51060.0
2016-10-05 08:00:00	MSFT	Stock	57.1	57.42	57.1	57.24	17276.0
2016-10-05 09:00:00	MSFT	Stock	57.33	57.7	57.26	57.58	2034571.0
2016-10-05 10:00:00	MSFT	Stock	57.59	57.83	57.529	57.72	2510412.0
2016-10-05 11:00:00	MSFT	Stock	57.725	57.93	57.68	57.91	1732759.0
2016-10-05 12:00:00	MSFT	Stock	57.9	57.96	57.83	57.86	1546390.0
2016-10-05 13:00:00	MSFT	Stock	57.87	57.89	57.73	57.865	1239490.0
2016-10-05 14:00:00	MSFT	Stock	57.86	57.915	57.8	57.844	1705316.0
2016-10-05 15:00:00	MSFT	Stock	57.84	57.877	57.6	57.64	2976544.0
2016-10-05 16:00:00	MSFT	Stock	57.634	57.72	57.61	57.64	1751531.0
2016-10-05 07:00:00	NVDA	Stock	1.7075	1.708	1.7075	1.708	20000.0
2016-10-05 08:00:00	NVDA	Stock	1.7075	1.715	1.7075	1.7128	927360.0
2016-10-05 09:00:00	NVDA	Stock	1.7128	1.7395	1.7027	1.7231	37156640.0
2016-10-05 10:00:00	NVDA	Stock	1.7235	1.7238	1.7065	1.711	34858840.0
2016-10-05 11:00:00	NVDA	Stock	1.711	1.7148	1.7092	1.7095	33940040.0
2016-10-05 12:00:00	NVDA	Stock	1.7095	1.7115	1.7058	1.7065	22621560.0
2016-10-05 13:00:00	NVDA	Stock	1.7065	1.7072	1.7005	1.7048	30367880.0
2016-10-05 14:00:00	NVDA	Stock	1.7049	1.7085	1.7021	1.7055	34104360.0
2016-10-05 15:00:00	NVDA	Stock	1.7052	1.707	1.701	1.7058	51878040.0
2016-10-05 16:00:00	NVDA	Stock	1.7058	1.7115	1.7058	1.7115	28716680.0
2016-10-05 17:00:00	NVDA	Stock	1.7058	1.7065	1.6852	1.6875	2053920.0
2016-10-05 18:00:00	NVDA	Stock	1.6875	1.6888	1.681	1.6858	1081200.0
2016-10-05 19:00:00	NVDA	Stock	1.6855	1.6872	1.682	1.6838	252560.0
2016-10-05 04:00:00	AMZN	Stock	41.7475	41.753	41.7475	41.753	4040.0
2016-10-05 06:00:00	AMZN	Stock	41.7925	41.8	41.7925	41.8	28000.0
2016-10-05 07:00:00	AMZN	Stock	41.8	41.813	41.7895	41.7895	18980.0
2016-10-05 08:00:00	AMZN	Stock	41.8	41.885	41.797	41.858	107260.0
2016-10-05 09:00:00	AMZN	Stock	41.8375	41.989	41.806	41.982	9453900.0
2016-10-05 10:00:00	AMZN	Stock	41.9915	42.035	41.8705	41.9335	7882960.0
2016-10-05 11:00:00	AMZN	Stock	41.9335	42.0612	41.9092	42.036	7455360.0
2016-10-05 12:00:00	AMZN	Stock	42.036	42.1959	42.028	42.153	8930720.0
2016-10-05 13:00:00	AMZN	Stock	42.151	42.235	42.1255	42.2252	5482100.0
2016-10-05 14:00:00	AMZN	Stock	42.23	42.2475	42.175	42.2415	5425080.0
2016-10-05 15:00:00	AMZN	Stock	42.2405	42.2835	42.2142	42.218	11214780.0
2016-10-05 16:00:00	AMZN	Stock	42.218	42.2395	42.14	42.175	2417920.0
2016-10-05 17:00:00	AMZN	Stock	42.192	42.1945	42.1375	42.1375	134420.0

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

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