PREVIEW / stock_1hour / 2012-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-16.parquet
  size:    989 KB
  rows:    45,989
  symbols: 3,535

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-03-16 04:00:00	AAPL	Stock	20.9854	20.9964	20.9768	20.9964	74396.0
2012-03-16 05:00:00	AAPL	Stock	21.0079	21.0125	20.99	20.99	126868.0
2012-03-16 06:00:00	AAPL	Stock	21.0	21.0179	20.9893	21.0179	71540.0
2012-03-16 07:00:00	AAPL	Stock	21.0314	21.1304	21.0	21.0482	2838472.0
2012-03-16 08:00:00	AAPL	Stock	21.0357	21.1071	20.9179	20.9196	8754508.0
2012-03-16 09:00:00	AAPL	Stock	20.9146	20.9607	20.6429	20.7607	132408892.0
2012-03-16 10:00:00	AAPL	Stock	20.7596	21.0414	20.7054	20.9632	177390584.0
2012-03-16 11:00:00	AAPL	Stock	20.9604	21.0429	20.8929	20.9804	100505440.0
2012-03-16 12:00:00	AAPL	Stock	20.9818	21.0132	20.8314	20.8575	65018716.0
2012-03-16 13:00:00	AAPL	Stock	20.8582	20.9268	20.8368	20.9236	47787152.0
2012-03-16 14:00:00	AAPL	Stock	20.9227	20.9461	20.875	20.8836	50546496.0
2012-03-16 15:00:00	AAPL	Stock	20.8832	20.9136	20.8418	20.9132	103517876.0
2012-03-16 16:00:00	AAPL	Stock	20.9132	20.9237	20.8711	20.8943	61834276.0
2012-03-16 17:00:00	AAPL	Stock	20.8939	20.9132	20.8851	20.8929	982912.0
2012-03-16 18:00:00	AAPL	Stock	20.8929	20.9036	20.8918	20.8982	399168.0
2012-03-16 19:00:00	AAPL	Stock	20.895	20.9032	20.8893	20.8929	352856.0
2012-03-16 07:00:00	MSFT	Stock	32.92	32.96	32.92	32.95	12383.0
2012-03-16 08:00:00	MSFT	Stock	32.92	32.95	32.8	32.92	59316.0
2012-03-16 09:00:00	MSFT	Stock	32.93	32.95	32.77	32.84	6965253.0
2012-03-16 10:00:00	MSFT	Stock	32.847	32.88	32.77	32.81	6847196.0
2012-03-16 11:00:00	MSFT	Stock	32.82	32.85	32.75	32.845	4870590.0
2012-03-16 12:00:00	MSFT	Stock	32.845	32.85	32.772	32.79	4505916.0
2012-03-16 13:00:00	MSFT	Stock	32.78	32.8	32.7	32.702	4336151.0
2012-03-16 14:00:00	MSFT	Stock	32.71	32.75	32.66	32.69	3481810.0
2012-03-16 15:00:00	MSFT	Stock	32.695	32.7	32.5	32.6	8878637.0
2012-03-16 16:00:00	MSFT	Stock	32.595	32.791	32.547	32.6	5851487.0
2012-03-16 17:00:00	MSFT	Stock	32.6	32.6	32.6	32.6	4343.0
2012-03-16 18:00:00	MSFT	Stock	32.64	32.64	32.59	32.6	1179.0
2012-03-16 19:00:00	MSFT	Stock	32.6	32.6	32.59	32.59	10200.0
2012-03-16 08:00:00	NVDA	Stock	0.3645	0.365	0.3645	0.3645	97760.0
2012-03-16 09:00:00	NVDA	Stock	0.365	0.3665	0.3628	0.3655	103356600.0
2012-03-16 10:00:00	NVDA	Stock	0.3655	0.3665	0.3632	0.3662	87419800.0
2012-03-16 11:00:00	NVDA	Stock	0.3662	0.3665	0.3642	0.3649	44616800.0
2012-03-16 12:00:00	NVDA	Stock	0.3648	0.3652	0.364	0.3648	23001160.0
2012-03-16 13:00:00	NVDA	Stock	0.3645	0.3652	0.364	0.3652	27204920.0
2012-03-16 14:00:00	NVDA	Stock	0.3651	0.3655	0.364	0.3648	31452200.0
2012-03-16 15:00:00	NVDA	Stock	0.3645	0.365	0.3638	0.365	62102920.0
2012-03-16 16:00:00	NVDA	Stock	0.3645	0.3652	0.363	0.365	17334520.0
2012-03-16 17:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	44920.0
2012-03-16 19:00:00	NVDA	Stock	0.3638	0.365	0.3638	0.365	16000.0
2012-03-16 08:00:00	AMZN	Stock	9.201	9.2215	9.188	9.1905	133060.0
2012-03-16 09:00:00	AMZN	Stock	9.19	9.2008	9.1175	9.1545	27087220.0
2012-03-16 10:00:00	AMZN	Stock	9.155	9.2144	9.125	9.1715	9450420.0
2012-03-16 11:00:00	AMZN	Stock	9.1705	9.1775	9.133	9.1705	10437800.0
2012-03-16 12:00:00	AMZN	Stock	9.1715	9.2395	9.166	9.224	6013360.0
2012-03-16 13:00:00	AMZN	Stock	9.227	9.2815	9.2195	9.2763	10372260.0
2012-03-16 14:00:00	AMZN	Stock	9.2763	9.284	9.257	9.263	6965380.0
2012-03-16 15:00:00	AMZN	Stock	9.264	9.264	9.233	9.2525	15895320.0
2012-03-16 16:00:00	AMZN	Stock	9.2525	9.2571	9.205	9.252	11693300.0
2012-03-16 17:00:00	AMZN	Stock	9.249	9.2525	9.2409	9.2495	31940.0

> showing 50 of 45,989 rows — these rows as CSV

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