PREVIEW / stock_1hour / 2016-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-23.parquet
  size:    1.0 MB
  rows:    48,021
  symbols: 3,170

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-11-23 04:00:00	AAPL	Stock	27.9475	27.95	27.9175	27.925	8536.0
2016-11-23 05:00:00	AAPL	Stock	27.925	27.925	27.9	27.9	3988.0
2016-11-23 07:00:00	AAPL	Stock	27.9475	27.975	27.93	27.93	5676.0
2016-11-23 08:00:00	AAPL	Stock	27.95	27.9525	27.8625	27.875	114760.0
2016-11-23 09:00:00	AAPL	Stock	27.8875	27.915	27.6825	27.735	14749000.0
2016-11-23 10:00:00	AAPL	Stock	27.735	27.7675	27.5825	27.5975	17242500.0
2016-11-23 11:00:00	AAPL	Stock	27.5988	27.7175	27.5975	27.7175	12287668.0
2016-11-23 12:00:00	AAPL	Stock	27.7175	27.77	27.6925	27.7375	9146384.0
2016-11-23 13:00:00	AAPL	Stock	27.7375	27.7938	27.6725	27.7625	7375808.0
2016-11-23 14:00:00	AAPL	Stock	27.7625	27.8425	27.7525	27.7625	8495128.0
2016-11-23 15:00:00	AAPL	Stock	27.7602	27.81	27.725	27.8062	14437352.0
2016-11-23 16:00:00	AAPL	Stock	27.8075	27.835	27.7825	27.805	17704436.0
2016-11-23 17:00:00	AAPL	Stock	27.8125	27.8125	27.8125	27.8125	444.0
2016-11-23 18:00:00	AAPL	Stock	27.8	27.81	27.8	27.8	5968.0
2016-11-23 19:00:00	AAPL	Stock	27.8	27.8125	27.7875	27.7875	11560.0
2016-11-23 05:00:00	MSFT	Stock	61.14	61.14	61.07	61.07	1516.0
2016-11-23 06:00:00	MSFT	Stock	61.06	61.06	61.06	61.06	240.0
2016-11-23 07:00:00	MSFT	Stock	61.17	61.17	61.17	61.17	414.0
2016-11-23 08:00:00	MSFT	Stock	61.15	61.15	60.95	61.1	3086.0
2016-11-23 09:00:00	MSFT	Stock	61.12	61.12	60.46	60.615	2835653.0
2016-11-23 10:00:00	MSFT	Stock	60.61	60.73	60.37	60.435	2435281.0
2016-11-23 11:00:00	MSFT	Stock	60.449	60.47	60.25	60.345	1854807.0
2016-11-23 12:00:00	MSFT	Stock	60.34	60.48	60.27	60.29	1357766.0
2016-11-23 13:00:00	MSFT	Stock	60.3	60.38	60.25	60.26	1147212.0
2016-11-23 14:00:00	MSFT	Stock	60.26	60.46	60.26	60.344	1889958.0
2016-11-23 15:00:00	MSFT	Stock	60.35	60.4	60.3	60.4	3855672.0
2016-11-23 16:00:00	MSFT	Stock	60.4	60.45	60.38	60.4	4765593.0
2016-11-23 17:00:00	MSFT	Stock	60.42	60.44	60.36	60.36	799.0
2016-11-23 19:00:00	MSFT	Stock	60.4	60.4	60.39	60.39	698.0
2016-11-23 04:00:00	NVDA	Stock	2.3433	2.3433	2.3433	2.3433	48480.0
2016-11-23 07:00:00	NVDA	Stock	2.3398	2.3398	2.3398	2.3398	20000.0
2016-11-23 08:00:00	NVDA	Stock	2.3392	2.35	2.3392	2.347	375320.0
2016-11-23 09:00:00	NVDA	Stock	2.347	2.3473	2.3192	2.3343	32890360.0
2016-11-23 10:00:00	NVDA	Stock	2.3343	2.3812	2.334	2.3758	94797600.0
2016-11-23 11:00:00	NVDA	Stock	2.3755	2.381	2.3552	2.36	42833840.0
2016-11-23 12:00:00	NVDA	Stock	2.36	2.3642	2.3473	2.3525	126734720.0
2016-11-23 13:00:00	NVDA	Stock	2.3532	2.3572	2.336	2.3404	28655680.0
2016-11-23 14:00:00	NVDA	Stock	2.3406	2.3528	2.337	2.3448	24779200.0
2016-11-23 15:00:00	NVDA	Stock	2.3448	2.3495	2.3422	2.349	35788160.0
2016-11-23 16:00:00	NVDA	Stock	2.3492	2.3497	2.347	2.3485	9301320.0
2016-11-23 17:00:00	NVDA	Stock	2.3485	2.3485	2.3485	2.3485	23800.0
2016-11-23 18:00:00	NVDA	Stock	2.3485	2.3488	2.3485	2.3488	221360.0
2016-11-23 19:00:00	NVDA	Stock	2.3488	2.3488	2.3488	2.3488	4000.0
2016-11-23 05:00:00	AMZN	Stock	39.3	39.3	39.3	39.3	2000.0
2016-11-23 07:00:00	AMZN	Stock	39.151	39.2245	39.144	39.2245	24820.0
2016-11-23 08:00:00	AMZN	Stock	39.05	39.2	39.05	39.08	164760.0
2016-11-23 09:00:00	AMZN	Stock	39.06	39.0875	38.656	38.84	13206400.0
2016-11-23 10:00:00	AMZN	Stock	38.8295	38.8675	38.6625	38.7185	10901420.0
2016-11-23 11:00:00	AMZN	Stock	38.7285	38.787	38.66	38.75	6976240.0
2016-11-23 12:00:00	AMZN	Stock	38.755	38.9439	38.7162	38.9405	8039120.0

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

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