PREVIEW / stock_1hour / 2012-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-28.parquet
  size:    945 KB
  rows:    44,498
  symbols: 3,524

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-03-28 04:00:00	AAPL	Stock	21.9657	22.0346	21.9657	22.0	98700.0
2012-03-28 05:00:00	AAPL	Stock	21.9754	22.0054	21.9754	22.0036	57120.0
2012-03-28 06:00:00	AAPL	Stock	22.0014	22.0125	22.0007	22.0125	164640.0
2012-03-28 07:00:00	AAPL	Stock	22.0089	22.0736	21.9929	22.0411	1140972.0
2012-03-28 08:00:00	AAPL	Stock	22.0479	22.0832	22.0321	22.0446	5841556.0
2012-03-28 09:00:00	AAPL	Stock	22.0446	22.1946	22.0361	22.1082	119815444.0
2012-03-28 10:00:00	AAPL	Stock	22.1104	22.1893	22.0146	22.0914	114634408.0
2012-03-28 11:00:00	AAPL	Stock	22.0914	22.1268	21.9536	22.0115	93551780.0
2012-03-28 12:00:00	AAPL	Stock	22.0121	22.0139	21.7968	21.9804	101454556.0
2012-03-28 13:00:00	AAPL	Stock	21.9796	22.0275	21.875	21.9779	54878740.0
2012-03-28 14:00:00	AAPL	Stock	21.9782	22.0521	21.9204	22.0481	52856440.0
2012-03-28 15:00:00	AAPL	Stock	22.0487	22.0796	22.0161	22.0575	79243248.0
2012-03-28 16:00:00	AAPL	Stock	22.0579	22.0714	21.9354	22.0575	24107076.0
2012-03-28 17:00:00	AAPL	Stock	22.0575	22.0629	22.0464	22.0546	167020.0
2012-03-28 18:00:00	AAPL	Stock	22.0521	22.0614	22.0518	22.0589	121072.0
2012-03-28 19:00:00	AAPL	Stock	22.0564	22.065	22.0543	22.0543	609532.0
2012-03-28 04:00:00	MSFT	Stock	32.51	32.51	32.51	32.51	227.0
2012-03-28 07:00:00	MSFT	Stock	32.47	32.52	32.47	32.52	1820.0
2012-03-28 08:00:00	MSFT	Stock	32.53	32.55	32.47	32.48	8095.0
2012-03-28 09:00:00	MSFT	Stock	32.48	32.7	32.48	32.67	3313496.0
2012-03-28 10:00:00	MSFT	Stock	32.66	32.69	32.45	32.48	5294871.0
2012-03-28 11:00:00	MSFT	Stock	32.49	32.54	32.2	32.22	5269331.0
2012-03-28 12:00:00	MSFT	Stock	32.23	32.29	32.17	32.255	3839334.0
2012-03-28 13:00:00	MSFT	Stock	32.26	32.275	32.18	32.21	2695496.0
2012-03-28 14:00:00	MSFT	Stock	32.21	32.25	32.04	32.22	5241538.0
2012-03-28 15:00:00	MSFT	Stock	32.23	32.28	32.15	32.175	9887151.0
2012-03-28 16:00:00	MSFT	Stock	32.19	32.314	32.12	32.26	5324360.0
2012-03-28 17:00:00	MSFT	Stock	32.24	32.25	32.24	32.25	655.0
2012-03-28 18:00:00	MSFT	Stock	32.25	32.26	32.24	32.24	2508.0
2012-03-28 19:00:00	MSFT	Stock	32.24	32.25	32.24	32.25	2986.0
2012-03-28 07:00:00	NVDA	Stock	0.3798	0.3798	0.379	0.379	40000.0
2012-03-28 08:00:00	NVDA	Stock	0.3798	0.3798	0.375	0.3775	258800.0
2012-03-28 09:00:00	NVDA	Stock	0.3768	0.3818	0.3725	0.379	203664400.0
2012-03-28 10:00:00	NVDA	Stock	0.3793	0.383	0.378	0.3815	167126920.0
2012-03-28 11:00:00	NVDA	Stock	0.3813	0.384	0.3758	0.3771	129998360.0
2012-03-28 12:00:00	NVDA	Stock	0.377	0.3788	0.3765	0.3773	79517560.0
2012-03-28 13:00:00	NVDA	Stock	0.377	0.3783	0.3753	0.376	65897920.0
2012-03-28 14:00:00	NVDA	Stock	0.3758	0.378	0.3743	0.3776	66619040.0
2012-03-28 15:00:00	NVDA	Stock	0.3775	0.3795	0.3768	0.3788	165821080.0
2012-03-28 16:00:00	NVDA	Stock	0.379	0.3813	0.3783	0.3813	2937000.0
2012-03-28 17:00:00	NVDA	Stock	0.379	0.3813	0.379	0.3813	240360.0
2012-03-28 18:00:00	NVDA	Stock	0.3798	0.3798	0.3798	0.3798	17000.0
2012-03-28 19:00:00	NVDA	Stock	0.379	0.379	0.379	0.379	18000.0
2012-03-28 05:00:00	AMZN	Stock	10.325	10.325	10.31	10.325	28000.0
2012-03-28 06:00:00	AMZN	Stock	10.325	10.325	10.325	10.325	8000.0
2012-03-28 07:00:00	AMZN	Stock	10.335	10.335	10.3275	10.3345	180400.0
2012-03-28 08:00:00	AMZN	Stock	10.336	10.3845	10.2535	10.342	1115680.0
2012-03-28 09:00:00	AMZN	Stock	10.333	10.3645	10.227	10.2788	21411260.0
2012-03-28 10:00:00	AMZN	Stock	10.2735	10.3	10.1155	10.1595	26463640.0
2012-03-28 11:00:00	AMZN	Stock	10.1588	10.172	10.0625	10.0894	15437580.0

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

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