PREVIEW / stock_1hour / 2013-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-05-14.parquet
  size:    1010 KB
  rows:    46,327
  symbols: 3,522

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-05-14 05:00:00	AAPL	Stock	16.1929	16.1929	16.1871	16.1871	11284.0
2013-05-14 06:00:00	AAPL	Stock	16.1804	16.1804	16.1804	16.1804	2800.0
2013-05-14 07:00:00	AAPL	Stock	16.1982	16.2675	16.1646	16.2675	205492.0
2013-05-14 08:00:00	AAPL	Stock	16.2589	16.2904	16.1786	16.2032	1586592.0
2013-05-14 09:00:00	AAPL	Stock	16.2018	16.2571	16.13	16.1414	53129524.0
2013-05-14 10:00:00	AAPL	Stock	16.1436	16.205	16.1204	16.1869	51504712.0
2013-05-14 11:00:00	AAPL	Stock	16.1856	16.1964	16.1286	16.1732	41231008.0
2013-05-14 12:00:00	AAPL	Stock	16.1736	16.2	16.1314	16.1418	19470864.0
2013-05-14 13:00:00	AAPL	Stock	16.1421	16.1551	15.8293	15.9246	74732476.0
2013-05-14 14:00:00	AAPL	Stock	15.9246	15.9804	15.7911	15.8364	106863064.0
2013-05-14 15:00:00	AAPL	Stock	15.8354	15.9057	15.8036	15.8457	73578596.0
2013-05-14 16:00:00	AAPL	Stock	15.8532	16.2359	15.8393	15.8471	14445536.0
2013-05-14 17:00:00	AAPL	Stock	15.8496	15.8518	15.8207	15.8207	450520.0
2013-05-14 18:00:00	AAPL	Stock	15.8214	15.8304	15.8071	15.8261	322952.0
2013-05-14 19:00:00	AAPL	Stock	15.83	15.83	15.8107	15.8146	204288.0
2013-05-14 06:00:00	MSFT	Stock	32.83	32.83	32.82	32.82	600.0
2013-05-14 07:00:00	MSFT	Stock	32.8	32.84	32.8	32.83	6300.0
2013-05-14 08:00:00	MSFT	Stock	32.83	32.9	32.8	32.9	38715.0
2013-05-14 09:00:00	MSFT	Stock	32.9	33.34	32.8	33.13	6094689.0
2013-05-14 10:00:00	MSFT	Stock	33.13	33.15	33.005	33.08	8083432.0
2013-05-14 11:00:00	MSFT	Stock	33.09	33.22	33.07	33.15	5171536.0
2013-05-14 12:00:00	MSFT	Stock	33.145	33.357	33.14	33.18	4691282.0
2013-05-14 13:00:00	MSFT	Stock	33.18	33.34	33.15	33.225	4563948.0
2013-05-14 14:00:00	MSFT	Stock	33.224	33.3	33.17	33.195	3463282.0
2013-05-14 15:00:00	MSFT	Stock	33.195	33.53	33.18	33.52	12658072.0
2013-05-14 16:00:00	MSFT	Stock	33.53	33.91	32.934	33.5	11012366.0
2013-05-14 17:00:00	MSFT	Stock	33.46	33.53	33.33	33.47	11141.0
2013-05-14 18:00:00	MSFT	Stock	33.47	33.52	33.45	33.45	3934.0
2013-05-14 19:00:00	MSFT	Stock	33.51	33.51	33.45	33.45	2300.0
2013-05-14 07:00:00	NVDA	Stock	0.3542	0.3618	0.3542	0.36	296000.0
2013-05-14 08:00:00	NVDA	Stock	0.36	0.3645	0.36	0.3612	804000.0
2013-05-14 09:00:00	NVDA	Stock	0.3618	0.3635	0.358	0.3582	66362960.0
2013-05-14 10:00:00	NVDA	Stock	0.3582	0.3612	0.3566	0.3612	63165920.0
2013-05-14 11:00:00	NVDA	Stock	0.3611	0.3625	0.361	0.3615	40681800.0
2013-05-14 12:00:00	NVDA	Stock	0.3618	0.3635	0.361	0.3612	69842080.0
2013-05-14 13:00:00	NVDA	Stock	0.3612	0.3635	0.3611	0.3628	43530800.0
2013-05-14 14:00:00	NVDA	Stock	0.3629	0.3642	0.3622	0.3635	43807000.0
2013-05-14 15:00:00	NVDA	Stock	0.3633	0.3638	0.361	0.3615	91485840.0
2013-05-14 16:00:00	NVDA	Stock	0.3612	0.3627	0.3588	0.3588	29355240.0
2013-05-14 17:00:00	NVDA	Stock	0.3625	0.3625	0.3612	0.3612	165720.0
2013-05-14 06:00:00	AMZN	Stock	13.179	13.179	13.179	13.179	2000.0
2013-05-14 07:00:00	AMZN	Stock	13.1975	13.1975	13.175	13.175	9400.0
2013-05-14 08:00:00	AMZN	Stock	13.25	13.25	13.1875	13.205	211000.0
2013-05-14 09:00:00	AMZN	Stock	13.205	13.331	13.196	13.3205	7347800.0
2013-05-14 10:00:00	AMZN	Stock	13.33	13.4205	13.3075	13.4145	9298740.0
2013-05-14 11:00:00	AMZN	Stock	13.418	13.433	13.389	13.412	4247980.0
2013-05-14 12:00:00	AMZN	Stock	13.4125	13.4318	13.3795	13.3835	2901080.0
2013-05-14 13:00:00	AMZN	Stock	13.3835	13.3995	13.3085	13.339	6902220.0
2013-05-14 14:00:00	AMZN	Stock	13.3425	13.3875	13.3255	13.3459	5767740.0
2013-05-14 15:00:00	AMZN	Stock	13.346	13.47	13.336	13.4165	12901720.0

> showing 50 of 46,327 rows — these rows as CSV

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