PREVIEW / stock_1hour / 2014-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-07-30.parquet
  size:    1.0 MB
  rows:    50,056
  symbols: 3,547

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-30 04:00:00	AAPL	Stock	24.6125	24.64	24.6125	24.625	3200.0
2014-07-30 05:00:00	AAPL	Stock	24.605	24.6375	24.605	24.6375	20492.0
2014-07-30 06:00:00	AAPL	Stock	24.6275	24.6375	24.62	24.6375	24024.0
2014-07-30 07:00:00	AAPL	Stock	24.6375	24.655	24.615	24.645	77844.0
2014-07-30 08:00:00	AAPL	Stock	24.6475	24.67	24.575	24.64	663696.0
2014-07-30 09:00:00	AAPL	Stock	24.6475	24.675	24.5425	24.579	20123652.0
2014-07-30 10:00:00	AAPL	Stock	24.58	24.6475	24.53	24.59	18257096.0
2014-07-30 11:00:00	AAPL	Stock	24.59	24.59	24.445	24.445	20550676.0
2014-07-30 12:00:00	AAPL	Stock	24.4462	24.5625	24.4175	24.5325	14574852.0
2014-07-30 13:00:00	AAPL	Stock	24.535	24.57	24.49	24.558	8637648.0
2014-07-30 14:00:00	AAPL	Stock	24.5575	24.65	24.5275	24.57	18445380.0
2014-07-30 15:00:00	AAPL	Stock	24.5725	24.62	24.5025	24.5325	19117440.0
2014-07-30 16:00:00	AAPL	Stock	24.5325	24.5852	24.5125	24.535	4148256.0
2014-07-30 17:00:00	AAPL	Stock	24.5375	24.5672	24.5225	24.5425	71712.0
2014-07-30 18:00:00	AAPL	Stock	24.5425	24.5425	24.5275	24.5275	50980.0
2014-07-30 19:00:00	AAPL	Stock	24.535	24.54	24.53	24.535	28224.0
2014-07-30 04:00:00	MSFT	Stock	43.9	43.9	43.9	43.9	400.0
2014-07-30 08:00:00	MSFT	Stock	43.87	44.15	43.87	44.07	31998.0
2014-07-30 09:00:00	MSFT	Stock	44.07	44.1	43.7	43.75	2389435.0
2014-07-30 10:00:00	MSFT	Stock	43.755	43.785	43.29	43.43	6517455.0
2014-07-30 11:00:00	MSFT	Stock	43.43	43.51	43.35	43.45	3138434.0
2014-07-30 12:00:00	MSFT	Stock	43.46	43.55	43.42	43.53	2026331.0
2014-07-30 13:00:00	MSFT	Stock	43.53	43.54	43.37	43.42	2797084.0
2014-07-30 14:00:00	MSFT	Stock	43.42	43.48	43.33	43.4	6079378.0
2014-07-30 15:00:00	MSFT	Stock	43.393	43.595	43.33	43.58	5374455.0
2014-07-30 16:00:00	MSFT	Stock	43.58	43.59	43.48	43.55	2501397.0
2014-07-30 17:00:00	MSFT	Stock	43.475	43.6	43.475	43.6	3741.0
2014-07-30 19:00:00	MSFT	Stock	43.5	43.55	43.47	43.47	3931.0
2014-07-30 08:00:00	NVDA	Stock	0.4445	0.4498	0.4445	0.4498	736000.0
2014-07-30 09:00:00	NVDA	Stock	0.4445	0.4502	0.4445	0.448	21196600.0
2014-07-30 10:00:00	NVDA	Stock	0.448	0.451	0.4461	0.4488	48367000.0
2014-07-30 11:00:00	NVDA	Stock	0.4488	0.4498	0.4474	0.4475	39633120.0
2014-07-30 12:00:00	NVDA	Stock	0.4476	0.45	0.4475	0.4497	13775000.0
2014-07-30 13:00:00	NVDA	Stock	0.4495	0.4519	0.4484	0.4511	17976160.0
2014-07-30 14:00:00	NVDA	Stock	0.451	0.4532	0.4505	0.452	35154400.0
2014-07-30 15:00:00	NVDA	Stock	0.452	0.4528	0.4498	0.452	51407360.0
2014-07-30 16:00:00	NVDA	Stock	0.4518	0.452	0.4484	0.4519	12375280.0
2014-07-30 17:00:00	NVDA	Stock	0.4518	0.4518	0.4518	0.4518	348480.0
2014-07-30 18:00:00	NVDA	Stock	0.452	0.452	0.452	0.452	4000.0
2014-07-30 19:00:00	NVDA	Stock	0.452	0.452	0.452	0.452	16000.0
2014-07-30 06:00:00	AMZN	Stock	16.05	16.05	16.05	16.05	2100.0
2014-07-30 07:00:00	AMZN	Stock	16.025	16.0325	16.025	16.03	35020.0
2014-07-30 08:00:00	AMZN	Stock	16.0325	16.0825	16.0325	16.0745	174760.0
2014-07-30 09:00:00	AMZN	Stock	16.07	16.11	15.977	16.0278	12739560.0
2014-07-30 10:00:00	AMZN	Stock	16.023	16.052	15.925	15.9915	13443420.0
2014-07-30 11:00:00	AMZN	Stock	15.979	16.0868	15.9575	15.9965	8603980.0
2014-07-30 12:00:00	AMZN	Stock	15.993	16.0635	15.9725	16.034	5465140.0
2014-07-30 13:00:00	AMZN	Stock	16.034	16.0845	16.011	16.059	3774680.0
2014-07-30 14:00:00	AMZN	Stock	16.051	16.127	16.0247	16.0785	8945400.0
2014-07-30 15:00:00	AMZN	Stock	16.0845	16.1365	16.0525	16.1255	10682160.0

> showing 50 of 50,056 rows — these rows as CSV

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