PREVIEW / stock_1hour / 2016-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-14.parquet
  size:    1.0 MB
  rows:    49,006
  symbols: 3,147

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-14 05:00:00	AAPL	Stock	28.8125	28.815	28.8	28.815	5616.0
2016-12-14 06:00:00	AAPL	Stock	28.8	28.8	28.8	28.8	820.0
2016-12-14 07:00:00	AAPL	Stock	28.8475	28.8975	28.7575	28.8	43228.0
2016-12-14 08:00:00	AAPL	Stock	28.8125	28.8575	28.7075	28.75	331260.0
2016-12-14 09:00:00	AAPL	Stock	28.765	29.05	28.735	28.9925	20000308.0
2016-12-14 10:00:00	AAPL	Stock	28.995	29.025	28.8925	28.9345	15828552.0
2016-12-14 11:00:00	AAPL	Stock	28.9338	28.955	28.8312	28.9225	10571124.0
2016-12-14 12:00:00	AAPL	Stock	28.9225	28.95	28.875	28.8952	7077748.0
2016-12-14 13:00:00	AAPL	Stock	28.8962	28.9875	28.8952	28.98	6961164.0
2016-12-14 14:00:00	AAPL	Stock	28.9825	29.0075	28.7625	28.9125	24837832.0
2016-12-14 15:00:00	AAPL	Stock	28.9125	28.995	28.76	28.8	27706968.0
2016-12-14 16:00:00	AAPL	Stock	28.8	28.8325	28.7975	28.8075	12216752.0
2016-12-14 17:00:00	AAPL	Stock	28.825	28.825	28.7625	28.825	95712.0
2016-12-14 18:00:00	AAPL	Stock	28.8125	28.8125	28.7675	28.78	32104.0
2016-12-14 19:00:00	AAPL	Stock	28.81	28.825	28.8	28.8225	18172.0
2016-12-14 04:00:00	MSFT	Stock	63.05	63.05	63.05	63.05	500.0
2016-12-14 05:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	400.0
2016-12-14 07:00:00	MSFT	Stock	63.2	63.2	63.04	63.1	10326.0
2016-12-14 08:00:00	MSFT	Stock	63.08	63.1	63.0	63.05	4432.0
2016-12-14 09:00:00	MSFT	Stock	63.05	63.45	62.88	63.055	2759259.0
2016-12-14 10:00:00	MSFT	Stock	63.06	63.24	62.985	62.99	2867937.0
2016-12-14 11:00:00	MSFT	Stock	62.995	63.11	62.846	63.055	2263482.0
2016-12-14 12:00:00	MSFT	Stock	63.059	63.114	63.02	63.09	1687964.0
2016-12-14 13:00:00	MSFT	Stock	63.09	63.19	62.99	63.174	1763440.0
2016-12-14 14:00:00	MSFT	Stock	63.18	63.24	62.62	62.89	5787704.0
2016-12-14 15:00:00	MSFT	Stock	62.88	63.115	62.53	62.69	7192461.0
2016-12-14 16:00:00	MSFT	Stock	62.68	62.87	62.68	62.84	3014669.0
2016-12-14 17:00:00	MSFT	Stock	62.75	62.81	62.75	62.81	1562.0
2016-12-14 18:00:00	MSFT	Stock	62.76	62.76	62.7	62.7	8790.0
2016-12-14 19:00:00	MSFT	Stock	62.78	62.8	62.74	62.74	700.0
2016-12-14 06:00:00	NVDA	Stock	2.2925	2.3172	2.2925	2.3125	313400.0
2016-12-14 07:00:00	NVDA	Stock	2.3125	2.317	2.31	2.3158	325200.0
2016-12-14 08:00:00	NVDA	Stock	2.316	2.316	2.275	2.3113	921200.0
2016-12-14 09:00:00	NVDA	Stock	2.3125	2.348	2.2892	2.3477	105845880.0
2016-12-14 10:00:00	NVDA	Stock	2.3478	2.3738	2.3388	2.3723	168804920.0
2016-12-14 11:00:00	NVDA	Stock	2.3718	2.3895	2.3632	2.389	103937040.0
2016-12-14 12:00:00	NVDA	Stock	2.3891	2.4145	2.3845	2.4105	107439360.0
2016-12-14 13:00:00	NVDA	Stock	2.4108	2.4278	2.3928	2.4227	100260480.0
2016-12-14 14:00:00	NVDA	Stock	2.4218	2.4238	2.379	2.4085	145624400.0
2016-12-14 15:00:00	NVDA	Stock	2.4078	2.4238	2.3958	2.4115	157871800.0
2016-12-14 16:00:00	NVDA	Stock	2.4113	2.4132	2.3822	2.4125	24822200.0
2016-12-14 17:00:00	NVDA	Stock	2.4125	2.4125	2.4062	2.4088	287400.0
2016-12-14 18:00:00	NVDA	Stock	2.4088	2.4113	2.4065	2.4113	338720.0
2016-12-14 19:00:00	NVDA	Stock	2.4113	2.416	2.4068	2.416	385160.0
2016-12-14 06:00:00	AMZN	Stock	38.8885	38.9125	38.8885	38.9125	9480.0
2016-12-14 07:00:00	AMZN	Stock	38.925	38.9435	38.8625	38.8625	87720.0
2016-12-14 08:00:00	AMZN	Stock	38.8725	38.9375	38.84	38.8475	243840.0
2016-12-14 09:00:00	AMZN	Stock	38.8575	39.043	38.7295	38.8775	13478900.0
2016-12-14 10:00:00	AMZN	Stock	38.8839	38.97	38.7555	38.8441	11607680.0
2016-12-14 11:00:00	AMZN	Stock	38.83	38.845	38.4975	38.6428	10589000.0

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

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