PREVIEW / stock_1hour / 2014-06-02

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-02.parquet
  size:    1.0 MB
  rows:    48,555
  symbols: 3,557

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
2014-06-02 04:00:00	AAPL	Stock	22.6782	22.7032	22.6718	22.6739	114184.0
2014-06-02 05:00:00	AAPL	Stock	22.6786	22.7143	22.6786	22.7071	77224.0
2014-06-02 06:00:00	AAPL	Stock	22.7136	22.7286	22.6936	22.7	184520.0
2014-06-02 07:00:00	AAPL	Stock	22.6904	22.7036	22.6386	22.6457	453180.0
2014-06-02 08:00:00	AAPL	Stock	22.6429	22.7	22.6161	22.6775	1658468.0
2014-06-02 09:00:00	AAPL	Stock	22.6739	22.6764	22.3842	22.389	52397912.0
2014-06-02 10:00:00	AAPL	Stock	22.3895	22.5125	22.3701	22.4193	42422604.0
2014-06-02 11:00:00	AAPL	Stock	22.4193	22.5711	22.3834	22.5539	32433884.0
2014-06-02 12:00:00	AAPL	Stock	22.5511	22.5704	22.4769	22.5021	17938956.0
2014-06-02 13:00:00	AAPL	Stock	22.5021	22.5279	22.3782	22.4564	34405784.0
2014-06-02 14:00:00	AAPL	Stock	22.4546	22.4854	22.2321	22.2979	62472732.0
2014-06-02 15:00:00	AAPL	Stock	22.3046	22.4639	22.2682	22.4464	48907096.0
2014-06-02 16:00:00	AAPL	Stock	22.4518	22.4571	22.4107	22.4321	4495848.0
2014-06-02 17:00:00	AAPL	Stock	22.4354	22.4529	22.4354	22.4518	211120.0
2014-06-02 18:00:00	AAPL	Stock	22.4518	22.4614	22.4446	22.4575	136108.0
2014-06-02 19:00:00	AAPL	Stock	22.4468	22.4482	22.4425	22.4425	156016.0
2014-06-02 04:00:00	MSFT	Stock	40.94	40.94	40.94	40.94	500.0
2014-06-02 06:00:00	MSFT	Stock	40.94	40.94	40.88	40.9	600.0
2014-06-02 07:00:00	MSFT	Stock	40.9	41.01	40.9	41.0	1400.0
2014-06-02 08:00:00	MSFT	Stock	40.95	41.05	40.95	41.04	8910.0
2014-06-02 09:00:00	MSFT	Stock	41.02	41.05	40.8	40.972	2584203.0
2014-06-02 10:00:00	MSFT	Stock	40.98	41.09	40.85	41.0	3508537.0
2014-06-02 11:00:00	MSFT	Stock	40.99	41.01	40.86	40.87	2146722.0
2014-06-02 12:00:00	MSFT	Stock	40.865	40.9	40.82	40.845	1685330.0
2014-06-02 13:00:00	MSFT	Stock	40.84	40.88	40.75	40.79	1667221.0
2014-06-02 14:00:00	MSFT	Stock	40.79	40.82	40.7	40.73	1215635.0
2014-06-02 15:00:00	MSFT	Stock	40.72	40.83	40.68	40.79	3045994.0
2014-06-02 16:00:00	MSFT	Stock	40.79	40.958	40.785	40.786	2023327.0
2014-06-02 17:00:00	MSFT	Stock	40.79	40.79	40.77	40.77	38796.0
2014-06-02 18:00:00	MSFT	Stock	40.79	40.79	40.78	40.78	9388.0
2014-06-02 19:00:00	MSFT	Stock	40.73	40.78	40.73	40.78	700.0
2014-06-02 08:00:00	NVDA	Stock	0.4738	0.4738	0.4738	0.4738	40000.0
2014-06-02 09:00:00	NVDA	Stock	0.477	0.4795	0.4738	0.4738	15941600.0
2014-06-02 10:00:00	NVDA	Stock	0.474	0.4745	0.4695	0.4725	53048320.0
2014-06-02 11:00:00	NVDA	Stock	0.4728	0.4732	0.4708	0.471	28685640.0
2014-06-02 12:00:00	NVDA	Stock	0.471	0.471	0.4695	0.47	17342480.0
2014-06-02 13:00:00	NVDA	Stock	0.4701	0.4723	0.4698	0.4708	16488720.0
2014-06-02 14:00:00	NVDA	Stock	0.4708	0.4728	0.4705	0.4723	9580920.0
2014-06-02 15:00:00	NVDA	Stock	0.4723	0.4738	0.4713	0.4735	27078400.0
2014-06-02 16:00:00	NVDA	Stock	0.4735	0.4737	0.4734	0.4735	6705080.0
2014-06-02 17:00:00	NVDA	Stock	0.4735	0.4735	0.4735	0.4735	113280.0
2014-06-02 08:00:00	AMZN	Stock	15.648	15.648	15.6	15.6325	44400.0
2014-06-02 09:00:00	AMZN	Stock	15.6215	15.6325	15.4625	15.55	6101700.0
2014-06-02 10:00:00	AMZN	Stock	15.541	15.5475	15.3716	15.3785	7532320.0
2014-06-02 11:00:00	AMZN	Stock	15.378	15.5222	15.3625	15.4955	5648100.0
2014-06-02 12:00:00	AMZN	Stock	15.4993	15.5037	15.38	15.384	2767340.0
2014-06-02 13:00:00	AMZN	Stock	15.3895	15.4345	15.3675	15.387	2956320.0
2014-06-02 14:00:00	AMZN	Stock	15.389	15.403	15.35	15.379	3432520.0
2014-06-02 15:00:00	AMZN	Stock	15.377	15.449	15.364	15.4385	9126200.0
2014-06-02 16:00:00	AMZN	Stock	15.4415	15.6275	15.3925	15.435	2043000.0

> showing 50 of 48,555 rows — these rows as CSV

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