PREVIEW / stock_1hour / 2011-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-08.parquet
  size:    915 KB
  rows:    43,803
  symbols: 3,492

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-12-08 04:00:00	AAPL	Stock	13.8786	13.8786	13.8411	13.8411	16800.0
2011-12-08 06:00:00	AAPL	Stock	13.8786	13.8786	13.8786	13.8786	14000.0
2011-12-08 07:00:00	AAPL	Stock	13.9054	14.0589	13.9054	14.0311	1339184.0
2011-12-08 08:00:00	AAPL	Stock	14.0214	14.0768	14.0096	14.0229	4731524.0
2011-12-08 09:00:00	AAPL	Stock	14.0186	14.125	13.9289	14.0916	74641812.0
2011-12-08 10:00:00	AAPL	Stock	14.0889	14.1071	14.01	14.0664	68403020.0
2011-12-08 11:00:00	AAPL	Stock	14.0639	14.0675	14.0186	14.0607	40898340.0
2011-12-08 12:00:00	AAPL	Stock	14.0618	14.0689	14.0214	14.0504	22531880.0
2011-12-08 13:00:00	AAPL	Stock	14.0518	14.06	13.9889	14.0464	37469880.0
2011-12-08 14:00:00	AAPL	Stock	14.0459	14.0571	14.0029	14.0118	29298724.0
2011-12-08 15:00:00	AAPL	Stock	14.0111	14.0954	13.9368	13.9546	88174968.0
2011-12-08 16:00:00	AAPL	Stock	13.9521	14.0515	13.9036	13.9054	7610232.0
2011-12-08 17:00:00	AAPL	Stock	13.9393	13.9482	13.9129	13.9454	220416.0
2011-12-08 18:00:00	AAPL	Stock	13.9454	13.9521	13.9304	13.9468	175952.0
2011-12-08 19:00:00	AAPL	Stock	13.9379	13.9496	13.9286	13.9446	211512.0
2011-12-08 07:00:00	MSFT	Stock	25.65	25.66	25.64	25.64	11100.0
2011-12-08 08:00:00	MSFT	Stock	25.66	25.78	25.5	25.52	50304.0
2011-12-08 09:00:00	MSFT	Stock	25.5	25.59	25.395	25.48	4989085.0
2011-12-08 10:00:00	MSFT	Stock	25.48	25.72	25.4	25.62	10952803.0
2011-12-08 11:00:00	MSFT	Stock	25.628	25.67	25.55	25.64	6972828.0
2011-12-08 12:00:00	MSFT	Stock	25.64	25.67	25.59	25.608	5407237.0
2011-12-08 13:00:00	MSFT	Stock	25.6	25.618	25.49	25.58	5418544.0
2011-12-08 14:00:00	MSFT	Stock	25.59	25.598	25.49	25.54	5444347.0
2011-12-08 15:00:00	MSFT	Stock	25.54	25.59	25.37	25.4	17017885.0
2011-12-08 16:00:00	MSFT	Stock	25.4	25.646	25.37	25.4	3089514.0
2011-12-08 17:00:00	MSFT	Stock	25.35	25.38	25.26	25.31	8462.0
2011-12-08 18:00:00	MSFT	Stock	25.36	25.4	25.32	25.38	18222.0
2011-12-08 19:00:00	MSFT	Stock	25.38	25.4	25.31	25.31	6400.0
2011-12-08 08:00:00	NVDA	Stock	0.3835	0.3845	0.3805	0.3805	222000.0
2011-12-08 09:00:00	NVDA	Stock	0.3775	0.3818	0.3728	0.379	55909160.0
2011-12-08 10:00:00	NVDA	Stock	0.379	0.3805	0.3758	0.3771	54284600.0
2011-12-08 11:00:00	NVDA	Stock	0.377	0.378	0.372	0.3735	70093920.0
2011-12-08 12:00:00	NVDA	Stock	0.3735	0.3748	0.3713	0.372	38546920.0
2011-12-08 13:00:00	NVDA	Stock	0.3718	0.3725	0.3688	0.3723	47453240.0
2011-12-08 14:00:00	NVDA	Stock	0.3723	0.3726	0.3688	0.3698	37215600.0
2011-12-08 15:00:00	NVDA	Stock	0.3698	0.374	0.366	0.3672	174420080.0
2011-12-08 16:00:00	NVDA	Stock	0.3678	0.3727	0.3625	0.3628	1549760.0
2011-12-08 17:00:00	NVDA	Stock	0.3638	0.3672	0.3625	0.3672	196000.0
2011-12-08 18:00:00	NVDA	Stock	0.3672	0.3672	0.363	0.363	12000.0
2011-12-08 19:00:00	NVDA	Stock	0.3652	0.3652	0.3635	0.365	64000.0
2011-12-08 04:00:00	AMZN	Stock	9.769	9.769	9.769	9.769	4000.0
2011-12-08 06:00:00	AMZN	Stock	9.769	9.769	9.769	9.769	4000.0
2011-12-08 07:00:00	AMZN	Stock	9.7685	9.769	9.76	9.766	19060.0
2011-12-08 08:00:00	AMZN	Stock	9.7875	9.825	9.7355	9.75	435140.0
2011-12-08 09:00:00	AMZN	Stock	9.735	9.7945	9.641	9.7295	12886240.0
2011-12-08 10:00:00	AMZN	Stock	9.731	9.7555	9.669	9.6815	12446800.0
2011-12-08 11:00:00	AMZN	Stock	9.6805	9.6965	9.597	9.651	11992360.0
2011-12-08 12:00:00	AMZN	Stock	9.651	9.671	9.6235	9.6255	8578400.0
2011-12-08 13:00:00	AMZN	Stock	9.6255	9.6255	9.551	9.5915	9208440.0
2011-12-08 14:00:00	AMZN	Stock	9.5905	9.612	9.5255	9.542	8270480.0

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

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