PREVIEW / stock_1hour / 2012-06-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-21.parquet
  size:    935 KB
  rows:    44,190
  symbols: 3,491

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
2012-06-21 04:00:00	AAPL	Stock	20.8571	20.8571	20.8393	20.8393	30800.0
2012-06-21 07:00:00	AAPL	Stock	20.8929	20.9375	20.8925	20.9125	84420.0
2012-06-21 08:00:00	AAPL	Stock	20.9125	20.9268	20.8857	20.8929	406812.0
2012-06-21 09:00:00	AAPL	Stock	20.8929	20.9925	20.8736	20.9273	32828684.0
2012-06-21 10:00:00	AAPL	Stock	20.9293	21.0079	20.8643	20.9943	50751848.0
2012-06-21 11:00:00	AAPL	Stock	20.9932	20.9996	20.8689	20.8889	43380344.0
2012-06-21 12:00:00	AAPL	Stock	20.8883	20.9007	20.7954	20.8279	34573392.0
2012-06-21 13:00:00	AAPL	Stock	20.8286	20.8704	20.7736	20.8212	30389044.0
2012-06-21 14:00:00	AAPL	Stock	20.8205	20.8318	20.7275	20.7846	40271308.0
2012-06-21 15:00:00	AAPL	Stock	20.7811	20.7822	20.6229	20.6286	77778400.0
2012-06-21 16:00:00	AAPL	Stock	20.63	20.9442	20.6254	20.6429	9140516.0
2012-06-21 17:00:00	AAPL	Stock	20.6429	20.6768	20.63	20.67	331352.0
2012-06-21 18:00:00	AAPL	Stock	20.6607	20.6714	20.6607	20.6671	118580.0
2012-06-21 19:00:00	AAPL	Stock	20.6607	20.6789	20.6504	20.6789	149072.0
2012-06-21 07:00:00	MSFT	Stock	30.9	31.0	30.9	31.0	5400.0
2012-06-21 08:00:00	MSFT	Stock	30.94	30.98	30.87	30.93	18604.0
2012-06-21 09:00:00	MSFT	Stock	30.94	31.14	30.87	30.89	4967289.0
2012-06-21 10:00:00	MSFT	Stock	30.885	30.99	30.65	30.895	8523549.0
2012-06-21 11:00:00	MSFT	Stock	30.9	30.93	30.62	30.675	5369674.0
2012-06-21 12:00:00	MSFT	Stock	30.67	30.69	30.39	30.46	4957634.0
2012-06-21 13:00:00	MSFT	Stock	30.46	30.51	30.35	30.435	3591006.0
2012-06-21 14:00:00	MSFT	Stock	30.43	30.438	30.27	30.307	3965699.0
2012-06-21 15:00:00	MSFT	Stock	30.3	30.32	30.06	30.135	13482191.0
2012-06-21 16:00:00	MSFT	Stock	30.145	30.536	30.124	30.2	2601049.0
2012-06-21 17:00:00	MSFT	Stock	30.135	30.18	30.135	30.18	27802.0
2012-06-21 18:00:00	MSFT	Stock	30.19	30.22	30.18	30.18	4025.0
2012-06-21 19:00:00	MSFT	Stock	30.18	30.23	30.18	30.23	1734.0
2012-06-21 08:00:00	NVDA	Stock	0.3375	0.343	0.3375	0.3398	280680.0
2012-06-21 09:00:00	NVDA	Stock	0.338	0.338	0.3278	0.331	73207560.0
2012-06-21 10:00:00	NVDA	Stock	0.331	0.3318	0.3278	0.3318	72519200.0
2012-06-21 11:00:00	NVDA	Stock	0.3315	0.3318	0.326	0.3275	75755560.0
2012-06-21 12:00:00	NVDA	Stock	0.3276	0.3278	0.3243	0.3248	48832440.0
2012-06-21 13:00:00	NVDA	Stock	0.3249	0.3258	0.323	0.3235	50965240.0
2012-06-21 14:00:00	NVDA	Stock	0.3235	0.3238	0.3218	0.3238	51791240.0
2012-06-21 15:00:00	NVDA	Stock	0.3236	0.3236	0.3203	0.3208	108072880.0
2012-06-21 16:00:00	NVDA	Stock	0.3209	0.3228	0.3203	0.3208	5051560.0
2012-06-21 17:00:00	NVDA	Stock	0.3209	0.3235	0.32	0.3235	1624240.0
2012-06-21 18:00:00	NVDA	Stock	0.3248	0.326	0.3223	0.3235	156400.0
2012-06-21 19:00:00	NVDA	Stock	0.3235	0.3235	0.3225	0.3225	78360.0
2012-06-21 06:00:00	AMZN	Stock	11.15	11.15	11.15	11.15	2000.0
2012-06-21 07:00:00	AMZN	Stock	11.2	11.2	11.174	11.174	10000.0
2012-06-21 08:00:00	AMZN	Stock	11.1725	11.1775	11.1705	11.175	39760.0
2012-06-21 09:00:00	AMZN	Stock	11.1825	11.24	11.175	11.2075	5239960.0
2012-06-21 10:00:00	AMZN	Stock	11.2085	11.3015	11.1511	11.2565	12225180.0
2012-06-21 11:00:00	AMZN	Stock	11.2595	11.2615	11.155	11.194	8712400.0
2012-06-21 12:00:00	AMZN	Stock	11.1895	11.198	11.09	11.131	5534340.0
2012-06-21 13:00:00	AMZN	Stock	11.131	11.152	11.078	11.095	4828000.0
2012-06-21 14:00:00	AMZN	Stock	11.09	11.0993	11.036	11.07	4976520.0
2012-06-21 15:00:00	AMZN	Stock	11.0715	11.0715	11.026	11.026	12164360.0
2012-06-21 16:00:00	AMZN	Stock	11.0295	11.1435	11.0125	11.0431	824300.0

> showing 50 of 44,190 rows — these rows as CSV

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