PREVIEW / stock_1hour / 2012-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-28.parquet
  size:    938 KB
  rows:    45,265
  symbols: 3,506

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-28 04:00:00	AAPL	Stock	20.4643	20.4643	20.4021	20.4021	32200.0
2012-06-28 07:00:00	AAPL	Stock	20.4443	20.5	20.4286	20.4286	201880.0
2012-06-28 08:00:00	AAPL	Stock	20.4596	20.4643	20.4107	20.4207	557396.0
2012-06-28 09:00:00	AAPL	Stock	20.4239	20.5	20.3786	20.4368	33634524.0
2012-06-28 10:00:00	AAPL	Stock	20.4393	20.4561	20.3093	20.35	49733936.0
2012-06-28 11:00:00	AAPL	Stock	20.3521	20.3704	20.3046	20.331	31753904.0
2012-06-28 12:00:00	AAPL	Stock	20.3257	20.3571	20.2832	20.3218	20250216.0
2012-06-28 13:00:00	AAPL	Stock	20.3212	20.3225	20.2243	20.2843	32415824.0
2012-06-28 14:00:00	AAPL	Stock	20.285	20.2986	20.2004	20.2221	33147296.0
2012-06-28 15:00:00	AAPL	Stock	20.2221	20.3393	20.2175	20.3129	66147424.0
2012-06-28 16:00:00	AAPL	Stock	20.3218	20.5035	20.2502	20.2946	9568496.0
2012-06-28 17:00:00	AAPL	Stock	20.2993	20.3232	20.2679	20.2757	630140.0
2012-06-28 18:00:00	AAPL	Stock	20.2739	20.2786	20.2189	20.2321	451164.0
2012-06-28 19:00:00	AAPL	Stock	20.2321	20.2475	20.2196	20.2196	142296.0
2012-06-28 07:00:00	MSFT	Stock	30.15	30.18	30.12	30.12	9000.0
2012-06-28 08:00:00	MSFT	Stock	30.11	30.17	30.0	30.0	48168.0
2012-06-28 09:00:00	MSFT	Stock	30.0	30.17	29.59	29.782	4404219.0
2012-06-28 10:00:00	MSFT	Stock	29.79	29.82	29.42	29.53	11067172.0
2012-06-28 11:00:00	MSFT	Stock	29.535	29.64	29.495	29.6	4017102.0
2012-06-28 12:00:00	MSFT	Stock	29.605	29.67	29.48	29.51	3168173.0
2012-06-28 13:00:00	MSFT	Stock	29.51	29.615	29.462	29.6	4432634.0
2012-06-28 14:00:00	MSFT	Stock	29.6	29.61	29.49	29.605	3999461.0
2012-06-28 15:00:00	MSFT	Stock	29.61	29.95	29.6	29.905	10846143.0
2012-06-28 16:00:00	MSFT	Stock	29.91	30.191	29.51	29.87	2385166.0
2012-06-28 17:00:00	MSFT	Stock	29.91	29.91	29.81	29.84	86737.0
2012-06-28 18:00:00	MSFT	Stock	29.84	29.89	29.82	29.82	2900.0
2012-06-28 19:00:00	MSFT	Stock	29.88	29.88	29.82	29.82	2900.0
2012-06-28 08:00:00	NVDA	Stock	0.3245	0.327	0.3245	0.3255	264800.0
2012-06-28 09:00:00	NVDA	Stock	0.3258	0.3325	0.3228	0.3305	70004000.0
2012-06-28 10:00:00	NVDA	Stock	0.3305	0.333	0.3258	0.3266	102870960.0
2012-06-28 11:00:00	NVDA	Stock	0.3265	0.3308	0.3254	0.3304	64964880.0
2012-06-28 12:00:00	NVDA	Stock	0.3303	0.3308	0.327	0.3276	50891080.0
2012-06-28 13:00:00	NVDA	Stock	0.3276	0.3284	0.3265	0.3281	48567080.0
2012-06-28 14:00:00	NVDA	Stock	0.328	0.3288	0.3258	0.3283	59752960.0
2012-06-28 15:00:00	NVDA	Stock	0.3283	0.3318	0.327	0.331	131832480.0
2012-06-28 16:00:00	NVDA	Stock	0.331	0.3313	0.328	0.328	12580440.0
2012-06-28 17:00:00	NVDA	Stock	0.3285	0.331	0.3285	0.331	388080.0
2012-06-28 18:00:00	NVDA	Stock	0.3313	0.3313	0.3313	0.3313	76000.0
2012-06-28 19:00:00	NVDA	Stock	0.3318	0.3318	0.331	0.331	68000.0
2012-06-28 08:00:00	AMZN	Stock	11.228	11.281	11.2	11.2	137300.0
2012-06-28 09:00:00	AMZN	Stock	11.2175	11.281	11.1325	11.155	7542080.0
2012-06-28 10:00:00	AMZN	Stock	11.156	11.1695	11.054	11.083	10900960.0
2012-06-28 11:00:00	AMZN	Stock	11.0755	11.105	11.0655	11.093	5511940.0
2012-06-28 12:00:00	AMZN	Stock	11.093	11.119	11.0645	11.0725	4184580.0
2012-06-28 13:00:00	AMZN	Stock	11.0695	11.0785	10.9785	11.01	7847840.0
2012-06-28 14:00:00	AMZN	Stock	11.0145	11.027	10.9375	10.9504	8338040.0
2012-06-28 15:00:00	AMZN	Stock	10.9497	11.095	10.9444	11.065	12211440.0
2012-06-28 16:00:00	AMZN	Stock	11.0655	11.2731	11.0296	11.06	2463940.0
2012-06-28 17:00:00	AMZN	Stock	11.0655	11.0655	11.0655	11.0655	28640.0
2012-06-28 18:00:00	AMZN	Stock	11.0375	11.0375	11.0305	11.0305	31040.0

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

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