PREVIEW / stock_1hour / 2011-06-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-20.parquet
  size:    942 KB
  rows:    45,564
  symbols: 3,549

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
2011-06-20 04:00:00	AAPL	Stock	11.5	11.5	11.35	11.3529	14196.0
2011-06-20 05:00:00	AAPL	Stock	11.4	11.4	11.4	11.4	2800.0
2011-06-20 06:00:00	AAPL	Stock	11.3875	11.4104	11.3875	11.4104	8400.0
2011-06-20 07:00:00	AAPL	Stock	11.3932	11.3932	11.3393	11.3464	714952.0
2011-06-20 08:00:00	AAPL	Stock	11.3511	11.3571	11.2911	11.3343	3465168.0
2011-06-20 09:00:00	AAPL	Stock	11.3339	11.3571	11.2321	11.2789	105633640.0
2011-06-20 10:00:00	AAPL	Stock	11.2796	11.2911	11.0893	11.1682	181263824.0
2011-06-20 11:00:00	AAPL	Stock	11.1664	11.2221	11.1339	11.2011	82401872.0
2011-06-20 12:00:00	AAPL	Stock	11.204	11.3164	11.2014	11.2483	78858052.0
2011-06-20 13:00:00	AAPL	Stock	11.2461	11.2893	11.2343	11.2413	35552356.0
2011-06-20 14:00:00	AAPL	Stock	11.2422	11.3464	11.2264	11.3389	55093500.0
2011-06-20 15:00:00	AAPL	Stock	11.3375	11.338	11.2186	11.2614	77179872.0
2011-06-20 16:00:00	AAPL	Stock	11.2614	11.3027	11.235	11.2571	9512076.0
2011-06-20 17:00:00	AAPL	Stock	11.2554	11.2564	11.2439	11.2518	196056.0
2011-06-20 18:00:00	AAPL	Stock	11.2568	11.2614	11.25	11.2507	717976.0
2011-06-20 19:00:00	AAPL	Stock	11.2586	11.2857	11.2511	11.2768	300720.0
2011-06-20 07:00:00	MSFT	Stock	24.18	24.2	24.13	24.17	6900.0
2011-06-20 08:00:00	MSFT	Stock	24.17	24.25	24.13	24.13	14065.0
2011-06-20 09:00:00	MSFT	Stock	24.15	24.342	24.14	24.34	6078283.0
2011-06-20 10:00:00	MSFT	Stock	24.33	24.52	24.3	24.49	9496794.0
2011-06-20 11:00:00	MSFT	Stock	24.49	24.66	24.44	24.642	7686290.0
2011-06-20 12:00:00	MSFT	Stock	24.65	24.655	24.56	24.57	5751702.0
2011-06-20 13:00:00	MSFT	Stock	24.575	24.65	24.52	24.525	5734498.0
2011-06-20 14:00:00	MSFT	Stock	24.528	24.61	24.51	24.58	4786439.0
2011-06-20 15:00:00	MSFT	Stock	24.59	24.61	24.46	24.46	11429907.0
2011-06-20 16:00:00	MSFT	Stock	24.47	24.585	24.321	24.51	2567826.0
2011-06-20 17:00:00	MSFT	Stock	24.52	24.52	24.5	24.51	5907.0
2011-06-20 18:00:00	MSFT	Stock	24.47	24.48	24.47	24.48	562409.0
2011-06-20 19:00:00	MSFT	Stock	24.49	24.51	24.49	24.51	3700.0
2011-06-20 08:00:00	NVDA	Stock	0.3925	0.3925	0.3888	0.39	157000.0
2011-06-20 09:00:00	NVDA	Stock	0.39	0.3993	0.3885	0.3988	65030680.0
2011-06-20 10:00:00	NVDA	Stock	0.3988	0.4	0.3918	0.392	151392840.0
2011-06-20 11:00:00	NVDA	Stock	0.3922	0.3933	0.3875	0.3908	144336520.0
2011-06-20 12:00:00	NVDA	Stock	0.391	0.3942	0.391	0.3933	74323880.0
2011-06-20 13:00:00	NVDA	Stock	0.3935	0.394	0.3918	0.3925	71305120.0
2011-06-20 14:00:00	NVDA	Stock	0.3925	0.3933	0.3902	0.3922	87920720.0
2011-06-20 15:00:00	NVDA	Stock	0.3922	0.3925	0.3895	0.3905	136161560.0
2011-06-20 16:00:00	NVDA	Stock	0.3908	0.3932	0.3895	0.3895	1148160.0
2011-06-20 17:00:00	NVDA	Stock	0.3888	0.3888	0.3888	0.3888	14000.0
2011-06-20 06:00:00	AMZN	Stock	9.28	9.28	9.28	9.28	2000.0
2011-06-20 07:00:00	AMZN	Stock	9.28	9.28	9.28	9.28	17200.0
2011-06-20 08:00:00	AMZN	Stock	9.3185	9.3185	9.2625	9.2885	100060.0
2011-06-20 09:00:00	AMZN	Stock	9.279	9.419	9.2785	9.3725	11742160.0
2011-06-20 10:00:00	AMZN	Stock	9.3725	9.415	9.3285	9.3325	11519420.0
2011-06-20 11:00:00	AMZN	Stock	9.334	9.3815	9.3225	9.378	6171320.0
2011-06-20 12:00:00	AMZN	Stock	9.3795	9.4426	9.3705	9.426	7676040.0
2011-06-20 13:00:00	AMZN	Stock	9.426	9.4335	9.3885	9.391	3460240.0
2011-06-20 14:00:00	AMZN	Stock	9.3925	9.4105	9.38	9.3905	4852980.0
2011-06-20 15:00:00	AMZN	Stock	9.391	9.3955	9.359	9.386	8906000.0
2011-06-20 16:00:00	AMZN	Stock	9.384	9.3879	9.3653	9.3816	394600.0

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

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