PREVIEW / stock_1hour / 2013-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-14.parquet
  size:    1022 KB
  rows:    47,447
  symbols: 3,519

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-08-14 04:00:00	AAPL	Stock	17.6071	17.7129	17.6071	17.6429	157892.0
2013-08-14 05:00:00	AAPL	Stock	17.6321	17.6982	17.6282	17.6982	68796.0
2013-08-14 06:00:00	AAPL	Stock	17.6982	17.7482	17.6789	17.6964	458948.0
2013-08-14 07:00:00	AAPL	Stock	17.7143	17.7539	17.6893	17.7361	2334388.0
2013-08-14 08:00:00	AAPL	Stock	17.7371	17.7589	17.4643	17.7014	9556848.0
2013-08-14 09:00:00	AAPL	Stock	17.7014	17.8546	17.6214	17.7211	188269368.0
2013-08-14 10:00:00	AAPL	Stock	17.7207	17.8164	17.6214	17.7768	114375128.0
2013-08-14 11:00:00	AAPL	Stock	17.7767	17.8525	17.7243	17.8154	77063224.0
2013-08-14 12:00:00	AAPL	Stock	17.8179	18.0089	17.8164	17.9189	129652488.0
2013-08-14 13:00:00	AAPL	Stock	17.9225	17.9643	17.7793	17.8329	75617472.0
2013-08-14 14:00:00	AAPL	Stock	17.833	17.945	17.8143	17.9343	53736788.0
2013-08-14 15:00:00	AAPL	Stock	17.9343	17.9543	17.7875	17.8064	79447424.0
2013-08-14 16:00:00	AAPL	Stock	17.8036	17.9004	17.6707	17.7536	10599960.0
2013-08-14 17:00:00	AAPL	Stock	17.7518	17.8036	17.7143	17.7286	1233792.0
2013-08-14 18:00:00	AAPL	Stock	17.7214	17.7571	17.6971	17.75	782740.0
2013-08-14 19:00:00	AAPL	Stock	17.75	17.7589	17.7346	17.7414	430724.0
2013-08-14 06:00:00	MSFT	Stock	32.07	32.07	32.07	32.07	150.0
2013-08-14 07:00:00	MSFT	Stock	32.1	32.15	32.1	32.15	300.0
2013-08-14 08:00:00	MSFT	Stock	32.2	32.2	32.11	32.15	4758.0
2013-08-14 09:00:00	MSFT	Stock	32.15	32.43	32.1	32.253	5539401.0
2013-08-14 10:00:00	MSFT	Stock	32.26	32.26	31.7	31.88	9746194.0
2013-08-14 11:00:00	MSFT	Stock	31.88	32.02	31.83	31.93	4905038.0
2013-08-14 12:00:00	MSFT	Stock	31.92	31.98	31.785	31.8	4180410.0
2013-08-14 13:00:00	MSFT	Stock	31.8	31.96	31.75	31.951	5134646.0
2013-08-14 14:00:00	MSFT	Stock	31.956	32.41	31.95	32.373	8143495.0
2013-08-14 15:00:00	MSFT	Stock	32.375	33.36	32.25	32.34	7009382.0
2013-08-14 16:00:00	MSFT	Stock	32.34	32.38	31.937	32.25	1885491.0
2013-08-14 17:00:00	MSFT	Stock	32.21	32.25	31.826	31.89	36257.0
2013-08-14 18:00:00	MSFT	Stock	32.1	32.2	32.07	32.11	5470.0
2013-08-14 19:00:00	MSFT	Stock	32.09	32.1	32.09	32.1	2300.0
2013-08-14 09:00:00	NVDA	Stock	0.3595	0.3655	0.3592	0.3652	38067000.0
2013-08-14 10:00:00	NVDA	Stock	0.3654	0.3698	0.3649	0.3698	114064880.0
2013-08-14 11:00:00	NVDA	Stock	0.3698	0.3768	0.3695	0.3743	159347440.0
2013-08-14 12:00:00	NVDA	Stock	0.3743	0.3763	0.3743	0.3763	79278320.0
2013-08-14 13:00:00	NVDA	Stock	0.3763	0.378	0.374	0.374	70459920.0
2013-08-14 14:00:00	NVDA	Stock	0.374	0.376	0.3728	0.3755	93627080.0
2013-08-14 15:00:00	NVDA	Stock	0.3756	0.3778	0.3749	0.3759	224657680.0
2013-08-14 16:00:00	NVDA	Stock	0.3758	0.377	0.3655	0.3742	17711160.0
2013-08-14 17:00:00	NVDA	Stock	0.373	0.3758	0.3728	0.3758	267560.0
2013-08-14 18:00:00	NVDA	Stock	0.3725	0.3725	0.3725	0.3725	36000.0
2013-08-14 19:00:00	NVDA	Stock	0.3725	0.3725	0.3713	0.3713	46000.0
2013-08-14 08:00:00	AMZN	Stock	14.6695	14.6695	14.6625	14.6625	14000.0
2013-08-14 09:00:00	AMZN	Stock	14.6625	14.715	14.612	14.6605	3002080.0
2013-08-14 10:00:00	AMZN	Stock	14.6705	14.6985	14.5665	14.6161	4829820.0
2013-08-14 11:00:00	AMZN	Stock	14.615	14.6808	14.5895	14.6195	5515500.0
2013-08-14 12:00:00	AMZN	Stock	14.612	14.6365	14.571	14.6248	2018440.0
2013-08-14 13:00:00	AMZN	Stock	14.625	14.6295	14.5385	14.5495	2721940.0
2013-08-14 14:00:00	AMZN	Stock	14.543	14.5895	14.527	14.5805	2434200.0
2013-08-14 15:00:00	AMZN	Stock	14.581	14.599	14.5445	14.567	6254820.0
2013-08-14 16:00:00	AMZN	Stock	14.567	14.604	14.5641	14.567	208440.0

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

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