PREVIEW / stock_1hour / 2016-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-12.parquet
  size:    1.0 MB
  rows:    49,137
  symbols: 3,385

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-01-12 04:00:00	AAPL	Stock	24.555	24.725	24.555	24.685	34272.0
2016-01-12 05:00:00	AAPL	Stock	24.7425	24.805	24.7	24.805	24004.0
2016-01-12 06:00:00	AAPL	Stock	24.825	25.175	24.825	25.065	709880.0
2016-01-12 07:00:00	AAPL	Stock	25.0525	25.1025	25.0375	25.075	491220.0
2016-01-12 08:00:00	AAPL	Stock	25.08	25.1375	25.0475	25.1	1341752.0
2016-01-12 09:00:00	AAPL	Stock	25.1	25.1725	24.9575	25.095	36463308.0
2016-01-12 10:00:00	AAPL	Stock	25.095	25.155	24.8425	24.9315	30340828.0
2016-01-12 11:00:00	AAPL	Stock	24.925	24.9525	24.7775	24.9125	20442204.0
2016-01-12 12:00:00	AAPL	Stock	24.9125	24.9675	24.7575	24.8075	16124592.0
2016-01-12 13:00:00	AAPL	Stock	24.8038	24.9225	24.8	24.825	13461324.0
2016-01-12 14:00:00	AAPL	Stock	24.8275	24.93	24.71	24.9062	20703172.0
2016-01-12 15:00:00	AAPL	Stock	24.9052	25.055	24.8	24.99	30781360.0
2016-01-12 16:00:00	AAPL	Stock	24.99	25.035	24.9125	24.925	10573224.0
2016-01-12 17:00:00	AAPL	Stock	24.9475	24.955	24.91	24.925	101092.0
2016-01-12 18:00:00	AAPL	Stock	24.93	24.99	24.9225	24.975	64492.0
2016-01-12 19:00:00	AAPL	Stock	24.9875	25.075	24.9875	25.0725	123676.0
2016-01-12 04:00:00	MSFT	Stock	52.5	52.5	52.5	52.5	441.0
2016-01-12 05:00:00	MSFT	Stock	52.59	52.59	52.54	52.57	2160.0
2016-01-12 06:00:00	MSFT	Stock	52.56	52.56	52.45	52.55	10693.0
2016-01-12 07:00:00	MSFT	Stock	52.6	52.8	52.6	52.8	2960.0
2016-01-12 08:00:00	MSFT	Stock	52.7	52.95	52.7	52.8	158467.0
2016-01-12 09:00:00	MSFT	Stock	52.78	53.1	52.61	52.82	4273153.0
2016-01-12 10:00:00	MSFT	Stock	52.82	52.9	52.5	52.7	4733692.0
2016-01-12 11:00:00	MSFT	Stock	52.7	52.71	52.11	52.342	4138337.0
2016-01-12 12:00:00	MSFT	Stock	52.35	52.56	52.06	52.27	2961982.0
2016-01-12 13:00:00	MSFT	Stock	52.27	52.56	52.27	52.37	2726262.0
2016-01-12 14:00:00	MSFT	Stock	52.379	52.81	52.06	52.81	4196127.0
2016-01-12 15:00:00	MSFT	Stock	52.8	52.98	52.58	52.77	7184111.0
2016-01-12 16:00:00	MSFT	Stock	52.78	52.78	52.63	52.7	3138666.0
2016-01-12 17:00:00	MSFT	Stock	52.65	52.78	52.46	52.7	135720.0
2016-01-12 18:00:00	MSFT	Stock	52.6	52.6	52.6	52.6	964.0
2016-01-12 19:00:00	MSFT	Stock	52.7	52.78	52.7	52.78	19700.0
2016-01-12 07:00:00	NVDA	Stock	0.7495	0.7495	0.7495	0.7495	8000.0
2016-01-12 08:00:00	NVDA	Stock	0.75	0.752	0.75	0.752	232200.0
2016-01-12 09:00:00	NVDA	Stock	0.752	0.7655	0.742	0.76	87418920.0
2016-01-12 10:00:00	NVDA	Stock	0.7598	0.7612	0.7553	0.7568	50418920.0
2016-01-12 11:00:00	NVDA	Stock	0.7568	0.76	0.7508	0.7578	58431200.0
2016-01-12 12:00:00	NVDA	Stock	0.758	0.7595	0.75	0.7505	41001560.0
2016-01-12 13:00:00	NVDA	Stock	0.7505	0.755	0.7498	0.7509	25637160.0
2016-01-12 14:00:00	NVDA	Stock	0.751	0.7565	0.7492	0.756	52176440.0
2016-01-12 15:00:00	NVDA	Stock	0.7563	0.7568	0.7528	0.7545	100717560.0
2016-01-12 16:00:00	NVDA	Stock	0.7545	0.755	0.7545	0.755	1866960.0
2016-01-12 17:00:00	NVDA	Stock	0.7545	0.7545	0.751	0.7545	261200.0
2016-01-12 19:00:00	NVDA	Stock	0.7545	0.7575	0.7545	0.7575	22000.0
2016-01-12 05:00:00	AMZN	Stock	31.042	31.075	31.042	31.075	15820.0
2016-01-12 06:00:00	AMZN	Stock	31.075	31.132	31.075	31.1	28200.0
2016-01-12 07:00:00	AMZN	Stock	31.1415	31.2625	31.1	31.2625	254360.0
2016-01-12 08:00:00	AMZN	Stock	31.2345	31.2875	31.1675	31.205	689660.0
2016-01-12 09:00:00	AMZN	Stock	31.225	31.2995	31.0	31.11	17304260.0
2016-01-12 10:00:00	AMZN	Stock	31.0992	31.219	31.005	31.1435	13447880.0

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

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