PREVIEW / stock_1hour / 2016-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-16.parquet
  size:    1.1 MB
  rows:    51,037
  symbols: 3,177

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-16 04:00:00	AAPL	Stock	28.8825	28.8825	28.88	28.8825	7280.0
2016-12-16 05:00:00	AAPL	Stock	28.8375	28.925	28.8375	28.925	23456.0
2016-12-16 06:00:00	AAPL	Stock	28.9075	28.93	28.9	28.93	8488.0
2016-12-16 07:00:00	AAPL	Stock	28.965	29.075	28.965	29.0625	57796.0
2016-12-16 08:00:00	AAPL	Stock	29.0625	29.1175	29.0125	29.0875	371452.0
2016-12-16 09:00:00	AAPL	Stock	29.0875	29.1325	28.9725	29.07	42655356.0
2016-12-16 10:00:00	AAPL	Stock	29.0725	29.0825	28.9538	29.0325	14244520.0
2016-12-16 11:00:00	AAPL	Stock	29.034	29.075	28.9112	29.0288	14081752.0
2016-12-16 12:00:00	AAPL	Stock	29.03	29.0475	28.966	28.975	8222656.0
2016-12-16 13:00:00	AAPL	Stock	28.9775	28.9875	28.9425	28.9475	7062700.0
2016-12-16 14:00:00	AAPL	Stock	28.9488	28.9985	28.9425	28.9662	8049844.0
2016-12-16 15:00:00	AAPL	Stock	28.9662	29.0	28.94	28.993	19289484.0
2016-12-16 16:00:00	AAPL	Stock	28.9925	29.0	28.9775	28.98	42999704.0
2016-12-16 17:00:00	AAPL	Stock	28.99	28.99	28.965	28.98	22480.0
2016-12-16 18:00:00	AAPL	Stock	28.9925	28.9925	28.98	28.98	7060.0
2016-12-16 19:00:00	AAPL	Stock	28.98	28.9925	28.975	28.98	251072.0
2016-12-16 06:00:00	MSFT	Stock	62.58	62.58	62.58	62.58	100.0
2016-12-16 07:00:00	MSFT	Stock	62.8	62.8	62.8	62.8	100.0
2016-12-16 08:00:00	MSFT	Stock	62.74	62.92	62.72	62.92	625.0
2016-12-16 09:00:00	MSFT	Stock	62.82	63.02	62.25	62.42	14076410.0
2016-12-16 10:00:00	MSFT	Stock	62.42	62.47	62.24	62.3	2656815.0
2016-12-16 11:00:00	MSFT	Stock	62.3	62.45	62.22	62.361	3066100.0
2016-12-16 12:00:00	MSFT	Stock	62.37	62.425	62.22	62.245	1869916.0
2016-12-16 13:00:00	MSFT	Stock	62.24	62.36	62.115	62.34	1770133.0
2016-12-16 14:00:00	MSFT	Stock	62.335	62.48	62.28	62.375	2370754.0
2016-12-16 15:00:00	MSFT	Stock	62.38	62.42	62.21	62.3	5719189.0
2016-12-16 16:00:00	MSFT	Stock	62.3	62.44	62.27	62.4	7868010.0
2016-12-16 17:00:00	MSFT	Stock	62.45	62.45	62.45	62.45	100.0
2016-12-16 18:00:00	MSFT	Stock	62.31	62.31	62.31	62.31	100.0
2016-12-16 19:00:00	MSFT	Stock	62.45	62.45	62.45	62.45	250.0
2016-12-16 05:00:00	NVDA	Stock	2.48	2.48	2.48	2.48	8800.0
2016-12-16 07:00:00	NVDA	Stock	2.487	2.4872	2.485	2.4872	93600.0
2016-12-16 08:00:00	NVDA	Stock	2.4875	2.495	2.4603	2.4852	1380960.0
2016-12-16 09:00:00	NVDA	Stock	2.4852	2.5175	2.4712	2.4805	154431360.0
2016-12-16 10:00:00	NVDA	Stock	2.4798	2.4933	2.4658	2.4843	119693200.0
2016-12-16 11:00:00	NVDA	Stock	2.4839	2.4872	2.4568	2.47	74785120.0
2016-12-16 12:00:00	NVDA	Stock	2.47	2.4745	2.4578	2.4665	45828520.0
2016-12-16 13:00:00	NVDA	Stock	2.467	2.4675	2.4445	2.4492	57525760.0
2016-12-16 14:00:00	NVDA	Stock	2.4493	2.467	2.4481	2.4565	49242880.0
2016-12-16 15:00:00	NVDA	Stock	2.457	2.5113	2.4432	2.51	269693120.0
2016-12-16 16:00:00	NVDA	Stock	2.4978	2.5103	2.4422	2.4868	86833760.0
2016-12-16 17:00:00	NVDA	Stock	2.4875	2.4898	2.4838	2.4898	2533640.0
2016-12-16 18:00:00	NVDA	Stock	2.4895	2.4908	2.4875	2.4908	278240.0
2016-12-16 19:00:00	NVDA	Stock	2.4875	2.4908	2.4875	2.49	183560.0
2016-12-16 07:00:00	AMZN	Stock	38.247	38.247	38.1855	38.1855	35520.0
2016-12-16 08:00:00	AMZN	Stock	38.2	38.2425	38.1605	38.1885	108460.0
2016-12-16 09:00:00	AMZN	Stock	38.1995	38.275	38.0445	38.109	20863300.0
2016-12-16 10:00:00	AMZN	Stock	38.111	38.12	37.85	37.8565	12268840.0
2016-12-16 11:00:00	AMZN	Stock	37.855	37.8833	37.7	37.8735	9882220.0
2016-12-16 12:00:00	AMZN	Stock	37.879	37.879	37.753	37.8475	5540320.0

> showing 50 of 51,037 rows — these rows as CSV

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