PREVIEW / stock_1hour / 2013-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-11.parquet
  size:    1.0 MB
  rows:    47,531
  symbols: 3,529

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-12-11 04:00:00	AAPL	Stock	20.1786	20.2079	20.1786	20.2079	18536.0
2013-12-11 05:00:00	AAPL	Stock	20.2329	20.2329	20.2289	20.2289	5600.0
2013-12-11 06:00:00	AAPL	Stock	20.2204	20.2204	20.1954	20.1954	102116.0
2013-12-11 07:00:00	AAPL	Stock	20.2021	20.2679	20.1464	20.2679	202272.0
2013-12-11 08:00:00	AAPL	Stock	20.2696	20.3107	20.1786	20.2729	1139488.0
2013-12-11 09:00:00	AAPL	Stock	20.28	20.3918	20.2321	20.2989	52281992.0
2013-12-11 10:00:00	AAPL	Stock	20.2936	20.3104	20.1829	20.2839	50376480.0
2013-12-11 11:00:00	AAPL	Stock	20.2802	20.2989	20.1944	20.2032	28332976.0
2013-12-11 12:00:00	AAPL	Stock	20.2018	20.2057	20.0997	20.1218	35242284.0
2013-12-11 13:00:00	AAPL	Stock	20.1218	20.1571	20.0614	20.1118	33548256.0
2013-12-11 14:00:00	AAPL	Stock	20.11	20.125	20.0293	20.055	28763924.0
2013-12-11 15:00:00	AAPL	Stock	20.0571	20.0829	19.9889	20.0407	45663492.0
2013-12-11 16:00:00	AAPL	Stock	20.0454	20.255	20.0139	20.0571	24575572.0
2013-12-11 17:00:00	AAPL	Stock	20.0586	20.0693	20.0486	20.0486	141288.0
2013-12-11 18:00:00	AAPL	Stock	20.0679	20.0771	20.0589	20.0589	130424.0
2013-12-11 19:00:00	AAPL	Stock	20.0636	20.0714	20.0554	20.0679	172872.0
2013-12-11 06:00:00	MSFT	Stock	38.15	38.15	38.15	38.15	1665.0
2013-12-11 07:00:00	MSFT	Stock	38.2	38.36	38.2	38.3	1200.0
2013-12-11 08:00:00	MSFT	Stock	38.3	38.32	38.22	38.23	37066.0
2013-12-11 09:00:00	MSFT	Stock	38.23	38.3	37.86	37.95	4651305.0
2013-12-11 10:00:00	MSFT	Stock	37.95	37.95	37.66	37.675	5521242.0
2013-12-11 11:00:00	MSFT	Stock	37.675	37.74	37.57	37.6	3804697.0
2013-12-11 12:00:00	MSFT	Stock	37.605	37.61	37.39	37.45	5159947.0
2013-12-11 13:00:00	MSFT	Stock	37.45	37.7	37.45	37.66	3490382.0
2013-12-11 14:00:00	MSFT	Stock	37.665	37.67	37.6	37.61	3213207.0
2013-12-11 15:00:00	MSFT	Stock	37.61	37.66	37.55	37.605	7369538.0
2013-12-11 16:00:00	MSFT	Stock	37.6	37.696	37.57	37.63	4223754.0
2013-12-11 17:00:00	MSFT	Stock	37.63	37.63	37.56	37.56	245.0
2013-12-11 18:00:00	MSFT	Stock	37.67	37.67	37.67	37.67	1490.0
2013-12-11 19:00:00	MSFT	Stock	37.67	37.67	37.63	37.63	3057.0
2013-12-11 09:00:00	NVDA	Stock	0.389	0.3902	0.3862	0.3875	87213080.0
2013-12-11 10:00:00	NVDA	Stock	0.3875	0.389	0.387	0.388	69771840.0
2013-12-11 11:00:00	NVDA	Stock	0.388	0.3886	0.386	0.3864	32084440.0
2013-12-11 12:00:00	NVDA	Stock	0.3865	0.3878	0.3855	0.3878	30344760.0
2013-12-11 13:00:00	NVDA	Stock	0.3876	0.3882	0.387	0.3874	14571280.0
2013-12-11 14:00:00	NVDA	Stock	0.3875	0.3878	0.3862	0.3866	22679960.0
2013-12-11 15:00:00	NVDA	Stock	0.3868	0.3873	0.3845	0.3855	55015360.0
2013-12-11 16:00:00	NVDA	Stock	0.3853	0.3867	0.385	0.3853	15051200.0
2013-12-11 05:00:00	AMZN	Stock	19.3675	19.3675	19.3675	19.3675	2080.0
2013-12-11 07:00:00	AMZN	Stock	19.3855	19.401	19.3855	19.389	12140.0
2013-12-11 08:00:00	AMZN	Stock	19.363	19.434	19.363	19.4225	25920.0
2013-12-11 09:00:00	AMZN	Stock	19.417	19.449	19.291	19.3581	6842640.0
2013-12-11 10:00:00	AMZN	Stock	19.3495	19.4375	19.2625	19.3903	8072540.0
2013-12-11 11:00:00	AMZN	Stock	19.391	19.4	19.3	19.3318	4399440.0
2013-12-11 12:00:00	AMZN	Stock	19.331	19.3405	19.205	19.208	5978380.0
2013-12-11 13:00:00	AMZN	Stock	19.2135	19.2905	19.2065	19.2885	3259760.0
2013-12-11 14:00:00	AMZN	Stock	19.2804	19.2885	19.1535	19.1606	4102640.0
2013-12-11 15:00:00	AMZN	Stock	19.1685	19.186	19.1	19.1095	7416540.0
2013-12-11 16:00:00	AMZN	Stock	19.1095	19.3705	19.105	19.1235	3823880.0
2013-12-11 17:00:00	AMZN	Stock	19.2	19.2	19.2	19.2	2000.0

> showing 50 of 47,531 rows — these rows as CSV

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