PREVIEW / stock_1hour / 2014-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-12-11.parquet
  size:    1.1 MB
  rows:    50,585
  symbols: 3,571

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-12-11 04:00:00	AAPL	Stock	28.05	28.06	28.015	28.0475	28448.0
2014-12-11 05:00:00	AAPL	Stock	28.0525	28.075	28.0375	28.04	64240.0
2014-12-11 06:00:00	AAPL	Stock	28.04	28.0575	27.9675	27.9675	16064.0
2014-12-11 07:00:00	AAPL	Stock	27.975	28.11	27.9375	28.085	156760.0
2014-12-11 08:00:00	AAPL	Stock	28.0825	28.1475	27.97	28.1175	570648.0
2014-12-11 09:00:00	AAPL	Stock	28.1125	28.2975	28.0325	28.2275	22919592.0
2014-12-11 10:00:00	AAPL	Stock	28.2225	28.4325	28.19	28.3725	29853620.0
2014-12-11 11:00:00	AAPL	Stock	28.37	28.45	28.2875	28.3938	15614880.0
2014-12-11 12:00:00	AAPL	Stock	28.3925	28.4325	28.3288	28.345	9056448.0
2014-12-11 13:00:00	AAPL	Stock	28.345	28.3625	28.275	28.28	10317292.0
2014-12-11 14:00:00	AAPL	Stock	28.28	28.2875	27.975	27.9838	21783972.0
2014-12-11 15:00:00	AAPL	Stock	27.9825	28.1725	27.835	27.9075	34343868.0
2014-12-11 16:00:00	AAPL	Stock	27.905	28.3908	27.785	27.8	8792892.0
2014-12-11 17:00:00	AAPL	Stock	27.8	27.905	27.7938	27.8425	321716.0
2014-12-11 18:00:00	AAPL	Stock	27.8425	27.885	27.8425	27.8725	91532.0
2014-12-11 19:00:00	AAPL	Stock	27.87	27.87	27.825	27.8325	69508.0
2014-12-11 06:00:00	MSFT	Stock	46.92	46.92	46.92	46.92	100.0
2014-12-11 08:00:00	MSFT	Stock	47.0	47.1	47.0	47.1	6042.0
2014-12-11 09:00:00	MSFT	Stock	47.05	47.1	46.68	47.005	4448148.0
2014-12-11 10:00:00	MSFT	Stock	47.0	47.5	46.925	47.43	5433187.0
2014-12-11 11:00:00	MSFT	Stock	47.44	47.74	47.42	47.73	2837518.0
2014-12-11 12:00:00	MSFT	Stock	47.73	47.74	47.53	47.63	1600824.0
2014-12-11 13:00:00	MSFT	Stock	47.63	47.69	47.522	47.61	1943990.0
2014-12-11 14:00:00	MSFT	Stock	47.61	47.655	47.27	47.316	2747903.0
2014-12-11 15:00:00	MSFT	Stock	47.315	47.53	47.06	47.18	5271957.0
2014-12-11 16:00:00	MSFT	Stock	47.16	47.655	47.0	47.0	2294376.0
2014-12-11 17:00:00	MSFT	Stock	47.17	47.17	46.98	46.98	41266.0
2014-12-11 18:00:00	MSFT	Stock	47.02	47.02	47.02	47.02	250.0
2014-12-11 19:00:00	MSFT	Stock	47.02	47.02	47.02	47.02	750.0
2014-12-11 09:00:00	NVDA	Stock	0.51	0.5133	0.5055	0.5088	17451200.0
2014-12-11 10:00:00	NVDA	Stock	0.5088	0.5125	0.5088	0.5101	20182480.0
2014-12-11 11:00:00	NVDA	Stock	0.5101	0.512	0.5091	0.5112	13565000.0
2014-12-11 12:00:00	NVDA	Stock	0.5115	0.5122	0.5102	0.5115	10665760.0
2014-12-11 13:00:00	NVDA	Stock	0.5112	0.5118	0.5095	0.5095	10134800.0
2014-12-11 14:00:00	NVDA	Stock	0.5095	0.5108	0.5068	0.5072	16837800.0
2014-12-11 15:00:00	NVDA	Stock	0.5071	0.51	0.5055	0.5068	31436960.0
2014-12-11 16:00:00	NVDA	Stock	0.5065	0.5108	0.506	0.5104	10452000.0
2014-12-11 17:00:00	NVDA	Stock	0.5065	0.5065	0.5065	0.5065	106480.0
2014-12-11 06:00:00	AMZN	Stock	15.359	15.359	15.359	15.359	2000.0
2014-12-11 07:00:00	AMZN	Stock	15.3065	15.3065	15.3065	15.3065	4020.0
2014-12-11 08:00:00	AMZN	Stock	15.292	15.417	15.292	15.4005	239540.0
2014-12-11 09:00:00	AMZN	Stock	15.405	15.458	15.3005	15.4555	7666440.0
2014-12-11 10:00:00	AMZN	Stock	15.4505	15.632	15.441	15.509	14338780.0
2014-12-11 11:00:00	AMZN	Stock	15.504	15.5985	15.455	15.5451	8981080.0
2014-12-11 12:00:00	AMZN	Stock	15.5495	15.5555	15.475	15.5458	5126020.0
2014-12-11 13:00:00	AMZN	Stock	15.5445	15.5535	15.488	15.505	3932940.0
2014-12-11 14:00:00	AMZN	Stock	15.5045	15.5405	15.3525	15.3635	7575520.0
2014-12-11 15:00:00	AMZN	Stock	15.369	15.466	15.345	15.368	9036900.0
2014-12-11 16:00:00	AMZN	Stock	15.368	15.4788	15.3085	15.3085	2280340.0
2014-12-11 17:00:00	AMZN	Stock	15.368	15.368	15.281	15.281	83020.0

> showing 50 of 50,585 rows — these rows as CSV

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