PREVIEW / stock_1hour / 2013-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-01-23.parquet
  size:    965 KB
  rows:    45,613
  symbols: 3,489

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
2013-01-23 04:00:00	AAPL	Stock	18.1143	18.125	18.0939	18.1225	22400.0
2013-01-23 05:00:00	AAPL	Stock	18.1164	18.1429	18.1164	18.125	45080.0
2013-01-23 06:00:00	AAPL	Stock	18.1268	18.1429	18.125	18.1393	37100.0
2013-01-23 07:00:00	AAPL	Stock	18.1571	18.1775	18.0918	18.0918	696836.0
2013-01-23 08:00:00	AAPL	Stock	18.0993	18.1811	18.0214	18.1182	3291932.0
2013-01-23 09:00:00	AAPL	Stock	18.1179	18.2429	18.0275	18.1121	72858604.0
2013-01-23 10:00:00	AAPL	Stock	18.1146	18.3371	18.1043	18.2496	121219476.0
2013-01-23 11:00:00	AAPL	Stock	18.2514	18.2768	18.1429	18.1782	69312740.0
2013-01-23 12:00:00	AAPL	Stock	18.1732	18.2821	18.1525	18.2646	48926416.0
2013-01-23 13:00:00	AAPL	Stock	18.2666	18.3304	18.211	18.2157	74888912.0
2013-01-23 14:00:00	AAPL	Stock	18.2143	18.3721	18.1586	18.3423	85843828.0
2013-01-23 15:00:00	AAPL	Stock	18.3454	18.3925	18.2954	18.3571	118478696.0
2013-01-23 16:00:00	AAPL	Stock	18.3571	18.8561	17.2679	17.2682	105085372.0
2013-01-23 17:00:00	AAPL	Stock	17.2689	17.2736	16.385	16.385	113657992.0
2013-01-23 18:00:00	AAPL	Stock	16.385	16.5	16.3321	16.4946	23061584.0
2013-01-23 19:00:00	AAPL	Stock	16.4893	16.5636	16.4464	16.5532	5091072.0
2013-01-23 07:00:00	MSFT	Stock	27.29	27.29	27.27	27.27	2400.0
2013-01-23 08:00:00	MSFT	Stock	27.27	27.32	27.1	27.3	29517.0
2013-01-23 09:00:00	MSFT	Stock	27.28	27.58	27.17	27.55	8822215.0
2013-01-23 10:00:00	MSFT	Stock	27.54	27.635	27.44	27.48	6592944.0
2013-01-23 11:00:00	MSFT	Stock	27.48	27.58	27.41	27.49	4527961.0
2013-01-23 12:00:00	MSFT	Stock	27.48	27.52	27.42	27.5	3059304.0
2013-01-23 13:00:00	MSFT	Stock	27.5	27.54	27.47	27.539	2609757.0
2013-01-23 14:00:00	MSFT	Stock	27.54	27.56	27.47	27.493	5187430.0
2013-01-23 15:00:00	MSFT	Stock	27.49	27.61	27.46	27.6	14380336.0
2013-01-23 16:00:00	MSFT	Stock	27.6	27.62	27.15	27.55	3526017.0
2013-01-23 17:00:00	MSFT	Stock	27.57	27.61	27.31	27.33	120207.0
2013-01-23 18:00:00	MSFT	Stock	27.34	27.51	27.33	27.5	30151.0
2013-01-23 19:00:00	MSFT	Stock	27.51	27.55	27.48	27.55	40305.0
2013-01-23 07:00:00	NVDA	Stock	0.3065	0.3075	0.3065	0.3075	64400.0
2013-01-23 08:00:00	NVDA	Stock	0.3032	0.3038	0.3032	0.3038	91200.0
2013-01-23 09:00:00	NVDA	Stock	0.3045	0.3045	0.3005	0.301	45332840.0
2013-01-23 10:00:00	NVDA	Stock	0.301	0.3019	0.3	0.3002	97001360.0
2013-01-23 11:00:00	NVDA	Stock	0.3005	0.301	0.3	0.3002	44517440.0
2013-01-23 12:00:00	NVDA	Stock	0.3002	0.3022	0.3	0.302	56481440.0
2013-01-23 13:00:00	NVDA	Stock	0.3021	0.3022	0.3012	0.3018	29209800.0
2013-01-23 14:00:00	NVDA	Stock	0.302	0.3035	0.3012	0.3018	61048440.0
2013-01-23 15:00:00	NVDA	Stock	0.3018	0.3032	0.301	0.3031	74481200.0
2013-01-23 16:00:00	NVDA	Stock	0.3032	0.3038	0.3014	0.3032	7409560.0
2013-01-23 17:00:00	NVDA	Stock	0.3015	0.302	0.3005	0.3005	364400.0
2013-01-23 18:00:00	NVDA	Stock	0.3005	0.3005	0.3005	0.3005	78800.0
2013-01-23 19:00:00	NVDA	Stock	0.3008	0.3008	0.3002	0.3002	204000.0
2013-01-23 04:00:00	AMZN	Stock	13.552	13.552	13.552	13.552	2000.0
2013-01-23 06:00:00	AMZN	Stock	13.575	13.575	13.575	13.575	2000.0
2013-01-23 07:00:00	AMZN	Stock	13.5905	13.612	13.5905	13.6	27380.0
2013-01-23 08:00:00	AMZN	Stock	13.5875	13.595	13.58	13.585	74200.0
2013-01-23 09:00:00	AMZN	Stock	13.5805	13.5805	13.3725	13.388	9921320.0
2013-01-23 10:00:00	AMZN	Stock	13.388	13.3965	13.3325	13.3508	10408180.0
2013-01-23 11:00:00	AMZN	Stock	13.35	13.387	13.335	13.3798	5967160.0
2013-01-23 12:00:00	AMZN	Stock	13.373	13.4055	13.3675	13.389	4607680.0

> showing 50 of 45,613 rows — these rows as CSV

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