PREVIEW / stock_1hour / 2014-07-03

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-03.parquet
  size:    762 KB
  rows:    32,852
  symbols: 3,537

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-07-03 04:00:00	AAPL	Stock	23.4075	23.4075	23.4075	23.4075	400.0
2014-07-03 05:00:00	AAPL	Stock	23.4	23.4	23.3775	23.4	11600.0
2014-07-03 06:00:00	AAPL	Stock	23.4075	23.445	23.4075	23.42	25832.0
2014-07-03 07:00:00	AAPL	Stock	23.42	23.45	23.38	23.395	111444.0
2014-07-03 08:00:00	AAPL	Stock	23.415	23.4375	23.3625	23.4325	807196.0
2014-07-03 09:00:00	AAPL	Stock	23.435	23.435	23.305	23.3875	16029056.0
2014-07-03 10:00:00	AAPL	Stock	23.3898	23.3975	23.3	23.3775	15694480.0
2014-07-03 11:00:00	AAPL	Stock	23.38	23.4475	23.38	23.4168	14372296.0
2014-07-03 12:00:00	AAPL	Stock	23.42	23.5225	23.4062	23.5225	28139648.0
2014-07-03 13:00:00	AAPL	Stock	23.5225	23.525	23.4148	23.5	9277584.0
2014-07-03 14:00:00	AAPL	Stock	23.495	23.51	23.495	23.5075	141452.0
2014-07-03 15:00:00	AAPL	Stock	23.5075	23.515	23.5025	23.5075	133568.0
2014-07-03 16:00:00	AAPL	Stock	23.505	23.5125	23.5025	23.5125	37692.0
2014-07-03 08:00:00	MSFT	Stock	41.8	41.93	41.8	41.93	525.0
2014-07-03 09:00:00	MSFT	Stock	41.95	42.0	41.56	41.62	3288626.0
2014-07-03 10:00:00	MSFT	Stock	41.61	41.87	41.61	41.705	2669212.0
2014-07-03 11:00:00	MSFT	Stock	41.705	41.79	41.66	41.78	2201566.0
2014-07-03 12:00:00	MSFT	Stock	41.775	41.84	41.69	41.8	4222523.0
2014-07-03 13:00:00	MSFT	Stock	41.79	41.8	41.758	41.8	2471315.0
2014-07-03 14:00:00	MSFT	Stock	41.65	41.65	41.65	41.65	168.0
2014-07-03 15:00:00	MSFT	Stock	41.78	41.8	41.78	41.78	8403.0
2014-07-03 17:00:00	MSFT	Stock	41.805	41.805	41.805	41.805	2634.0
2014-07-03 07:00:00	NVDA	Stock	0.4662	0.4662	0.4662	0.4662	8000.0
2014-07-03 08:00:00	NVDA	Stock	0.4675	0.4675	0.4675	0.4675	40000.0
2014-07-03 09:00:00	NVDA	Stock	0.4628	0.4723	0.4628	0.4708	31737840.0
2014-07-03 10:00:00	NVDA	Stock	0.4708	0.4723	0.4702	0.471	21881480.0
2014-07-03 11:00:00	NVDA	Stock	0.471	0.4715	0.4699	0.4709	22407560.0
2014-07-03 12:00:00	NVDA	Stock	0.4708	0.4725	0.47	0.4713	41887600.0
2014-07-03 13:00:00	NVDA	Stock	0.4718	0.4718	0.4713	0.4718	17308320.0
2014-07-03 14:00:00	NVDA	Stock	0.4718	0.4718	0.4718	0.4718	101800.0
2014-07-03 08:00:00	AMZN	Stock	16.6	16.699	16.6	16.655	82000.0
2014-07-03 09:00:00	AMZN	Stock	16.6835	16.8111	16.654	16.7705	7267920.0
2014-07-03 10:00:00	AMZN	Stock	16.7662	16.85	16.751	16.8265	10822620.0
2014-07-03 11:00:00	AMZN	Stock	16.8275	16.89	16.7895	16.8875	5203920.0
2014-07-03 12:00:00	AMZN	Stock	16.8875	16.915	16.8505	16.878	9556740.0
2014-07-03 13:00:00	AMZN	Stock	16.869	16.8806	16.8214	16.862	2652620.0
2014-07-03 14:00:00	AMZN	Stock	16.88	16.88	16.88	16.88	10000.0
2014-07-03 15:00:00	AMZN	Stock	16.875	16.875	16.875	16.875	2000.0
2014-07-03 16:00:00	AMZN	Stock	16.8675	16.8675	16.8675	16.8675	20000.0
2014-07-03 17:00:00	AMZN	Stock	16.8724	16.8724	16.8724	16.8724	5600.0
2014-07-03 06:00:00	GOOGL	Stock	29.4625	29.4625	29.4625	29.4625	2000.0
2014-07-03 08:00:00	GOOGL	Stock	29.5485	29.55	29.5325	29.55	12600.0
2014-07-03 09:00:00	GOOGL	Stock	29.62	29.646	29.45	29.494	2436840.0
2014-07-03 10:00:00	GOOGL	Stock	29.5105	29.591	29.493	29.5835	2177620.0
2014-07-03 11:00:00	GOOGL	Stock	29.583	29.6795	29.5245	29.6795	2161640.0
2014-07-03 12:00:00	GOOGL	Stock	29.681	29.7125	29.6417	29.709	4492560.0
2014-07-03 13:00:00	GOOGL	Stock	29.7045	29.7045	29.6028	29.6375	2009440.0
2014-07-03 15:00:00	GOOGL	Stock	29.7045	29.7045	29.7045	29.7045	28740.0
2014-07-03 04:00:00	META	Stock	66.5	66.51	66.2	66.24	3010.0
2014-07-03 05:00:00	META	Stock	66.55	66.55	66.55	66.55	230.0

> showing 50 of 32,852 rows — these rows as CSV

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