PREVIEW / stock_1hour / 2015-01-28

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-28.parquet
  size:    1.0 MB
  rows:    48,766
  symbols: 3,524

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-01-28 04:00:00	AAPL	Stock	28.87	29.1225	28.87	29.05	296616.0
2015-01-28 05:00:00	AAPL	Stock	29.0275	29.0925	28.9	28.975	87940.0
2015-01-28 06:00:00	AAPL	Stock	29.0	29.36	29.0	29.275	1289180.0
2015-01-28 07:00:00	AAPL	Stock	29.2875	29.8125	29.2575	29.5075	5841696.0
2015-01-28 08:00:00	AAPL	Stock	29.4875	29.81	28.575	29.4625	12944216.0
2015-01-28 09:00:00	AAPL	Stock	29.4625	29.5025	28.96	29.2788	142180632.0
2015-01-28 10:00:00	AAPL	Stock	29.28	29.53	29.03	29.0775	106720476.0
2015-01-28 11:00:00	AAPL	Stock	29.0775	29.2375	28.8775	29.18	62627144.0
2015-01-28 12:00:00	AAPL	Stock	29.1825	29.435	29.175	29.4075	50649564.0
2015-01-28 13:00:00	AAPL	Stock	29.4072	29.41	29.2725	29.3662	29466956.0
2015-01-28 14:00:00	AAPL	Stock	29.3675	29.4275	29.1062	29.2625	47932536.0
2015-01-28 15:00:00	AAPL	Stock	29.2612	29.3175	28.83	28.83	67295440.0
2015-01-28 16:00:00	AAPL	Stock	28.83	29.3975	28.8025	28.8375	17016828.0
2015-01-28 17:00:00	AAPL	Stock	28.8375	28.875	28.815	28.8425	458496.0
2015-01-28 18:00:00	AAPL	Stock	28.845	28.9	28.8275	28.8975	398620.0
2015-01-28 19:00:00	AAPL	Stock	28.895	28.9375	28.8925	28.9325	406632.0
2015-01-28 04:00:00	MSFT	Stock	43.18	43.2	43.1	43.2	9500.0
2015-01-28 05:00:00	MSFT	Stock	43.17	43.17	43.05	43.05	5700.0
2015-01-28 06:00:00	MSFT	Stock	42.99	43.1	42.99	43.1	10342.0
2015-01-28 07:00:00	MSFT	Stock	43.03	43.1	42.9	43.0	26459.0
2015-01-28 08:00:00	MSFT	Stock	43.0	43.1	42.8	42.8	132456.0
2015-01-28 09:00:00	MSFT	Stock	42.81	42.84	42.2	42.365	10532545.0
2015-01-28 10:00:00	MSFT	Stock	42.36	42.45	42.15	42.18	10522406.0
2015-01-28 11:00:00	MSFT	Stock	42.178	42.3	41.9	42.155	10247283.0
2015-01-28 12:00:00	MSFT	Stock	42.155	42.3	42.09	42.23	5522835.0
2015-01-28 13:00:00	MSFT	Stock	42.235	42.38	42.16	42.165	6318438.0
2015-01-28 14:00:00	MSFT	Stock	42.165	42.35	41.78	41.98	10788442.0
2015-01-28 15:00:00	MSFT	Stock	41.978	42.03	41.16	41.2	21863072.0
2015-01-28 16:00:00	MSFT	Stock	41.2	42.225	41.02	41.15	4822695.0
2015-01-28 17:00:00	MSFT	Stock	41.12	41.2	41.12	41.2	19870.0
2015-01-28 18:00:00	MSFT	Stock	41.19	41.23	41.13	41.13	30364.0
2015-01-28 19:00:00	MSFT	Stock	41.15	41.23	41.15	41.22	14180.0
2015-01-28 07:00:00	NVDA	Stock	0.4978	0.4978	0.4978	0.4978	36000.0
2015-01-28 08:00:00	NVDA	Stock	0.4988	0.5	0.4975	0.4975	148000.0
2015-01-28 09:00:00	NVDA	Stock	0.4982	0.4988	0.4912	0.4978	24419160.0
2015-01-28 10:00:00	NVDA	Stock	0.4978	0.4985	0.4898	0.4905	31276720.0
2015-01-28 11:00:00	NVDA	Stock	0.4902	0.4928	0.4888	0.491	26092600.0
2015-01-28 12:00:00	NVDA	Stock	0.491	0.4932	0.4908	0.4918	13925520.0
2015-01-28 13:00:00	NVDA	Stock	0.492	0.4925	0.4902	0.491	14542880.0
2015-01-28 14:00:00	NVDA	Stock	0.491	0.4938	0.4875	0.49	27301400.0
2015-01-28 15:00:00	NVDA	Stock	0.4901	0.491	0.4825	0.4828	111060600.0
2015-01-28 16:00:00	NVDA	Stock	0.4828	0.4916	0.4822	0.4822	19242240.0
2015-01-28 17:00:00	NVDA	Stock	0.4838	0.4838	0.4838	0.4838	4000.0
2015-01-28 18:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	8000.0
2015-01-28 19:00:00	NVDA	Stock	0.483	0.483	0.483	0.483	8000.0
2015-01-28 06:00:00	AMZN	Stock	15.5035	15.5035	15.5035	15.5035	5820.0
2015-01-28 07:00:00	AMZN	Stock	15.5	15.5005	15.5	15.5005	4300.0
2015-01-28 08:00:00	AMZN	Stock	15.48	15.5	15.4515	15.4515	72620.0
2015-01-28 09:00:00	AMZN	Stock	15.4525	15.5755	15.28	15.2815	7647140.0
2015-01-28 10:00:00	AMZN	Stock	15.28	15.4223	15.1965	15.2515	10490220.0

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

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