PREVIEW / stock_1hour / 2016-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-15.parquet
  size:    1.0 MB
  rows:    48,182
  symbols: 3,325

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-03-15 04:00:00	AAPL	Stock	25.7025	25.7025	25.5325	25.575	65912.0
2016-03-15 05:00:00	AAPL	Stock	25.58	25.685	25.58	25.675	69772.0
2016-03-15 06:00:00	AAPL	Stock	25.675	25.925	25.675	25.9075	225464.0
2016-03-15 07:00:00	AAPL	Stock	25.875	26.125	25.875	26.0625	653592.0
2016-03-15 08:00:00	AAPL	Stock	26.045	26.0925	25.8875	25.9575	1497664.0
2016-03-15 09:00:00	AAPL	Stock	25.9575	26.195	25.9575	26.12	31764900.0
2016-03-15 10:00:00	AAPL	Stock	26.1175	26.2475	26.02	26.225	28236220.0
2016-03-15 11:00:00	AAPL	Stock	26.226	26.295	26.1775	26.2525	18292744.0
2016-03-15 12:00:00	AAPL	Stock	26.255	26.2675	26.175	26.185	12534160.0
2016-03-15 13:00:00	AAPL	Stock	26.1875	26.194	26.085	26.1548	12367896.0
2016-03-15 14:00:00	AAPL	Stock	26.155	26.18	26.1175	26.1575	9515760.0
2016-03-15 15:00:00	AAPL	Stock	26.1575	26.24	26.125	26.145	21923176.0
2016-03-15 16:00:00	AAPL	Stock	26.145	26.155	25.75	26.1325	9395824.0
2016-03-15 17:00:00	AAPL	Stock	26.1325	26.145	26.125	26.1275	83348.0
2016-03-15 18:00:00	AAPL	Stock	26.135	26.1525	26.135	26.1425	66060.0
2016-03-15 19:00:00	AAPL	Stock	26.1425	26.155	26.14	26.155	69580.0
2016-03-15 04:00:00	MSFT	Stock	52.99	52.99	52.99	52.99	1500.0
2016-03-15 06:00:00	MSFT	Stock	52.7	52.7	52.7	52.7	458.0
2016-03-15 07:00:00	MSFT	Stock	52.8	52.84	52.79	52.81	778.0
2016-03-15 08:00:00	MSFT	Stock	52.77	52.99	52.77	52.81	24312.0
2016-03-15 09:00:00	MSFT	Stock	52.91	53.0	52.74	52.86	1844195.0
2016-03-15 10:00:00	MSFT	Stock	52.85	53.375	52.77	53.37	2665108.0
2016-03-15 11:00:00	MSFT	Stock	53.366	53.48	53.07	53.09	2135394.0
2016-03-15 12:00:00	MSFT	Stock	53.1	53.355	53.09	53.105	1755152.0
2016-03-15 13:00:00	MSFT	Stock	53.105	53.35	52.97	53.31	1804404.0
2016-03-15 14:00:00	MSFT	Stock	53.32	53.44	53.25	53.415	2458885.0
2016-03-15 15:00:00	MSFT	Stock	53.42	53.59	53.3	53.59	4643218.0
2016-03-15 16:00:00	MSFT	Stock	53.59	53.63	53.55	53.59	1944934.0
2016-03-15 17:00:00	MSFT	Stock	53.59	53.59	53.57	53.58	90358.0
2016-03-15 18:00:00	MSFT	Stock	53.58	53.58	53.5	53.5	3697.0
2016-03-15 19:00:00	MSFT	Stock	53.5	53.58	53.5	53.58	987.0
2016-03-15 09:00:00	NVDA	Stock	0.8075	0.8085	0.8018	0.8046	17871680.0
2016-03-15 10:00:00	NVDA	Stock	0.8045	0.8046	0.795	0.796	30311680.0
2016-03-15 11:00:00	NVDA	Stock	0.796	0.7968	0.7895	0.7898	30771440.0
2016-03-15 12:00:00	NVDA	Stock	0.7898	0.795	0.7892	0.7945	21983640.0
2016-03-15 13:00:00	NVDA	Stock	0.7942	0.798	0.794	0.7971	36476680.0
2016-03-15 14:00:00	NVDA	Stock	0.7971	0.8008	0.7965	0.8	20031360.0
2016-03-15 15:00:00	NVDA	Stock	0.7998	0.8036	0.7994	0.8035	45153600.0
2016-03-15 16:00:00	NVDA	Stock	0.8035	0.8045	0.8035	0.8035	5049280.0
2016-03-15 18:00:00	NVDA	Stock	0.805	0.8062	0.805	0.8062	16600.0
2016-03-15 07:00:00	AMZN	Stock	28.485	28.515	28.485	28.515	27000.0
2016-03-15 08:00:00	AMZN	Stock	28.525	28.625	28.525	28.55	222640.0
2016-03-15 09:00:00	AMZN	Stock	28.5575	28.646	28.35	28.467	7276000.0
2016-03-15 10:00:00	AMZN	Stock	28.4365	28.601	28.4075	28.565	6822400.0
2016-03-15 11:00:00	AMZN	Stock	28.5725	28.814	28.5718	28.662	8476280.0
2016-03-15 12:00:00	AMZN	Stock	28.6589	28.742	28.609	28.69	7093120.0
2016-03-15 13:00:00	AMZN	Stock	28.69	29.015	28.682	28.9752	10759480.0
2016-03-15 14:00:00	AMZN	Stock	28.9705	29.076	28.892	28.9475	15388640.0
2016-03-15 15:00:00	AMZN	Stock	28.954	29.0155	28.8372	28.851	9352560.0
2016-03-15 16:00:00	AMZN	Stock	28.851	28.851	28.696	28.851	2172100.0

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

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