PREVIEW / stock_1hour / 2012-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-14.parquet
  size:    938 KB
  rows:    44,249
  symbols: 3,485

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-12-14 04:00:00	AAPL	Stock	18.875	18.8921	18.875	18.8911	25200.0
2012-12-14 05:00:00	AAPL	Stock	18.875	18.8871	18.8221	18.8221	85484.0
2012-12-14 06:00:00	AAPL	Stock	18.8214	18.8354	18.7679	18.7739	109732.0
2012-12-14 07:00:00	AAPL	Stock	18.7739	18.7864	18.4814	18.4868	4137784.0
2012-12-14 08:00:00	AAPL	Stock	18.4904	18.6564	18.425	18.4282	15431220.0
2012-12-14 09:00:00	AAPL	Stock	18.4282	18.5047	18.1607	18.3277	253625652.0
2012-12-14 10:00:00	AAPL	Stock	18.3257	18.3989	18.235	18.2443	143049480.0
2012-12-14 11:00:00	AAPL	Stock	18.2411	18.2696	18.1307	18.2287	155065792.0
2012-12-14 12:00:00	AAPL	Stock	18.2321	18.3111	18.2207	18.2379	67573520.0
2012-12-14 13:00:00	AAPL	Stock	18.2361	18.2561	18.1746	18.2232	60788588.0
2012-12-14 14:00:00	AAPL	Stock	18.2269	18.2439	18.0718	18.0893	80377276.0
2012-12-14 15:00:00	AAPL	Stock	18.0893	18.2243	18.0564	18.1786	185077648.0
2012-12-14 16:00:00	AAPL	Stock	18.2143	18.2877	18.0761	18.1429	20430256.0
2012-12-14 17:00:00	AAPL	Stock	18.1457	18.2068	18.1196	18.12	4085340.0
2012-12-14 18:00:00	AAPL	Stock	18.1243	18.1357	18.1107	18.1171	306320.0
2012-12-14 19:00:00	AAPL	Stock	18.1171	18.1286	18.1111	18.125	516124.0
2012-12-14 04:00:00	MSFT	Stock	27.22	27.26	27.22	27.26	1830.0
2012-12-14 06:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	100.0
2012-12-14 07:00:00	MSFT	Stock	27.19	27.2	27.14	27.18	17251.0
2012-12-14 08:00:00	MSFT	Stock	27.12	27.2	26.93	26.95	37096.0
2012-12-14 09:00:00	MSFT	Stock	27.0	27.15	26.82	26.93	4322661.0
2012-12-14 10:00:00	MSFT	Stock	26.93	26.995	26.88	26.97	6241612.0
2012-12-14 11:00:00	MSFT	Stock	26.96	26.99	26.83	26.85	5822501.0
2012-12-14 12:00:00	MSFT	Stock	26.856	26.945	26.85	26.89	3572062.0
2012-12-14 13:00:00	MSFT	Stock	26.9	26.91	26.85	26.86	2962445.0
2012-12-14 14:00:00	MSFT	Stock	26.865	26.88	26.72	26.73	4915415.0
2012-12-14 15:00:00	MSFT	Stock	26.73	26.84	26.7	26.815	7947552.0
2012-12-14 16:00:00	MSFT	Stock	26.82	26.932	26.73	26.81	5716336.0
2012-12-14 17:00:00	MSFT	Stock	26.8	26.81	26.8	26.8	168385.0
2012-12-14 18:00:00	MSFT	Stock	26.8	26.8	26.76	26.8	2491.0
2012-12-14 19:00:00	MSFT	Stock	26.8	26.82	26.77	26.82	9322.0
2012-12-14 07:00:00	NVDA	Stock	0.3175	0.3175	0.3155	0.3175	192000.0
2012-12-14 08:00:00	NVDA	Stock	0.3158	0.3158	0.315	0.315	783200.0
2012-12-14 09:00:00	NVDA	Stock	0.314	0.318	0.313	0.3168	39183840.0
2012-12-14 10:00:00	NVDA	Stock	0.3168	0.3175	0.3153	0.3163	55929120.0
2012-12-14 11:00:00	NVDA	Stock	0.3165	0.3165	0.3135	0.314	73715200.0
2012-12-14 12:00:00	NVDA	Stock	0.3139	0.316	0.3138	0.3148	35393160.0
2012-12-14 13:00:00	NVDA	Stock	0.3148	0.3153	0.3128	0.3148	21556000.0
2012-12-14 14:00:00	NVDA	Stock	0.315	0.3158	0.3123	0.3125	38942080.0
2012-12-14 15:00:00	NVDA	Stock	0.3125	0.3153	0.3124	0.3146	61422160.0
2012-12-14 16:00:00	NVDA	Stock	0.3148	0.315	0.3145	0.3148	10780640.0
2012-12-14 06:00:00	AMZN	Stock	12.5995	12.5995	12.5995	12.5995	2000.0
2012-12-14 07:00:00	AMZN	Stock	12.5825	12.5825	12.56	12.56	6000.0
2012-12-14 08:00:00	AMZN	Stock	12.5575	12.575	12.55	12.55	47280.0
2012-12-14 09:00:00	AMZN	Stock	12.545	12.595	12.5	12.5075	6354960.0
2012-12-14 10:00:00	AMZN	Stock	12.509	12.528	12.4465	12.47	11078260.0
2012-12-14 11:00:00	AMZN	Stock	12.47	12.474	12.4175	12.442	6806600.0
2012-12-14 12:00:00	AMZN	Stock	12.4408	12.5	12.4355	12.4855	5144700.0
2012-12-14 13:00:00	AMZN	Stock	12.486	12.49	12.4435	12.47	2366180.0
2012-12-14 14:00:00	AMZN	Stock	12.4715	12.472	12.411	12.4139	3880580.0

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

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