PREVIEW / stock_1hour / 2017-09-19

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-19.parquet
  size:    1.0 MB
  rows:    48,071
  symbols: 2,968

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
2017-09-19 04:00:00	AAPL	Stock	39.7125	39.8	39.7125	39.755	25528.0
2017-09-19 05:00:00	AAPL	Stock	39.7525	39.85	39.725	39.8	23044.0
2017-09-19 06:00:00	AAPL	Stock	39.825	39.8425	39.79	39.8325	20992.0
2017-09-19 07:00:00	AAPL	Stock	39.8075	39.93	39.7575	39.9	360260.0
2017-09-19 08:00:00	AAPL	Stock	39.81	39.9125	39.7775	39.8825	466000.0
2017-09-19 09:00:00	AAPL	Stock	39.89	39.9425	39.61	39.635	14798252.0
2017-09-19 10:00:00	AAPL	Stock	39.64	39.8575	39.635	39.815	11793912.0
2017-09-19 11:00:00	AAPL	Stock	39.8175	39.8212	39.6625	39.771	7649268.0
2017-09-19 12:00:00	AAPL	Stock	39.7725	39.875	39.77	39.7775	6906308.0
2017-09-19 13:00:00	AAPL	Stock	39.78	39.81	39.7122	39.76	5535676.0
2017-09-19 14:00:00	AAPL	Stock	39.7588	39.7875	39.6725	39.6925	5907332.0
2017-09-19 15:00:00	AAPL	Stock	39.6912	39.73	39.6425	39.68	9914416.0
2017-09-19 16:00:00	AAPL	Stock	39.6825	39.814	39.6725	39.6775	10253388.0
2017-09-19 17:00:00	AAPL	Stock	39.6775	39.6775	39.5775	39.6025	165296.0
2017-09-19 18:00:00	AAPL	Stock	39.6	39.6825	39.5875	39.6025	784872.0
2017-09-19 19:00:00	AAPL	Stock	39.6	39.625	39.59	39.605	33080.0
2017-09-19 07:00:00	MSFT	Stock	75.46	75.46	75.46	75.46	100.0
2017-09-19 08:00:00	MSFT	Stock	75.38	75.38	75.16	75.25	7555.0
2017-09-19 09:00:00	MSFT	Stock	75.25	75.39	75.01	75.18	1686252.0
2017-09-19 10:00:00	MSFT	Stock	75.19	75.63	75.1	75.63	1896573.0
2017-09-19 11:00:00	MSFT	Stock	75.64	75.64	75.45	75.465	1342472.0
2017-09-19 12:00:00	MSFT	Stock	75.469	75.71	75.42	75.45	1467394.0
2017-09-19 13:00:00	MSFT	Stock	75.445	75.615	75.41	75.61	909159.0
2017-09-19 14:00:00	MSFT	Stock	75.605	75.69	75.47	75.476	1195539.0
2017-09-19 15:00:00	MSFT	Stock	75.475	75.48	75.36	75.44	2667919.0
2017-09-19 16:00:00	MSFT	Stock	75.45	75.485	75.4	75.4	3062506.0
2017-09-19 17:00:00	MSFT	Stock	75.42	75.59	75.42	75.59	403.0
2017-09-19 18:00:00	MSFT	Stock	75.44	75.44	75.44	75.44	261166.0
2017-09-19 19:00:00	MSFT	Stock	75.44	75.44	75.44	75.44	160.0
2017-09-19 04:00:00	NVDA	Stock	4.6618	4.6625	4.6612	4.6625	44080.0
2017-09-19 05:00:00	NVDA	Stock	4.6625	4.6675	4.6625	4.6675	65120.0
2017-09-19 06:00:00	NVDA	Stock	4.6675	4.67	4.6528	4.656	418920.0
2017-09-19 07:00:00	NVDA	Stock	4.6532	4.6688	4.6532	4.663	499440.0
2017-09-19 08:00:00	NVDA	Stock	4.663	4.6688	4.6438	4.66	3782880.0
2017-09-19 09:00:00	NVDA	Stock	4.66	4.685	4.6154	4.6603	191182480.0
2017-09-19 10:00:00	NVDA	Stock	4.662	4.7462	4.6608	4.719	240427960.0
2017-09-19 11:00:00	NVDA	Stock	4.7195	4.72	4.6815	4.7078	120316200.0
2017-09-19 12:00:00	NVDA	Stock	4.7078	4.723	4.6938	4.6958	73310200.0
2017-09-19 13:00:00	NVDA	Stock	4.6958	4.7155	4.6903	4.7079	59810760.0
2017-09-19 14:00:00	NVDA	Stock	4.7078	4.7112	4.6953	4.7005	36757560.0
2017-09-19 15:00:00	NVDA	Stock	4.6996	4.7175	4.6802	4.684	92993040.0
2017-09-19 16:00:00	NVDA	Stock	4.6838	4.685	4.6705	4.6718	15037080.0
2017-09-19 17:00:00	NVDA	Stock	4.6725	4.6838	4.6663	4.6675	989440.0
2017-09-19 18:00:00	NVDA	Stock	4.6663	4.6838	4.665	4.6697	1179680.0
2017-09-19 19:00:00	NVDA	Stock	4.6652	4.675	4.663	4.675	693400.0
2017-09-19 06:00:00	AMZN	Stock	48.9	48.9	48.9	48.9	4040.0
2017-09-19 07:00:00	AMZN	Stock	48.9	48.9	48.8825	48.8825	9620.0
2017-09-19 08:00:00	AMZN	Stock	48.9	48.9495	48.875	48.9	90980.0
2017-09-19 09:00:00	AMZN	Stock	48.9025	48.912	48.373	48.5125	9416320.0
2017-09-19 10:00:00	AMZN	Stock	48.523	48.7775	48.4084	48.5925	8405720.0

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

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