PREVIEW / stock_1hour / 2016-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-01-22.parquet
  size:    1.0 MB
  rows:    49,267
  symbols: 3,401

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-01-22 04:00:00	AAPL	Stock	24.44	24.595	24.44	24.5375	22140.0
2016-01-22 05:00:00	AAPL	Stock	24.4375	24.5125	24.425	24.4825	6848.0
2016-01-22 06:00:00	AAPL	Stock	24.45	24.5625	24.38	24.5125	91932.0
2016-01-22 07:00:00	AAPL	Stock	24.5325	24.6	24.4725	24.595	342496.0
2016-01-22 08:00:00	AAPL	Stock	24.58	24.62	24.4875	24.5225	816560.0
2016-01-22 09:00:00	AAPL	Stock	24.5225	24.96	24.4925	24.9575	33836268.0
2016-01-22 10:00:00	AAPL	Stock	24.9575	25.045	24.815	24.8678	45080424.0
2016-01-22 11:00:00	AAPL	Stock	24.8675	24.905	24.725	24.845	31333840.0
2016-01-22 12:00:00	AAPL	Stock	24.8425	25.07	24.8307	25.045	27045972.0
2016-01-22 13:00:00	AAPL	Stock	25.0475	25.0975	25.0025	25.0885	18688668.0
2016-01-22 14:00:00	AAPL	Stock	25.09	25.23	25.065	25.2242	29710244.0
2016-01-22 15:00:00	AAPL	Stock	25.225	25.365	25.1425	25.355	44954040.0
2016-01-22 16:00:00	AAPL	Stock	25.355	25.375	25.31	25.365	9707588.0
2016-01-22 17:00:00	AAPL	Stock	25.37	25.4175	25.365	25.4125	193700.0
2016-01-22 18:00:00	AAPL	Stock	25.4	25.4675	25.3875	25.4575	153916.0
2016-01-22 19:00:00	AAPL	Stock	25.4475	25.495	25.4275	25.495	259884.0
2016-01-22 04:00:00	MSFT	Stock	50.95	51.4	50.95	51.24	2647.0
2016-01-22 06:00:00	MSFT	Stock	51.39	51.4	51.39	51.4	3062.0
2016-01-22 07:00:00	MSFT	Stock	51.25	51.46	51.2	51.21	8573.0
2016-01-22 08:00:00	MSFT	Stock	51.25	51.4	51.25	51.25	73091.0
2016-01-22 09:00:00	MSFT	Stock	51.28	51.9	51.26	51.689	4400736.0
2016-01-22 10:00:00	MSFT	Stock	51.685	52.33	51.68	51.93	6545852.0
2016-01-22 11:00:00	MSFT	Stock	51.93	52.16	51.765	52.046	4336363.0
2016-01-22 12:00:00	MSFT	Stock	52.04	52.28	51.995	52.111	2869569.0
2016-01-22 13:00:00	MSFT	Stock	52.118	52.245	51.995	52.2	2350653.0
2016-01-22 14:00:00	MSFT	Stock	52.191	52.3	52.06	52.23	3559550.0
2016-01-22 15:00:00	MSFT	Stock	52.23	52.3	52.02	52.29	6786720.0
2016-01-22 16:00:00	MSFT	Stock	52.29	52.29	52.2	52.29	3041252.0
2016-01-22 17:00:00	MSFT	Stock	52.29	52.47	52.25	52.4	9827.0
2016-01-22 18:00:00	MSFT	Stock	52.38	52.4	52.35	52.4	15975.0
2016-01-22 19:00:00	MSFT	Stock	52.4	52.5	52.4	52.45	10573.0
2016-01-22 07:00:00	NVDA	Stock	0.7	0.7	0.7	0.7	12000.0
2016-01-22 08:00:00	NVDA	Stock	0.7098	0.7098	0.7098	0.7098	4000.0
2016-01-22 09:00:00	NVDA	Stock	0.7083	0.716	0.7072	0.7123	33288800.0
2016-01-22 10:00:00	NVDA	Stock	0.712	0.7139	0.7074	0.7106	45713920.0
2016-01-22 11:00:00	NVDA	Stock	0.7106	0.7138	0.7075	0.7075	26229200.0
2016-01-22 12:00:00	NVDA	Stock	0.7072	0.7103	0.7068	0.7098	18637800.0
2016-01-22 13:00:00	NVDA	Stock	0.7098	0.7114	0.7072	0.7113	18449840.0
2016-01-22 14:00:00	NVDA	Stock	0.7113	0.7133	0.7095	0.7115	19527800.0
2016-01-22 15:00:00	NVDA	Stock	0.7115	0.7124	0.708	0.7113	58109400.0
2016-01-22 16:00:00	NVDA	Stock	0.7113	0.7118	0.709	0.7118	18341440.0
2016-01-22 17:00:00	NVDA	Stock	0.71	0.71	0.71	0.71	16000.0
2016-01-22 04:00:00	AMZN	Stock	29.315	29.315	29.15	29.15	20020.0
2016-01-22 05:00:00	AMZN	Stock	29.15	29.15	29.15	29.15	2380.0
2016-01-22 06:00:00	AMZN	Stock	29.163	29.2875	29.163	29.2875	45680.0
2016-01-22 07:00:00	AMZN	Stock	29.25	29.4	29.21	29.35	162160.0
2016-01-22 08:00:00	AMZN	Stock	29.322	29.35	29.2445	29.2445	349340.0
2016-01-22 09:00:00	AMZN	Stock	29.245	29.495	29.2054	29.39	12707500.0
2016-01-22 10:00:00	AMZN	Stock	29.391	29.727	29.377	29.6071	17953760.0
2016-01-22 11:00:00	AMZN	Stock	29.6005	29.7643	29.534	29.6156	13993940.0

> showing 50 of 49,267 rows — these rows as CSV

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