PREVIEW / stock_1hour / 2012-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-27.parquet
  size:    914 KB
  rows:    43,825
  symbols: 3,502

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-27 05:00:00	AAPL	Stock	20.4357	20.4357	20.4296	20.4296	22400.0
2012-06-27 06:00:00	AAPL	Stock	20.445	20.4821	20.445	20.4821	35000.0
2012-06-27 07:00:00	AAPL	Stock	20.4643	20.5107	20.4489	20.5	293832.0
2012-06-27 08:00:00	AAPL	Stock	20.5	20.5464	20.4821	20.5168	1680924.0
2012-06-27 09:00:00	AAPL	Stock	20.5168	20.5868	20.4761	20.5214	45929072.0
2012-06-27 10:00:00	AAPL	Stock	20.52	20.5979	20.5179	20.5743	35920136.0
2012-06-27 11:00:00	AAPL	Stock	20.5729	20.5779	20.5254	20.555	18357668.0
2012-06-27 12:00:00	AAPL	Stock	20.555	20.5711	20.5204	20.5393	13571068.0
2012-06-27 13:00:00	AAPL	Stock	20.5364	20.5457	20.4257	20.4504	25302872.0
2012-06-27 14:00:00	AAPL	Stock	20.4494	20.5046	20.4325	20.4736	19859224.0
2012-06-27 15:00:00	AAPL	Stock	20.4736	20.5371	20.4647	20.5161	32883396.0
2012-06-27 16:00:00	AAPL	Stock	20.5179	20.5246	20.5071	20.5129	5233116.0
2012-06-27 17:00:00	AAPL	Stock	20.5125	20.5125	20.5018	20.5071	102816.0
2012-06-27 18:00:00	AAPL	Stock	20.5082	20.5107	20.5036	20.5036	19600.0
2012-06-27 19:00:00	AAPL	Stock	20.5104	20.5143	20.5036	20.5079	46284.0
2012-06-27 08:00:00	MSFT	Stock	30.0	30.13	30.0	30.09	4682.0
2012-06-27 09:00:00	MSFT	Stock	30.07	30.5	30.07	30.1	4010644.0
2012-06-27 10:00:00	MSFT	Stock	30.11	30.44	30.07	30.25	6066957.0
2012-06-27 11:00:00	MSFT	Stock	30.25	30.31	30.115	30.19	3644364.0
2012-06-27 12:00:00	MSFT	Stock	30.195	30.32	30.19	30.23	2952772.0
2012-06-27 13:00:00	MSFT	Stock	30.23	30.256	30.1	30.145	3157301.0
2012-06-27 14:00:00	MSFT	Stock	30.15	30.18	30.03	30.17	4745611.0
2012-06-27 15:00:00	MSFT	Stock	30.17	30.26	30.12	30.17	7704645.0
2012-06-27 16:00:00	MSFT	Stock	30.17	30.262	30.03	30.03	1291883.0
2012-06-27 17:00:00	MSFT	Stock	30.12	30.17	30.1	30.17	20972.0
2012-06-27 18:00:00	MSFT	Stock	30.16	30.16	30.13	30.13	2508.0
2012-06-27 19:00:00	MSFT	Stock	30.14	30.17	30.13	30.17	1627.0
2012-06-27 08:00:00	NVDA	Stock	0.321	0.3213	0.3188	0.3213	200000.0
2012-06-27 09:00:00	NVDA	Stock	0.3208	0.3243	0.3185	0.322	58736800.0
2012-06-27 10:00:00	NVDA	Stock	0.3223	0.329	0.3213	0.328	89841640.0
2012-06-27 11:00:00	NVDA	Stock	0.3278	0.3304	0.3263	0.3293	101723800.0
2012-06-27 12:00:00	NVDA	Stock	0.3293	0.3308	0.327	0.328	58357960.0
2012-06-27 13:00:00	NVDA	Stock	0.3278	0.3283	0.3248	0.326	56811280.0
2012-06-27 14:00:00	NVDA	Stock	0.326	0.3283	0.3248	0.328	43781280.0
2012-06-27 15:00:00	NVDA	Stock	0.3278	0.33	0.327	0.3285	84755080.0
2012-06-27 16:00:00	NVDA	Stock	0.3285	0.3298	0.327	0.3287	10891720.0
2012-06-27 18:00:00	NVDA	Stock	0.3293	0.3293	0.3293	0.3293	40000.0
2012-06-27 19:00:00	NVDA	Stock	0.329	0.3298	0.329	0.3293	100000.0
2012-06-27 08:00:00	AMZN	Stock	11.235	11.275	11.235	11.275	68000.0
2012-06-27 09:00:00	AMZN	Stock	11.279	11.3635	11.2325	11.2745	11325700.0
2012-06-27 10:00:00	AMZN	Stock	11.2722	11.35	11.26	11.3002	7561620.0
2012-06-27 11:00:00	AMZN	Stock	11.305	11.34	11.3005	11.3305	4320160.0
2012-06-27 12:00:00	AMZN	Stock	11.3315	11.375	11.3105	11.3114	4434060.0
2012-06-27 13:00:00	AMZN	Stock	11.3145	11.3235	11.203	11.2334	6070040.0
2012-06-27 14:00:00	AMZN	Stock	11.233	11.237	11.165	11.1825	6922120.0
2012-06-27 15:00:00	AMZN	Stock	11.1865	11.3105	11.172	11.281	13079200.0
2012-06-27 16:00:00	AMZN	Stock	11.282	11.2935	11.258	11.258	1710500.0
2012-06-27 17:00:00	AMZN	Stock	11.2825	11.2825	11.275	11.277	79420.0
2012-06-27 19:00:00	AMZN	Stock	11.2765	11.3	11.2765	11.3	7580.0
2012-06-27 04:00:00	META	Stock	33.5	34.27	33.5	34.08	32607.0

> showing 50 of 43,825 rows — these rows as CSV

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