PREVIEW / stock_1hour / 2015-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-18.parquet
  size:    1.0 MB
  rows:    48,736
  symbols: 3,496

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
2015-03-18 04:00:00	AAPL	Stock	31.775	31.8525	31.775	31.85	17452.0
2015-03-18 05:00:00	AAPL	Stock	31.8525	31.87	31.85	31.87	36592.0
2015-03-18 06:00:00	AAPL	Stock	31.855	31.8875	31.7825	31.845	114776.0
2015-03-18 07:00:00	AAPL	Stock	31.825	31.85	31.725	31.725	184152.0
2015-03-18 08:00:00	AAPL	Stock	31.76	31.845	31.675	31.7375	559232.0
2015-03-18 09:00:00	AAPL	Stock	31.7422	31.82	31.6025	31.7425	22832272.0
2015-03-18 10:00:00	AAPL	Stock	31.745	31.975	31.7212	31.92	30733964.0
2015-03-18 11:00:00	AAPL	Stock	31.92	31.955	31.775	31.8138	15934272.0
2015-03-18 12:00:00	AAPL	Stock	31.8125	31.82	31.6875	31.6925	12866992.0
2015-03-18 13:00:00	AAPL	Stock	31.69	31.7925	31.5925	31.7675	15295216.0
2015-03-18 14:00:00	AAPL	Stock	31.7675	32.145	31.7275	32.095	55000868.0
2015-03-18 15:00:00	AAPL	Stock	32.0925	32.29	32.0725	32.1175	47570164.0
2015-03-18 16:00:00	AAPL	Stock	32.1175	32.163	31.7375	32.145	46684680.0
2015-03-18 17:00:00	AAPL	Stock	32.145	32.165	32.1175	32.165	216304.0
2015-03-18 18:00:00	AAPL	Stock	32.1725	32.205	32.1175	32.185	289372.0
2015-03-18 19:00:00	AAPL	Stock	32.185	32.205	32.17	32.195	205360.0
2015-03-18 04:00:00	MSFT	Stock	41.67	41.67	41.67	41.67	200.0
2015-03-18 05:00:00	MSFT	Stock	41.56	41.7	41.53	41.7	800.0
2015-03-18 06:00:00	MSFT	Stock	41.52	41.52	41.46	41.46	400.0
2015-03-18 07:00:00	MSFT	Stock	41.47	41.47	41.44	41.44	500.0
2015-03-18 08:00:00	MSFT	Stock	41.45	41.59	41.35	41.4	9846.0
2015-03-18 09:00:00	MSFT	Stock	41.39	41.685	41.33	41.55	3547049.0
2015-03-18 10:00:00	MSFT	Stock	41.54	41.96	41.5	41.96	5041808.0
2015-03-18 11:00:00	MSFT	Stock	41.96	42.02	41.76	41.88	4024040.0
2015-03-18 12:00:00	MSFT	Stock	41.875	42.1	41.85	42.01	2955762.0
2015-03-18 13:00:00	MSFT	Stock	42.004	42.05	41.88	41.93	3391323.0
2015-03-18 14:00:00	MSFT	Stock	41.92	42.75	41.92	42.6	9292904.0
2015-03-18 15:00:00	MSFT	Stock	42.61	42.83	42.43	42.5	9829523.0
2015-03-18 16:00:00	MSFT	Stock	42.5	42.605	41.386	42.45	4639434.0
2015-03-18 17:00:00	MSFT	Stock	42.48	42.5	42.47	42.47	56407.0
2015-03-18 18:00:00	MSFT	Stock	42.5	42.6	42.5	42.6	15520.0
2015-03-18 19:00:00	MSFT	Stock	42.501	42.51	42.501	42.51	200.0
2015-03-18 08:00:00	NVDA	Stock	0.5812	0.5812	0.5645	0.5733	60000.0
2015-03-18 09:00:00	NVDA	Stock	0.5812	0.5875	0.5802	0.5838	36776480.0
2015-03-18 10:00:00	NVDA	Stock	0.5838	0.5843	0.5778	0.5782	53472280.0
2015-03-18 11:00:00	NVDA	Stock	0.578	0.5795	0.5705	0.572	68941720.0
2015-03-18 12:00:00	NVDA	Stock	0.572	0.575	0.5712	0.5725	40601600.0
2015-03-18 13:00:00	NVDA	Stock	0.5724	0.5725	0.5665	0.5705	22128120.0
2015-03-18 14:00:00	NVDA	Stock	0.5705	0.5785	0.569	0.575	67445480.0
2015-03-18 15:00:00	NVDA	Stock	0.5749	0.578	0.571	0.572	91001280.0
2015-03-18 16:00:00	NVDA	Stock	0.5718	0.5758	0.5712	0.5755	18438920.0
2015-03-18 17:00:00	NVDA	Stock	0.5748	0.5748	0.5748	0.5748	20000.0
2015-03-18 06:00:00	AMZN	Stock	18.6065	18.6065	18.6065	18.6065	2000.0
2015-03-18 08:00:00	AMZN	Stock	18.55	18.55	18.53	18.53	9540.0
2015-03-18 09:00:00	AMZN	Stock	18.5165	18.529	18.4115	18.454	5795360.0
2015-03-18 10:00:00	AMZN	Stock	18.4625	18.502	18.383	18.4185	5974380.0
2015-03-18 11:00:00	AMZN	Stock	18.4175	18.43	18.335	18.373	4624320.0
2015-03-18 12:00:00	AMZN	Stock	18.3708	18.4085	18.336	18.376	4055160.0
2015-03-18 13:00:00	AMZN	Stock	18.378	18.4185	18.353	18.408	3001960.0
2015-03-18 14:00:00	AMZN	Stock	18.4075	18.7385	18.3975	18.68	12779300.0

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

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