PREVIEW / stock_1hour / 2012-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-11.parquet
  size:    944 KB
  rows:    45,314
  symbols: 3,515

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-06-11 04:00:00	AAPL	Stock	20.7839	21.0554	20.7839	20.9757	151844.0
2012-06-11 05:00:00	AAPL	Stock	20.9861	20.9861	20.9607	20.9607	44800.0
2012-06-11 06:00:00	AAPL	Stock	20.9536	20.9536	20.8929	20.8929	151536.0
2012-06-11 07:00:00	AAPL	Stock	20.9046	20.9046	20.84	20.8789	1659896.0
2012-06-11 08:00:00	AAPL	Stock	20.8911	20.9821	20.8821	20.9536	4916100.0
2012-06-11 09:00:00	AAPL	Stock	20.9525	20.9989	20.845	20.9457	84398020.0
2012-06-11 10:00:00	AAPL	Stock	20.9432	21.0171	20.8929	20.925	81159960.0
2012-06-11 11:00:00	AAPL	Stock	20.9271	21.0179	20.9111	20.99	50523872.0
2012-06-11 12:00:00	AAPL	Stock	20.9911	20.9968	20.9218	20.9279	32258296.0
2012-06-11 13:00:00	AAPL	Stock	20.9279	20.9604	20.7032	20.7941	88869060.0
2012-06-11 14:00:00	AAPL	Stock	20.7975	20.8543	20.6786	20.6986	80067680.0
2012-06-11 15:00:00	AAPL	Stock	20.6993	20.7207	20.3796	20.4107	146194524.0
2012-06-11 16:00:00	AAPL	Stock	20.4125	20.9751	20.3821	20.9436	11295872.0
2012-06-11 17:00:00	AAPL	Stock	20.3964	20.4071	20.3786	20.3932	496804.0
2012-06-11 18:00:00	AAPL	Stock	20.3929	20.4082	20.3811	20.4068	298144.0
2012-06-11 19:00:00	AAPL	Stock	20.4032	20.4054	20.3571	20.3618	352660.0
2012-06-11 05:00:00	MSFT	Stock	29.95	29.95	29.95	29.95	300.0
2012-06-11 06:00:00	MSFT	Stock	29.91	29.93	29.91	29.93	500.0
2012-06-11 07:00:00	MSFT	Stock	29.9	29.94	29.8	29.8	6950.0
2012-06-11 08:00:00	MSFT	Stock	29.85	29.89	29.8	29.83	37650.0
2012-06-11 09:00:00	MSFT	Stock	29.83	29.84	29.37	29.405	5169133.0
2012-06-11 10:00:00	MSFT	Stock	29.4	29.49	29.23	29.3	6944457.0
2012-06-11 11:00:00	MSFT	Stock	29.295	29.35	29.21	29.26	5000648.0
2012-06-11 12:00:00	MSFT	Stock	29.26	29.3	29.22	29.29	2620323.0
2012-06-11 13:00:00	MSFT	Stock	29.29	29.35	29.24	29.275	3311125.0
2012-06-11 14:00:00	MSFT	Stock	29.28	29.28	29.15	29.15	3955819.0
2012-06-11 15:00:00	MSFT	Stock	29.16	29.19	28.82	28.92	14775885.0
2012-06-11 16:00:00	MSFT	Stock	28.92	29.29	28.87	28.92	4063435.0
2012-06-11 17:00:00	MSFT	Stock	28.88	28.97	28.88	28.96	17398.0
2012-06-11 18:00:00	MSFT	Stock	28.97	28.97	28.88	28.88	3345.0
2012-06-11 19:00:00	MSFT	Stock	28.97	28.97	28.89	28.97	3144.0
2012-06-11 04:00:00	NVDA	Stock	0.3088	0.3113	0.3088	0.3113	34000.0
2012-06-11 05:00:00	NVDA	Stock	0.3123	0.3123	0.3123	0.3123	40000.0
2012-06-11 06:00:00	NVDA	Stock	0.3135	0.3135	0.311	0.311	16000.0
2012-06-11 07:00:00	NVDA	Stock	0.3103	0.3113	0.307	0.3113	473000.0
2012-06-11 08:00:00	NVDA	Stock	0.3103	0.3125	0.31	0.3113	1440960.0
2012-06-11 09:00:00	NVDA	Stock	0.3118	0.3145	0.3108	0.3118	81757600.0
2012-06-11 10:00:00	NVDA	Stock	0.3117	0.312	0.3062	0.307	100023640.0
2012-06-11 11:00:00	NVDA	Stock	0.307	0.3091	0.3058	0.3085	62626680.0
2012-06-11 12:00:00	NVDA	Stock	0.3088	0.3163	0.3083	0.315	212258760.0
2012-06-11 13:00:00	NVDA	Stock	0.315	0.3183	0.3125	0.314	154086560.0
2012-06-11 14:00:00	NVDA	Stock	0.314	0.314	0.3105	0.311	65448280.0
2012-06-11 15:00:00	NVDA	Stock	0.3108	0.3113	0.306	0.3068	137787320.0
2012-06-11 16:00:00	NVDA	Stock	0.307	0.3103	0.305	0.307	5347640.0
2012-06-11 17:00:00	NVDA	Stock	0.3088	0.3098	0.3065	0.3083	839400.0
2012-06-11 18:00:00	NVDA	Stock	0.3083	0.3088	0.3083	0.3088	44000.0
2012-06-11 19:00:00	NVDA	Stock	0.3095	0.3095	0.3083	0.309	146000.0
2012-06-11 04:00:00	AMZN	Stock	10.9475	11.02	10.9415	11.02	20000.0
2012-06-11 05:00:00	AMZN	Stock	11.0	11.0	11.0	11.0	2000.0
2012-06-11 06:00:00	AMZN	Stock	10.9835	10.9835	10.9505	10.955	42000.0

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

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