PREVIEW / stock_1hour / 2011-04-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-04-08.parquet
  size:    929 KB
  rows:    43,792
  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
2011-04-08 04:00:00	AAPL	Stock	12.1214	12.1214	12.1214	12.1214	28000.0
2011-04-08 05:00:00	AAPL	Stock	12.1243	12.1429	12.1243	12.1429	15400.0
2011-04-08 06:00:00	AAPL	Stock	12.125	12.1421	12.125	12.1421	10920.0
2011-04-08 07:00:00	AAPL	Stock	12.1286	12.1711	12.125	12.1589	457184.0
2011-04-08 08:00:00	AAPL	Stock	12.1582	12.1589	12.125	12.1482	1093652.0
2011-04-08 09:00:00	AAPL	Stock	12.145	12.1486	12.0288	12.0557	55766060.0
2011-04-08 10:00:00	AAPL	Stock	12.0571	12.0714	11.9946	12.0236	69567372.0
2011-04-08 11:00:00	AAPL	Stock	12.0225	12.0564	12.0129	12.0446	37630460.0
2011-04-08 12:00:00	AAPL	Stock	12.0446	12.0529	12.01	12.0207	24367504.0
2011-04-08 13:00:00	AAPL	Stock	12.0206	12.0343	12.0132	12.0275	20370224.0
2011-04-08 14:00:00	AAPL	Stock	12.0282	12.0296	11.9304	11.9329	69362860.0
2011-04-08 15:00:00	AAPL	Stock	11.9304	11.9743	11.9268	11.9664	76310444.0
2011-04-08 16:00:00	AAPL	Stock	11.9646	12.0155	11.9455	11.965	15274616.0
2011-04-08 17:00:00	AAPL	Stock	11.9643	11.965	11.9625	11.9625	83272.0
2011-04-08 18:00:00	AAPL	Stock	11.9625	11.9664	11.9571	11.96	335580.0
2011-04-08 19:00:00	AAPL	Stock	11.9614	11.9725	11.9607	11.9668	366268.0
2011-04-08 07:00:00	MSFT	Stock	26.23	26.33	26.23	26.3	2800.0
2011-04-08 08:00:00	MSFT	Stock	26.27	26.32	26.26	26.29	10575.0
2011-04-08 09:00:00	MSFT	Stock	26.29	26.29	26.04	26.04	4052713.0
2011-04-08 10:00:00	MSFT	Stock	26.04	26.09	25.96	26.0	8529062.0
2011-04-08 11:00:00	MSFT	Stock	25.995	26.14	25.97	26.12	3939750.0
2011-04-08 12:00:00	MSFT	Stock	26.12	26.17	26.07	26.1	3214157.0
2011-04-08 13:00:00	MSFT	Stock	26.11	26.17	26.07	26.092	3815005.0
2011-04-08 14:00:00	MSFT	Stock	26.1	26.135	25.98	26.0	5474915.0
2011-04-08 15:00:00	MSFT	Stock	26.0	26.12	25.995	26.06	8117848.0
2011-04-08 16:00:00	MSFT	Stock	26.07	26.2	26.02	26.05	2187684.0
2011-04-08 17:00:00	MSFT	Stock	26.07	26.07	26.05	26.05	5327.0
2011-04-08 18:00:00	MSFT	Stock	26.04	26.07	26.0	26.0	14919.0
2011-04-08 19:00:00	MSFT	Stock	26.03	26.03	26.03	26.03	1000.0
2011-04-08 07:00:00	NVDA	Stock	0.456	0.457	0.456	0.457	56000.0
2011-04-08 08:00:00	NVDA	Stock	0.457	0.457	0.453	0.4565	1107040.0
2011-04-08 09:00:00	NVDA	Stock	0.4565	0.4575	0.4452	0.4464	139192640.0
2011-04-08 10:00:00	NVDA	Stock	0.4465	0.4495	0.443	0.4432	132431200.0
2011-04-08 11:00:00	NVDA	Stock	0.4432	0.446	0.442	0.4445	76900120.0
2011-04-08 12:00:00	NVDA	Stock	0.4443	0.4455	0.4412	0.442	57823200.0
2011-04-08 13:00:00	NVDA	Stock	0.4419	0.4448	0.4415	0.444	53743000.0
2011-04-08 14:00:00	NVDA	Stock	0.444	0.4441	0.4385	0.4386	86705400.0
2011-04-08 15:00:00	NVDA	Stock	0.4385	0.4408	0.4375	0.439	182350760.0
2011-04-08 16:00:00	NVDA	Stock	0.4388	0.4525	0.438	0.4398	12432880.0
2011-04-08 17:00:00	NVDA	Stock	0.4392	0.4435	0.4388	0.4412	373680.0
2011-04-08 18:00:00	NVDA	Stock	0.4392	0.4392	0.4388	0.4388	139280.0
2011-04-08 19:00:00	NVDA	Stock	0.4405	0.4405	0.4385	0.4388	254720.0
2011-04-08 04:00:00	AMZN	Stock	9.251	9.251	9.251	9.251	2000.0
2011-04-08 06:00:00	AMZN	Stock	9.234	9.234	9.234	9.234	2000.0
2011-04-08 07:00:00	AMZN	Stock	9.247	9.284	9.247	9.284	4000.0
2011-04-08 08:00:00	AMZN	Stock	9.257	9.305	9.256	9.305	135620.0
2011-04-08 09:00:00	AMZN	Stock	9.305	9.311	9.2435	9.2935	12723400.0
2011-04-08 10:00:00	AMZN	Stock	9.2935	9.308	9.255	9.2735	11246960.0
2011-04-08 11:00:00	AMZN	Stock	9.275	9.2992	9.25	9.2673	7407800.0
2011-04-08 12:00:00	AMZN	Stock	9.267	9.279	9.2375	9.252	5267100.0

> showing 50 of 43,792 rows — these rows as CSV

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