PREVIEW / stock_1hour / 2012-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-23.parquet
  size:    937 KB
  rows:    44,621
  symbols: 3,533

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-05-23 04:00:00	AAPL	Stock	19.7929	19.8304	19.75	19.75	38500.0
2012-05-23 05:00:00	AAPL	Stock	19.8036	19.8036	19.75	19.75	19600.0
2012-05-23 06:00:00	AAPL	Stock	19.7404	19.75	19.7257	19.7375	36260.0
2012-05-23 07:00:00	AAPL	Stock	19.7429	19.8357	19.7429	19.8286	539532.0
2012-05-23 08:00:00	AAPL	Stock	19.8282	19.8929	19.7218	19.8711	2268504.0
2012-05-23 09:00:00	AAPL	Stock	19.8711	20.0493	19.7582	19.9611	88735052.0
2012-05-23 10:00:00	AAPL	Stock	19.9604	20.0089	19.8214	19.875	82706568.0
2012-05-23 11:00:00	AAPL	Stock	19.8754	20.0068	19.7857	19.8489	64796144.0
2012-05-23 12:00:00	AAPL	Stock	19.8478	19.9352	19.7886	19.8871	40562144.0
2012-05-23 13:00:00	AAPL	Stock	19.8864	20.0911	19.8729	20.0771	54770688.0
2012-05-23 14:00:00	AAPL	Stock	20.0761	20.1543	19.9643	20.1416	67443992.0
2012-05-23 15:00:00	AAPL	Stock	20.14	20.4571	20.1018	20.3682	153349196.0
2012-05-23 16:00:00	AAPL	Stock	20.3682	20.4246	19.9642	20.4214	15846572.0
2012-05-23 17:00:00	AAPL	Stock	20.4218	20.4879	20.3771	20.4821	1920548.0
2012-05-23 18:00:00	AAPL	Stock	20.4789	20.4857	20.4375	20.4525	991480.0
2012-05-23 19:00:00	AAPL	Stock	20.4604	20.4643	20.4107	20.4161	531328.0
2012-05-23 20:00:00	AAPL	Stock	20.4	20.4	20.4	20.4	9100.0
2012-05-23 07:00:00	MSFT	Stock	29.51	29.63	29.5	29.63	600.0
2012-05-23 08:00:00	MSFT	Stock	29.63	29.65	29.53	29.56	10600.0
2012-05-23 09:00:00	MSFT	Stock	29.64	29.64	28.66	28.872	13159595.0
2012-05-23 10:00:00	MSFT	Stock	28.88	29.0	28.75	28.844	11178570.0
2012-05-23 11:00:00	MSFT	Stock	28.848	28.905	28.72	28.785	5640132.0
2012-05-23 12:00:00	MSFT	Stock	28.785	28.82	28.64	28.79	5500655.0
2012-05-23 13:00:00	MSFT	Stock	28.795	28.95	28.78	28.938	4366574.0
2012-05-23 14:00:00	MSFT	Stock	28.93	29.0	28.79	28.98	6251508.0
2012-05-23 15:00:00	MSFT	Stock	28.98	29.2	28.922	29.1	12842491.0
2012-05-23 16:00:00	MSFT	Stock	29.11	29.14	28.8	29.1	5078375.0
2012-05-23 17:00:00	MSFT	Stock	29.1	29.18	29.1	29.18	15032.0
2012-05-23 18:00:00	MSFT	Stock	29.15	29.15	29.05	29.1	2127.0
2012-05-23 19:00:00	MSFT	Stock	29.11	29.11	29.05	29.05	2730.0
2012-05-23 08:00:00	NVDA	Stock	0.2982	0.2982	0.2982	0.2982	17920.0
2012-05-23 09:00:00	NVDA	Stock	0.3	0.3012	0.2956	0.3002	51951840.0
2012-05-23 10:00:00	NVDA	Stock	0.3001	0.3012	0.2982	0.2998	58144240.0
2012-05-23 11:00:00	NVDA	Stock	0.2995	0.3008	0.2962	0.2971	53705200.0
2012-05-23 12:00:00	NVDA	Stock	0.297	0.3032	0.2968	0.3028	80648520.0
2012-05-23 13:00:00	NVDA	Stock	0.3028	0.3075	0.3028	0.3059	75096840.0
2012-05-23 14:00:00	NVDA	Stock	0.3058	0.3059	0.302	0.3051	32942800.0
2012-05-23 15:00:00	NVDA	Stock	0.3051	0.3115	0.3039	0.311	121686600.0
2012-05-23 16:00:00	NVDA	Stock	0.311	0.3111	0.3031	0.3103	12664640.0
2012-05-23 18:00:00	NVDA	Stock	0.311	0.311	0.311	0.311	8000.0
2012-05-23 19:00:00	NVDA	Stock	0.311	0.311	0.3103	0.311	83200.0
2012-05-23 04:00:00	AMZN	Stock	10.7375	10.7375	10.7375	10.7375	30000.0
2012-05-23 05:00:00	AMZN	Stock	10.7375	10.7375	10.7375	10.7375	8000.0
2012-05-23 07:00:00	AMZN	Stock	10.7265	10.7265	10.6905	10.6905	23000.0
2012-05-23 08:00:00	AMZN	Stock	10.71	10.723	10.679	10.723	159120.0
2012-05-23 09:00:00	AMZN	Stock	10.738	10.8475	10.6675	10.8355	8781920.0
2012-05-23 10:00:00	AMZN	Stock	10.838	10.8775	10.65	10.661	13127100.0
2012-05-23 11:00:00	AMZN	Stock	10.6635	10.6855	10.5735	10.587	13009300.0
2012-05-23 12:00:00	AMZN	Stock	10.587	10.6585	10.559	10.6438	9392220.0
2012-05-23 13:00:00	AMZN	Stock	10.651	10.7601	10.644	10.755	9175200.0

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

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