PREVIEW / stock_1hour / 2014-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-01-22.parquet
  size:    1.0 MB
  rows:    48,263
  symbols: 3,538

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-01-22 05:00:00	AAPL	Stock	19.575	19.575	19.5732	19.575	16800.0
2014-01-22 06:00:00	AAPL	Stock	19.575	19.5757	19.575	19.5757	5600.0
2014-01-22 07:00:00	AAPL	Stock	19.5979	19.6954	19.5979	19.6764	310940.0
2014-01-22 08:00:00	AAPL	Stock	19.6725	19.6954	19.6557	19.6921	1120700.0
2014-01-22 09:00:00	AAPL	Stock	19.6929	19.7357	19.5646	19.6414	40835200.0
2014-01-22 10:00:00	AAPL	Stock	19.6408	19.8725	19.6368	19.8646	83279812.0
2014-01-22 11:00:00	AAPL	Stock	19.8704	19.9032	19.8046	19.8482	43901368.0
2014-01-22 12:00:00	AAPL	Stock	19.8486	19.8936	19.8161	19.8296	30878008.0
2014-01-22 13:00:00	AAPL	Stock	19.8296	19.8321	19.665	19.6964	47082028.0
2014-01-22 14:00:00	AAPL	Stock	19.7	19.7571	19.6804	19.6921	22095528.0
2014-01-22 15:00:00	AAPL	Stock	19.6961	19.7282	19.6732	19.6968	31015936.0
2014-01-22 16:00:00	AAPL	Stock	19.6961	19.8039	19.6814	19.7321	11726708.0
2014-01-22 17:00:00	AAPL	Stock	19.725	19.7554	19.6968	19.7382	923384.0
2014-01-22 18:00:00	AAPL	Stock	19.7375	19.7636	19.7321	19.7625	195972.0
2014-01-22 19:00:00	AAPL	Stock	19.7507	19.7704	19.7468	19.7554	229852.0
2014-01-22 04:00:00	MSFT	Stock	36.24	36.24	36.24	36.24	553.0
2014-01-22 06:00:00	MSFT	Stock	36.26	36.26	36.26	36.26	400.0
2014-01-22 07:00:00	MSFT	Stock	36.23	36.23	36.17	36.17	400.0
2014-01-22 08:00:00	MSFT	Stock	36.16	36.28	36.141	36.28	3888.0
2014-01-22 09:00:00	MSFT	Stock	36.28	36.34	35.75	36.06	3778082.0
2014-01-22 10:00:00	MSFT	Stock	36.06	36.155	35.91	35.94	2942367.0
2014-01-22 11:00:00	MSFT	Stock	35.95	36.09	35.92	36.0	1581764.0
2014-01-22 12:00:00	MSFT	Stock	36.002	36.13	35.985	36.125	1514881.0
2014-01-22 13:00:00	MSFT	Stock	36.13	36.175	36.06	36.08	1897800.0
2014-01-22 14:00:00	MSFT	Stock	36.08	36.14	36.05	36.06	2014729.0
2014-01-22 15:00:00	MSFT	Stock	36.06	36.085	35.93	35.94	4805047.0
2014-01-22 16:00:00	MSFT	Stock	35.93	36.17	35.923	36.15	2361723.0
2014-01-22 17:00:00	MSFT	Stock	36.15	36.26	36.03	36.25	55400.0
2014-01-22 18:00:00	MSFT	Stock	36.24	36.24	36.17	36.18	6450.0
2014-01-22 19:00:00	MSFT	Stock	36.25	36.25	36.17	36.17	7427.0
2014-01-22 09:00:00	NVDA	Stock	0.402	0.4025	0.396	0.3988	50537120.0
2014-01-22 10:00:00	NVDA	Stock	0.3987	0.4003	0.3982	0.3995	59458360.0
2014-01-22 11:00:00	NVDA	Stock	0.3998	0.3999	0.3985	0.399	21273520.0
2014-01-22 12:00:00	NVDA	Stock	0.3988	0.3998	0.3988	0.3995	8220800.0
2014-01-22 13:00:00	NVDA	Stock	0.3994	0.4	0.399	0.3996	15294280.0
2014-01-22 14:00:00	NVDA	Stock	0.3996	0.4001	0.3993	0.3998	37847520.0
2014-01-22 15:00:00	NVDA	Stock	0.3998	0.4015	0.3993	0.4008	127163120.0
2014-01-22 16:00:00	NVDA	Stock	0.4008	0.4013	0.4007	0.4007	13925400.0
2014-01-22 07:00:00	AMZN	Stock	20.334	20.334	20.334	20.334	9000.0
2014-01-22 08:00:00	AMZN	Stock	20.3375	20.343	20.295	20.3415	20000.0
2014-01-22 09:00:00	AMZN	Stock	20.3325	20.42	20.225	20.252	6075120.0
2014-01-22 10:00:00	AMZN	Stock	20.2625	20.276	20.1	20.122	6944200.0
2014-01-22 11:00:00	AMZN	Stock	20.126	20.18	20.1111	20.143	4293000.0
2014-01-22 12:00:00	AMZN	Stock	20.149	20.3008	20.1335	20.27	3516480.0
2014-01-22 13:00:00	AMZN	Stock	20.275	20.3013	20.219	20.24	3409980.0
2014-01-22 14:00:00	AMZN	Stock	20.251	20.2695	20.193	20.202	2488180.0
2014-01-22 15:00:00	AMZN	Stock	20.205	20.27	20.201	20.2262	7010160.0
2014-01-22 16:00:00	AMZN	Stock	20.227	20.45	20.2	20.4	2656380.0
2014-01-22 17:00:00	AMZN	Stock	20.4125	20.425	20.3715	20.3715	47180.0
2014-01-22 18:00:00	AMZN	Stock	20.3336	20.4165	20.3336	20.3785	116280.0

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

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