PREVIEW / stock_1hour / 2014-09-04

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-09-04.parquet
  size:    1.0 MB
  rows:    48,550
  symbols: 3,590

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
2014-09-04 04:00:00	AAPL	Stock	25.0	25.0	24.03	24.07	650496.0
2014-09-04 05:00:00	AAPL	Stock	24.0625	24.4275	24.0575	24.3975	583764.0
2014-09-04 06:00:00	AAPL	Stock	24.3925	24.58	24.3125	24.5725	393044.0
2014-09-04 07:00:00	AAPL	Stock	24.5725	24.675	24.5325	24.6275	941332.0
2014-09-04 08:00:00	AAPL	Stock	24.5525	24.9175	24.4325	24.9125	3555844.0
2014-09-04 09:00:00	AAPL	Stock	24.9225	24.97	24.4475	24.91	92815256.0
2014-09-04 10:00:00	AAPL	Stock	24.91	25.0225	24.88	24.985	57028992.0
2014-09-04 11:00:00	AAPL	Stock	24.9825	24.9975	24.8375	24.8775	31796576.0
2014-09-04 12:00:00	AAPL	Stock	24.875	24.9225	24.7775	24.8475	23386316.0
2014-09-04 13:00:00	AAPL	Stock	24.8475	24.8775	24.76	24.7725	15903376.0
2014-09-04 14:00:00	AAPL	Stock	24.7725	24.8175	24.515	24.525	33776476.0
2014-09-04 15:00:00	AAPL	Stock	24.5275	24.5672	24.4625	24.5275	53322280.0
2014-09-04 16:00:00	AAPL	Stock	24.53	24.9565	21.3307	24.55	5809924.0
2014-09-04 17:00:00	AAPL	Stock	24.55	24.57	24.53	24.5675	935008.0
2014-09-04 18:00:00	AAPL	Stock	24.5675	24.575	24.53	24.5725	307872.0
2014-09-04 19:00:00	AAPL	Stock	24.57	24.575	24.555	24.57	253092.0
2014-09-04 05:00:00	MSFT	Stock	45.0	45.0	45.0	45.0	900.0
2014-09-04 06:00:00	MSFT	Stock	45.12	45.12	45.12	45.12	100.0
2014-09-04 07:00:00	MSFT	Stock	45.07	45.08	45.04	45.05	1580.0
2014-09-04 08:00:00	MSFT	Stock	45.04	45.05	44.76	44.8	14362.0
2014-09-04 09:00:00	MSFT	Stock	44.77	45.08	44.67	45.03	4024947.0
2014-09-04 10:00:00	MSFT	Stock	45.025	45.21	45.01	45.13	4228345.0
2014-09-04 11:00:00	MSFT	Stock	45.125	45.19	45.02	45.13	3030465.0
2014-09-04 12:00:00	MSFT	Stock	45.137	45.19	45.1	45.165	1665029.0
2014-09-04 13:00:00	MSFT	Stock	45.17	45.21	45.15	45.18	1799775.0
2014-09-04 14:00:00	MSFT	Stock	45.18	45.25	45.115	45.155	2859992.0
2014-09-04 15:00:00	MSFT	Stock	45.16	45.27	45.06	45.25	5491610.0
2014-09-04 16:00:00	MSFT	Stock	45.26	45.28	45.012	45.25	2321568.0
2014-09-04 17:00:00	MSFT	Stock	45.26	45.264	45.24	45.26	208751.0
2014-09-04 18:00:00	MSFT	Stock	45.26	45.28	45.26	45.28	583.0
2014-09-04 19:00:00	MSFT	Stock	45.28	45.28	45.28	45.28	2000.0
2014-09-04 07:00:00	NVDA	Stock	0.4942	0.4942	0.4942	0.4942	4000.0
2014-09-04 08:00:00	NVDA	Stock	0.493	0.493	0.493	0.493	20000.0
2014-09-04 09:00:00	NVDA	Stock	0.4948	0.5038	0.491	0.5034	65853440.0
2014-09-04 10:00:00	NVDA	Stock	0.5035	0.5035	0.4978	0.5025	102743000.0
2014-09-04 11:00:00	NVDA	Stock	0.5024	0.5038	0.501	0.501	42641360.0
2014-09-04 12:00:00	NVDA	Stock	0.501	0.5022	0.499	0.4993	29584520.0
2014-09-04 13:00:00	NVDA	Stock	0.4992	0.5005	0.499	0.499	21059640.0
2014-09-04 14:00:00	NVDA	Stock	0.499	0.4998	0.4974	0.498	26039760.0
2014-09-04 15:00:00	NVDA	Stock	0.4978	0.5015	0.4968	0.5008	145555720.0
2014-09-04 16:00:00	NVDA	Stock	0.5005	0.5033	0.4992	0.5008	19160480.0
2014-09-04 17:00:00	NVDA	Stock	0.5008	0.5008	0.5008	0.5008	638360.0
2014-09-04 04:00:00	AMZN	Stock	17.0225	17.025	17.0225	17.025	4000.0
2014-09-04 05:00:00	AMZN	Stock	17.0275	17.05	17.025	17.05	43600.0
2014-09-04 07:00:00	AMZN	Stock	16.95	17.1625	16.95	17.1625	130140.0
2014-09-04 08:00:00	AMZN	Stock	17.085	17.225	16.925	17.2185	558800.0
2014-09-04 09:00:00	AMZN	Stock	17.2	17.45	17.179	17.3848	17538260.0
2014-09-04 10:00:00	AMZN	Stock	17.3865	17.469	17.3695	17.375	13144500.0
2014-09-04 11:00:00	AMZN	Stock	17.374	17.415	17.3	17.3245	6905600.0
2014-09-04 12:00:00	AMZN	Stock	17.325	17.3885	17.302	17.3215	3623460.0

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

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