PREVIEW / stock_1hour / 2012-03-02

all stock 1-hour files

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

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-02 06:00:00	AAPL	Stock	19.4464	19.4464	19.4464	19.4464	8400.0
2012-03-02 07:00:00	AAPL	Stock	19.4443	19.4443	19.3714	19.4029	1056608.0
2012-03-02 08:00:00	AAPL	Stock	19.4071	19.4464	19.3929	19.4007	2801148.0
2012-03-02 09:00:00	AAPL	Stock	19.4032	19.4718	19.3757	19.4079	67468436.0
2012-03-02 10:00:00	AAPL	Stock	19.4075	19.4564	19.3857	19.4354	65894416.0
2012-03-02 11:00:00	AAPL	Stock	19.4368	19.5286	19.4111	19.4668	86868852.0
2012-03-02 12:00:00	AAPL	Stock	19.4664	19.4768	19.4382	19.4632	42968212.0
2012-03-02 13:00:00	AAPL	Stock	19.4641	19.4714	19.4304	19.4643	37604616.0
2012-03-02 14:00:00	AAPL	Stock	19.4639	19.48	19.4521	19.4682	36543780.0
2012-03-02 15:00:00	AAPL	Stock	19.4664	19.4893	19.4554	19.4661	70995736.0
2012-03-02 16:00:00	AAPL	Stock	19.4707	19.4786	19.4495	19.4714	11203892.0
2012-03-02 17:00:00	AAPL	Stock	19.4714	19.4718	19.4439	19.4568	838180.0
2012-03-02 18:00:00	AAPL	Stock	19.4568	19.4568	19.4464	19.4471	220024.0
2012-03-02 19:00:00	AAPL	Stock	19.4468	19.4625	19.4393	19.4482	979104.0
2012-03-02 06:00:00	MSFT	Stock	32.33	32.33	32.33	32.33	200.0
2012-03-02 07:00:00	MSFT	Stock	32.27	32.27	32.2	32.26	2207.0
2012-03-02 08:00:00	MSFT	Stock	32.25	32.28	32.17	32.28	10920.0
2012-03-02 09:00:00	MSFT	Stock	32.26	32.36	32.06	32.13	5006298.0
2012-03-02 10:00:00	MSFT	Stock	32.12	32.44	32.11	32.38	8266573.0
2012-03-02 11:00:00	MSFT	Stock	32.39	32.4	32.14	32.19	8633965.0
2012-03-02 12:00:00	MSFT	Stock	32.195	32.22	32.09	32.175	5660863.0
2012-03-02 13:00:00	MSFT	Stock	32.17	32.18	32.08	32.1	3958597.0
2012-03-02 14:00:00	MSFT	Stock	32.105	32.15	32.07	32.1	3241256.0
2012-03-02 15:00:00	MSFT	Stock	32.1	32.11	32.0	32.08	9376170.0
2012-03-02 16:00:00	MSFT	Stock	32.08	32.181	32.005	32.02	2754215.0
2012-03-02 17:00:00	MSFT	Stock	32.01	32.01	32.0	32.01	2366.0
2012-03-02 18:00:00	MSFT	Stock	32.02	32.155	32.01	32.01	7444.0
2012-03-02 19:00:00	MSFT	Stock	32.01	32.03	32.01	32.02	3860.0
2012-03-02 08:00:00	NVDA	Stock	0.3815	0.3815	0.3788	0.379	192000.0
2012-03-02 09:00:00	NVDA	Stock	0.38	0.383	0.3795	0.3823	37173360.0
2012-03-02 10:00:00	NVDA	Stock	0.3822	0.387	0.3822	0.3862	77187920.0
2012-03-02 11:00:00	NVDA	Stock	0.3862	0.3873	0.3833	0.3862	90582080.0
2012-03-02 12:00:00	NVDA	Stock	0.386	0.3866	0.3853	0.3862	97428240.0
2012-03-02 13:00:00	NVDA	Stock	0.386	0.3898	0.3858	0.3898	167504800.0
2012-03-02 14:00:00	NVDA	Stock	0.3898	0.39	0.3865	0.3876	88798160.0
2012-03-02 15:00:00	NVDA	Stock	0.3875	0.389	0.3842	0.3842	113818240.0
2012-03-02 16:00:00	NVDA	Stock	0.3845	0.3863	0.3834	0.3845	4852880.0
2012-03-02 18:00:00	NVDA	Stock	0.3842	0.3842	0.3842	0.3842	4000.0
2012-03-02 08:00:00	AMZN	Stock	8.965	8.9655	8.965	8.965	9600.0
2012-03-02 09:00:00	AMZN	Stock	8.963	9.066	8.9505	9.0375	13674080.0
2012-03-02 10:00:00	AMZN	Stock	9.037	9.092	9.003	9.0305	16190380.0
2012-03-02 11:00:00	AMZN	Stock	9.038	9.0585	8.9459	8.987	11422700.0
2012-03-02 12:00:00	AMZN	Stock	8.987	8.9945	8.9515	8.9815	6644540.0
2012-03-02 13:00:00	AMZN	Stock	8.9761	8.997	8.9555	8.9935	7419860.0
2012-03-02 14:00:00	AMZN	Stock	8.9933	9.0	8.975	8.988	4022340.0
2012-03-02 15:00:00	AMZN	Stock	8.987	8.996	8.9525	8.965	10558560.0
2012-03-02 16:00:00	AMZN	Stock	8.965	9.04	8.9505	8.965	2741480.0
2012-03-02 17:00:00	AMZN	Stock	8.965	8.965	8.961	8.961	21020.0
2012-03-02 18:00:00	AMZN	Stock	8.96	8.9615	8.96	8.96	24000.0
2012-03-02 19:00:00	AMZN	Stock	8.972	8.972	8.97	8.97	5960.0

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

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