PREVIEW / stock_1hour / 2016-12-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-30.parquet
  size:    1.1 MB
  rows:    49,040
  symbols: 3,165

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-12-30 04:00:00	AAPL	Stock	29.25	29.25	29.25	29.25	7960.0
2016-12-30 05:00:00	AAPL	Stock	29.2	29.2	29.2	29.2	800.0
2016-12-30 06:00:00	AAPL	Stock	29.2	29.2375	29.12	29.235	17204.0
2016-12-30 07:00:00	AAPL	Stock	29.24	29.3225	29.2275	29.27	36336.0
2016-12-30 08:00:00	AAPL	Stock	29.2775	29.28	29.215	29.215	82800.0
2016-12-30 09:00:00	AAPL	Stock	29.22	29.3	29.0225	29.05	12768720.0
2016-12-30 10:00:00	AAPL	Stock	29.05	29.1075	29.01	29.0522	11286340.0
2016-12-30 11:00:00	AAPL	Stock	29.05	29.135	29.0425	29.085	7035588.0
2016-12-30 12:00:00	AAPL	Stock	29.0825	29.0875	28.8928	28.9288	18654204.0
2016-12-30 13:00:00	AAPL	Stock	28.9285	28.985	28.865	28.915	11596704.0
2016-12-30 14:00:00	AAPL	Stock	28.915	28.93	28.8675	28.89	9568676.0
2016-12-30 15:00:00	AAPL	Stock	28.89	28.9975	28.8575	28.96	22249168.0
2016-12-30 16:00:00	AAPL	Stock	28.975	29.0832	28.9025	28.9375	19068740.0
2016-12-30 17:00:00	AAPL	Stock	28.9375	28.9375	28.9075	28.915	45084.0
2016-12-30 18:00:00	AAPL	Stock	28.925	28.925	28.88	28.88	37788.0
2016-12-30 19:00:00	AAPL	Stock	28.9	28.9	28.8675	28.8975	49504.0
2016-12-30 07:00:00	MSFT	Stock	62.73	62.99	62.73	62.99	308.0
2016-12-30 08:00:00	MSFT	Stock	62.99	62.99	62.98	62.98	1490.0
2016-12-30 09:00:00	MSFT	Stock	62.91	62.99	62.29	62.3	2268278.0
2016-12-30 10:00:00	MSFT	Stock	62.29	62.34	62.03	62.3	2659860.0
2016-12-30 11:00:00	MSFT	Stock	62.29	62.42	62.2	62.335	1260842.0
2016-12-30 12:00:00	MSFT	Stock	62.335	62.46	62.2	62.336	2167571.0
2016-12-30 13:00:00	MSFT	Stock	62.336	62.385	62.19	62.21	1159809.0
2016-12-30 14:00:00	MSFT	Stock	62.21	62.27	62.105	62.16	2072562.0
2016-12-30 15:00:00	MSFT	Stock	62.155	62.3	62.05	62.15	5904010.0
2016-12-30 16:00:00	MSFT	Stock	62.15	62.2	62.02	62.14	6271077.0
2016-12-30 17:00:00	MSFT	Stock	62.03	62.03	62.0	62.02	1023.0
2016-12-30 18:00:00	MSFT	Stock	62.03	62.06	62.03	62.06	880.0
2016-12-30 19:00:00	MSFT	Stock	62.06	62.14	62.06	62.14	2763.0
2016-12-30 04:00:00	NVDA	Stock	2.85	2.8513	2.8375	2.8462	806040.0
2016-12-30 05:00:00	NVDA	Stock	2.8405	2.8405	2.8188	2.825	186680.0
2016-12-30 06:00:00	NVDA	Stock	2.83	2.8422	2.815	2.825	509200.0
2016-12-30 07:00:00	NVDA	Stock	2.8212	2.825	2.807	2.8188	1105760.0
2016-12-30 08:00:00	NVDA	Stock	2.8188	2.8408	2.8095	2.81	10544880.0
2016-12-30 09:00:00	NVDA	Stock	2.8082	2.8138	2.7038	2.7115	248625840.0
2016-12-30 10:00:00	NVDA	Stock	2.71	2.7407	2.7058	2.734	189128680.0
2016-12-30 11:00:00	NVDA	Stock	2.733	2.736	2.6802	2.6852	179778360.0
2016-12-30 12:00:00	NVDA	Stock	2.6852	2.701	2.6675	2.6875	124477280.0
2016-12-30 13:00:00	NVDA	Stock	2.6872	2.6896	2.6625	2.666	76271520.0
2016-12-30 14:00:00	NVDA	Stock	2.6658	2.6975	2.6575	2.6939	146681280.0
2016-12-30 15:00:00	NVDA	Stock	2.693	2.697	2.66	2.6685	203603920.0
2016-12-30 16:00:00	NVDA	Stock	2.6685	2.6715	2.658	2.6588	7680520.0
2016-12-30 17:00:00	NVDA	Stock	2.66	2.66	2.6545	2.6578	960840.0
2016-12-30 18:00:00	NVDA	Stock	2.6575	2.66	2.6545	2.6562	469440.0
2016-12-30 19:00:00	NVDA	Stock	2.655	2.675	2.655	2.6688	898360.0
2016-12-30 06:00:00	AMZN	Stock	38.35	38.35	38.35	38.35	4800.0
2016-12-30 07:00:00	AMZN	Stock	38.4	38.4	38.4	38.4	5760.0
2016-12-30 08:00:00	AMZN	Stock	38.3655	38.4	38.3	38.35	125820.0
2016-12-30 09:00:00	AMZN	Stock	38.387	38.399	37.925	37.9362	7806680.0
2016-12-30 10:00:00	AMZN	Stock	37.9265	38.0485	37.8165	37.879	7763000.0

> showing 50 of 49,040 rows — these rows as CSV

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