PREVIEW / stock_1hour / 2016-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-02.parquet
  size:    1.0 MB
  rows:    48,837
  symbols: 3,326

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-05-02 04:00:00	AAPL	Stock	24.0	24.0	23.49	23.575	59216.0
2016-05-02 05:00:00	AAPL	Stock	23.57	23.57	23.5375	23.56	9528.0
2016-05-02 06:00:00	AAPL	Stock	23.55	23.565	23.5325	23.565	20148.0
2016-05-02 07:00:00	AAPL	Stock	23.55	23.575	23.5425	23.565	98924.0
2016-05-02 08:00:00	AAPL	Stock	23.555	23.595	23.5	23.535	445980.0
2016-05-02 09:00:00	AAPL	Stock	23.5325	23.5375	23.14	23.145	29421740.0
2016-05-02 10:00:00	AAPL	Stock	23.1425	23.3675	23.1	23.1775	36782776.0
2016-05-02 11:00:00	AAPL	Stock	23.1775	23.295	23.1725	23.23	17748044.0
2016-05-02 12:00:00	AAPL	Stock	23.23	23.2475	23.1525	23.195	15109204.0
2016-05-02 13:00:00	AAPL	Stock	23.1925	23.2682	23.1675	23.19	15519164.0
2016-05-02 14:00:00	AAPL	Stock	23.19	23.41	23.17	23.4065	21138124.0
2016-05-02 15:00:00	AAPL	Stock	23.4062	23.485	23.3375	23.41	35536724.0
2016-05-02 16:00:00	AAPL	Stock	23.4	23.45	23.1895	23.45	5647052.0
2016-05-02 17:00:00	AAPL	Stock	23.4525	23.46	23.4375	23.455	338496.0
2016-05-02 18:00:00	AAPL	Stock	23.4525	23.47	23.425	23.46	769636.0
2016-05-02 19:00:00	AAPL	Stock	23.4625	23.4625	23.445	23.4525	166004.0
2016-05-02 04:00:00	MSFT	Stock	49.94	50.0	49.94	50.0	1090.0
2016-05-02 07:00:00	MSFT	Stock	49.95	49.97	49.85	49.85	5300.0
2016-05-02 08:00:00	MSFT	Stock	49.99	49.99	49.85	49.95	3431.0
2016-05-02 09:00:00	MSFT	Stock	49.91	50.11	49.78	49.91	3439426.0
2016-05-02 10:00:00	MSFT	Stock	49.91	50.2	49.86	49.916	5210970.0
2016-05-02 11:00:00	MSFT	Stock	49.919	50.04	49.85	49.91	2969717.0
2016-05-02 12:00:00	MSFT	Stock	49.91	50.07	49.85	50.03	3187480.0
2016-05-02 13:00:00	MSFT	Stock	50.03	50.59	49.97	50.51	4966649.0
2016-05-02 14:00:00	MSFT	Stock	50.51	50.745	50.49	50.715	3928878.0
2016-05-02 15:00:00	MSFT	Stock	50.715	50.75	50.52	50.61	6441836.0
2016-05-02 16:00:00	MSFT	Stock	50.61	50.64	50.61	50.63	1514187.0
2016-05-02 17:00:00	MSFT	Stock	50.61	50.61	50.56	50.61	2103.0
2016-05-02 18:00:00	MSFT	Stock	50.56	50.6	50.56	50.6	600.0
2016-05-02 19:00:00	MSFT	Stock	50.56	50.56	50.56	50.56	100.0
2016-05-02 05:00:00	NVDA	Stock	0.8975	0.8975	0.8975	0.8975	16000.0
2016-05-02 07:00:00	NVDA	Stock	0.9	0.913	0.9	0.9105	121760.0
2016-05-02 08:00:00	NVDA	Stock	0.9	0.9095	0.9	0.9092	81040.0
2016-05-02 09:00:00	NVDA	Stock	0.9053	0.907	0.893	0.9008	42120840.0
2016-05-02 10:00:00	NVDA	Stock	0.9008	0.9018	0.894	0.8965	38044080.0
2016-05-02 11:00:00	NVDA	Stock	0.8965	0.902	0.8925	0.8943	40191960.0
2016-05-02 12:00:00	NVDA	Stock	0.8943	0.8991	0.8935	0.8975	19950280.0
2016-05-02 13:00:00	NVDA	Stock	0.8973	0.9012	0.8955	0.8968	14760960.0
2016-05-02 14:00:00	NVDA	Stock	0.8968	0.898	0.8953	0.8965	23512000.0
2016-05-02 15:00:00	NVDA	Stock	0.8965	0.902	0.8965	0.8998	51060560.0
2016-05-02 16:00:00	NVDA	Stock	0.9	0.9	0.8984	0.9	10125440.0
2016-05-02 17:00:00	NVDA	Stock	0.9	0.9	0.9	0.9	6440.0
2016-05-02 07:00:00	AMZN	Stock	33.149	33.2015	33.1375	33.1475	87200.0
2016-05-02 08:00:00	AMZN	Stock	33.075	33.19	33.075	33.099	471200.0
2016-05-02 09:00:00	AMZN	Stock	33.1165	33.7575	33.068	33.56	23201180.0
2016-05-02 10:00:00	AMZN	Stock	33.594	33.885	33.45	33.725	19049760.0
2016-05-02 11:00:00	AMZN	Stock	33.7202	33.9	33.7058	33.7338	11769300.0
2016-05-02 12:00:00	AMZN	Stock	33.7235	33.975	33.6755	33.934	10335920.0
2016-05-02 13:00:00	AMZN	Stock	33.916	34.247	33.8975	34.1145	14458700.0
2016-05-02 14:00:00	AMZN	Stock	34.1225	34.275	34.107	34.1895	10222080.0

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

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